I did not take a backup myself. Doesn't the virtuoso take backup by default? Correct me if I am wrong. I had used ./virtuoso -dc <config file> to start my server. I would like to know a stable process that I should be following to make sure these things does not occur. It would be such a waste of time to load all the triples from the start.
Thanks, Sharath On Mon, Jan 9, 2012 at 7:32 PM, Hugh Williams <[email protected]>wrote: > 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.dbwith > 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 >>> >>> >>> >> > >
