Solved

zabbix server backup issue

Posted on 2013-12-27
6
1,057 Views
Last Modified: 2014-01-05
Hi Expert,

I've configured zabbix in ubuntu 12.04.Now it's working fine.
now i'm trying to take backup and restore backup in new zabbix machine.i've restored backup in new zabbix system.and when i was logging in browser than i've got below error.

    * Error in query [SELECT DISTINCT t.triggerid,t.value,t.lastchange,t.priority,t.value_flags,t.description,t.error, t.expression,hg.groupid FROM triggers t,functions f,items i,hosts_groups hg WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid IN ('2','4') AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') ORDER BY lastchange DESC,t.lastchange DESC] [Unknown column 't.value_flags' in 'field list']
   
 * Error in query [SELECT e.* FROM events e JOIN (SELECT max(eventid) as lasteventid FROM events e WHERE 1=0 AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND e.object=0 AND e.value_changed=1 GROUP BY e.objectid) ee ON e.eventid=ee.lasteventid] [Unknown column 'e.value_changed' in 'where clause']

Please suggest,what can we do in this situation.

Thanks & Regards,
xeroxzerox
0
Comment
Question by:xeroxzerox
  • 3
  • 3
6 Comments
 
LVL 21

Accepted Solution

by:
Mazdajai earned 500 total points
ID: 39744743
Are they running the same version of zabbix? How do you take a backup and restore?

http://zabbixzone.com/zabbix/backuping-full-database/

This is an indication of database column mismatch. Without knowing the db structure, it is difficult to pin point issue. I would suggest opening a case with Zabbix and submit a dump of the db to them.
0
 
LVL 6

Author Comment

by:xeroxzerox
ID: 39745540
Thanks for response but Same issue facing .. same error i found in it.
i've successfully taken fullbackup and only configured setting backup from zabbix.
but issue in restore.may be some gap missing.
0
 
LVL 21

Expert Comment

by:Mazdajai
ID: 39746265
How do you perform the restore?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 6

Author Comment

by:xeroxzerox
ID: 39750685
http://zabbixzone.com/zabbix/backuping-full-database/

in this link in below script scribe to restore backup....
0
 
LVL 21

Expert Comment

by:Mazdajai
ID: 39753073
What version of zabbix? Can you post the mysql log?
0
 
LVL 6

Author Closing Comment

by:xeroxzerox
ID: 39758573
Thanks...
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am a long time windows user and for me it is normal to have spaces in directory and file names. Changing to Linux I found myself frustrated when I moved my windows data over to my new Linux computer. The problem occurs when at the command line.…
Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question