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

Reply via email to