Error Upgrading to 11.33.3 (Apr2019)
Hi! I have a database that It started on version Dec2016-SP5. I have been upgrading from version to version without any problem. Now, Im trying to do the last upgrade (this means from Aug2018-SP2 to Apr2019. But Im facing an error. This is what I see on the log: 2019-06-06 15:17:55 ERR cli_gm[2188]: #main thread:!ERROR: BBPcheckbats: file /opt/monetdb/cli_gm/bat/50/65/506571.tail too small (expected 127992, actual 125580) 2019-06-06 15:17:55 MSG cli_gm[2188]: !ERROR: BBPcheckbats: file /opt/monetdb/cli_gm/bat/50/65/506571.tail too small (expected 127992, actual 125580) 2019-06-06 15:17:55 ERR cli_gm[2188]: !FATAL: BBPinit: BBPcheckbats failed 2019-06-06 15:17:58 MSG merovingian[2180]: database 'cli_gm' (2188) has exited with exit status 1 2019-06-06 15:17:58 ERR control[2180]: (local): failed to fork mserver: database 'cli_gm' appears to shut itself down after starting, check monetdbd's logfile (merovingian.log) for possible hints Is there anything I can do to solve this problem? Thks in advance Ariel PD.If I go back to version Aug2018-SP2 the database keeps working with no problem.
This is a new check since the Apr2019 release. The error was probably already present in the database, but without check, you didn't notice it. It can produce other errors in older versions of MonetDB when you actually use a table that contains the column that is represented by the BAT. You may be able to fix the database so that the error doesn't occur. You can try to add NULL bytes to the mentioned file so that it is at least the expected size. This does depend on the type of the column. On 06/06/2019 17.25, Ariel Abadi wrote:
Hi! I have a database that It started on version Dec2016-SP5. I have been upgrading from version to version without any problem. Now, Im trying to do the last upgrade (this means from Aug2018-SP2 to Apr2019. But Im facing an error.
This is what I see on the log:
2019-06-06 15:17:55 ERR cli_gm[2188]: #main thread:!ERROR: BBPcheckbats: file /opt/monetdb/cli_gm/bat/50/65/506571.tail too small (expected 127992, actual 125580)
2019-06-06 15:17:55 MSG cli_gm[2188]: !ERROR: BBPcheckbats: file /opt/monetdb/cli_gm/bat/50/65/506571.tail too small (expected 127992, actual 125580)
2019-06-06 15:17:55 ERR cli_gm[2188]: !FATAL: BBPinit: BBPcheckbats failed
2019-06-06 15:17:58 MSG merovingian[2180]: database 'cli_gm' (2188) has exited with exit status 1
2019-06-06 15:17:58 ERR control[2180]: (local): failed to fork mserver: database 'cli_gm' appears to shut itself down after starting, check monetdbd's logfile (merovingian.log) for possible hints
Is there anything I can do to solve this problem?
Thks in advance Ariel PD.If I go back to version Aug2018-SP2 the database keeps working with no problem.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender
Thank you very much for your help!!!
I tried to add NULL bytes to the mentioned file, but after that started to
appear a list of other files with the same error. Ive started adding bytes
to all those files, till Ive got tired.... it is plenty of missing
values... Therefore I will have to backup and restore into a new fresh
database.
Thks again for your help
Ariel
On Thu, Jun 6, 2019 at 1:36 PM Sjoerd Mullender
This is a new check since the Apr2019 release. The error was probably already present in the database, but without check, you didn't notice it. It can produce other errors in older versions of MonetDB when you actually use a table that contains the column that is represented by the BAT.
You may be able to fix the database so that the error doesn't occur. You can try to add NULL bytes to the mentioned file so that it is at least the expected size. This does depend on the type of the column.
On 06/06/2019 17.25, Ariel Abadi wrote:
Hi! I have a database that It started on version Dec2016-SP5. I have been upgrading from version to version without any problem. Now, Im trying to do the last upgrade (this means from Aug2018-SP2 to Apr2019. But Im facing an error.
This is what I see on the log:
2019-06-06 15:17:55 ERR cli_gm[2188]: #main thread:!ERROR: BBPcheckbats: file /opt/monetdb/cli_gm/bat/50/65/506571.tail too small (expected 127992, actual 125580)
2019-06-06 15:17:55 MSG cli_gm[2188]: !ERROR: BBPcheckbats: file /opt/monetdb/cli_gm/bat/50/65/506571.tail too small (expected 127992, actual 125580)
2019-06-06 15:17:55 ERR cli_gm[2188]: !FATAL: BBPinit: BBPcheckbats failed
2019-06-06 15:17:58 MSG merovingian[2180]: database 'cli_gm' (2188) has exited with exit status 1
2019-06-06 15:17:58 ERR control[2180]: (local): failed to fork mserver: database 'cli_gm' appears to shut itself down after starting, check monetdbd's logfile (merovingian.log) for possible hints
Is there anything I can do to solve this problem?
Thks in advance Ariel PD.If I go back to version Aug2018-SP2 the database keeps working with no problem.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Ariel Abadi -
Sjoerd Mullender