Error starting MaxDB on CE Preview 7.1 SR5

Hi everyone,

I installed CE 7.1 Trial Version SR5 successfully yesterday. The server worked fine.

Today I could not start the CE System because the MaxDB was not started.

I tried the following command: dbmcli -d CE2 -u control,<password> db_online

This error occured:

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Database state: OFFLINE

6,Internal errorcode, Error code 9050 "disk_not_accessible"

20017,RestartFilesystem failed with 'I/O error'

Can anyone help me? As I said yesterday it worked that why it doesn't seem to be a general problem.

Best regards,

Olaf

SAP Managed Tags:
SAP MaxDB

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

ERR
-24988,ERR_SQL: SQL error
-902,I/O error
3,Database state: OFFLINE
6,Internal errorcode, Error code 9050 "disk_not_accessible"
20017,RestartFilesystem failed with 'I/O error'

Usually I/O errors means that the disk is damaged.... "disk_not_accessible"

Check your hardware.

Regards

Juan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

> Usually I/O errors means that the disk is damaged.... "disk_not_accessible"

Actually it means "disk is not accessible" - maybe the path to the datavolumes is wrong or maybe there is a permission problem.

Please let us see the KNLDIAG for this error.

regards,

Lars

Hi everyone,

I tried to analyse the problem and tested the connection.

After a couple of minutes it worked. But I have no idea why. I did not change any properties, just tested.

Thanks for your answers anyway

Olaf

Hello Olaf,

Please post more details to get clear on the reported issue:

-> The OS version of the database server.

-> What is database version?

-> What File Systems are you using for the data/log volumes?

-> Please post the KnlMsg file < or knldiag if the database version < 7.7 >

with more lines before the "Error code 9050 "disk_not_accessible"" occurs.

-> Post the entries in the dbm.prt file around the time when you tried to start the database.

Thank you and best regards, Natalia Khlopina

Hi Natalia,

I'm using the NW CE Trial Version. So everything's on my local PC (Windows XP Pro), NTFS formatted Hard Drive, MaxDB Version 7.6.03

KnlMsg File:

<MSG_ARGS

FILE="KernelTrace.cpp"

_LINE="214"

_TIME="2009-01-13 09:27:40.080"

_MESSAGEVERSION="1"

TITLE="Internal errorcode"

BASIS_ERROR="9050"

ERRORTEXT="disk_not_accessible"

</MSG>

<MSG_ARGS

FILE="KernelAdministration.cpp"

_LINE="369"

_TIME="2009-01-13 09:27:40.080"

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgOutputKnlDiag.cpp"

_LINE="407"

_TIME="2009-01-13 09:27:40.080"

_LABEL="CONNECT "

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgOutputKnlDiag.cpp"

_LINE="407"

_TIME="2009-01-13 09:27:40.080"

_LABEL="DBSTATE "

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgList.cpp"

_LINE="3827"

_TIME="2009-01-13 09:27:40.080"

_MESSAGEVERSION="1"

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgList.cpp"

_LINE="3846"

_TIME="2009-01-13 09:27:40.080"

_MESSAGEVERSION="1"

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgList.cpp"

_LINE="3856"

_TIME="2009-01-13 09:27:40.080"

_MESSAGEVERSION="1"

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgOutputKnlDiag.cpp"

_LINE="407"

_TIME="2009-01-13 09:27:40.080"

_LABEL="TASKING "

</MSG>

</MSGL>

<MSG_ARGS

FILE="TraceWriter.cpp"

_LINE="208"

_TIME="2009-01-13 09:27:40.080"

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgOutputKnlDiag.cpp"

_LINE="407"

_TIME="2009-01-13 09:27:40.080"

_LABEL="VOLUMEIO"

</MSG>

</MSGL>

<MSG_ARGS

FILE="TraceWriter.cpp"

_LINE="214"

_TIME="2009-01-13 09:27:40.283"

</MSG>

</MSGL>

<MSG_ARGS

FILE="TraceWriter.cpp"

_LINE="255"

_TIME="2009-01-13 09:27:40.283"

</MSG>

</MSGL>

<MSG_ARGS

FILE="TraceWriter.cpp"

_LINE="377"

_TIME="2009-01-13 09:27:40.283"

</MSG>

</MSGL>

<MSG_ARGS

FILE="MsgOutputKnlDiag.cpp"

_LINE="407"

_TIME="2009-01-13 09:27:40.283"

_LABEL="TASKING "

</MSG>

</MSGL>

dbm.prt:

2009-01-13 09:27:39 0x000016b8 INF 216 DBMSrv DBM Server client connection (established at 2009-01-13 09:27:39): PID 1316 on computer <computer_name>

2009-01-13 09:27:39 0x000016b8 INF 283 DBMSrv command db_online

2009-01-13 09:27:40 0x000016b8 ERR -24988 DBMSrv ERR_SQL: SQL error

0x000016b8 ERR -24778 DBMSrv -902,I/O error

0x000016b8 ERR -24778 DBMSrv 3,Database state: OFFLINE

0x000016b8 ERR -24778 DBMSrv 6,Internal errorcode, Error code 9050 "disk_not_accessible"

0x000016b8 ERR -24778 DBMSrv 20017,RestartFilesystem failed with 'I/O error'

2009-01-13 09:27:40 0x000016b8 INF 226 DBMSrv DBM Server client disconnected: PID 1316 on computer <computer_name>

Thanks,

Olaf

