06-24-2009 09:13 PM
Hi there,
we discovered a very long dbbackup of LMS-DBs (longer than a day).
Troubleshooting the source of the problem aims to validation of HUM-Database with command dbvalid (the upm.db database has a size of over 8GB).
Is there a problem with backup.pl script handling this "huge" amount of database size?
Is it recommended to comment out the dbvalidation in backup-script to speed up the backup-process?
Thanks for you ideas.
Lothar
06-25-2009 09:02 AM
It's not a problem with the Perl script, but an issue with the database engine. We found this same kind of time lag with LMS 3.1 data migration when it came to large databases. No, it is not recommended to disable database validation as that is the way to determine if a database is consistent when backed up. Turning that off may make the backup complete faster, but you would not know if the data backed up could be properly restored.
06-26-2009 01:28 AM
Hi Joe,
it seems that after restarting LMS-Application dbvalidation in backup is much faster.
Is that explainable?
Maybe filled up cache, ...?
Thanks for your update
Lothar
06-26-2009 10:46 AM
No, that doesn't make sense since the verification is done on the BACKED UP database (i.e. a new engine is always started). What would make sense is if some other LMS process was taking a lot of CPU and further slowing down the verification process. A restart may have corrected that.
04-18-2011 03:38 AM
Hello guys,
We have problem with scheduled LMS 3.1 backup. It takes more than 12hours to finish. You can see in log that backup is scheduled for 18:00h and it waits untill 22:07 to start doing anything. We can't figure out why is there such a delay. It started to happen after system reported lack of free space on disk. And we feed up the space, but then faced this problem with long duration. Before this problem occured backup used to last for 45 min od 1 hour.
Backup to 'C:/BACKUP' started at: [Mon Apr 11 18:01:26 2011]
Apps file : D:\\PROGRA~1\\CSCOpx\\backup\\manifest\\campus\\properties\\datafiles.txt
[Mon Apr 11 22:07:07 2011] Archiving the contents of the following directories into C:\BACKUP\2\campus\filebackup.tar
[Mon Apr 11 22:07:07 2011] D:\PROGRA~1\CSCOpx\campus\etc\cwsi\DeviceDiscovery.properties
D:\PROGRA~1\CSCOpx\campus\etc\cwsi\ANIServer.properties
D:\PROGRA~1\CSCOpx\campus\etc\cwsi\ut.properties
D:\PROGRA~1\CSCOpx\campus\etc\cwsi\discoverysnmp.conf
D:\PROGRA~1\CSCOpx\campus\etc\cwsi\datacollectionsnmp.conf
Do you have any ideas what went wrong and how to fix it?
Thanks,
Marija
04-18-2011 07:48 AM
Please start a new thread for your question.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide