on 05-02-2010 10:59 AM
Hello, Everyone
When I tried to start a maxdb service, it failed. Then I opened the file of knldiag.err , and I found the following lines:
2010-05-02 11:30:57 0x508 ERR 18432 MESSAGES Event log is full, rc = 1502
2010-05-02 11:31:08 0x9E0 ERR 20125 RTE Database automatic restart failed
2010-05-02 12:35:22 0x98 ERR 18431 MESSAGES Could not write to event log, rc = 5
2010-05-02 12:35:23 ___ Stopping GMT 2010-05-02 04:35:23 7.6.00 Build 037-121-149-748
2010-05-02 13:39:23 --- Starting GMT 2010-05-02 05:39:23 7.6.00 Build 037-121-149-748
2010-05-02 13:39:25 0x1650 ERR 18432 MESSAGES Event log is full, rc = 1502
2010-05-02 13:39:26 0x14D4 ERR 20125 RTE Database automatic restart failed
2010-05-02 14:05:23 0x111C ERR 18431 MESSAGES Could not write to event log, rc = 31
2010-05-02 14:05:24 ___ Stopping GMT 2010-05-02 06:05:24 7.6.00 Build 037-121-149-748
What's the matter with it ?
How can I solve this problem?
Any advice will be appreciated!
Best regards.
Fang
hi Fang,
I'm not like the windows guru but I think the error ur talking about:
2010-05-02 11:30:57 0x508 ERR 18432 MESSAGES Event log is full, rc = 1502
is refering to the windows event log being full and not the maxDB log being full.
There's a tool that comes with maxDB called xsysrc .. it looks up sys error number/text:
C:\Users\me>where xsysrc
C:\sapdb\programs\bin\xsysrc.exe
C:\Users\me>xsysrc 1502
Errortext for errorcode 1502:
'The event log file is full. ==> this is what ur seeing.
You can also look up other rc codes u listed here ( rc = 5, rc = 31 ) in the similar way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Junco Ueda,
Thank you very much for you kind reply.
As you pointed out, the system event log is full, so I cleared it.
But I still failed to start the service.
This time the last serveral lines of knldiag gave the following message:
2010-05-06 21:33:54 0x2E0 3 RunTime State changed from STARTING to ADMIN
2010-05-06 21:33:54 0x2E0 19601 DBSTATE SERVERDB is ready
============================================ begin of write cycle ==================
2010-05-06 21:33:54 0x2E0 20223 RTE Database tries automatic restart
2010-05-06 21:33:54 0x1450 19821 TASKING Thread 5200 starting
2010-05-06 21:33:56 0x1450 ERR 20125 RTE Database automatic restart failed
-
current write position
I could not figure out this problem. Would you please give me some advice on how to handle this?
Thanks in advance.
Fang
I'm unsure why such a large shm needs to be allocated.
There is a direct command to cleanup the shm but at this point, I'm unsure if you want to go there w/out first investigating what is the story with the huge allocation of shm.
Lastly, can you take a look at this thread and see if it helps at all:
If not and you are a sap cust, maybe opening a customer message at this point will be the best bet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, Junco Ueda
Thanks for your reply.
I read the recommended message but found that was not my case.
My windows box is windows XP professional with service pack 2.
That db was running for a long time. But suddenly failed to start.
I do not know why the dbm.shm file size is that large. Perhaps I have to execute the command to cleanup the dbm.shm file.
But the problem is that when I execute dbmcli command to start up the db, the nearly 4GB size of dbm.shm file was created again!
I have to solve this problem as soon as possible. Any advice will be appreciated!
Fang
Hello Fang,
1. Please let us know if you are SAP customer first.
2. If you are SAP customer:
u2022 Could you please create the SAP ticket on this issue
u2022 What SAP system version do you have?
3. Could you post the output of the commands:
dbmcli u2013s dbm_version
dbmcli dbm_version
dbmcli u2013n <database server> dbm_version
dbmcli db_enum u2013s
xinstinfo XNCXTYHC
<InstallationPath>\pgm\dbmshm CHECK f:\sdb\data\wrk XNCXTYHC
Post the output.
Is the drive f:\ a local database drive?
If not, please post more details on the installation architecture of the system.
4. Could you please set the u201CStart Typeu201D for MAXDB services to Manual on MAXDB server.
Then reboot the server.
Stop the x_server. Stop all applications.
Close all dbmcli & DBMGUI sessions.
Logon as your user first:
<InstallationPath>\pgm\dbmshm DELETE f:\sdb\data\wrk XNCXTYHC
Login to the database server locally as administrator & run :
<InstallationPath>\pgm\dbmshm DELETE f:\sdb\data\wrk XNCXTYHC
Could you connect to the database after that?
u2022 Restart the x_server.
u2022 dbmcli u2013d XNCXTYHC u2013n <database server name> -u <dbm-user>,<pwd>
<enter>
Thank you and best regards, Natalia Khlopina
Hello, Natalia
1. First, I am not a SAP customer. Thanks a lot for so much help.
3. The output of the commands
(1) dbmcli dbm_version
OK
VERSION = 7.6.00
BUILD = DBMServer 7.6.00 Build 037-121-149-748
OS = WIN32
INSTROOT = F:\sdb\7600
LOGON = True
CODE = ASCII
SWAP = full
UNICODE = (unknown)
INSTANCE = (unknown)
SYSNAME = Windows XP
(2) dbmcli db_enum -s
OK
ZYCJDXTJ F:\sdb\7600 7.6.00.37 fast running
ZYCJDX1 F:\sdb\7600 7.6.00.37 fast offline
YEFANGCU F:\sdb\7600 7.6.00.37 fast offline
XNJXTCHU F:\sdb\7600 7.6.00.37 fast running
XNJCSDB F:\sdb\7600 7.6.00.37 fast running
xncxtyhc F:\sdb\7600 7.6.00.37 fast offline
XNCXTDB0 F:\sdb\7600 7.6.00.37 fast offline
XNCXTCH1 F:\sdb\7600 7.6.00.37 fast offline
WANGZON1 F:\sdb\7600 7.6.00.37 fast running
TUANWANG F:\sdb\7600 7.6.00.37 fast offline
HELUOCUN F:\sdb\7600 7.6.00.37 fast offline
CWZ32009 F:\sdb\7600 7.6.00.37 fast offline
CWZ22009 F:\sdb\7600 7.6.00.37 fast offline
CWZ12008 F:\sdb\7600 7.6.00.37 fast offline
CWYF2008 F:\sdb\7600 7.6.00.37 fast offline
CWTW2009 F:\sdb\7600 7.6.00.37 fast offline
CWTW2008 F:\sdb\7600 7.6.00.37 fast offline
cwgp2009 F:\sdb\7600 7.6.00.37 fast offline
cwgp2008 F:\sdb\7600 7.6.00.37 fast offline
cwgo2008 F:\sdb\7600 7.6.00.37 fast offline
CWGA2008 F:\sdb\7600 7.6.00.37 fast offline
CW312008 F:\sdb\7600 7.6.00.37 fast running
cw112008 F:\sdb\7600 7.6.00.37 fast offline
CJDXDB F:\sdb\7600 7.6.00.37 fast running
AOWEI1 F:\sdb\7600 7.6.00.37 fast running
.M760037 F:\sdb\7600 7.6.00.37 fast offline
.M760037 F:\sdb\7600 7.6.00.37 quick offline
.M760037 F:\sdb\7600 7.6.00.37 slow offline
.M760037 F:\sdb\7600 7.6.00.37 test offline
(3) xinstinfo XNCXTYHC
IndepData : f:\sdb\data
IndepPrograms : f:\sdb\programs
InstallationPath : F:\sdb\7600
Kernelversion : KERNEL 7.6.00 BUILD 037-121-149-748
Rundirectory : f:\sdb\data\wrk\XNCXTYHC
Edited by: worldisflat on May 18, 2010 9:29 AM
Hello, Natalia
1. First, I am not a SAP customer. Thanks a lot for so much help.
3. The output of the commands
(1) dbmcli dbm_version
OK
VERSION = 7.6.00
BUILD = DBMServer 7.6.00 Build 037-121-149-748
OS = WIN32
INSTROOT = F:\sdb\7600
LOGON = True
CODE = ASCII
SWAP = full
UNICODE = (unknown)
INSTANCE = (unknown)
SYSNAME = Windows XP
(2) dbmcli db_enum -s
OK
ZYCJDXTJ F:\sdb\7600 7.6.00.37 fast running
ZYCJDX1 F:\sdb\7600 7.6.00.37 fast offline
YEFANGCU F:\sdb\7600 7.6.00.37 fast offline
XNJXTCHU F:\sdb\7600 7.6.00.37 fast running
XNJCSDB F:\sdb\7600 7.6.00.37 fast running
xncxtyhc F:\sdb\7600 7.6.00.37 fast offline
XNCXTDB0 F:\sdb\7600 7.6.00.37 fast offline
XNCXTCH1 F:\sdb\7600 7.6.00.37 fast offline
WANGZON1 F:\sdb\7600 7.6.00.37 fast running
TUANWANG F:\sdb\7600 7.6.00.37 fast offline
HELUOCUN F:\sdb\7600 7.6.00.37 fast offline
CWZ32009 F:\sdb\7600 7.6.00.37 fast offline
CWZ22009 F:\sdb\7600 7.6.00.37 fast offline
CWZ12008 F:\sdb\7600 7.6.00.37 fast offline
CWYF2008 F:\sdb\7600 7.6.00.37 fast offline
CWTW2009 F:\sdb\7600 7.6.00.37 fast offline
CWTW2008 F:\sdb\7600 7.6.00.37 fast offline
cwgp2009 F:\sdb\7600 7.6.00.37 fast offline
cwgp2008 F:\sdb\7600 7.6.00.37 fast offline
cwgo2008 F:\sdb\7600 7.6.00.37 fast offline
CWGA2008 F:\sdb\7600 7.6.00.37 fast offline
CW312008 F:\sdb\7600 7.6.00.37 fast running
cw112008 F:\sdb\7600 7.6.00.37 fast offline
CJDXDB F:\sdb\7600 7.6.00.37 fast running
AOWEI1 F:\sdb\7600 7.6.00.37 fast running
.M760037 F:\sdb\7600 7.6.00.37 fast offline
.M760037 F:\sdb\7600 7.6.00.37 quick offline
.M760037 F:\sdb\7600 7.6.00.37 slow offline
.M760037 F:\sdb\7600 7.6.00.37 test offline
(3) xinstinfo XNCXTYHC
IndepData : f:\sdb\data
IndepPrograms : f:\sdb\programs
InstallationPath : F:\sdb\7600
Kernelversion : KERNEL 7.6.00 BUILD 037-121-149-748
Rundirectory : f:\sdb\data\wrk\XNCXTYHC
(4) F:\sdb\7600\pgm>dbmshm CHECK f:\sdb\data\wrk XNCXTYHC
ERR
-24835,ERR_SHMNOINFOFILE: Shared memory missing information file
-24834,ERR_SHMNODATAFILE: Shared memory missing data file
f:\ is a local database drive.
4. The ouput of <InstallationPath>\pgm\dbmshm DELETE f:\sdb\data\wrk XNCXTYHC
OK
5. I could not connect to the database after that by using dbmcli -n localhost -d xncxtyhc -u dbm,B1234567
The output is as follows:
Error! Connection failed to node (local) for database xncxtyhc:
-24700,ERR_DBMSRV_NOSTART: Could not start DBM server.
-24832,ERR_SHMNOTAVAILABLE: Shared memory not available
-24686,ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory
-24827,ERR_SHMALLOCFAILED: ID f:\sdb\data\wrk\XNCXTYHC.dbm.shm, requested size 4283826678
I checked the size of f:\sdb\data\wrk\XNCXTYHC.dbm.shm, it is 4,283,826,678.
My system is Windows XP service pack 2 with physicial memory sized 2GB.
I guessed the reason is -24835,ERR_SHMNOINFOFILE: Shared memory missing information file, but I don't know what it is and how to create it.
Wish your kind reply and thanks in advance.
Fang
Hello Fang,
1. You created many database instances based on one database kernel installation.
Do you have problems to connect to another database instances?
2. Itu2019s 32bit server and you have 7 database instances running on this server. Correct?
3. Did you connect to the database server via WTS connection?
4. Do you have another windows 32bit server , where you could copy the XNCXTYHC
Database instance?
Thank you and best regards, Natalia Khlopina
hi,
Sounds like the last db shutdown wasn't a clean one. Can u try:
1. If u have appservers that connect to the DB, stop them.
2. stop x_server.
3. check NO dbmsrv processes are running on the db server.
4. close all dbmgui/dbmcli sessions.
5. rename: // save the originals, just in case u need them later.
f:\sdb\data\wrk\XNCXTYHC.dbm.shm => f:\sdb\data\wrk\XNCXTYHC.dbm.shm.old
f:\sdb\data\wrk\XNCXTYHC.dbm.shi => f:\sdb\data\wrk\XNCXTYHC.dbm.shi.old
6. try: dbmcli -d xncxtyhc -u ITACCEL,A1234567
If no error, then
restart x_server
restart app
restart db (db_online)
7. if all is good, u can go ahead and delete the *.old ones.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Junco Ueda,
I followed your advice and executed all of the commands. But I still got the same error.
2010-05-08 18:24:52 0x000011c8 ERR -24700 DBMSrv ERR_DBMSRV_NOSTART: Could not start DBM server.
0x000011c8 ERR -24832 DBMSrv ERR_SHMNOTAVAILABLE: Shared memory not available
0x000011c8 ERR -24686 DBMSrv ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory
0x000011c8 ERR -24827 DBMSrv ERR_SHMALLOCFAILED: ID f:\sdb\data\wrk\XNCXTYHC.dbm.shm, requested size 4283826678
2010-05-08 18:24:52 0x000011c8 INF 226 DBMSrv DBM Server client disconnect: PID 1780 on computer ITACCEL_PC_LAKE
I checked the file size of XNCXTYHC.dbm.shm, it is exactly 4283826678 and the spare space of F drive is nearly 4.37GB. Other db's dbm.shm is only 875B(less then 1KB).
When I checked the system event log, I found strange messages as follows:
The Apache service named reported the following error:
>>> httpd.exe: Syntax error on line 35 of L:/\xe5\xbc\x80\xe5\x8f\x91\xe8\x8c\x83\xe4\xbe\x8b/EPC-Setup/jinhersoft/apache/conf/httpd.conf: ServerRoot must be a valid directory .
So I have the following questions:
1. Why XNCXTYHC.dbm.shm requires so large a size as to be 4283826678B?
2. Why Apache service needs to be started ( and shutdown) when a db is going to be started (and shutdown)? Is this behavior due to virus?
3. Is there other direct command to cleanup the DBM server Shared Memory?
Your answer is highly appreciated!
Fang
You can also check these files for any errors during the start up. Anything good in there?
Directory of C:\sapdb\data\wrk:
dbmsrv_<hostname>.err
dbmsrv_<hostname>.prt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Junco Ueda,
I executed the following command and got the error messages as follows:
F:\>dbmcli -d xncxtyhc -u ITACCEL,A1234567
Error! Connection failed to node (local) for database xncxtyhc:
-24700,ERR_DBMSRV_NOSTART: Could not start DBM server.
-24832,ERR_SHMNOTAVAILABLE: Shared memory not available
-24686,ERR_SHMNOCLEANUP: Could not cleanup the DBM server Shared Memory
-24827,ERR_SHMALLOCFAILED: ID f:\sdb\data\wrk\XNCXTYHC.dbm.shm, requested size 4283826678
It seems that the shared memory is not enough. The required size is nearly 4280MB. It is incredible!
So how can I cleanup the DBM server Shared Memory? what kind of command show I type?
Thanks in advance.
Fang
hi,
Can you paste the entire output to the below command, at the dos prompt:
>> dbmcli -d <sid> -u <dbm userame, password>
for example, for my local system:
>> dbmcli -d MESSY -u control, control
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Fang,
knldiag isn't telling us much there. Can you take a look at knldiag.err and even dbm.prt to see if there are any errors reported about 2010-05-06 21:33:54, during the last startup?
Can you also paste the output of db_state? I think db is stuck in admin mode.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Junco Ueda,
Thank you very much for your kind reply.
Unfortunately, the error message is little and provides less hints.
knldiag.err gave the following error message:
2010-05-06 21:33:52 --- Starting GMT 2010-05-06 13:33:52 7.6.00 Build 037-121-149-748
2010-05-06 21:33:56 0x1450 ERR 20125 RTE Database automatic restart failed
dbm.prt had no message at that time.
When I tried to connect it via database manager, the following error message popped up:
-100 ERR_DBMSRV_NOSTART: Could not start DBM.
What is the possible problem?
Is there any way to get more information?
Your advice will be highly appreciated!
Fang
Hello, Dear Experts:
Because nobody answered my question, I have to sincerely ask help again from the experts.
The sap db service of windows could not startup due to the error of ERR 18432 MESSAGES Event log is full, rc = 1502.
I guessed the possible reason as log file is full. But how can I do something to expand the size of the log file? The database manager could not connected to the DB instance !
I am desperated because I can not afford to lose the DATA and I can not find any material to solve it.
Please help me. Any advice will be highly appreciated!
Fang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.