-24994,ERR_RTE: Runtime environment error 4,connection broken server state

[Former Member]

Hi gurus

I am facing this problem when trying to start the Database:

Starting Database Instance...

OK

Opening Database...

ERR

-24994,ERR_RTE: Runtime environment error

4,connection broken server state 4

I have check the knldiag.err:

2008-08-18 08:52:05 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 08:52:05 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 08:52:05 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 08:52:05 _ Stopping GMT 2008-08-18 06:52:05 7.6.00 Build 035-123-139-084

2008-08-18 08:53:40 --- Starting GMT 2008-08-18 06:53:40 7.6.00 Build 035-123-139-084

2008-08-18 08:54:16 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 08:54:16 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 08:54:16 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 08:54:16 _ Stopping GMT 2008-08-18 06:54:16 7.6.00 Build 035-123-139-084

2008-08-18 09:05:27 --- Starting GMT 2008-08-18 07:05:27 7.6.00 Build 035-123-139-084

2008-08-18 09:06:09 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 09:06:09 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 09:06:09 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 09:06:12 _ Stopping GMT 2008-08-18 07:06:12 7.6.00 Build 035-123-139-084

2008-08-18 09:19:38 --- Starting GMT 2008-08-18 07:19:38 7.6.00 Build 035-123-139-084

2008-08-18 09:20:21 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 09:20:21 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 09:20:21 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 09:20:21 _ Stopping GMT 2008-08-18 07:20:21 7.6.00 Build 035-123-139-084

2008-08-18 09:28:57 --- Starting GMT 2008-08-18 07:28:57 7.6.00 Build 035-123-139-084

2008-08-18 09:29:41 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 09:29:41 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 09:29:41 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 09:29:41 _ Stopping GMT 2008-08-18 07:29:41 7.6.00 Build 035-123-139-084

2008-08-18 09:30:58 --- Starting GMT 2008-08-18 07:30:58 7.6.00 Build 035-123-139-084

2008-08-18 09:31:34 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 09:31:34 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 09:31:34 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 09:31:34 _ Stopping GMT 2008-08-18 07:31:34 7.6.00 Build 035-123-139-084

2008-08-18 09:48:40 --- Starting GMT 2008-08-18 07:48:40 7.6.00 Build 035-123-139-084

2008-08-18 09:49:21 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 09:49:21 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 09:49:21 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 09:49:21 _ Stopping GMT 2008-08-18 07:49:21 7.6.00 Build 035-123-139-084

2008-08-18 09:59:24 --- Starting GMT 2008-08-18 07:59:24 7.6.00 Build 035-123-139-084

2008-08-18 10:00:14 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 10:00:14 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 10:00:14 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 10:00:16 _ Stopping GMT 2008-08-18 08:00:16 7.6.00 Build 035-123-139-084

2008-08-18 10:40:18 --- Starting GMT 2008-08-18 08:40:18 7.6.00 Build 035-123-139-084

2008-08-18 10:41:12 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 10:41:12 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 10:41:12 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 10:41:13 _ Stopping GMT 2008-08-18 08:41:13 7.6.00 Build 035-123-139-084

2008-08-18 10:47:02 --- Starting GMT 2008-08-18 08:47:02 7.6.00 Build 035-123-139-084

2008-08-18 10:47:37 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 10:47:37 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 10:47:37 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

more rtedump:

ERR 11105 CONSOLE WARNING: kernel not running 'SID'

ERR 11105 CONSOLE WARNING: examining OLD DATA

SERVERDB: SID

ERR 11105 CONSOLE WARNING: kernel not running 'SID'

ERR 11105 CONSOLE WARNING: examining OLD DATA

The database state is OFFLINE

Kernel Version 'Kernel 7.6.00 Build 035-123-139-084'

RTE Version 'X64/LIX86 7.6.00 Build 035-123-139-084'

Its runnong on Suse Linux Enterprise Server 10,64bit,Maxdb 7.6 ,ERP6

