Maxdb does not start after adding datafile

[Former Member]

Hi All,

After trying to add extra datafiles maxdb does not start any more.

The error is:

-24994 Runtime environment error [db_online ]; 4,connection broken

In knldiag.err the following is shown but I do not understand what's going on:

0x14B4 ERR 8 Messages End of the message list registry dump

2007-10-16 15:57:41 ___ Stopping GMT 2007-10-16 13:57:41 7.6.00 Build 018-123-119-055

2007-10-16 16:20:40 --- Starting GMT 2007-10-16 14:20:40 7.6.00 Build 018-123-119-055

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY RTEMem_Allocator : could not allocate m

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY emory

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY required : 7224

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY allocated : 95666176

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY supplement : 1048576

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY limit : -1

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY free blocks size 24 : 25

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY RTEMem_Allocator : could not allocate m

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY emory

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY required : 8672

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY allocated : 95666176

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY supplement : 1048576

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY limit : -1

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY free blocks size 24 : 25

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY RTEMem_Allocator : could not allocate m

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY emory

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY required : 9344

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY allocated : 95666176

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY supplement : 1048576

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY limit : -1

2007-10-16 16:25:31 0x17DC ERR 54008 MEMORY free blocks size 24 : 25

2007-10-16 16:25:31 0x17DC ERR 3 Admin Kernel_Administration.cpp:606

2007-10-16 16:25:31 0x17DC ERR 3 Admin 2007-10-16 16:25:31 Admin Error 3

2007-10-16 16:25:31 0x17DC ERR 3 Admin Database state: OFFLINE

2007-10-16 16:25:31 0x17DC ERR 3 Admin + Kernel_Trace.cpp:223

2007-10-16 16:25:31 0x17DC ERR 3 Admin + 2007-10-16 16:25:31 KernelCommon Info 6

2007-10-16 16:25:31 0x17DC ERR 3 Admin - Internal errorcode, Errorcode 1910 "sysbuf_storage_exceeded"

2007-10-16 16:25:31 0x17DC ERR 3 Admin + Kernel_Administration.cpp:387

2007-10-16 16:25:31 0x17DC ERR 3 Admin + 2007-10-16 16:25:31 Admin Warning 20024

2007-10-16 16:25:31 0x17DC ERR 3 Admin - Sql lock manager could not be initialized:Too many buffers requested

2007-10-16 16:25:31 0x174C ERR 7 Messages Msg_List.cpp:3617

2007-10-16 16:25:31 0x174C ERR 7 Messages 2007-10-16 16:25:31 Messages Error 7

2007-10-16 16:25:31 0x174C ERR 7 Messages Begin of dump of registered messages

2007-10-16 16:25:31 0x174C ERR 10 Messages Msg_List.cpp:3631

2007-10-16 16:25:31 0x174C ERR 10 Messages 2007-10-16 16:25:31 Messages Error 10

2007-10-16 16:25:31 0x174C ERR 10 Messages abort dump of registered messages

2007-10-16 16:25:31 0x174C ERR 8 Messages Msg_List.cpp:3636

2007-10-16 16:25:31 0x174C ERR 8 Messages 2007-10-16 16:25:31 Messages Error 8

2007-10-16 16:25:31 0x174C ERR 8 Messages End of the message list registry dump

2007-10-16 16:25:32 0x165C ERR 54008 MEMORY RTEMem_RteAllocator : could not allocat

2007-10-16 16:25:32 0x165C ERR 54008 MEMORY e memory

2007-10-16 16:25:32 0x165C ERR 54008 MEMORY required : 5270704

2007-10-16 16:25:32 0x165C ERR 54008 MEMORY allocated : 7340032

2007-10-16 16:25:32 0x165C ERR 54008 MEMORY supplement : 5271552

2007-10-16 16:25:32 0x165C ERR 54008 MEMORY limit : -1

2007-10-16 16:25:33 ___ Stopping GMT 2007-10-16 14:25:33 7.6.00 Build 018-123-119-055

2007-10-16 16:48:56 --- Starting GMT 2007-10-16 14:48:56 7.6.00 Build 018-123-119-055

