A Day in the Life
It's Friday. It's almost time for me to go home. There wasn't going to be an entry today but then...
Ticket# 20070112-ACC22:
YOU GUYS SUCK! OUR SYSTEM IS DOWN!!! PRIO-1! PRIO-1!!! FIX IT NOW!!!
Nothing's being written. All transactions are failing. But they can read everything...
x-posted to da brog.
SQLError Statement 0 2007-01-12 04:16:51 UPDATE dbo.APP_REQUEST
SET
STATUS = ?,
ACTL_START_DT = ?,
LAST_UPD_BY = ?,
LAST_UPD = ?
WHERE ROW_ID = ? AND STATUS = 'QUEUED'
GenericLog GenericError 1 2007-01-12 04:16:51 [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'ixsblpr' is full. Back up the transaction log for the database to free up some log space.
GenericLog GenericError 1 2007-01-12 04:16:51 Message: Error: An ODBC error occurred,
Additional Message: pfNativeError: 9002; szSQLState: 37000;
szErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'ixsblpr' is full. Back up the transaction log for the database to free up some log space.
Over and over and over. A few hundred megs of our server logs filled with the same message.
They have no more space on their database hard drives (or at least in the transaction logs), but we're the suck-meisters.
A Prio-1 has been resolved and closed inside 15 minutes.
Root Cause 17:Fuckwit.