Could this be the kernel which has crashed?

Any ideas are welcome

[markus_doehr2]

Please post the knldiag also - knldiag.err contains only the error, not the cause

Markus

[Former Member]

2008-08-18 11:23:00 6507 11570 startup complete

2008-08-18 11:23:00 6525 31 SrvTasks Permanently reserved 13 servertasks for 'Backup / Restore'.

2008-08-18 11:23:00 6525 31 SrvTasks Permanently reserved 2 servertasks for 'Backup / Restore'.

2008-08-18 11:23:00 6525 31 SrvTasks Permanently reserved 1 servertasks for 'Savepoint'.

2008-08-18 11:23:00 6508 11561 COMMUNIC Connecting T68 local 5206

2008-08-18 11:23:00 6524 11561 COMMUNIC Connected T68 local 5206

2008-08-18 11:23:00 6508 11561 COMMUNIC Connecting T100 local 6533

2008-08-18 11:23:00 6526 12929 TASKING Task T100 started

2008-08-18 11:23:00 6526 11007 COMMUNIC wait for connection T100

2008-08-18 11:23:00 6526 11561 COMMUNIC Connected T100 local 6533

2008-08-18 11:23:00 6535 12821 TASKING Thread 6535 starting

2008-08-18 11:23:00 6535 11597 IO Open '/sapdb/SID/data/DISKD0001' successfull, fd: 10

2008-08-18 11:23:00 6535 11565 startup DEVi started

2008-08-18 11:23:00 6536 12821 TASKING Thread 6536 starting

2008-08-18 11:23:00 6536 11597 IO Open '/sapdb/SID/data/DISKD0001' successfull, fd: 18

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0001' devno 1 T100 succeeded

2008-08-18 11:23:00 6536 11565 startup DEVi started

2008-08-18 11:23:00 6537 12821 TASKING Thread 6537 starting

2008-08-18 11:23:00 6537 11597 IO Open '/sapdb/SID/data/DISKD0002' successfull, fd: 20

2008-08-18 11:23:00 6537 11565 startup DEVi started

2008-08-18 11:23:00 6538 12821 TASKING Thread 6538 starting

2008-08-18 11:23:00 6538 11597 IO Open '/sapdb/SID/data/DISKD0002' successfull, fd: 21

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0002' devno 2 T100 succeeded

2008-08-18 11:23:00 6538 11565 startup DEVi started

2008-08-18 11:23:00 6539 12821 TASKING Thread 6539 starting

2008-08-18 11:23:00 6539 11597 IO Open '/sapdb/SID/data/DISKD0003' successfull, fd: 23

2008-08-18 11:23:00 6539 11565 startup DEVi started

2008-08-18 11:23:00 6540 12821 TASKING Thread 6540 starting

2008-08-18 11:23:00 6540 11597 IO Open '/sapdb/SID/data/DISKD0003' successfull, fd: 24

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0003' devno 3 T100 succeeded

2008-08-18 11:23:00 6540 11565 startup DEVi started

2008-08-18 11:23:00 6541 12821 TASKING Thread 6541 starting

2008-08-18 11:23:00 6541 11597 IO Open '/sapdb/SID/data/DISKD0004' successfull, fd: 26

2008-08-18 11:23:00 6541 11565 startup DEVi started

2008-08-18 11:23:00 6542 12821 TASKING Thread 6542 starting

2008-08-18 11:23:00 6542 11597 IO Open '/sapdb/SID/data/DISKD0004' successfull, fd: 27

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0004' devno 4 T100 succeeded

2008-08-18 11:23:00 6542 11565 startup DEVi started

2008-08-18 11:23:00 6543 12821 TASKING Thread 6543 starting

2008-08-18 11:23:00 6543 11597 IO Open '/sapdb/SID/data/DISKD0005' successfull, fd: 29

2008-08-18 11:23:00 6543 11565 startup DEVi started