2007-10-16 16:49:21 0x150C ERR 20000 Log Log_QueueRingBuffer.hpp:68

2007-10-16 16:49:21 0x150C ERR 20000 Log 2007-10-16 16:49:21 Log Error 20000

2007-10-16 16:49:21 0x150C ERR 20000 Log Assertion of state Log_FrameAllocator::New() failed. failed!

2007-10-16 16:49:21 0x150C ERR 18196 DBCRASH vabort:Emergency Shutdown, Log_QueueRingBuffer.hpp: 68

2007-10-16 16:49:21 0x10C8 ERR 18340 CONNECT Could not get named-shared-memory: 'Global\SAPDBTech-CONSOLE-SHM-00000001-fd256071-0000044c-00002575-9e7e2559aa947573', rc = 8

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE RTE_ConsoleDataCommunication.cpp:1581

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE 2007-10-16 16:49:21 RTE Error 13600

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE Console: Attaching shared memory '0X77AFB83C' failed, rc = 8

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE + RTE_ConsoleDataCommunication.cpp:217

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE + 2007-10-16 16:49:21 RTE Error 13609

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE - Console: Opening shared memory failed

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE + RTEThread_ConsoleConnections.cpp:266

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE + 2007-10-16 16:49:21 RTE Error 13110

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE - Console Thread: Initialization of reply worker failed

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE + RTEThread_ConsoleWorkerThread.cpp:129

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE + 2007-10-16 16:49:21 RTE Error 13114

2007-10-16 16:49:21 0x10C8 ERR 13600 RTE - Console Thread: Connect request failed

2007-10-16 16:49:51 0x150C ERR 7 Messages Msg_List.cpp:3617

2007-10-16 16:49:51 0x150C ERR 7 Messages 2007-10-16 16:49:51 Messages Error 7

2007-10-16 16:49:51 0x150C ERR 7 Messages Begin of dump of registered messages

2007-10-16 16:49:51 0x150C ERR 8 Messages Msg_List.cpp:3636

2007-10-16 16:49:51 0x150C ERR 8 Messages 2007-10-16 16:49:51 Messages Error 8

2007-10-16 16:49:51 0x150C ERR 8 Messages End of the message list registry dump

2007-10-16 16:49:52 ___ Stopping GMT 2007-10-16 14:49:52 7.6.00 Build 018-123-119-055

Please help.

Regards,

Koen

Message was edited by:

Koen Engelen

[markus_doehr2 · Accepted solution]

On which operating system are you working? To me it seems, that the system can't allocate the necessary shared memory segment...

--

Markus

[Former Member · Accepted solution]

Hi Markus,

Thanks for replying.

The system is a Win2003 Enterprise system SP1 with 6 Gb of RAM. The pagefile is 20 Gb.

Best Regards,

Koen

[Former Member · Accepted solution]

After rebooting the OS en trying to start maxdb again the follwing error occurs:

4 --- Starting GMT 2007-10-17 07:20:14 7.6.00 Build 018-123-119-055

2007-10-17 09:20:40 0x1530 ERR 20000 Log Log_QueueRingBuffer.hpp:68

2007-10-17 09:20:40 0x1530 ERR 20000 Log 2007-10-17 09:20:40 Log Error 20000

2007-10-17 09:20:40 0x1530 ERR 20000 Log Assertion of state Log_FrameAllocator::New() failed. failed!

2007-10-17 09:20:40 0x1530 ERR 18196 DBCRASH vabort:Emergency Shutdown, Log_QueueRingBuffer.hpp: 68

2007-10-17 09:20:40 0x1378 ERR 18340 CONNECT Could not get named-shared-memory: 'Global\SAPDBTech-CONSOLE-SHM-00000001-fd2648c8-000017bc-00000bf7-860ef67a62fa793a', rc = 8

2007-10-17 09:20:40 0x1378 ERR 13600 RTE RTE_ConsoleDataCommunication.cpp:1581

2007-10-17 09:20:40 0x1378 ERR 13600 RTE 2007-10-17 09:20:40 RTE Error 13600

