Already/No active transaction error shown from application

himanshutecstub commented 1 year ago

Proxysql : 2.5.1-90 OS : Ubuntu 22

We configure 3 galera node with proxysql server configuration 1 - Writer 2 - Reader

We use PHP application where use begin & commit transaction when try to commit than shown "Already/No active transaction" error. It's working fine with single server without galera & proxysql configuration

proxysql mysql_users set transaction_persistent = 1

Mysql version : 8.0.32 Database & tabels type : InnoDB In all mysql not set variables. mysql> show variables like '%commit%'; +-----------------------------------------+-------------------+ | Variable_name | Value | +-----------------------------------------+-------------------+ | autocommit | ON | | binlog_group_commit_sync_delay | 0 | | binlog_group_commit_sync_no_delay_count | 0 | | binlog_order_commits | ON | | innodb_api_bk_commit_interval | 5 | | innodb_commit_concurrency | 0 | | innodb_flush_log_at_trx_commit | 0 | | original_commit_timestamp | 36028797018963968 | | replica_preserve_commit_order | ON | | replication_sender_observe_commit_only | OFF | | slave_preserve_commit_order | ON | | wsrep_retry_autocommit | 1 | +-----------------------------------------+-------------------+

Please suggest how to resolve this issue

Thank You!

renecannao commented 1 year ago

Hi @himanshutecstub .

I am afraid that we cannot help without a reproducible test case

himanshutecstub commented 1 year ago

Hello,

We haven't exact idea about generate error. It's working normal in all DB operation but when website traffic/db operation increase than shown there error which is related to commit & rollback transaction.

Below server configuration is right for that? Also check we use old proxysql version in new version https://github.com/sysown/proxysql/pull/4306 issue resolved.

So my issue resolved after upgrade proxysql?

sysown / proxysql

Already/No active transaction error shown from application #4331