MariaDB 10.1.21 silently skipping INSERTs - Source

Revision: 52098
User: Christian Rishøj
Date: 2017-02-21 05:36

Since upgrading to MariaDB 10.1.21, INSERTs in a certain table are silently skipped.

E.g., the following query:

<<code>>
INSERT INTO supplierItems (itemId, supplierId, supplierItemId) VALUES (9788711721780, 99, 1234567890);                        
<</code>>

Gives "0 rows affected" as a result:

<<code>>
Query OK, 0 rows affected (0.00 sec)
<</code>>

And the inserted row is nowhere to be found:

<<code>>
SELECT * FROM supplierItems WHERE supplierId = 99 AND itemId = 1234567890;
Empty set (0.01 sec)
<</code>>

Glancing over the release notes (https://mariadb.com/kb/en/mariadb/mariadb-10121-release-notes/), I suspected this to have something to do with the table using compressed row format. However, converting the table to compact row format did not resolve the issue.

While the issue persists, it unfortunately isn't reproducible by creating an identical table in another database.

No warnings or errors appear in the client or the server log.

Any clues what might be at play, or how to go about debugging this?

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

MariaDB 10.1.21 silently skipping INSERTs - Source

Answer

Products

Solutions

Resources

Company

Pricing

Download MariaDB