Picture of s.taras
Registered 5 years 82 days
s.taras Thursday, 2 July 2020, 11:58 PM
Problem with replication
Hello.
Sometimes i got the problem with replication. Columns in insert query are duplicating. The problem is solving by reinstalling app.

Is this a way to prevent this behaviour?

Here is log:

PostgreSQLDatabase(02454780,1eeb0f68)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
AppWebsocket(024604b0)::AppWebsocketMessageComplete connected:true
AppWebsocket(024604b0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
AppWebsocket(024604b0)::WebsocketSendResult() connected=1 sendCount=1
AppWebsocket(024604b0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"tapi-fax-user","cn":"tapi-fax-user","guid":"471a1126625c5601a048005056932df0","node":"root"}}
PostgreSQLDatabase(02454780,02453f38)::ExecSQLV user:1eeb0f68 flags:00800001 sqlCmd:INSERT INTO users (username,phone,cn,uid,node,pseudo,username,phone,cn,uid,node,pseudo) VALUES ('tapi-fax-user',NULL,'tapi-fax-user','471a1126625c5601a048005056932df0','root',NULL,'tapi-fax-user',NULL,'tapi-fax-user','471a1126625c5601a048005056932df0','root',NULL) ON CONFLICT (username) DO UPDATE SET (username,phone,cn,uid,node,pseudo,username,phone,cn,uid,node,pseudo) = (EXCLUDED.username,EXCLUDED.phone,EXCLUDED.cn,EXCLUDED.uid,EXCLUDED.node,EXCLUDED.pseudo,EXCLUDED.username,EXCLUDED.phone,EXCLUDED.cn,EXCLUDED.uid,EXCLUDED.node,EXCLUDED.pseudo) RETURNING id

PostgreSQLDatabase(02454780,02453f38)::LastCommandFailed (42701):ERROR: column "username" specified more than once LINE 1: ...ERT INTO users (username,phone,cn,uid,node,pseudo,username,p...

Thank you
2013
Moderator Registered 16 years 72 days
Guntram Diehl (innovaphone) Friday, 3 July 2020, 09:02 AM
Re: Problem with replication
Do you have a trace from such a situation, which starts from the beginning of the replication? I would like to see the ReplicateStart. The only explanation I have, is that the column was specified twice in the ReplicateStart, which means it was added twice to the replicator.
Picture of s.taras
Registered 5 years 82 days
s.taras Friday, 3 July 2020, 10:41 AM
Re: Problem with replication
Unfortunately no. But will give you when issue reproduced
← You can define your color theme preference here