Vidéos d'aide de Screencast

Symantec Embedded database can not be restarted

Created: 17 Janv. 2013 • Updated: 21 Janv. 2013 | 16 comments
Ce problème a été résolu. Voir la solution.

Hi all,

When restarting Symantec Embedded database, it takes too long to stop the db service. After a while I get the report that the service can not be stopped. The status of Symantec Embedded database in services.msc hang at stopping. 

When checking the err.log in SEPM\db folder I get this information:

*** ERROR *** Assertion failed: 201847 (9.0.2.3654)
Checkpoint log: write to H:\Symantec Manager\db\sem5.db failed with status 112: filesystem may be full or file size has exceeded system limits
 
Can not do anything with it, must restart the server. We use SEPM 11.0.7101, Win server 2003 Std x86. The size of sem5.db in SEPM\db\ folder comes up to 7,064,096 KB.
Have anybody faced this problem before? 
 
Thank you all for your answer and suggestion!
 
Regards,
Nguyen Cao

Commentaires CommentairesAccéder au dernier commentaire

l'image des Ashish-Sharma

HI,

How much disk space available in Drive ?

Try to Shrink database

https://www-secure.symantec.com/connect/downloads/...

Thanks In Advance

Ashish Sharma

l'image des Nguyen Cao

Hi Ashish,

Our SEPM drive has about 5.6GB free space.

Thank you for the tool, I will try to shrink the DB and check the performance again.

l'image des Nguyen Cao

One more question Ashish: Do I need to stop Symantec Embedded Database before shrinking?

l'image des Ashish-Sharma

HI,

Yes you need to start the Embedded Database but your case your service are stopped ..

Do you have configure any Disk Quote in System drive ?

May be you can follow this artical

Symantec Endpoint Protection 11.x: Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager
Article:TECH102333  |  Created: 2007-01-21  |  Updated: 2011-11-09  |  Article URL http://www.symantec.com/docs/TECH102333
 

Thanks In Advance

Ashish Sharma

l'image des Nguyen Cao

Hi Ashish,

I do not configure any disk quota in System drive.

I manage to start the Symantec Embedded database and currently running the database shrinking now but it seems to take very long time (the screenshot I took 30 minutes after running ShrinkEmbeddedDB.bat).

l'image des Ashish-Sharma

Hi,

Yes it's take time you can wait untill it's not finish and after check how much disk space free

Thanks In Advance

Ashish Sharma

l'image des SebastianZ

"Our SEPM drive has about 5.6GB free space" - is this the same drive we are talking about as in the error you have mentioned?:

Checkpoint log: write to H:\Symantec Manager\db\sem5.db failed with status 112: filesystem may be full or file size has exceeded system limits

Is this a virtual machine? Any chances of increasing the size of teh drive by other means?

l'image des Nguyen Cao

Thanks Ashish,

I will try to run database shrinking once again.

Do you have any solution if shrink tool can not help?

@ Sebastian,

Yes the machine is virtual machine. The drive is the same, we only use drive H for SEPM and free space size is 5.6GB

I have tried to shrink database one time but nothing change after 3 hours so I stopped the shrink process, try to reboot the server, free some disk space and try to run database shrink tool once again.

Anything new will be updated here.

Cheers,

Nguyen Cao

l'image des SMLatCST

I know this is a bit of a silly question, but given the specific error message you're receiving, can you confirm what filesystem your H: drive is using?

The error message seems to suggest it might not be using NTFS...

l'image des SMLatCST

Oh yeah, and ShrinkEmbeddedDB.bat is for SEP12.1, for v11.* SEPM's you're meant to use dbunload:

http://www.symantec.com/docs/TECH104278

SOLUTION
l'image des SameerU

Hi

Please try to repair SEPM.

Regards

l'image des Nguyen Cao

Thank all,

I'll try one more time with dbunload.

Regards,

Nguyen Cao

l'image des SMLatCST

Did you see my first post?  Like I said, it's a bit silly but can you confirm what filesystem your H:\ drive is using?

l'image des Nguyen Cao

Hi,

The File system in H drive is NTFS, just like you guess.

l'image des SMLatCST

Oh!  I was actually wondering if it might be using a different filesystem as the error message indicates the sem5.db file has reached the limits of the filesystem.

Does the out.log file provide any other information?

l'image des Nguyen Cao

Hi,

Thank you for your answer, I guess that you think the file system in H: is FAT32 or something. But with FAT32 the file size can not come up to nearly 7GB (it will be around 4GB).

Anyway,

I tried to clear H drive and then run dbunload again. It worked, now my sem5.db reduce to 4.5GB. I can stop and start Symantec Embedded Database properly.

Thank you all and have a nice day guys!

Regards,

Nguyen Cao