sidorares / sidorares/node-mysql2
too many connections using pool
Open
Nobody has claimed this yet.
needs investigation
- Dominant language
- TypeScript
- Stars
- 4.4k
- Forks
- 680
- Avg merge
- 9h 7m
- Merged PRs (30d)
- 59
Description
Hi there,
I'm using pool connections of 100 connections.
Once in awhile I'm getting the following error:
doSql pool.getConnection failed with error:Error: Host 'xxxxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Any idea on how to fix this?
Best,
Guy
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing the pool.getConnection path and the reported MySQL host-blocking error. Reproduce or characterize the connection failures, then define the expected pool behavior and a testable fix; the issue currently names no files or tests and provides no clear completion criteria.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, node.js
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100