Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Freeswitch-users] Postgress BDR insert failed for "complete" table


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
abdirahman.osm at gmai...
Guest
PostPosted: Wed Oct 27, 2021 10:41 am    Post subject: [Freeswitch-users] Postgress BDR insert failed for "com Reply with quote
Hello,

I am using postgres  with BDR bidirectional replication which requires primary keys for the freeswitch tables.


 So far so good , except freeswitch is complaining about one table here is the error



2021-10-26 23:40:47.772796 95.47% [DEBUG] mod_pgsql.c:784 Query (insert into complete values (0,'hash_remote', 'list', '', '', '', '', '', '', '', '',  'dagobah-api-gw-1-2')) returned PGRES_FATAL_ERROR
2021-10-26 23:40:47.772796 95.47% [ERR] mod_pgsql.c:551 Error executing query:
ERROR:  column "complete_uuid" is of type uuid but expression is of type integer
LINE 1: insert into complete values (0,'hash_remote', 'list', '', ''...



What I noticed is that freeswitch is doing an INSERT INTO command with no column names specified. I checked the source code and found this to be the only case for the "complete" table whereas the other tables when INSERT INTO is used column names are specified. 


Here is the structure of my  complete table with the new column complete_uuid as primary key.


CREATE TABLE :myschema.complete (
complete_uuid uuid DEFAULT public.gen_random_uuid() PRIMARY KEY,
sticky  INTEGER,
a1  VARCHAR(128),
a2  VARCHAR(128),
a3  VARCHAR(128),
a4  VARCHAR(128),
a5  VARCHAR(128),
a6  VARCHAR(128),
a7  VARCHAR(128),
a8  VARCHAR(128),
a9  VARCHAR(128),
a10 VARCHAR(128),
hostname VARCHAR(256)
        );



Any suggestions?


Thanks 


Abdirahman A. Osman
Back to top
gmaruzz at gmail.com
Guest
PostPosted: Wed Oct 27, 2021 1:48 pm    Post subject: [Freeswitch-users] Postgress BDR insert failed for "com Reply with quote
On Wed, Oct 27, 2021 at 5:44 PM Abdirahman Osman <abdirahman.osm@gmail.com (abdirahman.osm@gmail.com)> wrote:


Quote:
Hello,

I am using postgres  with BDR bidirectional replication which requires primary keys for the freeswitch tables.


 So far so good , except freeswitch is complaining about one table here is the error



2021-10-26 23:40:47.772796 95.47% [DEBUG] mod_pgsql.c:784 Query (insert into complete values (0,'hash_remote', 'list', '', '', '', '', '', '', '', '',  'dagobah-api-gw-1-2')) returned PGRES_FATAL_ERROR
2021-10-26 23:40:47.772796 95.47% [ERR] mod_pgsql.c:551 Error executing query:
ERROR:  column "complete_uuid" is of type uuid but expression is of type integer
LINE 1: insert into complete values (0,'hash_remote', 'list', '', ''...



What I noticed is that freeswitch is doing an INSERT INTO command with no column names specified. I checked the source code and found this to be the only case for the "complete" table whereas the other tables when INSERT INTO is used column names are specified. 


Here is the structure of my  complete table with the new column complete_uuid as primary key.


CREATE TABLE :myschema.complete (
complete_uuid uuid DEFAULT public.gen_random_uuid() PRIMARY KEY,
sticky  INTEGER,
a1  VARCHAR(128),
a2  VARCHAR(128),
a3  VARCHAR(128),
a4  VARCHAR(128),
a5  VARCHAR(128),
a6  VARCHAR(128),
a7  VARCHAR(128),
a8  VARCHAR(128),
a9  VARCHAR(128),
a10 VARCHAR(128),
hostname VARCHAR(256)
        );



Any suggestions?





What is the table "complete" used for? by which module?

You can't do anything, only modify source in a way to explicit use fields, and give a default to generate pk, or fill the pk explicitly.


Anyway, which module uses this table?




-giovanni



--


Sincerely,

Giovanni Maruzzelli
OpenTelecom.IT
cell: +39 347 266 56 18
Back to top
abdirahman.osm at gmai...
Guest
PostPosted: Thu Oct 28, 2021 11:27 am    Post subject: [Freeswitch-users] Postgress BDR insert failed for "com Reply with quote
Hi Giovanni,


Thanks for your comment.


I think the table is used by fs_cli to list available commands.
Another possible solution I came across  is to use Replica Identity " ALTER TABLE mytable REPLICA IDENTITY FULL", will give it a try.
Abdirahman A. Osman








On Wed, 27 Oct 2021 at 13:53, Giovanni Maruzzelli <gmaruzz@gmail.com (gmaruzz@gmail.com)> wrote:

Quote:
On Wed, Oct 27, 2021 at 5:44 PM Abdirahman Osman <abdirahman.osm@gmail.com (abdirahman.osm@gmail.com)> wrote:


Quote:
Hello,

I am using postgres  with BDR bidirectional replication which requires primary keys for the freeswitch tables.


 So far so good , except freeswitch is complaining about one table here is the error



2021-10-26 23:40:47.772796 95.47% [DEBUG] mod_pgsql.c:784 Query (insert into complete values (0,'hash_remote', 'list', '', '', '', '', '', '', '', '',  'dagobah-api-gw-1-2')) returned PGRES_FATAL_ERROR
2021-10-26 23:40:47.772796 95.47% [ERR] mod_pgsql.c:551 Error executing query:
ERROR:  column "complete_uuid" is of type uuid but expression is of type integer
LINE 1: insert into complete values (0,'hash_remote', 'list', '', ''...



What I noticed is that freeswitch is doing an INSERT INTO command with no column names specified. I checked the source code and found this to be the only case for the "complete" table whereas the other tables when INSERT INTO is used column names are specified. 


Here is the structure of my  complete table with the new column complete_uuid as primary key.


CREATE TABLE :myschema.complete (
complete_uuid uuid DEFAULT public.gen_random_uuid() PRIMARY KEY,
sticky  INTEGER,
a1  VARCHAR(128),
a2  VARCHAR(128),
a3  VARCHAR(128),
a4  VARCHAR(128),
a5  VARCHAR(128),
a6  VARCHAR(128),
a7  VARCHAR(128),
a8  VARCHAR(128),
a9  VARCHAR(128),
a10 VARCHAR(128),
hostname VARCHAR(256)
        );



Any suggestions?





What is the table "complete" used for? by which module?

You can't do anything, only modify source in a way to explicit use fields, and give a default to generate pk, or fill the pk explicitly.


Anyway, which module uses this table?




-giovanni



--


Sincerely,

Giovanni Maruzzelli
OpenTelecom.IT
cell: +39 347 266 56 18



_________________________________________________________________________

The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.

Join our online community to chat in real time https://signalwire.community

Professional FreeSWITCH Services
sales@freeswitch.com (sales@freeswitch.com)
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org (FreeSWITCH-users@lists.freeswitch.org)
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com
Back to top
gmaruzz at gmail.com
Guest
PostPosted: Thu Oct 28, 2021 12:43 pm    Post subject: [Freeswitch-users] Postgress BDR insert failed for "com Reply with quote
On Thu, Oct 28, 2021 at 5:23 PM Abdirahman Osman <abdirahman.osm@gmail.com (abdirahman.osm@gmail.com)> wrote:

Quote:


I think the table is used by fs_cli to list available commands.
Another possible solution I came across  is to use Replica Identity " ALTER TABLE mytable REPLICA IDENTITY FULL", will give it a try.




You can add an autogenerated uuid (eg: defaults to some uuid generation function) pk to that table, and it will work with BDR



--
Sincerely,

Giovanni Maruzzelli
OpenTelecom.IT
cell: +39 347 266 56 18
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services