It seems to be a communication problem.
What does "x_cons AEONLINE show state" and "x_cons AEONLINE show state" print out ?
-----Original Message-----
Sent: Dienstag, 30. September 2003 10:22
To: Zabach, Elke; SAPDB
Subject: Re: -24988 sql error [sql_connect ...]; 1,database
not running
Hi Elke,
Post by Zabach, ElkePost by Andreas ErnstHi 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.
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.... :-(((
Post by Zabach, Elkewhat does knldiag says?
do you find some info in the archive when looking for that
what knldiag tells you?
Post by Zabach, ElkeElke
SAP Labs Berlin
Post by Andreas ErnstSuSE 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