2008-08-18 11:23:00 6544 12821 TASKING Thread 6544 starting

2008-08-18 11:23:00 6544 11597 IO Open '/sapdb/SID/data/DISKD0005' successfull, fd: 30

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0005' devno 5 T100 succeeded

2008-08-18 11:23:00 6544 11565 startup DEVi started

2008-08-18 11:23:00 6545 12821 TASKING Thread 6545 starting

2008-08-18 11:23:00 6545 11597 IO Open '/sapdb/SID/data/DISKD0006' successfull, fd: 32

2008-08-18 11:23:00 6545 11565 startup DEVi started

2008-08-18 11:23:00 6546 12821 TASKING Thread 6546 starting

2008-08-18 11:23:00 6546 11597 IO Open '/sapdb/SID/data/DISKD0006' successfull, fd: 33

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0006' devno 6 T100 succeeded

2008-08-18 11:23:00 6546 11565 startup DEVi started

2008-08-18 11:23:00 6547 12821 TASKING Thread 6547 starting

2008-08-18 11:23:00 6547 11597 IO Open '/sapdb/SID/data/DISKD0007' successfull, fd: 35

2008-08-18 11:23:00 6547 11565 startup DEVi started

2008-08-18 11:23:00 6548 12821 TASKING Thread 6548 starting

2008-08-18 11:23:00 6548 11597 IO Open '/sapdb/SID/data/DISKD0007' successfull, fd: 36

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0007' devno 7 T100 succeeded

2008-08-18 11:23:00 6548 11565 startup DEVi started

2008-08-18 11:23:00 6549 12821 TASKING Thread 6549 starting

2008-08-18 11:23:00 6549 11597 IO Open '/sapdb/SID/data/DISKD0008' successfull, fd: 38

2008-08-18 11:23:00 6549 11565 startup DEVi started

2008-08-18 11:23:00 6550 12821 TASKING Thread 6550 starting

2008-08-18 11:23:00 6550 11597 IO Open '/sapdb/SID/data/DISKD0008' successfull, fd: 39

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0008' devno 8 T100 succeeded

2008-08-18 11:23:00 6550 11565 startup DEVi started

2008-08-18 11:23:00 6551 12821 TASKING Thread 6551 starting

2008-08-18 11:23:00 6551 11597 IO Open '/sapdb/SID/data/DISKD0009' successfull, fd: 41

2008-08-18 11:23:00 6551 11565 startup DEVi started

2008-08-18 11:23:00 6552 12821 TASKING Thread 6552 starting

2008-08-18 11:23:00 6552 11597 IO Open '/sapdb/SID/data/DISKD0009' successfull, fd: 42

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0009' devno 9 T100 succeeded

2008-08-18 11:23:00 6552 11565 startup DEVi started

2008-08-18 11:23:00 6553 12821 TASKING Thread 6553 starting

2008-08-18 11:23:00 6553 11597 IO Open '/sapdb/SID/data/DISKD0010' successfull, fd: 44

2008-08-18 11:23:00 6553 11565 startup DEVi started

2008-08-18 11:23:00 6554 12821 TASKING Thread 6554 starting

2008-08-18 11:23:00 6554 11597 IO Open '/sapdb/SID/data/DISKD0010' successfull, fd: 45

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/data/DISKD0010' devno 10 T100 succeeded

2008-08-18 11:23:00 6554 11565 startup DEVi started

2008-08-18 11:23:00 6555 12821 TASKING Thread 6555 starting

2008-08-18 11:23:00 6555 11597 IO Open '/sapdb/SID/saplog/DISKL001' successfull, fd: 47

2008-08-18 11:23:00 6555 11565 startup DEVi started

2008-08-18 11:23:00 6556 12821 TASKING Thread 6556 starting

2008-08-18 11:23:00 6556 11597 IO Open '/sapdb/SID/saplog/DISKL001' successfull, fd: 48

