Page MenuHomePhabricator

Investigate mysterious reappearing null row in revtag
Closed, ResolvedPublic


Every once in a while I look at the revtag table at, 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

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

Assuming this was the only cause.