Hi Aem,

Looking at the date of your Virtuoso build you are using a 6.1.3 build from 
March 2011 at best, whereas the latest Virtuoso build is available are 6.1.4 
and running your query below does not crash my server on Mac OS X Lion, thus I 
would recommend you upgrade to this version to see if the problem persists. You 
can download the source for compilation from:
        
        http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VOSDownload

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 17 Feb 2012, at 23:22, Aem Cradle wrote:

> 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 of a 
> callstack, even though 
> CallstackOnException is set to 2 in virtuoso.ini
> 
> 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. 
> 
> Any guidance will be appreciated
> Thanks,
> mcradle.
> 
> 
> ==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:          s...@macports.org, openmaintai...@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
> 
> 
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to