[Freeswitch-users] Error sending queries to pgsql

Thu Jul 6 14:13:43 UTC 2017

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

> 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>:
>
>> 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
>>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://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/49a32d0f/attachment.html>