Dear All,
We are moving to SAPDB from small test server to big production server. New system and SapDB is setup. SAPDB versions are identical on both servers.
Everything is fine. I have old data in my previous server. I wanted to move old complete backup data to new server. After several hours of search in mailing list I had my complete backup and log file backup.
Everything is fine. I recovered data and log files. (I had some issues with log recovery. I suppose log file recovery is a little bit complicated in some cases)
After recovery; I try to stop and go to admin mode -> OK I try to go online in admin mode -> Error I try to go online in offline mode -> Error
Error is below: %dbmcli -d ozler -u <user>,<pass> db_online ERR -24988,ERR_SQL: sql error -8888,connection broken
Below is only ERR lines (several lines before and after) from my knldiag:
2004-07-03 12:17:01 11 54003 dynpool LOCK ObjReq_list size : 4864
2004-07-03 12:17:01 11 7 Log 1 queues, flushmode is 'MinimizeSpace', devstate is 'HistoryLost'
2004-07-03 12:17:01 11 8 Log Oldest not saved is ioseq -1 @ off 1
2004-07-03 12:17:01 11 10 Log LogVolume not completely written until now
2004-07-03 12:17:01 11 6 Log Restart from ioseq 3 @ off 4 to ioseq 3 @ off 4
2004-07-03 12:17:01 11 11 Log Result after checking the log device: 'Ok'
2004-07-03 12:17:01 12 43 Log recovering log from log_volume from IOSeq: '3'
2004-07-03 12:17:01 12 28 Log normal end of log found at off 4 lastseq 3.
2004-07-03 12:17:01 12 45 Log last-redo-read#1:TR-1(21)[EMAIL PROTECTED]'FinishOpenTrans':20040703:111259
2004-07-03 12:17:01 11 40 Log Savepoint requested by T40 reason 'Restart' (started).
2004-07-03 12:17:01 12 4 Pager SVP(1) Start Write Data
2004-07-03 12:17:01 12 5 Pager SVP(1) Stop Data IO, Pages: 0 IO: 0
2004-07-03 12:17:01 12 6 Pager SVP(2) Wait for last split, TaskId: 36
2004-07-03 12:17:01 12 7 Pager SVP(2) Stop Wait for last split, Pages: 0 IO: 0
2004-07-03 12:17:01 12 53070 SAVPOINT B20PREPARE_SVP: 23
2004-07-03 12:17:01 12 8 Pager SVP(3) Start Write Data
2004-07-03 12:17:02 12 9 Pager SVP(3) Stop Data IO, Pages: 1 IO: 1
2004-07-03 12:17:02 12 10 Pager SVP(3) Start Write Converter
2004-07-03 12:17:02 12 11 Pager SVP(3) Stop Converter IO, Pages: 1 IO: 1
2004-07-03 12:17:02 12 53071 SAVPOINT B20SVP_COMPLETED: 23
2004-07-03 12:17:02 11 53000 DATACACH Reduce Data Cache (pool): 1247
2004-07-03 12:17:02 11 52612 RESTART LOCAL: ready
2004-07-03 12:17:02 11 ERR 51361 RESTART CONTROL USER ALR. EXISTS; 0
2004-07-03 12:17:02 11 ERR 11599 BTRACE ----> Emergency Stack Back Trace <----
2004-07-03 12:17:02 11 ERR 11599 BTRACE (0):0x8493d24 [0x2e551a8c](0x0,0x0,0x0,0x2e551b44)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (1):0x8493c9a [0x2e551aac](0x0,0x0,0x2e551aec,0x849a074)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (2):0x849a074 [0x2e551abc](0x5845202e,0x53545349,0x30203b,0x0)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (3):0x844b34b [0x2e551aec](0x1,0x2e551b1c,0x2e551b44,0x1b)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (4):0x81a3319 [0x2e551b7c](0xc8a1,0x85d35aa,0x85db1fd,0x0)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (5):0x81a322c [0x2e551cec](0x2e552144,0x2e551d34,0x2e551eb4,0x849b02d)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (6):0x81a42fe [0x2e551d1c](0x2e552144,0x2e551d34,0x2e551eb4,0x40e6798d)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (7):0x821cbc6 [0x2e551efc](0x2e552144,0x2e551f24,0x2e551f1b,0x2e551f24)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (8):0x82f7f26 [0x2e551f4c](0x2e552144,0x2e551f7a,0x2e551f83,0x7)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (9):0x82f7a98 [0x2e55200c](0x2e552144,0x2,0x2e552168,0x2e552038)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (10):0x82f8227 [0x2e55202c](0x2e552144,0x60,0x8f20,0x2f90f098)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (11):0x82f8698 [0x2e55204c](0x2e552144,0x0,0x2e552112,0x2e55207b)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (12):0x8101651 [0x2e5520ec](0x2e552144,0x2e552112,0x2e552112,0x2e552113)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (13):0x8101833 [0x2e55211c](0x2e552144,0x4,0x0,0x0)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (14):0x81018ec [0x2e55376c](0x2e553f44,0x1,0x16,0x2e5537c4)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (15):0x8474e04 [0x2e55378c](0x2e553f44,0x2e553ec4,0x8716480,0x3a000)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (16):0x8101894 [0x2e553f2c](0x2e553f44,0xc,0x0,0x0)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (17):0x84bb306 [0x2e553fac](0x3281,0x3,0x860c469,0x86131a9)
2004-07-03 12:17:02 11 ERR 11599 BTRACE (18):0x84bb193 [0x2e553fdc](0x500183e8,0x0,0x2e553ff4,0x2872cb43)
2004-07-03 12:17:02 11 ERR 11599 BTRACE *** Error in stack backtrace: Signal 10 in eo670_UnixFillCallArray(OutputOnly)
2004-07-03 12:17:02 11 ERR 11599 BTRACE ----> Module List <----
2004-07-03 12:17:02 11 ERR 11599 BTRACE FREEBSD : /proc/11076/map : not supported yet. 2
2004-07-03 12:17:02 11 ERR 11599 BTRACE |.text Start |.text End | Module File Name
2004-07-03 12:17:02 11 ERR 11599 BTRACE
2004-07-03 12:17:02 11 ERR 11599 BTRACE ----> Symbolic Stack Back Trace <----
2004-07-03 12:17:02 11 ERR 11599 BTRACE *** Error in stack backtrace: Signal 10 in eo670_UnixFillCallArray
2004-07-03 12:17:02 11 12820 EXCEPT calling ak dump for T40
2004-07-03 12:17:02 11 ERR 11196 DBCRASH vabort:Emergency Shutdown, Task: 40
2004-07-03 12:17:02 11 12696 DBSTATE Change DbState to 'KILL'(28)
2004-07-03 12:17:02 11 12697 DBSTATE Resuming tracewriter
2004-07-03 12:17:02 11 12825 TASKING state 28 before shutkill(1)
2004-07-03 12:17:02 9 12825 TASKING state 28 before shutkill(1)
2004-07-03 12:17:02 9 12825 TASKING state 28 before shutkill(1)
2004-07-03 12:17:02 11 12768 UKT3 stopped
2004-07-03 12:17:02 9 12619 TASKING Releasing tracewriter
2004-07-03 12:17:06 1 12624 EXCEPT Kernel aborts
--------------------------------------- current write position -----------------
I did not understand problem. I searhed mailing list for "51361", "CONTROL USER ALR. EXISTS". No records exists. Is it possible to direct me?
I have backups in my hand. I can drop and re-create instance. On the other hand, I tried this several times without any success. I use bigger data and log sizes than backup server.
Fyi, If I create instance and use it as a fresh db, everything is all right. I usually prefer GUI to console during my recovery process. My GUI version is 7.4.3.30.
Regards,
-- Ertan Küçükoğlu [EMAIL PROTECTED] Ozler Plastik San. ve Tic. A.S. Tel: +90.212.676.6767 Fax: +90.212.676.8012
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
