<div style="font-family: Helvetica; font-size: 13px;">report to jira including your FreeSWITCH version<br></div>
<div><div><br></div><div>-- </div><div>Seven Du</div><div><span style="font-size: 10pt;">http://about.me/dujinfang</span></div><div><div>http://www.dujinfang.com</div></div><div><div><span style="font-size: 10pt;">http://www.freeswitch.org.cn</span></div></div><div><span style="font-size: 10pt;"><br></span></div><div>Sent with <a href="http://www.sparrowmailapp.com/?sig">Sparrow</a></div><div><br></div></div>
<p style="color: #A0A0A8;">On Monday, October 13, 2014 at 10:40 PM, Linux Vince wrote:</p>
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;">
<span><div><div><div dir="ltr">Hi,<div><br></div><div>I am trying to confure FreeSwitch for my VOIP gateway.</div><div><br></div><div>It works really good in testing in low load.</div><div><br></div><div>However, whenever i try to increase load it takes only around 240 concurrent calls and any call beyond that it starts giving 503, Bad Gateway errors.</div><div><br></div><div>On console i start getting below error, which led me to believe that database issue and it seems it cannot take more connections. I tried setting up MySQL as database as well with same results.</div><div><br></div><div><div>2014-10-13 20:00:50.680811 [ERR] switch_core_sqldb.c:1196 SQL ERR: [select state,status,rpid,presence_id,uuid from sip_dialogs where uuid != '35579a26-4bc4-40ab-ae5c-a2b6f460c801' and call_info_state != 'seized' and hostname='BOX02' and profile_name='internal' and ((sip_from_user='sipp' and sip_from_host='10.0.0.14') or presence_id='<a href="mailto:sipp@10.0.0.14">sipp@10.0.0.14</a>') order by rcd desc] unable to open database file</div><div>2014-10-13 20:00:50.680811 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [unable to open database file]</div><div>update sip_subscriptions set version=version+1 where hostname='BOX02' and profile_name='internal' and sip_subscriptions.event != 'line-seize' and sip_subscriptions.proto='sip' and (event='presence' or event='dialog') and sub_to_user='sipp' and (sub_to_host='10.0.0.14' or sub_to_host='10.0.0.15' or sub_to_host='N/A' or presence_hosts like '%10.0.0.14%') and (sip_subscriptions.profile_name = 'internal' or presence_hosts like '%10.0.0.14%')</div><div>2014-10-13 20:00:50.680811 [ERR] switch_core_sqldb.c:1196 SQL ERR: [select distinct sip_subscriptions.proto,sip_subscriptions.sip_user,sip_subscriptions.sip_host,sip_subscriptions.sub_to_user,sip_subscriptions.sub_to_host,sip_subscriptions.event,sip_subscriptions.contact,sip_subscriptions.call_id,sip_subscriptions.full_from,sip_subscriptions.full_via,sip_subscriptions.expires,sip_subscriptions.user_agent,sip_subscriptions.accept,sip_subscriptions.profile_name,'CS_ROUTING','unknown','10.0.0.14',sip_presence.status,sip_presence.rpid,sip_presence.open_closed,'','',sip_subscriptions.version, '',sip_subscriptions.orig_proto,sip_subscriptions.full_to,sip_subscriptions.network_ip, sip_subscriptions.network_port from sip_subscriptions left join sip_presence on (sip_subscriptions.sub_to_user=sip_presence.sip_user and sip_subscriptions.sub_to_host=sip_presence.sip_host and sip_subscriptions.profile_name=sip_presence.profile_name and sip_subscriptions.hostname=sip_presence.hostname) where sip_subscriptions.hostname='BOX02' and sip_subscriptions.profile_name='internal' and sip_subscriptions.event != 'line-seize' and sip_subscriptions.proto='sip' and (event='presence' or event='dialog') and sub_to_user='sipp' and (sub_to_host='10.0.0.14' or sub_to_host='10.0.0.15' or sub_to_host='N/A' or presence_hosts like '%10.0.0.14%') ] unable to open database file</div></div><div><br></div><div>Please help.</div><div><br></div><div>Thanks,</div><div>Vishal</div></div>
</div><div><div>_________________________________________________________________________</div><div>Professional FreeSWITCH Consulting Services: </div><div><a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a></div><div><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a></div><div><br></div><div>Official FreeSWITCH Sites</div><div><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></div><div><a href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a></div><div><a href="http://www.cluecon.com">http://www.cluecon.com</a></div><div><br></div><div>FreeSWITCH-powered IP PBX: The CudaTel Communication Server</div><div><a href="http://www.cudatel.com">http://www.cudatel.com</a></div><div><br></div><div>FreeSWITCH-users mailing list</div><div><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a></div><div><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a></div><div>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a></div><div><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></div></div></div></span>
</blockquote>
<div>
<br>
</div>