InnoDB: Doing recovery: scanned up to log sequence number  ( %)

InnoDB: Doing recovery: scanned up to log sequence number  ( %)

 ::  InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percents:  ::  InnoDB: Error: space id and page n:o stored in the page

InnoDB: read in are :, should be :!

InnoDB: Database page corruption on disk or a failed

InnoDB: file read of page .

InnoDB: You may have to recover from a backup.

 ::  InnoDB: Page dump in ascii and hex ( bytes):

mysql> select * from information_schema.INNODB_SYS_DATAFILES where space=;

+-------+---------------+

| SPACE | PATH          |

+-------+---------------+

|    | .\test\t2.ibd |

+-------+---------------+

$ sudo ./test /u01/mysql/data/test/t1.ibd

spaceid: , file:/u01/mysql/data/test/t1.ibd 

#include "stdlib.h"

#include "stdio.h"

#ifdef _WIN64

typedef unsigned __int64     ulint;

#else

typedef unsigned long int     ulint;

#endif /* _WIN64 */

typedef unsigned char byte;

ulint

mach_read_from_4(

     byte*     b)     /*!< in: pointer to four bytes */

{

     return( ((ulint)(b[]) << )

          | ((ulint)(b[]) << )

          | ((ulint)(b[]) << )

          | (ulint)(b[])

          );

}

void main(int argc,char *argv[])

{

        FILE *fp;

        byte ret[];

        int  offset;

        ulint spaceid;

        if ((fp=fopen(argv[],"r"))==NULL)

        {

                printf("cannot open this file\n");

                exit();

        }

        offset=;

        if (fseek(fp,offset,)!=)

        {

                printf("cannot move pointer there.\n");

                exit();

        }

        fread(ret,sizeof(byte),,fp);

        spaceid = mach_read_from_4(ret);

        printf("spaceid:%lu , file:%s\n",spaceid,argv[]);

        fclose(fp);

}