Syncing Errors

[AndreOS17]

When trying to connect an user or using the sync command, getting this:

(direct connection)

(command)
Traceback (most recent call last):
File "/usr/lib/python3.12/site-packages/mautrix/bridge/commands/handler.py", line 491, in handle
await self._run_handler(handler, evt)
File "/usr/lib/python3.12/site-packages/mautrix_telegram/commands/handler.py", line 194, in _run_handler
return await handler(evt)
^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/mautrix/bridge/commands/handler.py", line 340, in call
return await self._handler(evt)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/mautrix_telegram/commands/telegram/misc.py", line 333, in sync
await evt.sender.sync_dialogs()
File "/usr/lib/python3.12/site-packages/mautrix_telegram/user.py", line 901, in sync_dialogs
async for dialog in self.client.iter_dialogs(
File "/usr/lib/python3.12/site-packages/telethon/requestiter.py", line 74, in anext
if await self._load_next_chunk():
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/telethon/client/dialogs.py", line 53, in _load_next_chunk
r = await self.client(self.request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/telethon/client/users.py", line 30, in call
return await self._call(self._sender, request, ordered=ordered)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/telethon/client/users.py", line 95, in _call
await self.session.process_entities(result)
File "/usr/lib/python3.12/site-packages/mautrix_telegram/db/telethon_session.py", line 208, in process_entities
await self._locked_process_entities(tlo)
File "/usr/lib/python3.12/site-packages/mautrix_telegram/db/telethon_session.py", line 226, in _locked_process_entities
await self.db.execute(q, self.session_id, ids, hashes, usernames, phones, names)
File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/database.py", line 136, in execute
return await conn.execute(query, *args, timeout=timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/connection.py", line 38, in wrapper
ret = await func(self, arg, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/mautrix/util/async_db/connection.py", line 81, in execute
return await self.wrapped.execute(query, *args, timeout=timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/asyncpg/connection.py", line 352, in execute
_, status, _ = await self._execute(
^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/asyncpg/connection.py", line 1864, in _execute
result, _ = await self.__execute(
^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/asyncpg/connection.py", line 1961, in __execute
result, stmt = await self._do_execute(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.12/site-packages/asyncpg/connection.py", line 2024, in _do_execute
result = await executor(stmt, None)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "asyncpg/protocol/protocol.pyx", line 206, in bind_execute
asyncpg.exceptions.CardinalityViolationError: ON CONFLICT DO UPDATE command cannot affect row a second time
HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained values.

What can be done about these errors?

[VityaSchel]

Getting the same error, is it just a random bug?

[VityaSchel]

Happens to me after every sync chats command

[erikhubers]

@AndreOS17: Why did you close it? I also encounter this issue. Could you please elaborate if you fixed it?

[AndreOS17]

If it helps, I don't know the cause of the problem, because it started to appear occasionally when using the bridge. What I did was pass a hard-coded filter in mautrix-telegram > db > telethon_session.py in the call to _locked_process_entities, but it was a personal solution. I don't know if the devs intend to solve or even comment on the problem. I never got any other response about it and I know that you're not the only ones with this problem either.

I closed the issue because, after analyzing other previous issues, this would be done anyway, so if any dev wants to reopen or leave this issue as a discussion space, they are completely free to do so.

Anyway, sorry for the delay in responding. I stopped looking at the group's notifications (the vast majority were just unanswered issues too).

[VityaSchel]

yeah author of this project closed two my suggestions/issues yesterday lol and pracrically all issues here are closed immediately they clearly do not care anymore 30 мая 2025 г. 19:18:20 GMT+04:00, AndreOS17 ***@***.***> пишет:

…

AndreOS17 left a comment (mautrix/telegram#1007) If it helps, I don't know the cause of the problem, because it started to appear occasionally when using the bridge. What I did was pass a hard-coded filter in mautrix-telegram > db > telethon_session.py in the call to _locked_process_entities, but it was a personal solution. I don't know if the devs intend to solve or even comment on the problem. I never got any other response about it and I know that you're not the only ones with this problem either. I closed the issue because, after analyzing other previous issues, this would be done anyway, so if any dev wants to reopen or leave this issue as a discussion space, they are completely free to do so. Anyway, sorry for the delay in responding. I stopped looking at the group's notifications (the vast majority were just unanswered issues too). -- Reply to this email directly or view it on GitHub: #1007 (comment) You are receiving this because you commented. Message ID: ***@***.***>

[erikhubers]

@AndreOS17 : Thank you for responding. Yesterday I was trying to setup Synapse and various mautrix bridges myself for the first time ever. I was kinda hoping it was a configuration issue on my end. I'll try and have a look myself.

[erikhubers]

@AndreOS17: As I kept having the same issue, not even being able to sync any messages at all after logging out and back in again I attempted a manual dedup myself. From what I understand this error happens when the ON CONFLICT is being triggered when the conflict is in the data we're trying to insert itself.

            q = (
                "WITH deduped AS ("
                "  SELECT DISTINCT ON (session_id, id) "
                    "         session_id, id, hash, username, phone, name "
                    "  FROM (SELECT $1 as session_id, "
                    "               unnest($2::bigint[]) as id, "
                    "               unnest($3::bigint[]) as hash, "
                    "               unnest($4::text[]) as username, "
                    "               unnest($5::text[]) as phone, "
                    "               unnest($6::text[]) as name) t "
                    ") "
                    "INSERT INTO telethon_entities (session_id, id, hash, username, phone, name) "
                    "SELECT * FROM deduped "
                    "ON CONFLICT (session_id, id) DO UPDATE"
                    "  SET hash=excluded.hash, username=excluded.username,"
                    "      phone=excluded.phone, name=excluded.name"
                )

[undercoverturbo]

For what release is this commit planed/when will it be merged?

[tulir]

https://docs.mau.fi/bridges/general/troubleshooting.html#why-is-the-latest-release-old