Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.5, 10.2(EOL), 10.3(EOL)
Description
Observed on buildbot, 64-bit Windows, debug:
CURRENT_TEST: innodb.group_commit_crash_no_optimize_thread
|
…
|
2017-09-17 10:58:59 4604 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1682230
|
Assertion failed: recv_sys->mlog_checkpoint_lsn <= recv_sys->recovered_lsn, file D:\winx64-debug\build\src\storage\innobase\log\log0recv.cc, line 2374
|
…
|
----------SERVER LOG END-------------
|
mysqltest failed but provided no output
|
The result from queries just before the failure was:
|
< snip >
|
a b c d 2
|
a b c d 3
|
a b c d 4
|
a b c d 5
|
a b c d 6
|
a b c d 7
|
a b c d 8
|
a b c d 9
|
a b c d 10
|
SHOW BINLOG EVENTS LIMIT 4,1;
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000001 # Query 1 # use `test`; insert into t1 select * from t2
|
delete from t1;
|
SET binlog_format= mixed;
|
RESET MASTER;
|
START TRANSACTION;
|
insert into t1 select * from t2;
|
call setcrash(2);
|
COMMIT;
|
Got one of the listed errors
|
This logic will be removed altogether when MDEV-14425 introduces a separate file for log checkpoints and file names.
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- is duplicated by
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
MDEV-14425 Change the InnoDB redo log format to reduce write amplification
-
- Closed
-
-
-
- Closed
-
(2 relates to)
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Affects Version/s | 10.3 [ 22126 ] |
| Fix Version/s | 10.3 [ 22126 ] |
| Assignee | Marko Mäkelä [ marko ] | Thirunarayanan B [ thiru ] |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Fix Version/s | 10.4 [ 22408 ] |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Description |
Observed on [buildbot, 64-bit Windows, debug|http://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/5272/steps/test/logs/stdio]:
{noformat} CURRENT_TEST: innodb.group_commit_crash_no_optimize_thread … 2017-09-17 10:58:59 4604 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1682230 Assertion failed: recv_sys->mlog_checkpoint_lsn <= recv_sys->recovered_lsn, file D:\winx64-debug\build\src\storage\innobase\log\log0recv.cc, line 2374 … ----------SERVER LOG END------------- mysqltest failed but provided no output The result from queries just before the failure was: < snip > a b c d 2 a b c d 3 a b c d 4 a b c d 5 a b c d 6 a b c d 7 a b c d 8 a b c d 9 a b c d 10 SHOW BINLOG EVENTS LIMIT 4,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 1 # use `test`; insert into t1 select * from t2 delete from t1; SET binlog_format= mixed; RESET MASTER; START TRANSACTION; insert into t1 select * from t2; call setcrash(2); COMMIT; Got one of the listed errors {noformat} Potentially related to |
Observed on [buildbot, 64-bit Windows, debug|http://buildbot.askmonty.org/buildbot/builders/winx64-debug/builds/5272/steps/test/logs/stdio]:
{noformat} CURRENT_TEST: innodb.group_commit_crash_no_optimize_thread … 2017-09-17 10:58:59 4604 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1682230 Assertion failed: recv_sys->mlog_checkpoint_lsn <= recv_sys->recovered_lsn, file D:\winx64-debug\build\src\storage\innobase\log\log0recv.cc, line 2374 … ----------SERVER LOG END------------- mysqltest failed but provided no output The result from queries just before the failure was: < snip > a b c d 2 a b c d 3 a b c d 4 a b c d 5 a b c d 6 a b c d 7 a b c d 8 a b c d 9 a b c d 10 SHOW BINLOG EVENTS LIMIT 4,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 1 # use `test`; insert into t1 select * from t2 delete from t1; SET binlog_format= mixed; RESET MASTER; START TRANSACTION; insert into t1 select * from t2; call setcrash(2); COMMIT; Got one of the listed errors {noformat} This logic will be removed altogether when |
| Link |
This issue relates to |
| Labels | crash recovery | crash need_rr recovery |
| Link |
This issue is duplicated by |
| Link |
This issue duplicates |
| Link |
This issue is duplicated by |
| Link |
This issue is blocked by |
| Link |
This issue is blocked by |
| Link |
This issue duplicates |
| Link |
This issue is duplicated by |
| Fix Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.5.5 [ 24423 ] | |
| Labels | crash need_rr recovery | crash recovery rr-profile |
| Labels | crash recovery rr-profile | crash recovery rr-profile-analyzed |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.2.33 [ 24307 ] | |
| Fix Version/s | 10.3.24 [ 24306 ] | |
| Fix Version/s | 10.4.14 [ 24305 ] | |
| Fix Version/s | 10.5.5 [ 24423 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue duplicates |
| Link |
This issue duplicates |
| Link |
This issue duplicates |
| Workflow | MariaDB v3 [ 82621 ] | MariaDB v4 [ 152839 ] |
| Zendesk Related Tickets | 159637 |