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
-
-
- Closed
-
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
MDEV-11125 Introduce a reduced doublewrite mode, handling error detection only
-
- Closed
-
-
-
- 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 ] |