Dear community (now in plain text) 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 updated 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 transactions and pxa files to another place, it is is always the same patron, it starts, gets a transaction problem and then totally crashes. I haven't 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 Now I have noticed that on my local docker instance I am having the same error: Now looking at 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 Thank you Jorge de Jesus _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
