Dear community
I have am trying to run a virutoso instance based on the docker image (tenforce/vituroso) the docker image is being run on a openshift 3.6/kubbernetes (OC). The virtuoso.ini has been update to work on a NFS mount provided by OC and we have no permission issues or any problems with the volume. Virtuoso is running with a sudoer user. Bellow some parameters of the virtuosos.ini
/data is the nfs mount and I have moved the look to be outside the NFS, and reduced the checkpoints. Neverthless virtusoso starts with an error:
15:08:44 PL LOG: DB.DBA.DAV_QUEUE_RUN exit handler:
SR325: Transaction aborted due to a database checkpoint or database-wide atomic operation. Please retry transaction
Then later after a restart of the pod:
6:54:12 OpenLink Virtuoso Universal Server
16:54:12 Version 07.20.3229-pthreads for Linux as of Aug 10 2020
16:54:12 uses parts of OpenSSL, PCRE, Html Tidy
16:54:12 Database version 3126
16:54:12 SQL Optimizer enabled (unlimited layouts)
16:54:13 Compiler unit is timed at 0.000256 msec
16:54:14 Roll forward started
16:54:14 133 transactions, 45484 bytes replayed (100 %)
16:54:14 Roll forward complete
16:54:14 Error executing a server init statement : 37000: SQ156: Internal Optimized compiler error : sqlo table has no index in sqldf.c:3777.
Please report the statement compiled. -- DB.DBA.RDF_QUAD_FT_UPGRADE ()
16:54:14 Roll forward complete
16:54:14 Error executing a server init statement : 37000: SQ156: Internal Optimized compiler error : sqlo table has no index in sqldf.c:3777.
Please report the statement compiled. -- DB.DBA.RDF_QUAD_FT_UPGRADE ()
16:54:14 Error executing a server init statement : 37000: SQ156: Internal Optimized compiler error : sqlo table has no index in sqldf.c:3777.
Please report the statement compiled. -- WS.WS.SYS_DAV_INIT_RDF ()
16:54:15 PL LOG: Installing Virtuoso Conductor version 1.00.8783 (DAV)
16:54:15 PL LOG: Installing with dependencies Virtuoso Conductor version 1.00.8783/2020-08-10 15:13 (DAV)
16:54:18 PL LOG: SQ156: Internal Optimized compiler error : sqlo table has no index in sqldf.c:3777.
Please report the statement compiled.
while executing the following statement:
--no_c_escapes-
RDFS_RULE_SET ('http
16:54:18 PL LOG: VAD_INSTALL: SQ156: Internal Optimized compiler error : sqlo table has no index in sqldf.c:3777.
Please report the statement compiled. (37000)
16:54:18 PL LOG: Errors were detected during installation of "Virtuoso Conductor".
16:54:18 PL LOG: The installation of this VAD package has failed.
16:54:18 PL LOG: Please delete the transaction file
16:54:18 PL LOG: /data/virtuoso.trx
16:54:18 PL LOG: and then restart your database server.
16:54:18 PL LOG: Note: Your database will be in its pre VAD installation
16:54:18 PL LOG: state after you restart.
16:54:21 The startup left global lock, unlocking
16:54:23 HTTP/WebDAV server online at 8890
16:54:23 Server online at 1111 (pid 1)
And finally
14:32:27 Database version 3100
14:32:27 Trying to access the database schema data before the schema has been initialized. This is usually caused by an unrecoverable corrupted database file.
14:32:27 Server exiting
I tried to delete the database, transaction logs. Moved the transacions and pxa files to another place, it is is always the same padron, it starts, gets a transaction problem and then totally crashes.
I havent found no info on the internet what could be the issue, I suspected the NFS but I am not certain any more. The shutdown signal to the pod is 15, so I expect that everything is flushed to the pods, the lock file is not on the NFS and O_DIRECT= 1
So, any tips or information that could help debug it ??
Thank you
[Database]
DatabaseFile = /data/virtuoso.db
ErrorLogFile = /data/virtuoso.log
; No locks inside NFS
LockFile = /run/lock/virtuoso.lck
TransactionFile = /data/virtuoso.trx
xa_persistent_file = /data/virtuoso.pxa
ErrorLogLevel = 7
FileExtend = 200
CheckpointSyncMode=2
MaxCheckpointRemap = 2000
Striping = 0
TempStorage = TempDatabase
Syslog = 0
[TempDatabase]
DatabaseFile = /data/virtuoso-temp.db
TransactionFile = /data/virtuoso-temp.trx
MaxCheckpointRemap = 2000
Striping = 0
[Parameters]
ServerPort = 1111
LiteMode = 0
DisableUnixSocket = 1
DisableTcpSocket = 0
MaxClientConnections = 10
CheckpointInterval = -1
O_DIRECT = 1
CaseMode = 2
NumberOfBuffers = 5555
MaxDirtyBuffers = 40000
ISRIC — World Soil Information
PO Box 353 | 6700 AJ Wageningen
Droevendaalsesteeg 3 (Building 101) | 6708 PB Wageningen
The Netherlands
Telephone (Secretariat): +31 317 483735
E-mail: i...@isric.org
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users