1. 16 Dec, 2019 1 commit
  2. 13 Dec, 2019 4 commits
    • Vicențiu Ciorbaru's avatar
      Update test result post merge · cf0823f9
      Vicențiu Ciorbaru authored
      Columns order is now according to standard SQL
      cf0823f9
    • Vicențiu Ciorbaru's avatar
      Merge branch '10.2' into 10.3 · 193b5ed5
      Vicențiu Ciorbaru authored
      193b5ed5
    • Anel Husakovic's avatar
      PR #1127 and PR #1150 · a134f1eb
      Anel Husakovic authored
      PR#1127: Fix is_check_constraints.result to be compatibile with 10.3
      
      The patch is done according to the original patch for MDEV-14474
      1edd09c325525cba33152 and not one which is merged on server
      d526679e.
      This patch includes:
      - Rename from `is_check_constraint` to `is_check_constraints` to tests
      and results
      - Per review, change the order of fields in IS check_constraints table by adding
      the column `table_name` before `constraint_name`. According to the standard
      2006 there is no `table_name` column.
      - Original patch and one in `10.3` supports embedded server this patch doesn't
      support. After the merge `10.3` will not support also.
      - Don't use patch c8b8b01b61 to change the length of `CHECK_CLAUSE` field
      
      PR#1150: MDEV-18440: Information_schema.check_constraints possible data leak
      
      This patch is extension of PR 1127 and includes:
      - Check for table grants
      - Additional test according to the MDEV specification
      a134f1eb
    • Marko Mäkelä's avatar
      Merge 10.2 into 10.3 · 3466b47b
      Marko Mäkelä authored
      3466b47b
  3. 12 Dec, 2019 4 commits
    • Eugene Kosov's avatar
      MDEV-20950 Reduce size of record offsets · f0aa073f
      Eugene Kosov authored
      offset_t: this is a type which represents one record offset.
      It's unsigned short int.
      
      a lot of functions: replace ulint with offset_t
      
      btr_pcur_restore_position_func(),
      page_validate(),
      row_ins_scan_sec_index_for_duplicate(),
      row_upd_clust_rec_by_insert_inherit_func(),
      row_vers_impl_x_locked_low(),
      trx_undo_prev_version_build():
        allocate record offsets on the stack instead of waiting for rec_get_offsets()
        to allocate it from mem_heap_t. So, reducing  memory allocations.
      
      RECORD_OFFSET, INDEX_OFFSET:
        now it's less convenient to store pointers in offset_t*
        array. One pointer occupies now several offset_t. And those constant are start
        indexes into array to places where to store pointer values
      
      REC_OFFS_HEADER_SIZE: adjusted for the new reality
      
      REC_OFFS_NORMAL_SIZE:
        increase size from 100 to 300 which means less heap allocations.
        And sizeof(offset_t[REC_OFFS_NORMAL_SIZE]) now is 600 bytes which
        is smaller than previous 800 bytes.
      
      REC_OFFS_SEC_INDEX_SIZE: adjusted for the new reality
      
      rem0rec.h, rem0rec.ic, rem0rec.cc:
        various arguments, return values and local variables types were changed to
        fix numerous integer conversions issues.
      
      enum field_type_t:
        offset types concept was introduces which replaces old offset flags stuff.
        Like in earlier version, 2 upper bits are used to store offset type.
        And this enum represents those types.
      
      REC_OFFS_SQL_NULL, REC_OFFS_MASK: removed
      
      get_type(), set_type(), get_value(), combine():
        these are convenience functions to work with offsets and it's types
      
      rec_offs_base()[0]:
        still uses an old scheme with flags REC_OFFS_COMPACT and REC_OFFS_EXTERNAL
      
      rec_offs_base()[i]:
        these have type offset_t now. Two upper bits contains type.
      f0aa073f
    • Marko Mäkelä's avatar
      Merge 10.2 into 10.3 · 0a20e5ab
      Marko Mäkelä authored
      0a20e5ab
    • Alexander Barkov's avatar
      MDEV-20667 Server crash on pop_cursor · e0f9540b
      Alexander Barkov authored
      When backpatching a forward GOTO label, the old code erroneously
      used CURSOR/HANDLER difference between context frames "c" and "a" to tune
      a cpop/hpop command. So the cpop/hpop command later tried to pop
      all cursors/handlers declared between "a" and "c", but those between
      "b" and "c" were not cpushed/hpoped yet during the execution of "GOTO x".
      
      Fixing the code to use the difference between frames "b" and "a" only.
      
      BEGIN     -- a
       ...
      GOTO x;   -- b
       ...
      <<x>>     -- c
       ...
      END       -- d
      e0f9540b
    • Vlad Lesin's avatar
      MDEV-21255: Deadlock of parallel slave and mariabackup (with failed log · beec9c0e
      Vlad Lesin authored
      copy thread)
      
      mariabackup hangs waiting until innodb redo log thread read log till certain
      LSN, and it waits under FTWRL. If there is redo log read error in the thread,
      it is finished, and main thread knows nothing about it, what leads to hanging.
      As it hangs under FTWRL, slave threads on server side can be blocked due
      to MDL lock conflict.
      
      The fix is to finish mariabackup with error message on innodb redo log read
      failure.
      beec9c0e
  4. 11 Dec, 2019 5 commits
  5. 10 Dec, 2019 8 commits
    • Marko Mäkelä's avatar
      Cleanup test sys_vars.innodb_buffer_pool_size_basic · f2d3b2ee
      Marko Mäkelä authored
      When using huge pages, the innodb_buffer_pool_size cannot necessarily
      be restored. Simplify things by restarting the server.
      f2d3b2ee
    • Marko Mäkelä's avatar
      MDEV-14482 - Cache line contention on ut_rnd_interval() · 41e6a154
      Marko Mäkelä authored
      InnoDB RNG maintains global state, causing otherwise unnecessary bus
      traffic. Even worse, this is cross-mutex traffic. That is, different
      mutexes suffer from contention.
      
      Fixed delay of 4 was verified to give best throughput by OLTP update
      index and read-write benchmarks on Intel Broadwell (2/20/40) and
      ARM (1/46/46).
      
      This is a backport of ce047900 from
      MariaDB Server 10.3.
      41e6a154
    • Marko Mäkelä's avatar
      MDEV-21256: Replace the 64-bit LCG with a 32-bit Galois LFSR · b1f2d3a8
      Marko Mäkelä authored
      We should not need anywhere near 32 bits of entropy, so we might
      just limit ourselves to a 32-bit random number generator.
      
      Also, it might be cheaper to use exclusive-or, bit shifting and
      conditional jumps, instead of multiplication and addition.
      
      We use relaxed atomic operations on the global random number generator
      state in order in an attempt to silence any warnings about race conditions.
      There is an obvious race condition between the load and store in
      ut_rnd_gen(), but we do not think that it matters much that the
      state of the random number generator could 'stutter'.
      
      This change seems makes the 'uncompress_ops' nondeterministic
      in innodb_zip.cmp_per_index after the restart. It looks like
      there is an inherent race condition in the test, because the
      table could be opened for InnoDB statistics recalculation
      already before innodb_cmp_per_index_enabled was set. We might
      end up having uncompress_ops anywhere between 0 and 9, or perhaps
      even more. Let us remove that part of the test.
      b1f2d3a8
    • Marko Mäkelä's avatar
      MDEV-21256: Simplify ut_rnd_interval() · d146e3dc
      Marko Mäkelä authored
      ut_rnd_interval(): Remove the first parameter, which was mostly
      passed as 0. Implement as a simple wrapper around ut_rnd_gen().
      Trivially return 0 if the size of the interval is smaller than 2.
      
      ut_rnd_ulint_counter, ut_rnd_gen_next_ulint(), ut_rnd_gen_ulint(): Remove.
      d146e3dc
    • Marko Mäkelä's avatar
      MDEV-21256: Reduce the use of ut_rnd_gen_next_ulint() · 51fc8ab7
      Marko Mäkelä authored
      ut_rnd_set_seed(): Unused function; remove.
      
      ut_rnd_gen(): Renamed from page_cur_lcg_prng().
      
      ut_rnd_current: The internal state of ut_rnd_gen().
      
      page_cur_open_on_rnd_user_rec(): Replace linear search with
      page_rec_get_nth().
      51fc8ab7
    • Eugene Kosov's avatar
      MDEV-21223 innodb_fts.sync_ddl fails in buildbot, server crashed in que_thr_step · 4c0854f2
      Eugene Kosov authored
      FreeState(): replace pointer to freed memory with NULL. This actually fixes a crash
      which is use-after-free as reported by ASAN
      
      DbugParse(): unconditionally lock mutex because we're touching shared init_settings.keywords
      4c0854f2
    • Oleksandr Byelkin's avatar
      MDEV-18460: Server crashed in strmake / tdc_create_key / THD::create_tmp_table_def_key · af650c76
      Oleksandr Byelkin authored
      When there is a WITH clause we postpone check for tables without
      database for later stages when tables in WITH will be defined.
      But we should not try to open such tables as temporary tables because
      temporary tables always belong to a some database.
      af650c76
    • Varun Gupta's avatar
      MDEV-20900: IN predicate to IN subquery conversion causes performance regression · 246e2ae1
      Varun Gupta authored
      Disable the IN predicate to IN subquery conversion when the types on the left and
      right hand side of the IN predicate are not of comparable type.
      246e2ae1
  6. 09 Dec, 2019 3 commits
    • Marko Mäkelä's avatar
    • Marko Mäkelä's avatar
      MDEV-21254 Remove unused keywords from the InnoDB SQL parser · 292015d4
      Marko Mäkelä authored
      The InnoDB internal SQL parser, which is used for updating the InnoDB
      data dictionary tables (to be removed in MDEV-11655), persistent
      statistics (to be refactored in MDEV-15020) and fulltext indexes,
      implements some unused keywords and built-in functions:
      
      OUT BINARY BLOB INTEGER FLOAT SUM DISTINCT READ
      COMPACT BLOCK_SIZE
      TO_CHAR TO_NUMBER BINARY_TO_NUMBER REPLSTR SYSDATE PRINTF ASSERT
      RND RND_STR ROW_PRINTF UNSIGNED
      
      Also, procedures are never declared with parameters. Only one top-level
      procedure is declared and invoked at a time, and parameters are being
      passed via pars_info_t.
      292015d4
    • Jan Lindström's avatar
      MDEV-21189: Dropping partition with 'wsrep_OSU_method=RSU' and 'SESSION... · 59e14b96
      Jan Lindström authored
      MDEV-21189: Dropping partition with 'wsrep_OSU_method=RSU' and 'SESSION sql_log_bin = 0' cases the galera node to hang
      
      Found two bugs
      
      (1) have_committing_connections was missing mutex unlock on one
      exit case. As this function is called on a loop it caused mutex
      lock when we already owned the mutex. This could cause hang.
      
      (2) wsrep_RSU_begin did set up error code when partition to
      be dropped could not be MDL-locked because of concurrent
      operations but wrong error code was propagated to upper layer
      causing error to be ignored. This could have also caused
      the hang.
      59e14b96
  7. 08 Dec, 2019 3 commits
  8. 05 Dec, 2019 5 commits
  9. 04 Dec, 2019 7 commits