This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 10.1.21 silently skipping INSERTs

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

E.g., the following query:

INSERT INTO supplierItems (itemId, supplierId, supplierItemId) VALUES (9788711721780, 99, 1234567890);                        

Gives "0 rows affected" as a result:

Query OK, 0 rows affected (0.00 sec)

And the inserted row is nowhere to be found:

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

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 Answered by Christian Rishøj in this comment.

The issue is reproducible with the given trigger.

Bug report filed: https://jira.mariadb.org/browse/MDEV-12100

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.