Bug #55713 innochecksum is NOT built with large file support enabled

• Submitted: 3 Aug 2010 13:32
• Modified: 16 Aug 2011 17:31
• Reporter: Oli Sennhauser
• Status: Closed
• Category: MySQL Server: Compiling
• Severity: S3 (Non-critical)
• Version: 5.1.48, 5.1.50
• OS: Linux (32-bit)
• Assigned to: Hery Ramilison
• CPU Architecture: Any
• Tags: innochecksum, large file support

[3 Aug 2010 13:32] Oli Sennhauser

Description:
When I run innochecksum against an ibdata file which is bigger than 2 (4?) Gbyte I get an error.
When innochecksum is compiled with large file support it works!

How to repeat:
ls -la ibdata1
-rw-r--r-- 1 mysql dba 8360129761 2010-07-30 21:02 ibdata1

./innochecksum ibdata1
error statting file: Value too large for defined data type

gcc innochecksum.c -D_FILE_OFFSET_BITS=64
./innochecksum ibdata1
page 0 invalid (fails log sequence number check)

Suggested fix:
Compile also 32-bit MySQL binaries with large file support because it can easily happen, that an InnoDB tablespace files gets bigger than 2 GB!

[5 Aug 2010 7:35] Sveta Smirnova

Thank you for the report.

I can not repeat described behavior neither with binaries built with BUILD/compile-pentium64-debug-max, nor with mysql-5.1.49-linux-x86_64-glibc23 package. Which package do you use?

[10 Aug 2010 9:46] Oli Sennhauser

> mysql-5.1.44-linux-i686-glibc23/bin/innochecksum ibdata1
error statting file: Value too large for defined data type
> mysql-5.1.48-linux-i686-glibc23/bin/innochecksum ibdata1
error statting file: Value too large for defined data type
> mysql-cluster-gpl-7.1.4b-linux-i686-glibc23/bin/innochecksum ibdata1
error statting file: Value too large for defined data type

[10 Aug 2010 20:07] Sveta Smirnova

Thank you for the feedback.

Verified as described: 32-bit version of innochecksum is not built with large file support by default, although it can be built in such a mode.

[16 Aug 2011 17:31] Hery Ramilison

Fix commited in 5.1 branch.