Jump to content


Photo

Database (max_user_connections) Error


  • Please log in to reply
22 replies to this topic

#1 wape

wape

    Newbie

  • Members
  • 9 posts

Posted 01 December 2019 - 06:21 AM

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 by wape, 01 December 2019 - 06:23 AM.


#2 flazepe

flazepe

    Rank X Member

  • Moderators
  • 1,055 posts
  • Gender:Male

Posted 01 December 2019 - 09:20 AM

This support request is being escalated to our root admin.

#3 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 11,172 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 01 December 2019 - 04:44 PM

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.

Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#4 wape

wape

    Newbie

  • Members
  • 9 posts

Posted 01 December 2019 - 04:49 PM

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



#5 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 11,172 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 01 December 2019 - 04:57 PM

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

Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#6 wape

wape

    Newbie

  • Members
  • 9 posts

Posted 01 December 2019 - 04:59 PM

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



#7 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 19,162 posts
  • Gender:Male

Posted 02 December 2019 - 02:28 AM

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.

#8 wape

wape

    Newbie

  • Members
  • 9 posts

Posted 02 December 2019 - 02:41 AM

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



#9 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 19,162 posts
  • Gender:Male

Posted 02 December 2019 - 02:45 AM

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

https://wiki.helione...ng_your_account

#10 wape

wape

    Newbie

  • Members
  • 9 posts

Posted 02 December 2019 - 02:48 AM

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



#11 wape

wape

    Newbie

  • Members
  • 9 posts

Posted 02 December 2019 - 02:51 AM

I donated $1 Heres the transaction ID 9LB898603A248922L


Edited by wape, 02 December 2019 - 02:52 AM.


#12 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 19,162 posts
  • Gender:Male

Posted 02 December 2019 - 02:51 AM

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

#13 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 19,162 posts
  • Gender:Male

Posted 02 December 2019 - 02:52 AM

What is the transaction ID?

#14 wape

wape

    Newbie

  • Members
  • 9 posts

Posted 02 December 2019 - 02:52 AM

Heres the transaction ID 9LB898603A248922L



#15 pooks

pooks

    Rank IV Member

  • Members
  • PipPipPipPip
  • 225 posts
  • Gender:Male
  • Location:Here
  • Interests:Elsword, Website, RPG Maker MV

Posted 02 December 2019 - 02:59 AM

$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?

Posted Image





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users