An IO Error Occurred While Parsing MySQL XML Document

Problem:

An IO error occurred while parsing MySQL XML document. (Invalid byte 2 of 3-byte UTF-9 sequence.)

Solution:

UPDATE: Recent versions of the CDP Server and agent should not see this error. Everything is now converted to UTF-8 before being read.

Lets gather data.

This command will get all dbs using perl expression a-zA-Z0-9_ then store the results to file:\\

 
cd /var/lib/mysql

find . | grep -P '[/w]' > test1.dbs

Now lets gather all the records and store to a different file.

 
find .  -name '*' > test2.dbs
 

Not lets diff the files and see what is different between them.

 
[root@db1 mysql]# diff test1.dbs test2.dbs

41687,41689d41682

< ./mtgcent_mtgcenter/vente_foirée.frm

< ./mtgcent_mtgcenter/vente_foirée.MYI

< ./mtgcent_mtgcenter/vente_foirée.MYD

Login to mysql:

 
mysql -u root -p

use mtgcent_mtgcenter;

show tables;

Results shows a bunch of tables but lets focus on the ones that are simliar to the diff above and I show 2 tables that could possibly match:

 
| vente_foiree

| vente_foir

Then check the actual disk to see which one is missing or wrong:

 
-rw-rw----    1 mysql    mysql        8824 Jun  9  2006 vente_foiree.frm

-rw-rw----    1 mysql    mysql       55244 Sep 19  2006 vente_foiree.MYD

-rw-rw----    1 mysql    mysql        5120 Sep 19  2006 vente_foiree.MYI

-rw-rw----    1 mysql    mysql        8776 Sep 28  2005 vente_foirée.frm

-rw-rw----    1 mysql    mysql      113400 Jun  5  2006 vente_foirée.MYD

-rw-rw----    1 mysql    mysql        7168 Jun  5  2006 vente_foirée.MYI

Hmm there are 2 but not the foir one.
Looks like vente_foir is missing but on disk it has special character so lets change the name and remove ée:

 
-rw-rw----    1 mysql    mysql        8824 Jun  9  2006 vente_foiree.frm

-rw-rw----    1 mysql    mysql       55244 Sep 19  2006 vente_foiree.MYD

-rw-rw----    1 mysql    mysql        5120 Sep 19  2006 vente_foiree.MYI

-rw-rw----    1 mysql    mysql        8776 Sep 28  2005 vente_foir.frm

-rw-rw----    1 mysql    mysql      113400 Jun  5  2006 vente_foir.MYD

-rw-rw----    1 mysql    mysql        7168 Jun  5  2006 vente_foir.MYI

Login back to mysql.
Run a check on that table mysql> check table vente_foir

 
+--------------------------------+------------+------------+----------+

| Table | Op | Msg_type | Msg_text |

+--------------------------------+------------+------------+----------+

| mtgcent_mtgcenter.vente_foir | check | status | OK |

+--------------------------------+------------+------------+----------+

1 row in set (0.01 sec)

Re-Ran backup and it completes just fine now.

An IO Error Occurred While Parsing MySQL XML Document

An IO Error Occurred While Parsing MySQL XML Document

Problem:

Solution:

Related Articles