My Oracle Support Banner

Unexpected EOF Error While Exporting A Large Table Using Shell Dump Utilities (dumpInstance/dumpTables) (Doc ID 2861045.1)

Last updated on APRIL 06, 2022

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Symptoms

On : 5.7 version, Other Technical Problem

Error while exporting a large table using shell dump utilities (dumpInstance/dumpTables)

ERROR
-----------------------
Error: [Worker001]: Error while dumping `<db>`.`<table>`: MySQL Error 9 (HY000): Unexpected EOF found when reading file ‘/tmp/MYEqko1C’ (Errcode: 175 - File to short; Expected more data in file)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an innodb cluster with large data e.g. 100G
2. Set the temporary space on the active node to be equal or smaller than the data size
3. Attempt a dumpInstance()/dumpTables() from that active node

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot dump the required schema.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.