logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Another crash! Please help!!: msg#00142

Subject: Another crash! Please help!!
Hi,

We have just experienced another crash.  This time it doesn't seem
connected with any external machine connecting, and this time we have some
different messages:

2004-08-17 10:52:21      0x4D8 ERR     0 SAPDBErr Assertion of state
Log_Savepoint::WriteSavepointEntryToArchiveLog: space init failed failed!
2004-08-17 10:52:21      0x4D8 ERR 18196 DBCRASH  vabort:Emergency
Shutdown, Log_Savepoint.cpp: 588
2004-08-17 10:52:21      0x4D8 ERR 19999 BTRACE   Error loading
'imagehlp.dll' or some required functions:126
2004-08-17 10:52:21      0x4D8     19624 EXCEPT   Kernel aborts

(last section of knldiag below).

Please, does anyone have any ideas why this happened?  We are using log
overwriting, so I am surprised by any space issues with the log.  The
database had plenty of space before it crashed too.

Appreciate any input!!

cheers,

David


Abbreviate knldiag:
2004-08-17 09:47:40      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 129
2004-08-17 09:48:25      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:3228)
2004-08-17 09:48:25      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 09:53:27      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:3568)
2004-08-17 09:53:27      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 09:55:40      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 09:55:40      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 09:55:40      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 136 IO: 42
2004-08-17 09:55:40      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 09:55:40      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 09:55:40      0x4D8     53070 SAVPOINT B20PREPARE_SVP: 130
2004-08-17 09:55:40      0x4D8         8 Pager    SVP(3) Start Write Data
2004-08-17 09:55:41      0x4D8         9 Pager    SVP(3) Stop Data IO,
Pages: 1 IO: 1
2004-08-17 09:55:41      0x4D8        10 Pager    SVP(3) Start Write
Converter
2004-08-17 09:55:41      0x4D8        11 Pager    SVP(3) Stop Converter IO,
Pages: 12 IO: 12
2004-08-17 09:55:41      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 130
2004-08-17 09:55:43      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'constitution-1.stl.ap.lexmark.com', PID:0)
2004-08-17 09:55:43      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 09:58:28      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:2720)
2004-08-17 09:58:28      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:03:29      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:3508)
2004-08-17 10:03:29      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:04:10      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 10:04:10      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 10:04:10      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 140 IO: 39
2004-08-17 10:04:10      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 10:04:10      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 10:04:10      0x4D8     53070 SAVPOINT B20PREPARE_SVP: 131
2004-08-17 10:04:10      0x4D8         8 Pager    SVP(3) Start Write Data
2004-08-17 10:04:11      0x4D8         9 Pager    SVP(3) Stop Data IO,
Pages: 1 IO: 1
2004-08-17 10:04:11      0x4D8        10 Pager    SVP(3) Start Write
Converter
2004-08-17 10:04:11      0x4D8        11 Pager    SVP(3) Stop Converter IO,
Pages: 13 IO: 13
2004-08-17 10:04:11      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 131
2004-08-17 10:06:17      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'www3.ap.lexmark.com', PID:0)
2004-08-17 10:06:28      0x2BC     19677 CONNECT  Client has released
connection, T19
2004-08-17 10:06:28      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:08:30      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:2656)
2004-08-17 10:08:30      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:12:10      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 10:12:10      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 10:12:10      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 132 IO: 36
2004-08-17 10:12:10      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 10:12:10      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 10:12:10      0x4D8     53070 SAVPOINT B20PREPARE_SVP: 132
2004-08-17 10:12:10      0x4D8         8 Pager    SVP(3) Start Write Data
2004-08-17 10:12:11      0x4D8         9 Pager    SVP(3) Stop Data IO,
Pages: 1 IO: 1
2004-08-17 10:12:11      0x4D8        10 Pager    SVP(3) Start Write
Converter
2004-08-17 10:12:11      0x4D8        11 Pager    SVP(3) Stop Converter IO,
Pages: 12 IO: 12
2004-08-17 10:12:11      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 132
2004-08-17 10:13:31      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:3440)
2004-08-17 10:13:31      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:18:32      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:3268)
2004-08-17 10:18:33      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:20:12      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 10:20:12      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 10:20:12      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 138 IO: 38
2004-08-17 10:20:12      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 10:20:12      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 10:20:12      0x4D8     53070 SAVPOINT B20PREPARE_SVP: 133
2004-08-17 10:20:12      0x4D8         8 Pager    SVP(3) Start Write Data
2004-08-17 10:20:12      0x4D8         9 Pager    SVP(3) Stop Data IO,
Pages: 1 IO: 1
2004-08-17 10:20:12      0x4D8        10 Pager    SVP(3) Start Write
Converter
2004-08-17 10:20:12      0x4D8        11 Pager    SVP(3) Stop Converter IO,
Pages: 12 IO: 12
2004-08-17 10:20:12      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 133
2004-08-17 10:23:34      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:2996)
2004-08-17 10:23:34      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:28:36      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:1372)
2004-08-17 10:28:37      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:28:47      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 10:28:47      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 10:28:47      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 141 IO: 38
2004-08-17 10:28:47      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 10:28:47      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 10:28:47      0x4D8     53070 SAVPOINT B20PREPARE_SVP: 134
2004-08-17 10:28:47      0x4D8         8 Pager    SVP(3) Start Write Data
2004-08-17 10:28:47      0x4D8         9 Pager    SVP(3) Stop Data IO,
Pages: 1 IO: 1
2004-08-17 10:28:47      0x4D8        10 Pager    SVP(3) Start Write
Converter
2004-08-17 10:28:47      0x4D8        11 Pager    SVP(3) Stop Converter IO,
Pages: 13 IO: 13
2004-08-17 10:28:47      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 134
2004-08-17 10:33:38      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:2304)
2004-08-17 10:33:38      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:36:50      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 10:36:50      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 10:36:50      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 136 IO: 37
2004-08-17 10:36:50      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 10:36:50      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 10:36:50      0x4D8     53070 SAVPOINT B20PREPARE_SVP: 135
2004-08-17 10:36:50      0x4D8         8 Pager    SVP(3) Start Write Data
2004-08-17 10:36:51      0x4D8         9 Pager    SVP(3) Stop Data IO,
Pages: 1 IO: 1
2004-08-17 10:36:51      0x4D8        10 Pager    SVP(3) Start Write
Converter
2004-08-17 10:36:51      0x4D8        11 Pager    SVP(3) Stop Converter IO,
Pages: 12 IO: 12
2004-08-17 10:36:51      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 135
2004-08-17 10:38:43      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:2008)
2004-08-17 10:38:43      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:43:46      0x2BC     19633 CONNECT  Connect req. (T19,
Node:'', PID:2580)
2004-08-17 10:43:46      0x2BC     19651 CONNECT  Connection released, T19
2004-08-17 10:45:20      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 10:45:20      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 10:45:20      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 134 IO: 36
2004-08-17 10:45:20      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 10:45:20      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 10:45:20      0x4D8     53070 SAVPOINT B20PREPARE_SVP: 136
2004-08-17 10:45:20      0x4D8         8 Pager    SVP(3) Start Write Data
2004-08-17 10:45:20      0x4D8         9 Pager    SVP(3) Stop Data IO,
Pages: 1 IO: 1
2004-08-17 10:45:20      0x4D8        10 Pager    SVP(3) Start Write
Converter
2004-08-17 10:45:20      0x4D8        11 Pager    SVP(3) Stop Converter IO,
Pages: 12 IO: 12
2004-08-17 10:45:21      0x4D8     53071 SAVPOINT B20SVP_COMPLETED: 136
2004-08-17 10:52:20      0x4DC        41 Log      Savepoint requested by T1
reason 'Time' (started).
2004-08-17 10:52:21      0x4D8         4 Pager    SVP(1) Start Write Data
2004-08-17 10:52:21      0x4D8         5 Pager    SVP(1) Stop Data IO,
Pages: 150 IO: 39
2004-08-17 10:52:21      0x4D8         6 Pager    SVP(2) Wait for last
split, TaskId: 85
2004-08-17 10:52:21      0x4D8         7 Pager    SVP(2) Stop Wait for last
split, Pages: 0 IO: 0
2004-08-17 10:52:21      0x4D8 ERR     0 SAPDBErr Assertion of state
Log_Savepoint::WriteSavepointEntryToArchiveLog: space init failed failed!
2004-08-17 10:52:21      0x4D8 ERR 18196 DBCRASH  vabort:Emergency
Shutdown, Log_Savepoint.cpp: 588
2004-08-17 10:52:21      0x4D8 ERR 19999 BTRACE   Error loading
'imagehlp.dll' or some required functions:126
2004-08-17 10:52:21      0x4D8     19624 EXCEPT   Kernel aborts
2004-08-17 10:52:21      0x4D8     19684 TASKING  Tracewriter termination
timeout: 1200 sec
2004-08-17 10:52:21      0x49C     19617 VOLUMEIO Single I/O attach,
'knltrace', UKT:1
2004-08-17 10:52:26      0x49C     19619 TASKING  Releasing tracewriter
2004-08-17 10:52:26      0x4D8     19890 DIAGHIST Backup of diagnostic
files will be forced at next restart
2004-08-17 10:52:26      0x4D8     19600 VERSION  'Kernel    7.4.3    Build
017-123-039-277'
2004-08-17 10:52:26      0x4D8     19654 DBSTATE  SERVERDB 'LDDSERV' has
stopped
-------------------------------------------- current write position
----------------



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx




<Prev in Thread] Current Thread [Next in Thread>