[Solved] Close The Connections For Luigi123_Sb

[Luigi123]

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.

[Krydos]

One of your connections had been open for 7 hours and 19 minutes sleeping without transferring a single byte... I closed them.

[Luigi123]

Thanks Krydos, I'll delete luigi123_sb2 and luigi123_sb3 and see if it works.

[Luigi123]

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 79

You 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.

[Krydos]

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.

[Luigi123]

I'm still receiving error.

[Krydos]

I didn't close them before. They're closed now.

[Luigi123]

Is it close already? Because I'm still receiving the same error.

[Krydos]

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.

[Luigi123]

Alright so I don't know what's going here, but when you close it, how come the error message is still showing up?

[Krydos]

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?

[Luigi123]

Alright, I turn off all of my Game Servers. So you can try to close the connections again.

 

Hopefully it will work.

[Krydos]

You currently have no open mysql connections.

[Luigi123]

Is it close now?

[Krydos]

Yes.