It seems to be a communication problem. What does "x_cons AEONLINE show state" and "x_cons AEONLINE show state" print out ? Uwe
> -----Original Message----- > From: Andreas Ernst [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 30. September 2003 10:22 > To: Zabach, Elke; SAPDB > Subject: Re: -24988 sql error [sql_connect ...]; 1,database > not running > > > Hi Elke, > > Zabach, Elke schrieb: > > >Andreas Ernst wrote: > > > > > >>Hi all, > >> > >>after a server crash, one of the two DBs will not start. > >> > >>I get the error > >> > >>-24988 sql error [sql_connect ...]; 1,database not running > >> > >>Searching in the list archiv is not possible (next link > >>resets to 'all > >>lists') and so i found nothing. > >> > >>db_cold/offline/warm don' t work - so what can i do? > >> > >> > > > >'don't work'... > >what do they return/say? > > > AEONLINE - Simone> db_online > OK > AEONLINE - Simone> db_cold > ERROR > -24988 sql error [db_cold]; 1,database not running > 1,database not running > > AEONLINE - Simone> db_offline > ERROR > -24988 sql error [db_offline]; 1,database not running > 1,database not running > > AEONLINE - Simone> db_warm > OK > > db_online/warm always says ok, but the database is still not running. > > database protokoll manager (dbmprt): > > 2003-09-30 10:00:47 0x000053c5 0 DBM > command db_online > 2003-09-30 10:01:27 0x000053c5 0 DBM command > param_startsession > 2003-09-30 10:01:27 0x000053c5 0 DBM command > param_abortsession > 2003-09-30 10:01:56 0x000053c5 0 DBM command > param_startsession > 2003-09-30 10:01:57 0x000053c5 0 DBM command > param_abortsession > 2003-09-30 10:05:17 0x000053c5 0 DBM command db_cold > 2003-09-30 10:05:17 0x000053c5 ERR -24988 DBM > ERR_SQL: sql error > 0x000053c5 ERR -24988 DBM 1,database not > running > 2003-09-30 10:05:21 0x000053c5 0 DBM > command db_offline > 2003-09-30 10:05:21 0x000053c5 ERR -24988 DBM > ERR_SQL: sql error > 0x000053c5 ERR -24988 DBM 1,database not > running > 2003-09-30 10:05:25 0x000053c5 0 DBM command db_warm > 2003-09-30 10:06:42 0x000053c5 0 DBM > command db_offline > 2003-09-30 10:06:42 0x000053c5 ERR -24988 DBM > ERR_SQL: sql error > 0x000053c5 ERR -24988 DBM 1,database not > running > > I viewed all logsfiles (DBMGUI - Check - Diagnosis Files), > but i did not > find any message that could help me to get an idea, where the problem > is.... :-((( > > >what does knldiag says? > >do you find some info in the archive when looking for that > what knldiag tells you? > > > >Elke > >SAP Labs Berlin > > > > > > > >>SuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build 027-121-048-452 > >> > >>regards > >>Andreas Ernst > >> > >> > I have no idea what i can do, the fastest way to solve the problem is > dropping and installing the database, but this is not possible > (db_cold/offline don't work). > > regards > Andreas Ernst > > > > -- > 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]
