[BUG] myloader 0.11.1 fails to restore dump with several databases

[nerijus]

With 0.10.7-2 it works:

$ myloader -d export-20210924-061432  --threads=1 --verbose=3 -o 2> mydumper.log

mydumper.log:

** Message: 07:28:12.626: 1 threads created
** Message: 07:28:12.627: Dropping table or view (if exists) `ejabberd`.`archive`
** Message: 07:28:12.640: Creating table `ejabberd`.`archive`
...
** Message: 07:28:12.950: Dropping table or view (if exists) `reg_manager`.`schema_migrations`
** Message: 07:28:12.951: Creating table `reg_manager`.`schema_migrations`
...

With 0.11.1-1 or 0.11.1-2 it fails:

** Message: 07:31:00.659: Step 1 completed, Databases created
** Message: 07:31:00.661: Thread 1 restoring table `ejabberd`.`archive` from /var/opt/export-20210924-061432/ejabberd.archive-schema.sql.gz
** Message: 07:31:00.661: Dropping table or view (if exists) `ejabberd`.`archive`
** Message: 07:31:00.672: Creating table `ejabberd`.`archive` from /var/opt/export-20210924-061432/ejabberd.archive-schema.sql.gz
...
** Message: 07:31:00.947: Thread 1 restoring table `reg_manager`.`schema_migrations` from /var/opt/export-20210924-061432/reg_manager.schema_migrations-schema.sql.gz
** Message: 07:31:00.947: Dropping table or view (if exists) `reg_manager`.`schema_migrations`
** Message: 07:31:00.951: Creating table `reg_manager`.`schema_migrations` from /var/opt/export-20210924-061432/reg_manager.schema_migrations-schema.sql.gz

** (myloader:22565): CRITICAL **: 07:31:00.951: Error restoring: CREATE TABLE `schema_migrations` (
  `version` bigint(20) NOT NULL,
  `dirty` tinyint(1) NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

** (myloader:22565): CRITICAL **: 07:31:00.951: Thread 1 issue restoring /var/opt/export-20210924-061432/reg_manager.schema_migrations-schema.sql.gz: Table 'schema_migrations' already exists
...

[nerijus]

It seems the bug manifests itself when restoring 2nd database:

** Message: 07:31:00.920: Dropping table or view (if exists) `ejabberd`.`vcard_search`
** Message: 07:31:00.923: Creating table `ejabberd`.`vcard_search` from /var/opt/export-20210924-061432/ejabberd.vcard_search-schema.sql.gz
** Message: 07:31:00.947: Thread 1 restoring table `reg_manager`.`schema_migrations` from /var/opt/export-20210924-061432/reg_manager.schema_migrations-schema.sql.gz
** Message: 07:31:00.947: Dropping table or view (if exists) `reg_manager`.`schema_migrations`
** Message: 07:31:00.951: Creating table `reg_manager`.`schema_migrations` from /var/opt/export-20210924-061432/reg_manager.schema_migrations-schema.sql.gz

** (myloader:22565): CRITICAL **: 07:31:00.951: Error restoring: CREATE TABLE `schema_migrations` (
  `version` bigint(20) NOT NULL,
  `dirty` tinyint(1) NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

** (myloader:22565): CRITICAL **: 07:31:00.951: Thread 1 issue restoring /var/opt/export-20210924-061432/reg_manager.schema_migrations-schema.sql.gz: Table 'schema_migrations' already exists

[davidducos]

Hi @nerijus, is schema_migrations present in other databases?

[davidducos]

Hi @nerijus, I found the bug, actually, I fixed on https://github.com/maxbube/mydumper/tree/stream but didn't realize that it was on this one. Sorry! Pull request and new release is on its way