[asterisk-users] Asterisk and realtime

[Andrew Nowrot]

Hi

I am using asterisk 10.1.3

When user hangs up during playing audio files in Background used in
realtime extensions with postgres I am getting this log on the
console:
[Feb  1 23:04:54] ERROR[4831]: res_config_pgsql.c:166 _pgsql_exec:
PostgreSQL RealTime: Failed to query 'extensions_conf at asterisk'.
[Feb  1 23:04:54] ERROR[4831]: res_config_pgsql.c:167 _pgsql_exec:
PostgreSQL RealTime: Query Failed: SELECT * FROM extensions_conf WHERE
exten LIKE '�%' AND context = 'Ivr-main' AND priority = '1'
[Feb  1 23:04:54] ERROR[4831]: res_config_pgsql.c:168 _pgsql_exec:
PostgreSQL RealTime: Query Failed because: ERROR:  postgres invalid
byte sequence for encoding "UTF8": 0xff
 (PGRES_FATAL_ERROR)
In never happend during execution of other applications in realtime;
always in Background.

I have reported this in issues.asterisk.org/jira:
https://issues.asterisk.org/jira/browse/ASTERISK-19291
but I also want to ask you for an opinion.

My dialplan looks like this:

[incoming]

exten => 0XXXXXXXXX,1,Answer() ; X are to hide the number
exten => 0XXXXXXXXX,2,Goto(incoming,s,10)

exten => s,10,Set(TRANSFER_CONTEXT=Inside)
exten => s,11,GotoIfTime(07:00-16:00,mon-fri,*,*?Ivr-main,s,1)
exten => s,12,Playback(ivr/welcome&ivr/hours&ivr/thankyou)
exten => s,13,Hangup()

[Ivr-main]

switch => Realtime/${CONTEXT}@extensions
________________________________

extensons_conf table in postgresql database

id  | context  | exten | priority |    app     |
                                  appdata
-----+----------+-------+----------+------------+-------------------------------------------------------------------------------------------------------------------------
 190 | Ivr-main | 1     |        1 | Goto       | Inside,10,1
 191 | Ivr-main | 2     |        1 | Goto       | Inside,11,1
 192 | Ivr-main | 3     |        1 | Goto       | Inside,12,1
 193 | Ivr-main | 4     |        1 | Goto       | Inside,13,1
 194 | Ivr-main | 5     |        1 | Goto       | Inside,14,1
 197 | Ivr-main | h     |        1 | Hangup     |
 195 | Ivr-main | i     |        1 | Goto       | Ivr-main,s,1
 188 | Ivr-main | s     |        1 | Wait       | 1
 189 | Ivr-main | s     |        2 | Background |
ivr/welcome2&ivr/hours&ivr/operator&ivr/sales&ivr/accountants&ivr/technical&ivr/marketing&ivr/warehouse&ivr/thankyou
 196 | Ivr-main | t     |        1 | Goto       | Inside,10,1
 198 | Ivr-main | _XX   |        1 | Goto       | Inside,${EXTEN},1


Does anyone have similar behaviour?
What can i do to fix this?

Best Regards

Andrew