SQL error - 20013, Admin command cannot enter critical state 'Backup'

[former_member313130]

Hello,

I have a problem to start (ADMIN --> ONLINE) our MaxDB of our Solution Manager.

I get the following error message:

SQL error

-104, DBM command impossible at this time

- 20013, Admin command cannot enter critical state 'Backup'

Has someone an idea how to solve this issue?

Thanks in advance for help!

Kind regards,

Joern

[former_member313130 · Accepted solution]

Hi,

that's my problem. I can't start the database:

af4lm139:sm2adm 51> dbmcli -d SM2 -u control,xxx db_admin

OK

af4lm139:sm2adm 51> dbmcli -d SM2 -u control,xxx db_warm

...

Can not flush file '/sapdb/SM2/data/wrk/dbmsrv_af4lm139.err'.

....

-

---

dbmsrv_af4lm139.err:

..............

PID 598: -

---

PID 598: 25: RTEThread_Thread::AppointMainThreadToThreadObject(int, SAPDBErr_MessageList&) + 0x392

PID 598: Symbol: ZN16RTEThreadThread31AppointMainThreadToThreadObjectEiR20SAPDBErr_MessageList

PID 598: SFrame: IP: 0x000000000087d8f2 (0x000000000087d560+0x392)

PID 598: Module: /sapdb/SM2/db/pgm/dbmsrv

PID 598: -

---

PID 598: 26: main + 0x105

PID 598: SFrame: IP: 0x000000000040bf15 (0x000000000040be10+0x105)

PID 598: Module: /sapdb/SM2/db/pgm/dbmsrv

PID 598: -

---

PID 598: 27: __libc_start_main + 0xf4

PID 598: SFrame: IP: 0x00002adc11d1a304 (0x00002adc11d1a210+0xf4)

PID 598: Module: /lib64/libc-2.4.so

PID 598: -

---

PID 598: 28: __gxx_personality_v0@@CXXABI_1.3 + 0x10a

PID 598: SFrame: IP: 0x000000000040bd5a (0x000000000040bc50+0x10a)

PID 598: Source: start.S:116

PID 598: Module: /sapdb/SM2/db/pgm/dbmsrv

-

---

Kind regards,

Joern

[former_member188883 · Accepted solution]

Hi Joern,

Can you make the dabase in admin mode. Later take a full database backup.

Post this backup try to make the database online.

Regards,

Deepak Kori

[former_member313130]

Hi Deepak,

thanks for your help - with the last tip I was able to start the database again!

Kind regards,

Joern

[former_member313130]

Hi,

that's my problem. I can't start the database:

af4lm139:sm2adm 51> dbmcli -d SM2 -u control,xxx db_admin

OK

af4lm139:sm2adm 51> dbmcli -d SM2 -u control,xxx db_warm

...

Can not flush file '/sapdb/SM2/data/wrk/dbmsrv_af4lm139.err'.

....

-

---

dbmsrv_af4lm139.err:

..............

PID 598: -

---

PID 598: 25: RTEThread_Thread::AppointMainThreadToThreadObject(int, SAPDBErr_MessageList&) + 0x392

PID 598: Symbol: ZN16RTEThreadThread31AppointMainThreadToThreadObjectEiR20SAPDBErr_MessageList

PID 598: SFrame: IP: 0x000000000087d8f2 (0x000000000087d560+0x392)

PID 598: Module: /sapdb/SM2/db/pgm/dbmsrv

PID 598: -

---

PID 598: 26: main + 0x105

PID 598: SFrame: IP: 0x000000000040bf15 (0x000000000040be10+0x105)

PID 598: Module: /sapdb/SM2/db/pgm/dbmsrv

PID 598: -

---

PID 598: 27: __libc_start_main + 0xf4

PID 598: SFrame: IP: 0x00002adc11d1a304 (0x00002adc11d1a210+0xf4)

PID 598: Module: /lib64/libc-2.4.so

PID 598: -

---

PID 598: 28: __gxx_personality_v0@@CXXABI_1.3 + 0x10a

PID 598: SFrame: IP: 0x000000000040bd5a (0x000000000040bc50+0x10a)

PID 598: Source: start.S:116

PID 598: Module: /sapdb/SM2/db/pgm/dbmsrv

-

---

Kind regards,

Joern

[former_member313130]

Hi Deepak,

I run the command and I got round about 33000 lines back:

-

---

ID UKT UNIX TASK APPL Current Timeout/ Region Wait

tid type pid state Priority cnt try item

T71 8 29246 User 0* Connect close 0 7564(s)

T72 8 29246 User 0* Connect close 0 7564(s)

T73 8 29246 User 0* Connect close 0 7564(s)

....

T171 4 29242 RedoRea Vsuspend (227) 0 160856(s)

T172 4 29242 RedoExe SyncRedo (232) 0 160856(s)

T173 4 29242 RedoExe SyncRedo (232) 0 160856(s)

T174 4 29242 RedoExe IO Wait (R) 0 18 160856(s)

.....

T169 9 29247 User 0* Connect close 0 8235(s)

T170 9 29247 User 0* Connect close 0 8235(s)

SERVERDB: SM2

The SERVERDB state is OFFLINE

-

---

Kind regards,

Joern

[former_member188883]

Hi ,

Your database SM2 is in offline state. Are you running any backup ?

if not, can you start your database directly by making it online and check the results.

Regards,

Deepak Kori

[former_member188883]

Hi,

Are you currently running a backup in admin mode?

What do you see when you enter

x_cons <SID> sh ac 1

Regards,

Deepak Kori