Hi, I assume that you set the log-autooverwrite to on. As a workaround you should switch it off again and then you should be able to restart.
Could you please send the contents of the file dbm.prt and dbm.utl for further analysis of this error? regards, Martin -----Ursprüngliche Nachricht----- Von: Ertan Kucukoglu [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. Juli 2004 07:57 An: Brunzema, Martin Cc: [EMAIL PROTECTED] Betreff: Re: AW: db_online problem Hi, I am going to replace current system. So, I backup data. I did not restore. Below is my backup history. I see several HISTLOST messages. dbmcli on ozler>backup_history_list OK END 4030AECE0002| |HISTLOST |2004-02-16 13:51:42| |2004-02-16 13:51:42| | | | | | | | 0| | 4030AEED0001|DAT_00001|SAVE COLD|2004-02-16 13:52:04|2004-02-16 13:52:04|2004-02-16 13:52:13|2004-02-16 13:52:13| 1012| |NO |data | 240| 1| 0| | 407CDA500003|DAT_00002|SAVE WARM|2004-04-14 09:29:36|2004-04-14 09:29:36|2004-04-14 09:29:36|2004-04-14 09:29:37| 2264| |NO |data | 496| 1| 0| | 407CF0CA0001|DAT_00003|SAVE COLD|2004-04-14 11:04:45|2004-04-14 11:04:45|2004-04-14 11:05:30|2004-04-14 11:05:32| 2265| |NO |data | 496| 1| 0| | 40E3EBC80001|DAT_00004|SAVE COLD|2004-07-01 13:46:57|2004-07-01 13:46:57|2004-07-01 13:47:36|2004-07-01 13:47:37| 9091| |NO |data | 536| 1| 0| | 40E64B520001|LOG_00001|SAVE COLD|2004-02-16 13:51:45|2004-04-22 17:37:25|2004-07-03 08:59:46|2004-07-03 08:59:48| 0| 8887| |auto | 1688| 1| 0| | 40E64B520001|LOG_00002|SAVE COLD|2004-04-22 17:37:25|2004-07-01 13:48:00|2004-07-03 08:59:48|2004-07-03 08:59:48| 8888| 9094| |auto | 64| 1| 0| | 40E64E1B0002| |HISTLOST |2004-07-03 09:11:39| |2004-07-03 09:11:39| | | | | | | | 0| | 40E64E770003|DAT_00005|SAVE COLD|2004-07-01 13:48:00|2004-07-01 13:48:00|2004-07-03 09:13:11|2004-07-03 09:13:13| 9094| |NO |data | 536| 1| 0| | 40E64EBA0006| |HISTLOST |2004-07-03 09:14:18| |2004-07-03 09:14:18| | | | | | | | 0| | 40E6507C0007|DAT_00006|SAVE COLD|2004-07-01 13:48:00|2004-07-01 13:48:00|2004-07-03 09:21:48|2004-07-03 09:21:48| 9094| |NO |data | 536| 1| 0| | --- dbmcli on ozler> Hope this may help. Regards, Ertan Küçükoğlu [EMAIL PROTECTED] Ozler Plastik San. ve Tic. A.S. Tel: +90.212.676.6767 Fax: +90.212.676.8012 Brunzema, Martin wrote: >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. > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
