[Freeswitch-users] FreeSWITCH Core DB with Postgres

[王聡]

Hello all,

Recently I tried to build a new server with FreeSWITCH 1.8.7 and PostgreSQL 11.

The installation went well, but error occurred when I tried to run fs with:

/usr/local/freeswitch/bin/freeswitch -u freeswitch -g freeswitch

And core-db-dsn is set as:

 <param name="core-db-dsn" value="pgsql://host=localhost dbname=freeswitch user=freeswitch password='freeswitch' options='-c client_min_messages=NOTICE' application_name='freeswitch' sslmode=disable" />

I had created an empty db named “freeswitch” in postgres, and I got lots of error like:

2020-06-01 11:58:16.760201 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "detailed_calls" does not exist
LINE 1: select * from detailed_calls where sent_callee_name=''
                      ^

2020-06-01 11:58:16.760258 [DEBUG] switch_pgsql.c:439 Query (DROP VIEW detailed_calls) returned PGRES_FATAL_ERROR
2020-06-01 11:58:16.760285 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  view "detailed_calls" does not exist

2020-06-01 11:58:16.764675 [DEBUG] switch_pgsql.c:439 Query (select ikey from interfaces) returned PGRES_FATAL_ERROR
2020-06-01 11:58:16.764688 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "interfaces" does not exist
LINE 1: select ikey from interfaces
                         ^

2020-06-01 11:58:16.764801 [DEBUG] switch_pgsql.c:439 Query (DROP TABLE interfaces) returned PGRES_FATAL_ERROR
2020-06-01 11:58:16.764814 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  table "interfaces" does not exist

2020-06-01 11:58:16.770480 [DEBUG] switch_pgsql.c:439 Query (select task_id, task_desc, task_group, task_runtime, task_sql_manager, hostname from tasks) returned PGRES_FATAL_ERROR
2020-06-01 11:58:16.770512 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "tasks" does not exist
LINE 1: ...k_group, task_runtime, task_sql_manager, hostname from tasks
                                                                  ^

2020-06-01 11:58:16.770567 [DEBUG] switch_pgsql.c:439 Query (DROP TABLE tasks) returned PGRES_FATAL_ERROR
2020-06-01 11:58:16.770595 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  table "tasks" does not exist

...

Actually freeswitch had created its core table in postgresql at this time, and I confirmed the table exists via psql. 
However, the different error occured in 2nd try:

2020-06-01 12:03:47.362395 [DEBUG] switch_pgsql.c:439 Query (create index uuindex on channels (uuid, hostname)) returned PGRES_FATAL_ERROR
2020-06-01 12:03:47.362434 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "uuindex" already exists

2020-06-01 12:03:47.362681 [DEBUG] switch_pgsql.c:439 Query (create index uuindex2 on channels (call_uuid)) returned PGRES_FATAL_ERROR
2020-06-01 12:03:47.362744 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "uuindex2" already exists

2020-06-01 12:03:47.363019 [DEBUG] switch_pgsql.c:439 Query (create index callsidx1 on calls (hostname)) returned PGRES_FATAL_ERROR
2020-06-01 12:03:47.363058 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "callsidx1" already exists

2020-06-01 12:03:47.363303 [DEBUG] switch_pgsql.c:439 Query (create index eruuindex on calls (caller_uuid, hostname)) returned PGRES_FATAL_ERROR
2020-06-01 12:03:47.363348 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "eruuindex" already exists

2020-06-01 12:03:47.363649 [DEBUG] switch_pgsql.c:439 Query (create index eeuuindex on calls (callee_uuid)) returned PGRES_FATAL_ERROR
2020-06-01 12:03:47.363690 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "eeuuindex" already exists

2020-06-01 12:03:47.363949 [DEBUG] switch_pgsql.c:439 Query (create index eeuuindex2 on calls (call_uuid)) returned PGRES_FATAL_ERROR
2020-06-01 12:03:47.363987 [ERR] switch_pgsql.c:680 Error executing query:
ERROR:  relation "eeuuindex2" already exists

It seems that freeswitch is trying to create same index again in postgresql.

All SQL execute is done by freeswitch, so I wonder if there is a bug in freeswitch or I got a broken installation.

Any suggestion would be appreciated.

Regards.
——————————————————

王聡
cong.wang.itsherpa at gmail.com

〒810−0073
福岡市中央区舞鶴2-3-6
赤坂プライムビル 2F
株式会社アイティーシェルパ

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200601/55ad443a/attachment.html>