[ZBX-11887] Slow new template importing Created: 2017 Mar 08  Updated: 2024 Apr 10  Resolved: 2017 Aug 29

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A), Frontend (F)
Affects Version/s: 3.0.8
Fix Version/s: 3.0.11rc1, 3.2.8rc1, 3.4.2rc1, 4.0.0alpha1, 4.0 (plan)

Type: Problem report Priority: Blocker
Reporter: Andrei Gushchin (Inactive) Assignee: Miks Kronkalns
Resolution: Fixed Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: File ZBX-11887.patch     PNG File ids table.png     PNG File transaction locks more.png     PNG File transaction locks.png    
Issue Links:
Duplicate
Team: Team B
Team: Team B
Sprint: Sprint 5, Sprint 6, Sprint 7, Sprint 8, Sprint 9, Sprint 10, Sprint 11, Sprint 12, Sprint 13, Sprint 14, Sprint 15
Story Points: 3

 Description   

Importing new templates failed even after 30 min with "lock wait timeout" MySQL error. That takes minutes on 2.0, and become worst after upgrading on 3.0.
One of a possible point is ids table and audit, noticed that during importing several times was blocked transactions with query DETETE from ids where table_name='auditlog', which must rise only when reached maximum ID.

private static function refreshIds($table, $count) {
                $tableSchema = self::getSchema($table);
                $id_name = $tableSchema['key'];

                // when we reach the maximum ID, we try to refresh them to check if any IDs have been freed
                $sql = 'DELETE FROM ids WHERE table_name='.zbx_dbstr($table).' AND field_name='.zbx_dbstr($id_name);


 Comments   
Comment by Stan Kmiec [ 2017 Mar 22 ]

Hello, we are curious if there is any update that can be provided for this?

Thanks,
Stan

Comment by Aaron Rubenking [ 2017 May 04 ]

Do we have an update for when this will be released?

Comment by Miks Kronkalns [ 2017 May 10 ]

(1) Translation stings:

  • Your database is not working properly. Please wait a few minutes and try to repeat this action. If the problem still persists, please contact system administrator. The problem might be caused by long running transaction or row level lock accomplished by your database management system.

iivs Very long string, but for a regular non admin user, that would seem too complicated.

CLOSED

Comment by Ivo Kurzemnieks [ 2017 May 12 ]

(2) Wrong coding style

Miks.Kronkalns RESOLVED in r68122, r69520.

iivs CLOSED

Comment by richlv [ 2017 May 12 ]

(3) nitpicking on the message.

  • "Your database is not working properly" - perhaps better as "Zabbix database is not working properly"

and maybe worth making the message a bit more useful ? what does "not working properly" mean - is it slow to respond or deleting my data ?

  • "Please wait few minutes and try to repeat this action" might be better as "Please wait a few minutes and try to repeat this action", but it might be simpler to change it to "Please retry later."

iivs I agree. Miks.Kronkalns, consult martins-v about this if not sure.

Miks.Kronkalns RESOLVED in r69520.

iivs Seems like this message was improved, but not enough and was changed back to original. Advice was not taken.

REOPENED

Miks.Kronkalns RESOLVED in r71442.

iivs CLOSED

Comment by Ivo Kurzemnieks [ 2017 May 13 ]

(4) Where is the development branch? I don't see it mentioned here in the issue.

Miks.Kronkalns RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-11887

iivs CLOSED

Comment by Aaron Rubenking [ 2017 Jun 22 ]

Do we have a release date yet? This has been opened for 3 months and we've seen this issue since October.

Comment by Miks Kronkalns [ 2017 Aug 29 ]

Fixed:

  • 3.0.11rc1 r71814
  • 3.2.8rc1 r71816
  • 3.4.2rc1 r71818
  • 4.0.0alpha1 (trunk) r71819
Generated at Fri Apr 19 16:54:32 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.