2013-10-07 14:35:46 MSG merovingian[8219]: database 'testbd' (8278) has exited with exit status 15
2013-10-07 14:35:46 ERR merovingian[8219]: database 'testbd' crashed after SIGTERM
2013-10-07 14:35:46 ERR merovingian[8219]: client error: database 'testbd' did not initialise the sql scenario
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The message means that you are creating too many BATs, probably
because you're using too many tables with too many columns. The
number of BATs is a hard limit, but it can easily be extended with a
recompilation of MonetDB. Increase one of the numbers N_BBPINIT or
BBPINITLOG in gdk/gdk.h and recompile everything.
Alternatively, rethink your database schema and use fewer tables and
columns.
> _______________________________________________ users-list mailing
On 2013-10-07 13:02, Pedro Salgueiro wrote:
> Hi,
>
> We have a MonetDB instance which was working without problems and
> suddenly stopped working. The following error shows up in
> "merovingian.log" when the client(mclient) tries to connect to the
> database:
>
> 2013-10-07 10:35:27 ERR testbd[12111]: !FATAL: BBPextend: trying
> to extend BAT pool beyond the limit (16384000) 2013-10-07 10:35:27
> ERR testbd[12111]: 2013-10-07 10:35:27 MSG merovingian[12015]:
> database 'testbd' (12111) has exited with exit status 1 2013-10-07
> 10:35:27 ERR merovingian[12015]: client error: database 'testbd'
> has crashed after starting, manual intervention needed, check
> monetdbd's logfile for details 2013-10-07 10:35:27 MSG
> merovingian[12015]: database 'testbd' has crashed after start on
> 2013-10-02 16:36:06, attempting restart, up min/avg/max: 0s/0s/0s,
> crash average: 1.00 1.00 0.83 (25-0=25)
>
>
> The DB size is about 1.1 GB. I really don't know how many tables,
> columns or records this specific database has, as it was being used
> for a while and the data is created/uploaded daily by its users.
>
> I tried with Feb2013-SP2, Feb2013-SP3 and Feb2013-SP4 I have a few
> question about this issue:
>
> 1 - Is there any way to see a more detailed log about the error?
>
> 2 - Is it possible to recover the DB from this error? I saw
> somewhere in the mailing list that removing the sql_logs could help
> starting the DB, at the cost of loosing some data. Already tried
> that with no success.
>
> 3 - What is this "BAT pool limit" thing? Is this related in some
> way with the number of tables, number of columns per table, or
> total amount of columns that a DB can have?
>
> Thank you, Pedro Salgueiro
>
>
>
>
>
> list users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>
- --
Sjoerd Mullender
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQCVAwUBUlKuqj7g04AjvIQpAQJB7wP/bMsajBiYpkZXmUSdgUsv3xzPHS/SGPB6
Rtd8h+bOjzfZREI8od7VRHlNmBnawPZbcfJiAaWovRNQvezRO4HZi5PKB73YW2ju
IAJKS2aaUcln+R8D/RgmKcVYrxWLFFWcHbWciMw6LnKNUMHWObhmTnY7Ne1BSh1V
Db7vlqZnkh8=
=vuct
-----END PGP SIGNATURE-----
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list