Drizzledump fails when trying to migrate MEMORY tables from MySQL

Bug #683917 reported by Patrick Crews
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
High
Andrew Hutchings
7.0
Fix Released
High
Andrew Hutchings

Bug Description

When trying to execute this command:
../client/drizzledump --compact --host=127.0.0.1 --port=13000 --destination-type=database --destination-host=localhost --destination-port=9306 --destination-user=root --destination-database=drizzledump_migrate_test --user=root drizzledump_migrate_test

drizzledump produces this output:
Error executing query: Can't create table 'drizzledump_migrate_test.t3' (errno: 138)
Error inserting into destination database

Contents of schema drizzledump_migrate_test on the MySQL server.
CREATE TABLE t1 (a INT) ENGINE=MyISAM;

CREATE TABLE t2 (a INT) ENGINE=Innodb;

CREATE TABLE t3 (a INT) ENGINE=MEMORY;

Will link to a branch with a test case + instructions for repeating via test-run.pl

Related branches

Revision history for this message
Patrick Crews (patrick-crews) wrote :

To repeat:
1) You need a running MySQL server
2) Set two environment vars:
  DRIZZLE_MYSQL_MIGRATE_TEST=1
  DRIZZLE_MYSQL_MIGRATE_PORT= port where MySQL is running

 ./test-run --record --suite=mysql_migrate engines

Changed in drizzle:
assignee: nobody → Andrew Hutchings (linuxjedi)
status: New → Confirmed
Changed in drizzle:
importance: Undecided → High
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers