On 1/9/12 10:38 PM, Sharath Jagannath wrote:
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.
Enable the scheduled online backup feature. Kingsley
Thanks, SharathOn Mon, Jan 9, 2012 at 7:32 PM, Hugh Williams <[email protected] <mailto:[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.db <http://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] <mailto:[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] <mailto:[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 <http://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] <mailto:[email protected]> https://lists.sourceforge.net/lists/listinfo/virtuoso-users------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
-- Regards, Kingsley Idehen Founder& CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/blog/~kidehen Twitter/Identi.ca handle: @kidehen Google+ Profile: https://plus.google.com/112399767740508618350/about LinkedIn Profile: http://www.linkedin.com/in/kidehen
smime.p7s
Description: S/MIME Cryptographic Signature
