[ZBX-23446] nested transaction detected Created: 2023 Sep 21  Updated: 2024 Apr 10  Resolved: 2023 Sep 24

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 7.0.0alpha5
Fix Version/s: 7.0.0alpha5, 7.0 (plan)

Type: Problem report Priority: Blocker
Reporter: Théo BARRAGUE Assignee: dimir
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Debian GNU/Linux 11 (bullseye)

Linux infra-zabbix-prod-1 5.10.0-25-amd64 #1 SMP Debian 5.10.191-1 (2023-08-16) x86_64 GNU/Linux

Docker version 24.0.6, build ed223bc

Attachments: Text File zabbix_server_truncated.log    
Team: Team A
Sprint: Sprint 104 (Sep 2023)
Story Points: 0.2

 Description   

Steps to reproduce:

  1. Setup zabbix/zabbix-server-mysql:alpine-trunk as Zabbix Server with it's own MySQL database
  2. Setup zabbix/zabbix-proxy-mysql:alpine-trunk as Zabbix Proxy with it's own MySQL database
  3. Start both and wait few seconds

Result:

"ERROR: nested transaction detected. Please report it to Zabbix Team." when saving data in database.

Expected:
No nested transaction, SAVEPOINT instead on MySQL backend ?

 Comments   
Comment by dimir [ 2023 Sep 22 ]

Fixed in development branch

Comment by Vladislavs Sokurenko [ 2023 Sep 22 ]

Thank you for your report, double transaction will be deleted

Comment by dimir [ 2023 Sep 22 ]

Fixed in

Comment by Théo BARRAGUE [ 2023 Sep 25 ]

It works well, thanks for the fix!

Generated at Sun Apr 20 20:56:31 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.