Hello Olaf,

-> Could you please display KnlMsg File using DBMGUI or Database studio tools, please post more lines from KnlMsg File before the error occurred to understand what disk was not accessible during the database restart.

-> Please see the document to convert the KnlMsg to text format, you could use the protconv tool, for example, "HowTo - New knldiag Message File Format in MaxDB 7.7" guide is available in SDNs MaxDB 'HowTo' section:

Go at https://www.sdn.sap.com/irj/scn/wiki?path=/display/maxdb/main

Click on "HowTo - New "knldiag" Message File Format in MaxDB 7.7"->

Thank you and best regards, Natalia Khlopina

KNLMSG File:

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19770: SERVERNODE: <computer_name>

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19771: Process ID: 6088

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19773: Date: 2009-01-14

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19772: Owner: 'SYSTEM'

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19806: Machine: 'Intel IA32 level 6 revision f02'

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19783: Processors: 1 ( logical: 2 )

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19782: Fiber: 'YES'

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19776: Max virtual memory: 2047 MB

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19777: Total physical memory: 3317 MB

Thread 0x17D Task - 2009-01-14 09:29:18 INFO 19778: Available physical memory: 2250 MB

Thread 0x17D Task - 2009-01-14 09:29:18 RTE 20219: Memory allocation not limited

Thread 0x17D Task - 2009-01-14 09:29:18 RTE 20220: System page cache usage enabled

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19692: tw;al;ut;2000sv,100bup;10ev,10gc;ti,100dw;30000us;compress

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19693: number of 'BUP': 0

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19693: number of ' DW': 16

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19693: number of ' US': 85

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19693: number of ' SV': 25

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19693: number of ' EV': 2

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19693: number of ' GC': 1

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19692: Total Number of UKT 7

Thread 0x17D Task - 2009-01-14 09:29:18 TCLUSTER 19692: Number ofUKT with User Tasks 1

Thread 0x17D Task - 2009-01-14 09:29:18 MEMORY 19860: I/O buffer cache: 12800 Pages allocated

Thread 0x17D Task - 2009-01-14 09:29:18 EVENTING 19811: Suppressing output to 'knldiag.evt' 0 pages

Thread 0x17D Task - 2009-01-14 09:29:18 EVENTING 19812: Eventbuffer 100 events 2 tasks

Thread 0x15D Task - 2009-01-14 09:29:18 TASKING 19821: Thread 5592 starting

Thread 0x17D Task - 2009-01-14 09:29:19 TRACE_IO 19831: Configured MAXMESSAGE_FILES:0

Thread 0x17D Task - 2009-01-14 09:29:19 TRACE_IO 19832: Disabled:No TraceMessagefiles wanted

Thread 0x111 Task - 2009-01-14 09:29:19 THREAD 19688: CLOCK thread started

Thread 0x15E Task - 2009-01-14 09:29:19 THREAD 19688: TIMER thread started

Thread 0xD00 Task - 2009-01-14 09:29:19 THREAD 19688: ASYNC0 thread started

Thread 0xF40 Task - 2009-01-14 09:29:19 RTE 20213: CONSOLE thread started

Thread 0xF54 Task - 2009-01-14 09:29:19 THREAD 19688: REQUESTOR thread started

Thread 0xF78 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 3960 starting

Thread 0x500 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 1280 starting

Thread 0x177 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 6000 starting

Thread 0xD50 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 3408 starting

Thread 0xF58 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 3928 starting

Thread 0x173 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 5944 starting

Thread 0x12E Task - 2009-01-14 09:29:19 TASKING 19821: Thread 4836 starting

Thread 0x12E Task - 2009-01-14 09:29:19 TASKING 19821: Thread 4840 starting

Thread 0x102 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 4140 starting

Thread 0x173 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 5940 starting

Thread 0x2B4 Task - 2009-01-14 09:29:19 TASKING 19627: UKT started, TID:0x2B4

Thread 0x2B8 Task - 2009-01-14 09:29:19 TASKING 19627: UKT started, TID:0x2B8

Thread 0xFD4 Task - 2009-01-14 09:29:19 TASKING 19821: Thread 4052 starting

Thread 0xE84 Task - 2009-01-14 09:29:19 TASKING 19627: UKT started, TID:0xE84

Thread 0xC60 Task - 2009-01-14 09:29:19 TASKING 19627: UKT started, TID:0xC60

Thread 0x169 Task - 2009-01-14 09:29:19 TASKING 19627: UKT started, TID:0x169C

Thread 0x12E Task - 2009-01-14 09:29:19 TASKING 19627: UKT started, TID:0x12E0

Thread 0x10B Task - 2009-01-14 09:29:19 TASKING 19627: UKT started, TID:0x10BC

Thread 0x10B Task 1 2009-01-14 09:29:19 VOLUMEIO 19615: Attachingvolume 'knltrace'

Thread 0x100 Task - 2009-01-14 09:29:20 DBSTATE 19613: I/O thread for 'knltrace' started

Thread 0x10B Task 1 2009-01-14 09:29:20 Admin 20040: Kernel state: 'ADMIN' reached

Thread 0x10B Task 1 2009-01-14 09:29:20 SrvTasks 9: AvailableServertasks: 25

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: HIST_DIRitem size : 8

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: HIST_DIRnum items : 85

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: DYNP_B930_HIST_DIR : 680

Thread 0x10B Task 1 2009-01-14 09:29:20 dynDATA 54003: DYND_K57_KB_PAGES : 11

