On 8/18/14 11:33 AM, Dimitris Kontokostas wrote:



On Mon, Aug 18, 2014 at 1:09 PM, Kingsley Idehen <kide...@openlinksw.com <mailto: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


Okay, we'll look into this. I believe you are in touch with Hugh in regards to DB specimen too, right?

--
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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to