[ZBX-15872] PostgreSQL deadlock while updating hosts table Created: 2019 Mar 26  Updated: 2024 Apr 10  Resolved: 2019 Apr 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 4.0.6rc2, 4.2.0rc2
Fix Version/s: 4.0.7rc1, 4.2.1rc1, 4.4.0alpha1, 4.4 (plan)

Type: Problem report Priority: Trivial
Reporter: Edgar Akhmetshin Assignee: Vladislavs Sokurenko
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screenshot at 2019-03-26 11-38-18.png     PNG File Screenshot at 2019-03-26 11-38-23.png     PNG File Screenshot at 2019-03-26 11-46-48.png     PNG File Screenshot at 2019-03-26 11-47-44-2.png     PNG File Screenshot at 2019-03-26 11-47-44-3.png     File zabbix_server 3.log.7z    
Issue Links:
Causes
Team: Team A
Sprint: Sprint 50 (Mar 2019), Sprint 51 (Apr 2019)
Story Points: 0.5

 Description   

Steps to reproduce:

  1. Upgrade to Zabbix 4.0.5 and PostgreSQL 9.6 and pg_activity/pg_top
  2. Setup active agent auto-registration

Result:

 51083:20190325:095811.429 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  deadlock detected
DETAIL:  Process 61170 waits for ShareLock on transaction 1050243760; blocked by process 82093.
Process 82093 waits for ShareLock on transaction 1050243129; blocked by process 61170.
HINT:  See server log for query details.
CONTEXT:  while updating tuple (44,1) in relation "hosts"
 [update hosts set status=1 where hostid=12751]

See screenshots...




Expected:
No deadlocks...

 Comments   
Comment by Vladislavs Sokurenko [ 2019 Mar 28 ]

Fixed in development branch:
svn://svn.zabbix.com/branches/dev/ZBX-15872

Comment by Vladislavs Sokurenko [ 2019 Apr 03 ]

Fixed in:

  • pre-4.0.7rc1 r91918
  • pre-4.2.1rc1 r91919
  • pre-4.4.0alpha1 r91920
Generated at Thu May 15 08:31:45 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.