Thread 0x10B Task 1 2009-01-14 09:29:20 dynDATA 54003: BACKUP RESTART REC (8K): 1

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP TASK LIST : 176

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP TAPE LIST : 336

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP DEVSP LIST : 80

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP VOL IDX LIST : 32

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP SRR QUEUE : 608

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: DYNP_K38_SAVE_GLOB : 1152

Thread 0x10B Task 1 2009-01-14 09:29:20 dynDATA 54003: DYND_K38_SAVE : 1601

Thread 0x10B Task 1 2009-01-14 09:29:20 dynDATA 54003: BACKUP RESTART REC (8K): 1

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP TASK LIST : 32

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP TAPE LIST : 672

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP DEVSP LIST : 16

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP VOL IDX LIST : 32

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: BACKUP SRR QUEUE : 128

Thread 0x10B Task 1 2009-01-14 09:29:20 dynpool 54003: DYNP_K38_AUTOSAVE : 864

Thread 0x10B Task 1 2009-01-14 09:29:20 dynDATA 54003: DYND_K38_AUTOSAVE : 321

Thread 0x10B Task 1 2009-01-14 09:29:20 TASKING 19930: Kernel initialization completed

Thread 0x10B Task 5 2009-01-14 09:29:20 Pager 20018: Start TaskId: 5

Thread 0x10B Task 5 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:0

Thread 0x10B Task 20 2009-01-14 09:29:20 Pager 20018: Start TaskId: 20

Thread 0x10B Task 20 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:1

Thread 0x10B Task 19 2009-01-14 09:29:20 Pager 20018: Start TaskId: 19

Thread 0x10B Task 19 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:2

Thread 0x10B Task 18 2009-01-14 09:29:20 Pager 20018: Start TaskId: 18

Thread 0x10B Task 18 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:3

Thread 0x10B Task 17 2009-01-14 09:29:20 Pager 20018: Start TaskId: 17

Thread 0x10B Task 17 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:4

Thread 0x10B Task 16 2009-01-14 09:29:20 Pager 20018: Start TaskId: 16

Thread 0x10B Task 16 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:5

Thread 0x10B Task 15 2009-01-14 09:29:20 Pager 20018: Start TaskId: 15

Thread 0x10B Task 15 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:6

Thread 0x10B Task 14 2009-01-14 09:29:20 Pager 20018: Start TaskId: 14

Thread 0x10B Task 14 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:7

Thread 0x10B Task 13 2009-01-14 09:29:20 Pager 20018: Start TaskId: 13

Thread 0x10B Task 13 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:8

Thread 0x10B Task 12 2009-01-14 09:29:20 Pager 20018: Start TaskId: 12

Thread 0x10B Task 12 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:9

Thread 0x10B Task 11 2009-01-14 09:29:20 Pager 20018: Start TaskId: 11

Thread 0x10B Task 11 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:10

Thread 0x10B Task 10 2009-01-14 09:29:20 Pager 20018: Start TaskId: 10

Thread 0x10B Task 10 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:11

Thread 0x10B Task 9 2009-01-14 09:29:20 Pager 20018: Start TaskId: 9

Thread 0x10B Task 9 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:12

Thread 0x10B Task 8 2009-01-14 09:29:20 Pager 20018: Start TaskId: 8

Thread 0x10B Task 8 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:13

Thread 0x10B Task 7 2009-01-14 09:29:20 Pager 20018: Start TaskId: 7

Thread 0x10B Task 7 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:14

Thread 0x10B Task 6 2009-01-14 09:29:20 Pager 20018: Start TaskId: 6

Thread 0x10B Task 6 2009-01-14 09:29:20 Pager 20019: First DataCacheSegment:15

Thread 0x10B Task 1 2009-01-14 09:29:20 SrvTasks 31: Permanently reserved 11 servertasks for 'Backup / Restore'.

Thread 0x10B Task 1 2009-01-14 09:29:20 SrvTasks 31: Permanently reserved 2 servertasks for 'Backup / Restore'.

Thread 0x10B Task 1 2009-01-14 09:29:20 SrvTasks 31: Permanently reserved 1 servertasks for 'Savepoint'.

Thread 0x15E Task - 2009-01-14 09:29:20 RunTime 3: State changed from STARTING to ADMIN

Thread 0x15E Task - 2009-01-14 09:29:20 DBSTATE 19601: SERVERDB is ready

Thread 0x15E Task - 2009-01-14 09:29:20 RTE 20223: Database tries automatic restart

Thread 0x106 Task - 2009-01-14 09:29:20 TASKING 19821: Thread 4204 starting

Thread 0x169 Task 21 2009-01-14 09:29:20 CONNECT 19633: Connect req. (T21, Node:'', PID:5048)

Thread 0x169 Task 21 2009-01-14 09:29:20 VOLUMEIO 19615: Attachingvolume 'D:\sapdb\CE2\sapdata\DISKD0001'

Thread 0xA64 Task - 2009-01-14 09:29:20 DBSTATE 19613: I/O thread for 'D:\sapdb\CE2\sapdata\DISKD0001' started

Thread 0x169 Task 21 2009-01-14 09:29:20 VOLUMEIO 19617: Single I/O attach, 'D:\sapdb\CE2\sapdata\DISKD0001', UKT:7

Thread 0x169 Task 21 2009-01-14 09:29:20 VOLUMEIO 19615: Attachingvolume 'D:\sapdb\CE2\sapdata\DISKD0002'

