Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
2.2.3, 2.3.3
-
Debian 9 (Stretch)
VM (KVM)
Description
I've been having strange issues where specific applications have queries fail at random. (Debug logging didn't output any useful results.)
Strange thing is that almost half of all queries failed with MaxScale 2.2.3. Then, I upgraded MaxScale to 2.3.3 (without changing the config or anything else), and now 'only' a few queries fail.
For example, I have OTRS running. It works perfectly fine when talking directly to db01.dmz (Galera node), but starts randomly failing with MaxScale. But, most of the time, it works just as well as it dose with that Galera node. This is not OTRS-specific, because it is happening with more applications.
I'm quite certain I have to do with a bug here, but I have the most basic setup:
- Galera cluster with 3 nodes on Debian;
- readwritesplit on MaxScale on Debian
The config:
[db03.dmz.cyberfusion.cloud]
|
priority=3 |
protocol=MariaDBBackend
|
type=server
|
port=3306 |
address=10.10.0.9 |
|
|
[db02.dmz.cyberfusion.cloud]
|
priority=2 |
protocol=MariaDBBackend
|
type=server
|
port=3306 |
address=10.10.0.8 |
|
|
[splitterlistener]
|
protocol=MariaDBClient
|
type=listener
|
port=3306 |
service=readwriteservice
|
address=0.0.0.0 |
|
|
[galeramonitor]
|
use_priority=true |
module=galeramon
|
servers=db01.dmz.cyberfusion.cloud, db02.dmz.cyberfusion.cloud, db03.dmz.cyberfusion.cloud
|
available_when_donor=true |
user=maxscale
|
password=x
|
type=monitor
|
|
|
[db01.dmz.cyberfusion.cloud]
|
priority=1 |
protocol=MariaDBBackend
|
type=server
|
port=3306 |
address=10.10.0.7 |
|
|
[maxscale]
|
threads=auto
|
|
|
[readwriteservice]
|
transaction_replay=true |
master_accept_reads=True
|
use_sql_variables_in=master
|
servers=db01.dmz.cyberfusion.cloud, db02.dmz.cyberfusion.cloud, db03.dmz.cyberfusion.cloud
|
user=maxscale
|
router=readwritesplit
|
password=x
|
type=service
|
|
|
[maxadminlistener]
|
protocol=maxscaled
|
type=listener
|
socket=default |
service=maxadminservice
|
|
|
[maxadminservice]
|
router=cli
|
type=service
|