#78 Virtuoso seg faults upon select * from DB.DBA.SYS_I

v6.1.3
open
nobody
None
5
2014-08-23
2012-02-18
No

Hello,

I'm using Virtuoso Version "06.01.3127-pthreads for Darwin as of May 28 2011"
running isql I'm running the following query:

select * from DB.DBA.SYS_INDEX_SPACE_STATS;

And virtuoso crashes with the following lines on standard output:
19:28:05 INFO: HTTP/WebDAV server online at 8891
19:28:05 INFO: Server online at 1112 (pid 40690)
19:28:14 INFO: Server received signal 11. Continuing with the default action for that signal.

isql outputs the following message:

*** Error 08S01: [Virtuoso Driver]CL065: Lost connection to server
at line 1 of Top-Level:
select * from DB.DBA.SYS_INDEX_SPACE_STATS

This is the command line I'm using to run virtuoso:
/opt/local/bin/virtuoso-t -df +foreground +debug +configfile /mcradle/temp/virtuoso.ini

nothing gets written to the error log file, and I can't find any trace for a callstack, even though
CallstackOnException is set to 2.

what I'm really after besides reporting this bug is to get an idea why the database takes 1GB where
it shouldn't have much data in.

Thanks,
mcradle.

* I have sent this write-up to the mailing list, but I'm having problems with my mail provider - and I'm not sure if the mail went through or not. apologies if this question ends up showing both here in the tracker and in the mailing list.

==more technical information follows:

This is the macport info on the package:
bash-3.2$ port info virtuoso
virtuoso @6.1.4 (devel)
Variants: universal

Description: Virtuoso is an enterprise-grade server that delivers a platform for Data Access, Integration and Management.
Homepage: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/

Build Dependencies: gawk
Library Dependencies: libiodbc, openssl
Platforms: darwin
License: GPL
Maintainers: snc@macports.org, openmaintainer@macports.org

and this is the content of /mcradle/temp/virtuoso.ini

[Database]
DatabaseFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.db
ErrorLogFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.log
TransactionFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.trx
xa_persistent_file=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.pxa

[TempDatabase]
DatabaseFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso-temp.db
TransactionFile=/Users/mcradle/Library/Preferences/KDE/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso-temp.trx
MaxCheckpointRemap=1000

[Parameters]
LiteMode=0
ServerPort=1112
;mcradle change to enable tcp
DisableTcpSocket=1
PrefixResultNames=0
ServerThreads=100
NumberOfBuffers=2000
MaxDirtyBuffers=1333
SchedulerInterval=5
FreeTextBatchSize=1000
CheckpointInterval=10
MinAutoCheckpointSize=200000
;Mcradle enable callstack (does not help)
CallstackOnException = 2
TraceOn = errors

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks