Comment 2 for bug 957409

Hi Jocelyn,

How much memory do you actually have?

As indicated in the error log, key_buffer_size=1073741824 --
so, key_buffer_size alone takes 1Gb (default is 128 Mb); you might also have other non-default options which increase the memory usage further, check various %_buffer_size values in your cnf file or SHOW GLOBAL VARIABLES output. If your HW has little memory available, and you are using a 'big' config, it might be a problem.

That said, we had a very similar issue reported once (https://bugs.launchpad.net/maria/+bug/929603), for 5.3.3-rc, but it does not seem to be reproducible with the reporter's use case and data any longer, so we would greatly appreciate if you could provide more info about yours: DDL for tables used in the query, and, if possible, the data dump (it can be uploaded to ftp://ftp.askmonty.org. If you cannot provide the table contents, please at least give us the idea about the amount of data stored there. The DDLs (SHOW CREATE TABLE <table name> results) are still very important.

Thank you.