arnoldasgudas / Hangfire.MySqlStorage

MySql storage for Hangfire - fire-and-forget, delayed and recurring tasks runner
GNU Lesser General Public License v3.0
175 stars 114 forks source link

Hangfire.MySqlStorage with Galera Cluster #72

Open DrDenni opened 4 years ago

DrDenni commented 4 years ago

Hey there,

we are using gelera Cluster with bitnami helm chart (https://bitnami.com/stack/mariadb-galera/helm). After hangfire creates tables in galera cluster. The Service can't execute any write database operations.

Version of Package: 2.0.3

image

# Time: 200730 19:10:14
# User@Host: root[root] @  [172.17.0.1]
# Thread_id: 299  Schema: djp_core  QC_hit: No
# Query_time: 51.174712  Lock_time: 51.174599  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 0
SET timestamp=1596136214;
DELETE FROM `HangfireDistributedLock`  WHERE Resource = 'JobQueue';
2020-07-30 19:10:14 299 [Warning] Aborted connection 299 to db: 'djp_core' user: 'root' host: '172.17.0.1' (Lock wait timeout exceeded; try restarting transaction)
# Time: 200730 19:10:33
# User@Host: root[root] @  [172.17.0.1]
# Thread_id: 305  Schema: djp_core  QC_hit: No
# Query_time: 51.203375  Lock_time: 51.203295  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 0
SET timestamp=1596136233;
DELETE FROM `HangfireDistributedLock`  WHERE Resource = 'JobQueue';
2020-07-30 19:10:33 305 [Warning] Aborted connection 305 to db: 'djp_core' user: 'root' host: '172.17.0.1' (Lock wait timeout exceeded; try restarting transaction)
# Time: 200730 19:10:54
# User@Host: root[root] @  [172.17.0.1]
# Thread_id: 311  Schema: djp_core  QC_hit: No
# Query_time: 51.229503  Lock_time: 51.229394  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 0
SET timestamp=1596136254;
DELETE FROM `HangfireDistributedLock`  WHERE Resource = 'JobQueue';
2020-07-30 19:10:54 311 [Warning] Aborted connection 311 to db: 'djp_core' user: 'root' host: '172.17.0.1' (Lock wait timeout exceeded; try restarting transaction)

image

Kind Regards