List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:July 14 2009 8:40pm
Subject:Re: Copy 70GB ibdata, etc. and server won't start now
View as plain text  
Why do the dates on the log files differ by almost a month between Old and
New?

On Tue, Jul 14, 2009 at 2:23 PM, Daevid Vincent <daevid@stripped> wrote:

>
>
> > -----Original Message-----
> > From: Gary Smith [mailto:Gary@stripped]
> > Sent: Monday, July 13, 2009 8:54 PM
> > To: Daevid Vincent; mysql@stripped
> > Subject: RE: Copy 70GB ibdata, etc. and server won't start now
> >
> > > InnoDB: Your database may be corrupt or you may have copied
> > the InnoDB
> > > InnoDB: tablespace but not the InnoDB log files. See
> > > InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
> > > InnoDB: for more information.
> > > InnoDB: Error: trying to access page number 2144600306 in space 0,
> > > InnoDB: space name ./ibdata1,
> > > InnoDB: which is outside the tablespace bounds.
> > > InnoDB: Byte offset 0, len 16384, i/o type 10.
> > > InnoDB: If you get this error at mysqld startup, please check that
> > > InnoDB: your my.cnf matches the ibdata files that you have in the
> > > InnoDB: MySQL server.
> > > 090714  1:43:18InnoDB: Assertion failure in thread
> > 3083368144 in file
> > > fil0fil.c line 3959
> > > InnoDB: We intentionally generate a memory trap.
> > > InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
> > > InnoDB: If you get repeated assertion failures or crashes, even
> > > InnoDB: immediately after the mysqld startup, there may be
> > > InnoDB: corruption in the InnoDB tablespace. Please refer to
> > > InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
> > > InnoDB: about forcing recovery.
> >
> > First thing that comes to mind is a scenario that happened
> > some time ago when we migrated data from one server to
> > another in a similar way.  Server one had the innodb file set
> > to 2gb each file (10 files total).  New server was set for
> > 1gb each.  It doesn't shrink files so not much was thought
> > about it at the time but our problem was the innodb table
> > settings had to match to the letter.  We ended up copying the
> > copy file from the old machine to the new machine (they were
> > running the same version so it really wasn't a problem.
>
> The logfiles are the same size so I assume that's configured right?
>
> > I know that you stated you were running Ubuntu, which is
> > great, but what version of the database did it come from and
> > what version of the database is it going to?
>
> +------+
> | Old: |
> +------+
> mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using
> readline
> 5.2
>
> drwx------ 2 mysql mysql       12288 2009-06-26 21:33 agis_core
> -rw-r--r-- 1 mysql mysql           0 2008-11-24 23:34 debian-5.0.flag
> -rw-rw---- 1 mysql mysql 72387395584 2009-07-14 19:18 ibdata1
> -rw-rw---- 1 mysql mysql     5242880 2009-07-14 19:18 ib_logfile0
> -rw-rw---- 1 mysql mysql     5242880 2009-07-14 18:30 ib_logfile1
> drwxr-xr-x 2 mysql mysql        4096 2008-11-24 23:34 mysql
>
>
> +------+
> | New: |
> +------+
> mysql  Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using readline
> 5.2
>
> drwx------ 2 mysql mysql       12288 2009-07-14 00:36 agis_core
> -rw-r--r-- 1 mysql mysql           0 2008-11-24 23:34 debian-5.0.flag
> -rw-rw---- 1 mysql mysql 70038585344 2009-06-17 04:09 ibdata1
> -rw-rw---- 1 mysql mysql     5242880 2009-07-14 01:43 ib_logfile0
> -rw-rw---- 1 mysql mysql     5242880 2009-06-17 03:22 ib_logfile1
> drwxr-xr-x 2 mysql mysql        4096 2009-07-14 00:36 mysql
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
  • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
    • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
      • Re: Copy 70GB ibdata, etc. and server won't start nowJohnny Withers14 Jul
        • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
          • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent15 Jul
            • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
              • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
                • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent15 Jul
                  • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
        • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
      • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
  • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal14 Jul
  • Re: Copy 70GB ibdata, etc. and server won't start nowMarcus Bointon14 Jul
    • Re: Copy 70GB ibdata, etc. and server won't start nowTodd Lyons15 Jul