[Perfparse-users] Fwd: SQL Errors

[Jonnathan C. <jc...@di...>]

When I run --update for databases I get (see below) -- any ideas?

[root@new-host-6 bin]# ./perfparse-db-tool  --update
Auto-convert database up to version 0.19...

Starting...

Warning, this stage may take some time:
An error occured with the SQL:

  "CREATE TABLE IF NOT EXISTS perfdata_bin_summary_data (
metric_id INT NOT NULL, frequency INT NOT NULL, ctime DATETIME NOT NULL,
PRIMARY KEY (metric_id, frequency, ctime),      FOREIGN KEY (metric_id,
frequency)             REFERENCES perfdata_bin_summary_header
(metric_id, frequency)            ON DELETE RESTRICT,     val_count
INTEGER NOT NULL DEFAULT 0,   sum_val DOUBLE NOT NULLsum_square_val
DOUBLE NOT NULL,  max_val DOUBLE NOT NULL,        min_val DOUBLE NOT
NULL,        max_warn DOUBLE NOT NULL,       min_warn DOUBLE NOT NULL,
max_critical DOUBLE NOT NULL,    min_critical DOUBLE NOT
NULL            ) type=InnoDB"

Failure Message:

  "Can't create table './nagios/perfdata_bin_summary_data.frm' (errno:
150)"



Thanks,
Jonnathan