Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Cannot Reproduce
-
10.0.13
-
None
-
Ubuntu "Trusty" 14.04
x86_64
Kernel 3.13.0-33
Description
Running MariaDB from the deb repository. Have been running v10.0.x for 6 months or so. This week, I updated the server to 10.0.13.
We immediately started seeing problems at the application layer with apparent bad or missing data. Downgrading back to 10.0.12 (and .11, and .10) did not fix the issue, which seemed to indicate the data itself was bad. I saw indications that the server was possibly corrupting keys, such as:
MariaDB [dbname]> select * from invoices where date="20140819" order by id desc;
|
[...]
|
46 rows in set (0.02 sec)
|
 |
MariaDB [dbname]> select * from invoices where date="20140819" order by id desc limit 1;
|
Empty set (0.00 sec)
|
Still running 10.0.10, I then dumped the table contents via mysqldump and reloaded them, and the problems disappeared.
i.e. merely applying a limit caused the query to return no rows (id is the primary key on this table).
We're using Aria for most of the tables, including the above.