[ZBX-8047] Zabbix database convert to node taking longer time Created: 2014 Apr 08  Updated: 2017 May 30  Resolved: 2014 Apr 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I)
Affects Version/s: 2.0.9
Fix Version/s: None

Type: Incident report Priority: Blocker
Reporter: mayuresh bhardwaj Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: dm
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Cent os



 Description   

Hi,

I am trying to conver the database to node. My database backup size is 300 MB. When i am changing database it is taking longet time and stuck at converting tables.

Is it takes time according to DB size ?

bash# zabbix_server -n 4
Dropping foreign keys ......................................................................................................................... done.
Converting tables ..........................................................................

Thanks
Mayur



 Comments   
Comment by Aleksandrs Saveljevs [ 2014 Apr 08 ]

Strictly speaking, this is not a complete bug report (see https://www.zabbix.org/wiki/Docs/bug_reporting_guidelines) and is better investigated through https://www.zabbix.org/wiki/Getting_help .

If you wish to investigate this further, you should enable DebugLevel=4 in server configuration to see where it gets stuck.

In general, though, transition to distributed monitoring is not advised, because ZBXNEXT-1343 is going to remove it in 2.4.

Comment by richlv [ 2014 Apr 08 ]

as mentioned, dm is being removed for 2.4, so this is unlikely to be looked into much -> closing.

one reason why sometimes conversion is slow - zabbix server has not been stopped during the conversion.

Generated at Wed Apr 24 12:00:49 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.