Hi Pantelis, The "It is impossible to have a database file /media/VirtuosoDBDrive/virtuoso.db with a length not multiple of 2MB” error on startup indicates and attempt to grow the database, which is done in 2MB segments, failed during the process probably due to running out of disk space or the server shutdown unexpectedly.
This is not related to the trx file which would only be an issue if upgrading to a new engine build id ie 3217 , 3216 etc. and if you have ran the +checkpoint-only option then you can remove the trx file if it is not zero bytes as it would just contain the database signature info. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ 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 7 Sep 2016, at 09:13, Pantelis Natsiavas <natsia...@gmail.com> wrote: > > Hi everybody. > > As I am trying to work on big datasets, I thought that upgrading on the > latest version of virtuoso would be a good idea as I would hopefully get some > performance advantages too. > > However, following the procedure described in > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading > from Release 7.x to a newer Release 7.x I found out that my trx file has 185 > bytes length and it would not go to 0 even after the restart with the > "+checkpoint-only" argument. My log contains the following snippet after > startup > > 10:57:16 It is impossible to have a database file > /media/VirtuosoDBDrive/virtuoso.db with a length not multiple of 2MB. > 10:57:16 The process must have last terminated while growing the file. > 10:57:16 Please contact OpenLink Customer Support > 10:57:16 Database version 3126 > .... > 10:58:00 Roll forward started > 10:58:00 3 transactions, 185 bytes replayed (100 %) > 10:58:00 Roll forward complete > .... > > My questions are: > 1. If I get it right, the virtuoso.trx size implies that there are > transactions left uncompleted in a "dirty" state. However, this should not be > the case since as the log shows normal replay of the transactions. Could I > just delete the virtuoso.trx? Is there something else I could do to recover? > 2. What would be the easiest way to upgrade the virtuoso server? I am not > comfortable with the instruction "install the newer v7.x binary components, > either atop or after removing the older v7.x binary components.". Is there a > more specific guideline? > > Please note that I am running Virtuoso Version: 07.20.3214 Build: Oct 14 > 2015, on Ubuntu 14.04. > > Kind regards, > Pantelis Natsiavas > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
