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
