I have already to changed the value of both variables, on the Feb2013-SP4 version. Now I get a different error when the client tries to connect to the same database:

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

Is this a completely different error or is it related with the initial problem?

I wonder if the database got corrupted when the initial problem occurred. 
If the database got corrupted, is there any way to get it back to normal operation?

Also, what are the implications of changing these two variables? 
Would this increase the memory consumption or harm the performance of MonetDB in some way?

Thank you,
Pedro Salgueiro
 


On Mon, Oct 7, 2013 at 1:52 PM, Sjoerd Mullender <sjoerd@acm.org> wrote:
-----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-----
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list