PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: holt at roguewave dot com
Subject: Msg Handler output example...
Date: Feb 13 1998 9:40PM

Hi...

I just posted a bit of code having to do w/error trapping.  Just had one
happen, and here's the kind of output I get (via email).  Thought a real
example might be useful...

Tim Holt



ONYX Sybase Message
message = 1205
state = 2
severity = 13
text = Your server command (process id 23) was deadlocked with another
process and has been chosen as deadlock victim. Re-run your command
server = LIGHT
procedure = eRWWebSalesIncident
line = 53
Last SQL was...
EXEC eRWWebSalesIncident @SiteId = 1, @TrackId = 119, @IndividualId =
191165, @Item = "/sps/customer.cgi"

----------------------------------------------------------------
Environment Vars Dump
----------------------------------------------------------------
  ENV{SERVER_SOFTWARE} = Netscape-Enterprise/2.01
  ENV{GATEWAY_INTERFACE} = CGI/1.1
  ENV{REMOTE_ADDR} = 143.182.246.27
  ENV{SYBASE} = /opt/sybase11.0.2
  ENV{SERVER_PROTOCOL} = HTTP/1.0
  ENV{REQUEST_METHOD} = POST
  ENV{REMOTE_HOST} = arthur.ch.intel.com
  ENV{SERVER_URL} = http://www.roguewave.com
  ENV{HTTP_REFERER} = http://www.roguewave.com/sps/customer.cgi
  ENV{HTTP_USER_AGENT} = Mozilla/3.04 (WinNT; U)
  ENV{DSQUERY} = SYBASE1102
  ENV{PATH} =
.:/opt/users/www/bin:/usr/rwlocal/bin:/usr/etc:/usr/sbin/:/usr/openwin/b
in:/usr/bin/X11:/usr/bin:/usr/ucb:/usr/local/bin:/usr/local/bin/mh:/usr/
lib/X11/config:/usr/ccs/bin:/sybase/bin:/sybase/lib:/usr/ucblib
  ENV{TZ} = US/Pacific
  ENV{HTTP_ACCEPT} = image/gif, image/x-xbitmap, image/jpeg,
image/pjpeg, */*
  ENV{HTTP_CONNECTION} = keep-alive
  ENV{LD_LIBRARY_PATH} = /opt/sybase11.0.2/lib:
  ENV{HTTPS} = OFF
  ENV{SCRIPT_NAME} = /sps/customer.cgi
  ENV{SERVER_NAME} = www.roguewave.com
  ENV{SERVER_PORT} = 80
  ENV{CONTENT_TYPE} = application/x-www-form-urlencoded
  ENV{CONTENT_LENGTH} = 438
  ENV{HTTP_HOST} = www.roguewave.com
  ENV{HTTP_FORWARDED} = by http://arthur.ch.intel.com:1022
(Netscape-Proxy/2.52)

----------------------------------------------------------------
Call Stack Dump
----------------------------------------------------------------
1: Sql	/opt/www/cgi-bin/Sql.pm	195	Sql::EZ_message_handler	1	0
2: Sql	/opt/www/cgi-bin/Sql.pm	242	Sql::EZSQL_put	1	0
3: main	Customer2.pl	2218	Sql::EZSQL_getsproc	1	0
4: main	Customer2.pl	361	main::createSalesIncident	1	0
5: main	Customer2.pl	112	main::_Customer_login_SAVECID_handler	1	0
6: main	/opt/www/sps-bin/customer.cgi	48	main::Customer_login	1	0