search

mautrix / signal

A Matrix-Signal puppeting bridge
GNU Affero General Public License v3.0
484 stars 74 forks source link

Upgrading from mautrix-signal 0.4.3 to 0.6.0 ended up with users not able puppet due to unique constraint puppet_number_key #505

Closed samip5 closed 2 months ago

samip5 commented 2 months ago

It seems that something wierd went wrong? I did an in-place upgrade for mautrix-signal 0.4.3 to 0.6.0 and it migrated the database fine. However when a user tries to login again and use it, there are duplicate key value errors with puppet_number_key when handling contact list.

Apr 23 10:01:35 matrix-kapsi-fi mautrix-signal-amd64[1075311]: 2024-04-23T10:01:35+03:00 ERR Failed to save puppet to database after updating error="pq: duplicate key value violates unique constraint \"puppet_number_key\"" action="handle contact list" function=Puppet.UpdateInfo signal_user_id=d2343d45-3be5-4fb6-8458-fbbdaa1d1e0a user_id=@<snip>:kapsi.fi
maltee1 commented 2 months ago

have you tried upgrading to 0.5.0 first and then to 0.6.0?

samip5 commented 2 months ago

have you tried upgrading to 0.5.0 first and then to 0.6.0?

No, went straight to 0.6.0.

maltee1 commented 2 months ago

Maybe give it a try?

samip5 commented 2 months ago

I just truncated the puppet table, and "fixed" it already.