Luigi123 Posted July 3, 2017 Share Posted July 3, 2017 Hello,Can you close the connection of luigi123_sb on my Sourcebans? Because the error message of max_user_connections keeps popping up on my Sourcebans all the time and it's annoying. If you have any questions, feel free to let me know. Thanks. Link to comment Share on other sites More sharing options...
Krydos Posted July 3, 2017 Share Posted July 3, 2017 One of your connections had been open for 7 hours and 19 minutes sleeping without transferring a single byte... I closed them. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 3, 2017 Author Share Posted July 3, 2017 Thanks Krydos, I'll delete luigi123_sb2 and luigi123_sb3 and see if it works. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 16, 2017 Author Share Posted July 16, 2017 Hi Krydos,I'm still seeing the max_user_connection error message after I delete luigi123_sb2 and luigi123_sb3: Error: the XML response that was returned from the server is invalid. Received: Warning: mysqli_real_connect(): (HY000/1203): User luigi123_sb already has more than 'max_user_connections' active connections in /home/luigi123/public_html/bans/includes/adodb/drivers/adodb-mysqli.inc.php on line 124 Fatal error: mysqli error: [1203: User luigi123_sb already has more than 'max_user_connections' active connections] in CONNECT(localhost, '****', '****', luigi123_sourcebanssb_bans) in /home/luigi123/public_html/bans/includes/adodb/adodb-errorhandler.inc.php on line 79You have whitespace in your response. Marking this Thread Unsloved. Plus, I can't join my Game Server because of the max_user_connection. Even I add another database username too. Link to comment Share on other sites More sharing options...
Krydos Posted July 16, 2017 Share Posted July 16, 2017 1272973 luigi123_sb 158.69.123.33:42844 luigi123_sourcebanssb_bans Sleep 775 NULL 1291622 luigi123_sb 158.69.123.33:45416 luigi123_sourcebanssb_bans Sleep 959 NULL 1332235 luigi123_sb 158.69.123.33:51663 luigi123_sourcebanssb_bans Sleep 959 NULL 1333861 luigi123_sb 158.69.123.33:52021 luigi123_sourcebanssb_bans Sleep 959 NULL Sleeping for 13, 16, 16, and 16 minutes. Close the connections and the error goes away. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 16, 2017 Author Share Posted July 16, 2017 I'm still receiving error. Link to comment Share on other sites More sharing options...
Krydos Posted July 16, 2017 Share Posted July 16, 2017 I didn't close them before. They're closed now. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 16, 2017 Author Share Posted July 16, 2017 Is it close already? Because I'm still receiving the same error. Link to comment Share on other sites More sharing options...
Krydos Posted July 16, 2017 Share Posted July 16, 2017 1517671 luigi123_sb 158.69.123.33:49008 luigi123_sourcebanssb_bans Sleep 14400 NULL 1517688 luigi123_sb 158.69.123.33:49012 luigi123_sourcebanssb_bans Sleep 15606 NULL 1517699 luigi123_sb 158.69.123.33:49013 luigi123_sourcebanssb_bans Sleep 15606 NULL 1517923 luigi123_sb 158.69.123.33:49038 luigi123_sourcebanssb_bans Sleep 15606 NULL That's about 4.5 hours. Closed. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 20, 2017 Author Share Posted July 20, 2017 Alright so I don't know what's going here, but when you close it, how come the error message is still showing up? Link to comment Share on other sites More sharing options...
Krydos Posted July 22, 2017 Share Posted July 22, 2017 Something from 158.69.123.33 reopens all of your connections immediately and causes the error again. Is there any way to limit the number of connections it opens or force it to close connections on its own? Link to comment Share on other sites More sharing options...
Luigi123 Posted July 22, 2017 Author Share Posted July 22, 2017 Alright, I turn off all of my Game Servers. So you can try to close the connections again. Hopefully it will work. Link to comment Share on other sites More sharing options...
Krydos Posted July 22, 2017 Share Posted July 22, 2017 You currently have no open mysql connections. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 23, 2017 Author Share Posted July 23, 2017 Is it close now? Link to comment Share on other sites More sharing options...
Krydos Posted July 23, 2017 Share Posted July 23, 2017 Yes. Link to comment Share on other sites More sharing options...
Recommended Posts