1. 25 Apr, 2021 2 commits
  2. 24 Apr, 2021 4 commits
    • Igor Babaev's avatar
      This commit adds the same call of st_select_lex::set_unique_exclude() that · 2c9bf0ae
      Igor Babaev authored
      complemented the fix for MDEV-24823 in 10.2. As it is the only call of
      this function in 10.3 the commit also has added the code of the function.
      2c9bf0ae
    • Marko Mäkelä's avatar
      Merge 10.2 into 10.3 · c425d93b
      Marko Mäkelä authored
      except commit 1288dfff
      c425d93b
    • Marko Mäkelä's avatar
      MDEV-23026/MDEV-25474 fixup: Assertion ib_table->stat_initialized · 14a18d7d
      Marko Mäkelä authored
      It is possible that an object that was originally created by
      open_purge_table() will remain cached and reused for SQL execution.
      Our previous fix wrongly assumed that ha_innobase::open() would
      always be called before SQL execution starts. Therefore, we must
      invoke dict_stats_init() in ha_innobase::info_low() instead of
      only doing it in ha_innobase::open().
      
      Note: Concurrent execution of dict_stats_init() on the same table
      is possible, but it also was possible between two calls to
      ha_innobase::open(), with no ill effects observed.
      
      This should fix the assertion failure on stat_initialized.
      A possibly easy way to reproduce it would have been
      to run the server with innodb_force_recovery=2 (disable the purge of
      history), update a table so that an indexed virtual column will be
      affected, and finally restart the server normally (purge enabled),
      to observe a crash when the table is accessed from SQL.
      
      The problem was first observed and this fix verified by
      Elena Stepanova. Also Thirunarayanan Balathandayuthapani
      repeated the problem.
      14a18d7d
    • Marko Mäkelä's avatar
      MDEV-25459 MVCC read from index on CHAR or VARCHAR wrongly omits rows · 25ed665a
      Marko Mäkelä authored
      row_sel_sec_rec_is_for_clust_rec(): If the field in the
      clustered index record stored off page, always fetch it,
      also when the secondary index field has been built on the
      entire column. This was broken ever since the InnoDB Plugin
      for MySQL Server 5.1 introduced ROW_FORMAT=DYNAMIC and
      ROW_FORMAT=COMPRESSED for InnoDB tables. That code was first
      introduced in this tree in
      commit 3945d5e5.
      
      For the original ROW_FORMAT=REDUNDANT and the MySQL 5.0.3
      ROW_FORMAT=COMPRESSED, there was no problem, because for
      those tables we always stored at least a 768-byte prefix of
      each column in the clustered index record.
      
      row_sel_sec_rec_is_for_blob(): Allow prefix_len==0 for matching
      the full column.
      25ed665a
  3. 23 Apr, 2021 5 commits
    • Igor Babaev's avatar
      1288dfff
    • Aleksey Midenkov's avatar
      MDEV-25091 CREATE TABLE: field references qualified by a wrong table name succeed · 42f8548f
      Aleksey Midenkov authored
      Before FRM is written walk vcol expressions through
      check_table_name_processor() and check if field items match (db,
      table_name) qualifier.
      
      We cannot do this in check_vcol_func_processor() as there is already
      no table name qualifiers in expressions of written and loaded FRM.
      42f8548f
    • Aleksey Midenkov's avatar
      MDEV-23455 Hangs + Sig11 in unknown location(s) due to single complex FK query · 4649ba74
      Aleksey Midenkov authored
      Buffer overflow in ib_push_warning() fixed by using vsnprintf().
      
      InnoDB parser was obsoleted by MDEV-16417.
      
      Thanks to Nikita Malyavin for review and suggestion.
      4649ba74
    • Sergei Golubchik's avatar
      remove EXCEPTIONS-CLIENT · 018d7440
      Sergei Golubchik authored
      It's Oracle libmysqlclient license exception, we no longer include,
      build or ship libmysqlclient
      018d7440
    • Igor Babaev's avatar
      MDEV-24823 Crash with invalid multi-table update of view in 2nd execution of SP · e3a25793
      Igor Babaev authored
      Before this patch mergeable derived tables / view used in a multi-table
      update / delete were merged before the preparation stage.
      When the merge of a derived table / view is performed the on expression
      attached to it is fixed and ANDed with the where condition of the select S
      containing this derived table / view. It happens after the specification of
      the derived table / view has been merged into S. If the ON expression refers
      to a non existing field an error is reported and some other mergeable derived
      tables / views remain unmerged. It's not a problem if the multi-table
      update / delete statement is standalone. Yet if it is used in a stored
      procedure the select with incompletely merged derived tables / views may
      cause a problem for the second call of the procedure. This does not happen
      for select queries using derived tables / views, because in this case their
      specifications are merged after the preparation stage at which all ON
      expressions are fixed.
      This patch makes sure that merging of the derived tables / views used in a
      multi-table update / delete statement is performed after the preparation
      stage.
      
      Approved by Oleksandr Byelkin <sanja@mariadb.com>
      e3a25793
  4. 22 Apr, 2021 13 commits
    • Igor Babaev's avatar
      MDEV-24823 Crash with invalid multi-table update of view in 2nd execution of SP · b3b5d57e
      Igor Babaev authored
      Before this patch mergeable derived tables / view used in a multi-table
      update / delete were merged before the preparation stage.
      When the merge of a derived table / view is performed the on expression
      attached to it is fixed and ANDed with the where condition of the select S
      containing this derived table / view. It happens after the specification of
      the derived table / view has been merged into S. If the ON expression refers
      to a non existing field an error is reported and some other mergeable derived
      tables / views remain unmerged. It's not a problem if the multi-table
      update / delete statement is standalone. Yet if it is used in a stored
      procedure the select with incompletely merged derived tables / views may
      cause a problem for the second call of the procedure. This does not happen
      for select queries using derived tables / views, because in this case their
      specifications are merged after the preparation stage at which all ON
      expressions are fixed.
      This patch makes sure that merging of the derived tables / views used in a
      multi-table update / delete statement is performed after the preparation
      stage.
      
      Approved by Oleksandr Byelkin <sanja@mariadb.com>
      b3b5d57e
    • Sergei Golubchik's avatar
    • Sergei Golubchik's avatar
      MYSQL_MAINTAINER_MODE fixes · a40f29ab
      Sergei Golubchik authored
      * MSVC check was lost in a bad merge
      * add a comment
      * move AIX check where it belongs and where it would still
        allow -Werror, if desired
      a40f29ab
    • Vladislav Vaintroub's avatar
      5c5d24c7
    • Vladislav Vaintroub's avatar
      MDEV-25456 MariaBackup logs "[ERROR]" on Invalid log block checksum · 78bb9533
      Vladislav Vaintroub authored
      Fix is to changed message to be [WARNING] for backup
      78bb9533
    • Vladislav Vaintroub's avatar
      Update timezone data on Windows · f6542a7a
      Vladislav Vaintroub authored
      There is new Yukon Standard time Windows timezone.
      
      Also fix the powershell script that generates the Windows locale mapping,
      tell powershell to use TLSv1.2 to access the github (on some reason it is
      TLS1.1 that powershell is using by default, and it does no work)
      f6542a7a
    • Marko Mäkelä's avatar
      Revert "MDEV-24589 DROP TABLE is not crash-safe" · 1636db54
      Marko Mäkelä authored
      This reverts commit e731a283.
      
      A crash occurred during the test stress.ddl_innodb when
      fil_delete_tablespace() for DROP TABLE was waiting in
      fil_check_pending_operations() and a purge thread for handling
      an earlier DROP INDEX was attempting to load the index root page
      in btr_free_if_exists() and btr_free_root_check(). The function
      buf_page_get_gen() would write out several times
      "trying to read...being-dropped tablespace"
      before giving up and committing suicide.
      
      It turns out that during any page access in btr_free_if_exists(),
      fil_space_t::set_stopping() could have been invoked by
      fil_check_pending_operations(), as part of dropping the tablespace.
      Preventing this race condition would require extensive changes
      to the allocation code or some locking mechanism that would ensure
      that we only set the flag if btr_free_if_exists() is not in progress.
      
      Either way, that could be a too risky change in a GA release.
      Because MDEV-24589 is not strictly necessary in the 10.5 release
      series and it only is a requirement for MDEV-25180 in a later
      major release, we will revert the change from 10.5.
      1636db54
    • sachin's avatar
      MDEV-22953 main.flush_read_lock failed in buildbot with XAER_NOTA: Unknown XID · 21973d0d
      sachin authored
      Issue:- Since there is no waiting for the actual disconnection of the con_tmp
      (which does XA prepare of test1), We can have a issue when test1 is not
      prepared and we are calling rollback on test1 , giving XAER_NOTA: Unknown XID
      error
      
      Solution:- Wait for the complete disconnection of con_tmp
      21973d0d
    • Marko Mäkelä's avatar
      Merge 10.4 into 10.5 · df33b719
      Marko Mäkelä authored
      df33b719
    • Marko Mäkelä's avatar
      MDEV-25483: Shutdown crash during innodb.innodb_buffer_pool_resize_temporary · cbbca7ed
      Marko Mäkelä authored
      buf_resize_callback(): Correct an invalid assertion, and enable
      the assertion in debug builds only.
      
      Between buf_resize_start() and buf_resize_shutdown(),
      srv_shutdown_state must be less than SRV_SHUTDOWN_CLEANUP.
      
      The incorrect assertion had been introduced in
      commit 5e62b6a5 (MDEV-16264).
      As a result, the server could crash if shutdown was initiated
      concurrently with initiating a change of innodb_buffer_pool_size.
      cbbca7ed
    • Marko Mäkelä's avatar
      Merge 10.3 into 10.4 · ee455e6f
      Marko Mäkelä authored
      ee455e6f
    • Marko Mäkelä's avatar
      0d267f7c
    • Marko Mäkelä's avatar
      Merge 10.2 into 10.3 · 6f271302
      Marko Mäkelä authored
      6f271302
  5. 21 Apr, 2021 12 commits
  6. 20 Apr, 2021 4 commits