@Gargron @Thib I have a problem with commit c6904c0d3766a2ea8a81ab025c127169ecb51373, the migrate operation fails : https://paste.hostux.net/?0611fb21c954e101#GoscBCVyeuHh6ekPCxQ1cTAwoemhWcyQNNZPZKnrs2BE any ideas?
@valere @Gargron this is very fishy, you should definitely have that index… is this the first time the migration failed (not that this should change much)?What is the output of \d+ accounts in a postgres shell?
yep, it failed the first time I started the migration.
postgres-# \d+ accountsAucune relation nommée « accounts » n'a été trouvée.
@valere @Gargron do you know if the first time it failed, it failed with the same error?
You need to be connected to your mastodon database before running \d+ accounts
@Thib @Gargron meeh... better after coffee: https://paste.hostux.net/?9c030030b477bcc3#As1mxbs5Ts53fXVuPLuuBhxS6JoRm14tnZ5Bm8xrV7kJ
@valere @Gargron it doesn't return any indexes…? what does SELECT indexname, indexdef FROM pg_indexes WHERE tablename = 'accounts'; return?
SELECT indexname, indexdef FROM pg_indexes WHERE tablename = 'accounts';
@Thib @Gargron https://paste.hostux.net/?430bdf120b3bc2b6#EiSUoopr4mmsApKJ3cKVz6snNhLnjm1k7tMU3DmM3LR1
@valere @Gargron you're definitely missing an index here… i'm not sure how that could have happened… do you have database backups to check if that was the case before you tried the last migration?
@Thib @Gargron I'll check it out, thanks for your help
@valere @Gargron anyway, you should be able to run the following and start the migration again:
CREATE UNIQUE INDEX CONCURRENTLY index_accounts_on_username_and_domain_lower ON accounts (lower(username), lower(domain))
@Thib @Gargron I do have a glitch somewhere...
@valere @Gargron ok, that is definitely very weird and i don't know how to help with that
This is a small personal instance running on a couple small ARM servers at home.