Solved

zabbix server backup issue

Posted on 2013-12-27
6
1,064 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to retrieve remote exit code when using rsh from Linux to Windows ? 13 52
linux SFTP 8 60
SMB share across internet 15 65
Apache module 5 47
How many times have you wanted to quickly do the same thing to a list but found yourself typing it again and again? I first figured out a small time saver with the up arrow to recall the last command but that can only get you so far if you have a bi…
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 how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

860 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