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

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!!

Best Alexey Kopytov (akopytov) said : #2

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.

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.

Thanks Alexey Kopytov, that solved my question.