2008-08-18 11:23:00 6526 11000 vattach '/sapdb/SID/saplog/DISKL001' devno 11 T100 succeeded

2008-08-18 11:23:00 6556 11565 startup DEVi started

2008-08-18 11:23:00 6526 20016 Pager Start Read Converter

2008-08-18 11:23:05 6525 20003 KernelDB 70 percent of data area occupied, 3455994 pages free

2008-08-18 11:23:06 6526 20017 Pager Stop Read Converter, Pages: 4832 IO: 4832

2008-08-18 11:23:06 6526 53000 DATACACH Begin data cache restart

2008-08-18 11:23:06 6526 54003 dynpool DATA_CACHE_REGIONS : 64

2008-08-18 11:23:06 6526 54003 dynpool B20_DATACACHE_HEAD : 206672

2008-08-18 11:23:06 6526 54003 dynpool DATACACHE head num item: 12917

2008-08-18 11:23:06 6526 54003 dynpool DATACACHE head item siz: 16

2008-08-18 11:23:06 6526 54003 dynpool DATACACHE task queue : 3216

2008-08-18 11:23:06 6526 54003 dynpool US + SV + DW + 8 : 134

2008-08-18 11:23:06 6526 54003 dynpool DATACACHE taskq elem : 24

2008-08-18 11:23:06 6526 54003 dynpool B20_DATACACHE_TASKQ : 209888

2008-08-18 11:23:06 6526 54003 dynDATA DATA_CACHE_PAGES : 3228

2008-08-18 11:23:06 6526 54003 dynpool B20_DATACACHE_CB : 413184

2008-08-18 11:23:06 6526 54003 dynpool DATACACHE num cblocks : 3228

2008-08-18 11:23:06 6526 54003 dynpool DATACACHE cblock size : 128

2008-08-18 11:23:06 6526 54003 dynpool DYNP_B20_DATACACHE : 39876608

2008-08-18 11:23:06 6526 54003 dynDATA DYND_B20_DATACACHE : 206592

2008-08-18 11:23:06 6526 53000 DATACACH Finish data cache restart

2008-08-18 11:23:06 6526 53000 B*TREE LOB file directory restart successful

2008-08-18 11:23:06 6526 7 FileDir File directory restarting

2008-08-18 11:23:10 6526 8 FileDir File directory restart completed

2008-08-18 11:23:10 6526 20061 Log History: 50 (50) files existing

2008-08-18 11:23:10 6526 20064 Log History: all history files registered, GC is ready

2008-08-18 11:23:10 6526 54003 dynpool DYNP_K51_LOCK_LIST : 82791792

2008-08-18 11:23:10 6526 54003 dynpool LOCK maxlocks : 300000

2008-08-18 11:23:10 6526 54003 dynpool LOCK items : 902400

2008-08-18 11:23:10 6526 54003 dynpool LOCK Regions : 24

2008-08-18 11:23:10 6526 54003 dynpool LOCK TransRegions : 8

2008-08-18 11:23:10 6526 54003 dynpool LOCK RegionGlob+Space : 3840

2008-08-18 11:23:10 6526 54003 dynpool LOCK TransGlob : 768

2008-08-18 11:23:10 6526 54003 dynpool LOCK SupplyItemsPerRgn : 100

2008-08-18 11:23:10 6526 54003 dynpool LOCK SupplySize : 211200

2008-08-18 11:23:10 6526 54003 dynpool LOCK RowHash entries : 300000

2008-08-18 11:23:10 6526 54003 dynpool LOCK TabHash entries : 60000

2008-08-18 11:23:10 6526 54003 dynpool LOCK Row+Tab hash size :2880000

2008-08-18 11:23:10 6526 54003 dynpool LOCK Trans entries : 408

2008-08-18 11:23:10 6526 54003 dynpool LOCK trans_list size : 107776

2008-08-18 11:23:10 6526 54003 dynpool LOCK TransPtrList : 3264

