|
|
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
|
