Former Member

Jan 22, 2009 at 09:30 AM

Error after cloning an instance - maxdb 7.6

51 Views

Hi,

I am trying to clone a database in order to do some testing but it crashes when I execute the db_online command.

I issue the following commands to get the full data backup.

util_connect

medium_put MY_BACKUP "/tmp/my_backup" FILE DATA 0 8 NO

db_connect

backup_start MY_BACKUP

After the backup process is finished, I issue the following comands

to load the data backup in the new instance.

medium_put MY_BACKUP "/tmp/my_backup" FILE DATA 0 8 YES

db_admin

db_connect

db_activate RECOVER MY_BACKUP

db_online

Looks like db_activate works fine but db_online crashes.

---

>db_activate RECOVER MY_BACKUP

OK

Returncode 0

Date 20090122

Time 00092429

Server myserver

Database MYDATABASE

Kernel Version Kernel 7.6.05 Build 009-121-191-997

Pages Transferred 170536

Pages Left 0

Volumes 1

Medianame MY_BACKUP

Location /tmp/MY_BACKUP

Errortext

Label DAT_000001433

Is Consistent true

First LOG Page 670

Last LOG Page

DB Stamp 1 Date 20090122

DB Stamp 1 Time 00085015

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 170515

Devices Used 1

Database ID myserver:MYINSTANCE_20090122_085318

Max Used Data Page 0

Converter Page Count 112

---

>db_online

ERR

-24988,ERR_SQL: SQL error

-31001,(no error text available from database kernel)

Looking at knldiag.err I see the following errors:

2009-01-21 13:38:37 --- Starting GMT 2009-01-21 12:38:37 7.6.05 Build 009-121-191-997

2009-01-21 13:54:59 6787 ERR 51261 TRIGGER system trigger failed with rc *1001

2009-01-21 13:55:01 6787 ERR 3 Admin Database state: OFFLINE

2009-01-21 13:55:01 6787 ERR 2 Admin + A fatal error caused EMERGENCY SHUTDOWN. core is written

2009-01-21 13:55:01 6787 ERR 11196 DBCRASH vabort:Emergency Shutdown, Kernel_Administration.cpp: 619

2009-01-21 13:55:01 6787 ERR 11599 BTRACE -

> Emergency Stack Back Trace <----

...

2009-01-21 13:55:01 6787 ERR 11599 BTRACE -

> End of Stack Back Trace <----

2009-01-21 13:55:02 6787 ERR 7 Messages Begin of dump of registered messages

2009-01-21 13:55:02 6787 ERR 2 Admin A fatal error caused EMERGENCY SHUTDOWN. core is written

2009-01-21 13:55:02 6787 ERR 8 Messages End of the message list registry dump

2009-01-21 13:55:02 6787 ERR 51105 AK CACHE AK00001.dmp written: 0

2009-01-21 13:55:02 6787 ERR 11196 DBCRASH vabort:Emergency Shutdown, Task: 207

2009-01-21 13:55:02 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x200

2009-01-21 13:55:02 0 ERR 12010 DBCRASH Kernel exited exit code 2

2009-01-21 13:55:02 ___ Stopping GMT 2009-01-21 12:55:02 7.6.05 Build 009-121-191-997

Thanks in advance,

Xavi

Edited by: Xavi Graci on Jan 22, 2009 2:30 PM