On a virtual server instance with an OntoWiki and where I do heavy bulk uploads
using virt-jena, Virtuoso is very unstable and crashes at least daily.
I use virtGraph.getBulkUpdateHandler().add(Iterator) which is deprecated, could
that be the problem? Unfortunately that is my only option as otherwise the
upload is at least 10 times slower.
It leaves no log entries that point to a problem, as far as I understand it.
Nevertheless, I added the log at the bottom.
I use Virtuoso "Version 7.1.0.3207-pthreads as of Mar 26 2014".
The instance has 10 GB RAM, virtuoso.db is 36GB in size and virtuoso.ini is
configured to use 2 GB of memory (it always takes more than allocated and lets
my system get out of memory if I allocate it more):
NumberOfBuffers = 170000
MaxDirtyBuffers = 130000
MaxQueryMem = 1G
I also added "DefaultIsolation = 2" because I've read that this helps but to no
success.
Is there a more detailed log and how can I make it stable?
Thu Dec 04 2014
16:15:11 { Loading plugin 1: Type `plain', file `wikiv' in
`/usr/lib/virtuoso/hosting'
16:15:11 FAILED plugin 1: Unable to locate file }
16:15:11 { Loading plugin 2: Type `plain', file `mediawiki' in
`/usr/lib/virtuoso/hosting'
16:15:11 FAILED plugin 2: Unable to locate file }
16:15:11 { Loading plugin 3: Type `plain', file `creolewiki' in
`/usr/lib/virtuoso/hosting'
16:15:11 FAILED plugin 3: Unable to locate file }
16:15:11 OpenLink Virtuoso Universal Server
16:15:11 Version 07.10.3207-pthreads for Linux as of Mar 26 2014
16:15:11 uses parts of OpenSSL, PCRE, Html Tidy
16:15:13 Database version 3126
16:15:13 SQL Optimizer enabled (max 1000 layouts)
16:15:14 Compiler unit is timed at 0.000288 msec
16:15:23 built-in procedure "repl_undot_name" overruled by the RDBMS
16:15:24 Roll forward started
16:15:24 1000 transactions, 163949 bytes replayed (2 %)
16:15:26 13000 transactions, 2715040 bytes replayed (38 %)
16:15:27 Roll forward complete
16:15:29 Checkpoint started
16:15:29 Checkpoint finished, log reused
16:15:30 HTTP/WebDAV server online at 8890
16:15:30 Server online at 1111 (pid 11509)
16:29:22 /usr/bin/virtuoso-t() [0x91f298]
16:29:22 /usr/bin/virtuoso-t() [0x91f306]
16:29:22 /usr/bin/virtuoso-t() [0x879d40]
16:29:22 /usr/bin/virtuoso-t() [0x4a6a0d]
16:29:22 /usr/bin/virtuoso-t() [0x4a9c94]
16:29:22 /usr/bin/virtuoso-t() [0x54cf5c]
16:29:22 /usr/bin/virtuoso-t() [0x5509e0]
16:29:22 /usr/bin/virtuoso-t() [0x67fc2e]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0x609) [0x61bc69]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610e81]
16:29:22 /usr/bin/virtuoso-t() [0x561020]
16:29:22 /usr/bin/virtuoso-t() [0x561366]
16:29:22 /usr/bin/virtuoso-t(in_iter_input+0x363) [0x561733]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0x1ca) [0x61b82a]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0x1ca) [0x61b82a]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610e81]
16:29:22 /usr/bin/virtuoso-t() [0x561020]
16:29:22 /usr/bin/virtuoso-t() [0x561366]
16:29:22 /usr/bin/virtuoso-t(in_iter_input+0x363) [0x561733]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0x1ca) [0x61b82a]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0xdb7) [0x61c417]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0xdb7) [0x61c417]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0x1ca) [0x61b82a]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0xdb7) [0x61c417]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0x1ca) [0x61b82a]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610fc1]
16:29:22 /usr/bin/virtuoso-t(table_source_input+0x1ca) [0x61b82a]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x610e81]
16:29:22 /usr/bin/virtuoso-t() [0x649837]
16:29:22 /usr/bin/virtuoso-t() [0x610b68]
16:29:22 /usr/bin/virtuoso-t() [0x61a7ca]
16:29:22 /usr/bin/virtuoso-t(bif_exec+0x6f1) [0x585fe1]
16:29:22 /usr/bin/virtuoso-t() [0x5e1eb8]
16:29:22 /usr/bin/virtuoso-t() [0x5ea47b]
16:29:22 /usr/bin/virtuoso-t() [0x610c7a]
16:29:22 /usr/bin/virtuoso-t() [0x6192d1]
16:29:22 /usr/bin/virtuoso-t() [0x5e2389]
16:29:22 /usr/bin/virtuoso-t() [0x5eabf1]
16:29:22 /usr/bin/virtuoso-t() [0x610c7a]
16:29:22 /usr/bin/virtuoso-t() [0x61a7ca]
16:29:22 /usr/bin/virtuoso-t() [0x623474]
16:29:22 /usr/bin/virtuoso-t(sf_sql_execute_w+0x7f) [0x623aaf]
16:29:22 /usr/bin/virtuoso-t() [0x9238be]
16:29:22 /usr/bin/virtuoso-t() [0x9277bf]
16:29:22 /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182) [0x7ff6faefd182]
16:29:22 /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7ff6fa71fefd]
16:29:22 GPF: cetop.c:1388 not supposed to hit lt rl ce if looking for end of
range
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
