edit-task

Task Description: FIX-PRB-7140 - user ### has exceeded max user connections (10), chat support

Start Date:

Start Time:

Duration:

Priority:

Status: To Do Completed In Process

Add Photo:

Owner ID:

Content: use HTML Edit Content <h1 style="text-align: center;">CREATE-article# #</h1> <h2>[previously]</h2> <ol> <li><strong>[2017-03-15][00:00] NEW task IN prj-migration-5545</strong></li> <ol> <li>x] # 7141 - <a href="/view/task?id=7141" target="_blank">CREATE-article# #</a> - support chat transcript</li> </ol> <li><strong>[00:00] NEW article IN&nbsp;</strong></li> <ol> <li>] # # -&nbsp;</li> </ol> <li><strong>[00:00] NEW task</strong></li> <ol> <li>] += REFERENCE # 7140 - <a href="/view/task?id=7140" target="_blank">FIX-PRB-7140</a> - max-user-connections-exceeded</li> </ol></ol> <h2>[currently]</h2> <ol> <li>] &nbsp;</li> </ol> <h2>[next]</h2> <ol> <li>]</li> </ol> <div> <div><strong>] SUPPORT - or lack there-of&nbsp;</strong></div> <div>Bob: Hi</div> <div>Bob: Hello, how may i help you?</div> <div>?hi bob, new customer, just migrated a site over from another host</div> <div>Bob: ok</div> <div>?problem i am having is exceeded the 'max_user_connections' resource</div> <div>Bob: Is it for MySQL Connection error?</div> <div>?with mysql which is currently set at default of 10</div> <div>?10 user connections, 1000 max connection</div> <div>Bob: Normally, 10 is more than enough. But if your application doesn't close&nbsp;</div> <div>the connection after you use it, then it'll accumulate dead connections and&nbsp;</div> <div>eventually, you'll run out. If you want, you can use the Database manager -&gt;&nbsp;</div> <div>Mysql Manager -&gt; Flash DB function to flush all the dead connections to fix&nbsp;</div> <div>this problem.</div> <div>?- other host has user connections set to 0</div> <div>?no issues</div> <div>Bob: Is there anything else I can help you with?</div> <div>?can we try setting user connections to 0</div> <div>?I tried Flush Db .... same issue</div> <div>Bob: No, instead you can just check in your code and make sure you've closed&nbsp;</div> <div>all the connections properly after their use</div> <div>?my problem, NOT your problem, is that what your saying?</div> <div>Bob: Yes,</div> <div>?works on the other host, no issues</div> <div>Bob: I see..</div> <div>Bob: Please submit a new ticket by clicking "Helpdesk" link which is on the&nbsp;</div> <div>top right corner of your hosting control panel/member account center.</div> <div>Bob: We will check with the server logs and can trace where the connections&nbsp;</div> <div>are open</div> <div>?OK, will do that then,</div> </div>