[Freeswitch-users] Error sending queries to pgsql

Antonio Silva asilva at wirelessmundi.com
Fri Jul 14 14:25:02 UTC 2017


Hi Alexandr,

I've advance something in debugging this issue..

Do you use sip/wss or verto endpoints in your box?

Saludos / Regards / Cumprimentos,
António silva

On 07/06/2017 04:13 PM, Alexandr Popov wrote:
> i'm receiving two type of of error at FS are [FATAL:  invalid frontend 
> message type 21
> ]
> and
> This probably means the server terminated abnormally
> before or while processing the request.
> [Error sending query!]
>
>
> at postgers log i getting only -- invalid frontend message type 21
>
>
> 2017-07-06 15:26 GMT+03:00 Antonio Silva <asilva at wirelessmundi.com 
> <mailto:asilva at wirelessmundi.com>>:
>
>     Hi,
>
>     same results on old kernel..
>     i'm trying to reproduce it on isolate machine.. for now i put my
>     findings in jira https://freeswitch.org/jira/browse/FS-10474
>     <https://freeswitch.org/jira/browse/FS-10474>.
>
>
>
>     Alexandr:
>
>     What SO are you running? did you get some errors from postgres
>     before fs critical message?
>
>
>     Saludos / Regards / Cumprimentos,
>     António silva
>
>     On 07/04/2017 11:34 AM, Antonio Silva wrote:
>>     In this same box i also have data corruption with sqlite
>>     databases, special the ones that i use with mod_lua.. but I think
>>     that it could be something related with kernel.. i recently
>>     update to 4.9.x, and there was some changes in ext4.
>>
>>     I don't really know how to debug this, so today i'm reverting to
>>     the old kernel, 4.4.x and check it happens again..
>>
>>     If it happens again, my next move will try to reproduce this in FS..
>>
>>     Saludos / Regards / Cumprimentos,
>>     António silva
>>     On 07/04/2017 10:58 AM, Alexandr Popov wrote:
>>>     Seems its trouble with sockets. I have the same problem appeared
>>>     about a month ago.
>>>
>>>     2017-06-29 19:31 GMT+03:00 Antonio Silva
>>>     <asilva at wirelessmundi.com <mailto:asilva at wirelessmundi.com>>:
>>>
>>>         Hi Michael,
>>>
>>>         Yes, i'm trying to figure it out if is an issue in FS or
>>>         external.. but the message from PG i can't translate it.. i
>>>         just enable more logs to see if i got extra hints...
>>>
>>>
>>>         Thanks.
>>>
>>>         Saludos / Regards / Cumprimentos,
>>>         António silva
>>>
>>>         On 06/29/2017 06:22 PM, Michael Jerris wrote:
>>>
>>>             If you can figure out a reliable way to reproduce this
>>>             issue, please file a jira with details on what causes it.
>>>
>>>                 On Jun 29, 2017, at 7:22 AM, Antonio Silva
>>>                 <asilva at wirelessmundi.com
>>>                 <mailto:asilva at wirelessmundi.com>> wrote:
>>>
>>>                 Hi all,
>>>
>>>                 i use pgsql in core and from time to time i see
>>>                 critical messages like fail to send query, example:
>>>
>>>                 [CRIT] switch_pgsql.c:255 Failed to send query
>>>                 (update sip_authentication set
>>>                 expires='1498726568',last_nc=364 where
>>>                 nonce='3c20da2e-b663-46fe-8edc-c756f9166d07') to
>>>                 database: server closed the connection unexpectedly
>>>
>>>                 This was recently, i did an update to current master
>>>                 the previous version was from April, not sure if it
>>>                 could be an error on FS o some other issue on my box..
>>>
>>>
>>>                 PG is installed on the same server and the only
>>>                 thing i see from pg is "postgres[2236]: FATAL: 
>>>                 invalid frontend message type 21", PG is installed
>>>                 on the same server, running on /dev/shm with the
>>>                 same prio as FS and  the process never stopped.
>>>
>>>
>>>                 anyone has experience this error before? any idea
>>>                 what it could be the cause?
>>>
>>>
>>>             _________________________________________________________________________
>>>             Professional FreeSWITCH Consulting Services:
>>>             consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>>             http://www.freeswitchsolutions.com
>>>             <http://www.freeswitchsolutions.com>
>>>
>>>             Official FreeSWITCH Sites
>>>             http://www.freeswitch.org
>>>             http://confluence.freeswitch.org
>>>             <http://confluence.freeswitch.org>
>>>             http://www.cluecon.com
>>>
>>>             FreeSWITCH-users mailing list
>>>             FreeSWITCH-users at lists.freeswitch.org
>>>             <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>             http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>             <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>             UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>             <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>             http://www.freeswitch.org
>>>
>>>
>>>
>>>         _________________________________________________________________________
>>>         Professional FreeSWITCH Consulting Services:
>>>         consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>>         http://www.freeswitchsolutions.com
>>>         <http://www.freeswitchsolutions.com>
>>>
>>>         Official FreeSWITCH Sites
>>>         http://www.freeswitch.org
>>>         http://confluence.freeswitch.org
>>>         <http://confluence.freeswitch.org>
>>>         http://www.cluecon.com
>>>
>>>         FreeSWITCH-users mailing list
>>>         FreeSWITCH-users at lists.freeswitch.org
>>>         <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>         http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>         <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>         UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>         <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>         http://www.freeswitch.org
>>>
>>>
>>>
>>>
>>>     _________________________________________________________________________
>>>     Professional FreeSWITCH Consulting Services:
>>>     consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>>     http://www.freeswitchsolutions.com
>>>     <http://www.freeswitchsolutions.com>
>>>
>>>     Official FreeSWITCH Sites
>>>     http://www.freeswitch.org
>>>     http://confluence.freeswitch.org <http://confluence.freeswitch.org>
>>>     http://www.cluecon.com
>>>
>>>     FreeSWITCH-users mailing list
>>>     FreeSWITCH-users at lists.freeswitch.org
>>>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>     <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>     <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>     http://www.freeswitch.org
>>
>>     _________________________________________________________________________
>>     Professional FreeSWITCH Consulting Services:
>>     consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>     http://www.freeswitchsolutions.com
>>     <http://www.freeswitchsolutions.com>
>>
>>     Official FreeSWITCH Sites
>>     http://www.freeswitch.org
>>     http://confluence.freeswitch.org <http://confluence.freeswitch.org>
>>     http://www.cluecon.com
>>
>>     FreeSWITCH-users mailing list
>>     FreeSWITCH-users at lists.freeswitch.org
>>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>     <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>     <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>     http://www.freeswitch.org
>     _________________________________________________________________________
>     Professional FreeSWITCH Consulting Services:
>     consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>     http://www.freeswitchsolutions.com
>     <http://www.freeswitchsolutions.com> Official FreeSWITCH Sites
>     http://www.freeswitch.org http://confluence.freeswitch.org
>     <http://confluence.freeswitch.org> http://www.cluecon.com
>     FreeSWITCH-users mailing list
>     FreeSWITCH-users at lists.freeswitch.org
>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>     <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>     <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>     http://www.freeswitch.org 
>
> _________________________________________________________________________
> 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/20170714/ca30510d/attachment-0001.html>


More information about the FreeSWITCH-users mailing list