Sharath, On 10 Jan 2012, at 12:34, Kingsley Idehen wrote:
> 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.
[Hugh] Note you can setup the scheduled online back up manual as detailed in
the backup documentation at:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#backup
Or using the Conductor UI “System Admin -> Backup” tab as indicated at:
http://docs.openlinksw.com/virtuoso/htmlconductorbar.html#conductorbar
So if you do not have a regular online backup you will have to load the data
again I’m afraid, this time ensuring the online backups are in place such that
you can always recover back to a known working backup set.
Regards
Hugh
>
> Kingsley
>>
>> 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.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
>
>
> --
>
> 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
>
>
>
>
> ------------------------------------------------------------------------------
> 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
smime.p7s
Description: S/MIME cryptographic signature
