innodb compression hangs

[Nickolay Ihalainen]

alter table large_table ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
conversion hangs at 70-120 MB of 1.2GB large table.
this release percona-xtradb-1.0.2-1-5.1.30.x86_64.tar.gz works normaly, but
percona-xtradb-1.0.2-2-5.1.30.x86_64.tar.gz hangs.

[Percona (percona-team)]

Can't repeat on my box at this moment.

Can you get gdb backtrace at the moment of hang ?

[Nickolay Ihalainen (ihanick)]

Also, the hung is reproduced with the command:
alter table large_table ENGINE=MyISAM; (large table in ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8)
again work fine with prev version.

[Yasufumi Kinoshita (yasufumi-kinoshita)]

It may be latching order bug.
And it have been fixed at extensions-1.0/revision/27 already.

Thank you.

[Percona (percona-team)]

Nickolay,

It should be fixed in release-3 (not announced yet, on testing stage).

Can you try it from
http://www.percona.com/mysql/5.1.30-3/binary/ ?

[Nickolay Ihalainen (ihanick)]

There is a backtrace for 5.1.30-3

[Percona (percona-team)]

Nickolay,

Thank you for trying it..

I made version without split_buffer_mutex_patch - it's there
http://www.percona.com/mysql/5.1.30-3/binary/
percona-xtradb-1.0.2-pre3-5.1.30.x86_64.tar.gz

Can you try it please ?

Also can you show me your my.cnf ? I will try to repeat with your settings.

[Nickolay Ihalainen (ihanick)]

Yes, the pre3 works perfectly.
I'm using 3307 server from my.cnf with mysqld_multi

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Nickolay,

I have fixed the second hangup at extensions-1.0/revision/31

Thank you for your very meaningful report!

[Percona (percona-team)]

Nickolay,

Please try new version
percona-xtradb-1.0.2-3-5.1.30.x86_64.tar.gz

I included Yasufumi's fixes.

[Nickolay Ihalainen (ihanick)]

Version -3 (2009-01-16 06:56) hangs at compressid innodb to myisam alteration.

[Percona (percona-team)]

Nickolay,

Thank you very much, you provide invaluable feedback!

Any chance you can try percona-xtradb-1.0.2-pre3-5.1.30.x86_64.tar.gz ?

This version without split_buffer_pool extension.

[Nickolay Ihalainen (ihanick)]

Thanks, As I mentioned before - percona-xtradb-1.0.2-pre3-5.1.30.x86_64.tar.gz works fine.

[Percona (percona-team)]

Nickolay,

Thank you, so we probably will exclude split-buffer-pool from release 3 for now.

I missed that email somehow - I see you are using small buffer_pool size - I will try to experiment with your config.

[Nickolay Ihalainen (ihanick)]

I provide table structure and some configuration information in this attach. Maybe it helps.

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Nickolay,

Thank you very much for your reporting.

The next bug has been fixed at extensions-1.0/revision/33

Could you try again if we prepare the new source or binary?

Again,
Thank you very much!

[Yasufumi Kinoshita (yasufumi-kinoshita)]

I have found next reason of hangup. (And it may be last to fix about this case)
I will fix it at next revision.
Please be patient.

Thank you.

[Yasufumi Kinoshita (yasufumi-kinoshita)]

I could reproduce the hangup when "alter table large_table ENGINE=MyISAM;".
And I fixed not to cause the hangup at my environment at least.

The fix is pushed as extensions-1.0/revision/34.

Thank you.