Home - Waterfall Grid T-Grid Console Builders Recent Builds Buildslaves Changesources - JSON API - About

Console View


Categories: connectors experimental galera main
Legend:   Passed Failed Warnings Failed Again Running Exception Offline No data

connectors experimental galera main
ffff702623e5...
ffff702623e5a9d298161f5ea2e72109e301c384
Sergei Golubchik
C/C 3.1.27
fafa10dbc4f5...
fafa10dbc4f59b90f08fa67363e3c96aa2e34db3
Sergei Golubchik
update HeidiSQL to 12.10

also, switch to https
fa8081a11022...
fa8081a11022de480c2c04d401f46a62f134fa09
Vladislav Vaintroub
MDEV-14091 Support password protected SSL key in server.

Add ssl_passphrase_command server parameter, inspired by Postgres
parameter with the same name.

Based on a patch by Hartmut Holzgraefe
e69f8cae1a15...
e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4
Sergei Golubchik
Merge branch '10.6' into 10.11
d5e7bce14be5...
d5e7bce14be521e59224d200434655d5edf34292
Marko Mäkelä
MDEV-35966 galera.galera_as_master crashes in debug builds

innobase_commit(): When Galera is used with SET SQL_LOG_BIN=OFF,
some debug assertions that had been added in
commit ddd7d5d8e34c3edd7ebf4790eec2c4e4d9141e94 (MDEV-24035)
would fail. Let us relax those assertions for Galera transactions,
to allow an implicit commit after an internally executed XA PREPARE.

Note that trx_undo_report_row_operation() only allows undo log records
to be added to ACTIVE transactions (not after XA PREPARE). Hence, this
relaxation should be safe with respect to writes.
d0c2a007ee99...
d0c2a007ee99d299042e3729bbb08b49d9eb6ba0
Sergei Golubchik
C/C 3.3.14
cce642c3508b...
cce642c3508bde104a318d2fa124c8d939ba04d1
Sergei Petrunia
MDEV-30877: Output cardinality for derived table ignores GROUP BY

(Variant 3) (commit in 11.4)
When a derived table has a GROUP BY clause:

  SELECT ...
    FROM  (SELECT ... GROUP BY col1, col2) AS tbl

The optimizer would use inner join's output cardinality as an estimate
of derived table size, ignoring the fact that GROUP BY operation would
produce much fewer groups.

Add code to produce tighter bounds:
- The GROUP BY list is split into per-table lists. If GROUP BY list has
  expressions that refer to multiple tables, we fall back to join output
  cardinality.
- For each table, the first cardinality estimate is join_tab->read_records.
- Then, we try to get a tighter bound by using index statistics.
- If indexes do not cover all GROUP BY columns, we try to use per-column
  EITS statistics.
  • kvm-tarbake-jaunty-x86: make dist failed -  stdiokernel
caec03cb79ab...
caec03cb79ab5b39b9cf7bce784a4f8865234ebd
Sergei Golubchik
MDEV-35907 debian-start script fails when using non-standard socket path

consistently use --defaults-extra-file for all command-line tools
c95c1df6030d...
c95c1df6030df13ad4e78a7396e04dbdc1439687
Yuchen Pei
MDEV-22168 Supporting multiple engines with table partitioning

Patch by holyfoot bb-11.2-mdev-22168-hf
b8d686b24e9e2fb61cf24a4842e18159187b1bbc applied with trivial
mtr --record changes
c1933b46e4ca...
c1933b46e4ca2722951fa6772a6964582da14826
Sergei Golubchik
MDEV-33285 make the test deterministic

need to clear old signals
before waiting for new signals with the same name
a89e734fcb43...
a89e734fcb43bf04bf82c36f49eff490c110d209
Sergei Golubchik
ColumnStore 6.4.10-1
a61f0c392c83...
a61f0c392c8320ce34791d63fe03ec34f20138bb
Monty
Fixed costs in JOIN_TAB::estimate_scan_time() and HEAP

Estimate_scan_time() calculates the cost of scanning a derivied table.
The old code did not take into account that the temporary table heap table
may be converted to Aria.

Things fixed:
- Added checking if the temporary tables data will fit in the heap.
  If not, then calculate the cost based on the designated internal
  temporary table engine (Aria).
- Removed MY_MAX(records, 1000) and instead trust the optimizer's
  estimate of records. This reduces the cost of temporary tables a bit
  for small tables, which caused a few changes in mtr results.
- Fixed cost calculation for HEAP.
  - HEAP costs->row_next_find_cost was not set. This does not affect old
    costs calculation as this cost slot was not used anywhere.
    Now HEAP cost->row_next_find_cost is set, which allowed me to remove
    some duplicated computation in ha_heap::scan_time()
