[MDEV-14511] Use fewer transactions for updating InnoDB persistent statistics - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
Fix Version/s: 10.2.12, 10.3.3
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:

Description

The function dict_stats_save() is problematic. If it ever goes to 'goto err' it will attempt to free an active transaction object, without trying to roll it back first.

Furthermore, the first call to dict_stats_exec_sql() will use a different transaction object, that is, the update of table statistics is not a single atomic transaction with the update of index statistics.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

0001-MDEV-14511-Use-fewer-transactions-for-updating-InnoD.patch
104 kB
2017-12-01 14:53

Issue Links

causes

MDEV-14614 InnoDB: Failing assertion: trx->error_state == DB_SUCCESS or lock wait timeout upon saving statistics

Closed

MDEV-14941 Timeouts on persistent statistics tables caused by MDEV-14511

Closed

relates to

MDEV-13201 Assertion `srv_undo_sources || ...` failed on shutdown during DDL operation

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2017-11-27 12:01

Updated:: 2018-01-22 07:46

Resolved:: 2017-12-06 18:53

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

4.5d

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.