MaxDB not connecting through any means

[Former Member]

I am not able to check db_state or even login into my database using dbmcli. I have some info that you could help me try to address the problem...

dbmcli -d TLD -u control,*********

==========================

Error! Connection failed to node (local) for database TLD:

-24691,ERR_EXIT: The DBM server must be aborted.

-24726,ERR_SHMLINESEXCEEDED: Too many lines of type 3

-24692,ERR_CHECKER_THREAD_INTERNAL: Checker thread has an internal problem.

-24726,ERR_SHMLINESEXCEEDED: Too many lines of type 3

dbmcli -s inst_enum

================

OK

7.5.00.32 /sapdb/db/7500

7.5.00.32 /sapdb/TLX/db/7500

7.5.00.51 /sapdbP/TLP/db

7.5.00.51 /sapdb/TLX/db/apo/7500

7.7.06.16 /sapdb/TLD/7500

dbmcli -s db_enum

========================

OK

TLX /sapdb/TLX/db/apo/7500 7.5.00.32 fast offline

TLX /sapdb/TLX/db/apo/7500 7.5.00.32 quick offline

TLX /sapdb/TLX/db/apo/7500 7.5.00.32 slow offline

TLX /sapdb/TLX/db/apo/7500 7.5.00.32 test offline

TLP /sapdbP/TLP/db 7.5.00.51 fast offline

TLP /sapdbP/TLP/db 7.5.00.51 quick offline

TLP /sapdbP/TLP/db 7.5.00.51 slow offline

TLP /sapdbP/TLP/db 7.5.00.51 test offline

TLD /sapdb/TLD/7500 7.7.06.16 fast running

TLD /sapdb/TLD/7500 7.7.06.16 quick offline

TLD /sapdb/TLD/7500 7.7.06.16 slow offline

TLD /sapdb/TLD/7500 7.7.06.16 test offline

sdbregview -l

===========

DB Analyzer /sapdb/programs 7.7.06.16 64 bit valid

Server Utilities /sapdb/programs 7.7.06.16 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.58 valid

PCR 7301 /sapdb/programs 7.3.01.22 valid

PCR 7500 /sapdb/programs 7.5.00.51 64 bit valid

XML Indexing Engine /sapdb/programs/web 7.5.00.32 64 bit valid

Webtools /sapdb/programs/web 7.5.00.32 64 bit valid

SAP Utilities /sapdb/programs 7.7.06.16 64 bit valid

APO LC APPS /sapdb/TLX/db/apo/7500/sap 4.10.020 64 bit valid

APO LC APPS /sapdb/TLD/7500/sap 7.00.010 64 bit valid

Redist Python /sapdb/programs 7.7.06.16 32 bit valid

Base /sapdb/programs 7.7.06.16 64 bit valid

JDBC /sapdb/programs 7.6.06.05 valid

Messages /sapdb/programs MSG 0.7732 valid

ODBC /sapdb/programs 7.7.06.16 64 bit valid

SQLDBC 77 /sapdb/programs 7.7.06.16 64 bit valid

Database Kernel /sapdbP/TLP/db 7.5.0.51 valid

Database Kernel /sapdb/TLX/db/7500 7.5.00.32 64 bit valid

Database Kernel /sapdb/db/7500 7.5.00.32 64 bit valid

Database Kernel /sapdb/TLX/db/apo/7500 7.5.00.51 64 bit valid

Database Kernel /sapdb/TLD/7500 7.7.06.16 64 bit valid

Loader /sapdb/programs 7.7.06.16 64 bit valid

SQLDBC /sapdb/programs 7.7.06.16 64 bit valid

Fastload API /sapdb/programs 7.7.06.16 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.06.06 64 bit valid

PCR 7403 /sapdb/programs 7.4.03.50 64 bit valid

az18u959:tldadm> xinstinfo TLD

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/TLD/7500

Kernelversion : KERNEL 7.7.06 BUILD 016-123-219-400

