Just a guess... Maybe /home/virtuoso/database is the current directory when you start virtuoso? Try this: cd to a writable directory before you start virtuoso. (You'll need to specify the config file like this: virtuoso-t -c /home/virtuoso/database/virtuoso.ini ) Maybe the files like sestmE28h are written to the current directory.
Or you might try TTLP_MT_LOCAL_FILE instead of ttlp_mt (file_to_string_output(... See http://docs.openlinksw.com/virtuoso/fn_ttlp_mt_local_file.html Worked quite well for me. For smaller files, at least - haven't tried longabstract_en.nt yet. Maybe file_to_string_output() creates temporary files like .../sestmE28h. Just a wild guess... Bye, Christopher On Tue, Apr 14, 2009 at 18:21, Jem Rayfield <jem.rayfi...@bbc.co.uk> wrote: > To clarify. > > My question is... > > Why is virtuoso trying to use > > /home/virtuoso/database//sestmE28h > > When my virtuoso.ini is not specifying this? > > How can I configure Virtuoso to use a different directory. I gues this will > fix my problems? > > I need all data temp or otherwise to go on a different mount. /data. > > Cheers > Jem > > > ________________________________ > From: Jem Rayfield > Sent: 14 April 2009 17:15 > To: virtuoso-users@lists.sourceforge.net List > Subject: ttlp_mt problem > > Hi, > > I am trying to upload dbpedia N3 triples... using: > > isql 1111 dba ****** verbose=on banner=off prompt=off echo=ON > errors=stdout exec="ttlp_mt (file_to_string_output > ('/data/virtuoso/dbpediaLoad/longabstract_en.nt'), '', > 'http://*****.newsonline.tc.nca.bbc.co.uk/test', 17); checkpoint;" > > > However I am getting the following errors (many): > > 17:05:14 Can't write to file /home/virtuoso/database//sestmE28h > > My virtuoso.ini is as follows and has no references to > /home/virtuoso/database. > > My dir structure is > > /data/virtuoso/<db/trx/etc> > /home/virtuoso/<install> > > Any ideas appreciated > > Thanks > Jem > > > > /home/virtuoso/database/virtuoso.ini --> > > ; > ; virtuoso.ini > ; > ; Configuration file for the OpenLink Virtuoso VDBMS Server > ; > ; To learn more about this product, or any other product in our > ; portfolio, please check out our web site at: > ; > ; http://www.openlinksw.com > ; > ; or contact us at: > ; > ; general.informat...@openlinksw.com > ; > ; If you have any technical questions, please contact our support > ; staff at: > ; > ; technical.supp...@openlinksw.com > ; > ; > ; Database setup > ; > [Database] > DatabaseFile = /data/virtuoso/virtuoso.db > ErrorLogFile = /data/virtuoso/virtuoso.log > LockFile = /data/virtuoso/virtuoso.lck > TransactionFile = /data/virtuoso/virtuoso.trx > ErrorLogLevel = 7 > FileExtend = 200 > MaxCheckpointRemap = 1000000 > MaxMemPoolSize = 0 > StopCompilerWhenXOverRunTime = 1 > DefaultIsolation = 2 > Striping = 0 > xa_persistent_file = /data/virtuoso/virtuoso.pxa > > [TempDatabase] > DatabaseFile = /data/virtuoso/virtuoso-temp.db > TransactionFile = /data/virtuoso/virtuoso-temp.trx > MaxCheckpointRemap = 2000 > > ; > ; Server parameters > ; > [Parameters] > ServerPort = 1111 > DisableUnixSocket = 1 > ;SSLServerPort = 2111 > ;SSLCertificate = cert.pem > ;SSLPrivateKey = pk.pem > ;X509ClientVerify = 0 > ;X509ClientVerifyDepth = 0 > ;X509ClientVerifyCAFile = ca.pem > ServerThreads = 10 > CheckpointInterval = 60 > O_DIRECT = 0 > NumberOfBuffers = 550000 > MaxDirtyBuffers = 320000 > CaseMode = 2 > MaxStaticCursorRows = 5000 > CheckpointAuditTrail = 0 > AllowOSCalls = 0 > SchedulerInterval = 10 > DirsAllowed = ., ../vad, /data/virtuoso/dbpediaLoad/ > ThreadCleanupInterval = 0 > ThreadThreshold = 10 > ResourcesCleanupInterval = 0 > FreeTextBatchSize = 100000 > SingleCPU = 0 > VADInstallDir = ../vad/ > PrefixResultNames = 0 > MacSpotLight = 0 > > [HTTPServer] > ServerPort = 8890 > ServerRoot = ../vsp > DavRoot = DAV > EnabledDavVSP = 0 > HTTPProxyEnabled = 0 > TempASPXDir = 0 > DefaultMailServer = localhost:25 > ServerThreads = 5 > MaxKeepAlives = 10 > KeepAliveTimeout = 10 > MaxCachedProxyConnections = 10 > ProxyConnectionCacheTimeout = 15 > HTTPThreadSize = 280000 > HttpPrintWarningsInOutput = 0 > Charset = UTF-8 > HttpProxyServer = http://*****.****.bbc.co.uk:80 > > [AutoRepair] > BadParentLinks = 0 > > [Client] > SQL_PREFETCH_ROWS = 100 > SQL_PREFETCH_BYTES = 16000 > SQL_QUERY_TIMEOUT = 0 > SQL_TXN_TIMEOUT = 0 > ;SQL_NO_CHAR_C_ESCAPE = 1 > ;SQL_UTF8_EXECS = 0 > ;SQL_NO_SYSTEM_TABLES = 0 > ;SQL_BINARY_TIMESTAMP = 1 > ;SQL_ENCRYPTION_ON_PASSWORD = -1 > > [VDB] > ArrayOptimization = 0 > NumArrayParameters = 10 > VDBDisconnectTimeout = 1000 > KeepConnectionOnFixedThread = 0 > > [Replication] > ServerName = virtuoso-NOLAPPS34 > ServerEnable = 1 > QueueMax = 50000 > > ; > ; Striping setup > ; > ; These parameters have only effect when Striping is set to 1 in the > ; [Database] section, in which case the DatabaseFile parameter is ignored. > ; > ; With striping, the database is spawned across multiple segments > ; where each segment can have multiple stripes. > ; > ; Format of the lines below: > ; Segment<number> = <size>, <stripe file name> [, <stripe file name> .. ] > ; > ; <number> must be ordered from 1 up. > ; > ; The <size> is the total size of the segment which is equally divided > ; across all stripes forming the segment. Its specification can be in > ; gigabytes (g), megabytes (m), kilobytes (k) or in database blocks > ; (b, the default) > ; > ; Note that the segment size must be a multiple of the database page size > ; which is currently 8k. Also, the segment size must be divisible by the > ; number of stripe files forming the segment. > ; > ; The example below creates a 200 meg database striped on two segments > ; with two stripes of 50 meg and one of 100 meg. > ; > ; You can always add more segments to the configuration, but once > ; added, do not change the setup. > ; > [Striping] > Segment1 = 100M, db-seg1-1.db, db-seg1-2.db > Segment2 = 100M, db-seg2-1.db > ;... > ;[TempStriping] > ;Segment1 = 100M, db-seg1-1.db, db-seg1-2.db > ;Segment2 = 100M, db-seg2-1.db > ;... > ;[Ucms] > ;UcmPath = <path> > ;Ucm1 = <file> > ;Ucm2 = <file> > ;... > > [Zero Config] > ServerName = virtuoso (NOLAPPS34) > ;ServerDSN = ZDSN > ;SSLServerName = > ;SSLServerDSN = > > [Mono] > ;MONO_TRACE=Off > ;MONO_PATH=<path_here> > ;MONO_ROOT=<path_here> > ;MONO_CFG_DIR=<path_here> > ;virtclr.dll= > > [URIQA] > DynamicLocal = 1 > DefaultHost = localhost:8890 > > [SPARQL] > ;ExternalQuerySource = 1 > ;ExternalXsltSource = 1 > ResultSetMaxRows = 100000 > ;DefaultGraph = http://localhost:8890/dataspace > ;MaxQueryCostEstimationTime = 120 ; in seconds > ;MaxQueryExecutionTime = 10 ; in seconds > > [Plugins] > LoadPath = ../hosting > Load1 = plain, wikiv > Load2 = plain, mediawiki > Load3 = plain, creolewiki > Load4 = plain, im > Load5 = plain, wbxml2 > Load6 = attach, libphp5.so > Load7 = Hosting, hosting_php.so > ;Load8 = Hosting,hosting_perl.so > ;Load9 = Hosting,hosting_python.so > ;Load10 = Hosting,hosting_ruby.so > ;Load11 = msdtc,msdtc_sample > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > High Quality Requirements in a Collaborative Environment. > Download a free trial of Rational Requirements Composer Now! > http://p.sf.net/sfu/www-ibm-com > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > >
