On Mon, Aug 18, 2014 at 1:09 PM, Kingsley Idehen <kide...@openlinksw.com>
wrote:
> On 8/18/14 9:57 AM, Dimitris Kontokostas wrote:
>
> HI again,
>
> I started getting the same error which means my db got corrupted again
> very soon.
>
> I don't know how to fix the error source so it would help to tell me how
> I could possibly get to a corrupted db state and see if I do something
> wrong in my code.
>
> Best,
> DImitris
>
> Dimitris,
>
> You have a DB that has been restored, using the same procedures from the
> past? Or you have a corrupted DB that needs to be restored using the same
> procedures from the past. Either way, what version of Virtuoso are you
> running?
>
I restored the DB according to your instructions in previous mail in this
thread and everything worked fine for a while (25-30 days).
Then I get the same error again [see below for log errors]. So either I do
something wrong in the code or there is a bug in VOS
I am running VOS 7.1.0 stable
> Do you have snippet of the DB log file around the time of the corruption
> etc?
>
Below are some log snippets
[app log]
2014-08-18 07:43:02,101 [PageProcessor_N3] WARN
org.dbpedia.extraction.live.storage.JDBCUtil: COL..: Insert stopped
because out of seg data here or elsewhere host 0 key RDF_QUAD_OP slice 0
2014-08-18 07:43:02,101 [PageProcessor_N3] ERROR
org.dbpedia.extraction.destinations.SPARULDestination: SPARUL Update for
page failed
2014-08-18 07:43:02,102 [PageProcessor_N3] WARN
org.dbpedia.extraction.live.main.Main: Stopping DBpedia Live components
2014-08-18 07:43:02,109 [Thread-0] WARN
org.dbpedia.extraction.live.main.Main: Stopping DBpedia Live components
[vos log]
11:01:50 compiler text card estimate got error 37000 XM029: Free-text
expression, line 1: syntax error
, assuming unknown count
11:01:50 compiler text card estimate got error 37000 XM029: Free-text
expression, line 1: syntax error
, assuming unknown count
11:01:50 compiler text card estimate got error 37000 XM029: Free-text
expression, line 1: syntax error
, assuming unknown count
[...]
05:18:36 missed delete of name id cache wiki/Arya_Pratinidhi_Sabha_of_Fiji
0 (0x13ea625 )
05:19:17 missed delete of name id cache resource/G%C4%83e%C8%99ti 0
(0x1ae3328 )
[...]
20:15:24 missed delete of name id cache resource/KYYY 0 (0x215972 )
20:26:01 Checkpoint started
20:26:01 Checkpoint finished, log reused
20:42:44 missed delete of name id cache wiki/Eating_Disorders_Coalition 0
(0x4fc6f2 )
20:42:49 missed delete of name id cache
wiki/Ambassade_de_la_Republique_populaire_de_Chine_au_Canada 0
(0xd2d9f6 )
20:42:49 missed delete of name id cache
wiki/California_Department_of_Finance 0 (0x8a9f09 )
20:44:00 missed delete of name id cache resource/Gaean_Reach 0 (0xbaf080 )
20:44:18 missed delete of name id cache wiki/ECO 0 (0x1eaafb8 )
20:44:28 missed delete of name id cache resource/Air_Arabia_destinations 0
(0x29e9cda )
[...]
22:19:56 missed delete of name id cache resource/Safiabad,_Shahr-e_Babak 0
(0x1bce7f )
22:19:57 missed delete of name id cache resource/Rana_Tablacha 0 (0x291c82 )
22:19:58 missed delete of name id cache resource/Rav_Yeimar 0 (0x327965 )
22:20:03 missed delete of name id cache
wiki/The_Tooth_Fairy_(disambiguation) 0 (0xb451e8 )
22:20:12 missed delete of name id cache wiki/Lercaro 0 (0x1dd4e09 )
22:20:14 missed delete of name id cache wiki/Fragum 0 (0x202d409 )
22:20:16 missed delete of name id cache resource/John_F._Banzhaf 0
(0x1603db9 )
22:20:22 missed delete of name id cache
wiki/Review_of_Scientific_Instruments 0 (0x214c648 )
22:21:12 missed delete of name id cache resource/George_Gordon_Noel 0
(0x2d9e88 )
22:21:13 missed delete of name id cache resource/CD209 0 (0x696a12 )
22:21:18 missed delete of name id cache resource/Thin-client 0 (0xd9c459 )
[...]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x91f298]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x91f306]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x879d40]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x4a6a0d]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x4a9c94]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x54cf5c]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5509e0]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x67fc2e]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t(table_source_input+0x609)
[0x61bc69]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x610b68]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x610fc1]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t(table_source_input+0x1ca)
[0x61b82a]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e3fc2]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e42cf]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x649c02]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e3fc2]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x6181c7]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x618476]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x618515]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t(bif_exec+0xbfe) [0x5864ee]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e1eb8]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5ea47b]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x610c7a]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x6192d1]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e2389]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5eabf1]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x610c7a]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x6192d1]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e2389]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e35d2]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x5e7b2c]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x610b51]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x61a7ca]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x61cbd6]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x71d1fa]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x4f9217]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x4fafd1]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x4fb24c]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t(ws_init_func+0x8d)
[0x4fb65d]
10:02:10 /opt/virtuoso/ose/7.1.0/bin/virtuoso-t() [0x9277bf]
10:02:10 /lib/x86_64-linux-gnu/libpthread.so.0(+0x7e9a) [0x7f8b540ffe9a]
10:02:10 /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f8b5392c73d]
10:02:10 GPF: cetop.c:1388 not supposed to hit lt rl ce if looking for end
of range
GPF: cetop.c:1388 not supposed to hit lt rl ce if looking for end of range
start.sh: line 12: 8601 Segmentation fault
/opt/virtuoso/ose/7.1.0/bin/virtuoso-t -f -c "$iniFile"
[...]
08:14:42 * Monitor: High disk read (2)
08:16:43 * Monitor: High disk read (2)
08:17:01 * Monitor: Locks are held for a long time
08:18:44 * Monitor: High disk read (2)
08:21:04 * Monitor: High disk read (2)
08:29:14 * Monitor: CPU% is low while there are large numbers of runnable
threads
14:02:06 Read wait on column page 3217246. Waits should be on the index
leaf page
>
> Kingsley
>
>
> On Wed, Jul 16, 2014 at 6:59 PM, Kingsley Idehen <kide...@openlinksw.com>
> wrote:
>
>> On 7/16/14 11:39 AM, Dimitris Kontokostas wrote:
>>
>> One question on this
>>
>> After the restore procedure my new database file went from 41G to 29G
>> Was that from compression or did I loose ~25% of my data?
>>
>> Best,
>> Dimitris
>>
>>
>> You compacted your DBMS via the restore process. No data lost, just a
>> more compact DBMS.
>>
>> Kingsley
>>
>>
>>
>> On Wed, Jul 16, 2014 at 12:10 PM, Dimitris Kontokostas <jimk...@gmail.com
>> > wrote:
>>
>>> Thanks Hugh,
>>>
>>> it worked and it's back online
>>>
>>> One note for the documentation
>>> virtuoso-t -D (
>>>
>>> +crash-dump)
>>> runs in the foreground (as -f is provided) while
>>> virtuoso-t +restore-crash-dump on the background and it was kind of
>>> confusing
>>>
>>> Best,
>>> Dimitris
>>>
>>>
>>> On Wed, Jul 16, 2014 at 4:06 AM, Hugh Williams <hwilli...@openlinksw.com
>>> > wrote:
>>>
>>>> Hi Dimitris,
>>>>
>>>> This error comes from ~/libsrc/Wi/colins.c and indicates possible
>>>> corruption in the database, thus you should run an integrity check as
>>>> detailed at:
>>>>
>>>> http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#vdbrecovery
>>>>
>>>> and consider performing a dump and recovery of the database as
>>>> detailed in the documentation.
>>>>
>>>> Best Regards
>>>> Hugh Williams
>>>> Professional Services
>>>> OpenLink Software, Inc. //
>>>> http://www.openlinksw.com/
>>>> 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 15 Jul 2014, at 06:57, Dimitris Kontokostas <jimk...@gmail.com>
>>>> wrote:
>>>>
>>>> Hello,
>>>>
>>>> I am using VOS through virtjdbc and since yesterday afternoon I
>>>> cannot update data in my database ang get the following exception:
>>>>
>>>> WARN org.dbpedia.extraction.live.storage.JDBCUtil - COL..: Insert
>>>> stopped because out of seg data here or elsewhere host 0 key RDF_QUAD slice
>>>> 0
>>>>
>>>> I searched a bit around but didn't find anything related. Any help
>>>> appreciated
>>>>
>>>> Best,
>>>> Dimitris
>>>>
>>>> --
>>>> Kontokostas Dimitris
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Want fast and easy access to all the code in your enterprise? Index and
>>>> search up to 200,000 lines of code with a free copy of Black Duck
>>>> Code Sight - the same software that powers the world's largest code
>>>> search on Ohloh, the Black Duck Open Hub! Try it now.
>>>> http://p.sf.net/sfu/bds_______________________________________________
>>>> Virtuoso-users mailing list
>>>> Virtuoso-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Kontokostas Dimitris
>>>
>>
>>
>>
>> --
>> Kontokostas Dimitris
>>
>>
>> ------------------------------------------------------------------------------
>> Want fast and easy access to all the code in your enterprise? Index and
>> search up to 200,000 lines of code with a free copy of Black Duck
>> Code Sight - the same software that powers the world's largest code
>> search on Ohloh, the Black Duck Open Hub! Try it now.http://p.sf.net/sfu/bds
>>
>>
>>
>> _______________________________________________
>> Virtuoso-users mailing
>> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>>
>> --
>> Regards,
>>
>> Kingsley Idehen
>> Founder & CEO
>> OpenLink Software
>> Company Web: http://www.openlinksw.com
>> Personal Weblog 1: http://kidehen.blogspot.com
>> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
>> Twitter Profile: https://twitter.com/kidehen
>> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
>> LinkedIn Profile: http://www.linkedin.com/in/kidehen
>> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Want fast and easy access to all the code in your enterprise? Index and
>> search up to 200,000 lines of code with a free copy of Black Duck
>> Code Sight - the same software that powers the world's largest code
>> search on Ohloh, the Black Duck Open Hub! Try it now.
>> http://p.sf.net/sfu/bds
>> _______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>
>
> --
> Kontokostas Dimitris
>
>
>
> --
> Regards,
>
> Kingsley Idehen
> Founder & CEO
> OpenLink Software
> Company Web: http://www.openlinksw.com
> Personal Weblog 1: http://kidehen.blogspot.com
> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
> Twitter Profile: https://twitter.com/kidehen
> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
> LinkedIn Profile: http://www.linkedin.com/in/kidehen
> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>
>
--
Kontokostas Dimitris
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
