Message-ID: <9937807.1075854191519.JavaMail.evans@thyme> Date: Wed, 28 Mar 2001 06:52:00 -0800 (PST) From: matt.pena@enron.com To: daren.farmer@enron.com Subject: RE: What happened: tempdb xact log Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-From: Matt Pena X-To: Daren J Farmer X-cc: X-bcc: X-Folder: \Darren_Farmer_Jun2001\Notes Folders\All documents X-Origin: Farmer-D X-FileName: dfarmer.nsf This information can be obtained in our reporting environment. Our reporting environment is refreshed daily. Please use this going foward for this type of analysis. With the increased activity in Unify, we're having all users that need to run reports in previous months perform this operation in reporting. Donna Grief or Richard Pinion can show you where this environment is located. If you have questions, please ask. thanks -----Original Message----- From: Farmer, Daren Sent: Wednesday, March 28, 2001 2:11 PM To: Pena, Matt Subject: RE: What happened: tempdb xact log Matt, Each month, prior to bidweek, I pull up a monthly range in Path Manager to get a feel of how many of our swing customers operated in a prior month (or a month in a prior year). I have never had problem with this before, and I have done this task every month since Unify was put into production. When the problem occurred this month, I was attempting to view Apr 1-30, 2000 on Houston Pipe Line, with HPL as the shipper. This information is very important for my bidweek preparation. So, I need to continue perfomorming this operation each month. If needed, I can wait until 5 pm top view the range. D From: Matt Pena/ENRON@enronXgate on 03/23/2001 02:30 PM To: Daren J Farmer/HOU/ECT@ECT cc: Chris Schomer/ENRON@enronXgate, Jaikishore Bharathi/ENRON@enronXgate, Bob Ward/ENRON@enronXgate, William Mallary/ENRON@enronXgate, Brian Ripley/ENRON@enronXgate Subject: RE: What happened: tempdb xact log 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 -----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 ( 713.345.3485 (office) ( 281.960.7181 (cell)