OpenNebula

Hi,

I am using an SVN checkout of ONE and test the new mysql backend. It seems that the hosts table is not created properly on my system (openSUSE 11.3, 64 Bit, MySQL 5.1.46)

This error causes the following output:

one:/var/lib/mysql # onehost list
Error: [HostPoolInfo] Error getting HOST Pool

I had grep'ed for the SQL statement that is used for creating this table and executed it by hand:

mysql> CREATE TABLE IF NOT EXISTS host_pool (oid INTEGER PRIMARY KEY,host_name VARCHAR, state INTEGER, im_mad VARCHAR,vm_mad VARCHAR,tm_mad VARCHAR, last_mon_time INTEGER, cluster VARCHAR, UNIQUE );
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

As you can see MySQL returned an error. Adjusting some of the varchar sizes helped to solve the issue...

mysql> CREATE TABLE IF NOT EXISTS host_pool (oid INTEGER PRIMARY KEY,host_name VARCHAR, state INTEGER, im_mad VARCHAR,vm_mad VARCHAR,tm_mad VARCHAR, last_mon_time INTEGER, cluster VARCHAR, UNIQUE );
Query OK, 0 rows affected (0.02 sec)

Maybe it has something to do with the internal representation of varchar.

Kind regards
Stefan