-----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. 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
_______________________________________________ users-list mailing 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-----