[Freeswitch-users] mod_pgsql.c:552 Error executing query: value too long for type character varying(255) on INVITE from LinphoneAndroid/4.6.14
Brian West
brian at freeswitch.com
Mon Nov 21 15:27:42 UTC 2022
Please file it.
On Mon, Nov 21, 2022 at 8:52 AM Дилян Палаузов <dpa-freeswitch at aegee.org>
wrote:
> Hello Brian,
>
> When I run freeSWITCH under strace it prints:
>
> [pid 84702] sendto(42, "Q\0\0\3\202insert into sip_dialogs
> (call_id,uuid,sip_to_user,sip_to_host,sip_to_tag,sip_from_user,sip_from_host,
>
> sip_from_tag,contact_user,contact_host,state,direction,user_agent,profile_name,hostname,contact,presence_id,presence_data,call_info,rcd,
> call_info_state)
> values('OgQbJfQIl-','7aa8f029-9094-4727-a53e-b2e1a0cc0aa5','13','192.168.0.199','','17','192.168.0.199','-1l6slefi','17
> ','192.168.0.146','confirmed','inbound','LinphoneAndroid/4.6.14 (CLT-L09)
> LinphoneSDK/5.1.62 (tags/5.1.62^0)','internal','d','<sip:17 at 19
> 2.168.0.146:58882
> ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2-3COnS
>
> ngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0;transport=udp>;expi
>
> res=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"','
> 17 at 192.168.0.199','','',1669041504,'')\0", 899, MSG_NOSIGNAL
> , NULL, 0 <unfinished ...>
> [pid 84702] <... sendto resumed>) = 899
> [pid 81942] <... clock_gettime resumed>{tv_sec=7522, tv_nsec=214678884}) =
> 0
> [pid 84702] recvfrom(42, <unfinished ...>
> [pid 81942] read(35, <unfinished ...>
> [pid 84702] <... recvfrom resumed>0x7f7c7c00f0e0, 16384, 0, NULL, NULL) =
> -1 EAGAIN (Resource temporarily unavailable)
> [pid 84702] poll([{fd=42,
> events=POLLIN|POLLPRI|POLLERR|POLLHUP|POLLNVAL|POLLRDNORM|POLLRDBAND}], 1,
> 10000) = 1 ([{fd=42, revents=POLLIN
> |POLLRDNORM}])
> [pid 84702] recvfrom(42, "E\0\0\0cSERROR\0VERROR\0C22001\0Mvalue too long
> for type character varying(255)\0Fvarchar.c\0L632\0Rvarchar\0\
> 0Z\0\0\0\5I", 16384, 0, NULL, NULL) = 106
>
> In the sip_dialogs table in Postgresql all columns are character
> varying(255), except the columns expires of type bigint and rcd of type
> int. In
>
> INSERT INTO sip_dialogs
>
> (call_id,uuid,sip_to_user,sip_to_host,sip_to_tag,sip_from_user,sip_from_host,sip_from_tag,contact_user,contact_host,state,direction,user_agent,profile
>
> _name,hostname,contact,presence_id,presence_data,call_info,rcd,call_info_state)
>
> VALUES('OgQbJfQIl-','7aa8f029-9094-4727-a53e-b2e1a0cc0aa5','13','192.168.0.199','','17','192.168.0.199','-
> 1l6slefi','17','192.168.0.146','confirmed','inbound','LinphoneAndroid/4.6.14
> (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0)','internal','d',
> '<sip:17 at 192.168.0.146:58882
> ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2-
>
> 3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-
>
> timeout=0;transport=udp>;expires=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"',
> '17 at 192.168.0.199','','',1669041504,'')
>
> The string
>
> <sip:17 at 192.168.0.146:58882
> ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2-
>
> 3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-
>
> timeout=0;transport=udp>;expires=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"
>
> is 355 bytes and is inserted into column contact. The sip_dialogs table
> is created in src/mod/endpoints/mod_sofia/sofia_glue.c:2486
>
> I think the right fix would be changing CREATE TABLE sip_dialgo in
> src/mod/endpoints/mod_sofia/sofia_glue.c:2486,
>
> Greetings
> Дилян
>
> -----Original Message-----
> From: Brian West <brian at freeswitch.com>
> Reply-To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> Subject: Re: [Freeswitch-users] mod_pgsql.c:552 Error executing query:
> value too long for type character varying(255) on INVITE from
> LinphoneAndroid/4.6.14
> Date: 11/20/2022 07:38:47 PM
>
> Greetings,
>
> Please file an issue here https://github.com/signalwire/freeswitch/issues,
> Also check out our community forum
> here https://forum.signalwire.community/c/freeswitch/17
>
> Thanks,
> Brian
>
>
>
>
> On Sun, Nov 20, 2022 at 5:26 AM Дилян Палаузов <dpa-freeswitch at aegee.org>
> wrote:
> > Hello,
> >
> > upon receiving from Linphone this packet:
> >
> >
> [91/1982]
> > recv 1548 bytes from udp/[192.168.0.146]:60979 at 13:18:42.024773:
>
> >
> ------------------------------------------------------------------------
>
> > INVITE sip:13 at 192.168.0.199 SIP/2.0
>
> > Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport
>
> > From: "17" <sip:17 at 192.168.0.199>;tag=4gQEL2Gnu
>
> > To: sip:13 at 192.168.0.199
>
> > CSeq: 21 INVITE
>
> > Call-ID: JjCHrXlix2
>
> > Max-Forwards: 70
>
> > Supported: replaces, outbound, gruu
>
> > Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE,
> SUBSCRIBE, INFO, PRACK, UPDATE
> > Content-Type: application/sdp
>
> > Content-Length: 425
>
> > Contact: <sip:17 at 192.168.0.146:60979
> ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jb
> >
> jFMiooS9jYqM2-3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0;
> >
> transport=udp>;expires=600;+sip.instance="<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>"
>
> > User-Agent: LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62
> (tags/5.1.62^0)
> > Proxy-Authorization: Digest realm="192.168.0.199",
> nonce="23e41321-96a8-46a0-aae3-9a4d35e55b66", algorithm=MD5,
> username="17", uri="si
> > p:13 at 192.168.0.199", response="b0d38675f5541fd7e8bd4f2e15ad141d",
> cnonce="mqgfEEfiJeT~XLy7", nc=00000001, qop=auth
> >
> > v=0
>
> > o=17 743 229 IN IP4 192.168.0.146
>
> > s=Talk
> > c=IN IP4 192.168.0.146
> > t=0 0
> > a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics
> > m=audio 7078 RTP/AVP 96 97 0 8 3 9 18 98 101
> > a=rtpmap:96 speex/16000
> > a=fmtp:96 vbr=on
> > a=rtpmap:97 speex/8000
> > a=fmtp:97 vbr=on
> > a=fmtp:18 annexb=yes
> > a=rtpmap:98 telephone-event/16000
> > a=rtpmap:101 telephone-event/8000
> > a=rtcp-fb:* trr-int 1000
> > a=rtcp-fb:* ccm tmmbr
> >
> >
> > 2022-11-20 13:18:42.030423 95.90% [ERR] mod_pgsql.c:552 Error executing
> query:
> > ERROR: value too long for type character varying(255)
> >
> > The system logs the above two lines. Or rather, when “sofia profile
> internal siptrace on” is active, fs_cli prints the above text in a row.
> >
> > I am using the latest FreeSwitch (commit bb682fc5b4c4fe67a).
> >
> > Greetings
> > Дилян
> >
> > _________________________________________________________________________
> >
> > The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> > Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
> services.
> > Build your next product on our scalable cloud platform.
> >
> > Join our online community to chat in real time
> https://signalwire.community
> >
> > Professional FreeSWITCH Services
> > sales at freeswitch.com
> > https://freeswitch.com
> >
> > Official FreeSWITCH Sites
> > https://freeswitch.com/oss
> > https://freeswitch.org/confluence
> > https://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
> > https://freeswitch.com
>
>
> --
>
> Brian West | Co-founder and Developer
> Need Commercial support? email sales at freeswitch.com
> FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
> Email: brian at freeswitch.com
> Mobile: 918-424-9378
> Website: https://www.FreeSWITCH.com
> https://www.facebook.com/signalwireinc?src=email
> https://twitter.com/freeswitch
> _________________________________________________________________________
>
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
> services.
> Build your next product on our scalable cloud platform.
>
> Join our online community to chat in real time
> https://signalwire.community
>
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://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
> https://freeswitch.com
>
>
> _________________________________________________________________________
>
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
> services.
> Build your next product on our scalable cloud platform.
>
> Join our online community to chat in real time
> https://signalwire.community
>
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://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
> https://freeswitch.com
--
Brian West | Co-founder and Developer
Need Commercial support? email sales at freeswitch.com
FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
<https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
Email: brian at freeswitch.com
Mobile: 918-424-9378
Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
[image: https://www.facebook.com/signalwireinc?src=email]
<https://www.facebook.com/freeswitch> [image:
https://twitter.com/freeswitch] <https://twitter.com/freeswitch>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20221121/69414716/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list