Hi, You can try to recover the db file by doing 1) calculate the size needed by doing : new_size = db_file_size - (db_file_size % 2097152) 2) use dd command to make a new db file : dd if=virtuoso.db of=new.db bs=1 count=<new_size> (can adjust bs and count depending of file size, for example bs=2097152 and count = new_size / 2097152) 3) move the virtuoso.db aside e.g. old.db, then move the new.db in virtuoso.db 4) start server and perform integrity check by doing via isql command-line tool SQL> backup '/dev/null'; if p4 fails, then possibly would need to do crash-dump and restore. if no error is seen then can go ahead.
HTH Best Regards, Mitko On Jan 10, 2012, at 5:10 AM, 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 > > > > ------------------------------------------------------------------------------ > 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 -- Mitko Iliev Developer Virtuoso Team OpenLink Software http://www.openlinksw.com/virtuoso Cross Platform Web Services Middleware
