Msql flush-hosts

Glenn Miler2 years ago

Hi all.

I am still a newbie in this, my traccar server is simply not running anymore, and again it was my host there had the problem, and moved my data to a new server, so in that sentece i think i have answered the question.

But never the less, i have this odd message in my traccar log, and trying to figure out if it is Traccar or my host provider there have an issue with too many connections, meaning is it traccar there recives too much or is it the mysql server, there is not handling the requests from Traccar.

2022-10-31 14:56:53 ERROR: Main method error - StacklessClosedChannelException (...)
2022-10-31 15:06:56  INFO: Operating system name: Linux version: 4.9.0-11-amd64 architecture: amd64
2022-10-31 15:06:56  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: ojdkbuild version: 11.0.13+8-LTS
2022-10-31 15:06:56  INFO: Memory limit heap: 966mb non-heap: 0mb
2022-10-31 15:06:56  INFO: Character encoding: UTF-8 charset: UTF-8
2022-10-31 15:06:56  INFO: Version: 5.2
2022-10-31 15:06:56  INFO: Starting server...
2022-10-31 15:06:57  INFO: Your platform does not provide complete low-level API for accessing direct buffers reliably. Unless explicitly requested, heap buffer will always be preferred to avoid potential system instability.
2022-10-31 15:06:58  INFO: HikariPool-1 - Starting...
2022-10-31 15:07:03 ERROR: HikariPool-1 - Exception during pool initialization. - null,  message from server: "Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" - CJException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < BasePipelineFactory:117 < ...)
2022-10-31 15:07:03  WARN: Failed to initialize a channel. Closing: [id: 0xcf4ef713] - null,  message from server: "Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" - CJException (... < DatabaseModule:79 < <gener:-1 < *:-1 < ... < BasePipelineFactory:117 < ...)
2022-10-31 15:07:03 ERROR: Main method error - StacklessClosedChannelException (...)
Anton Tananaev2 years ago

Looks like your MySQL server is blocking connection.

Glenn Miler2 years ago

Okay thanks, i thought the same. is there a way to control how many requests ? but i guess not, as i guess the requests comes as needed. ?

Anton Tananaev2 years ago

I think you need to configure your MySQL to not block connections.

Glenn Miler2 years ago

Got it, i will do that, thanks for the help again again again Anton :D