Incentive Scripts Community
Critical error mysqli_connect - Printable Version

+- Incentive Scripts Community (http://www.incentivescripts.com/forum)
+-- Forum: General (/forumdisplay.php?fid=1)
+--- Forum: Support (/forumdisplay.php?fid=3)
+--- Thread: Critical error mysqli_connect (/showthread.php?tid=2029)



Critical error mysqli_connect - winsbyclicks - 08-29-2017 10:14 AM

Critical error mysqli_connect
I'm having trouble at the PTC
Check this out
Warning: mysqli_connect(): (HY000/1203): User winsbycl_incent already has more than 'max_user_connections' active connections in /home/winsbyclicks/ClixScript_PHP_DOCS/classes/class.db2.php on line 0
Unable to connect to Database. Halting...

Queries are not being closed:
The query is not being processed.

Every 6,0s: mysqladmin stat proc Mon Aug 28 07:35:44 2017

Uptime: 5852431 Threads: 26 Questions: 204933195 Slow queries: 251 Opens: 1741329 Flush tables: 1 Open tables: 2000 Queries per second avg: 35.016
-----------------------------------------------
------------+
| Id | User | Host | db | Command | Time | State | Info
|
-+------------------------------------------------------------------------------------------
------------+
| 2728351 | winsbycl_incent | localhost | winsbycl_incent | Query | 1 | Waiting for table level lock | UPDATE rent_refs SET clicks = clicks + '6', earned = earned + '0.003', click_date = '1503
924710' WHE |
| 2728390 | winsbycl_incent | localhost | winsbycl_incent | Query | 8421 | Waiting for table level lock | SELECT * FROM rent_refs WHERE referer='manhlinh2509'
|
| 2728399 | winsbycl_incent | localhost | winsbycl_incent | Query | 8415 | Waiting for table level lock | SELECT * FROM rent_refs WHERE referer='pauline6911'
|
| 2728402 | winsbycl_incent | localhost | winsbycl_incent | Query | 8411 | Waiting for table level lock | SELECT * FROM rent_refs WHERE referer='lanphuong2608'
|
| 2728418 | winsbycl_incent | localhost | winsbycl_incent | Query | 8380 | Waiting for table level lock | SELECT username, referer FROM rent_refs WHERE username = 'armandovega' AND bot = '0'
|
| 2728444 | winsbycl_incent | localhost | winsbycl_incent | Query | 8369 | Waiting for table level lock | SELECT username, referer FROM rent_refs WHERE username = 'barabuzer' AND bot = '0'

//------------------------------------------//

Excessive resource usage: winsbyclicks (20491 (Parent PID:20304)).
Time: Tue Aug 29 12:00:19 2017 -0500
Account: winsbyclicks
Resource: Virtual Memory Size
Exceeded: 433 > 200 (MB)
Executable: /opt/cpanel/ea-php56/root/usr/bin/php-cgi
Command Line: /opt/cpanel/ea-php56/root/usr/bin/php-cgi /home/winsbyclicks/public_html/router.php
PID: 20491 (Parent PID:20304)
Killed: No

please help


RE: Critical error mysqli_connect - admin - 08-29-2017 01:18 PM

Hello,

As mentioned on Skype, I believe this may be an error relating to the upgrade you did yourself.

This is a specific case to your server/website. I will be helping you directly as this issue is not a general issue.


Thanks,
Robert