InnoDB assertion failure in log0log.cc line 616

[Daniel Nichter]

I'm trying to sysbench Drizzle with 48 tables of 5M rows each, but sysbench causes Drizzle InnoDB to die on the second table with this error:

111223 20:32:58 InnoDB: Assertion failure in thread 140116942296960 in file plugin/innobase/log/log0log.cc line 616
InnoDB: Failing assertion: (sizeof(ulint) == 4) || (offset < (((ib_int64_t) 1) << 32))

Alexey @ Percona told me:

It's a wrong assertion. The goal was to restrict offset to 4GB on 32-bit
systems. So it should be "(sizeof(ulint) != 4) || (offset < (((ib_int64_t) 1) << 32))"

The revision that introduced that code:

revno: 2258.3.1
committer: Laurynas Biveinis
branch nick: percona-files-extend
timestamp: Tue 2011-04-05 13:32:12 +0300
message: Port Percona's innodb_files_extend.patch

But the code in XtraDB is different:

 if (sizeof(ulint) == 4) {
 ut_a(offset < (((ib_int64_t) 1) << 32)); /* offset must be < 4 GB */
 }

Which is less pretty, but correct.

I'm not sure what the relationship is between Drizzle InnoDB and Percona XtraDB. In any case, the bug exists in Drizzle and is preventing big sysbench tests.