<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hello all,<div class=""><br class=""></div><div class="">Recently I tried to build a new server with FreeSWITCH 1.8.7 and PostgreSQL 11.</div><div class=""><br class=""></div><div class="">The installation went well, but error occurred when I tried to run fs with:</div><div class=""><br class=""></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class="">/usr/local/freeswitch/bin/freeswitch -u freeswitch -g freeswitch</div></blockquote><div class=""><br class=""></div><div class="">And core-db-dsn is set as:</div><div class=""><br class=""></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class=""> <param name="core-db-dsn" value="<a href="pgsql://host=localhost" class="">pgsql://host=localhost</a> dbname=freeswitch user=freeswitch password='freeswitch' options='-c client_min_messages=NOTICE' application_name='freeswitch' sslmode=disable" /></div></blockquote><div class=""><br class=""></div><div class="">I had created an empty db named “freeswitch” in postgres, and I got lots of error like:</div><div class=""><br class=""></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class=""><div class=""><div class="">2020-06-01 11:58:16.760201 [ERR] switch_pgsql.c:680 Error executing query:</div><div class="">ERROR: relation "detailed_calls" does not exist</div><div class="">LINE 1: select * from detailed_calls where sent_callee_name=''</div><div class=""> ^</div><div class=""><br class=""></div><div class="">2020-06-01 11:58:16.760258 [DEBUG] switch_pgsql.c:439 Query (DROP VIEW detailed_calls) returned PGRES_FATAL_ERROR</div><div class="">2020-06-01 11:58:16.760285 [ERR] switch_pgsql.c:680 Error executing query:</div><div class="">ERROR: view "detailed_calls" does not exist</div><div class=""><br class=""></div><div class="">2020-06-01 11:58:16.764675 [DEBUG] switch_pgsql.c:439 Query (select ikey from interfaces) returned PGRES_FATAL_ERROR</div><div class="">2020-06-01 11:58:16.764688 [ERR] switch_pgsql.c:680 Error executing query:</div><div class="">ERROR: relation "interfaces" does not exist</div><div class="">LINE 1: select ikey from interfaces</div><div class=""> ^</div><div class=""><br class=""></div><div class="">2020-06-01 11:58:16.764801 [DEBUG] switch_pgsql.c:439 Query (DROP TABLE interfaces) returned PGRES_FATAL_ERROR</div><div class="">2020-06-01 11:58:16.764814 [ERR] switch_pgsql.c:680 Error executing query:</div><div class="">ERROR: table "interfaces" does not exist</div><div class=""><br class=""></div><div class="">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</div><div class="">2020-06-01 11:58:16.770512 [ERR] switch_pgsql.c:680 Error executing query:</div><div class="">ERROR: relation "tasks" does not exist</div><div class="">LINE 1: ...k_group, task_runtime, task_sql_manager, hostname from tasks</div><div class=""> ^</div><div class=""><br class=""></div><div class="">2020-06-01 11:58:16.770567 [DEBUG] switch_pgsql.c:439 Query (DROP TABLE tasks) returned PGRES_FATAL_ERROR</div><div class="">2020-06-01 11:58:16.770595 [ERR] switch_pgsql.c:680 Error executing query:</div><div class="">ERROR: table "tasks" does not exist</div></div></div><div class=""><br class=""></div><div class="">...</div></blockquote><div class=""><br class=""></div><div class="">Actually freeswitch had created its core table in postgresql at this time, and I confirmed the table exists via psql. </div><div class="">However, the different error occured in 2nd try:</div><div class=""><br class=""></div><blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;" class=""><div class=""><div class="">2020-06-01 12:03:47.362395 [DEBUG] switch_pgsql.c:439 Query (create index uuindex on channels (uuid, hostname)) returned PGRES_FATAL_ERROR</div></div><div class=""><div class="">2020-06-01 12:03:47.362434 [ERR] switch_pgsql.c:680 Error executing query:</div></div><div class=""><div class="">ERROR: relation "uuindex" already exists</div></div><div class=""><div class=""><br class=""></div></div><div class=""><div class="">2020-06-01 12:03:47.362681 [DEBUG] switch_pgsql.c:439 Query (create index uuindex2 on channels (call_uuid)) returned PGRES_FATAL_ERROR</div></div><div class=""><div class="">2020-06-01 12:03:47.362744 [ERR] switch_pgsql.c:680 Error executing query:</div></div><div class=""><div class="">ERROR: relation "uuindex2" already exists</div></div><div class=""><div class=""><br class=""></div></div><div class=""><div class="">2020-06-01 12:03:47.363019 [DEBUG] switch_pgsql.c:439 Query (create index callsidx1 on calls (hostname)) returned PGRES_FATAL_ERROR</div></div><div class=""><div class="">2020-06-01 12:03:47.363058 [ERR] switch_pgsql.c:680 Error executing query:</div></div><div class=""><div class="">ERROR: relation "callsidx1" already exists</div></div><div class=""><div class=""><br class=""></div></div><div class=""><div class="">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</div></div><div class=""><div class="">2020-06-01 12:03:47.363348 [ERR] switch_pgsql.c:680 Error executing query:</div></div><div class=""><div class="">ERROR: relation "eruuindex" already exists</div></div><div class=""><div class=""><br class=""></div></div><div class=""><div class="">2020-06-01 12:03:47.363649 [DEBUG] switch_pgsql.c:439 Query (create index eeuuindex on calls (callee_uuid)) returned PGRES_FATAL_ERROR</div></div><div class=""><div class="">2020-06-01 12:03:47.363690 [ERR] switch_pgsql.c:680 Error executing query:</div></div><div class=""><div class="">ERROR: relation "eeuuindex" already exists</div></div><div class=""><div class=""><br class=""></div></div><div class=""><div class="">2020-06-01 12:03:47.363949 [DEBUG] switch_pgsql.c:439 Query (create index eeuuindex2 on calls (call_uuid)) returned PGRES_FATAL_ERROR</div></div><div class=""><div class="">2020-06-01 12:03:47.363987 [ERR] switch_pgsql.c:680 Error executing query:</div></div><div class=""><div class="">ERROR: relation "eeuuindex2" already exists</div></div><div class=""><br class=""></div></blockquote>It seems that freeswitch is trying to create same index again in postgresql.<div class=""><br class=""><div class="">All SQL execute is done by freeswitch, so I wonder if there is a bug in freeswitch or I got a broken installation.</div><div class=""><br class=""></div><div class="">Any suggestion would be appreciated.</div><div class=""><br class=""></div><div class="">Regards.<br class=""><div class="">
<div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">——————————————————</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">王聡</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><a href="mailto:cong.wang.itsherpa@gmail.com" class="">cong.wang.itsherpa@gmail.com</a></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br class=""></div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">〒810−0073<br class="">福岡市中央区舞鶴2-3-6<br class="">赤坂プライムビル 2F</div><div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">株式会社アイティーシェルパ</div></div>
</div>
<br class=""></div></div></body></html>