Percona XtraBackup moved to https://jira.percona.com/projects/PXB

Full Backup（archive_write_header failed）

Asked by kazushige uratani on 2012-04-20

Hello!!

The error is as follows.
----------------------------------------------------------------------------------------------------------------
[01] ...done
[01] Streaming ./onmyo_gree_production/treasure_histories#P#p20120319.ibd
>> log scanned up to (2829895986645)
>> log scanned up to (2829895986645)
[01] ...done
[01] Streaming ./onmyo_gree_production/fellow_compositions.ibd
[01] ...done
archive_write_header() failed.
[01] xtrabackup: error: cannot open the destination stream for ./onmyo_gree_production/shikigamis_users.ibd
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 371.
backup finished !!
Thu Apr 19 15:48:53 JST 2012
----------------------------------------------------------------------------------------------------------------

I checked that the table had not broken.
----------------------------------------------------------------------------------------------------------------
mysql> check table shikigamis_users;
+----------------------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------------------------+-------+----------+----------+
| onmyo_gree_production.shikigamis_users | check | status | OK |
+----------------------------------------+-------+----------+----------+
1 row in set (6 min 59.20 sec)
----------------------------------------------------------------------------------------------------------------

I made Size of a file small.
----------------------------------------------------------------------------------------------------------------
Before
-rw-r--r-- 1 mysql mysql 9090 Apr 19 12:49 shikigamis_users.frm
-rw-r--r-- 1 mysql mysql 8627683328 Apr 19 12:44 shikigamis_users.ibd

mysql> alter table shikigamis_users ENGINE=InnoDB;
Query OK, 59435904 rows affected (11 min 11.72 sec)
Records: 59435904 Duplicates: 0 Warnings: 0

After
-rw-rw---- 1 mysql mysql 9090 Apr 19 16:13 shikigamis_users.frm
-rw-rw---- 1 mysql mysql 5708447744 Apr 19 16:24 shikigamis_users.ibd
----------------------------------------------------------------------------------------------------------------

After that.
I was able to backup.
----------------------------------------------------------------------------------------------------------------
[01] ...done
[01] Streaming ./onmyo_gree_production/shikigamis_users.ibd
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
>> log scanned up to (2843547600961)
[01] ...done
----------------------------------------------------------------------------------------------------------------

It seems that it becomes an error when a large file is backed up.

I think that there is wall of 8 GB.

Would you try on larger file than 8 GB file?

Question information

Language:: English Edit question

Status:: Solved

For:: Percona XtraBackup moved to https://jira.percona.com/projects/PXB Edit question

Assignee:: No assignee Edit question

Solved by:: Alexey Kopytov

Solved:: 2012-04-23

Last query:: 2012-04-23

Last reply:: 2012-04-20

Revision history for this message

kazushige uratani (kazushige-uratani) said on 2012-04-20:

Hello!!

I was able to do backup by using a "stream=xbstream" option.
However, it was not able to restore.

Would you teach the method of restoration?
Moreover, please also give me the rise of a new manual.

Thank you!!

Revision history for this message

Alexey Kopytov (akopytov) said on 2012-04-20:

Hello,

The problems with --stream=tar with files larger than 8 GB is bug #977998. We now have a solution for this bug, so you can expect a fix in XtraBackup 2.0.1.

Regarding the xbstream format being undocumented, it's bug #977533. The documentation has already been written and will be uploaded after reviews in the next few days.

I'm linking those bug reports to this question, so you will be notified when those bugs will be closed.

Revision history for this message

kazushige uratani (kazushige-uratani) said on 2012-04-23:

Hello Alexey!!

I see!!

I expect that it will be solved.
I am going to try, if the following version is released.

This matter is once closed.

Thank you.

Revision history for this message

kazushige uratani (kazushige-uratani) said on 2012-04-23:

Thanks Alexey Kopytov, that solved my question.

To post a message you must log in.

Ask a question

Edit question

Percona XtraBackup moved to https://jira.percona.com/projects/PXB

Full Backup（archive_write_header failed）

Question information

Related bugs

Related FAQ:

Subscribers