Database consistency issues

[Konstantin Ryabitsev]

Hi, all:

I'm trying to figure out how this can possibly happen:

> SELECT id, submission_id FROM patchwork_comment WHERE
submission_id=9896319;
+----------+---------------+
| id       | submission_id |
+----------+---------------+
| 20810589 |       9896319 |
+----------+---------------+
1 row in set (0.00 sec)

MariaDB [KORG_PATCHWORK]> SELECT * FROM patchwork_submission WHERE
id=9896319;
Empty set (0.00 sec)

There don't appear to be any foreign key constraints on the
patchwork_comment table -- would that be the side-effect of migration?


Regards,
-- 
Konstantin Ryabitsev
Director, IT Infrastructure Security
The Linux Foundation

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: OpenPGP digital signature
URL: <http://lists.ozlabs.org/pipermail/patchwork/attachments/20180806/f91a3da5/attachment-0001.sig>