Bug #49613 Backup 1687 Error when sending data (for table #10) to Snapshot restore driver
Submitted: 11 Dec 2009 8:37 Modified: 11 Oct 2010 12:11
Reporter: Philip Stoev Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:6.0-backup OS:Any
Assigned to: Thava Alagu CPU Architecture:Any

[11 Dec 2009 8:37] Philip Stoev 
Description:
The 1687 Error when sending data (for table #10) to Snapshot restore driver error has been observed again on a completely fresh 6.0-backup tree, even though all previous bugs regarding this error have been closed.

How to repeat:
The frequency of this error is less than one per several thousand backups, so it may be difficult to reproduce. Issuing the same RESTORE command again succeeds.
[11 Dec 2009 11:12] Philip Stoev 
Correct grammar for bug bug49613

Attachment: bug49613.yy (application/octet-stream, text), 69.89 KiB.
[11 Dec 2009 11:14] Philip Stoev 
To reproduce this with the RQG:

$ perl runall.pl \
  --grammar=conf/bug46913.yy \
  --basedir=/build/bzr/mysql-6.0-backup \
  --queries=100K \
  --mysqld=--mysql-backup \
  --duration=1200 \
  --threads=10 \
  --gendata=conf/WL5004_data.zz \
  --mem \
  --mysqld=--log-output=file

This grammar is set so that consequtive BACKUP + RESTORE is executed in one connection, and the other 9 connections execute a mixture of various DDL statements. Please let me know if a simplified grammar is required to fix this bug.

This is a transient error, and running the same RESTORE again would succeed.