As a sidenote to future self, next time before you spend an hour on debugging a completely unrelated issue, please check if you enabled auto-generating primary keys on this 'one-time debug' copy of the database... FFS.