build with --with-extra-charsets=all

Bug #690661 reported by Kostas Chatzikokolakis
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
Medium
Ignacio Nin
1.6
Fix Released
Critical
Stewart Smith
2.0
Fix Released
Medium
Ignacio Nin

Bug Description

We are using greek character set in some tables. When trying to --prepare, I was getting the following error (xtrabackup 1.5, MySQL 5.1.41):

InnoDB: Assertion failure in thread
1214785856 in file xtrabackup.c line 1070

In this thread it is mentioned that this is a charset issue and the solution is to build with enough character sets:
http://groups.google.com/group/percona-discussion/browse_thread/thread/68301ff3288443d6/6d8ef9d3dd144291?lnk=gst&q=character+set&pli=1

I built with -with-extra-charsets=all and the problem is gone. So, unless it causes any issues (I'm no expert in building mysql), it would be hugely useful if the provided binary builds include all character sets.

Kostas

Tags: cr i15577

Related branches

Changed in percona-xtrabackup:
assignee: nobody → Aleksandr Kuzminsky (akuzminsky)
milestone: none → 1.6
Changed in percona-xtrabackup:
assignee: Aleksandr Kuzminsky (akuzminsky) → Valentine Gostev (core-longbow)
importance: Undecided → Medium
Revision history for this message
Valentine Gostev (longbow) wrote :

Could you please add a sample table dump containing greek characters to this bug report?

Changed in percona-xtrabackup:
status: New → Confirmed
assignee: Valentine Gostev (core-longbow) → Ignacio Nin (ignacio-nin)
status: Confirmed → Triaged
Revision history for this message
Vadim Tkachenko (vadim-tk) wrote :

Ignacio, this should be done when you build binary

Changed in percona-xtrabackup:
status: Triaged → Fix Committed
Changed in percona-xtrabackup:
milestone: 1.6 → 1.7
tags: added: cr i15577
Revision history for this message
Jan Scheufler (werewolf22) wrote :

Hi all,
sorry for bringing this up again, but I wanted to ask, whether this is already featured in v2.0.6, as I am currently having the same problem.

What I am trying to ask, is the binary version of XtraBackup, that can be downloaded from percona.com built with the above mentioned option, or not?

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Jan,

Yes, 2.0.6 is built with extra_charsets=all. If you are having a similar problem, please report it as a bug.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-551

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.