Hi David, there exists a systemview ALLOCATORSTATISTIC which shows the allocation of the heap. Allocators are using a base allocator to extend their own chunks but at the at the end the systemheap is used which is controlled by your os and ulimit settings for the user under which the database is running.
Please check your system log if your os is running out of memory and check your ulimits. Snapshots of ALLOCATORSTATISTIC may give hints of unusual memory consumption of specific allocators. kind regards Uwe >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Sunday, August 22, 2004 6:35 PM >To: Hahn, Uwe >Cc: [EMAIL PROTECTED] >Subject: RE: Another crash! Please help!! > > > >Thanks for the info, Uwe....any advice on how to fix it?!! >It's SAP's heap >memory allocation that's failing right? Can we increase it? Will that >help? > >cheers, > >David > > > >|---------+----------------------------> >| | "Hahn, Uwe" | >| | <[EMAIL PROTECTED]| >| | > | >| | | >| | 08/18/2004 02:25 | >| | AM | >| | | >|---------+----------------------------> > >>-------------------------------------------------------------- >----------------------------------------------------------| > | > | > | To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, >Sixto Lambis <[EMAIL PROTECTED]> | > | cc: [EMAIL PROTECTED] > | > | Subject: RE: Another crash! Please help!! > | > >>-------------------------------------------------------------- >----------------------------------------------------------| > > > > >>>2004-08-17 10:52:21 0x4D8 ERR 0 SAPDBErr Assertion of state >>>Log_Savepoint::WriteSavepointEntryToArchiveLog: space init > >This means that the allocation of heap memory failed. >Kind regards, >Uwe > >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >>Sent: Sunday, August 22, 2004 1:00 AM >>To: Sixto Lambis >>Cc: [EMAIL PROTECTED] >>Subject: RE: Another crash! Please help!! >> >> >> >>Unfortunately we cannot go past the 7.4 mark, due to licensing issues. >> >> >> >>|---------+----------------------------> >>| | "Sixto Lambis" | >>| | <[EMAIL PROTECTED]| >>| | ail.com> | >>| | | >>| | 08/17/2004 05:30 | >>| | PM | >>| | | >>|---------+----------------------------> >> >>>-------------------------------------------------------------- >>----------------------------------------------------------| >> | >> | >> | To: [EMAIL PROTECTED], [EMAIL PROTECTED] >> | >> | cc: >> | >> | Subject: RE: Another crash! Please help!! >> | >> >>>-------------------------------------------------------------- >>----------------------------------------------------------| >> >> >> >> >>Hi, >>I suggest that update MAX DB to next available build. >> >>Best Regards, >>Sixto >> >> >>>From: [EMAIL PROTECTED] >>>To: [EMAIL PROTECTED] >>>Subject: Another crash! Please help!! >>>Date: Sat, 21 Aug 2004 17:14:39 -0400 >>> >>>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/[EMAIL PROTECTED] >>> >> >>_________________________________________________________________ >>Help STOP SPAM with the new MSN 8 and get 2 months FREE* >>http://join.msn.com/?page=features/junkmail >> >> >>-- >>MaxDB Discussion Mailing List >>For list archives: http://lists.mysql.com/maxdb >>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> >> >> >> >>-- >>MaxDB Discussion Mailing List >>For list archives: http://lists.mysql.com/maxdb >>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
