[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: | ZBX-11887.patch ids table.png transaction locks more.png transaction locks.png | ||||
Issue Links: |
|
||||
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. 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, |
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:
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.
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 ?
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:
|