[Freeswitch-users] Error sending queries to pgsql

[Alexandr Popov]

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>:

> 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>
>>> 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
>> 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/20170704/b96ba66c/attachment.html>