[Freeswitch-users] Error sending queries to pgsql

[Antonio Silva]

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
> 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/20170704/91053d5f/attachment-0001.html>