Thread 0x144 Task - 2009-01-14 09:29:20 DBSTATE 19613: I/O thread for 'D:\sapdb\CE2\sapdata\DISKD0002' started

Thread 0x169 Task 21 2009-01-14 09:29:20 VOLUMEIO 19617: Single I/O attach, 'D:\sapdb\CE2\sapdata\DISKD0002', UKT:7

Thread 0x169 Task 21 2009-01-14 09:29:20 VOLUMEIO 19615: Attachingvolume 'F:\sapdb\CE2\saplog\DISKL001'

Thread 0x12A Task - 2009-01-14 09:29:20 ERR IO 18499: Wrong path 'F:\sapdb\CE2\saplog\DISKL001'

Thread 0x169 Task 21 2009-01-14 09:29:20 ERR IOMan 20027: Attach error on log volume 1: wrong path specified,_FILE=IOMan_Volume.cpp,_LINE=981

Thread 0x169 Task 21 2009-01-14 09:29:20 VOLUMEIO 19616: Detachingvolume 'D:\sapdb\CE2\sapdata\DISKD0001'

Thread 0x12A Task - 2009-01-14 09:29:20 VOLUMEIO 19618: Single I/O detach, 'D:\sapdb\CE2\sapdata\DISKD0001', UKT:7

Thread 0xA64 Task - 2009-01-14 09:29:20 DBSTATE 19614: I/O thread for 'D:\sapdb\CE2\sapdata\DISKD0001' stopped

Thread 0x169 Task 21 2009-01-14 09:29:20 VOLUMEIO 19616: Detachingvolume 'D:\sapdb\CE2\sapdata\DISKD0002'

Thread 0x12A Task - 2009-01-14 09:29:20 VOLUMEIO 19618: Single I/O detach, 'D:\sapdb\CE2\sapdata\DISKD0002', UKT:7

Thread 0x144 Task - 2009-01-14 09:29:20 DBSTATE 19614: I/O thread for 'D:\sapdb\CE2\sapdata\DISKD0002' stopped

Thread 0x169 Task 21 2009-01-14 09:29:20 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=617

2009-01-14 09:29:20 KernelComm 6: Internal errorcode, Error code 9050 "disk_not_accessible"

2009-01-14 09:29:20 ERR Admin 20017: RestartFilesystem failed with 'I/O error',_FILE=Kernel_Administration.cpp,_LINE=369

Thread 0x169 Task 21 2009-01-14 09:29:20 CONNECT 19651: Connection released, T21

Thread 0x169 Task 21 2009-01-14 09:29:20 DBSTATE 19621: Shutdown kill requested

Thread 0x17D Task - 2009-01-14 09:29:20 ERR Messages 7: Begin of dump of registered messages,_FILE=Msg_List.cpp,_LINE=3827

Thread 0x17D Task - 2009-01-14 09:29:20 ERR Messages 10: abort dump of registered messages,_FILE=Msg_List.cpp,_LINE=3846

Thread 0x17D Task - 2009-01-14 09:29:20 ERR Messages 8: End of the message list registry dump,_FILE=Msg_List.cpp,_LINE=3856

Thread 0x2B8 Task 3 2009-01-14 09:29:20 Trace 20000: Start flush kernel trace

Thread 0x17D Task - 2009-01-14 09:29:20 TASKING 19684: Tracewriter termination timeout: 1200 sec

Thread 0x2B8 Task 3 2009-01-14 09:29:20 VOLUMEIO 19617: Single I/O attach, 'knltrace', UKT:1

Thread 0x2B8 Task 3 2009-01-14 09:29:20 Trace 20001: Stop flush kernel trace

Thread 0x2B8 Task 3 2009-01-14 09:29:20 Trace 20002: Start flush kernel dump

Thread 0x2B8 Task 3 2009-01-14 09:29:20 Trace 20003: Stop flush kernel dump

Thread 0x2B8 Task 3 2009-01-14 09:29:20 TASKING 19619: Releasing tracewriter

Thread 0x17D Task - 2009-01-14 09:29:20 DIAGHIST 19890: Backup of diagnostic files will be forced at next restart

Thread 0x17D Task - 2009-01-14 09:29:20 VERSION 19600: 'Kernel 7.6.03 Build 012-123-169-237'

Thread 0x17D Task - 2009-01-14 09:29:20 DBSTATE 19654: SERVERDB 'CE2' has stopped

Thread 0x106 Task - 2009-01-14 09:29:20 ERR RTE 20125: Database automatic restart failed,_FILE=RTE_ExternalCall.cpp,_LINE=868

Thank you,

Olaf

Hello Olaf,

According your information, the problem was occurred

To attach the log volume 1 during the database restart:

"Thread 0x12A Task -

2009-01-14 09:29:20

ERR IO 18499: Wrong path 'F:\sapdb\CE2\saplog\DISKL001'

Thread 0x169 Task 21

2009-01-14 09:29:20 ERR IOMan 20027: Attach error on log volume 1:

wrong path specified,_FILE=IOMan_Volume.cpp,_LINE=981

May be device F:\, where the log volume is located was not available during

the database restart. Please check it.

Thank you and best regards, Natalia Khlopina

Thank you Natalia,

that solved the problem.

Thanks,

Olaf

Hello Olaf,

Thank you for the update

You could close this case. Best regards, Natalia Khlopina

Dear Natalia,

