Enron email

Algorithmic Indexing

23 Mar 2001, 14:30 UTC

RE: What happened: tempdb xact log

From
Matt Pena matt.pena@enron.com
To
Daren J Farmer
Cc
Chris Schomer, jaikishore.bharathi@enron.com, Bob Ward, william.mallary@enron.com, Brian Ripley
Bcc
Chris Schomer, jaikishore.bharathi@enron.com, Bob Ward, william.mallary@enron.com, Brian Ripley
Date
Fri, 23 Mar 2001 06:30:00 -0800 (PST)
Darren,
Do you know if you were running pulling up the Path Manager for a date range 
around 10:51?; How do you normally pull up the Path Manager?; Please let me 
know as we're attempting to find out what caused this problem and if we 
should restrict access on the date range functionality.; If you were only 
pulling it for a day, that would be okay.
;
Thanks
Quoted or forwarded from earlier messages
-----Original Message-----
From: Mallary, William 
Sent: Friday, March 23, 2001 2:24 PM
To: Ripley, Brian
Cc: Schomer, Chris; Pena, Matt; Bharathi, Jaikishore; Ward, Bob
Subject: What happened: tempdb xact log


Brian, 
;
At 11:20am this morning, a stored procedure (source_dest_list_range_sp, Line 
#172) being run by Daren Farmer caused the tempdb transaction log on 
unifygasp to fill up.; This procedure is run routinely by many other users on 
a daily basis without incident.; At the time of the failure, this stored 
procedure had been running since 10:51am, or roughly 30 minutes.; I was 
notified via automatic page at 11:24am; the page indicating that there was 
200MB free.; I immediately checked tempdb, which was by full by this time.; 
Three attempts to clear the transaction log prior to 11:30am finally resulted 
in;a cleared transaction log.
;
Kishore noiced shortly thereafter that there was a problem in the way that 
Sybase was accounting for its free space, a condition which may have been 
crucial to the failure since nearly 5GB of space was apparently unavailable 
to the transaction log.; A reboot of unifyprod2 at 1:40pm cleared this 
condition.

Bill Mallary
*; william.mallary@enron.com <mailto:william.mallary@enron.com>
( ;713.345.3485 (office)
( ;281.960.7181 (cell)

;