[MXS-2318] Can't disconnect maxscale session on Read Write Split router Created: 2019-02-06  Updated: 2019-02-06  Resolved: 2019-02-06

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: 2.2.19, 2.3.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Maiavria Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Debian 8, Debian 9


 Description   

Hi everyone

I can't disconnect a PHP (5.6 and 7) PDO driver initiated session with Maxscale on a Read Write Split router.

Maybe this is related to the fact that multiple connections are open, one on the write/master node, and several to the read only nodes.

We also have tried with persistent connections on and off.

Is there a way or a special command to execute to tell Maxscale to close the opened session and all open mysql connections behind ?

 Comments   
Comment by markus makela [ 2019-02-06 ]

The MariaDB/MySQL protocol should handle disconnection on its own and nothing special should be required. Does it work if you skip MaxScale and use a direct connection to the database? If it does, there's something different in how the client application behaves when MaxScale is used.

Comment by Maiavria [ 2019-02-06 ]

I found that a PDO Statement transaction was still referenced, the problem was solved by nulling it.

Thanks for your help

Comment by markus makela [ 2019-02-06 ]

Great! I'll go ahead and close this as Not a Bug. If it turns out it is a MaxScale problem, feel free to open this issue.

Generated at Thu Feb 08 04:13:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.