2008-08-18 11:23:10 6526 54003 dynpool LOCK TransHash entries : 408

2008-08-18 11:23:10 6526 54003 dynpool LOCK TransHash size : 3328

2008-08-18 11:23:10 6526 54003 dynpool LOCK SupplyPoolSegments: 9000

2008-08-18 11:23:10 6526 54003 dynpool LOCK SupplyPoolSize : 79416000

2008-08-18 11:23:10 6526 54003 dynpool LOCK ObjColl_list size : 13056

2008-08-18 11:23:10 6526 54003 dynpool LOCK ObjReq_list size : 8160

2008-08-18 11:23:11 6526 20006 Log 1 queues, flushmode is 'MaximizeSafety', devstate is 'HistoryLost'

2008-08-18 11:23:11 6526 20007 Log Oldest not saved is ioseq 4945153 @ off 13801

2008-08-18 11:23:11 6526 20008 Log First known on LogVolume is ioseq 4509315 @ off 14362

2008-08-18 11:23:11 6526 20005 Log Restart from ioseq 4945153 @ off 13801 to ioseq 4945736 @ off 14361

2008-08-18 11:23:11 6526 20010 Log Result after checking the log device: 'Ok'

2008-08-18 11:23:11 6526 9 Log The number of active logging-queues has been increased to 1

2008-08-18 11:23:11 6526 53000 OBJECT Restarted Garbage coll: 0

2008-08-18 11:23:11 6526 11 Rst 408 redo transactions readable and 11 redo tasks available.

2008-08-18 11:23:11 6523 7 Restart recovering log from log_volume from IOSeq: '4945153'

+++++++++++++++++++++++++++++++++++++++ Kernel Exit ++++++++++++++++++++++++++++

2008-08-18 11:23:17 0 11987 dump_rte rtedump written to file 'rtedump'

2008-08-18 11:23:17 0 ERR 12005 DBCRASH Kernel exited with core and exit status 0x8b

2008-08-18 11:23:17 0 ERR 12012 DBCRASH No stack backtrace since signal handler was suppressed by SUPPRESS_CORE=NO

2008-08-18 11:23:17 0 ERR 12009 DBCRASH Kernel exited due to signal 11(SIGSEGV)

2008-08-18 11:23:17 0 12808 DBSTATE Flushing knltrace pages

2008-08-18 11:23:17 0 WNG 11824 COMMUNIC Releasing T68 kernel abort

2008-08-18 11:23:17 0 WNG 11824 COMMUNIC Releasing T100 kernel abort

2008-08-18 11:23:17 0 12696 DBSTATE Change DbState to 'OFFLINE '(29)

-

---

current write position -

---

[markus_doehr2]

To what value is the parameter "LOG_IO_QUEUES" set?

Markus

[Former Member]

200

[markus_doehr2]

Sorry - wrong parameter - my bad

I wanted to ask for "LOG_QUEUE_COUNT"...

Markus

[Former Member]

1

[former_member229109]

Hello Frank,

-> As SAP customer you have option to open the OSS ticket on this issue.

Did you already created the SAP ticket, where this problem was reported?

-> You have quit old version '7.6.00 Build 035', some 'redo log' problems are

fixed in the new releases.

-> database parameter :: SUPPRESS_CORE 'YES' or 'NO'

'YES': core dumps of database kernel are suppressed

'NO' : core dumps of database kernel are not suppressed

==> The parameter was set to NO => Was the core dump created? Could you debug it?

Please set the SUPPRESS_CORE to YES & restart the database from the offline mode. If the crash occurred please post the complete knldiag trace.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi

I have changed the core parameter to YES.And restarted the database.

2008-08-18 13:17:35 6652 7 Restart recovering log from log_volume from IOSeq: '4945153'

2008-08-18 13:17:35 0 12853 DBSTATE Caught signal 11(SIGSEGV)

2008-08-18 13:17:35 0 ERR 11330 COREHAND ABORTING due to signal 11

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

