You're hitting the length limit for one of the database columns, it's probably one of these.

/usr/src/freeswitch/src/mod/endpoints/mod_sofia/sofia_glue.c      
                "   call_id          VARCHAR(255),\n"
                "   sip_user         VARCHAR(255),\n"
                "   sip_host         VARCHAR(255),\n"
                "   presence_hosts   VARCHAR(255),\n"
                "   status           VARCHAR(255),\n"
                "   ping_status      VARCHAR(255),\n"
                "   rpid             VARCHAR(255),\n"
                "   user_agent       VARCHAR(255),\n"
                "   server_user      VARCHAR(255),\n"
                "   server_host      VARCHAR(255),\n"
                "   profile_name     VARCHAR(255),\n"
                "   hostname         VARCHAR(255),\n"
                "   network_ip       VARCHAR(255),\n"
                "   sip_username     VARCHAR(255),\n"
                "   sip_realm        VARCHAR(255),\n"
                "   mwi_user         VARCHAR(255),\n"
                "   mwi_host         VARCHAR(255),\n"
                "   orig_server_host VARCHAR(255),\n"
                "   orig_hostname    VARCHAR(255),\n"
                "   sub_host         VARCHAR(255)\n"
                "   sip_user        VARCHAR(255),\n"
                "   sip_host        VARCHAR(255),\n"
                "   status          VARCHAR(255),\n"
                "   rpid            VARCHAR(255),\n"
                "   user_agent      VARCHAR(255),\n"
                "   profile_name    VARCHAR(255),\n"
                "   hostname        VARCHAR(255),\n"
                "   network_ip      VARCHAR(255),\n"
                "   open_closed     VARCHAR(255)\n"
                "   call_id         VARCHAR(255),\n"
                "   uuid            VARCHAR(255),\n"
                "   sip_to_user     VARCHAR(255),\n"
                "   sip_to_host     VARCHAR(255),\n"
                "   sip_from_user   VARCHAR(255),\n"
                "   sip_from_host   VARCHAR(255),\n"
                "   contact_user    VARCHAR(255),\n"
                "   contact_host    VARCHAR(255),\n"
                "   state           VARCHAR(255),\n"
                "   direction       VARCHAR(255),\n"
                "   user_agent      VARCHAR(255),\n"
                "   profile_name    VARCHAR(255),\n"
                "   hostname        VARCHAR(255),\n"
                "   contact         VARCHAR(255),\n"
                "   presence_id     VARCHAR(255),\n"
                "   presence_data   VARCHAR(255),\n"
                "   call_info       VARCHAR(255),\n"
                "   call_info_state VARCHAR(255) default '',\n"
                "   status          VARCHAR(255),\n"
                "   rpid            VARCHAR(255),\n"
                "   sip_to_tag      VARCHAR(255),\n"
                "   sip_from_tag    VARCHAR(255),\n"
                "   proto           VARCHAR(255),\n"
                "   sip_user        VARCHAR(255),\n"
                "   sip_host        VARCHAR(255),\n"
                "   sub_to_user     VARCHAR(255),\n"
                "   sub_to_host     VARCHAR(255),\n"
                "   presence_hosts  VARCHAR(255),\n"
                "   event           VARCHAR(255),\n"
                "   call_id         VARCHAR(255),\n"
                "   full_from       VARCHAR(255),\n"
                "   full_via        VARCHAR(255),\n"
                "   user_agent      VARCHAR(255),\n"
                "   accept          VARCHAR(255),\n"
                "   profile_name    VARCHAR(255),\n"
                "   hostname        VARCHAR(255),\n"
                "   network_ip      VARCHAR(255),\n"
                "   orig_proto      VARCHAR(255),\n"
                "   full_to         VARCHAR(255)\n"
                "   nonce           VARCHAR(255),\n"
                "   profile_name    VARCHAR(255),\n"
                "   hostname        VARCHAR(255),\n"
                "   subscriber        VARCHAR(255),\n"
                "   call_id           VARCHAR(255),\n"
                "   aor               VARCHAR(255),\n"
                "   profile_name      VARCHAR(255),\n"
                "   hostname          VARCHAR(255),\n"
                "   contact_str       VARCHAR(255),\n"
                "   network_ip        VARCHAR(255)\n"
                "   profile_name      VARCHAR(255),\n"
                "   hostname          VARCHAR(255),\n"
                "   contact_str       VARCHAR(255),\n"
                "   call_id           VARCHAR(255),\n"
                "   network_ip        VARCHAR(255),\n"

From: FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> on behalf of Äèëÿí Ïàëàóçîâ <dpa-freeswitch@aegee.org>
Sent: Sunday, November 20, 2022 12:25
To: freeswitch-users <freeswitch-users@lists.freeswitch.org>
Subject: [Freeswitch-users] mod_pgsql.c:552 Error executing query: value too long for type character varying(255) on INVITE from LinphoneAndroid/4.6.14
 
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 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>;tag=4gQEL2Gnu                                                                                        
To: sip:13@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@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", 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
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
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com