Thank you Hugh. I have removed the old virtuoso.trx file and everything seems in place.
Kind regards, Pantelis Natsiavas 2016-09-08 4:47 GMT+03:00 Hugh Williams <hwilli...@openlinksw.com>: > 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 > >
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
