[Freeswitch-users] postgres db contains non existent channels

[Tihomir Culjaga]

Hi,

 can you capture what fs is trying to save ?
do you have a sip message capture in wireshark ?



On 29 March 2018 at 20:14, Roman Dissauer <roman at dissauer.net> wrote:

> Hi,
>
> we have about 800 connected users, 150 simultaneous calls and some user
> agents send sip messages with non UTF-8 characters.
> When FreeSWITCH tries to alter the channel information in the postgres db
> it throughs an error:
>
> 2018-03-29 15:47:46.794346 [ERR] switch_pgsql.c:656 Error executing query:
> ERROR:  invalid byte sequence for encoding "UTF8": 0xf6 0x63 0x68 0x6c
>
> The Problem now is that we see some calls in the database which do not
> exist anymore (uuid_exists returns false). This are other calls, not the
> one which cause the error above!
> It seems that everytime the error happens, Freeswitch cannot delete other
> channels from db when the bye is arriving +/- 100ms near the error.
>
> We tried to set client_encoding in the postgres connection string to some
> options e.g. LATIN1 but that didn’t solve our problem. Whichever
> client_encoding we used, we always had some user agents with some unknown
> characters.
>
> How should we deal with that?
>
> Thanks,
> Roman
>
> *RDI SOLUTIONS e.U.*
> Hollenthon 105
> 2812 Hollenthon, Österreich
> T: +43 1 3530349 <+43%201%203530349> - 10
> F: +43 1 3530349 <+43%201%203530349> - 99
> roman.dissauer at rdi.at
> *www.rdi.at <http://www.rdi.at>*
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180401/96bd07f8/attachment.html>