I have gone through many of your replies and solutions on SDN forum related to MaxDB. Wondering if you could help me in my crisis too.

I have recently performed a system copy changing the SID from the previous server to be able to configure our SAP PRD server. I have opted to go with SAPINST->system copy process with all the required inputs where it took me to the screen asking me to restore the MaxDB database and make sure that the database is in online state. The steps performed by me were as follows:-

prdserver1:sqdprd 6> dbmcli -d PRD -u control,pass1234 medium_put dbrecover /bac

kup/backup16032011 FILE DATA

(Note: backup16032011 is the complete backup from the previous server)

prdserver1:sqdprd 7> dbmcli -d PRD -u control,pass1234

dbmcli on PRD>recover_check dbrecover

ERR

-24933,ERR_NOSERVICESESSION: No service session active

---

dbmcli on PRD>db_connect

---

dbmcli on PRD>db_admin

---

dbmcli on PRD>recover_check dbrecover

ERR

-24933,ERR_NOSERVICESESSION: No service session active

---

dbmcli on PRD>service_connect

---

dbmcli on PRD>recover_check dbrecover

Returncode 0

Date 20110930

Time 00134052

Server sapserver1

Database SPP

Kernel Version Kernel 7.7.06 Build 010-123-204-327

Pages Transferred 13059672

Pages Left 0

Volumes 1

Medianame dbrecover

Location /backup/backup16032011

Errortext

Label DAT_000000273

Is Consistent true

First LOG Page 14870005

Last LOG Page

DB Stamp 1 Date 20110924

DB Stamp 1 Time 00222656

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 13059651

Devices Used 1

Database ID sapserver1:SPP_20110924_222705

Max Used Data Page 0

Converter Page Count 7033

---

dbmcli on PRD>user_getall

CONTROL

---

dbmcli on PRD>sql_execute select * from users

ERR

-24988,ERR_SQL: SQL error

-101,SQL statement not available in this DB mode

---

dbmcli on PRD>recover_config dbrecover

Returncode 0

Date 20110924

Time 00222705

Server sapserver1

Database SPP

Kernel Version Kernel 7.7.06 Build 010-123-204-327

Pages Transferred 0

Pages Left 0

Volumes

Medianame

Location /backup/backup16032011

Errortext

Label DAT_000000273

Is Consistent true

First LOG Page 14870005

Last LOG Page

DB Stamp 1 Date 20110924

DB Stamp 1 Time 00222656

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 13059651

Devices Used 1

Database ID sapserver1:SPP_20110924_222705

Max Used Data Page 0

Converter Page Count 7033

---

dbmcli on PRD>db_state

State

ADMIN

---

dbmcli on PRD>recover_start dbrecover

Returncode 0

Date 20110930

Time 00144150

Server sapserver1

Database SPP

Kernel Version Kernel 7.7.06 Build 010-123-204-327

Pages Transferred 13059672

Pages Left 0

Volumes 1

Medianame dbrecover

Location /backup/backup16032011

Errortext

Label DAT_000000273

Is Consistent true

First LOG Page 14870005

Last LOG Page

DB Stamp 1 Date 20110924

DB Stamp 1 Time 00222656

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 13059651

Devices Used 1

Database ID sapserver1:SPP_20110924_222705

Max Used Data Page 0

Converter Page Count 7033

---

dbmcli on PRD>db_execute clear log

---

dbmcli on PRD>recover_ignore

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

---

dbmcli on PRD>db_state

State

ADMIN

---

dbmcli on PRD>recover_ignore

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

---

(Note:- after error 104, i had to check the PRD.cfg file and the users available in the database then had to proceed with the SAP NOTE:- 442944)

dbmcli on PRD>db_cold

---

dbmcli on PRD>util_connect control,pass1234

---

dbmcli on PRD>util_execute restart

---

dbmcli on PRD>util_release

---

dbmcli on PRD>load_systab -u superdba,pass1234 -ud pass1234

0,OK: everything works fine

0,/sapdb/PRD/db/bin/sdbsysload -R /sapdb/PRD/db -d PRD -u superdba,*

Installing tables for instances

Removing obsolete objects

Installing Loader tables

Installing messages and help

Installing SYSDBA tables

Installing comments for SYSDBA tables

Installing ODBC tables

Installing tables for WebAgent

Installing tables for Repository (WebDAV)

Installing DOMAIN tables

Installing comments for DOMAIN tables

Installing Views as replacement for SHOWs

Installing Database Manager tables

Installing SYSINFO tables

Installing comments for SYSINFO tables

Installing support for UDE (User Defined Extensions)

Installing additional triggers

Installing tables for JDBC Database Metadata

Installing tables for SQLDBC Database Metadata

Installing tables for DBAnalyzer

==================================

Installation successfully finished

==================================

---

dbmcli on PRD>recover_ignore

ERR

-24990,ERR_NOBACKUPSESSION: No restore session available

---

dbmcli on PRD>db_state

State

ONLINE

( NOTE:- after checking the dbstate i thought of initializing a complete backup on the database and on the logs as the log directory was full up after the system copy process)

dbmcli -d PRD -u control,pass1234 medium_put data /backup/DATA0007 FILE DATA

prdserver1:sqdprd 5>

prdserver1:sqdprd 5> dbmcli -d PRD -u control,pass1234 db_connect

prdserver1:sqdprd 6> dbmcli -d PRD -u control,pass1234

dbmcli on PRD>backup_start data

ERR

