Percona XtraDB Storage Engine for MySQL

innodb compression hangs

Reported by Nickolay Ihalainen on 2009-01-14
2
Affects Status Importance Assigned to Milestone
Percona-XtraDB
Fix Released
High
Unassigned

Bug Description

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) wrote :

Can't repeat on my box at this moment.

Can you get gdb backtrace at the moment of hang ?

Nickolay Ihalainen (ihanick) wrote :

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.

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

Thank you.

Percona (percona-team) wrote :

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) wrote :

There is a backtrace for 5.1.30-3

Percona (percona-team) wrote :

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) wrote :

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

Nickolay,

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

Thank you for your very meaningful report!

Percona (percona-team) wrote :

Nickolay,

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

I included Yasufumi's fixes.

Changed in percona-xtradb:
status: New → In Progress
importance: Undecided → High
status: In Progress → Fix Committed
Changed in percona-xtradb:
assignee: nobody → yasufumi-kinoshita
Nickolay Ihalainen (ihanick) wrote :

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

Percona (percona-team) wrote :

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) wrote :

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

Percona (percona-team) wrote :

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.

Changed in percona-xtradb:
status: Fix Committed → In Progress
Nickolay Ihalainen (ihanick) wrote :

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

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!

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.

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.

Changed in percona-xtradb:
status: In Progress → Fix Committed
Changed in percona-xtradb:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers