Hi Jorge,
I would suggest using the official OpenLink provided Virtuoso Docker images at:
https://community.openlinksw.com/t/virtuoso-enterprise-edition-docker-quick-start-guide/285
rather then the “tenforce/virtuoso” docker images which use older code base,
and see if the same error occurs ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Home Page: http://www.openlinksw.com <http://www.openlinksw.com/>
Community Support: https://community.openlinksw.com
<https://community.openlinksw.com/>
Company Blog: https://medium.com/openlink-software-blog
<https://medium.com/openlink-software-blog>
Virtuoso Blog: https://medium.com/virtuoso-blog
<https://medium.com/virtuoso-blog>
Data Access Drivers Blog:
https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers
<https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers>
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 12 Aug 2020, at 08:08, jorge.mendesdeje...@isric.org wrote:
>
> 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
> <https://www.wageningencampus.nl/nl/campus/over/gebouwen/show/Gaia-gebouwnummer-101.htm>
> The Netherlands
> Telephone (Secretariat): +31 317 483735
> E-mail: i...@isric.org <blocked::mailto:soil.is...@wur.nl>
>
>
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
