Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Proxysql Connect MYSQL Socket #4210

Closed
zGansalloz opened this issue May 8, 2023 · 5 comments
Closed

Proxysql Connect MYSQL Socket #4210

zGansalloz opened this issue May 8, 2023 · 5 comments

Comments

@zGansalloz
Copy link

| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_$
+--------------+----------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----$
| 1 | /var/run/mysqld/mysql.sock | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000$

MySQL_Monitor.cpp:4344:monitor_dns_resolver_thread(): [ERROR] An error occurred while resolving hostname: /var/run/mysqld/mysql.sock [-2]

@zGansalloz
Copy link
Author

MySQL_Session.cpp:1667:handler_again___status_PINGING_SERVER(): [ERROR] Detected a broken connection while during ping on (1,/var/run/mysqld/mysql.sock,0,23)

I do not quite understand why these actions take place on the socket.

@renecannao
Copy link
Contributor

MySQL_Monitor.cpp:4344:monitor_dns_resolver_thread(): [ERROR] An error occurred while resolving hostname: /var/run/mysqld/mysql.sock [-2]

This is clearly a bug, and likely easy to fix. We will follow up.

... handler_again___status_PINGING_SERVER() ...
I do not quite understand why these actions take place on the socket.

To keep alive free connections.

@zGansalloz
Copy link
Author

ProxySQL version 2.5.1-90-gbedaa6c, codename Truls

which stable version do you recommend?

@renecannao
Copy link
Contributor

2.5.1 is the latest stable.
2.5.2 is expected to be released soon.

@renecannao
Copy link
Contributor

renecannao commented May 11, 2023

Closing, fixed in PR #4213

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants