Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.3.11
-
None
Description
After few hours any connection attempts through maxscale finaly:
ERROR 1040 (HY000): Too many connections
Direct connect without maxscale working fine.
config example:
[maxscale]
|
threads = auto
|
log_warning=1
|
log_debug=1
|
|
|
[mysql07]
|
type = server
|
protocol = MariaDBBackend
|
address = 192.168.4.106
|
port = 3307
|
|
|
[mysql08]
|
type = server
|
protocol = MariaDBBackend
|
address = 192.168.4.107
|
port = 3307
|
|
|
[Service-for-cluster_78]
|
user = maxscale
|
password = pass
|
filters = Hint
|
max_slave_replication_lag=300
|
max_sescmd_history=1500
|
prune_sescmd_history=true
|
type = service
|
router = readwritesplit
|
servers = mysql07, mysql08
|
master_accept_reads = true
|
max_connections = 800
|
|
|
[MariaDB-Monitor-for-cluster_78]
|
type = monitor
|
module = mariadbmon
|
user = replica
|
password = pass
|
monitor_interval = 5000
|
failover_timeout = 10
|
auto_failover = false
|
detect_replication_lag = true
|
handle_events = false
|
servers = mysql07, mysql08
|
|
|
[Listener-for-cluster_78]
|
address = 0.0.0.0
|
type = listener
|
service = Service-for-cluster_78
|
protocol = MariaDBClient
|
port = 3306
|
|
|
[MaxAdmin-Service]
|
type = service
|
router = cli
|
|
|
[MaxAdmin-Listener]
|
type = listener
|
service = MaxAdmin-Service
|
protocol = maxscaled
|
socket = default
|
|
|
[Hint]
|
type = filter
|
module = hintfilter
|
MySQL server variables:
| max_connect_errors | 1000 |
|
| max_connections | 1000 |
|
| max_user_connections | 800 |
|
MySQL server status:
| Max_used_connections | 193 |
|
| Max_used_connections_time | 2019-10-03 06:40:06 |
|
maxctrl show servers "connections": 0 (Statistics section)
maxctrl show services fragment:
{
|
"connections":500,
|
"current_connections":1,
|
"queries":1500,
|
"route_master":0,
|
"route_slave":1500,
|
"route_all":500,
|
"rw_transactions":0,
|
"ro_transactions":0,
|
"replayed_transactions":0,
|
"server_query_statistics":[
|
{
|
"id":"mysql07",
|
"total":2000,
|
"read":2000,
|
"write":0,
|
"avg_sess_duration":"74.4405ms",
|
"avg_sess_active_pct":98.50054979380471,
|
"avg_selects_per_session":2
|
},
|
{
|
"id":"mysql08",
|
"total":500,
|
"read":500,
|
"write":0,
|
"avg_sess_duration":"74.422ms",
|
"avg_sess_active_pct":0,
|
"avg_selects_per_session":0
|
}
|
]
|
}
|
Attachments
Issue Links
- is caused by
-
-
- Closed
-