-24991,ERR_NODBSESSION: no database session available

---

dbmcli on PRD>db_state

State

ONLINE

---

dbmcli on PRD>db_admin

---

dbmcli on PRD>backup_start data

ERR

-24991,ERR_NODBSESSION: no database session available

---

dbmcli on PRD>

prdserver1:sqdprd 7> dbmcli -uUTL -u control,pass1234 backup_start data

Error! Connection failed to node (local) for database (no dbname):

-24875,ERR_NEEDADMI: The operating system user is not a member of the database administrators group

-24994,ERR_RTE: Runtime environment error

20130,UNIX user 'CONTROL' unknown

prdserver1:sqdprd 8> dbmcli -uUTL -u control,pass1234 -d PRD backup_start data

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Data backup failed

prdserver1:sqdprd 9> dbmcli -d PRD -u control,pass1234 db_state

State

ADMIN

prdserver1:sqdprd 10>

prdserver1:sqdprd 10> dbmcli -d PRD -u control,pass1234 db_online

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Database state: OFFLINE

Internal errorcode, Error code 9050 "disk_not_accessible"

20017,RestartFilesystem failed with 'I/O error'

prdserver1:sqdprd 11>

prdserver1:sqdprd 11> db_release

db_release: Command not found.

prdserver1:sqdprd 12> dbmcli -d PRD -u control,pass1234 db_release

prdserver1:sqdprd 13>

prdserver1:sqdprd 13> dbmcli -d PRD -u control,pass1234 db_online

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Database state: OFFLINE

Internal errorcode, Error code 9050 "disk_not_accessible"

20017,RestartFilesystem failed with 'I/O error'

---

dbmcli on PRD>db_state

State

OFFLINE

---

Its surprising that the db has gone offline after been able to log on to the server. I would be very obliged if you could take a look at this issue.Please do reach me in case required any further information. Hope i am not bothering you, sorry, please dont get me wrong.

Thanks a lot in advance.

Dear Natalia,

I have gone through many of your replies and solutions on SDN forum related to MaxDB. Wondering if you could help me in my crisis too.--

>I have recently performed a system copy changing the SID from the previous server to be able to configure our SAP PRD server. I have opted to go with SAPINST->system copy process with all the required inputs where it took me to the screen asking me to restore the MaxDB database and make sure that the database is in online state. The steps performed by me were as follows:--

prdserver1:sqdprd 6> dbmcli -d PRD -u control,pass1234 medium_put dbrecover /bac

kup/backup16032011 FILE DATA

OK----

(Note: backup16032011 is the complete backup from the previous server)----

prdserver1:sqdprd 7> dbmcli -d PRD -u control,pass1234----

dbmcli on PRD>recover_check dbrecover----

ERR

-24933,ERR_NOSERVICESESSION: No service session active----

---

dbmcli on PRD>db_connect

OK----

---

dbmcli on PRD>db_admin

OK----

---

dbmcli on PRD>recover_check dbrecover

ERR

-24933,ERR_NOSERVICESESSION: No service session active----

---

dbmcli on PRD>service_connect

OK----

---

dbmcli on PRD>recover_check dbrecover

Returncode 0

Date 20110930

Time 00134052

Server sapserver1

Database SPP

Kernel Version Kernel 7.7.06 Build 010-123-204-327

Pages Transferred 13059672

Pages Left 0

Volumes 1

Medianame dbrecover

Location /backup/backup16032011

Errortext

Label DAT_000000273

Is Consistent true

First LOG Page 14870005

Last LOG Page

DB Stamp 1 Date 20110924

DB Stamp 1 Time 00222656

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 13059651

Devices Used 1

Database ID sapserver1:SPP_20110924_222705

Max Used Data Page 0

Converter Page Count 7033----

---

dbmcli on PRD>user_getall

CONTROL----

---

dbmcli on PRD>sql_execute select * from users

ERR

-24988,ERR_SQL: SQL error

-101,SQL statement not available in this DB mode----

---

dbmcli on PRD>recover_config dbrecover

Returncode 0

Date 20110924

Time 00222705

Server sapserver1

Database SPP

Kernel Version Kernel 7.7.06 Build 010-123-204-327

Pages Transferred 0

Pages Left 0

Volumes

Medianame

Location /backup/backup16032011

Errortext

Label DAT_000000273

Is Consistent true

First LOG Page 14870005

Last LOG Page

DB Stamp 1 Date 20110924

DB Stamp 1 Time 00222656

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 13059651

Devices Used 1

Database ID sapserver1:SPP_20110924_222705

Max Used Data Page 0

Converter Page Count 7033----

---

dbmcli on PRD>db_state

State

ADMIN----

---

dbmcli on PRD>recover_start dbrecover

Returncode 0

Date 20110930

Time 00144150

Server sapserver1

Database SPP

Kernel Version Kernel 7.7.06 Build 010-123-204-327

Pages Transferred 13059672

Pages Left 0

Volumes 1

Medianame dbrecover

Location /backup/backup16032011

Errortext

Label DAT_000000273

Is Consistent true

First LOG Page 14870005

Last LOG Page

DB Stamp 1 Date 20110924

DB Stamp 1 Time 00222656

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 13059651

Devices Used 1

Database ID sapserver1:SPP_20110924_222705

Max Used Data Page 0

Converter Page Count 7033----

---

dbmcli on PRD>db_execute clear log

OK----

---

dbmcli on PRD>recover_ignore

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time----

---

dbmcli on PRD>db_state

State

ADMIN----

---

dbmcli on PRD>recover_ignore

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time----

---

(Note:- after error 104, i had to check the PRD.cfg file and the users available in the database then had to proceed with the SAP NOTE:- 442944)----

dbmcli on PRD>db_cold

OK----

---

dbmcli on PRD>util_connect control,pass1234

OK----

---

dbmcli on PRD>util_execute restart

OK----

---

dbmcli on PRD>util_release

OK----

---

dbmcli on PRD>load_systab -u superdba,pass1234 -ud pass1234

0,OK: everything works fine

0,/sapdb/PRD/db/bin/sdbsysload -R /sapdb/PRD/db -d PRD -u superdba,*

Installing tables for instances

Removing obsolete objects

Installing Loader tables

Installing messages and help

Installing SYSDBA tables

Installing comments for SYSDBA tables

Installing ODBC tables

Installing tables for WebAgent

Installing tables for Repository (WebDAV)

Installing DOMAIN tables

Installing comments for DOMAIN tables

Installing Views as replacement for SHOWs

Installing Database Manager tables

Installing SYSINFO tables

Installing comments for SYSINFO tables

Installing support for UDE (User Defined Extensions)

Installing additional triggers

Installing tables for JDBC Database Metadata

Installing tables for SQLDBC Database Metadata

Installing tables for DBAnalyzer

==================================

Installation successfully finished

==================================----

---

dbmcli on PRD>recover_ignore

ERR

-24990,ERR_NOBACKUPSESSION: No restore session available----

---

dbmcli on PRD>db_state

State

ONLINE----

( NOTE:- after checking the dbstate i thought of initializing a complete backup on the database and on the logs as the log directory was full up after the system copy process)----

dbmcli -d PRD -u control,pass1234 medium_put data /backup/DATA0007 FILE DATA

OK----

prdserver1:sqdprd 5>

prdserver1:sqdprd 5> dbmcli -d PRD -u control,pass1234 db_connect

OK----

prdserver1:sqdprd 6> dbmcli -d PRD -u control,pass1234----

dbmcli on PRD>backup_start data

ERR

-24991,ERR_NODBSESSION: no database session available----

---

dbmcli on PRD>db_state

State

ONLINE----

---

dbmcli on PRD>db_admin

OK----

---

dbmcli on PRD>backup_start data

ERR

-24991,ERR_NODBSESSION: no database session available----

---

dbmcli on PRD>----

prdserver1:sqdprd 7> dbmcli -uUTL -u control,pass1234 backup_start data

Error! Connection failed to node (local) for database (no dbname):

-24875,ERR_NEEDADMI: The operating system user is not a member of the database administrators group

-24994,ERR_RTE: Runtime environment error

20130,UNIX user 'CONTROL' unknown----

prdserver1:sqdprd 8> dbmcli -uUTL -u control,pass1234 -d PRD backup_start data

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Data backup failed----

prdserver1:sqdprd 9> dbmcli -d PRD -u control,pass1234 db_state

State

ADMIN----

prdserver1:sqdprd 10>

prdserver1:sqdprd 10> dbmcli -d PRD -u control,pass1234 db_online

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Database state: OFFLINE

Internal errorcode, Error code 9050 "disk_not_accessible"

20017,RestartFilesystem failed with 'I/O error'----

prdserver1:sqdprd 11>

prdserver1:sqdprd 11> db_release----

db_release: Command not found.----

prdserver1:sqdprd 12> dbmcli -d PRD -u control,pass1234 db_release

OK----

prdserver1:sqdprd 13>

prdserver1:sqdprd 13> dbmcli -d PRD -u control,pass1234 db_online

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Database state: OFFLINE

Internal errorcode, Error code 9050 "disk_not_accessible"

20017,RestartFilesystem failed with 'I/O error'----

---

dbmcli on PRD>db_state

State

OFFLINE----

---

Thanks a lot in advance.

Pradeep

Dear Natalia,

I have forgotten to mention my ERP and the DB versions on the last reply:--

ERP ECC6 EHP1 SR1
~~MaxDB:-MAXDB 7.7 .06 Build 10,RDBMS,Number 51036887. startdb.log details as follows:~~--

Sat Oct 1 14:33:26 IST 2011

LOGFILE FOR STARTING DATABASE===================>>

Trying to start database ...

Sat Oct 1 14:33:26 IST 2011

Checking required environment variables===================>>

SAPSYSTEMNAME is >PRD<

Start database with xuserkey >c<===================>>

Sat Oct 1 14:33:26 IST 2011

Connect to the database to check the database state===================>>

dbmcli: connect check finished with return code: 0

Database not available===================>>

Sat Oct 1 14:33:26 IST 2011

Starting XServer

12916 XSERVER Found other running x_server with version 'U64/LIX86 7.7.06 Build 010-123-204-327'

12902 XSERVER started, 'already...'===================>>

Sat Oct 1 14:33:26 IST 2011

Starting database

Starting Database Instance...

Opening Database...

ERR

-24988,ERR_SQL: SQL error

-902,I/O error

3,Database state: OFFLINE

Internal errorcode, Error code 9050 "disk_not_accessible"

20017,RestartFilesystem failed with 'I/O error'===================>>

Sat Oct 1 14:33:36 IST 2011

Connect to the database to verify the database is now open

dbmcli check finished with return code: 0

Database start failed

