[ZBX-15370] syncing history is too slow Created: 2018 Dec 27 Updated: 2020 Sep 03 Resolved: 2019 Jan 03 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 4.0.2 |
| Fix Version/s: | None |
| Type: | Problem report | Priority: | Trivial |
| Reporter: | Fabrice T | Assignee: | Arturs Lontons |
| Resolution: | Won't fix | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Production |
||
| Attachments: |
Capture_busy.PNG
history.PNG
one.PNG
one.PNG
three.PNG
two.PNG
two.PNG
|
| Description |
|
Hello After a restart of Zabbix server (due to a modification of configuration file) , the syncing history data take a long time to finish After 2h its only to 6%
35032:20181227:101742.008 syncing history data... 6.255328%
The problem is this zabbix is already used in production. We can not wait 20h...
I want to know if its possible to skip this process (syncing history data) - to make zabbix available as son possible .
Loose a data is not a problem , real time monitoring is the priority |
| Comments |
| Comment by Fabrice T [ 2018 Dec 27 ] |
|
After 40 , just 1% progess
35032:20181227:103507.017 syncing history data... 7.364018% |
| Comment by Fabrice T [ 2018 Dec 27 ] |
|
I have finally kill the process (kill -9 PID)
its not clean to dot it , but after 3 hours i have not the choice, i dont know why this sync of data take a long time
|
| Comment by Arturs Lontons [ 2018 Dec 27 ] |
|
Hi! |
| Comment by Fabrice T [ 2018 Dec 27 ] |
|
Hi
thank you for your feedback . this is my conf file :
StartPollers=5
|
| Comment by Fabrice T [ 2018 Dec 27 ] |
|
|
| Comment by Fabrice T [ 2018 Dec 27 ] |
|
|
| Comment by Arturs Lontons [ 2019 Jan 03 ] |
|
This issue seems to be caused by bad database performance - you can see in the graphs that the history write cache was full until the restart (and may possibly become full again in the future) and that the housekeeper process is also periodically 100% busy. Since this is not a Zabbix bug, but a configuration issue, you should direct this issue either at the Zabbix forums - https://www.zabbix.com/forum/ |
| Comment by Timo Veith [ 2020 Sep 03 ] |
|
Hi, it looks like we are having the same problem. Have you found a solution yet and if yes what was it? Thank you and have a nice day timo |
