MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:July 27 2004 7:35am
Subject:Re: Innodb assertion failure after binary backup-restore
View as plain text  
Hi!

That method will not work. InnoDB must be quiet long enough so that it has
time to flush all the contents of the buffer pool to the data files.

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/


----- Original Message ----- 
From: ""Sp.Raja"" <spraja@stripped>
Newsgroups: mailing.database.myodbc
Sent: Friday, July 23, 2004 4:43 PM
Subject: Innodb assertion failure after binary backup-restore


> Hi List,
>
> We are using 4.0.15a MySQL. We need to backup database at times and we
empl=
> oy the following method
>
> FLUSH TABLES WITH READ LOCK
> tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1
> UNLOCK TABLES
>
> and restore is reverse. We cannot overwrite all databases, some of them
nee=
> ds to be unchanged across backup and restores called persistent databases
(=
> just 1% of full data) so we employ the following
>
> mysqldump on persistent databases
> stop mysql
> cd /usr/local/mysql/data
> tar -zxf backup.tar.gz
> start mysql
> destroy persistent databases
> run mysqldump sql files to get database back to shape
>
> This method works fine expect for the case where backup is taken
immediatel=
> y after table creation and population.
> When we start the mysql after restore of this backup. It comes up, but
mysq=
> l connections to it asking for persistent database destroy hangs. When I
do=
>  a processlist I get
>
+----+------+-----------+----+---------+------+-----------------+----------=
> ----------------+
> | Id | User | Host      | db | Command | Time | State           | Info
=
>                 |
>
+----+------+-----------+----+---------+------+-----------------+----------=
> ----------------+
> | 1  | root | localhost |    | Query   | 55   | Waiting on cond | drop
data=
> base persistent1|
> | 4  | root | localhost |    | Query   | 0    |                 | show
proc=
> esslist         |
>
+----+------+-----------+----+---------+------+-----------------+----------=
> ----------------+
>
> When I open up another mysql client and query some of the tables, they
also=
>  hang and processlist at that time shows
>
+----+------+-----------+---------+---------+------+-----------------+-----=
> ------------------------+
> | Id | User | Host      | db      | Command | Time | State           |
Info=
>                         |
>
+----+------+-----------+---------+---------+------+-----------------+-----=
> ------------------------+
> | 1  | root | localhost |         | Query   | 171  | Waiting on cond |
drop=
>  database persistent1   |
> | 6  | root | localhost |  data   | Query   | 59   | Opening tables  |
sele=
> ct * from my_data       |
> | 11 | root | localhost |         | Query   | 0    |                 |
show=
>  processlist            |
>
+----+------+-----------+---------+---------+------+-----------------+-----=
> ------------------------+
>
> After some time mysql.err reports
> 040721 14:43:49  InnoDB: Assertion failure in thread 88 in file fsp0fsp.c
l=
> ine 2950
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to mysql@stripped
> InnoDB: Thread 88 stopped in file fsp0fsp.c line 2950
> InnoDB: Thread 30 stopped in file os0sync.c line 509
> InnoDB: Thread 96 stopped in file sync0sync.ic line 109
> InnoDB: Thread 29 stopped in file sync0arr.c line 126
>
> Please help me in resolving the issue by giving directions on how to
procee=
> d.
> your help is much appreciated.
>
> Thanks for your time,
> Sp.Raja
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>

Thread
Innodb assertion failure after binary backup-restoreSp.Raja23 Jul
  • Re: Innodb assertion failure after binary backup-restoreSp.Raja23 Jul
    • Re: Innodb assertion failure after binary backup-restoreSp.Raja26 Jul
Re: Innodb assertion failure after binary backup-restoreHeikki Tuuri27 Jul
  • Re: Innodb assertion failure after binary backup-restoreSp.Raja27 Jul
Re: Innodb assertion failure after binary backup-restoreHeikki Tuuri27 Jul
  • Re: Innodb assertion failure after binary backup-restoreSp.Raja27 Jul
    • RE: Innodb assertion failure after binary backup-restoreMark Steele28 Jul
Re: Innodb assertion failure after binary backup-restoreHarald Fuchs27 Jul
Re: Innodb assertion failure after binary backup-restoreHeikki Tuuri29 Jul