[OpenSIPS-Devel] [ opensips-Bugs-2823259 ] postgres insert into dialog generates error
SourceForge.net
noreply at sourceforge.net
Mon Jul 20 18:42:22 CEST 2009
Bugs item #2823259, was opened at 2009-07-17 22:10
Message generated for change (Settings changed) made by bogdan_iancu
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2823259&group_id=232389
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: 1.5.x
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Patrick F. (padraigf65)
Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: postgres insert into dialog generates error
Initial Comment:
postgres[38330]: [4-1] ERROR: syntax error at end of input at character 446
This is the statement from postgres logfile
insert into dialog (hash_entry,hash_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,callee_sock,start_time,state,timeout,caller_cseq,callee_cseq,caller_route_
set,callee_route_set,caller_contact,callee_contact ) values (3192,901188333,'XXXXXXXXXXX-XXXX at XXXXXXXXXX','sip:5555551212 at 192.168.113.92','8a05ee72','sip:5555551313
@192.168.93.27','80380344-69E','udp:192.168.93.27:5060','udp:192.168.93.27:5060',1247856162,3,1247856161,'1','1',NULL
----------------------------------------------------------------------
>Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-07-20 19:42
Message:
Hi Patrick,
the fix is available on SVN - please upload and test again.
Thanks and regards,
Bogdan
----------------------------------------------------------------------
Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-07-20 14:43
Message:
Hi Patrick.
Do you get any other error in the opensips logs? like "error while
preparing insert operation" ?
Bogdan
----------------------------------------------------------------------
Comment By: Patrick F. (padraigf65)
Date: 2009-07-17 22:11
Message:
version: opensips 1.5.2-notls (x86_64/freebsd)
flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM,
SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
Version info:
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, select, kqueue.
svnrevision: 2:5888M
@(#) $Id: main.c 5887 2009-07-16 11:47:46Z bogdan_iancu $
main.c compiled on 14:30:11 Jul 17 2009 with gcc 4.2.1
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2823259&group_id=232389
More information about the Devel
mailing list