Re: replicator syncing throwing error on pbx and App Manager with 13r2
Hi
I checked debugs and ever function is called only once. and why the same code works on app manager with 13r1.
i you want i can send you copy of demo code privately.
BR
Iqbal
10-01 09:39:40.937 AppService::AppService 13B126
10-01 09:39:40.937 AppService::AppStart softphone@example.com
SoftPhone2::InitReplicator+++++++++++++++++++++++++++++++++++10-01 09:39:40.937 softphone@example.com App instance started
10-01 09:39:40.937 softphone@example.com SoftPhone2::ServerCertificateUpdate cert:0 certLen:0
10-01 09:39:40.943 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::DatabaseConnectComplete
10-01 09:39:40.943 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::Connected connected:1
10-01 09:39:40.943 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abce8 flags:00000001 sqlCmd:CREATE TABLE IF NOT EXISTS "tblusers" ();
TaskDbInit::AddColumn::---initUsers
10-01 09:39:40.949 softphone@example.com PostgreSQLDatabase(014a20d0,014abce8)::DatabaseExecSQLResult dataset: 014af110
10-01 09:39:40.949 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abce8 flags:00000001 sqlCmd:SELECT column_name FROM information_schema.columns WHERE table_name='tblusers';
10-01 09:39:40.964 softphone@example.com PostgreSQLDatabase(014a20d0,014abce8)::DatabaseExecSQLResult dataset: 014af0d0
10-01 09:39:40.964 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abce8 flags:00000001 sqlCmd:ALTER TABLE "tblusers" ADD COLUMN "id" BIGSERIAL PRIMARY KEY NOT NULL, ADD COLUMN "user_name" VARCHAR, ADD COLUMN "user_phone" VARCHAR, ADD COLUMN "user_cn" VARCHAR, ADD COLUMN "user_node" VARCHAR, ADD COLUMN "user_pseudo" VARCHAR, ADD COLUMN "user_uid" UUID UNIQUE NOT NULL, ADD COLUMN "user_profid" SMALLINT DEFAULT 0
10-01 09:39:40.987 softphone@example.com PostgreSQLDatabase(014a20d0,014abce8)::DatabaseExecSQLResult dataset: 014af110
10-01 09:39:40.987 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abce8 flags:00000001 sqlCmd:SELECT constraint_name FROM information_schema.table_constraints WHERE table_name='tblusers'
10-01 09:39:40.992 softphone@example.com PostgreSQLDatabase(014a20d0,014abce8)::DatabaseExecSQLResult dataset: 014af0d0
10-01 09:39:40.992 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abce8 flags:00000001 sqlCmd:ALTER TABLE "tblusers" ADD CONSTRAINT "const_username" UNIQUE (user_name)
10-01 09:39:40.998 softphone@example.com PostgreSQLDatabase(014a20d0,014abce8)::DatabaseExecSQLResult dataset: 014af110
10-01 09:39:40.998 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::Connected connected:1
10-01 09:39:40.998 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abe18 flags:00000001 sqlCmd:CREATE TABLE IF NOT EXISTS "tbldevices" ();
TaskDbInit::AddColumn::---initDevices
10-01 09:39:41.000 softphone@example.com PostgreSQLDatabase(014a20d0,014abe18)::DatabaseExecSQLResult dataset: 014af090
10-01 09:39:41.000 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abe18 flags:00000001 sqlCmd:SELECT column_name FROM information_schema.columns WHERE table_name='tbldevices';
10-01 09:39:41.005 softphone@example.com PostgreSQLDatabase(014a20d0,014abe18)::DatabaseExecSQLResult dataset: 014af050
10-01 09:39:41.005 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abe18 flags:00000001 sqlCmd:ALTER TABLE "tbldevices" ADD COLUMN "id" BIGSERIAL PRIMARY KEY NOT NULL, ADD COLUMN "user_id" BIGINT REFERENCES tblusers(id) ON DELETE CASCADE NOT NULL, ADD COLUMN "device_hw" VARCHAR, ADD COLUMN "device_text" VARCHAR, ADD COLUMN "device_app" VARCHAR
10-01 09:39:41.022 softphone@example.com PostgreSQLDatabase(014a20d0,014abe18)::DatabaseExecSQLResult dataset: 014af090
10-01 09:39:41.022 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::Connected connected:1
10-01 09:39:41.022 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abf48 flags:00000001 sqlCmd:CREATE TABLE IF NOT EXISTS "tbllines" ();
TaskDbInit::AddColumn::---initLines
10-01 09:39:41.025 softphone@example.com PostgreSQLDatabase(014a20d0,014abf48)::DatabaseExecSQLResult dataset: 014af0d0
10-01 09:39:41.025 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abf48 flags:00000001 sqlCmd:SELECT column_name FROM information_schema.columns WHERE table_name='tbllines';
10-01 09:39:41.028 softphone@example.com PostgreSQLDatabase(014a20d0,014abf48)::DatabaseExecSQLResult dataset: 014af110
10-01 09:39:41.028 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014abf48 flags:00000001 sqlCmd:ALTER TABLE "tbllines" ADD COLUMN "line_id" SMALLSERIAL PRIMARY KEY NOT NULL, ADD COLUMN "line_name" VARCHAR UNIQUE NOT NULL, ADD COLUMN "line_number" VARCHAR, ADD COLUMN "line_number_sufix" VARCHAR
10-01 09:39:41.045 softphone@example.com PostgreSQLDatabase(014a20d0,014abf48)::DatabaseExecSQLResult dataset: 014af0d0
10-01 09:39:41.045 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::Connected connected:1
10-01 09:39:41.045 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac078 flags:00000001 sqlCmd:CREATE TABLE IF NOT EXISTS "tblprofiles" ();
TaskDbInit::AddColumn::---initProfiles
10-01 09:39:41.047 softphone@example.com PostgreSQLDatabase(014a20d0,014ac078)::DatabaseExecSQLResult dataset: 014af050
10-01 09:39:41.047 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac078 flags:00000001 sqlCmd:SELECT column_name FROM information_schema.columns WHERE table_name='tblprofiles';
10-01 09:39:41.050 softphone@example.com PostgreSQLDatabase(014a20d0,014ac078)::DatabaseExecSQLResult dataset: 014af090
10-01 09:39:41.050 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac078 flags:00000001 sqlCmd:ALTER TABLE "tblprofiles" ADD COLUMN "prof_id" SMALLSERIAL PRIMARY KEY NOT NULL, ADD COLUMN "prof_name" VARCHAR NOT NULL, ADD COLUMN "prof_default_line_number" VARCHAR, ADD COLUMN "prof_default_line_number_sufix" VARCHAR
10-01 09:39:41.062 softphone@example.com PostgreSQLDatabase(014a20d0,014ac078)::DatabaseExecSQLResult dataset: 014af050
10-01 09:39:41.062 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::Connected connected:1
10-01 09:39:41.062 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac1a8 flags:00000001 sqlCmd:CREATE TABLE IF NOT EXISTS "tblxline2profile" ();
TaskDbInit::AddColumn::---initLine2profile
10-01 09:39:41.064 softphone@example.com PostgreSQLDatabase(014a20d0,014ac1a8)::DatabaseExecSQLResult dataset: 014af110
10-01 09:39:41.064 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac1a8 flags:00000001 sqlCmd:SELECT column_name FROM information_schema.columns WHERE table_name='tblxline2profile';
10-01 09:39:41.067 softphone@example.com PostgreSQLDatabase(014a20d0,014ac1a8)::DatabaseExecSQLResult dataset: 014af0d0
10-01 09:39:41.067 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac1a8 flags:00000001 sqlCmd:ALTER TABLE "tblxline2profile" ADD COLUMN "profid" SMALLINT REFERENCES tblprofiles(prof_id) NOT NULL, ADD COLUMN "lineid" SMALLINT REFERENCES tbllines(line_id) NOT NULL
10-01 09:39:41.069 softphone@example.com PostgreSQLDatabase(014a20d0,014ac1a8)::DatabaseExecSQLResult dataset: 014af110
10-01 09:39:41.069 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac1a8 flags:00000001 sqlCmd:SELECT constraint_name FROM information_schema.table_constraints WHERE table_name='tblxline2profile'
10-01 09:39:41.071 softphone@example.com PostgreSQLDatabase(014a20d0,014ac1a8)::DatabaseExecSQLResult dataset: 014af0d0
10-01 09:39:41.071 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014ac1a8 flags:00000001 sqlCmd:ALTER TABLE "tblxline2profile" ADD CONSTRAINT "lineid_profid" UNIQUE (lineid , profid)
10-01 09:39:41.075 softphone@example.com PostgreSQLDatabase(014a20d0,014ac1a8)::DatabaseExecSQLResult dataset: 014af110
TaskDbInit::---Complete
10-01 09:39:41.075 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::Connected connected:1
10-01 09:39:41.075 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014afbe8 flags:00000001 sqlCmd:CREATE TABLE IF NOT EXISTS "replicator_full" ();
10-01 09:39:41.077 softphone@example.com PostgreSQLDatabase(014a20d0,014afbe8)::DatabaseExecSQLResult dataset: 014af090
10-01 09:39:41.077 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014afbe8 flags:00000001 sqlCmd:SELECT column_name FROM information_schema.columns WHERE table_name='replicator_full';
10-01 09:39:41.079 softphone@example.com PostgreSQLDatabase(014a20d0,014afbe8)::DatabaseExecSQLResult dataset: 014af050
10-01 09:39:41.080 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014afbe8 flags:00000001 sqlCmd:ALTER TABLE "replicator_full" ADD COLUMN "id" BIGSERIAL PRIMARY KEY NOT NULL, ADD COLUMN "row" BIGINT REFERENCES tblusers(id) ON DELETE CASCADE NOT NULL
10-01 09:39:41.087 softphone@example.com PostgreSQLDatabase(014a20d0,014afbe8)::DatabaseExecSQLResult dataset: 014af090
10-01 09:39:41.087 softphone@example.com App instance initialized
0-01 09:41:10.527 softphone@example.com PostgreSQLDatabase(014a20d0,014f0c98)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
10-01 09:41:10.527 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageComplete connected:true
10-01 09:41:10.527 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
10-01 09:41:10.528 softphone@example.com AppWebsocket(014ad0e0)::WebsocketSendResult() connected=1 sendCount=1
10-01 09:41:10.529 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"JA_1111111112025","cn":"JA_1111111112025","guid":"2d36692eebef60015c860050569337b0","node":"root","devices":[{"hw":"JA_1111111112025_webrtc","text":"WebRTC","voip":"DUMMYVOIP"},{"hw":"JA_1111111112025_swphone","text":"Softphone","no-filter":true}]}}
10-01 09:41:10.529 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014f0c98 flags:00800001 sqlCmd:INSERT INTO tblusers (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) VALUES ('JA_1111111112025',NULL,'JA_1111111112025','2d36692eebef60015c860050569337b0','root',NULL,'JA_1111111112025',NULL,'JA_1111111112025','2d36692eebef60015c860050569337b0','root',NULL) ON CONFLICT (user_name) DO UPDATE SET (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) = (EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo,EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo) RETURNING id
10-01 09:41:10.529 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::LastCommandFailed (42701):ERROR: column "user_name" specified more than once
LINE 1: ...user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,...
^
10-01 09:41:10.529 softphone@example.com PostgreSQLDatabase(014a20d0,014f0c98)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
10-01 09:41:10.529 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageComplete connected:true
10-01 09:41:10.529 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
10-01 09:41:10.530 softphone@example.com AppWebsocket(014ad0e0)::WebsocketSendResult() connected=1 sendCount=1
10-01 09:41:10.530 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"DS_4082212321216","e164":"1216","cn":"DS_4082212321216","guid":"2d6ce62bebef600127810050569337b0","node":"root","devices":[{"hw":"DS_4082212321216_webrtc","text":"WebRTC","voip":"DUMMYVOIP"},{"hw":"DS_4082212321216_swphone","text":"Softphone","no-filter":true}]}}
10-01 09:41:10.530 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014f0c98 flags:00800001 sqlCmd:INSERT INTO tblusers (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) VALUES ('DS_4082212321216','1216','DS_4082212321216','2d6ce62bebef600127810050569337b0','root',NULL,'DS_4082212321216','1216','DS_4082212321216','2d6ce62bebef600127810050569337b0','root',NULL) ON CONFLICT (user_name) DO UPDATE SET (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) = (EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo,EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo) RETURNING id
10-01 09:41:10.531 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::LastCommandFailed (42701):ERROR: column "user_name" specified more than once
LINE 1: ...user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,...
^
10-01 09:41:10.531 softphone@example.com PostgreSQLDatabase(014a20d0,014f0c98)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
10-01 09:41:10.531 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageComplete connected:true
10-01 09:41:10.531 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
10-01 09:41:10.531 softphone@example.com AppWebsocket(014ad0e0)::WebsocketSendResult() connected=1 sendCount=1
10-01 09:41:10.532 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"PU_4082212321815","e164":"1815","cn":"PU_4082212321815","guid":"2da9532bebef600159810050569337b0","node":"root","devices":[{"hw":"PU_4082212321815_webrtc","text":"WebRTC","voip":"DUMMYVOIP"},{"hw":"PU_4082212321815_swphone","text":"Softphone","no-filter":true}]}}
10-01 09:41:10.532 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014f0c98 flags:00800001 sqlCmd:INSERT INTO tblusers (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) VALUES ('PU_4082212321815','1815','PU_4082212321815','2da9532bebef600159810050569337b0','root',NULL,'PU_4082212321815','1815','PU_4082212321815','2da9532bebef600159810050569337b0','root',NULL) ON CONFLICT (user_name) DO UPDATE SET (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) = (EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo,EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo) RETURNING id
10-01 09:41:10.532 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::LastCommandFailed (42701):ERROR: column "user_name" specified more than once
LINE 1: ...user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,...
^
10-01 09:41:10.532 softphone@example.com PostgreSQLDatabase(014a20d0,014f0c98)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
10-01 09:41:10.532 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageComplete connected:true
10-01 09:41:10.532 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
10-01 09:41:10.533 softphone@example.com AppWebsocket(014ad0e0)::WebsocketSendResult() connected=1 sendCount=1
10-01 09:41:10.533 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"JA_1111111111275","e164":"1275","cn":"JA_1111111111275","guid":"2dcf762cebef60016e830050569337b0","node":"root","devices":[{"hw":"JA_1111111111275_webrtc","text":"WebRTC","voip":"DUMMYVOIP"},{"hw":"JA_1111111111275_swphone","text":"Softphone","no-filter":true}]}}
10-01 09:41:10.533 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014f0c98 flags:00800001 sqlCmd:INSERT INTO tblusers (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) VALUES ('JA_1111111111275','1275','JA_1111111111275','2dcf762cebef60016e830050569337b0','root',NULL,'JA_1111111111275','1275','JA_1111111111275','2dcf762cebef60016e830050569337b0','root',NULL) ON CONFLICT (user_name) DO UPDATE SET (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) = (EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo,EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo) RETURNING id
10-01 09:41:10.534 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::LastCommandFailed (42701):ERROR: column "user_name" specified more than once
LINE 1: ...user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,...
^
10-01 09:41:10.534 softphone@example.com PostgreSQLDatabase(014a20d0,014f0c98)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
10-01 09:41:10.534 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageComplete connected:true
10-01 09:41:10.534 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
10-01 09:41:10.535 softphone@example.com AppWebsocket(014ad0e0)::WebsocketSendResult() connected=1 sendCount=1
10-01 09:41:10.535 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"JA_1111111111986","e164":"1986","cn":"JA_1111111111986","guid":"2ded6c2eebef600135860050569337b0","node":"root","devices":[{"hw":"JA_1111111111986_webrtc","text":"WebRTC","voip":"DUMMYVOIP"},{"hw":"JA_1111111111986_swphone","text":"Softphone","no-filter":true}]}}
10-01 09:41:10.535 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014f0c98 flags:00800001 sqlCmd:INSERT INTO tblusers (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) VALUES ('JA_1111111111986','1986','JA_1111111111986','2ded6c2eebef600135860050569337b0','root',NULL,'JA_1111111111986','1986','JA_1111111111986','2ded6c2eebef600135860050569337b0','root',NULL) ON CONFLICT (user_name) DO UPDATE SET (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) = (EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo,EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo) RETURNING id
10-01 09:41:10.535 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::LastCommandFailed (42701):ERROR: column "user_name" specified more than once
LINE 1: ...user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,...
^
10-01 09:41:10.535 softphone@example.com PostgreSQLDatabase(014a20d0,014f0c98)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
10-01 09:41:10.535 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageComplete connected:true
10-01 09:41:10.535 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
10-01 09:41:10.537 softphone@example.com AppWebsocket(014ad0e0)::WebsocketSendResult() connected=1 sendCount=1
10-01 09:41:10.538 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"JA_1111111111264","e164":"1264","cn":"JA_1111111111264","guid":"2e1a012cebef600163830050569337b0","node":"root","devices":[{"hw":"JA_1111111111264_webrtc","text":"WebRTC","voip":"DUMMYVOIP"},{"hw":"JA_1111111111264_swphone","text":"Softphone","no-filter":true}]}}
10-01 09:41:10.538 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014f0c98 flags:00800001 sqlCmd:INSERT INTO tblusers (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) VALUES ('JA_1111111111264','1264','JA_1111111111264','2e1a012cebef600163830050569337b0','root',NULL,'JA_1111111111264','1264','JA_1111111111264','2e1a012cebef600163830050569337b0','root',NULL) ON CONFLICT (user_name) DO UPDATE SET (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) = (EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo,EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo) RETURNING id
10-01 09:41:10.538 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::LastCommandFailed (42701):ERROR: column "user_name" specified more than once
LINE 1: ...user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,...
^
10-01 09:41:10.538 softphone@example.com PostgreSQLDatabase(014a20d0,014f0c98)::DatabaseError error: DB_ERR_SQL_COMMAND_FAILED
10-01 09:41:10.538 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageComplete connected:true
10-01 09:41:10.538 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketMessageSend {"mt":"ReplicateNext","api":"PbxTableUsers"} connected:true
10-01 09:41:10.539 softphone@example.com AppWebsocket(014ad0e0)::WebsocketSendResult() connected=1 sendCount=1
10-01 09:41:10.539 softphone@example.com AppWebsocket(014ad0e0)::AppWebsocketRecvResult {"mt":"ReplicateNextResult","api":"PbxTableUsers","columns":{"h323":"JA_1111111112095","e164":"2095","cn":"JA_1111111112095","guid":"2e5f2c2eebef6001a2860050569337b0","node":"root","devices":[{"hw":"JA_1111111112095_webrtc","text":"WebRTC","voip":"DUMMYVOIP"},{"hw":"JA_1111111112095_swphone","text":"Softphone","no-filter":true}]}}
10-01 09:41:10.539 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::ExecSQLV user:014f0c98 flags:00800001 sqlCmd:INSERT INTO tblusers (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) VALUES ('JA_1111111112095','2095','JA_1111111112095','2e5f2c2eebef6001a2860050569337b0','root',NULL,'JA_1111111112095','2095','JA_1111111112095','2e5f2c2eebef6001a2860050569337b0','root',NULL) ON CONFLICT (user_name) DO UPDATE SET (user_name,user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,user_phone,user_cn,user_uid,user_node,user_pseudo) = (EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo,EXCLUDED.user_name,EXCLUDED.user_phone,EXCLUDED.user_cn,EXCLUDED.user_uid,EXCLUDED.user_node,EXCLUDED.user_pseudo) RETURNING id
10-01 09:41:10.539 softphone@example.com PostgreSQLDatabase(014a20d0,014a1918)::LastCommandFailed (42701):ERROR: column "user_name" specified more than once
LINE 1: ...user_phone,user_cn,user_uid,user_node,user_pseudo,user_name,...