9a0ac0cdf781...
9a0ac0cdf7814241dbc8f3d95fa045f9fa6358e6
Sergei Golubchik
MDEV-35911 Assertion `marked_for_write_or_computed()' failed in bool Field_new_decimal::store_value(const my_decimal*, int*)

disable the assert.

also, use the same check for check_that_all_fields_are_given_values()
as it's used in not_null_fields_have_null_values() - to avoid
issuing the same warning twice.
92a6789638d2...
92a6789638d27f10044be9fb2d57b63f8bbf5e6e
Sergei Golubchik
C/C 3.4.4
91de54e098b1...
91de54e098b179f033deb1ee61fc3d7d5997f588
Sergei Petrunia
Remove redundant if-statement in Index_prefix_calc::get_avg_frequency

the code went like this:

  for ( ... ; i < prefixes ; ...)
  {
      if (i < prefixes)
      {
        ...
8505dc7a2d02...
8505dc7a2d02166b44763bc11ad96aa1530daae8
Dave Gosselin
MDEV-35510 ASAN build crashes during bootstrap

Avoid ASAN failure by collecting statistics from Result objects
before cleaning them up.  In related single-table cases, statistics
are maintained directly by the single-table update and delete
functions.
7eded23be659...
7eded23be6597b4c485e8cad1538f2ae14541f91
Sergei Golubchik
ColumnStore 5.6.9-1
7d657fda64ce...
7d657fda64ce1a24f9120b81946b2e390b6364af
Sergei Golubchik
Merge branch '10.11 into 11.4
747866af70ba...
747866af70ba48c57f173b912432349efa17cf34
Sergei Petrunia
MDEV-30877: Output cardinality for derived table ignores GROUP BY

(Variant 3)
When a derived table has a GROUP BY clause:

  SELECT ...
    FROM  (SELECT ... GROUP BY col1, col2) AS tbl

The optimizer would use inner join's output cardinality as an estimate
of derived table size, ignoring the fact that GROUP BY operation would
produce much fewer groups.

Add code to produce tighter bounds:
- The GROUP BY list is split into per-table lists. If GROUP BY list has
  expressions that refer to multiple tables, we fall back to join output
  cardinality.
- For each table, the first cardinality estimate is join_tab->read_records.
- Then, we try to get a tighter bound by using index statistics.
- If indexes do not cover all GROUP BY columns, we try to use per-column
  EITS statistics.
6e6fcf4d43e9...
6e6fcf4d43e9f5812e1870821968a77c9f826b62
Vlad Lesin
MDEV-34489 innodb.innodb_row_lock_time_ms fails

The test fails trying to compare (innodb/lock)_row_lock_time_avg with
some limit. We can't predict (innodb/lock)_row_lock_time_avg value,
because it's counted as the whole waiting time divided by the amount of
waits. Both waiting time and amount of waits depend on the previous
tests execution. The corresponding counters in lock_sys can't be reset
with any query. Remove (innodb/lock)_row_lock_time_avg comparision from
the test.

information_schema.global_status.innodb_row_lock_time can't be reset,
compare its difference instead of absolute value.

Reviewed by: Marko Mäkelä
66cf3c6974c4...
66cf3c6974c4a295687a78dc7bf5050db8bdbf2f
Sergei Golubchik
MDEV-35612 fix for system-versioning

only ignore fully invisible fields
633bcc82ff2a...
633bcc82ff2a3df864d3118d96cbed89883cb60f
Kristian Nielsen
MDEV-34705: Binlog-in-engine: Implement PURGE BINARY LOGS

Still ToDo: is to restrict auto-purge so that it does not purge any binlog
file with out-of-band data that might still be needed by a connected slave.

Signed-off-by: Kristian Nielsen <[email protected]>
5c05d0f5be48...
5c05d0f5be483a000d255865db6447f61328d67c
Marko Mäkelä
MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size

We deprecate and ignore the parameter innodb_buffer_pool_chunk_size
and let the buffer pool size to be changed in arbitrary 1-megabyte
increments, all the way up to innodb_buffer_pool_size_max,
which must be specified at startup.

If innodb_buffer_pool_size_max is not specified, it will default to
twice the specified innodb_buffer_pool_size.

The buffer pool will be mapped in a contiguous memory area that
will be aligned and partitioned into extents of 8 MiB on 64-bit systems
and 2 MiB on 32-bit systems.

Within an extent, the first few innodb_page_size blocks contain
buf_block_t objects that will cover the page frames in the rest
of the extent. In this way, there is a trivial mapping between
page frames and block descriptors and we do not need any
lookup tables like buf_pool.zip_hash or buf_pool_t::chunk_t::map.

We will always allocate the same number of block descriptors for
an extent, even if we do not need all the buf_block_t in the last
extent in case the innodb_buffer_pool_size is not an integer multiple
of the of extents size.

The minimum innodb_buffer_pool_size is 256*5/4 pages. At the default
innodb_page_size=16k this corresponds to 5 MiB. However, now that the
innodb_buffer_pool_size includes the memory allocated for the block
descriptors, the minimum would be innodb_buffer_pool_size=6m.

Innodb_buffer_pool_resize_status: Remove. We will execute
buf_pool_t::resize() synchronously in the thread that is executing
SET GLOBAL innodb_buffer_pool_size. That operation will run until
it completes, or until a KILL statement is executed, the client
is disconnected, the buf_flush_page_cleaner() thread notices that
we are running out of memory, or the server is shut down.

my_large_virtual_alloc(): A new function, similar to my_large_malloc().
FIXME: On Microsoft Windows, let the caller know if large page allocation
was used. In that case, we must disallow buffer pool resizing.

buf_pool_t::create(), buf_pool_t::chunk_t::create(): Only initialize
the first page descriptor of each chunk.

buf_pool_t::lazy_allocate(): Lazily initialize a previously allocated
page descriptor and increase buf_pool.n_blocks, which must be below
buf_pool.n_blocks_alloc.

buf_pool_t::allocate(): Renamed from buf_LRU_get_free_only().

buf_pool_t::LRU_warned: Changed to Atomic_relaxed<bool>,
only to be modified by the buf_flush_page_cleaner() thread.

buf_pool_t::LRU_shrink(): Check if buffer pool shrinking needs
to process a buffer page.

buf_pool_t::resize(): Always zero out b->page.zip.data.
Failure to do so would cause crashes or corruption in
the test innodb.innodb_buffer_pool_resize due to
duplicated allocation in the buddy system.
Before tarting to shrink the buffer pool, run one batch of
buf_flush_page_cleaner() in order to prevent LRU_warn().
Abort shrinking if the buf_flush_page_cleaner() has LRU_warned.

buf_pool_t::first_to_withdraw: The first block descriptor that is
out of the bounds of the shrunk buffer pool.

buf_pool_t::withdrawn: The list of withdrawn blocks.
If buf_pool_t::resize() is aborted, we must be able to resurrect
the withdrawn blocks in the free list.

buf_pool_t::contains_zip(): Added a parameter for the
number of least significant pointer bits to disregard,
so that we can find any pointers to within a block
that is supposed to be free.

buf_pool_t::get_info(): Replaces buf_stats_get_pool_info().

innodb_init_param(): Refactored. We must first compute
srv_page_size_shift and then determine the valid bounds of
innodb_buffer_pool_size.

buf_buddy_shrink(): Replaces buf_buddy_realloc().
Part of the work is deferred to buf_buddy_condense_free(),
which is being executed when we are not holding any
buf_pool.page_hash latch.

buf_buddy_condense_free(): Do not relocate blocks.

buf_buddy_free_low(): Do not care about buffer pool shrinking.
This will be handled by buf_buddy_shrink() and
buf_buddy_condense_free().

buf_buddy_alloc_zip(): Assert !buf_pool.contains_zip()
when we are allocating from the binary buddy system.
Previously we were asserting this on multiple recursion levels.

buf_buddy_block_free(), buf_buddy_free_low():
Assert !buf_pool.contains_zip().

buf_buddy_alloc_from(): Remove the redundant parameter j.

buf_flush_LRU_list_batch(): Add the parameter shrinking.
If we are shrinking, invoke buf_pool_t::LRU_shrink() to see
if we must keep going.

buf_do_LRU_batch(): Skip buf_free_from_unzip_LRU_list_batch()
if we are shrinking the buffer pool. In that case, we want
to minimize the page relocations and just finish as quickly
as possible.

trx_purge_attach_undo_recs(): Limit purge_sys.n_pages_handled()
in every iteration, in case the buffer pool is being shrunk
in the middle of a purge batch.
5be38d14fce4...
5be38d14fce4cc6ed2ea02633ba1bb9b1b53ed3b
Sergei Golubchik
ColumnStore 23.10.3-1
50ba45b7fb17...
50ba45b7fb1763cdbe80626780976daa81d5ad33
Vladislav Vaintroub
MDEV-14091 Support password protected SSL key in server.

Add ssl_passphrase_command server parameter, inspired by Postgres
parameter with the same name.

Based on a patch by Hartmut Holzgraefe
4e8a88dfc2a6...
4e8a88dfc2a62ca3792af0c2382dd793e30f3798
Monty
Fixed costs in JOIN_TAB::estimate_scan_time() and HEAP

Estimate_scan_time() calculates the cost of scanning a derivied table.
The old code did not take into account that the temporary table heap table
may be converted to Aria.

Things fixed:
- Added checking if the temporary tables data will fit in the heap.
  If not, then calculate the cost based on the designated internal
  temporary table engine (Aria).
- Removed MY_MAX(records, 1000) and instead trust the optimizer's
  estimate of records. This reduces the cost of temporary tables a bit
  for smal lables, which caused a few changes in mtr results.
- Fixed cost calculation for HEAP.
  - HEAP costs->row_next_find_cost was not set. This does not affect old
    costs calculation as this cost slot was not used anywhere.
    Now HEAP cost->row_next_find_cost is set, which allowed me to remove
    some duplicated computation in ha_heap::scan_time()


The effect of the above changes
3cfffb4de661...
3cfffb4de661fb70f27e514d9c0e4851813010f7
Marko Mäkelä
MDEV-35962 CREATE INDEX fails to heal a FOREIGN KEY constraint

commit_cache_norebuild(): Replace any newly added indexes in
the attached foreign key constraints.
38d3b6027b66...
38d3b6027b6637d7be0da2060a6aa4c314d2337d
Sergei Golubchik
MDEV-35943 ASAN errors in Query_arena::free_items / fill_schema_table_from_frm

shouldn't try to close the table if open failed.

followup for deb20fb751f6
30f766133462...
30f766133462a9a622889e715c63a417034f9d6c
Vladislav Vaintroub
MDEV-14091 Support password protected SSL key in server.

Add ssl_passphrase_command server parameter, inspired by Postgres
parameter with the same name.

Based on a patch by Hartmut Holzgraefe
1fec4fc4f81b...
1fec4fc4f81b2a16ec887855ef3a1d05387bb9ea
Sergei Golubchik
more C API methods in the service_sql

for columnstore
17e31abd8b6a...
17e31abd8b6a045d6f5240a0d3387dbad942683a
Sergei Golubchik
compilation failure on CentOS 7
10162dbb39ff...
10162dbb39fff2c922bb405e784af113c6639162
Vladislav Vaintroub
MDEV-14091 Support password protected SSL key in server.

Add ssl_passphrase_command server parameter, inspired by Postgres
parameter with the same name.

Based on a patch by Hartmut Holzgraefe
0e5cebbd3250...
0e5cebbd3250d0cd5d12f117fddd983e8bdaa41b
Sergei Petrunia
MDEV-30877: Output cardinality for derived table ignores GROUP BY

(Variant 3)
When a derived table has a GROUP BY clause:

  SELECT ...
    FROM  (SELECT ... GROUP BY col1, col2) AS tbl

The optimizer would use inner join's output cardinality as an estimate
of derived table size, ignoring the fact that GROUP BY operation would
produce much fewer groups.

Add code to produce tighter bounds:
- The GROUP BY list is split into per-table lists. If GROUP BY list has
  expressions that refer to multiple tables, we fall back to join output
  cardinality.
- For each table, the first cardinality estimate is join_tab->read_records.
- Then, we try to get a tighter bound by using index statistics.
- If indexes do not cover all GROUP BY columns, we try to use per-column
  EITS statistics.
0771110266ff...
0771110266ff5c04216af4bf1243c65f8c67ccf4
Sergei Golubchik
MDEV-33658 1/2 FULLTEXT and SPATIAL keys are not "too long"

max_key_length applies only to PRIMARY/UNIQUE/MULTIPLE keys,
but not to FULLTEXT/SPATIAL/VECTOR keys.

this fixes main.partition_geometries test

followup for ecaedbe299fe
0749476e1ea8...
0749476e1ea8dd358675845ba6ee4f81409461c3
Marko Mäkelä
WIP: MDEV-36024 regression with innodb_encrypt_log

Note: This change breaks crash recovery for innodb_encrypt_log.
Its only purpose is to estimate the performance when the inline
function encryption_crypt() is split in such a way that
encryption_ctx_update() will be invoked multiple times.

Even if this change worked as intended, it would be incompatible with
the existing innodb_encrypt_log format.
066e8d6aeabc...
066e8d6aeabc13242193780341e0f845528105de
Sergei Golubchik
Merge branch '10.5' into 10.6
04bd6ed44c6c...
04bd6ed44c6cb4d97e627691d88b77dcffc02993
Sergei Golubchik
MDEV-35368 Validation of SSL certificate fails for mariadb-backup

Just like in CONC-712, disable hostname checks for connections
over unix socket. Even for not self-signed certificates.
045951756214...
04595175621446d685fbb7b664977178cb8cb473
Sergei Golubchik
MDEV-35169 cleanup after the test

followup for f6e00abda0c7
03d2328785db...
03d2328785db2ec1467a9c465712b2c559bcd6e6
Sergei Golubchik
MDEV-35944 DELETE fails to notice transaction abort, violating ACID

Process errors of read_record().

Also, add an assert that Marko requested
BuildBot (0.8.9) working for the MariaDB project.
Page built: Wed 05 Feb 2025 12:57:25 (UTC)