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
Monty
Ensure that mysqlbinlog frees all memory at exit
Vlad Lesin
MDEV-28187 mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation

Make absolute destination path from relative one, basing on mysql data
directory.

Reviewed by Alexander Barkov.
Anel Husakovic
WIP:Race condition, wrong result file

1. Noted race condition when having single replica that is busy (test
case 7)
Proof, iteratively runs:
```bash
1. gives result
#              but since we are iterating through slave_info, this slave is not found,why?In previous test slave_info is found.
SHOW REPLICA HOSTS;
Server_id Host Port Master_id Gtid_State_Sent Gtid_State_Ack
+2 localhost SLAVE_PORT 1 0-1-5 0-1-4
connection slave;
SET @@GLOBAL.debug_dbug= "";
# cleanup
# -------------------------------------------
connection master;

2. doesn't give result
--- /home/anel/GitHub/mariadb/server/src/10.11/mysql-test/suite/rpl/r/rpl_show_slave_hosts.result 2023-03-14 15:42:26.155423792 +0100
+++ /home/anel/GitHub/mariadb/server/src/10.11/mysql-test/suite/rpl/r/rpl_show_slave_hosts.reject 2023-03-14 15:47:45.790195438 +0100
@@ -155,12 +155,19 @@
# -------------------------------------------
connection master;
drop table t;
+drop table t2;
connection slave;
```

2. Cannot save result file:
```bash
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
rpl.rpl_show_slave_hosts 'mix'          [ fail ]  Found warnings/errors in server log file!
        Test ended at 2023-03-14 15:49:10
line
2023-03-14 15:48:59 11 [ERROR] Slave I/O: Replication event checksum verification failed while reading from network, Internal MariaDB error code: 1743
2023-03-14 15:48:59 11 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
^ Found warnings in /home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/mysqld.2.err
ok
line
2023-03-14 15:49:09 9 [Warning] Timeout waiting for reply of binlog (file: master-bin.000001, pos: 1434), semi-sync up to file master-bin.000001, position 1228.
^ Found warnings in /home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/mysqld.1.err
ok

- saving '/home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/rpl.rpl_show_slave_hosts-mix/' to '/home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/rpl.rpl_show_slave_hosts-mix/'

Only  1  of 3 completed.
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 21 seconds executing testcases
mysql-test-run: WARNING: Got errors/warnings while running tests, please examine '/home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/warnings' for details.

Failure: Failed 1/1 tests, 0.00% were successful.

```
Anel Husakovic
MDEV-30697: Memory leak detected when mariadb-binlog is used with option flashback
Anel Husakovic
WIP:Race condition, wrong result file

1. Noted impact of randomness of event selection (looks like a race
condition but it is not), when having single replica that is busy (test
case 7)
Proof, iteratively runnning the tests:
```bash
1. gives result
#              but since we are iterating through slave_info, this slave is not found,why?In previous test slave_info is found.
SHOW REPLICA HOSTS;
Server_id Host Port Master_id Gtid_State_Sent Gtid_State_Ack
+2 localhost SLAVE_PORT 1 0-1-5 0-1-4
connection slave;
SET @@GLOBAL.debug_dbug= "";
# cleanup
# -------------------------------------------
connection master;

2. doesn't give result
--- /home/anel/GitHub/mariadb/server/src/10.11/mysql-test/suite/rpl/r/rpl_show_slave_hosts.result 2023-03-14 15:42:26.155423792 +0100
+++ /home/anel/GitHub/mariadb/server/src/10.11/mysql-test/suite/rpl/r/rpl_show_slave_hosts.reject 2023-03-14 15:47:45.790195438 +0100
@@ -155,12 +155,19 @@
# -------------------------------------------
connection master;
drop table t;
+drop table t2;
connection slave;
```

2. Cannot save result file - impact of `corrupt_query_event` debug
point:
```bash
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
rpl.rpl_show_slave_hosts 'mix'          [ fail ]  Found warnings/errors in server log file!
        Test ended at 2023-03-14 15:49:10
line
2023-03-14 15:48:59 11 [ERROR] Slave I/O: Replication event checksum verification failed while reading from network, Internal MariaDB error code: 1743
2023-03-14 15:48:59 11 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, Internal MariaDB error code: 1595
^ Found warnings in /home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/mysqld.2.err
ok
line
2023-03-14 15:49:09 9 [Warning] Timeout waiting for reply of binlog (file: master-bin.000001, pos: 1434), semi-sync up to file master-bin.000001, position 1228.
^ Found warnings in /home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/mysqld.1.err
ok

- saving '/home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/rpl.rpl_show_slave_hosts-mix/' to '/home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/rpl.rpl_show_slave_hosts-mix/'

Only  1  of 3 completed.
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 21 seconds executing testcases
mysql-test-run: WARNING: Got errors/warnings while running tests, please examine '/home/anel/GitHub/mariadb/server/build/10.11/mysql-test/var/log/warnings' for details.

Failure: Failed 1/1 tests, 0.00% were successful.

```
Thirunarayanan Balathandayuthapani
MDEV-26198  Assertion `0' failed in row_log_table_apply_op during
redundant table rebuild

- InnoDB alter fails to apply the online log during redundant table
rebuild. Problem is that InnoDB wrongly reads the length flags of the
record while applying the temporary log record.

rec_init_offsets_comp_ordinary(): For finding the n_core_null_bytes,
InnoDB should use the same logic as rec_convert_dtuple_to_rec_comp().
Andrei
MDEV-30780 optimistic parallel slave hangs after hit an error

The hang could be seen as show slave status displaying an error like
    Last_Error: Could not execute Write_rows_v1
along with
    Slave_SQL_Running: Yes

accompanied with one of the replication threads in show-processlist
characteristically having status like

  2394 | system user  |    | NULL | Slave_worker | 50852| closing tables

It turns out that closing tables worker got entrapped in endless looping
in mark_start_commit_inner() across already garbage-collected gco items.

The reclaimed gco links are explained with actually possible
out-of-order groups of events termination due to the Last_Error.
This patch reinforces the correct ordering to perform
finish_event_group's cleanup actions, incl unlinking gco:s
from the active list.
Monty
Fixes to mysql_install_db

- Change to use 'mariadbd' instead of 'mysqld' in help texts and other
  visible places.
- Start binary 'mariadbd' instead of 'mysqld'. This will remove a warning
  in 11.0 when running mysql_install_db.
- Use my_print_defaults --mariadbd instead of --mysqld
- Use --skip-log-error if the user don't have access to log-error file.
  This it needed to allow mysql_install_db to work silenty for users that
  has not write access to /var/log.

Other things:
- Updated my_print_defaults to support --mariadbd
Daniel Black
MDEV-30810 errmsg-utf8.txt no longer uses charsets

Charset names in the 'languages' line are not used any more.

Removing to avoid confusion.

All messages in errmsg-utf8.txt are in utf8 now.

Charset names should have been removed in MySQL-5.5 during: https://dev.mysql.com/worklog/task/?id=751

Bump version number.
EkaterinePapava
MDEV-30789 Add Georgian translation (error messages)
Sergei Golubchik
Merge branch '10.10' into 10.11