2007-10-17 09:20:40 0x1378 ERR 13600 RTE Console: Attaching shared memory '0X77AFB6BC' failed, rc = 8

2007-10-17 09:20:40 0x1378 ERR 13600 RTE + RTE_ConsoleDataCommunication.cpp:217

2007-10-17 09:20:40 0x1378 ERR 13600 RTE + 2007-10-17 09:20:40 RTE Error 13609

2007-10-17 09:20:40 0x1378 ERR 13600 RTE - Console: Opening shared memory failed

2007-10-17 09:20:40 0x1378 ERR 13600 RTE + RTEThread_ConsoleConnections.cpp:266

2007-10-17 09:20:40 0x1378 ERR 13600 RTE + 2007-10-17 09:20:40 RTE Error 13110

2007-10-17 09:20:40 0x1378 ERR 13600 RTE - Console Thread: Initialization of reply worker failed

2007-10-17 09:20:40 0x1378 ERR 13600 RTE + RTEThread_ConsoleWorkerThread.cpp:129

2007-10-17 09:20:40 0x1378 ERR 13600 RTE + 2007-10-17 09:20:40 RTE Error 13114

2007-10-17 09:20:40 0x1378 ERR 13600 RTE - Console Thread: Connect request failed

2007-10-17 09:21:10 0x1530 ERR 7 Messages Msg_List.cpp:3617

2007-10-17 09:21:10 0x1530 ERR 7 Messages 2007-10-17 09:21:10 Messages Error 7

2007-10-17 09:21:10 0x1530 ERR 7 Messages Begin of dump of registered messages

2007-10-17 09:21:10 0x1530 ERR 8 Messages Msg_List.cpp:3636

2007-10-17 09:21:10 0x1530 ERR 8 Messages 2007-10-17 09:21:10 Messages Error 8

2007-10-17 09:21:10 0x1530 ERR 8 Messages End of the message list registry dump

2007-10-17 09:21:12 ___ Stopping GMT 2007-10-17 07:21:12 7.6.00 Build 018-123-119-055

[markus_doehr2 · Accepted solution]

How big is your CACHE_SIZE defined?

--

Markus

[Former Member · Accepted solution]

Hi Markus,

The CACHE_SIZE is currently 180096

Regards,

koen

[markus_doehr2 · Accepted solution]

That might be your problem.

Each data file needs a certain amount of internal structures, if you´re on 32bit you may have reached the 2 GB limit for a single process.

To check that, decrease your CACHE_SIZE to 160000 and try to start the database.

--

Markus

[Former Member · Accepted solution]

Hi Markus,

This indeed solved my issue! Thank you very much for your quick help!

I will reward all points.

Best regards,

Koen

[markus_doehr2 · Accepted solution]

you're welcome

--

Markus

[Former Member · Accepted solution]

Hi, Markus

Reading these replies I have seen that we have a similar error.

The version of Maxdb is 7.5.00.52, O.S is 2003 32bit with 4GB physical memory. The database space is approximately 4 TB.

Recently the backup on disk and the backup with external storage fails with the following error:

0x1480 ERR 54008 MEMORY   RTEMem_Allocator : could not allocate me

0x1480 ERR 54008 MEMORY   mory

0x1480 ERR 54008 MEMORY   required  : 8176

0x1480 ERR 54008 MEMORY   allocated : 371347456

0x1480 ERR 54008 MEMORY   supplement: 1048576

0x1480 ERR 54008 MEMORY   limit

: 4294967295

0x1480 ERR 20020 Converte No more memory for back up page no container. max page no= 479590865 #perm conv leaf p.= 257133 'leaf page entries=

0x1480 ERR 20020 Converte  1861

0x1480 ERR

0 SAPDBErr Assertion of state BeginSaveData/Pages because of exhausted memory failed!

0x1480 ERR 18196 DBCRASH  vabort:Emergency Shutdown, Log_Savepoint.cpp: 570

--- Starting GMT 2012-07-24 12:54:03

7.5.0

Build 052-123-232-633

I checked out some parameters which CACHE_SIZE that is currently set at 260000.

When we tried to change it to lower values the resource MaxDB never went online.

Best regards,

Emiliano Zannelli