Hello I'm updating zabbix from 2.0.9 to 2.2.2 v , after binaries and php update, I'm starting DB (110GB) and it's starting update indexes , it's doing it few days , zabbix not working.
How can I fix it ?
on startup .
27499:20140306:201052.585 current database version (mandatory/optional): 02020000/02020000
27499:20140306:201052.585 required mandatory version: 02020000
27504:20140306:201053.006 server #1 started [configuration syncer #1]
| 121 | zabbix | 00Zabbix.local:28038 | zabbix | Query | 1420 | Creating sort index | select clock,ns,value from history_uint where itemid=41464 and clock<=1393477128 and clock>139088512 |
| 122 | zabbix | 00Zabbix.local:28039 | zabbix | Query | 589 | Creating sort index | select clock,ns,value from history where itemid=38800 and clock<=1393477960 and clock>1390885960 ord |
| 123 | zabbix | 00Zabbix.local:28040 | zabbix | Query | 292 | Creating sort index | select clock,ns,value from history_uint where itemid=44533 and clock<=1393478256 and clock>139088625 |
| 124 | zabbix | 00Zabbix.local:28041 | zabbix | Query | 276 | Creating sort index | select clock,ns,value from history_uint where itemid=34877 and clock<=1393478272 and clock>139088627 |
How can I fix it ?
on startup .
27499:20140306:201052.585 current database version (mandatory/optional): 02020000/02020000
27499:20140306:201052.585 required mandatory version: 02020000
27504:20140306:201053.006 server #1 started [configuration syncer #1]
| 121 | zabbix | 00Zabbix.local:28038 | zabbix | Query | 1420 | Creating sort index | select clock,ns,value from history_uint where itemid=41464 and clock<=1393477128 and clock>139088512 |
| 122 | zabbix | 00Zabbix.local:28039 | zabbix | Query | 589 | Creating sort index | select clock,ns,value from history where itemid=38800 and clock<=1393477960 and clock>1390885960 ord |
| 123 | zabbix | 00Zabbix.local:28040 | zabbix | Query | 292 | Creating sort index | select clock,ns,value from history_uint where itemid=44533 and clock<=1393478256 and clock>139088625 |
| 124 | zabbix | 00Zabbix.local:28041 | zabbix | Query | 276 | Creating sort index | select clock,ns,value from history_uint where itemid=34877 and clock<=1393478272 and clock>139088627 |