Hi, what do you mean by "I tried to have full backup": Did you backup data or did you restore data?
If you restored data it may be the case that your LogVolume does not match the restored state of your Datavolume. Have a look into your backup-history and see which logbackups you have to recover. regards, Martin -----Ursprüngliche Nachricht----- Von: Ertan Kucukoglu [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. Juli 2004 10:27 An: [EMAIL PROTECTED] Betreff: db_online problem Dear All, I have a db on FreeBSD system. SapDB version is 7.4.3.27. Recently I tried to have full backup. I do not understand what I did wrong but at the moment my db can not go inline. ozlerplastik# /usr/local/sapdb/depend/bin/dbmcli -d OZLER -u dbm,dbm db_admin OK ozlerplastik# /usr/local/sapdb/depend/bin/dbmcli -d OZLER -u dbm,dbm db_online ERR -24988,ERR_SQL: sql error -8888,connection broken ozlerplastik# Below are just the lines from my "knldiag" file for db. I put ERR lines and just above those ERR liens. ------------------------------------------------- 2004-07-15 11:07:52 11 12 Pager Start Read Converter 2004-07-15 11:07:52 11 13 Pager Stop Read Converter, Pages: 8 IO: 8 2004-07-15 11:07:52 11 54003 dynpool DATA_CACHE_REGIONS : 8 2004-07-15 11:07:52 11 54003 dynpool B20_DATACACHE_HEAD : 79784 2004-07-15 11:07:52 11 54003 dynpool DATACACHE head num item: 9973 2004-07-15 11:07:52 11 54003 dynpool DATACACHE head item siz: 8 2004-07-15 11:07:52 11 54003 dynpool DATACACHE task queue : 1440 2004-07-15 11:07:52 11 54003 dynpool US + SV + DW + 8 : 90 2004-07-15 11:07:52 11 54003 dynpool DATACACHE taskq elem : 16 2004-07-15 11:07:52 11 54003 dynpool B20_DATACACHE_TASKQ : 81224 2004-07-15 11:07:52 11 54003 dynDATA DATA_CACHE_PAGES : 122 2004-07-15 11:07:52 11 54003 dynpool B20_DATACACHE_CB : 8296 2004-07-15 11:07:52 11 54003 dynpool DATACACHE num cblocks : 122 2004-07-15 11:07:52 11 54003 dynpool DATACACHE cblock size : 68 2004-07-15 11:07:52 11 54003 dynpool DYNP_B20_DATACACHE : 716160 2004-07-15 11:07:52 11 54003 dynDATA DYND_B20_DATACACHE : 976 2004-07-15 11:07:52 11 54003 dynpool TREELOCK_HEAD_LIST all : 4036 2004-07-15 11:07:52 11 54003 dynpool DATA_CACHE_PAGES*10/par: 1009 2004-07-15 11:07:52 11 54003 dynpool TREELOCK_HEAD_LIST elem: 4 2004-07-15 11:07:52 11 54003 dynpool TREELOCK_LIST all : 7104 2004-07-15 11:07:52 11 54003 dynpool (USER + SERVER + 2) * 2: 148 2004-07-15 11:07:52 11 54003 dynpool TREELOCK_LIST elem : 48 2004-07-15 11:07:52 11 54003 dynpool TREE_LOCK region count : 8 2004-07-15 11:07:52 11 54003 dynpool DYNP_B77_TREE_LOCK : 89120 2004-07-15 11:07:52 11 54003 dynpool DYNP_K51_LOCK_LIST : 901216 2004-07-15 11:07:52 11 54003 dynpool LOCK maxlocks : 2960 2004-07-15 11:07:52 11 54003 dynpool LOCK items : 11300 2004-07-15 11:07:52 11 54003 dynpool LOCK Regions : 24 2004-07-15 11:07:52 11 54003 dynpool LOCK TransRegions : 8 2004-07-15 11:07:52 11 54003 dynpool LOCK RegionGlob+Space : 2688 2004-07-15 11:07:52 11 54003 dynpool LOCK TransGlob : 640 2004-07-15 11:07:52 11 54003 dynpool LOCK SupplyItemsPerRgn : 100 2004-07-15 11:07:52 11 54003 dynpool LOCK SupplySize : 172800 2004-07-15 11:07:52 11 54003 dynpool LOCK RowHash entries : 2960 2004-07-15 11:07:52 11 54003 dynpool LOCK TabHash entries : 592 2004-07-15 11:07:52 11 54003 dynpool LOCK Row+Tab hash size : 14336 2004-07-15 11:07:52 11 54003 dynpool LOCK Trans entries : 296 2004-07-15 11:07:52 11 54003 dynpool LOCK trans_list size : 49792 2004-07-15 11:07:52 11 54003 dynpool LOCK TransPtrList : 1184 2004-07-15 11:07:52 11 54003 dynpool LOCK TransHash entries : 296 2004-07-15 11:07:52 11 54003 dynpool LOCK TransHash size : 1280 2004-07-15 11:07:52 11 54003 dynpool LOCK SupplyPoolSegments: 89 2004-07-15 11:07:52 11 54003 dynpool LOCK SupplyPoolSize : 642592 2004-07-15 11:07:52 11 54003 dynpool LOCK ObjColl_list size : 9472 2004-07-15 11:07:52 11 54003 dynpool LOCK ObjReq_list size : 4736 2004-07-15 11:07:52 11 3 Log Expected ioseq 9095, found -1--1 on off 1715 2004-07-15 11:07:52 11 ERR 0 SAPDBErr Assertion of state FreeLog failed! 2004-07-15 11:07:52 11 ERR 11196 DBCRASH vabort:Emergency Shutdown, Log_ArchiveLog.cpp: 409 2004-07-15 11:07:52 11 ERR 11599 BTRACE ----> Emergency Stack Back Trace <---- 2004-07-15 11:07:52 11 ERR 11599 BTRACE (0):0x8493d24 [0x29e7a64c](0x0,0x0,0x0,0x29e7a8d4) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (1):0x8493c9a [0x29e7a66c](0x0,0x0,0x29e7a6ac,0x849a074) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (2):0x849a074 [0x29e7a67c](0x29e7a8d4,0x9,0x0,0x1) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (3):0x85aab1d [0x29e7a6ac](0x1,0x1,0x860de2f,0x860de80) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (4):0x8547d84 [0x29e7a6dc](0x29e7a8d4,0x85f3f0a,0x861ea48,0x199) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (5):0x8550167 [0x29e7aa9c](0x2b30d8f8,0x25,0x0,0x1386) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (6):0x8357710 [0x29e7aadc](0x873d900,0x25,0x2,0x0) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (7):0x839b8ea [0x29e7ab7c](0x25,0x29e7bff6,0x4161c0,0x4161c0) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (8):0x831df67 [0x29e7ac6c](0x29e7bfd4,0x2b75b924,0x2b75b92c,0x0) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (9):0x811c832 [0x29e7acbc](0x29e7b378,0x29e7b144,0x29e7acec,0x81a3b2b) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (10):0x81a3b2b [0x29e7accc](0x29e7b144,0x29e7ace6,0x0,0x8722f00) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (11):0x81a31d8 [0x29e7acec](0x29e7b144,0x34,0x0,0x849b02d) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (12):0x81a42fe [0x29e7ad1c](0x29e7b144,0x29e7ad34,0x29e7aeb4,0x40f63b58) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (13):0x821cbc6 [0x29e7aefc](0x29e7b144,0x29e7af24,0x29e7af1b,0x29e7af24) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (14):0x82f7f26 [0x29e7af4c](0x29e7b144,0x29e7af7a,0x29e7af83,0x7) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (15):0x82f7a98 [0x29e7b00c](0x29e7b144,0x2,0x29e7b168,0x29e7b038) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (16):0x82f8227 [0x29e7b02c](0x29e7b144,0x60,0x8f20,0x30048098) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (17):0x82f8698 [0x29e7b04c](0x29e7b144,0x0,0x29e7b112,0x29e7b07b) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (18):0x8101651 [0x29e7b0ec](0x29e7b144,0x29e7b112,0x29e7b112,0x29e7b113) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (19):0x8101833 [0x29e7b11c](0x29e7b144,0x4,0x0,0x0) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (20):0x81018ec [0x29e7c76c](0x29e7cf44,0x1,0x16,0x29e7c7c4) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (21):0x8474e04 [0x29e7c78c](0x29e7cf44,0x29e7cec4,0x8716480,0x3a000) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (22):0x8101894 [0x29e7cf2c](0x29e7cf44,0xc,0x0,0x0) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (23):0x84bb306 [0x29e7cfac](0x3281,0x3,0x860c469,0x86131a9) 2004-07-15 11:07:52 11 ERR 11599 BTRACE (24):0x84bb193 [0x29e7cfdc](0x50016fdc,0x0,0x29e7cff4,0x28728303) 2004-07-15 11:07:52 11 ERR 11599 BTRACE *** Error in stack backtrace: Signal 10 in eo670_UnixFillCallArray(OutputOnly) 2004-07-15 11:07:52 11 ERR 11599 BTRACE ----> Module List <---- 2004-07-15 11:07:52 11 ERR 11599 BTRACE FREEBSD : /proc/65338/map : not supported yet. 2 2004-07-15 11:07:52 11 ERR 11599 BTRACE |.text Start |.text End | Module File Name 2004-07-15 11:07:52 11 ERR 11599 BTRACE 2004-07-15 11:07:52 11 ERR 11599 BTRACE ----> Symbolic Stack Back Trace <---- 2004-07-15 11:07:52 11 ERR 11599 BTRACE *** Error in stack backtrace: Signal 10 in eo670_UnixFillCallArray 2004-07-15 11:07:52 11 12820 EXCEPT calling ak dump for T37 2004-07-15 11:07:52 11 ERR 11196 DBCRASH vabort:Emergency Shutdown, Task: 37 2004-07-15 11:07:52 11 12696 DBSTATE Change DbState to 'KILL'(28) 2004-07-15 11:07:52 9 12825 TASKING state 28 before shutkill(1) 2004-07-15 11:07:52 11 12697 DBSTATE Resuming tracewriter 2004-07-15 11:07:52 11 12825 TASKING state 28 before shutkill(1) 2004-07-15 11:07:52 9 12825 TASKING state 28 before shutkill(1) 2004-07-15 11:07:52 3 12696 DBSTATE Change DbState to 'TRACE_WRITER_WAIT'(28) 2004-07-15 11:07:52 11 12768 UKT3 stopped 2004-07-15 11:07:52 9 12619 TASKING Releasing tracewriter 2004-07-15 11:07:55 1 12624 EXCEPT Kernel aborts --------------------------------------- current write position ----------------- Any help is appreciated. -- 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
