task

CREATE-article# #

[previously]

  1. [2017-03-15][00:00] NEW task IN prj-migration-5545
    1. x] # 7141 - CREATE-article# # - support chat transcript
  2. [00:00] NEW article IN 
    1. ] # # - 
  3. [00:00] NEW task
    1. ] += REFERENCE # 7140 - FIX-PRB-7140 - max-user-connections-exceeded

[currently]

  1. ]  

[next]

  1. ]
] SUPPORT - or lack there-of 
Bob: Hi
Bob: Hello, how may i help you?
?hi bob, new customer, just migrated a site over from another host
Bob: ok
?problem i am having is exceeded the 'max_user_connections' resource
Bob: Is it for MySQL Connection error?
?with mysql which is currently set at default of 10
?10 user connections, 1000 max connection
Bob: Normally, 10 is more than enough. But if your application doesn't close 
the connection after you use it, then it'll accumulate dead connections and 
eventually, you'll run out. If you want, you can use the Database manager -> 
Mysql Manager -> Flash DB function to flush all the dead connections to fix 
this problem.
?- other host has user connections set to 0
?no issues
Bob: Is there anything else I can help you with?
?can we try setting user connections to 0
?I tried Flush Db .... same issue
Bob: No, instead you can just check in your code and make sure you've closed 
all the connections properly after their use
?my problem, NOT your problem, is that what your saying?
Bob: Yes,
?works on the other host, no issues
Bob: I see..
Bob: Please submit a new ticket by clicking "Helpdesk" link which is on the 
top right corner of your hosting control panel/member account center.
Bob: We will check with the server logs and can trace where the connections 
are open
?OK, will do that then,
Details Photos Edit more

Details

ID: 7141

NAME: FIX-PRB-nnn

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

START DATE TIME: 2017-03-16 07:11:17

EST DURATION: 01:00:00

END DATE TIME: 2017-03-16 08:11:17

STATUS: Completed

PRIORITY: -5

OWNER ID: 1

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities