on 03-25-2010 10:01 AM
Hello.
I'm posting this because I ran out of ideas and google searches.
So my current problem is, I got a MaxDB server that was already in production because the person that was doing maintenance had to leave so I got it. So now I'm trying to clone a database instance (let's call it MAXDB1) to another machine that is going to be a test server.
I've tried doing a complete backup of MAXDB1 in the production machine and recover it on the test server, but sadly it always gives an error when I try to make it go online. I was wondering if I could get any pointers to any kind of documentation that shows me how to make this work or any other solution that could get the same result I currently need.
Production OS : Red Hat
Test OS : Kubuntu
MaxDB kerner Version : 7.7 on both machines.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> I've tried doing a complete backup of MAXDB1 in the production machine and recover it on the test server, but sadly it always gives an error when I try to make it go online.
well - we would maybe be able to help you but how should we if you don't give us any information what kind of error you get? Unfortunately the Crystal Ball to look into is not yet invented (no offense)
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Regarding the error, this is what I'm getting on the database manager GUI:
-24988 SQL error [db_online -f]; -31001, (no error text available from database kernel)
This is what I get on the database errors file:
Thread 0x29D Task 108 2010-03-25 15:00:09 AdminMsg 0: 4BAB7A790052 0000 RST RESTART
Thread 0x29D Task 108 2010-03-25 15:00:10 AdminMsg 0: 4BAB7A7A0054 0000 RST RETURNCODE *1001;RESTART
Thread 0x29D Task 108 2010-03-25 15:00:12 ERR DBCRASH 11196: vabort:Emergency Shutdown, Kernel_Administration.cpp: 704
Thread 0x29D Task 108 2010-03-25 15:00:12 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=704
2010-03-25 15:00:12 ERR Admin 2: A fatal error caused EMERGENCY SHUTDOWN. core is written,_FILE=vgg999.cpp,_LINE=62
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
> Emergency stack backtrace <----
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Using 'x86 GCC frame trace' for stack tracing
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (0):0x091c1c60 [F0xa9838b18](0xa9838b40,0x0,0x9413e3a,0x9000389)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (1):0x0909bfc6 [F0xa9838c28](0x0,0x9728840,0xa9838c58,0x96b4b18)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (2):0x0909c01c [F0xa9838c48](0x9728840,0x1,0x1,0x16b4b18)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (3):0x09093e8d [F0xa9838c68](0x97290a0,0xa983ce60,0x1,0x9401de8)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (4):0x08fb95fe [F0xa9838c98](0xa983ce60,0xa9838d30,0x93fb248,0x93fae28)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (5):0x08f538ee [F0xa9838d98](0xb738aa70,0xa9838e60,0x1,0x1)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (6):0x08a4a899 [F0xa9838ec8](0x1,0x2,0x48,0xa9838f30)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (7):0x085e9f18 [F0xa9839178](0xa98391ff,0x18d6,0x3,0xa98391f8)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (8):0x085ead25 [F0xa983b328](0xa983b8c0,0xa983b7f6,0xa983b34f,0x906de10)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (9):0x08f69b36 [F0xa983b778](0xa983b7f6,0x1,0xb736e360,0xa42362c8)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (10):0x08f69f88 [F0xa983cec8](0xb7518b40,0x2,0xa983cee8,0x9008bed)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (11):0x090498da [F0xa983cf98](0xb7518b40,0xb736e1e0,0xa983cfb8,0x0)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (12):0x09049c78 [F0xa983cfb8](0xb7518b40,0x942293f,0x0,0x96b4b18)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (13):0x09158ae6 [F0xa983cfe8](0x0,0x0,0x307da,0x190004)
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
> Symbolic stack backtrace <----
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 0: ZN17RTEDiagCallStack18TraceStackSymbolicEPK19RTEDiag_RegisterSet + 0x43
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x091c1b53 (0x091c1b10+0x43) FP: 0xa9838b18
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa9838b40, 0x0, 0x9413e3a, 0x9000389
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 1: ZN22RTEKernelCrashHandler12AbortHandlerEP23RTEDiag_FaultDescriptorPv + 0x234
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x0909bfd4 (0x0909bda0+0x234) FP: 0xa9838c28
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x0, 0x9728840, 0xa9838c58, 0x96b4b18
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 2: ZN22RTEKernelCrashHandler5AbortEb + 0x3c
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x0909c01c (0x0909bfe0+0x3c) FP: 0xa9838c48
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x9728840, 0x1, 0x1, 0x16b4b18
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 3: ZN21RTEKernelTermination5AbortERK20SAPDBErr_MessageListb + 0x6d
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x09093e8d (0x09093e20+0x6d) FP: 0xa9838c68
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x97290a0, 0xa983ce60, 0x1, 0x9401de8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 4: Z9RTECrashRK20SAPDBErr_MessageList + 0xde
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08fb95fe (0x08fb9520+0xde) FP: 0xa9838c98
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa983ce60, 0xa9838d30, 0x93fb248, 0x93fae28
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 5: ZN21KernelAdministration7OfflineERK20SAPDBErr_MessageListbb + 0x49e
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08f538ee (0x08f53450+0x49e) FP: 0xa9838d98
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb738aa70, 0xa9838e60, 0x1, 0x1
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 6: gg999Abort + 0x269
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08a4a899 (0x08a4a630+0x269) FP: 0xa9838ec8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x1, 0x2, 0x48, 0xa9838f30
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 7: Z11ak93sendingR14SQLManContextiiR10tsp00_EnumI18tsp01_CommErr_EnumLi11EhE + 0x348
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x085e9f18 (0x085e9bd0+0x348) FP: 0xa9839178
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa98391ff, 0x18d6, 0x3, 0xa98391f8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 8: Z17a93user_commandsR14SQLMan_ContextRbS1_ + 0x405
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x085ead25 (0x085ea920+0x405) FP: 0xa983b328
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa983b8c0, 0xa983b7f6, 0xa983b34f, 0x906de10
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 9: Z7SQLTaskR14SQLManContextP22Kernel_DatabaseContextR13RTETask_ITaskRbb + 0x76
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08f69b36 (0x08f69ac0+0x76) FP: 0xa983b778
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa983b7f6, 0x1, 0xb736e360, 0xa42362c8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 10: Z11KernelMainR13RTETask_ITask + 0x3b8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08f69f88 (0x08f69bd0+0x3b8) FP: 0xa983cec8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb7518b40, 0x2, 0xa983cee8, 0x9008bed
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 11: ZN12RTETaskTask14KernelTaskMainEv + 0xaa
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x090498da (0x09049830+0xaa) FP: 0xa983cf98
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb7518b40, 0xb736e1e0, 0xa983cfb8, 0x0
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 12: ZN12RTETaskTask4MainERS_ + 0x68
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x09049c78 (0x09049c10+0x68) FP: 0xa983cfb8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb7518b40, 0x942293f, 0x0, 0x96b4b18
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 13: Z23en88CallKernelTaskMainv + 0xa6
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x09158ae6 (0x09158a40+0xa6) FP: 0xa983cfe8
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x0, 0x0, 0x307da, 0x190004
Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel
Thread 0x29D Task - 2010-03-25 15:00:14 ERR Messages 7: Begin of dump of registered messages,_FILE=Msg_List.cpp,_LINE=3539
Thread 0x29D Task - 2010-03-25 15:00:12 ERR Admin 2: A fatal error caused EMERGENCY SHUTDOWN. core is written,_FILE=vgg999.cpp,_LINE=62
Thread 0x29D Task - 2010-03-25 15:00:12 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=704
2010-03-25 15:00:12 ERR Admin 2: A fatal error caused EMERGENCY SHUTDOWN. core is written,_FILE=vgg999.cpp,_LINE=62
Thread 0x29D Task -Thread 0x29D Task - 2010-03-25 14:45:38 RTEHSS 13951: No hot standby node configured -> No HotStandby configuration
Thread 0x29D Task - 2010-03-25 15:00:14 ERR Messages 8: End of the message list registry dump,_FILE=Msg_List.cpp,_LINE=3567
Thread 0x29D Task - 2010-03-25 15:00:14 ERR AK CACHE 51105: DUMPING SESSION CATCACHE: 1
Thread 0x29B Task - 2010-03-25 15:00:15 ERR RTEKernel 102: Kernel exited without core and exit status 0x6,_FILE=RTEKernel_Termination.cpp,_LINE=634
Thread 0x29B Task - 2010-03-25 15:00:15 ERR RTEKernel 98: Kernel exited due to signal 6 (SIGABRT),_FILE=RTEKernel_Termination.cpp,_LINE=680
Thread 0x29B Task - 2010-03-25 15:00:15 MsgOutput 28: ___ Stopping GMT 2010-03-25 15:00:15 7.7.06 Build 009-121-202-944
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.