[MXS-3397] Connection loss problem on maxscale Created: 2021-02-04 Updated: 2021-08-30 Resolved: 2021-08-30 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | N/A |
| Affects Version/s: | 2.5.8 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | haooy chen | Assignee: | Unassigned |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | None | ||
| Environment: |
I have a maxscale instance maxscale01 and three MySQL instances, mysql01 (Master) mysql02 (slave01) mysql03 (slave02) |
||
| Description |
|
I have a maxscale instance maxscale01 which version is v2.2.22 and three MySQL instances, mysql01 (Master) mysql02 (slave01) mysql03 (slave02) My profile is as follows:
|
| Comments |
| Comment by markus makela [ 2021-02-04 ] |
|
MaxScale 2.2 is EOL, can you test this with the latest 2.5 release? |
| Comment by haooy chen [ 2021-02-04 ] |
|
Thank you. I'll check it later |
| Comment by haooy chen [ 2021-02-22 ] |
|
hello,markus ,I reproduced it. The maxscale version is MaxScale 2.5.8 |
| Comment by markus makela [ 2021-02-22 ] |
|
In MaxScale 2.5 there's a connection_keepalive feature designed for situations like this. The default value is 300 seconds so any connection that does a query within that time should keep all connections alive. What is the value of your wait_timeout? |
| Comment by haooy chen [ 2021-02-22 ] |
|
interactive_timeout: 172800 |
| Comment by haooy chen [ 2021-02-22 ] |
|
I connect to the database through maxscale,I execute a query,The connection of master is refreshed,but slave is not refreshed。I'm curious about this。 |
| Comment by markus makela [ 2021-08-02 ] |
|
Can you test this again with the latest 2.5 release? We've done some fixes to the connection_keepalive feature and it might fix this problem. |
| Comment by markus makela [ 2021-08-24 ] |
|
chenhao any updates? |
| Comment by markus makela [ 2021-08-30 ] |
|
I'll close this as Cannot Reproduce. If you still see this problem with the latest 2.5 release, let us know and we'll reopen this. |