[Solved] Database (max_user_connections) Error

[wape]

I'am trying to connect to my database with the host name johnny.heliohost.org and its giving me a max user connection error

 

Heres the error:

 

  original:
   { Error: User wape_jack already has more than 'max_user_connections' active connections
    at Packet.asError (/home/jack/node_modules/mysql2/lib/packets/packet.js:712:17)
    at ClientHandshake.execute (/home/jack/node_modules/mysql2/lib/commands/command.js:28:26)
    at Connection.handlePacket (/home/jack/node_modules/mysql2/lib/connection.js:408:32)
    at PacketParser.Connection.packetParser.p [as onPacket] (/home/jack/node_modules/mysql2/lib/connection.js:70:12)
    at PacketParser.executeStart (/home/jack/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.Connection.stream.on.data (/home/jack/node_modules/mysql2/lib/connection.js:77:25)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    at addChunk (_stream_readable.js:263:12)
    at readableAddChunk (_stream_readable.js:250:11)
    at Socket.Readable.push (_stream_readable.js:208:10)
    at TCP.onread (net.js:607:20)
     code: 'ER_TOO_MANY_USER_CONNECTIONS',
     errno: 1203,
     sqlState: '42000',
     sqlMessage: 'User wape_jack already has more than \'max_user_connections\' active connections' } }

Edited December 1, 2019 by wape

[Flaze]

This support request is being escalated to our root admin.

[wolstech]

This is usually caused by badly-written code that doesn’t close its connections when it’s done with them.

 

I assume you wrote the program yourself? If so, be sure your code is closing the database connections when you’re finished with them. Many times I find code that opens a new connection for every query, never closes them, and fails when it hits the connection limit. You should either open, query, close every time, or open at the start of the script, reuse the single connection for every query, and close it at the end.

[wape]

it was working before but then my vps ip changed and i changed it on remote SQL and it didnt work after though

[wolstech]

That’s weird...

 

Let’s see what Krydos says. Changing an IP should not cause that error. If it weren’t configured for remote access, it’d be an access denied error, so it’s not that...

[wape]

yeah i also backed up my database and then created a new one + a new user. I have a backup so if u need to reset somethin then go for it

[Krydos]

You currently have zero open mysql connections. The limit on Johnny is 4 open connections at once. If you try to open more than 4 connections at the same time you will get that error. If you need more than 4 simultaneous connections I recommend transferring your account to Tommy which currently offers unlimited mysql connections. A limit may be added in the future on Tommy as well if we find people abusing the unlimited connections.

[wape]

Can you transfer my account to Tommy or is there somethin i gotta do?

[Krydos]

Are you a donor? If so please post your transaction ID.

 

https://wiki.helionet.org/Moving_your_account

[wape]

how much do i have to donate to transfer to tommy?

[wape]

I donated $1 Heres the transaction ID 9LB898603A248922L

Edited December 2, 2019 by wape

[Krydos]

$1.00+ to transfer to Tommy

$6.00+ to transfer to Tommy and get double storage space 2000 MB

[Krydos]

What is the transaction ID?

[wape]

Heres the transaction ID 9LB898603A248922L

[Guest pooks]

$1.00+ to transfer to Tommy

$6.00+ to transfer to Tommy and get double storage space 2000 MB

Hmm? I thought the $6 was for people without accounts?