Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL)
-
Windows
-
5.5.59, 10.3.6-1
Description
https://internal.askmonty.org/buildbot/builders/win32-debug/builds/3945/steps/test/logs/stdio
innodb.doublewrite 'innodb_plugin' w2 [ fail ]
|
Test ended at 2017-05-20 15:15:56
|
|
CURRENT_TEST: innodb.doublewrite
|
mysqltest: At line 220: query 'set global innodb_fil_make_page_dirty_debug = @space_id' failed: 2013: Lost connection to MySQL server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
f1 f2
|
1 ############
|
2 ++++++++++++
|
3 ////////////
|
4 ------------
|
5 ............
|
# Test End
|
# ---------------------------------------------------------------
|
# Test Begin: Test if recovery works if 2nd page of user
|
# tablespace is corrupted.
|
select space from information_schema.innodb_sys_tables
|
where name = 'test/t1' into @space_id;
|
# Ensure that dirty pages of table t1 is flushed.
|
flush tables t1 for export;
|
unlock tables;
|
begin;
|
insert into t1 values (6, repeat('%', 400));
|
# Make the 2nd page dirty for table t1
|
set global innodb_saved_page_number_debug = 1;
|
set global innodb_fil_make_page_dirty_debug = @space_id;
|
|
More results from queries before failure can be found in D:\win32-debug\build\mysql-test\var\2\log\doublewrite.log
|
|
|
Server [mysqld.1 - pid: 5132, winpid: 5132, exit: 768] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
----------SERVER LOG END-------------
|
Attachments
Issue Links
- is duplicated by
-
MDEV-15325 Incomplete validation of missing tablespace during recovery
-
- Closed
-
-
MDEV-16273 innodb.alter_kill fails in buildbot with Unknown storage engine 'InnoDB'
-
- Closed
-
- relates to
-
MDEV-11688 fil_crypt_threads_end() tries to create threads after aborted InnoDB startup
-
- Closed
-
-
MDEV-11799 InnoDB can abort if the doublewrite buffer contains a bad and a good copy
-
- Closed
-
-
MDEV-12600 crash during install_db with innodb_page_size=32K and ibdata1=3M;
-
- Closed
-
-
MDEV-13143 Server crashes in srv_init_abort_low() when started with inaccessible tmpdir
-
- Closed
-
-
MDEV-14049 InnoDB fails to refuse startup when a file is not found in crash recovery
-
- Closed
-
-
MDEV-10217 innodb.innodb_bug59641 fails sporadically in buildbot: InnoDB: Failing assertion: current_rec != insert_rec in file page0cur.c line 1052
-
- Closed
-
-
MDEV-11125 Introduce a reduced doublewrite mode, handling error detection only
-
- Closed
-
-
MDEV-16763 SIGNAL 6 ERROR
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Assignee | Marko Mäkelä [ marko ] |
Environment | Windows | Windows, Linux |
Labels | sporaric |
Attachment | mysqld.1.err [ 43951 ] |
Attachment | ibdata1.zip [ 43952 ] |
Attachment | ibdata1_2.zip [ 43953 ] |
Attachment | mysqld.1.err [ 43954 ] |
Attachment | case3.zip [ 43955 ] |
Attachment | case3.zip [ 43955 ] |
Attachment | case3_2.zip [ 43956 ] |
Attachment | case1.zip [ 43957 ] |
Attachment | case1_16k.zip [ 43960 ] |
Attachment | case2_8k.zip [ 43961 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Attachment | doublewrite.test [ 43982 ] |
Link |
This issue relates to |
Attachment | var.zip [ 44012 ] |
Environment | Windows, Linux | Windows |
Component/s | Storage Engine - InnoDB [ 10129 ] |
Summary | innodb.doublewrite failed in buildbot with Lost connection | InnoDB plugin occasionally skips the doublewrite buffer write for some pages |
Assignee | Marko Mäkelä [ marko ] | Jan Lindström [ jplindst ] |
Link |
This issue relates to |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Link |
This issue relates to |
Affects Version/s | 10.2 [ 14601 ] |
Fix Version/s | 5.5 [ 15800 ] | |
Fix Version/s | 10.0 [ 16000 ] |
Link |
This issue relates to |
Attachment | doublewrite.zip [ 44327 ] |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] |
Sprint | 5.5.59 [ 221 ] |
Link |
This issue is duplicated by |
Assignee | Jan Lindström [ jplindst ] | Thirunarayanan B [ thiru ] |
Summary | InnoDB plugin occasionally skips the doublewrite buffer write for some pages | InnoDB occasionally skips the doublewrite buffer write for some pages |
Sprint | 5.5.59 [ 221 ] | 5.5.59, 10.3.6 [ 221, 237 ] |
Link |
This issue is duplicated by |
Link |
This issue relates to |
Fix Version/s | 10.4 [ 22408 ] |
Fix Version/s | 5.5 [ 15800 ] |
Fix Version/s | 10.0 [ 16000 ] |
Fix Version/s | 10.1 [ 16100 ] |
Labels | sporaric | need_rr sporaric |
issue.field.resolutiondate | 2021-04-27 16:40:44.0 | 2021-04-27 16:40:44.785 |
Fix Version/s | 10.3.6 [ 23003 ] | |
Fix Version/s | 10.2.15 [ 23006 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | Confirmed [ 10101 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 80944 ] | MariaDB v4 [ 152220 ] |