Discussion:
-24988 sql error [sql_connect ...]; 1,database not running
Andreas Ernst
2003-09-29 09:11:38 UTC
Permalink
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?

SuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build 027-121-048-452

regards
Andreas Ernst
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
jean-michel OLTRA
2003-09-29 12:25:58 UTC
Permalink
Le lundi 29 septembre 2003, Andreas Ernst a écrit...
bonjour,
Post by Andreas Ernst
db_cold/offline/warm don' t work - so what can i do?
db_online ?
--
jean-michel
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Zabach, Elke
2003-09-29 14:45:55 UTC
Permalink
Post by Andreas Ernst
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?
what does knldiag says?
do you find some info in the archive when looking for that what knldiag tells you?

Elke
SAP Labs Berlin
Post by Andreas Ernst
SuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build 027-121-048-452
regards
Andreas Ernst
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Andreas Ernst
2003-09-30 08:22:12 UTC
Permalink
Hi Elke,
Post by Zabach, Elke
Post by Andreas Ernst
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.... :-(((
Post by Zabach, Elke
what does knldiag says?
do you find some info in the archive when looking for that what knldiag tells you?
Elke
SAP Labs Berlin
Post by Andreas Ernst
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/maxdb?unsub=gcdm-***@m.gmane.org
Dittmar, Daniel
2003-09-29 16:27:41 UTC
Permalink
Post by jean-michel OLTRA
Post by Andreas Ernst
db_cold/offline/warm don' t work - so what can i do?
db_online ?
Look into knldiag (http://sapdb.2scale.net/moin.cgi/knldiag) for any error messages.

Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
***@sap.com
http://www.sapdb.org/
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Dittmar, Daniel
2003-09-29 16:28:16 UTC
Permalink
Post by Andreas Ernst
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
Look into knldiag (http://sapdb.2scale.net/moin.cgi/knldiag) for any error messages.

Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
***@sap.com
http://www.sapdb.org/
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Andreas Ernst
2003-09-30 07:59:34 UTC
Permalink
Post by Dittmar, Daniel
Post by Andreas Ernst
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
Look into knldiag (http://sapdb.2scale.net/moin.cgi/knldiag) for any error messages.
Daniel Dittmar
Hi Daniel,

i send the

knldiag
knldiag.err
dbm.utl

to Uwe Hahn.

knldiag contains only some WNG messages like:
2003-09-26 15:14:11 2401 WNG 11824 COMMUNIC Releasing T38 connection
aborted

knldiag.err:
--------------------------------------------------------------------------------
Date Time TID Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2003-09-04 15:24:01 --- Starting GMT 2003-09-04
13:24:01 7.4.3 Build 027-121-048-452
2003-09-08 16:22:28 --- Starting GMT 2003-09-08
14:22:28 7.4.3 Build 027-121-048-452
2003-09-18 17:38:29 --- Starting GMT 2003-09-18
15:38:29 7.4.3 Build 027-121-048-452

In the logfiles i found nothing, that helped me looking for a solution.

regards
Andreas Ernst
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Hahn, Uwe
2003-09-30 11:27:53 UTC
Permalink
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-----
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, Elke
Post by Andreas Ernst
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.
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, Elke
what does knldiag says?
do you find some info in the archive when looking for that
what knldiag tells you?
Post by Zabach, Elke
Elke
SAP Labs Berlin
Post by Andreas Ernst
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
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Andreas Ernst
2003-09-30 11:58:41 UTC
Permalink
Hi Uwe,
Post by Hahn, Uwe
It seems to be a communication problem.
What does "x_cons AEONLINE show state" and "x_cons AEONLINE show state" print out ?
simone:~ # x_cons AEONLINE show state

SERVERDB: AEONLINE
The database state is ONLINE

Note: i can not see any differenz between the two commands...?!?!

Andreas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Andreas Ernst
2003-09-30 12:35:53 UTC
Permalink
This post might be inappropriate. Click to display it.
Hahn, Uwe
2003-09-30 11:34:22 UTC
Permalink
sorry, the second command should be "dbmcli ... db_state".
-----Original Message-----
From: Hahn, Uwe
Sent: Dienstag, 30. September 2003 13:28
To: 'Andreas Ernst'; SAPDB
Subject: RE: -24988 sql error [sql_connect ...]; 1,database
not running
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-----
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, Elke
Post by Andreas Ernst
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.
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, Elke
what does knldiag says?
do you find some info in the archive when looking for that
what knldiag tells you?
Post by Zabach, Elke
Elke
SAP Labs Berlin
Post by Andreas Ernst
SuSE Linux ( 2.4.20-4GB-athlon), SAP DB 7.4.3 Build
027-121-048-452
Post by Zabach, Elke
Post by Andreas Ernst
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
http://lists.mysql.com/maxdb?unsub=***@sap.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=***@sap.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-***@m.gmane.org
Loading...