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, DImitrisDimitris, 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 VOSI 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 count11:01:50 compiler text card estimate got error 37000 XM029: Free-text expression, line 1: syntax error, assuming unknown count11: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 reused20: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 rangeGPF: cetop.c:1388 not supposed to hit lt rl ce if looking for end of rangestart.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
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users