> Emergency Stack Back Trace <----

2008-08-18 13:17:35 0 ERR 11599 BTRACE (0):0xe61d85

2008-08-18 13:17:35 0 ERR 11599 BTRACE (1):0xe61de9

2008-08-18 13:17:35 0 ERR 11599 BTRACE (2):0xe61e07

2008-08-18 13:17:35 0 ERR 11599 BTRACE (3):0xea3ef8

2008-08-18 13:17:35 0 ERR 11599 BTRACE (4):0x2b6a4eccfc10

2008-08-18 13:17:35 0 ERR 11599 BTRACE (5):0xa72ed0

2008-08-18 13:17:35 0 ERR 11599 BTRACE (6):0xd7b9f7

2008-08-18 13:17:35 0 ERR 11599 BTRACE (7):0xd80ac7

2008-08-18 13:17:35 0 ERR 11599 BTRACE (8):0xd842cc

2008-08-18 13:17:35 0 ERR 11599 BTRACE (9):0xd77436

2008-08-18 13:17:35 0 ERR 11599 BTRACE (10):0xc215ef

2008-08-18 13:17:35 0 ERR 11599 BTRACE (11):0xc18f28

2008-08-18 13:17:35 0 ERR 11599 BTRACE (12):0xc173ee

2008-08-18 13:17:35 0 ERR 11599 BTRACE (13):0xd74fa4

2008-08-18 13:17:35 0 ERR 11599 BTRACE (14):0xd762e4

2008-08-18 13:17:35 0 ERR 11599 BTRACE (15):0xdfd988

2008-08-18 13:17:35 0 ERR 11599 BTRACE (16):0xeaadac

2008-08-18 13:17:35 0 ERR 11599 BTRACE (17):0x2b6a4f465eb0

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

> Register Dump <----

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

2008-08-18 13:17:35 0 ERR 11599 BTRACE rax rbx 0x0000000000000000 0x00002aab279b3cd0

2008-08-18 13:17:35 0 ERR 11599 BTRACE rcx rdx 0x00002aab279b3d70 0x0000000000000001

2008-08-18 13:17:35 0 ERR 11599 BTRACE rsi rdi 0x00002aab17f42f00 0x00002aab279b3cf8

2008-08-18 13:17:35 0 ERR 11599 BTRACE rbp rsp 0x00002aab279b3ce0 0x00002aab17f40240

2008-08-18 13:17:35 0 ERR 11599 BTRACE r08 r09 0x0000000000000000 0x00002b6a4ecc0c00

2008-08-18 13:17:35 0 ERR 11599 BTRACE r10 r11 0x19096b368cbaa976 0x0000000000001fd0

2008-08-18 13:17:35 0 ERR 11599 BTRACE r12 r13 0x00002aab279b3d08 0x00002aab279b3cf8

2008-08-18 13:17:35 0 ERR 11599 BTRACE r14 r15 0x00002aab17f42f00 0x00002aab279b3d6c

2008-08-18 13:17:35 0 ERR 11599 BTRACE

2008-08-18 13:17:35 0 ERR 11599 BTRACE rip eflags 0x0000000000a72ed0 0x0000000000010246

2008-08-18 13:17:35 0 ERR 11599 BTRACE cs fs gs 0x0000000000000033

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

2008-08-18 13:17:35 0 ERR 11599 BTRACE cwd swd 0x037f 0x

2008-08-18 13:17:35 0 ERR 11599 BTRACE ftw fop 0x0000 0x

