Hi Hugh,
now I tried again the whole thing using a blank virtuoso database. Just
in case it helps you more than me, you find the isql-output attached, as
well as the dmesg messages. After this output is written, the
virtuoso-server is gone.
In case I do not have enough memory, I reduced to
"NumberOfBuffers = 100000" in virtuoso.ini. (My machine has 4GB
of RAM). That didn't help either.
Best Regards
Andreas
DMESG:
>>
dmesg | grep virtuoso
[3643045.965288] virtuoso-t[5604]: segfault at 0 ip 000000000056ee81 sp
00007f090ade8210 error 4 in virtuoso-t[400000+8fc000]
[3643257.243416] virtuoso-t[5644]: segfault at 0 ip 000000000056ee81 sp
00007faf0d90e210 error 4 in virtuoso-t[400000+8fc000]
[3643385.722944] virtuoso-t[5736]: segfault at 0 ip 000000000056ee81 sp
00007f40be8b1210 error 4 in virtuoso-t[400000+8fc000]
[3643587.903636] virtuoso-t[5804]: segfault at 0 ip 000000000056ee81 sp
00007fb3809c1210 error 4 in virtuoso-t[400000+8fc000]
[3643702.176504] virtuoso-t[5842]: segfault at 0 ip 000000000056ee81 sp
00007f6be90f3210 error 4 in virtuoso-t[400000+8fc000]
[3643795.715579] virtuoso-t[5885]: segfault at 0 ip 000000000056ee81 sp
00007f92b00cc210 error 4 in virtuoso-t[400000+8fc000]
[3644841.236003] virtuoso-t[6104]: segfault at 0 ip 000000000056ee81 sp
00007f03ceba5210 error 4 in virtuoso-t[400000+8fc000]
[3645854.953640] virtuoso-t[6490]: segfault at 0 ip 000000000056ee81 sp
00007f91354e9210 error 4 in virtuoso-t[400000+8fc000]
[4043399.473119] virtuoso-t[26763]: segfault at 0 ip 000000000056ee81 sp
00007f5be7b0e210 error 4 in virtuoso-t[400000+8fc000]
[4043478.809775] virtuoso-t[26842]: segfault at 0 ip 000000000056ee81 sp
00007f43b0815210 error 4 in virtuoso-t[400000+8fc000]
[1]+ Speicherzugriffsfehler nohup
/usr/local/virtuoso-opensource/bin/virtuoso-t -f -c
/usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.ini >>
/var/log/virtuoso/virtuoso.log (wd:
/mnt/triplestore/virtuoso-opensource/data)
(wd now: /mnt/triplestore/virtuoso-opensource/bin)
>>
ISQL-Output:
>>
./isql localhost USR PWD virtuosoBulkLoader.isql
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
Done. -- 7 msec.
Done. -- 2 msec.
Done. -- 4 msec.
Done. -- 0 msec.
*** Error 08S01: [Virtuoso Driver]CL065: Lost connection to
server??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
in lines 25-59 of Command-Line-Load virtuosoBulkLoader.isql:
#line 25 "virtuosoBulkLoader.isql"
create procedure
ld_dir (in path varchar, in mask varchar, in graph varchar)
{
declare ls any;
declare inx int;
ls := sys_dirlist (path, 1);
for (inx := 0; inx < length (ls); inx := inx + 1)
{
if (ls[inx] like mask)
{
set isolation = 'serializable';
if (not (exists (select 1 from DB.DBA.LOAD_LIST where LL_FILE =
path || '/' || ls[inx] for update)))
{
declare gfile, cgfile, ngraph varchar;
gfile := path || '/' || replace (ls[inx], '.gz', '') || '.graph';
cgfile := path || '/' || regexp_replace (replace (ls[inx],
'.gz', ''), '\\-[0-9]+\\.n', '.n') || '.graph';
if (file_stat (gfile) <> 0)
ngraph := trim (file_to_string (gfile), ' \r\n');
else if (file_stat (cgfile) <> 0)
ngraph := trim (file_to_string (cgfile), ' \r\n');
else if (file_stat (path || '/' || 'global.graph') <> 0)
ngraph := trim (file_to_string (path || '/' || 'global.graph'),
' \r\n');
else
ngraph := graph;
if (ngraph is not null)
{
insert into DB.DBA.LOAD_LIST (ll_file, ll_graph) values (path
|| '/' || ls[inx], ngraph);
}
}
commit work;
}
}
}
>>
Am 07.12.10 16:06, schrieb Hugh Williams:
> Hi Andreas,
>
> How big is the data you are attempting to load, can a copy be provided so we
> can try to recreate locally ?
>
> Are there any errors reported in the virtuoso.log file or a core file at the
> time of this failure as the error indicates the Virtuoso server has shutdown
> unexpectedly ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software
> Web: http://www.openlinksw.com
> Support: http://support.openlinksw.com
> Forums: http://boards.openlinksw.com/support
> Twitter: http://twitter.com/OpenLink
>
> On 6 Dec 2010, at 18:49, Andreas Kahl wrote:
>
>> Hi Hugh, Hi all,
>>
>> now I am back again with my UTF-8-Issue: With the UTF-8-enabled settings the
>> virtuosoBulkLoader-Script does not work any more. (script from
>> http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderScript )
>> The fifth command (starting line 25) fails and most of the rest fail, too.
>> I get an error "Error 08S01: [Virtuoso Driver]CL065: Lost connection to
>> server" followed by hundreds of question marks. After saying this, the whole
>> server terminates and has to be restarted.
>>
>> I tried to get around the problem by starting the server without the setting
>> "[Client] ... SQL_UTF8_EXECS = 1" in virtuoso.ini. Then the script
>> worked well again. Afterwards I re-activated the setting again and tried to
>> bulk load my data. This only led to the same error and virtuoso terminating.
>>
>> I attached a copy of the virtuoso.ini I am using. If anyone knows what I can
>> do to track down this problem, or even knows a solution, that would help me
>> lot.
>>
>> Thanks & Best Regards
>> Andreas
>>
>>
>>
>> -------- Original-Nachricht --------
>>> Datum: Tue, 30 Nov 2010 03:49:02 +0000
>>> Von: Hugh Williams <[email protected]>
>>> An: Andreas Kahl <[email protected]>
>>> CC: [email protected]
>>> Betreff: Re: [Virtuoso-users] Are SPARQL-Queries with UTF-8-characers
>>> impossible?
>>> Hi Andreas,
>>>
>>> Please see the following documentation on configuring Virtuoso for wide
>>> character / unicode / UTF-8 support:
>>>
>>> http://docs.openlinksw.com/virtuoso/wideidentifiers.html
>>> http://docs.openlinksw.com/virtuoso/dbadm.html#ini_Client
>>> http://docs.openlinksw.com/virtuoso/dbadm.html#ini_HTTPServer
>>>
>>> Best Regards
>>> Hugh Williams
>>> Professional Services
>>> OpenLink Software
>>> Web: http://www.openlinksw.com
>>> Support: http://support.openlinksw.com
>>> Forums: http://boards.openlinksw.com/support
>>> Twitter: http://twitter.com/OpenLink
>>>
>>> On 29 Nov 2010, at 14:05, Andreas Kahl wrote:
>>>
>>>> Hello everyone,
>>>>
>>>> I am currently evaluating Virtuoso-Opensource and have loaded some data.
>>> Now I am trying to query the data with the Faceted Search & Find service
>>> (fct) and via SPARQL. In both I get an error (fct) or empty result set
>>> (SPARQL) if I use characters outside ASCII-Space (e.g. german Umlauts).
>>>> Concerning SPARQL, the manual says: "Unicode characters in names are not
>>> supported."
>>>> http://docs.openlinksw.com/virtuoso/rdfsparql.html
>>>>
>>>> Does this mean that using non-ASCII-characters in queries is impossible
>>> with Virtuoso, or is there some option to activate unicode support?
>>>> Thanks for your help.
>>>>
>>>> Andreas
>>>>
>>>>
>>> ------------------------------------------------------------------------------
>>>> Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
>>>> Tap into the largest installed PC base & get more eyes on your game by
>>>> optimizing for Intel(R) Graphics Technology. Get started today with the
>>>> Intel(R) Software Partner Program. Five $500 cash prizes are up for
>>> grabs.
>>>> http://p.sf.net/sfu/intelisp-dev2dev
>>>> _______________________________________________
>>>> Virtuoso-users mailing list
>>>> [email protected]
>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>> <virtuoso.ini>------------------------------------------------------------------------------
>> What happens now with your Lotus Notes apps - do you make another costly
>> upgrade, or settle for being marooned without product support? Time to move
>> off Lotus Notes and onto the cloud with Force.com, apps are easier to build,
>> use, and manage than apps on traditional platforms. Sign up for the Lotus
>> Notes Migration Kit to learn more.
>> http://p.sf.net/sfu/salesforce-d2d_______________________________________________
>> Virtuoso-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
