willsion / appaloosa-zabbix-templates

Automatically exported from code.google.com/p/appaloosa-zabbix-templates
0 stars 0 forks source link

Can't load the xml file with Zabbix 2 #6

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Generate the mysql.xml with the appaloosa plugin : perl 
tools/gen_template.pl defs/mysql.pl mysql.xml
2. Import the mysql.xml into the new Zabbix 2

What is the expected output? What do you see instead?

Many errors occurs :

Created: Application "MySQL" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf cell count" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Unflushed log" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State end" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads connected" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com update multi" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read next" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache queries in cache" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Spin waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Relay log space" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB locked tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read first" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Innodb row lock time" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Lock system memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pool size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Page hash memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Open files limit" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf merges" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State sending data" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending log flushes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Opened tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache not cached" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Total mem alloc" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State locked" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key read requests" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Open tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort range" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler delete" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads created" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows read" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Read views" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read key" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort rows" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Bytes sent" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending buf pool flushes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB lock wait secs" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave lag" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State init" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Log bytes written" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Questions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler rollback" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State updating" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Thread hash memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com replace select" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave retried transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache total blocks" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Created tmp files" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read rnd" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com replace" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache free blocks" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select range check" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slow launch threads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key buf bytes unflushed" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select full range join" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Current transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Active transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending AIO sync ios" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads cached" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read rnd next" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB lock structs" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State reading from net" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State freeing items" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binlog cache size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select range" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State sorting result" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Hash index cells used" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State none" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Open files" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pages read" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Log bytes flushed" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com insert" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com delete" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending normal AIO writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Free pages" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Additional pool alloc" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Created tmp disk tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave running" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State statistics" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Database pages" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Uncheckpointed bytes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select full join" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending chkp writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows updated" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Max connections" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Aborted clients" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort scan" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key write requests" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows inserted" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Connections" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State preparing" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com select" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "OS waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Recovery system memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Table cache" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binlog cache use" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB sem wait time ms" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com update" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache free memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Spin rounds" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler savepoint" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com delete multi" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pages created" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache lowmem prunes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Bytes received" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read prev" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Hash index cells total" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache inserts" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com load" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State login" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "History list" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MySQL Processes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache hits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binlog cache disk use" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler commit" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State other" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave open temp tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending ibuf AIO reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Adaptive hash memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler prepare" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf inserts" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows deleted" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Table locks immediate" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Modified pages" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Table locks waited" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB tables in use" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB sem waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Created tmp tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Aborted connects" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File fsyncs" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM key buffer size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Query cache size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Innodb row lock waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File system memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binary log space" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave stopped" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler discover" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending normal AIO reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State copying to tmp table" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf merged" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slow queries" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State closing tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Thread cache size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pages written" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf used cells" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com insert select" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Locked transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending AIO log ios" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending log writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB log buffer size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf free cells" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Max used connections" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler write" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler savepoint rollback" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads running" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key buf bytes used" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Dictionary cache memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler update" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB open files" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Log writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort merge passes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select scan" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State writing to net" on "Template_MySQL".
Created: Trigger "Process mysqld not running on {HOSTNAME}" on "Template_MySQL".
Created: Trigger "Slave lag more than 10m over 10m on {HOSTNAME}" on 
"Template_MySQL".
Created: Trigger "Slave lag more than 5m over 10m on {HOSTNAME}" on 
"Template_MySQL".
Created: Trigger "Slave is stopped on {HOSTNAME}" on "Template_MySQL".
Created: Trigger "More than 500 threads on {HOSTNAME}" on "Template_MySQL".
Created: Trigger "Server {HOSTNAME} is waiting on table locks" on 
"Template_MySQL".
Created: Trigger "InnoDB lock structures more than 30 in 5m on {HOSTNAME}" on 
"Template_MySQL".
Created: Trigger "InnoDB uncheckpointed bytes in the last 10m > 25MB on 
{HOSTNAME}" on "Template_MySQL".
Created: Trigger "Thread in state Copying_to_tmp_table for more than 6min on 
{HOSTNAME}" on "Template_MySQL".
Updated: Trigger "Slave lag more than 10m over 10m on {HOSTNAME}" on 
"Template_MySQL".
Error in query [INSERT INTO trigger_depends 
(triggerid_down,triggerid_up,triggerdepid) VALUES ('13536','1',40)] [Cannot add 
or update a child row: a foreign key constraint fails 
(`zabbix`.`trigger_depends`, CONSTRAINT `c_trigger_depends_2` FOREIGN KEY 
(`triggerid_up`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE)]
SQL statement execution has failed "INSERT INTO trigger_depends 
(triggerid_down,triggerid_up,triggerdepid) VALUES ('13536','1',40)".

What version of the product are you using? On what operating system?

Zabbix 2.0.0
appaloosa-zabbix-templates 0.0.1
better-cacti-templates 1.1.8
MySQL 5.5.24
PHP 5.3.3-7+squeeze9
Debian squeeze

Original issue reported on code.google.com by cedric.p...@gmail.com on 23 May 2012 at 3:18

GoogleCodeExporter commented 9 years ago
Just tested with Zabbix 1.8.12 and import is ok.
Anybody can help to work on a 2.0.0 xml file ?

Original comment by cedric.p...@gmail.com on 25 May 2012 at 1:51

GoogleCodeExporter commented 9 years ago
Well.. it now expects the tag <delay_flex/> for every item. Attached patch adds 
this. However that's only fixing a notice.

I don't know, why the import of the trigger fails. But you can just disable the 
import of triggers, then it works (triggers are defined at the end of the xml 
file, so creating them by hand shouldn't be too hard).

Original comment by steffen....@googlemail.com on 12 Jun 2012 at 10:47

Attachments:

GoogleCodeExporter commented 9 years ago
I don't know, if that's the problem, but you output all the trigger 
dependencies (<dependencies>) at the beginning of the file as direct child of 
<zabbix_export>.

If I export a template from zabbix, the <dependencies> are children of a 
<trigger>, like this:

Yours:
  <dependencies>
    <dependency description="Template_MySQL:Slave lag more than 10m over 10m on {HOSTNAME}">
      <depends>Template_MySQL:Process mysqld not running on {HOSTNAME}</depends>
    </dependency>

Zabbix 2.0 export:

    <triggers>
        <trigger>
            <expression>{Service Apt Update Check:custom.apt-update-check.normal.last(0)}>0</expression>
            <name>Non-critical updates available</name>
...
            <dependencies>
                <dependency>
                    <name>Security updates available</name>
                    <expression>{Service Apt Update Check:custom.apt-update-check.security.last(0)}>0</expression>
                </dependency>
            </dependencies>

Original comment by steffen....@googlemail.com on 12 Jun 2012 at 11:08

GoogleCodeExporter commented 9 years ago
Is there a definite fix or workaround as trying Zabbix 2.0.0 myself. and get 
the same error.

What version of the product are you using? On what operating system?

Zabbix 2.0.0
appaloosa-zabbix-templates 0.0.1
better-cacti-templates 1.1.8
5.5.24-0ubuntu0.12.04.1-log (Ubuntu)
PHP 5.3.10-1ubuntu3.2 with Suhosin-Patch (cli)
Zabbix Appliance openSUS 12.1 "Asparagus" - Kernel 3.1.10-1.9-defaultroot

Dom

Original comment by Dominic....@gmail.com on 10 Jul 2012 at 11:15

GoogleCodeExporter commented 9 years ago
Yes, there is ;-)
http://www.fromdual.ch/mysql-performance-monitor

Original comment by cedric.p...@gmail.com on 10 Jul 2012 at 11:41