Duplicate INSERTS in galera cluster

[kevinnivek]

Hello,

I am using the following on CentOS 7 :

galera-3-25.3.26-2.el7.x86_64
mysql-wsrep-libs-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-common-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-libs-compat-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-devel-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-client-5.7-5.7.21-25.14.el7.x86_64

This is a high availability environment with a load balancer in front of 2 servers and an arbitrator.

I am noticing under certain conditions (yet to be discovered), duplicate INSERTS are happening into the table when a user submits a POST request (to ultimately insert into the database).

I have ruled out the application level that is submitting the INSERT and am curious if anyone can help me to diagnose the issue further.

When the duplicate happened, in this most recent scenario, the date/timestamps are identical :

row id : 152309 - 2019-09-12 16:44:26
row id : 152315 - 2019-09-12 16:44:26

Any ideas?