2008-08-18 13:17:35 0 ERR 11599 BTRACE rip rdp 0x0000000000000000 0x0000000000000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE mxcsr mask 0x000000000000001fa0 0x0000ffff]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st0 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st1 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st2 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st3 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st4 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st5 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st6 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE st7 [0x0000 0x0000 0x0000 0x0000 - 0x0000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm00 [0xbb235d79 0x41f91587 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm01 [0x00000000 0x43e00000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm02 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm03 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm04 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm05 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm06 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm07 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm08 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm09 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm10 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm11 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm12 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm13 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm14 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE xmm15 [0x00000000 0x00000000 0x00000000 0x00000000]

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

> Module List <----

2008-08-18 13:17:35 0 ERR 11599 BTRACE |.text Start |.text End | Module File Name

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x0000000000400000|0x0000000001062000| /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4eba6000|0x00002b6a4ebc1000| /lib64/ld-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4ecc2000|0x00002b6a4ecd4000| /lib64/libpthread-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4edd9000|0x00002b6a4eddb000| /lib64/libdl-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4eedd000|0x00002b6a4eee5000| /lib64/librt-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4efe7000|0x00002b6a4f0aa000| /usr/lib64/libstdc++.so.5.0.7

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4f1c3000|0x00002b6a4f217000| /lib64/libm-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4f318000|0x00002b6a4f325000| /lib64/libgcc_s.so.1

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4f426000|0x00002b6a4f54d000| /lib64/libc-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE |0x00002b6a4f64d000|0x00002b6a4f650000| /lib64/libc-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

> Symbolic Stack Back Trace <----

2008-08-18 13:17:35 0 ERR 11599 BTRACE 0: 0x0000000000e6141d eo670_UnixTraceStack +0x01ad

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 1: 0x0000000000e61de9 eo670_CTraceContextStackOCB +0x0009

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 2: 0x0000000000e61e07 eo670_CTraceContextStack +0x0017

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 3: 0x0000000000ea3ef8 en81_CrashSignalHandler +0x00e8

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 4: 0x00002b6a4eccfc10 __funlockfile +0x0050

2008-08-18 13:17:35 0 ERR 11599 BTRACE /lib64/libpthread-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 5: 0x0000000000a72ed0 ZN31DataChainSplitSpaceForwardReadI12Rst_RedoPageE8Iterator5BreakER20SAPDBErr_Message

Lis

2008-08-18 13:17:35 0 ERR 11599 BTRACE t +0x00d0

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 6: 0x0000000000d7b9f7 ZN16RstRedoReadTask17ContinueCopyEntryER20Rst_LogEntryIteratorR13Rst_CopyStateR20SAPD

BEr

2008-08-18 13:17:35 0 ERR 11599 BTRACE r_MessageList +0x06b7

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 7: 0x0000000000d80ac7 ZN16RstRedoReadTask30InternReadLogAndCreateRedoFileEiR22SAPDBMem_IRawAllocatorR18tgg0

0_T

2008-08-18 13:17:35 0 ERR 11599 BTRACE ransContextR20Rst_LogEntryIteratorR16Container_VectorI13Rst_CopyStateER20SAPDBErr_Messa

geL

2008-08-18 13:17:35 0 ERR 11599 BTRACE ist +0x0927

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 8: 0x0000000000d842cc ZN16RstRedoReadTask25ReadLogAndCreateRedoFilesEiR18tgg00_TransContextR20SAPDBErr_Mess

age

2008-08-18 13:17:35 0 ERR 11599 BTRACE List +0x02ac

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 9: 0x0000000000d77436 ZN15RstRedoManager25ReadLogAndCreateRedoFilesEiR18tgg00_TransContextR20SAPDBErr_Messa

geL

2008-08-18 13:17:35 0 ERR 11599 BTRACE ist +0x0016

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 10: 0x0000000000c215ef ZN16SrvTasksJobRedo13ExecuteInternER13Trans_Context +0x021f

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 11: 0x0000000000c18f28 ZN12SrvTasksJob7ExecuteEv +0x0308

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 12: 0x0000000000c173ee ZN13SrvTasksTask3RunEv +0x080e

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 13: 0x0000000000d74fa4 Z18KernelNonUserTaskR13RTETask_ITaskR13Trans_ContextR20SAPDBErr_MessageList +0x00e4

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 14: 0x0000000000d762e4 Z11KernelMainR13RTETask_ITask +0x0094

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 15: 0x0000000000dfd988 RTETask_TaskMain +0x0038

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 16: 0x0000000000eaadac Z23en88CallKernelTaskMainP9TASK_TYPE +0x009c

2008-08-18 13:17:35 0 ERR 11599 BTRACE /sapdb/SID/db/pgm/kernel

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE 17: 0x00002b6a4f465eb0 __start_context +0x0000

2008-08-18 13:17:35 0 ERR 11599 BTRACE /lib64/libc-2.4.so

2008-08-18 13:17:35 0 ERR 11599 BTRACE Frameinfo [0x0]

2008-08-18 13:17:35 0 ERR 11599 BTRACE -

---

> End of Stack Back Trace <----

2008-08-18 13:17:35 0 ERR 11330 COREHAND dump of siginfo content:

2008-08-18 13:17:35 0 ERR 11330 COREHAND signal 11 (SIGSEGV)

2008-08-18 13:17:35 0 ERR 11330 COREHAND code 1 (ILL_ILLOPC:illegal opcode)

2008-08-18 13:17:35 0 ERR 11330 COREHAND errno 0

2008-08-18 13:17:35 0 ERR 11330 COREHAND value(int) 11059472

2008-08-18 13:17:35 0 ERR 11330 COREHAND value(ptr) @A8C110

2008-08-18 13:17:35 0 ERR 11330 COREHAND pid 40

2008-08-18 13:17:35 0 ERR 11330 COREHAND addr @28

2008-08-18 13:17:35 0 ERR 11599 BTRACE analysing LVCMem_Allocator_001

2008-08-18 13:17:35 0 ERR 11599 BTRACE

2008-08-18 13:17:35 0 ERR 11599 BTRACE no problems detected in LVCMem_Allocator_001

+++++++++++++++++++++++++++++++++++++++ Kernel Exit ++++++++++++++++++++++++++++

2008-08-18 13:17:36 0 11987 dump_rte rtedump written to file 'rtedump'

2008-08-18 13:17:36 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x2f00

2008-08-18 13:17:36 0 ERR 12008 DBCRASH Kernel exited due to reentered signal handler

2008-08-18 13:17:36 0 12890 DIAGHIST Backup of diagnostic files will be forced at next restart

2008-08-18 13:17:36 0 12808 DBSTATE Flushing knltrace pages

2008-08-18 13:17:36 0 WNG 11824 COMMUNIC Releasing T68 kernel abort

2008-08-18 13:17:36 0 WNG 11824 COMMUNIC Releasing T100 kernel abort

2008-08-18 13:17:36 0 12696 DBSTATE Change DbState to 'OFFLINE '(29)

-

---

current write position -

---

[lbreddemann]

Hi Frank,

you're hitting a pretty old bug (http://maxdb.sap.com/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1146505) that occurs when LOCAL_REDO_LOG_BUFFER_SIZE is set to a value bigger than 8K.

Please install the most current patch available to you (either MaxDB 7.6.03 Build 15 for NON-SAP customers or 7.6.04. Build 15 for SAP Customers).

best regards,

Lars

[Former Member]

Hi all

Managed to solve the problem but it wasnt the patch problem as it looked like.It was the redo logs which needed to be reset.And then it worked

[lbreddemann]

Hi Frank,

of course deleting the redo information will let the db start again. But it does not prevent this situation from occuring again.

Therefore make sure to install the patch anyway.

BTW: The database needed recovery when you hit the error (otherwise there wouldn't be any logreading at all). By deleting the redo information you disabled the recovery of transactions that may have been completed already.

MaxDB databases will always start nevertheless, by just using the consistent database state of the last successful savepoint.

Therefore - from application point of view - you lost transactions!

Better perform a check for logical consistency for your application before continuing your work.

Best regards,

Lars

[Former Member]

solved