I switched over to use project file settings and now I occasionally get a constraint violation when trying to run the
craft projectconfig/sync command.
I think this is a bug, because the
UPDATE `info` SET `id`=1, `version`='18.104.22.168', `schemaVersion`='3.3.3', `maintenance`=0, `config`=' ...`
statement seem to be missing a WHERE, which means it tries to set ALL rows in table
info to the same values. For some reason, I end up having 2 rows in
info where the one with id=2 is basically empty.
This is on version 22.214.171.124.
DELETE FROM info WHERE id = 2; resolves the situation in my case, but it is a bit cumbersome that this happens.