Skip to content

Instantly share code, notes, and snippets.

@ShekharReddy4
Created August 11, 2018 10:07
Show Gist options
  • Save ShekharReddy4/dc9ccb934d74c7ba15b4bcbb357f4b0b to your computer and use it in GitHub Desktop.
Save ShekharReddy4/dc9ccb934d74c7ba15b4bcbb357f4b0b to your computer and use it in GitHub Desktop.
2018-08-11T10:07:13.955709Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2018-08-11T10:07:13.955750Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-08-11T10:07:13.955771Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-11T10:07:13.955778Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-08-11T10:07:13.959693Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.21-log) starting as process 1728 ...
2018-08-11T10:07:13.979667Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-08-11T10:07:13.980100Z 0 [Note] InnoDB: Uses event mutexes
2018-08-11T10:07:13.980433Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-08-11T10:07:13.980955Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-08-11T10:07:13.981306Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2018-08-11T10:07:13.982179Z 0 [Note] InnoDB: Number of pools: 1
2018-08-11T10:07:13.982626Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-08-11T10:07:13.991783Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2018-08-11T10:07:13.992906Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-08-11T10:07:14.109013Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-08-11T10:07:14.110999Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 199147134621
2018-08-11T10:07:14.115251Z 0 [ERROR] InnoDB: Cannot read first page of '.\winchester\pronto_restriction_rules.ibd' I/O error
2018-08-11T10:07:14.116096Z 0 [ERROR] InnoDB: Cannot read first page in datafile: .\winchester\pronto_restriction_rules.ibd, Space ID:18446744073709551615, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2018-08-11T10:07:14.117660Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:0
2018-08-11T10:07:14.118038Z 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0
2018-08-11T10:07:14.118401Z 0 [Note] InnoDB: Page size:2048. Pages to analyze:0
2018-08-11T10:07:14.118861Z 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0
2018-08-11T10:07:14.119220Z 0 [Note] InnoDB: Page size:4096. Pages to analyze:0
2018-08-11T10:07:14.119593Z 0 [Note] InnoDB: Page size: 4096. Possible space_id count:0
2018-08-11T10:07:14.120079Z 0 [Note] InnoDB: Page size:8192. Pages to analyze:0
2018-08-11T10:07:14.120418Z 0 [Note] InnoDB: Page size: 8192. Possible space_id count:0
2018-08-11T10:07:14.120776Z 0 [Note] InnoDB: Page size:16384. Pages to analyze:0
2018-08-11T10:07:14.121120Z 0 [Note] InnoDB: Page size: 16384. Possible space_id count:0
2018-08-11T10:07:14.121475Z 0 [Note] InnoDB: Page size:32768. Pages to analyze:0
2018-08-11T10:07:14.121819Z 0 [Note] InnoDB: Page size: 32768. Possible space_id count:0
2018-08-11T10:07:14.122278Z 0 [Note] InnoDB: Page size:65536. Pages to analyze:0
2018-08-11T10:07:14.122594Z 0 [Note] InnoDB: Page size: 65536. Possible space_id count:0
2018-08-11T10:07:14.123033Z 0 [ERROR] InnoDB: Datafile '.\winchester\pronto_restriction_rules.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.
2018-08-11T10:07:14.126001Z 0 [ERROR] InnoDB: Cannot read first page of '.\winchester2\pronto_restriction_rules.ibd' I/O error
2018-08-11T10:07:14.126509Z 0 [ERROR] InnoDB: Cannot read first page in datafile: .\winchester2\pronto_restriction_rules.ibd, Space ID:18446744073709551615, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2018-08-11T10:07:14.127867Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:0
2018-08-11T10:07:14.128215Z 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0
2018-08-11T10:07:14.128668Z 0 [Note] InnoDB: Page size:2048. Pages to analyze:0
2018-08-11T10:07:14.129019Z 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0
2018-08-11T10:07:14.129498Z 0 [Note] InnoDB: Page size:4096. Pages to analyze:0
2018-08-11T10:07:14.129902Z 0 [Note] InnoDB: Page size: 4096. Possible space_id count:0
2018-08-11T10:07:14.130317Z 0 [Note] InnoDB: Page size:8192. Pages to analyze:0
2018-08-11T10:07:14.130635Z 0 [Note] InnoDB: Page size: 8192. Possible space_id count:0
2018-08-11T10:07:14.131084Z 0 [Note] InnoDB: Page size:16384. Pages to analyze:0
2018-08-11T10:07:14.131470Z 0 [Note] InnoDB: Page size: 16384. Possible space_id count:0
2018-08-11T10:07:14.132002Z 0 [Note] InnoDB: Page size:32768. Pages to analyze:0
2018-08-11T10:07:14.132375Z 0 [Note] InnoDB: Page size: 32768. Possible space_id count:0
2018-08-11T10:07:14.132850Z 0 [Note] InnoDB: Page size:65536. Pages to analyze:0
2018-08-11T10:07:14.133204Z 0 [Note] InnoDB: Page size: 65536. Possible space_id count:0
2018-08-11T10:07:14.133586Z 0 [ERROR] InnoDB: Datafile '.\winchester2\pronto_restriction_rules.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.
2018-08-11T10:07:14.147266Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 199147391935
2018-08-11T10:07:14.151317Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-08-11T10:07:14.151777Z 0 [Note] InnoDB: Starting crash recovery.
2018-08-11T10:07:14.152144Z 0 [ERROR] InnoDB: Tablespace 8865 was not found at .\winchester\pronto_restriction_rules.ibd.
2018-08-11T10:07:14.152670Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2018-08-11T10:07:14.153224Z 0 [ERROR] InnoDB: Tablespace 9029 was not found at .\winchester2\pronto_restriction_rules.ibd.
2018-08-11T10:07:14.153764Z 0 [ERROR] InnoDB: Cannot continue operation.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment