maria:bb-10.4-release-mdev30218

Last commit made on 2023-02-02
Get this branch:
git clone -b bb-10.4-release-mdev30218 https://git.launchpad.net/maria

Branch merges

Branch information

Name:
bb-10.4-release-mdev30218
Repository:
lp:maria

Recent commits

8f08993... by Sergey Petrunia

MDEV-30218: Incorrect optimization for rowid_filtering, correction

Final corrections:
- Remove incorrect tracing, "rowid_filter_skipped"
- Put the worst_seeks sanity check back

3137f69... by Igor Babaev

MDEV-30218 Incorrect optimization for rowid_filtering

Correction over the last patch for this MDEV.

c8f2e9a... by Oleksandr "Sanja" Byelkin

Fix number of rows passing in case of EQ_REF

9c6fcdb... by Sergey Petrunia

MDEV-30218: Incorrect optimization for rowid_filtering, correction

Enable use of Rowid Filter optimization with eq_ref access.
Use the following assumptions:
- Assume index-only access cost is 50% of non-index-only access cost.
- Take into account that "Eq_ref access cache" reduces the number of
  lookups eq_ref access will make.
  = This means the number of Rowid Filter checks is reduced also
  = Eq_ref access cost is computed using that assumption (see
    prev_record_reads() call), so we should use it in all cost '
    computations.

a977054... by Oleksandr "Sanja" Byelkin

Merge branch '10.3' into 10.4

c73985f... by Andrei <email address hidden>

MDEV-30010 post-push: fixing test results.

765291d... by Daniel Black

CREDITS: re-instate Tencent Cloud

This was an accidential deletion looking at an outdated list.

284810b... by Yuchen Pei

MDEV-30370 Fixing spider hang when server aborts

This is Kentoku's patch for MDEV-22979 (e6e41f04f4e + 22a0097727f),
which fixes 30370.

It changes the wait to a timed wait for the first sts thread, which
waits on server start to execute the init queries for spider. It also
flips the flag init_command to false when the sts thread is being
freed. With these changes the sts thread can check the flag regularly
and abort the init_queries when it finds out the init_command is
false. This avoids the deadlock that causes the problem in MDEV-30370.

It also fixes MDEV-22979 for 10.4, but not 10.5. I have not tested
higher versions for MDEV-22979.

A test has also been done on MDEV-29904 to avoid regression, given
MDEV-27233 is a similar problem and its patch caused the
regression. The test passes for 10.4-11.0.

However, this adhoc test only works consistently when placed in the
main testsuite. We should not place spider tests in the main suite, so
we do not include it in this commit. A patch for MDEV-27912 should fix
this problem and allow a proper test for MDEV-29904. See comments in
the jira ticket MDEV-30370/29904 for the adhoc testcase used for this
commit.

2279ddd... by Vladislav Vaintroub

MDEV-30457 Windows, signtool error "No file digest algorithm specified."

Add /fd parameter. It is now mandatory for the recent versions of
signtool

7fe9324... by Andrei <email address hidden>

MDEV-30323 Some DDLs like ANALYZE can complete on parallel slave out of order

ANALYZE was observed to race over a preceding in binlog order DML
in updating the binlog and slave gtid states.

Tagging ANALYZE and other admin class commands in binlog by the fixes
of MDEV-17515 left a flaw allowing such race leading to
the gtid mode out-of-order error.
This is fixed now to observe by ADMIN commands the ordered access to
the slave gtid status variables and binlog.