upgrade error

[woger]

Hi,
I am upgrading from 1.4.5 to 1.6 and when I run the mysql patch i get this error:

[root@fedora mysql]# mysql -uzabbix -p****** zabbix < patch.sql
ERROR 1025 (HY000) at line 53: Error on rename of './zabbix/escalations' to './zabbix/#sql2-9ab-2cc83' (errno: -1)

anybody an idea what is going wrong?
further info:
fedora5
php 5.1.6
mysql 5.0.7

thanks,

Roger

[Alexei]

It seems to be something related to MySQL or OS problems (lack of disk space, file descriptors, whatever).

[woger]

I have another 290Gb free on the disk so thatś not a problem. I also did a myisamchk on the database without any error.

greetings,

Roger

[xs-]

You are using myisam?
I dont know for sure but it's possible some tricks used by the patch file require innodb tables.

[woger]

the database uses innodb.
mysql> SHOW VARIABLES LIKE 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | YES |
+---------------+-------+
1 row in set (0.00 sec)

Roger

[xs-]

database support yes, but what type are the tables.

[woger]

ehmm, how do I check that?