[asterisk-bugs] [Asterisk 0018331]: ODBC Disconnection if call not briged

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18331 
====================================================================== 
Reported By:                apsaras
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18331
Category:                   PBX/pbx_realtime
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.37 
JIRA:                       SWP-2629 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-11-18 09:16 CST
Last Modified:              2010-12-07 17:31 CST
====================================================================== 
Summary:                    ODBC Disconnection if call not briged
Description: 
We have several versions of Asterisk installed working with realtime via
ODBC on PostgreSQL Database.

We found out that if a call hungup during IVR (before call is briged) we
get DB Errors, Disconnection and Reconnection.
====================================================================== 

---------------------------------------------------------------------- 
 (0129453) apsaras (reporter) - 2010-12-07 17:31
 https://issues.asterisk.org/view.php?id=18331#c129453 
---------------------------------------------------------------------- 
LOG:  statement: SELECT * FROM sip_users WHERE name = '2111765111'
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '1' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '1' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '1' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '1' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '1' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '2'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '2' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '2'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '2' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = '2109769111' AND
context = 'DialIn' AND priority = '2'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '2' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '2'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '2'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '2'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '3'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '3'
LOG:  statement: SELECT * FROM extensions WHERE exten = 's' AND context =
'DialIn' AND priority = '3'
ERROR:  invalid byte sequence for encoding "UTF8": 0xff
HINT:  This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
LOG:  statement:
LOG:  statement: set DateStyle to 'ISO'
LOG:  statement:
LOG:  statement: set geqo to 'OFF'
LOG:  statement:
LOG:  statement: select oid from pg_type where typname='lo'
LOG:  statement: select version()
ERROR:  invalid byte sequence for encoding "UTF8": 0xff
HINT:  This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
LOG:  statement:
LOG:  statement: set DateStyle to 'ISO'
LOG:  statement:
LOG:  statement: set geqo to 'OFF'
LOG:  statement:
LOG:  statement: select oid from pg_type where typname='lo'
LOG:  statement: select version()
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '1' ORDER BY exten
LOG:  statement: SELECT * FROM extensions WHERE exten = 'h' AND context =
'DialIn' AND priority = '1'
LOG:  statement: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND
context = 'DialIn' AND priority = '1' ORDER BY exten
LOG:  statement: INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield)
VALUES ('2010-12-08
01:27:56','2111765111','2111765111','s','DialIn','SIP/commgate-00002326','','BackGround','metromall',5,4,'ANSWERED',3,'','1291764476.9000','')


Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-07 17:31 apsaras        Note Added: 0129453                          
======================================================================