brian at freeswitch.com
Guest
|
 Posted: Mon Nov 21, 2022 11:02 am Post subject: [Freeswitch-users] mod_pgsql.c:552 Error executing query: va |
 |
|
Please file it.
On Mon, Nov 21, 2022 at 8:52 AM Дилян Палаузов <dpa-freeswitch@aegee.org (dpa-freeswitch@aegee.org)> wrote:
| Quote: | 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@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@192.168.0.199 (17@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@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@192.168.0.199 (17@192.168.0.199)','','',1669041504,'')
The string
<sip:17@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@freeswitch.com (brian@freeswitch.com)>
Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)>
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org (freeswitch-users@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@aegee.org (dpa-freeswitch@aegee.org)> wrote:
| Quote: | 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@192.168.0.199 ([email]sip%3A13@192.168.0.199[/email]) SIP/2.0
Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport
From: "17" <sip:17@192.168.0.199 ([email]sip%3A17@192.168.0.199[/email])>;tag=4gQEL2Gnu
To: sip:13@192.168.0.199 ([email]sip%3A13@192.168.0.199[/email])
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@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@192.168.0.199 ([email]p%3A13@192.168.0.199[/email])", 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@freeswitch.com (sales@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@lists.freeswitch.org (FreeSWITCH-users@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@freeswitch.com (sales@freeswitch.com)
FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
Email: brian@freeswitch.com (brian@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@freeswitch.com (sales@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@lists.freeswitch.org (FreeSWITCH-users@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@freeswitch.com (sales@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@lists.freeswitch.org (FreeSWITCH-users@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@freeswitch.com (sales@freeswitch.com)
FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
Email: brian@freeswitch.com (brian@freeswitch.com)
Mobile: 918-424-9378
Website: https://www.FreeSWITCH.com
[/url] [url=https://twitter.com/freeswitch] |
|
Search
