2017-10-18 15:42:56.072002 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts 2017-10-18 15:42:56.072044 [NOTICE] sofia.c:5946 Connecting ODBC Profile dq [sofia_reg_dq] 2017-10-18 15:42:56.072135 [DEBUG] sofia.c:3046 Creating agent for dq 2017-10-18 15:42:56.072226 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_registrations] [delete from sip_registrations where sub_host is null and hostname='ccc-prod-fs2' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] Auto Generating Table! 2017-10-18 15:42:56.072252 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_registrations] [drop table sip_registrations] 2017-10-18 15:42:56.072707 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_subscriptions] [delete from sip_subscriptions where hostname='ccc-prod-fs2' and full_to='XXX'] Auto Generating Table! 2017-10-18 15:42:56.072728 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_subscriptions] [DROP TABLE sip_subscriptions] 2017-10-18 15:42:56.072964 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_dialogs] [delete from sip_dialogs where hostname='ccc-prod-fs2' and (expires <> -9999 or rpid='' or sip_from_tag='' or rcd > 0)] Auto Generating Table! 2017-10-18 15:42:56.072985 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_dialogs] [DROP TABLE sip_dialogs] 2017-10-18 15:42:56.073209 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_presence] [delete from sip_presence where hostname='ccc-prod-fs2' or open_closed=''] Auto Generating Table! 2017-10-18 15:42:56.073229 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_presence] [DROP TABLE sip_presence] 2017-10-18 15:42:56.073418 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_authentication] [delete from sip_authentication where hostname='ccc-prod-fs2' or last_nc >= 0] Auto Generating Table! 2017-10-18 15:42:56.073439 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_authentication] [DROP TABLE sip_authentication] 2017-10-18 15:42:56.073595 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_shared_appearance_subscriptions] [delete from sip_shared_appearance_subscriptions where contact_str='' or hostname='ccc-prod-fs2' and network_ip like '%'] Auto Generating Table! 2017-10-18 15:42:56.073618 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_shared_appearance_subscriptions] [DROP TABLE sip_shared_appearance_subscriptions] 2017-10-18 15:42:56.073802 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: sip_shared_appearance_dialogs] [delete from sip_shared_appearance_dialogs where contact_str='' or hostname='ccc-prod-fs2' and network_ip like '%'] Auto Generating Table! 2017-10-18 15:42:56.073823 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: sip_shared_appearance_dialogs] [DROP TABLE sip_shared_appearance_dialogs] 2017-10-18 15:42:56.114657 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.115028 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.115301 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.115615 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.115912 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.116200 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.116488 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.116780 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.117047 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.117382 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.117696 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.117981 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.118245 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.118493 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.118804 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.119073 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.119344 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.119604 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.119871 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.120119 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.120373 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.120680 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.120922 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.121187 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.121446 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.121739 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.121990 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.122076 [DEBUG] sofia.c:3164 Created agent for agent 2017-10-18 15:42:56.122113 [DEBUG] sofia.c:3212 Set params for agent 2017-10-18 15:42:56.122118 [DEBUG] sofia.c:3259 Activated db for agent 2017-10-18 15:42:56.122240 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.122496 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.122802 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.123065 [INFO] switch_core_sqldb.c:1693 sofia:agent Starting SQL thread. 2017-10-18 15:42:56.123071 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.123141 [DEBUG] sofia.c:3297 Starting thread for agent 2017-10-18 15:42:56.123146 [DEBUG] sofia.c:2946 Launching worker thread for agent 2017-10-18 15:42:56.123314 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.123586 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.123856 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.124119 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.124365 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.124616 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.124862 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.125118 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.125363 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.125638 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.125955 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.126228 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.126480 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.126775 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.127020 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.127278 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.127551 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.127810 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.128063 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.128308 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.128578 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.128836 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.129078 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.129342 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.129619 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.129921 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.130206 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.131297 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.131642 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.131900 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.132176 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.132473 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.132771 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.133060 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.133356 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.133627 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.133883 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.134162 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.134434 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.134691 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.134944 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:56.170467 [DEBUG] sofia.c:3164 Created agent for dq 2017-10-18 15:42:56.170523 [DEBUG] sofia.c:3212 Set params for dq 2017-10-18 15:42:56.170527 [DEBUG] sofia.c:3259 Activated db for dq 2017-10-18 15:42:56.171524 [INFO] switch_core_sqldb.c:1693 sofia:dq Starting SQL thread. 2017-10-18 15:42:56.171612 [DEBUG] sofia.c:3297 Starting thread for dq 2017-10-18 15:42:56.171619 [DEBUG] sofia.c:2946 Launching worker thread for dq 2017-10-18 15:42:56.222627 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory data: [hostname=ccc-prod-fs2§ion=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A56&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A56%20GMT&Event-Date-Timestamp=1508341376123188&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=33&purpose=gateways&profile=agent] 2017-10-18 15:42:56.222818 [NOTICE] sofia_reg.c:3398 Added gateway 'example.com' to profile 'agent' 2017-10-18 15:42:56.270879 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory data: [hostname=ccc-prod-fs2§ion=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A56&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A56%20GMT&Event-Date-Timestamp=1508341376171657&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=36&purpose=gateways&profile=dq] 2017-10-18 15:42:57.072200 [DEBUG] sofia.c:4450 debug [0] 2017-10-18 15:42:57.072220 [DEBUG] sofia.c:4450 sip-trace [no] 2017-10-18 15:42:57.072224 [DEBUG] sofia.c:4450 sip-capture [yes] 2017-10-18 15:42:57.072230 [DEBUG] sofia.c:4450 rfc2833-pt [101] 2017-10-18 15:42:57.072246 [DEBUG] sofia.c:4450 sip-port [5040] 2017-10-18 15:42:57.072250 [DEBUG] sofia.c:4450 dialplan [XML] 2017-10-18 15:42:57.072257 [DEBUG] sofia.c:4450 context [fifo_dp] 2017-10-18 15:42:57.072261 [DEBUG] sofia.c:4450 dtmf-duration [2000] 2017-10-18 15:42:57.072265 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU] 2017-10-18 15:42:57.072271 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU] 2017-10-18 15:42:57.072274 [DEBUG] sofia.c:4450 hold-music [local_stream://moh] 2017-10-18 15:42:57.072277 [DEBUG] sofia.c:4450 rtp-timer-name [soft] 2017-10-18 15:42:57.072279 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto] 2017-10-18 15:42:57.072282 [DEBUG] sofia.c:4450 manage-presence [false] 2017-10-18 15:42:57.072285 [DEBUG] sofia.c:4450 odbc-dsn [pgsql://hostaddr=10.120.3.3 dbname=svp2 user=tms password='s1IghR2gMZ19G81LxFtvc8BH0TJgq7Mw' options='-c client_min_messages=NOTICE' application_name='freeswitch'] 2017-10-18 15:42:57.072290 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous] 2017-10-18 15:42:57.072293 [DEBUG] sofia.c:4450 nonce-ttl [60] 2017-10-18 15:42:57.072295 [DEBUG] sofia.c:4450 auth-calls [false] 2017-10-18 15:42:57.072298 [DEBUG] sofia.c:4450 inbound-late-negotiation [true] 2017-10-18 15:42:57.072301 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true] 2017-10-18 15:42:57.072305 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24] 2017-10-18 15:42:57.072308 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24] 2017-10-18 15:42:57.072312 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat] 2017-10-18 15:42:57.072315 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat] 2017-10-18 15:42:57.072319 [DEBUG] sofia.c:4450 rtp-timeout-sec [300] 2017-10-18 15:42:57.072323 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800] 2017-10-18 15:42:57.072325 [DEBUG] sofia.c:4450 tls [false] 2017-10-18 15:42:57.072329 [DEBUG] sofia.c:4450 tls-only [false] 2017-10-18 15:42:57.072333 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls] 2017-10-18 15:42:57.072337 [DEBUG] sofia.c:4450 tls-sip-port [5041] 2017-10-18 15:42:57.072340 [DEBUG] sofia.c:4450 tls-passphrase [] 2017-10-18 15:42:57.072345 [DEBUG] sofia.c:4450 tls-verify-date [true] 2017-10-18 15:42:57.072351 [DEBUG] sofia.c:4450 tls-verify-policy [none] 2017-10-18 15:42:57.072355 [DEBUG] sofia.c:4450 tls-verify-depth [2] 2017-10-18 15:42:57.072366 [DEBUG] sofia.c:4450 tls-verify-in-subjects [] 2017-10-18 15:42:57.072369 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2] 2017-10-18 15:42:57.072387 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts 2017-10-18 15:42:57.072455 [NOTICE] sofia.c:5946 Connecting ODBC Profile fifo [sofia_reg_fifo] 2017-10-18 15:42:57.072516 [DEBUG] sofia.c:3046 Creating agent for fifo 2017-10-18 15:42:57.091876 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.092199 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.092537 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.092826 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.093099 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.093373 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.093627 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.093921 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.094201 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.094574 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.094900 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.095182 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.095452 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.095709 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.095967 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.096226 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.096483 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.096733 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.096991 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.097266 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.097539 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.097831 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.098100 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.098369 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.098638 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.098924 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.099189 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.099451 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.099743 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.100006 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.100261 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.100518 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.100771 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.101019 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.101288 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.101564 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.101828 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.102113 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.102383 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.102662 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.102931 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.103190 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.103446 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.103693 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.103948 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.104206 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.104465 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.104743 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.105012 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.105291 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.105550 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.105816 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.106104 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.106387 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.106675 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.106970 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.107236 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.107508 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.107788 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.108043 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.108304 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.108561 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.108815 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.109062 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.109325 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.109592 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.109849 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.110122 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.110383 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.110637 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.110899 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.111161 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:57.146952 [DEBUG] sofia.c:3164 Created agent for fifo 2017-10-18 15:42:57.147001 [DEBUG] sofia.c:3212 Set params for fifo 2017-10-18 15:42:57.147004 [DEBUG] sofia.c:3259 Activated db for fifo 2017-10-18 15:42:57.147951 [INFO] switch_core_sqldb.c:1693 sofia:fifo Starting SQL thread. 2017-10-18 15:42:57.148035 [DEBUG] sofia.c:3297 Starting thread for fifo 2017-10-18 15:42:57.148043 [DEBUG] sofia.c:2946 Launching worker thread for fifo 2017-10-18 15:42:57.241538 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory data: [hostname=ccc-prod-fs2§ion=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A57&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A57%20GMT&Event-Date-Timestamp=1508341377148081&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=41&purpose=gateways&profile=fifo] 2017-10-18 15:42:57.371318 [WARNING] sofia.c:2206 MSG Thread 1 Started 2017-10-18 15:42:57.371317 [WARNING] sofia.c:2206 MSG Thread 0 Started 2017-10-18 15:42:58.072567 [DEBUG] sofia.c:4450 debug [0] 2017-10-18 15:42:58.072580 [DEBUG] sofia.c:4450 sip-trace [no] 2017-10-18 15:42:58.072583 [DEBUG] sofia.c:4450 sip-capture [yes] 2017-10-18 15:42:58.072587 [DEBUG] sofia.c:4450 rfc2833-pt [101] 2017-10-18 15:42:58.072593 [DEBUG] sofia.c:4450 sip-port [5042] 2017-10-18 15:42:58.072598 [DEBUG] sofia.c:4450 dialplan [XML] 2017-10-18 15:42:58.072605 [DEBUG] sofia.c:4450 context [ivr_dp] 2017-10-18 15:42:58.072609 [DEBUG] sofia.c:4450 dtmf-duration [2000] 2017-10-18 15:42:58.072616 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU] 2017-10-18 15:42:58.072619 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU] 2017-10-18 15:42:58.072622 [DEBUG] sofia.c:4450 hold-music [local_stream://moh] 2017-10-18 15:42:58.072625 [DEBUG] sofia.c:4450 rtp-timer-name [soft] 2017-10-18 15:42:58.072628 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto] 2017-10-18 15:42:58.072630 [DEBUG] sofia.c:4450 manage-presence [false] 2017-10-18 15:42:58.072634 [DEBUG] sofia.c:4450 odbc-dsn [pgsql://hostaddr=10.120.3.3 dbname=svp2 user=tms password='s1IghR2gMZ19G81LxFtvc8BH0TJgq7Mw' options='-c client_min_messages=NOTICE' application_name='freeswitch'] 2017-10-18 15:42:58.072638 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous] 2017-10-18 15:42:58.072642 [DEBUG] sofia.c:4450 nonce-ttl [60] 2017-10-18 15:42:58.072646 [DEBUG] sofia.c:4450 auth-calls [false] 2017-10-18 15:42:58.072653 [DEBUG] sofia.c:4450 inbound-late-negotiation [true] 2017-10-18 15:42:58.072659 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true] 2017-10-18 15:42:58.072663 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24] 2017-10-18 15:42:58.072666 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24] 2017-10-18 15:42:58.072669 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat] 2017-10-18 15:42:58.072672 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat] 2017-10-18 15:42:58.072675 [DEBUG] sofia.c:4450 rtp-timeout-sec [300] 2017-10-18 15:42:58.072678 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800] 2017-10-18 15:42:58.072682 [DEBUG] sofia.c:4450 enable-3pcc [true] 2017-10-18 15:42:58.072685 [DEBUG] sofia.c:4450 tls [false] 2017-10-18 15:42:58.072691 [DEBUG] sofia.c:4450 tls-only [false] 2017-10-18 15:42:58.072697 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls] 2017-10-18 15:42:58.072706 [DEBUG] sofia.c:4450 tls-sip-port [5043] 2017-10-18 15:42:58.072710 [DEBUG] sofia.c:4450 tls-passphrase [] 2017-10-18 15:42:58.072716 [DEBUG] sofia.c:4450 tls-verify-date [true] 2017-10-18 15:42:58.072721 [DEBUG] sofia.c:4450 tls-verify-policy [none] 2017-10-18 15:42:58.072725 [DEBUG] sofia.c:4450 tls-verify-depth [2] 2017-10-18 15:42:58.072728 [DEBUG] sofia.c:4450 tls-verify-in-subjects [] 2017-10-18 15:42:58.072732 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2] 2017-10-18 15:42:58.072749 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts 2017-10-18 15:42:58.072845 [NOTICE] sofia.c:5946 Connecting ODBC Profile ivr [sofia_reg_ivr] 2017-10-18 15:42:58.072924 [DEBUG] sofia.c:3046 Creating agent for ivr 2017-10-18 15:42:58.081914 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.082291 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.082551 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.082907 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.083221 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.083572 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.083871 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.084201 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.084505 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.084956 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.085284 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.085555 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.085941 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.086220 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.086490 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.086764 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.087033 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.087325 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.087595 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.087874 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.088135 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.088423 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.088676 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.088937 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.089233 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.089491 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.089745 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.090022 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.090296 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.090550 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.090838 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.091090 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.091344 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.091729 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.092025 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.092307 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.092584 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.092869 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.093140 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.093413 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.093673 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.093956 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.094230 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.094471 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.094766 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.095030 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.095347 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.095618 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.095927 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.096229 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.096516 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.096789 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.097089 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.097393 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.097671 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.097957 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.098239 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.098575 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.098870 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.099175 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.099495 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.099751 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.100054 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.100393 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.100687 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.101004 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.101304 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.101572 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.101860 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.102174 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.102461 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.102764 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:58.138762 [DEBUG] sofia.c:3164 Created agent for ivr 2017-10-18 15:42:58.138815 [DEBUG] sofia.c:3212 Set params for ivr 2017-10-18 15:42:58.138818 [DEBUG] sofia.c:3259 Activated db for ivr 2017-10-18 15:42:58.139766 [INFO] switch_core_sqldb.c:1693 sofia:ivr Starting SQL thread. 2017-10-18 15:42:58.139853 [DEBUG] sofia.c:3297 Starting thread for ivr 2017-10-18 15:42:58.139858 [DEBUG] sofia.c:2946 Launching worker thread for ivr 2017-10-18 15:42:58.226917 [ERR] mod_xml_curl.c:315 Received HTTP error 500 trying to fetch https://ccc-prod-lb.objectbrains.com/tms/rest/all_in_one/directory data: [hostname=ccc-prod-fs2§ion=directory&tag_name=&key_name=&key_value=&Event-Name=REQUEST_PARAMS&Core-UUID=17ecaae7-fd12-4299-afd6-870c5152c3ab&FreeSWITCH-Hostname=ccc-prod-fs2&FreeSWITCH-Switchname=ccc-prod-fs2&FreeSWITCH-IPv4=10.120.3.24&FreeSWITCH-IPv6=%3A%3A1&Event-Date-Local=2017-10-18%2015%3A42%3A58&Event-Date-GMT=Wed,%2018%20Oct%202017%2015%3A42%3A58%20GMT&Event-Date-Timestamp=1508341378139898&Event-Calling-File=sofia.c&Event-Calling-Function=launch_sofia_worker_thread&Event-Calling-Line-Number=2967&Event-Sequence=45&purpose=gateways&profile=ivr] 2017-10-18 15:42:59.072987 [DEBUG] sofia.c:4450 debug [0] 2017-10-18 15:42:59.073001 [DEBUG] sofia.c:4450 sip-trace [no] 2017-10-18 15:42:59.073004 [DEBUG] sofia.c:4450 sip-capture [yes] 2017-10-18 15:42:59.073010 [DEBUG] sofia.c:4450 rfc2833-pt [101] 2017-10-18 15:42:59.073016 [DEBUG] sofia.c:4450 sip-port [5048] 2017-10-18 15:42:59.073020 [DEBUG] sofia.c:4450 dialplan [XML] 2017-10-18 15:42:59.073027 [DEBUG] sofia.c:4450 context [rsbc_dp] 2017-10-18 15:42:59.073031 [DEBUG] sofia.c:4450 dtmf-duration [2000] 2017-10-18 15:42:59.073035 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU] 2017-10-18 15:42:59.073039 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU] 2017-10-18 15:42:59.073042 [DEBUG] sofia.c:4450 hold-music [local_stream://moh] 2017-10-18 15:42:59.073044 [DEBUG] sofia.c:4450 rtp-timer-name [soft] 2017-10-18 15:42:59.073046 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto] 2017-10-18 15:42:59.073049 [DEBUG] sofia.c:4450 manage-presence [false] 2017-10-18 15:42:59.073051 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous] 2017-10-18 15:42:59.073054 [DEBUG] sofia.c:4450 nonce-ttl [60] 2017-10-18 15:42:59.073066 [DEBUG] sofia.c:4450 auth-calls [false] 2017-10-18 15:42:59.073071 [DEBUG] sofia.c:4450 inbound-late-negotiation [true] 2017-10-18 15:42:59.073074 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true] 2017-10-18 15:42:59.073076 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24] 2017-10-18 15:42:59.073079 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24] 2017-10-18 15:42:59.073082 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat] 2017-10-18 15:42:59.073086 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat] 2017-10-18 15:42:59.073090 [DEBUG] sofia.c:4450 rtp-timeout-sec [300] 2017-10-18 15:42:59.073093 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800] 2017-10-18 15:42:59.073095 [DEBUG] sofia.c:4450 enable-3pcc [true] 2017-10-18 15:42:59.073100 [DEBUG] sofia.c:4450 tls [false] 2017-10-18 15:42:59.073105 [DEBUG] sofia.c:4450 tls-only [false] 2017-10-18 15:42:59.073130 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls] 2017-10-18 15:42:59.073137 [DEBUG] sofia.c:4450 tls-sip-port [5049] 2017-10-18 15:42:59.073142 [DEBUG] sofia.c:4450 tls-passphrase [] 2017-10-18 15:42:59.073152 [DEBUG] sofia.c:4450 tls-verify-date [true] 2017-10-18 15:42:59.073158 [DEBUG] sofia.c:4450 tls-verify-policy [none] 2017-10-18 15:42:59.073161 [DEBUG] sofia.c:4450 tls-verify-depth [2] 2017-10-18 15:42:59.073169 [DEBUG] sofia.c:4450 tls-verify-in-subjects [] 2017-10-18 15:42:59.073176 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2] 2017-10-18 15:42:59.073199 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts 2017-10-18 15:42:59.073272 [NOTICE] sofia.c:5949 Started Profile rsbc [sofia_reg_rsbc] 2017-10-18 15:42:59.073302 [DEBUG] sofia.c:4450 debug [0] 2017-10-18 15:42:59.073304 [DEBUG] sofia.c:4450 sip-trace [no] 2017-10-18 15:42:59.073306 [DEBUG] sofia.c:4450 sip-capture [yes] 2017-10-18 15:42:59.073309 [DEBUG] sofia.c:4450 rfc2833-pt [101] 2017-10-18 15:42:59.073313 [DEBUG] sofia.c:4450 sip-port [5046] 2017-10-18 15:42:59.073317 [DEBUG] sofia.c:4450 dialplan [XML] 2017-10-18 15:42:59.073325 [DEBUG] sofia.c:4450 context [sbc_dp] 2017-10-18 15:42:59.073331 [DEBUG] sofia.c:4450 dtmf-duration [2000] 2017-10-18 15:42:59.073335 [DEBUG] sofia.c:4450 inbound-codec-prefs [PCMU] 2017-10-18 15:42:59.073345 [DEBUG] sofia.c:4450 outbound-codec-prefs [PCMU] 2017-10-18 15:42:59.073353 [DEBUG] sofia.c:4450 hold-music [local_stream://moh] 2017-10-18 15:42:59.073358 [DEBUG] sofia.c:4450 rtp-timer-name [soft] 2017-10-18 15:42:59.073361 [DEBUG] sofia.c:4450 local-network-acl [localnet.auto] 2017-10-18 15:42:59.073364 [DEBUG] sofia.c:4450 manage-presence [false] 2017-10-18 15:42:59.073365 [DEBUG] sofia.c:3046 Creating agent for rsbc 2017-10-18 15:42:59.073367 [DEBUG] sofia.c:4450 odbc-dsn [pgsql://hostaddr=10.120.3.3 dbname=svp2 user=tms password='s1IghR2gMZ19G81LxFtvc8BH0TJgq7Mw' options='-c client_min_messages=NOTICE' application_name='freeswitch'] 2017-10-18 15:42:59.073421 [DEBUG] sofia.c:4450 inbound-codec-negotiation [generous] 2017-10-18 15:42:59.073428 [DEBUG] sofia.c:4450 nonce-ttl [60] 2017-10-18 15:42:59.073437 [DEBUG] sofia.c:4450 auth-calls [false] 2017-10-18 15:42:59.073443 [DEBUG] sofia.c:4450 inbound-late-negotiation [true] 2017-10-18 15:42:59.073446 [DEBUG] sofia.c:4450 inbound-zrtp-passthru [true] 2017-10-18 15:42:59.073449 [DEBUG] sofia.c:4450 rtp-ip [10.120.3.24] 2017-10-18 15:42:59.073455 [DEBUG] sofia.c:4450 sip-ip [10.120.3.24] 2017-10-18 15:42:59.073458 [DEBUG] sofia.c:4450 ext-rtp-ip [auto-nat] 2017-10-18 15:42:59.073462 [DEBUG] sofia.c:4450 ext-sip-ip [auto-nat] 2017-10-18 15:42:59.073466 [DEBUG] sofia.c:4450 rtp-timeout-sec [300] 2017-10-18 15:42:59.073472 [DEBUG] sofia.c:4450 rtp-hold-timeout-sec [1800] 2017-10-18 15:42:59.073480 [DEBUG] sofia.c:4450 enable-3pcc [true] 2017-10-18 15:42:59.073486 [DEBUG] sofia.c:4450 tls [false] 2017-10-18 15:42:59.073495 [DEBUG] sofia.c:4450 tls-only [false] 2017-10-18 15:42:59.073503 [DEBUG] sofia.c:4450 tls-bind-params [transport=tls] 2017-10-18 15:42:59.073513 [DEBUG] sofia.c:4450 tls-sip-port [5047] 2017-10-18 15:42:59.073520 [DEBUG] sofia.c:4450 tls-passphrase [] 2017-10-18 15:42:59.073530 [DEBUG] sofia.c:4450 tls-verify-date [true] 2017-10-18 15:42:59.073542 [DEBUG] sofia.c:4450 tls-verify-policy [none] 2017-10-18 15:42:59.073549 [DEBUG] sofia.c:4450 tls-verify-depth [2] 2017-10-18 15:42:59.073553 [DEBUG] sofia.c:4450 tls-verify-in-subjects [] 2017-10-18 15:42:59.073559 [DEBUG] sofia.c:4450 tls-version [tlsv1,tlsv1.1,tlsv1.2] 2017-10-18 15:42:59.073569 [INFO] sofia.c:5782 Setting MAX Auth Validity to 0 Attempts 2017-10-18 15:42:59.073618 [NOTICE] sofia.c:5946 Connecting ODBC Profile sbc [sofia_reg_sbc] 2017-10-18 15:42:59.073732 [DEBUG] sofia.c:3046 Creating agent for sbc 2017-10-18 15:42:59.082495 [DEBUG] switch_pgsql.c:415 Query (create index sr_call_id on sip_registrations (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.082792 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_user on sip_registrations (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.083043 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_host on sip_registrations (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.083298 [DEBUG] switch_pgsql.c:415 Query (create index sr_sub_host on sip_registrations (sub_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.083554 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_user on sip_registrations (mwi_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.083800 [DEBUG] switch_pgsql.c:415 Query (create index sr_mwi_host on sip_registrations (mwi_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.084056 [DEBUG] switch_pgsql.c:415 Query (create index sr_profile_name on sip_registrations (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.084309 [DEBUG] switch_pgsql.c:415 Query (create index sr_presence_hosts on sip_registrations (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.084569 [DEBUG] switch_pgsql.c:415 Query (create index sr_contact on sip_registrations (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.084884 [DEBUG] switch_pgsql.c:415 Query (create index sr_expires on sip_registrations (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.085215 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_expires on sip_registrations (ping_expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.085481 [DEBUG] switch_pgsql.c:415 Query (create index sr_hostname on sip_registrations (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.085865 [DEBUG] switch_pgsql.c:415 Query (create index sr_status on sip_registrations (status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.086153 [DEBUG] switch_pgsql.c:415 Query (create index sr_ping_status on sip_registrations (ping_status)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.086406 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_ip on sip_registrations (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.086652 [DEBUG] switch_pgsql.c:415 Query (create index sr_network_port on sip_registrations (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.086900 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_username on sip_registrations (sip_username)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.087153 [DEBUG] switch_pgsql.c:415 Query (create index sr_sip_realm on sip_registrations (sip_realm)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.087394 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_server_host on sip_registrations (orig_server_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.087666 [DEBUG] switch_pgsql.c:415 Query (create index sr_orig_hostname on sip_registrations (orig_hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.087927 [DEBUG] switch_pgsql.c:415 Query (create index ss_call_id on sip_subscriptions (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.088251 [DEBUG] switch_pgsql.c:415 Query (create index ss_multi on sip_subscriptions (call_id, profile_name, hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.088505 [DEBUG] switch_pgsql.c:415 Query (create index ss_hostname on sip_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.088761 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_ip on sip_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.089013 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_user on sip_subscriptions (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.089269 [DEBUG] switch_pgsql.c:415 Query (create index ss_sip_host on sip_subscriptions (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.089553 [DEBUG] switch_pgsql.c:415 Query (create index ss_presence_hosts on sip_subscriptions (presence_hosts)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.089821 [DEBUG] switch_pgsql.c:415 Query (create index ss_event on sip_subscriptions (event)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.090077 [DEBUG] switch_pgsql.c:415 Query (create index ss_proto on sip_subscriptions (proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.090348 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_user on sip_subscriptions (sub_to_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.090635 [DEBUG] switch_pgsql.c:415 Query (create index ss_sub_to_host on sip_subscriptions (sub_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.090900 [DEBUG] switch_pgsql.c:415 Query (create index ss_expires on sip_subscriptions (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.091163 [DEBUG] switch_pgsql.c:415 Query (create index ss_orig_proto on sip_subscriptions (orig_proto)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.091521 [DEBUG] switch_pgsql.c:415 Query (create index ss_network_port on sip_subscriptions (network_port)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.091781 [DEBUG] switch_pgsql.c:415 Query (create index ss_profile_name on sip_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.092096 [DEBUG] switch_pgsql.c:415 Query (create index ss_version on sip_subscriptions (version)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.092425 [DEBUG] switch_pgsql.c:415 Query (create index ss_full_from on sip_subscriptions (full_from)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.092725 [DEBUG] switch_pgsql.c:415 Query (create index ss_contact on sip_subscriptions (contact)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.092997 [DEBUG] switch_pgsql.c:415 Query (create index sd_uuid on sip_dialogs (uuid)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.093297 [DEBUG] switch_pgsql.c:415 Query (create index sd_hostname on sip_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.093586 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_data on sip_dialogs (presence_data)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.093841 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info on sip_dialogs (call_info)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.094120 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_info_state on sip_dialogs (call_info_state)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.094371 [DEBUG] switch_pgsql.c:415 Query (create index sd_expires on sip_dialogs (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.094620 [DEBUG] switch_pgsql.c:415 Query (create index sd_rcd on sip_dialogs (rcd)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.094869 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_tag on sip_dialogs (sip_to_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.095140 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_user on sip_dialogs (sip_from_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.095398 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_host on sip_dialogs (sip_from_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.095657 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_to_host on sip_dialogs (sip_to_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.095914 [DEBUG] switch_pgsql.c:415 Query (create index sd_presence_id on sip_dialogs (presence_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.096156 [DEBUG] switch_pgsql.c:415 Query (create index sd_call_id on sip_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.096406 [DEBUG] switch_pgsql.c:415 Query (create index sd_sip_from_tag on sip_dialogs (sip_from_tag)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.096655 [DEBUG] switch_pgsql.c:415 Query (create index sp_hostname on sip_presence (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.096909 [DEBUG] switch_pgsql.c:415 Query (create index sp_open_closed on sip_presence (open_closed)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.097191 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_user on sip_presence (sip_user)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.097470 [DEBUG] switch_pgsql.c:415 Query (create index sp_sip_host on sip_presence (sip_host)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.097748 [DEBUG] switch_pgsql.c:415 Query (create index sp_profile_name on sip_presence (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.098162 [DEBUG] switch_pgsql.c:415 Query (create index sp_expires on sip_presence (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.098459 [DEBUG] switch_pgsql.c:415 Query (create index sa_nonce on sip_authentication (nonce)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.098764 [DEBUG] switch_pgsql.c:415 Query (create index sa_hostname on sip_authentication (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.099085 [DEBUG] switch_pgsql.c:415 Query (create index sa_expires on sip_authentication (expires)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.099356 [DEBUG] switch_pgsql.c:415 Query (create index sa_last_nc on sip_authentication (last_nc)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.099654 [DEBUG] switch_pgsql.c:415 Query (create index ssa_hostname on sip_shared_appearance_subscriptions (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.099910 [DEBUG] switch_pgsql.c:415 Query (create index ssa_network_ip on sip_shared_appearance_subscriptions (network_ip)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.100179 [DEBUG] switch_pgsql.c:415 Query (create index ssa_subscriber on sip_shared_appearance_subscriptions (subscriber)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.100470 [DEBUG] switch_pgsql.c:415 Query (create index ssa_profile_name on sip_shared_appearance_subscriptions (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.100746 [DEBUG] switch_pgsql.c:415 Query (create index ssa_aor on sip_shared_appearance_subscriptions (aor)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.101019 [DEBUG] switch_pgsql.c:415 Query (create index ssd_profile_name on sip_shared_appearance_dialogs (profile_name)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.101317 [DEBUG] switch_pgsql.c:415 Query (create index ssd_hostname on sip_shared_appearance_dialogs (hostname)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.101632 [DEBUG] switch_pgsql.c:415 Query (create index ssd_contact_str on sip_shared_appearance_dialogs (contact_str)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.101881 [DEBUG] switch_pgsql.c:415 Query (create index ssd_call_id on sip_shared_appearance_dialogs (call_id)) returned PGRES_FATAL_ERROR 2017-10-18 15:42:59.102145 [DEBUG] switch_pgsql.c:415 Query (create index ssd_expires on sip_shared_appearance_dialogs (expires)) returned PGRES_FATAL_ERROR