[Freeswitch-users] Postgress BDR insert failed for "complete" table
abdirahman.osm at gmail.com
Thu Oct 28 15:21:58 UTC 2021
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 at gmail.com> wrote:
> On Wed, Oct 27, 2021 at 5:44 PM Abdirahman Osman <abdirahman.osm at gmail.com>
>> 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
>> ERROR: column "complete_uuid" is of type uuid but expression is of type
>> 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 Maruzzelli
> 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
> Build your next product on our scalable cloud platform.
> Join our online community to chat in real time
> Professional FreeSWITCH Services
> sales at freeswitch.com
> Official FreeSWITCH Sites
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the FreeSWITCH-users