[Freeswitch-users] Error sending queries to pgsql

Antonio Silva asilva at wirelessmundi.com
Thu Jul 6 12:26:19 UTC 2017


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.



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
>> 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
>
>
>
> _________________________________________________________________________
> 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/20170706/958c429f/attachment-0001.html>


More information about the FreeSWITCH-users mailing list