Page MenuHomePhabricator

Investigate mysterious reappearing null row in revtag
Closed, ResolvedPublic

Description

Every once in a while I look at the revtag table at translatewiki.net, I find this mysterious row with all values undefined.

MariaDB [translatewiki_net]> select * from bw_revtag limit 10;
+---------+---------+-------------+----------+
| rt_type | rt_page | rt_revision | rt_value |
+---------+---------+-------------+----------+
|         |       0 |           0 | NULL     |

Event Timeline

Nikerabbit raised the priority of this task from to Low.
Nikerabbit updated the task description. (Show Details)
Nikerabbit added a subscriber: Nikerabbit.

There was such entry there again. But we have MySQL strict mode now so it should fail in the future.

Change 271973 had a related patch set uploaded (by Nikerabbit):
Avoid broken inserts to revtag

https://gerrit.wikimedia.org/r/271973

Change 271973 merged by jenkins-bot:
Avoid broken inserts to revtag

https://gerrit.wikimedia.org/r/271973

Assuming this was the only cause.