wape Posted December 1, 2019 Share Posted December 1, 2019 (edited) 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 Link to comment Share on other sites More sharing options...
flazepe Posted December 1, 2019 Share Posted December 1, 2019 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
wolstech Posted December 1, 2019 Share Posted December 1, 2019 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. Link to comment Share on other sites More sharing options...
wape Posted December 1, 2019 Author Share Posted December 1, 2019 it was working before but then my vps ip changed and i changed it on remote SQL and it didnt work after though Link to comment Share on other sites More sharing options...
wolstech Posted December 1, 2019 Share Posted December 1, 2019 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... Link to comment Share on other sites More sharing options...
wape Posted December 1, 2019 Author Share Posted December 1, 2019 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 Link to comment Share on other sites More sharing options...
Krydos Posted December 2, 2019 Share Posted December 2, 2019 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. Link to comment Share on other sites More sharing options...
wape Posted December 2, 2019 Author Share Posted December 2, 2019 Can you transfer my account to Tommy or is there somethin i gotta do? Link to comment Share on other sites More sharing options...
Krydos Posted December 2, 2019 Share Posted December 2, 2019 Are you a donor? If so please post your transaction ID. https://wiki.helionet.org/Moving_your_account Link to comment Share on other sites More sharing options...
wape Posted December 2, 2019 Author Share Posted December 2, 2019 how much do i have to donate to transfer to tommy? Link to comment Share on other sites More sharing options...
wape Posted December 2, 2019 Author Share Posted December 2, 2019 (edited) I donated $1 Heres the transaction ID 9LB898603A248922L Edited December 2, 2019 by wape Link to comment Share on other sites More sharing options...
Krydos Posted December 2, 2019 Share Posted December 2, 2019 $1.00+ to transfer to Tommy $6.00+ to transfer to Tommy and get double storage space 2000 MB Link to comment Share on other sites More sharing options...
Krydos Posted December 2, 2019 Share Posted December 2, 2019 What is the transaction ID? Link to comment Share on other sites More sharing options...
wape Posted December 2, 2019 Author Share Posted December 2, 2019 Heres the transaction ID 9LB898603A248922L Link to comment Share on other sites More sharing options...
Guest pooks Posted December 2, 2019 Share Posted December 2, 2019 $1.00+ to transfer to Tommy$6.00+ to transfer to Tommy and get double storage space 2000 MBHmm? I thought the $6 was for people without accounts? Link to comment Share on other sites More sharing options...
Recommended Posts