mydumper is generating *metadata file for each table

[aloks2019]

Mydumper is generating *metadata file for each table. This file contains number of imsert statements mentioned in file *.SQL.gz ; however there are separate files *sql.gz having actual insert statements.

However, myloader is not able to process those file and error is “cannot open file /database name.tablename-metadata.

backup command mydumper —user —ask-password —compress —compress-protocol—triggers—events —routines —build-empty-files —try-consistency-only —kill-long-queries —outputdir

[davidducos]

Hi @aloks2019 are you using same mydumper/myloader versions?

[aloks2019]

Yes.. using same version v0.12.1

[aloks2019]

I couldn’t try latest version as rpm of mydumper for RHEL8 is not available

[davidducos]

As a workaround, just remove them.

[aloks2019]

Yeah!! Doing same for now.. I have deleted all the *-metadata files except “metadata” file.

[davidducos]

Can you prepare a test case? it was impossible for me to reproduce your issue.

[aloks2019]

I don’t see this issue in latest version