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 <sjoerd@monetdb.org> wrote:
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