Rundirectory : /sapdb/data/wrk/TLD

===========================

cd /sapdb/data/config

ls -ltr

===========================

total 1016

-rr--- 1 tlxadm sapsys 14706 Dec 05 2008 TLP.04

-rr--- 1 sdb sdba 14706 Feb 23 2009 TLX.04

-rr--- 1 sdb sdba 14706 Jun 05 2009 TLX.03

-rr--- 1 tlxadm sapsys 14706 Jun 06 2009 TLP.03

-rw-rw---- 1 sdb sdba 943 Jun 19 2009 TLX.mmm

-rrr-- 1 sdb sdba 198 Sep 14 2009 Installations.ini.old

-rwxrwxrwx 1 sdb sdba 48 Sep 14 2009 Runtimes.ini

-rw-rw---- 1 sdb sdba 169 Sep 14 2009 Databases.ini.old

-rr--- 1 tlxadm sapsys 14706 Sep 20 2009 TLP.02

-rwxrwxrwx 1 tlxadm sapsys 19107 Oct 04 2009 TLP.pah

-rwxrwxrwx 1 tlxadm sapsys 3072 Oct 04 2009 TLP.upc

-rr--- 1 tlxadm sapsys 14706 Oct 04 2009 TLP.01

-rwxrwxrwx 1 tlxadm sapsys 1164 Nov 14 2009 TLP.mmm

-rw-rw---- 1 sdb sdba 3072 Dec 04 2009 TLX.upc

-rr--- 1 sdb sdba 14706 Dec 04 2009 TLX.02

-rwxrwxrwx 1 tlxadm sapsys 14706 Dec 08 2009 TLP

-rwxrwxrwx 1 tlxadm sapsys 4830 Dec 08 2009 TLP.cfg

-rw-rw---- 1 sdb sdba 14861 Dec 16 2009 TLX.pah

-rr--- 1 sdb sdba 14706 Dec 16 2009 TLX.01

-rw-rw---- 1 sdb sdba 4900 Dec 16 2009 TLX.cfg

-rw-rw---- 1 sdb sdba 14706 Dec 16 2009 TLX

drwxr-xr-x 2 root sdba 256 Mar 20 2010 install

-rrr-- 1 sdb sdba 256 Mar 20 2010 Installations.ini

-rw-rw---- 1 sdb sdba 212 Mar 20 2010 Databases.ini

-rr--- 1 sdb sdba 22404 Mar 20 2010 TLD.02

-rw-rw---- 1 sdb sdba 179744 Mar 20 2010 TLD.pah

-rr--- 1 sdb sdba 22404 Mar 20 2010 TLD.01

-rw-rw---- 1 sdb sdba 3584 Nov 24 14:40 TLD.upc

-rw-rw---- 1 sdb sdba 22404 Nov 24 14:40 TLD

-rw-rw---- 1 sdb sdba 2473 Dec 07 05:04 TLD.mmm

-rw-rw---- 1 sdb sdba 76 Dec 07 05:04 TLD.cfg

dbmcli -d TLD -u control,*********

==========================

Error! Connection failed to node (local) for database TLD:

-24691,ERR_EXIT: The DBM server must be aborted.

-24726,ERR_SHMLINESEXCEEDED: Too many lines of type 3

-24692,ERR_CHECKER_THREAD_INTERNAL: Checker thread has an internal problem.

-24726,ERR_SHMLINESEXCEEDED: Too many lines of type 3

[Former Member]

I don't see the anyfiles of name dbmshm* or dbmshi* files in the system.

Only file is "/sapdb/TLD/7500/pgm/dbmshm".

[lbreddemann]

Hi there,

please check [Error 'Cannot register service database' during upgrade to version 7.7|http://wiki.sdn.sap.com/wiki/display/MaxDB/Error%27Cannotregisterservicedatabase%27duringupgradetoversion+7.7].

Try with deleting the ***dbm.shm and ***dbm.shi files to resolve the issue.

regards,

Lars