startsap_DVEBMGS00.log details:---Trace of system startup/check of SAP System PRD on Fri Sep 30 17:20:06 IST 2011

Called command: /usr/sap/PRD/SYS/exe/run/startsap start

Starting Startup Agent sapstartsrv

Instance Service on host prdserver1 started

Starting SAP Instance DVEBMGS00

SAP-R/3-Startup Program Rel 701 V1.8 (2003/04/24)

Starting at 2011/09/30 17:20:17

Startup Profile: "/usr/sap/PRD/SYS/profile/START_DVEBMGS00_prdserver1"

Setup Environment Variables

(25811) SETENV LD_LIBRARY_PATH=/usr/sap/PRD/DVEBMGS00/exe:/usr/sap/PRD/DVEBMGS00/exe:/tmp/sapinst_exe.20140.1317369262:/usr/sap/PRD/SYS/exe/run:/sapdb/programs/lib

(25811) SETENV SHLIB_PATH=/usr/sap/PRD/DVEBMGS00/exe:

(25811) SETENV LIBPATH=/usr/sap/PRD/DVEBMGS00/exe:

Execute Pre-Startup Commands

(25812) Local: /usr/sap/PRD/SYS/exe/run/sapcpe pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1

(25822) Local: /usr/sap/PRD/SYS/exe/run/sapcpe pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1 list:/usr/sap/PRD/SYS/exe/run/sapcrypto.lst

(25823) Local: /usr/sap/PRD/DVEBMGS00/exe/sapmscsa pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1 -n

/usr/sap/PRD/DVEBMGS00/exe/sapmscsa: make new mode. SCSA currently non existent.

sapcscsa: SCSA defined. sapscsaId == 51511316 == 03120014

sapcscsa: SCSA attached at address 2b6048150000

sapcscsa: SCSA initialized.

/usr/sap/PRD/DVEBMGS00/log/SLOG00: No such file or directory

rslgwr1(20): rstrbopen cannot open pre-existing SysLog file.

/usr/sap/PRD/DVEBMGS00/exe/sapmscsa: finished.

(25824) Local: rm -f ms.sapPRD_DVEBMGS00

(25825) Local: ln -s -f /usr/sap/PRD/DVEBMGS00/exe/msg_server ms.sapPRD_DVEBMGS00

(25826) Local: rm -f dw.sapPRD_DVEBMGS00

(25827) Local: ln -s -f /usr/sap/PRD/DVEBMGS00/exe/disp+work dw.sapPRD_DVEBMGS00

(25828) Local: rm -f co.sapPRD_DVEBMGS00

(25829) Local: ln -s -f /usr/sap/PRD/DVEBMGS00/exe/rslgcoll co.sapPRD_DVEBMGS00

(25830) Local: rm -f se.sapPRD_DVEBMGS00

(25831) Local: ln -s -f /usr/sap/PRD/DVEBMGS00/exe/rslgsend se.sapPRD_DVEBMGS00

(25832) Local: rm -f ig.sapPRD_DVEBMGS00

(25833) Local: ln -s -f /usr/sap/PRD/DVEBMGS00/exe/igswd_mt ig.sapPRD_DVEBMGS00

Starting Programs

30.09.2011 17:20:17

ShmDetach

(25837) Starting: local ms.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1

(25838) Starting: local dw.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1

(25839) Starting: local co.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1 -F

(25840) Starting: local se.sapPRD_DVEBMGS00 pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1 -F

(25841) Starting: local ig.sapPRD_DVEBMGS00 -mode=profile pf=/usr/sap/PRD/SYS/profile/PRD_DVEBMGS00_prdserver1

(25811) Waiting for Child Processes to terminate.

Instance on host prdserver1 started

(25811) **** 2011/10/01 11:48:36 Caught Signal to Stop all Programs. ****

(25811) Parent Shutdown at 2011/10/01 11:48:38

(25811) Stop Child Process: 25841

(25811) Wait 300 sec for Process 25841 terminating...

(25811) Stop Child Process: 25840

(25811) Wait 300 sec for Process 25840 terminating...

(25811) Stop Child Process: 25839

(25811) Wait 300 sec for Process 25839 terminating...

(25811) Stop Child Process: 25838

(25811) Wait 300 sec for Process 25838 terminating...

(25811) Stop Child Process: 25837

(25811) Wait 300 sec for Process 25837 terminating...

Execute Post-Shutdown Commands

01.10.2011 11:49:01

ShmDetach

(25811) Exiting with Return-Code 0. (Ok)

dbm.knl file details:--

4E857EB00006|DAT_000000273|RESTORE |2011-09-24 22:26:56|2011-09-24 22:26:56|2011-09-30 14:41:50|2011-09-30 15:27:10| 14870005| |NO |dbrecover | 13059672| 1| 0| |

4E859959000A| |HISTLOST | | |2011-09-30 15:56:33| | | | | | | | 0| |

4E85A77F0012| |HISTLOST | | |2011-09-30 16:56:55| | | | | | | | 0| |

dbm.mdf file details:---

4E857EB00006|DAT_000000273|dbrecover |vftFile |NO | 0| 8|S|/backup/backup16032011

dbm.mmm file details:----

[dbrecover]

LOCATION=/backup/backup16032011

TYPE=FILE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=8

OVERWRITE=NO

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=NONE

INTERVAL=0

CREATED=20110930133939

MODIFIED=20110930133939

thanks in advance,pradeep

Ask a Question

Top Q&A Solution Author

User

Count