<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="">Hi,<div class=""><br class=""></div><div class="">we have about 800 connected users, 150 simultaneous calls and some user agents send sip messages with non UTF-8 characters.</div><div class="">When FreeSWITCH tries to alter the channel information in the postgres db it throughs an error:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(177, 37, 19); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">2018-03-29 15:47:46.794346 [ERR] switch_pgsql.c:656 Error executing query:</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: Courier; color: rgb(177, 37, 19); background-color: rgb(223, 219, 195);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">ERROR: invalid byte sequence for encoding "UTF8": 0xf6 0x63 0x68 0x6c</span></div></div><div class=""><br class=""></div><div class="">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!</div><div class="">It seems that everytime the error happens, Freeswitch cannot delete other channels from db when the bye is arriving +/- 100ms near the error.</div><div class=""><br class=""></div><div class="">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.</div><div class=""><br class=""></div><div class="">How should we deal with that?</div><div class=""><br class=""></div><div class="">Thanks,</div><div class="">Roman</div><div class=""><div><br class=""></div><div><div class=""><font face="GillSans-SemiBold" color="#53655a" class=""><b class="">RDI SOLUTIONS e.U.</b></font></div><div class=""><font color="#4d4e4c" face="GillSans-Light" class="">Hollenthon 105</font></div><div class=""><font face="GillSans-Light" color="#4d4e4c" class="">2812 Hollenthon, Österreich</font></div><div class=""><font face="GillSans-Light" color="#4d4e4c" class="">T: +43 1 3530349 - 10</font></div><div class=""><font face="GillSans-Light" color="#4d4e4c" class="">F: +43 1 3530349 - 99</font></div><div class=""><font face="GillSans-Light" color="#4d4e4c" class=""><a href="mailto:roman.dissauer@rdi.at" class="">roman.dissauer@rdi.at</a></font></div><div class=""><font color="#4d4e4c" face="GillSans-SemiBold" class=""><b class=""><a href="http://www.rdi.at" class="">www.rdi.at</a></b></font></div></div></div></body></html>