Hi Sharath, Sounds as if the database file is corrupt due to the unexpected killing of the sever or other. As per my previous suggestion do you now have a backup, online or manual that is being made at regular intervals that the database could be restored to ?
I also note you are running the open source Virtuoso 6.1.3 release and would recommend upgrading to the latest 6.1.4 release available on source forge ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers On 10 Jan 2012, at 03:10, Sharath Jagannath wrote: > 03:01:55 It is impossible to have a database file > /mnt/gluster/staging-virtuoso.ec2.xen.io/software/6_1_3_install_dir/var/lib/virtuoso/db/virtuoso.db > with a length not multiple of 2MB. > > Hey Hugh, > > This issue is surfacing again. Virtuoso server was killed accidentally. > I tried to recover the database using the recovery procedure mentioned here: > http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup > > #./virtuoso-t -b > > . > . > . > Recovery still fails with the debug message: > 3:01:40 uses parts of OpenSSL, PCRE, Html Tidy > 03:01:55 Database version 3126 > 03:01:55 It is impossible to have a database file > ../6_1_3_install_dir/var/lib/virtuoso/db/virtuoso.db with a length not > multiple of 2MB. > 03:01:55 The process must have last terminated while growing the file. > 03:01:55 Please contact OpenLink Customer Support > 03:01:55 Server exiting > > Is there anything else I should be doing to recover the data. > I do not want to re-load all of the billion triples :( again. > > Thanks, > Sharath > > > On Fri, Dec 9, 2011 at 10:58 AM, Sharath Jagannath <[email protected]> > wrote: > Thanks Hugh. > I did not have the back up yet. I should have one now. > Good to bump into this crash issue early in the game. > I just started to test the open virtuoso to make sure it meets my > requirements. > So the data corrupted was more of a test data than anything but I was kind of > surprised that the crash corrupted the db. > > Cheers, > Sharath > > > > On Thu, Dec 8, 2011 at 5:38 PM, Hugh Williams <[email protected]> > wrote: > Hi Sharath, > > The error indicates the database file is corrupt probably due to the database > file size being expanded at the time of the crash. > > Do you maintain backup sets it can be recovered from ? The following > documentation details how to create backups and also how you can attempt to > recover a corrupt database: > > http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup > > Best Regards > Hugh Williams > Professional Services > OpenLink Software, Inc. // http://www.openlinksw.com/ > 10 Burlington Mall Road, Suite 265, Burlington MA 01803 > Weblog -- http://www.openlinksw.com/blogs/ > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > Twitter -- http://twitter.com/OpenLink > Google+ -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > On 8 Dec 2011, at 20:41, Sharath Jagannath wrote: > >> Hey, >> >> I am using open-virtuoso-6.1.3. Have it configured, installed and was >> running on ubuntu box. >> open virtuoso server crashed due to some manual errors and I tried to >> restart it using virtuoso-t -f. >> >> I get the following error messages and the server crashes. >> >> 20:01:01 Database version 3126 >> 20:01:01 It is impossible to have a database file >> /mnt/gluster/staging-virtuoso.ec2.xen.io/software/6_1_3_install_dir/var/lib/virtuoso/db/virtuoso.db >> with a length not multiple of 2MB. >> 20:01:01 The process must have last terminated while growing the file. >> 20:01:01 Please contact OpenLink Customer Support >> 20:01:01 Server exiting >> >> >> I did see couple of questions in the forum regarding this issue but I did >> not see a solution to this problem. >> How am I supposed to restart the server and recover the corrupted data from >> the crash. >> >> >> Thanks, >> Sharath >> >> ------------------------------------------------------------------------------ >> Cloud Services Checklist: Pricing and Packaging Optimization >> This white paper is intended to serve as a reference, checklist and point of >> discussion for anyone considering optimizing the pricing and packaging model >> of a cloud services business. Read Now! >> http://www.accelacomm.com/jaw/sfnl/114/51491232/_______________________________________________ >> Virtuoso-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > >
smime.p7s
Description: S/MIME cryptographic signature
