Hi Georg, 2003-03-12 09:27:54 2517 ERR 59 Log RESTART ERROR '6416' => SHUTDOWN IS FORCED
the internal base error 6416 means that "util_activate dba,dba " never was executed! Yes I know it's in your script, but it's look like it wasn't executed. Perhaps the database crashed after the system dba was generated? Please execute the follwoing sequence again: dbmcli -d <DBNAME> -u <DBM,DBMPASSWD> db_admin util_connect util_activate dba,dba db_state (=> should be warm/online ) db_offline (=> shutdown database and made all changes persistent ) db_online load_systab -u dba,dba -ud domain In case of an error please send me the dbm.utl, dbm.prt, knldiag.err and the knldiag. Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message----- From: Georg Thome [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 12. M�rz 2003 10:41 To: [EMAIL PROTECTED] Subject: -24895,ERR_SHUTDOWN: shutdown of database occured Hi all, we've got a - SuSE 7.3 Linux system, - kernel 2.4.20 and - Sapdb 7.4.3.14 running. As a filesystem for the working directory of Sapdb we are using a software-RAID 1 with a ext3 filesystem on it. param_startsession param_init param_put MAXUSERTASKS 10 param_checkall param_commitsession param_addvolume 1 LOG LOG_001 F 25000 param_addvolume 1 DATA DAT_001 F 3400000 db_admin util_connect util_execute INIT CONFIG util_activate dba,dba load_systab -ud db after creation of a database with the script above, which should create a log with 200MByte and a devspace with approx. 27GByte located on the Raid 1 partition, the database is not able to start. As I can see out of the diag file the devspaces are started correct. Ok I think I have used the wrong password for the domain user, but the load_systab command should be not the reason. After setting up the db_warm command in the dbmcli: ERR -24895,ERR_SHUTDOWN: shutdown of database occured -71,connection broken TIA for your help Georg knldiag-file: ... <snip-snap> 2003-03-12 09:17:15 2517 11007 COMMUNIC wait for connection T24 2003-03-12 09:17:16 2491 11000 New Kernel State 'ADMIN'(22) ======================================= end of startup part ==================== 2003-03-12 09:17:16 2491 11570 startup complete 2003-03-12 09:17:16 2492 11561 COMMUNIC Connecting T24 local 2480 2003-03-12 09:17:16 2517 11561 COMMUNIC Connected T24 local 2480 2003-03-12 09:17:16 2517 11560 COMMUNIC Releasing T24 2003-03-12 09:17:16 2517 11007 COMMUNIC wait for connection T24 2003-03-12 09:17:16 2492 11561 COMMUNIC Connecting T24 local 2480 2003-03-12 09:17:16 2517 11561 COMMUNIC Connected T24 local 2480 2003-03-12 09:17:16 2517 11560 COMMUNIC Releasing T24 2003-03-12 09:17:16 2517 11007 COMMUNIC wait for connection T24 2003-03-12 09:27:53 2492 11561 COMMUNIC Connecting T24 local 2480 2003-03-12 09:27:53 2517 11561 COMMUNIC Connected T24 local 2480 2003-03-12 09:27:53 2493 11597 IO Open 'DAT_001' successfull, fd: 19 2003-03-12 09:27:53 2624 12821 TASKING Thread 2624 starting 2003-03-12 09:27:53 2493 11597 IO Open 'DAT_001' successfull, fd: 20 2003-03-12 09:27:53 2624 11565 startup DEVi started 2003-03-12 09:27:53 2625 12821 TASKING Thread 2625 starting 2003-03-12 09:27:53 2517 11000 vattach 'DAT_001' devno 1 T24 succeeded 2003-03-12 09:27:53 2625 11565 startup DEVi started 2003-03-12 09:27:54 2493 11597 IO Open 'LOG_001' successfull, fd: 22 2003-03-12 09:27:54 2626 12821 TASKING Thread 2626 starting 2003-03-12 09:27:54 2493 11597 IO Open 'LOG_001' successfull, fd: 23 2003-03-12 09:27:54 2626 11565 startup DEVi started 2003-03-12 09:27:54 2627 12821 TASKING Thread 2627 starting 2003-03-12 09:27:54 2517 11000 vattach 'LOG_001' devno 2 T24 succeeded 2003-03-12 09:27:54 2627 11565 startup DEVi started 2003-03-12 09:27:54 2517 12 Pager Start Read Converter 2003-03-12 09:27:54 2517 13 Pager Stop Read Converter, Pages: 4 IO: 4 2003-03-12 09:27:54 2517 54003 dynpool DATA_CACHE_REGIONS : 8 2003-03-12 09:27:54 2517 54003 dynpool B20_DATACACHE_HEAD : 79784 2003-03-12 09:27:54 2517 54003 dynpool DATACACHE head num item: 9973 2003-03-12 09:27:54 2517 54003 dynpool DATACACHE head item siz: 8 2003-03-12 09:27:54 2517 54003 dynpool DATACACHE task queue : 608 2003-03-12 09:27:54 2517 54003 dynpool US + SV + DW + 8 : 38 2003-03-12 09:27:54 2517 54003 dynpool DATACACHE taskq elem : 16 2003-03-12 09:27:54 2517 54003 dynpool B20_DATACACHE_TASKQ : 80392 2003-03-12 09:27:54 2517 54003 dynDATA DATA_CACHE_PAGES : 1248 2003-03-12 09:27:54 2517 54003 dynpool B20_DATACACHE_CB : 84864 2003-03-12 09:27:54 2517 54003 dynpool DATACACHE num cblocks : 1248 2003-03-12 09:27:54 2517 54003 dynpool DATACACHE cblock size : 68 2003-03-12 09:27:54 2517 54003 dynpool DYNP_B20_DATACACHE :1322048 2003-03-12 09:27:54 2517 54003 dynDATA DYND_B20_DATACACHE : 9984 2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_HEAD_LIST all : 40028 2003-03-12 09:27:54 2517 54003 dynpool DATA_CACHE_PAGES*10/par: 10007 2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_HEAD_LIST elem: 4 2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_LIST all : 2304 2003-03-12 09:27:54 2517 54003 dynpool (USER + SERVER + 2) * 2: 48 2003-03-12 09:27:54 2517 54003 dynpool TREELOCK_LIST elem : 48 2003-03-12 09:27:54 2517 54003 dynpool TREE_LOCK region count : 8 2003-03-12 09:27:54 2517 54003 dynpool DYNP_B77_TREE_LOCK : 338656 2003-03-12 09:27:54 2517 54003 dynpool DYNP_K51_LOCK_LIST : 673056 2003-03-12 09:27:54 2517 54003 dynpool LOCK maxlocks : 2500 2003-03-12 09:27:54 2517 54003 dynpool LOCK items : 9900 2003-03-12 09:27:54 2517 54003 dynpool LOCK Regions : 24 2003-03-12 09:27:54 2517 54003 dynpool LOCK TransRegions : 8 2003-03-12 09:27:54 2517 54003 dynpool LOCK RegionGlob+Space : 2304 2003-03-12 09:27:54 2517 54003 dynpool LOCK TransGlob : 640 2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplyItemsPerRgn : 100 2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplySize : 153600 2003-03-12 09:27:54 2517 54003 dynpool LOCK RowHash entries : 2496 2003-03-12 09:27:54 2517 54003 dynpool LOCK TabHash entries : 496 2003-03-12 09:27:54 2517 54003 dynpool LOCK Row+Tab hash size : 12032 2003-03-12 09:27:54 2517 54003 dynpool LOCK Trans entries : 96 2003-03-12 09:27:54 2517 54003 dynpool LOCK trans_list size : 16128 2003-03-12 09:27:54 2517 54003 dynpool LOCK TransPtrList : 384 2003-03-12 09:27:54 2517 54003 dynpool LOCK TransHash entries : 96 2003-03-12 09:27:54 2517 54003 dynpool LOCK TransHash size : 384 2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplyPoolSegments: 75 2003-03-12 09:27:54 2517 54003 dynpool LOCK SupplyPoolSize : 481504 2003-03-12 09:27:54 2517 54003 dynpool LOCK ObjColl_list size : 3072 2003-03-12 09:27:54 2517 54003 dynpool LOCK ObjReq_list size : 1536 2003-03-12 09:27:54 2517 ERR 59 Log RESTART ERROR '6416' => SHUTDOWN IS FORCED 2003-03-12 09:27:54 2517 12696 DBSTATE Change DbState to 'SHUTDOWN'(24) --------------------------------------- current write position ----------------- +++++++++++++++++++++++++++++++++++++++ Kernel Exit ++++++++++++++++++++++++++++ 2003-03-12 09:27:54 2483 12845 DBSTATE Kernel exited normal 2003-03-12 09:27:54 2483 12890 DIAGHIST Backup of diagnostic files will be forced at next restart 2003-03-12 09:27:54 2483 12808 DBSTATE Flushing knltrace pages 2003-03-12 09:27:54 2483 11560 COMMUNIC Releasing T24 2003-03-12 09:27:54 2483 12696 DBSTATE Change DbState to 'OFFLINE '(28) --------------------------------------- current write position ----------------- ****************May the sapdb be with you**************** This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
