Hi all,

I try to restore a dump from an old 4.1.22 (MyIsam,latin1) database into my recent mysql-cluster (5.1.22,utf8). When starting from a new databases (I create it and import the dump), everything runs fine. But when I upgrade the database (drop tables and recreate tables + insert from a dump), I encounter a strange problem. I can do select normally from the api node where I imported the dump, but from other nodes I have an error:

"ERROR 1296 (HY000): Got error 241 'Invalid schema object version' from NDBCLUSTER"

This problem is documented as a long time bug in the bug tracker and mailing lists. Some say you have to replay the select to have it work again, some other say you have to restart the api node to have it work but neither work in my case. The error is persistent !

Note that this problem do not occur on all tables, but only some of them. Some other tables from the same database dump work fine. Importing the dump with "mysql database < dump" reports no error at all and nothing special in the logs.

Do you have a clue on this issue ? Any similar experience with a solution ? Are there in your opinion some particular things I should check or make before considering it as a bug ?

Thanks for your remarks and comments on this.

Vincent.

Details:

glibc 2.3.6 mysql-cluster-5.1.22

On host where the dump has been restored:

mysql> SELECT * FROM UserObmPref WHERE (userobmpref_user_id='0' OR userobmpref_user_id='10') ORDER BY userobmpref_user_id, userobmpref_option ; +---------------------+--------------------+-------------------+ | userobmpref_user_id | userobmpref_option | userobmpref_value | +---------------------+--------------------+-------------------+ | 0 | set_cal_interval | 2 | | 0 | set_commentorder | 0 | | 0 | set_csv_sep | ; | | 0 | set_date | Y-m-d | | 0 | set_date_upd | mdy | | 0 | set_day_weekstart | monday | | 0 | set_debug | 0 | | 0 | set_display | no | | 0 | set_dsrc | 0 | | 0 | set_lang | fr | | 0 | set_mail | yes | | 0 | set_menu | both | | 0 | set_rows | 12 | | 0 | set_theme | aliasuite | | 0 | set_todo | todo_priority | | 10 | last_company | 2926 | | 10 | last_contact | 2810 | | 10 | last_document | 9493 | +---------------------+--------------------+-------------------+

On the otther cluster nodes:

mysql> SELECT * FROM UserObmPref WHERE (userobmpref_user_id='0' OR userobmpref_user_id='10') ORDER BY userobmpref_user_id, userobmpref_option ; ERROR 1296 (HY000): Got error 241 'Invalid schema object version' from NDBCLUSTER