[MXS-4033] Upgrade to 6.2.2 confuses SQL clients Created: 2022-02-28 Updated: 2022-03-14 Resolved: 2022-03-14 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | N/A |
| Affects Version/s: | 6.2.2 |
| Fix Version/s: | 6.2.3 |
| Type: | Bug | Priority: | Major |
| Reporter: | Assen Totin (Inactive) | Assignee: | markus makela |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
MaxScale with rw-spit and one primary, one replica. Testing platform with a few pretty standard WordPress web sites (PHP 7.2 on RHEL-8). After the upgrade of MaxScale from 6.2.1 to 6.2.2 they practically stopped loading (with very few exceptions now and then, mostly around a restart of some component like PHP-FPM or MaxScale). The primary node shows the SQL client connect (so authentication works fine), but even the default database is not set (which is unusual - the typical connection will always set a default database). Then the connection remains idle until terminated on timeout. So, the client side seems to be somehow stuck, although the PHP FPM error log says nothing about this. The MaxScale log is also completely silent - no crashes or restarts of the process detected. Even an old MariaDB client like 10.3 has no problems connecting and working via MaxScale. However, apparently some SQL clients do have an issue. Reverting MaxScale back to 6.2.1 restores the web sites to working condition. Looking at [172.16.69.4-Service] The CPU on the MaxScale machine is practically idle, free memory is available, disk space too. We cannot offer a definitive reproduction scenario, but it may be worth simulating with a PHP-7.2 client (stock on RHEL-8); I think WP uses the mysqli driver from it. |
| Comments |
| Comment by markus makela [ 2022-03-01 ] |
|
Most likely caused by |
| Comment by Assen Totin (Inactive) [ 2022-03-07 ] |
|
Thank you, Markus. Two more notes:
|
| Comment by markus makela [ 2022-03-11 ] |
|
The 6.2.3 release is now out, can you try again with it and see if it still happens? |
| Comment by Assen Totin (Inactive) [ 2022-03-14 ] |
|
Yes, it looks like 6.2.3 fixes this issue. Feel free to close the ticket; I'll reopen in case anything new around it surfaces. |
| Comment by markus makela [ 2022-03-14 ] |
|
Closing as a duplicate of |