- discuss - lists.mariadb.org

[Maria-discuss] DBMS vs Storage Engine Alone
by Jonathan M. Wilbur 20 Dec '22

20 Dec '22

Sorry to ask this question here, since it is not strictly MariaDB-related, but I need the knowledge of people that develop with databases: is there significant overhead to using a DBMS versus a storage engine directly? I have a project for which speed / latency is very important, and I was wondering if I could make significant performance gains by using a storage engine (such as WiredTiger, RocksDB, LevelDB, etc.) directly instead of using a DBMS (like MariaDB). More concretely, are there any studies out there on this to give me some objective numbers on this? Assume it is over a local loopback connection, so pretty much only the overhead of the networking itself would apply. Thank you in advance, - Jonathan M. Wilbur

4 3

[Maria-discuss] flush tables with read lock blocks
by Alex 13 Dec '22

13 Dec '22

Hi, I'm using mariadb-10.5.18-1.fc37.x86_64 on fedora37 set up as a master server. There are currently two or three slaves configured and operating properly. I'm trying to add another slave, and for some reason when I try to flush tables with read lock, then dump the databases to be transferred to the new slave, mysqldump just prints: -- Connecting to localhost... At first I didn't realize it, but soon the database stopped responding to all clients until I released the lock with "unlock tables". I'm following these directions: https://mariadb.com/kb/en/setting-up-replication/ What could I be doing wrong? Here are the my.cnf options that I believe could be related to my issue. Any ideas greatly appreciated. The server has 128GB of RAM. [mysqld] sql_mode=ONLY_FULL_GROUP_BY character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci max_connections=1000 replicate_do_db='repdb' replicate_do_db='sbclient' port = 3306 socket = /var/lib/mysql/mysql.sock skip-external-locking key_buffer_size = 256M max_allowed_packet = 512M join_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M query_cache_size = 400000000 query_cache_type = 1 query_cache_strip_comments = 1 relay_log_space_limit = 500M relay_log_purge = 1 log-slave-updates = 1 local_infile = OFF binlog_format = ROW max_heap_table_size = 2048M tmp_table_size = 2048M relay-log=myserver-relay-bin log_bin = /var/log/mariadb/mysql-bin.log log_warnings = 1 expire_logs_days = 2 max_binlog_size = 500M plugin_load=server_audit=server_audit.so plugin_load_add = query_response_time server_audit_events=connect,query server_audit_file_path = /var/log/mariadb/server_audit.log server_audit_file_rotate_size = 1G server_audit_file_rotations = 1 slow-query-log = 1 slow-query-log-file = /var/log/mariadb/mariadb-slow.log long_query_time = 1 log_error = /var/log/mariadb/mariadb-error.log skip-networking=0 binlog_format=mixed server-id = 590

2 2

Re: [Maria-discuss] Maria-db refuses to start
by Jogchum Reitsma 12 Dec '22

12 Dec '22

Op 08-11-2022 om 13:04 schreef Marko Mäkelä: > Hi Jogchum, > > On Tue, Nov 8, 2022 at 1:21 PM Jogchum Reitsma > <jogchum.reitsma(a)gmail.com> wrote: > [...] >> 2022-11-08 12:06:17 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files. >> (repeated several times) >> 2022-11-08 12:06:17 0 [ERROR] /usr/local/mariadb-10.6.10-linux-systemd-x86_64/bin/mariadbd: unknown option '--skip-locking' >> 2022-11-08 12:06:17 0 [ERROR] Aborting > Was that the end of the output? No shutdown message from InnoDB, like this? > > 2022-11-08 14:03:03 0 [Note] InnoDB: Shutdown completed; log sequence > number 2150107; transaction id 3085 > > If there was no output like that, you should remove any line that says > "skip_locking" or "skip-locking" from the configuration file and > retry. > > Marko Yes, that was indeed the end of the output. The skip-locking statement was not in /etc/my.cnf, but inmy.cnf in my home dir. Commented it out and now this complaint disappeared. But now I get #################################################################### 2022-11-08 13:37:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2022-11-08 13:37:32 0 [Note] InnoDB: Number of pools: 1 2022-11-08 13:37:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-11-08 13:37:32 0 [Note] InnoDB: Using Linux native AIO 2022-11-08 13:37:32 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-11-08 13:37:32 0 [Note] InnoDB: Completed initialization of buffer pool 2022-11-08 13:37:32 0 [Note] InnoDB: 128 rollback segments are active. 2022-11-08 13:37:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-11-08 13:37:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-11-08 13:37:32 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-11-08 13:37:32 0 [Note] InnoDB: 10.6.10 started; log sequence number 578191791; transaction id 2935782 2022-11-08 13:37:32 0 [Note] InnoDB: Loading buffer pool(s) from /home/jogchum/mysql/ib_buffer_pool 2022-11-08 13:37:32 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-11-08 13:37:32 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files. 2022-11-08 13:37:33 0 [Note] Server socket created on IP: '0.0.0.0'. 2022-11-08 13:37:33 0 [ERROR] Can't start server : Bind on unix socket: No such file or directory 2022-11-08 13:37:33 0 [ERROR] Do you already have another server running on socket: /var/run/mysql/mysql.sock ? 2022-11-08 13:37:33 0 [ERROR] Aborting Warning: Memory not freed: 280 ########################################################################## (again no further output). /var/run/mysql/mysql.sock odoes not exeist, and "pgrep mariadbd", "pgrep mysql" and "pgrep mysqld" show nothing, so no serer is running anymore. ss -a | grep 3306 or ss -a | grep /var/run/mysql also gives nothing, so it seems there are no processes using that port. We're getting closer it seems, but not quite there yet... regards, Jogchum

7 48

[Maria-discuss] Statistics are not being updated?
by Colin Charles 08 Dec '22

08 Dec '22

Hi, Any reason statistics stopped being updated in October? https://mariadb.org/statistics/ Would be great if this got fixed, thanks cheers, -c -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] Followup on MDEV-25625, still present in 10.5.16
by Chris Ross (cross2) 17 Nov '22

17 Nov '22

Hello all. I came across MDEV-25625 while looking for that same problem. It was closed, I think because the reporter didn’t get back to it, but I’m now seeing the same. I’ve added a comment, but I don’t know if commenting on a closed issue will notify anyone. Can anyone comment/re-open that issue? I don’t want to file a duplicate. Thank you. https://jira.mariadb.org/browse/MDEV-25625 - Chris

2 3

[Maria-discuss] subscribe
by Surya 15 Nov '22

15 Nov '22

Hello , -- Best regards, Surya mailto:surya@fastmail.in

1 0

[Maria-discuss] (no subject)
by Surya 15 Nov '22

15 Nov '22

Hello , -- Best regards, Surya mailto:surya@fastmail.in

1 0

[Maria-discuss] mariadb-10.3.37 strips "collate" from "show create table"
by Reindl Harald 10 Nov '22

10 Nov '22

mariadb-10.3.36 versus mariadb-10.3.37 in the past every field contained "collate latin1_german1_ci" and after this point-update collation is only part of the output if it's different then the tables default collation surely, i can update everything to mariadb-10.3.37 and rewrite all this tests in the hope the next point-update don't restore the old behavior but it's really a bad style --------------------------------------------------------------------------------------------------------------------- CALLER: '/autotests/custom/phpincludes_mysql.php:306': --------------------------------------------------------------------------------------------------------------------- --- old_9bb3995c3244abfff522da086526e88b5a8a81f1e7cf672d8343f20d.txt 2022-11-10 01:03:12.366665303 +0100 +++ new_53033703b16454931e7c7f62ef923229ca8183aff6f6fa017cdb44bd.txt 2022-11-10 01:03:12.366665303 +0100 @@ -1,14 +1,14 @@ create table `test_table` (`test_id` mediumint(7) unsigned not null auto_increment, -`char_char` char(200) collate latin1_german1_ci default null, +`char_char` char(200) default null, `char_date` date default null, `char_datetime` datetime default null, -`char_longtext` longtext collate latin1_german1_ci default null, -`char_mediumtext` mediumtext collate latin1_german1_ci default null, -`char_text` text collate latin1_german1_ci default null, +`char_longtext` longtext default null, +`char_mediumtext` mediumtext default null, +`char_text` text default null, `char_time` time default null, `char_timestamp` datetime default null, -`char_tinytext` tinytext collate latin1_german1_ci default null, -`char_varchar` varchar(200) collate latin1_german1_ci default null, +`char_tinytext` tinytext default null, +`char_varchar` varchar(200) default null, `number_bigint` bigint(200) unsigned default null, `number_double` double unsigned default null, `number_float` double unsigned default null,

1 0

[Maria-discuss] Maria-db refuses to start
by Jogchum Reitsma 08 Nov '22

08 Nov '22

Hi, I am on OpenSuse Tumbleweed, rolling distro. Since some snapshots of Tumbleweed my mariadb does not start at system start. I don't use the mariadb databases a lot, so I didn't notice it immediately. Hence I'm unsure when the problem occurred first time. When trying to start it manually, I got the message [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.5.8. Searching that message, I saw a post on https://bbs.archlinux.org/viewtopic.php?id=259364 Like me, he had a non-default location for the databases configured in /etc/my.cnf. The solution that worked for him was to change that to another location in my.cnf, starting the database (which now succeeded), and copy the existing databases to that new location. So I decided to mimic that: commented out the existing database location, entered an new one, and started the database server (as root) with systemctl start mariadb After a while, the new location is created (owned by mysql:root) and populated: l mysql_recover totaal 111048 drwx------ 6 mysql root 243 2 okt 21:33 ./ drwxr-xr-x 225 jogchum users 16384 2 okt 21:26 ../ -rw-rw---- 1 mysql mysql 417792 2 okt 21:27 aria_log.00000001 -rw-rw---- 1 mysql mysql 52 2 okt 21:27 aria_log_control -rw-rw---- 1 mysql mysql 942 2 okt 21:27 ib_buffer_pool -rw-rw---- 1 mysql mysql 12582912 2 okt 21:27 ibdata1 -rw-rw---- 1 mysql mysql 100663296 2 okt 21:27 ib_logfile0 drwx------ 2 mysql mysql 4096 2 okt 21:27 mysql/ -rw-rw---- 1 root root 14 2 okt 21:27 mysql_upgrade_info drwx------ 2 mysql mysql 28 2 okt 21:27 performance_schema/ drwx------ 2 mysql mysql 8192 2 okt 21:27 sys/ drwx------ 2 mysql mysql 28 2 okt 21:27 test/ But unlike the posting at bbs.archlinux.org just mentioned, the server crashed again, now with the following messages in journalctl: ################################################################################# journalctl -xeu mariadb.service A start job for unit mariadb.service has finished with a failure. The job identifier is 2782226 and the job result is failed. okt 02 21:20:47 linux-mkay systemd[1]: Starting MariaDB database server... Subject: A start job for unit mariadb.service has begun execution Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel A start job for unit mariadb.service has begun execution. The job identifier is 2790830. okt 02 21:20:47 linux-mkay mysql-systemd-helper[44977]: 2022-10-02 21:20:47 0 [Note] /usr/sbin/mysqld (server 10.8.3-MariaDB) starting as process 44977 ... okt 02 21:20:48 linux-mkay systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Subject: Unit process exited Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel An ExecStart= process belonging to unit mariadb.service has exited. The process' exit code is 'exited' and its exit status is 1. okt 02 21:20:48 linux-mkay systemd[1]: mariadb.service: Failed with result 'exit-code'. Subject: Unit failed Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel The unit mariadb.service has entered the 'failed' state with result 'exit-code'. okt 02 21:20:48 linux-mkay systemd[1]: Failed to start MariaDB database server. Subject: A start job for unit mariadb.service has failed Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel A start job for unit mariadb.service has finished with a failure. The job identifier is 2790830 and the job result is failed. okt 02 21:26:55 linux-mkay systemd[1]: Starting MariaDB database server... Subject: A start job for unit mariadb.service has begun execution Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel A start job for unit mariadb.service has begun execution. The job identifier is 2792404. okt 02 21:26:55 linux-mkay mysql-systemd-helper[45372]: Creating MySQL privilege database... okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Two all-privilege accounts were created. okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: One is root@localhost, it has no password, but you need to okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: be system 'root' user to connect. Use, for example, sudo mysql okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: The second is mysql@localhost, it has no password either, but okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: you need to be the system 'mysql' user to connect. okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: After connecting you can set the password, if you would need to be okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: able to connect as any of these users with a password and without sudo okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: See the MariaDB Knowledgebase at https://mariadb.com/kb okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Please report any problems at https://mariadb.org/jira okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: The latest information about MariaDB is available at https://mariadb.org/. okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Consider joining MariaDB's strong and vibrant community: okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: https://mariadb.org/get-involved/ okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: 2022-10-02 21:27:17 0 [Note] /usr/sbin/mysqld (server 10.8.3-MariaDB) starting as process 45468 ... okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: 2022-10-02 21:27:17 0 [Warning] Can't create test file /home/jogchum/mysql_recover/linux-mkay.lower-test okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: [103B blob data] okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: 2022-10-02 21:27:17 0 [ERROR] Aborting okt 02 21:27:17 linux-mkay systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Subject: Unit process exited Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel ############################################################################################ Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? Thanks in advance! regards, Jogchum

6 22

[Maria-discuss] Bug in incremental backups since MariaDB version 10.5.7 with mariabackup?
by Michael Rößler 02 Nov '22

02 Nov '22

Hi @ll, I am using mariabackup since 2 years. I wanted to upgrade from version 10.4.24 to 10.6.10 but I found out that incremental Backups does not work as expected because of size. Further investigation show that it is since version 10.5.7. Then I have found out that in the file xtrabackup_checkpoints the value for to_lsn is not changing in version 10.5.7 and 10.6.10. Using the command 'mysql -e "SHOW ENGINE INNODB STATUS\G" | egrep "Last check"' show that values are the same with that command and the value to_lsn in the file xtrabackup_checkpoints. Backup-commands used in test environment: mariabackup --extra-lsndir=/var/backup/full --backup --compress --stream=xbstream --user=root --password=root --target-dir=/var/backup/full > /var/backup/full/full.xbstream mariabackup --extra-lsndir=/var/backup/inc1 --backup --compress --stream=xbstream --user=root --password=root --incremental-basedir=/var/backup/full --target-dir=/var/backup/inc1 > /var/backup/inc1/inc1.xbstream mariabackup --extra-lsndir=/var/backup/inc2 --backup --compress --stream=xbstream --user=root --password=root --incremental-basedir=/var/backup/inc1 --target-dir=/var/backup/inc2 > /var/backup/inc2/inc2.xbstream mariabackup --extra-lsndir=/var/backup/inc3 --backup --compress --stream=xbstream --user=root --password=root --incremental-basedir=/var/backup/inc2 --target-dir=/var/backup/inc3 > /var/backup/inc3/inc3.xbstream Size of files compared between version 10.5.6 and 10.5.7: [root@mysqlsingle2 backup]# ls *10.5.6/*xbstream -lh -rw-r--r-- 1 root root 765K 2. Nov 13:03 full-10.5.6/full.xbstream -rw-r--r-- 1 root root 779K 2. Nov 13:06 inc1-10.5.6/inc1.xbstream -rw-r--r-- 1 root root 1,2M 2. Nov 13:16 inc2-10.5.6/inc2.xbstream -rw-r--r-- 1 root root 752K 2. Nov 13:17 inc3-10.5.6/inc3.xbstream [root@mysqlsingle2 backup]# ls -lh *10.5.7/*xbstream -rw-r--r-- 1 root root 763K 2. Nov 13:22 full-10.5.7/full.xbstream -rw-r--r-- 1 root root 723K 2. Nov 13:23 inc1-10.5.7/inc1.xbstream # added 2000 rows -rw-r--r-- 1 root root 2,1M 2. Nov 13:30 inc2-10.5.7/inc2.xbstream # added 20000 rows -rw-r--r-- 1 root root 2,2M 2. Nov 13:31 inc3-10.5.7/inc3.xbstream # added 2000 rows to_lsn in file xtrabackup_checkpoints: [root@mysqlsingle2 backup]# cat full*/*checkpoints | grep "to_lsn" to_lsn = 47455 # 10.5.6 to_lsn = 45118 # 10.5.7 [root@mysqlsingle2 backup]# cat inc1*/*checkpoints | grep "to_lsn" to_lsn = 487597 # 10.5.6 to_lsn = 45118 # 10.5.7 [root@mysqlsingle2 backup]# cat inc2*/*checkpoints | grep "to_lsn" to_lsn = 4572514 # 10.5.6 to_lsn = 45118 # 10.5.7 [root@mysqlsingle2 backup]# cat inc3*/*checkpoints | grep "to_lsn" to_lsn = 4995024 # 10.5.6 to_lsn = 45118 # 10.5.7 'Last checkpoint at' from command 'mysql -e "SHOW ENGINE INNODB STATUS\G" | egrep "Last check"': [root@mysqlsingle2 backup]# cat full*/*Last* Last checkpoint at 47455 Last checkpoint at 45118 [root@mysqlsingle2 backup]# cat inc1*/*Last* Last checkpoint at 487597 Last checkpoint at 45118 [root@mysqlsingle2 backup]# cat inc2*/*Last* Last checkpoint at 4572514 Last checkpoint at 45118 [root@mysqlsingle2 backup]# cat inc3*/*Last* Last checkpoint at 4995024 Last checkpoint at 45118 Kind regards Michael

1 0

[Maria-discuss] Galera with stunnel for rsync sst method
by John Fawcett 15 Oct '22

15 Oct '22

Hi Can someone point out or help with a step by step guide to setting up Galera to use stunnel for rsync sst? I was following the instructions here: https://mariadb.com/kb/en/introduction-to-state-snapshot-transfers-ssts/ and my main doubts are: 1. Does stunnel itself have to be configured and if so is it the same configuration on all galera nodes? 2. Does stunnel have to be running as a service on any of the galera nodes? 3. Does the configuration shown in the galera documentation [sst] tkey = /etc/my.cnf.d/certificates/client-key.pem tcert = /etc/my.cnf.d/certificates/client-cert.pem have to be done on all the galera nodes? 4. Do the above key and cert have to be the same (or have to be different) on all galera nodes? 5. more of a stunnel question, but following the link from the galera documentation to the stunnel documentation for certificate generation, https://www.stunnel.org/howto.html I got stuck on this command which no longer works on openssl 3.0.5.5: openssl gendh 2048 >> stunnel.pem Any idea on what has replaced it? Thanks for any help. John

1 0

[Maria-discuss] Migration path for unix_socket authentication plugin
by William Edwards 14 Oct '22

14 Oct '22

Hi, On MariaDB servers that were installed with >= MariaDB 10.4, I have one root user that was created as: MariaDB [(none)]> show create user 'root'@'localhost'; CREATE USER `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket FWIW: The statements on https://mariadb.com/kb/en/authentication-from-mariadb-104/#description are reversed (`IDENTIFIED VIA unix_socket OR mysql_native_password USING 'invalid'` instead of `IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket`). On MariaDB servers that were installed with < MariaDB 10.4, I have 3 root users that were created as: MariaDB [(none)]> show create user 'root'@'localhost'; CREATE USER `root`@`localhost` MariaDB [(none)]> show create user 'root'@'::1'; CREATE USER `root`@`::1` MariaDB [(none)]> show create user 'root'@'127.0.0.1'; CREATE USER `root`(a)`127.0.0.1` I've upgraded all MariaDB servers that were installed with MariaDB <= 10.4 to MariaDB 10.6. I would like to update these root users, that were created when installing on < 10.4, to use UNIX socket authentication too. If I run: ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket ... I have a user with the same create statement as on servers that were installed with >= MariaDB 10.4: MariaDB [(none)]> show create user 'root'@'localhost'; CREATE USER `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket I have 3 questions regarding this: 1. Is the ALTER USER statement above the correct migration path, to update root users created when installing on < 10.4 to use UNIX socket authentication, like root users created when installing on >= 10.4? Am I forgetting anything? 2. I presume the 'root'@'::1' and 'root'@'127.0.0.1' users were created to support TCP connections when skip_name_resolve=1. If so, they are no longer needed when using a UNIX socket. Can I safely delete these users, after updating the 'root'@'localhost' user to use UNIX socket authentication? 3. Is there a plan to automatically remove the debian-sys-maint user on future major upgrades? It still exists on servers that were installed on < 10.4. The /etc/mysql/debian.cnf file is deprecated already, so this user should be unused. FYI: All MariaDB servers were installed from the MariaDB Debian repository. Thank you! William Edwards

2 1

[Maria-discuss] Retrieve authentication plugins for user
by William Edwards 13 Oct '22

13 Oct '22

Hi, When creating an account with multiple authentication plugins, in this case 'unix_socket' OR 'mysql_native_password', the mysql.user.plugin column is set to either one. How should I retrieve *all* used authentication plugins for a given user? Example: ``` MariaDB [(none)]> CREATE USER 'testing'@'localhost' IDENTIFIED VIA unix_socket OR mysql_native_password USING 'invalid'; Query OK, 0 rows affected (0.005 sec) MariaDB [(none)]> select user,host,password,authentication_string,plugin from mysql.user where User = 'testing'; +---------+-----------+----------+-----------------------+-----------------------+ | User | Host | Password | authentication_string | plugin | +---------+-----------+----------+-----------------------+-----------------------+ | testing | localhost | invalid | invalid | mysql_native_password | +---------+-----------+----------+-----------------------+-----------------------+ 1 row in set (0.003 sec) ``` William Edwards

2 1

[Maria-discuss] What is the right way to update based on a DB change?
by ngtech1ltd＠gmail.com 03 Oct '22

03 Oct '22

Hey Everybody, I have the next scenario which I am not sure about the right way for a solution. I have a radius server that authenticate clients from multiple WIFI Access Points. I have couple systems and they need to know the current client login identifier (MAC or IP Address). It is stored in the DB and the DB is being updated on every login. I can try to give a static IP for every user and it will resolve this issue but there is an overhead for this. So what I was thinking instead is to either run a query that will fetch the latest changes or use a trigger to update another table which in turn will be read by an external software every 1-5 seconds. I believe that the right solution is to use a trigger that will update another table with the details and on the other table I will have a Processed column that will be updated when the software finished processing the row. Then in turn every 24 hours I will run a DB cleanup cron. I will try later on to share the schema. Any advice is more than welcome. Thanks, Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: <mailto:ngtech1ltd@gmail.com> ngtech1ltd(a)gmail.com Web: <https://ngtech.co.il/> https://ngtech.co.il/ My-Tube: <https://tube.ngtech.co.il/> https://tube.ngtech.co.il/

3 3

[Maria-discuss] LevelDB and KV best performance
by ngtech1ltd＠gmail.com 22 Aug '22

22 Aug '22

Hey, I have been using BDB and LevelDB and other KV embedded DB as an improvement for SquidGuard. I have seen the next MDEV: https://jira.mariadb.org/browse/MDEV-3841 And was wondering what is the most recommended way to store a simple KV list in MaraiDB these days. Currently MariaDB works fine for me but when I am comparing the performance of BDB to MariaDB even if am iterating a full DB file 6 times to find out if 6 different Keys are present it seems like a simple embedded DB is faster then MariaDB. I am not stating a fact since I don’t have the metrics but this is what it seems like. The DB is mainly for READ so I was thinking about an option to use a master and READ ONLY slaves to speedup the DB. The DB contains about 80 million rows so it’s not that big since the only thing I need is the KEY to match a category. Currently I am using a simple InnoDB table and the buffers are maximized to the maximum that the machine can offer. Thanks, Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: <mailto:ngtech1ltd@gmail.com> ngtech1ltd(a)gmail.com Web: <https://ngtech.co.il/> https://ngtech.co.il/ My-Tube: <https://tube.ngtech.co.il/> https://tube.ngtech.co.il/

1 0

[Maria-discuss] Change case with unique constraint
by Keith Edmunds 22 Aug '22

22 Aug '22

I can't change the case of a column with a unique index, example below. MariaDB [test]> show columns in kae; +-------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(2048) | NO | UNI | NULL | | +-------+---------------+------+-----+---------+----------------+ 2 rows in set (0.001 sec) MariaDB [test]> select * from kae; +----+------+ | id | name | +----+------+ | 1 | test | +----+------+ 1 row in set (0.001 sec) MariaDB [test]> update kae set name="Test" where id=1; ERROR 1062 (23000): Duplicate entry 'Test' for key 'unique_name' MariaDB [test]>

4 3

[Maria-discuss] "Rewind" type of mechanisms?
by Sam R. 19 Aug '22

19 Aug '22

Hi! I would like to know about following topic regarding MariaDB.We would like to run DB cluster with HA (high availability). -- E.g. with MaxScale. My Q:Does MariaDB support such mechanism which would be similar to pg_rewind? Reference: PostgreSQL supports such a rewind operation.Or, are there plans to support such regarding MariaDB? ( If such would be needed / useful. ) Rewind: "A typical scenario is to bring an old primary server back online after failover as a standby that follows the new primary." Target: robustness/stability of a DB cluster. Avoiding needs to manually fix DB cluster. Best Regards Sam

3 7

[Maria-discuss] mysql_upgrade and error 'Table rebuild required. Please do "ALTER TABLE `table1` FORCE" or dump/reload to fix it!'
by Karl Levik 18 Aug '22

18 Aug '22

Hello list, After upgrading a database from 10.5 to 10.6 I get messages like below for a couple of the tables when I run mysql_upgrade: error : Table rebuild required. Please do "ALTER TABLE `table1` FORCE" or dump/reload to fix it! But at the end of the output it says: Repairing tables `database1`.`table1` FIXED `database1`.`table2` FIXED .... and so on - it lists all the tables that it previously said I needed to rebuild as "fixed". So, does that mean I don't need to do anything, or should I still run the ALTER TABLE statements? It seems I can SELECT + DELETE from and INSERT into the tables without getting any errors, so presumably I don't have to worry? Regards, Karl

1 0

[Maria-discuss] Repos empty?
by William Edwards 15 Aug '22

15 Aug '22

Hello, The Debian repos @ https://mariadb.org/download/?t=repo-config don't seem to contain any packages and no Release file anymore. Last updated yesterday at 18:41 (IDK which timezone). E.g. http://ams2.mirrors.digitalocean.com/mariadb/repo/10.3/debian/dists/buster/… (the issue isn't with this specific mirror). When choosing a repo on mariadb.org, the error "An error occured. The mirrors could not be loaded." is shown. -- With kind regards, William Edwards

2 4

[Maria-discuss] Major upgrade instructions missing for Galera
by William Edwards 10 Aug '22

10 Aug '22

Hi, The documentation at https://mariadb.com/kb/en/upgrading-galera-cluster/ is missing major upgrade instructions > MariaDB 10.4. Someone else caught this as well: https://mariadb.com/kb/en/upgrading-from-104-to-105-galera-changes/ Is this intentional? -- With kind regards, William Edwards

3 6

[Maria-discuss] ibtmp1 for internal temporary tablespaces
by William Edwards 09 Aug '22

09 Aug '22

Hi, User-created temporary tables are stored in ibtmp1. Are internal temporary tablespaces (those created by MariaDB while executing queries) too? I am unable to find the answer in the documentation[1]. Context: I'd like to store ibtmp1 in a different path using innodb_temp_data_file_path, but ONLY for user-created temporary tables. William Edwards [1]: https://mariadb.com/kb/en/innodb-temporary-tablespaces/ -- With kind regards, William Edwards

2 1

[Maria-discuss] Some questions about mariadb-dump and mariabackup
by jkmdb＠w3.org 02 Aug '22

02 Aug '22

Hi! Sorry to bother you about this but I haven't found the answers in the doc. ** mariadb-dump Could you tell me what is the difference of calling mariadb-dump on innodb tables using --skip-lock-tables --single-transaction? >From what I read these seem to be time / performace optimizations for doing innodb tables dumps but if we omit them, we would get the same data dumped, even it takes longer. Could you confirm this? ** mariabackup We have a setup that stores the binary logs under /var/log/mysql (set up with the log_bin configuration option) and the databases themselves under /var/lib/mysql Suppose I call mariabackup to make a backup of the database as follows (some options obmitted): mariabackup --backup --target-dir=my_backup_dir Could you tell me if calling mariabackup --prepare --target-dir=my_backup_dir needs access to the binary logs stored under /var/log/mysql or if mariabackup made a copy of all that it needs in my_backup_dir? ** mariabackup and incremental backups This is basically the same question as the above. If i'm making incremental backups as follows (some options obmitted): mariabackup --backup \ --target-dir=my_backup_dir/inc1 --incremental-basedir=full_backup_dir When I do the prepare for the incremental backups, does mariabackup need access to the /var/log/mysql bin logs or do the full + each incremental backup dirs has all the info needed to do the prepare? mariabackup --prepare \ --target-dir=my_backup_dir/inc1 --incremental-basedir=full_backup_dir Many thanks in advance! --josé

3 2

[Maria-discuss] MariaDB server horribly slow on start
by Cédric Counotte 01 Aug '22

01 Aug '22

Hello all. I hope I'm at the right place to ask this question. I opened a bug here: https://jira.mariadb.org/browse/MDEV-28969, however I was told to use this mailing list. We have 4 MariaDB servers in a Galera Cluster and it happens that a server has to be restarted (be it for a crash which I have to open a bug for) or maintenance. When that happens, the restarted server is causing huge slow down on the whole cluster, and it lasts for 10 to 30 minutes at the very least! And by huge, I mean huge, we end up with 500 to 800 pending queries on all servers as you can see on attached screenshots I've attached the configuration of any server for reference in case this is the source of the issue. Any way to solve this would be greatly appreciated. Regards, 3C.

8 45

[Maria-discuss] Looking for advice where to start looking at a slow query case
by ngtech1ltd＠gmail.com 26 Jul '22

26 Jul '22

Hey, I have tried to run a local service which claims to be a YouTube alike which is named AVideo(used to be PHPTube). I loaded the service with 220k+ videos from YouTube and have used MariaDB as the DB backend. The service moved slowly as the size of the videos DB growed from 100k to 150k. I got a recommendation from the developer to use MySQL which didn’t made any sense to me. I tracked the issue to the SQL queries that the service runs. Currently I am upgrading my local servers so the DB cannot be downloaded for testing however I have seen a very interesting thing. I will first put the query here: ```sql SELECT u.*, v.*, c.iconClass, c.name as category, c.clean_name as clean_category,c.description as category_description, v.created as videoCreation, v.modified as videoModified FROM videos as v LEFT JOIN categories c ON categories_id = c.id LEFT JOIN users u ON v.users_id = u.id WHERE 2=2 AND u.status = 'a' AND v.status IN ('a','k','f') ORDER BY likes DESC LIMIT 36, 12; ``` The ANALYZE FORMAT=JSON for that query is: ```json { "query_block": { "select_id": 1, "r_loops": 1, "r_total_time_ms": 9643.807074, "filesort": { "sort_key": "v.likes desc", "r_loops": 1, "r_total_time_ms": 756.223544, "r_limit": 48, "r_used_priority_queue": true, "r_output_rows": 49, "r_sort_mode": "sort_key,rowid", "temporary_table": { "table": { "table_name": "u", "access_type": "ref", "possible_keys": ["PRIMARY", "users_status_IDX"], "key": "users_status_IDX", "key_length": "1", "used_key_parts": ["status"], "ref": ["const"], "r_loops": 1, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.034852389, "r_other_time_ms": 0.020715696, "filtered": 100, "r_filtered": 100, "index_condition": "u.`status` = 'a'" }, "table": { "table_name": "v", "access_type": "ref", "possible_keys": [ "fk_videos_users_idx", "video_status_idx", "videos_status_index" ], "key": "fk_videos_users_idx", "key_length": "4", "used_key_parts": ["users_id"], "ref": ["AVideo.u.id"], "r_loops": 1, "rows": 391299, "r_rows": 990067, "r_table_time_ms": 2691.791742, "r_other_time_ms": 6129.887127, "filtered": 50.00025558, "r_filtered": 100, "attached_condition": "v.`status` in ('a','k','f')" }, "table": { "table_name": "c", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id"], "ref": ["AVideo.v.categories_id"], "r_loops": 990067, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.00546745, "r_other_time_ms": 0.569425897, "filtered": 100, "r_filtered": 100 } } } } } ``` While for the next: ```sql SELECT * FROM (SELECT u.id as uid , u.user as uuser , u.name as uname , u.email as uemail , u.password as upassword , u.created as ucreated , u.modified as umodified , u.isAdmin as uisAdmin , u.status as ustatus , u.photoURL as uphotoURL , u.lastLogin as ulastLogin , u.recoverPass as urecoverPass , u.backgroundURL as ubackgroundURL , u.canStream as ucanStream , u.canUpload as ucanUpload , u.canCreateMeet as ucanCreateMeet , u.canViewChart as ucanViewChart , u.about as uabout , u.channelName as uchannelName , u.emailVerified as uemailVerified , u.analyticsCode as uanalyticsCode , u.externalOptions as uexternalOptions , u.first_name as ufirst_name , u.last_name as ulast_name , u.address as uaddress , u.zip_code as uzip_code , u.country as ucountry , u.region as uregion , u.city as ucity , u.donationLink as udonationLink , u.extra_info as uextra_info , u.phone as uphone , u.is_company as uis_company , v.*, c.iconClass, c.name as category, c.clean_name as clean_category,c.description as category_description, v.created as videoCreation, v.modified as videoModified FROM videos as v LEFT JOIN categories c ON categories_id = c.id LEFT JOIN users u ON v.users_id = u.id WHERE 2=2 AND v.status IN ('a','k','f') ORDER BY likes DESC ) a WHERE a.ustatus IN ('a') LIMIT 1000, 900; ``` The ANALYZE FORMAT=JSON is the next: ```json { "query_block": { "select_id": 1, "r_loops": 1, "r_total_time_ms": 8.047324959, "table": { "table_name": "u", "access_type": "ref", "possible_keys": ["PRIMARY", "users_status_IDX"], "key": "users_status_IDX", "key_length": "1", "used_key_parts": ["status"], "ref": ["const"], "r_loops": 1, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.045761237, "r_other_time_ms": 0.0201165, "filtered": 100, "r_filtered": 100, "index_condition": "u.`status` = 'a'" }, "table": { "table_name": "v", "access_type": "ref", "possible_keys": [ "fk_videos_users_idx", "video_status_idx", "videos_status_index" ], "key": "fk_videos_users_idx", "key_length": "4", "used_key_parts": ["users_id"], "ref": ["AVideo.u.id"], "r_loops": 1, "rows": 391299, "r_rows": 1900, "r_table_time_ms": 6.939235389, "r_other_time_ms": 1.010973728, "filtered": 50.00025558, "r_filtered": 100, "attached_condition": "v.`status` in ('a','k','f')" }, "table": { "table_name": "c", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id"], "ref": ["AVideo.v.categories_id"], "r_loops": 1900, "rows": 1, "r_rows": 1, "r_table_time_ms": 0.007669714, "r_other_time_ms": 0.001959112, "filtered": 100, "r_filtered": 100 } } } ``` And what I am trying to understand is, what's the difference? Why would the same exact query will result with this issue? Just to notice that the next query will not run at all due to fields naming conflict between u and v: ```sql SELECT * FROM (SELECT u.* , v.*, c.iconClass, c.name as category, c.clean_name as clean_category,c.description as category_description, v.created as videoCreation, v.modified as videoModified FROM videos as v LEFT JOIN categories c ON categories_id = c.id LEFT JOIN users u ON v.users_id = u.id WHERE 2=2 AND v.status IN ('a','k','f') ORDER BY likes DESC ) a WHERE a.ustatus IN ('a') LIMIT 1000, 900; ``` I am not new to the DB world that much but it's the first time I am getting my hands dirty about such an issue. I will share the full DB later on today so it could be used as a learning material. Also, are there any big public databases that can be used for learning and testing purposes? Thanks, Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: ngtech1ltd(a)gmail.com Web: https://ngtech.co.il/ My-Tube: https://tube.ngtech.co.il/

3 10

[Maria-discuss] mariadb-connector-cpp and multiple threads
by jason＠youtorque.com 25 Jul '22

25 Jul '22

Using the [ MariaDB C++ Connector ]( https://github.com/mariadb-corporation/mariadb-connector-cpp ) on ubuntu 20.04, and gcc compiler. During load test of a webserver application it was discovered that anytime there was more than a single concurrent connection the server would crash. This was narrowed down to the connect member of the mariadb driver. The errors that were being reported were always one of the following two: terminate called after throwing an instance of 'std::logic_error' what(): basic_string::_M_construct null not validAborted (core dumped)terminate called after throwing an instance of 'std::invalid_argument' what(): stoiAborted (core dumped) As it wouldn't be feasible to post the source of the server, I have reproduced a minimal working example that uses only standard library and mariadb/conncpp.hpp: ``` #include <mariadb/conncpp.hpp>#include <iostream>#include <thread>#include <string>sql::Driver* driver = sql::mariadb::get_driver_instance();sql::SQLString connectionUrl = "jdbc:mariadb://localhost:3306/the_database_name";sql::Properties properties = {{"user", "the_username"}, {"password", "the_password"}};int main(){ // simulate 2 concurrent connections each making 500 requests std::vector<std::function<void()>> t1cbs; std::vector<std::function<void()>> t2cbs; for(int i = 0; i < 500; i++) // if does not fail for you at 500 up the number until it does { t1cbs.push_back([&]{ std::unique_ptr<sql::Connection> conn(driver->connect(connectionUrl, properties)); std::cout << "t1:" << conn->getHostname().c_str() << std::endl; }); // comment out this block to keep the second thread from executing, and you will see // that no errors occur t2cbs.push_back([&]{ std::unique_ptr<sql::Connection> conn(driver->connect(connectionUrl, properties)); std::cout << "t2:" << conn->getHostname().c_str() << std::endl; }); } std::thread t1([&]{ for(auto& cb : t1cbs) cb(); }); std::thread t2([&]{ for(auto& cb : t2cbs) cb(); }); t1.join(); t2.join(); return 0;} ``` I'm guessing the issue is on my end as I've just started working with this particular library and have probably missed or misunderstood something. Would someone be able to point me in the right direction as far as how I might go about creating database connections from within separate threads?

2 3

Re: [Maria-discuss] mysql_upgrade fails
by Majed Zouhairy 21 Jul '22

21 Jul '22

on centos 8, upgrade form mraidb 10.3 to 10.6 fails with: sudo mysql_upgrade -u root -p Enter password: Major version upgrade detected from 10.3.17-MariaDB to 10.6.8-MariaDB. Check required! Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views Phase 4/7: Running 'mysql_fix_privilege_tables' ERROR 1005 (HY000) at line 694: Can't create table `mysql`.`innodb_table_stats` (errno: 184 "Tablespace already exists") ERROR 1005 (HY000) at line 698: Can't create table `mysql`.`innodb_index_stats` (errno: 184 "Tablespace already exists") ERROR 1005 (HY000) at line 702: Can't create table `mysql`.`transaction_registry` (errno: 184 "Tablespace already exists") ERROR 1005 (HY000) at line 774: Can't create table `mysql`.`gtid_slave_pos` (errno: 184 "Tablespace already exists") FATAL ERROR: Upgrade failed ________________________________ From: Vicențiu Ciorbaru <cvicentiu(a)gmail.com> Sent: Wednesday, April 21, 2021 3:51 PM To: Majed Zouhairy <majedzouhairy(a)hotmail.com> Cc: maria-discuss(a)lists.launchpad.net <maria-discuss(a)lists.launchpad.net> Subject: Re: [Maria-discuss] mysql_upgrade fails Hi Majed, What MariaDB version is this? What is the previous version and what is the current version you are upgrading to? Is this from a linux distro, or where did you get the MariaDB binary from? If it's a distro, which one? Vicențiu On Wed, 21 Apr 2021 at 15:31, Majed Zouhairy <majedzouhairy(a)hotmail.com<mailto:majedzouhairy@hotmail.com>> wrote: in last time's upgrade and today i got: sudo mysql_upgrade -u root -p Enter password: Phase 1/7: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views Phase 4/7: Running 'mysql_fix_privilege_tables' ERROR 1813 (HY000) at line 77: Tablespace for table '`mysql`.`innodb_table_stats`' exists. Please DISCARD the tablespace before IMPORT ERROR 1813 (HY000) at line 81: Tablespace for table '`mysql`.`innodb_index_stats`' exists. Please DISCARD the tablespace before IMPORT ERROR 1813 (HY000) at line 85: Tablespace for table '`mysql`.`transaction_registry`' exists. Please DISCARD the tablespace before IMPORT ERROR 1813 (HY000) at line 153: Tablespace for table '`mysql`.`gtid_slave_pos`' exists. Please DISCARD the tablespace before IMPORT ERROR 1146 (42S02) at line 642: Table 'mysql.innodb_index_stats' doesn't exist ERROR 1243 (HY000) at line 643: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1146 (42S02) at line 645: Table 'mysql.innodb_table_stats' doesn't exist ERROR 1243 (HY000) at line 646: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1146 (42S02) at line 650: Table 'mysql.innodb_index_stats' doesn't exist ERROR 1146 (42S02) at line 654: Table 'mysql.innodb_table_stats' doesn't exist ERROR 1146 (42S02) at line 657: Table 'mysql.innodb_table_stats' doesn't exist FATAL ERROR: Upgrade failed what to do? _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

3 8

[Maria-discuss] Speeding up MyRocks engine
by Jan Křístek 24 Jun '22

24 Jun '22

Hello, I have already given up on MyRocks but could someone give some hint to take back my decision?. I have a setup with a heavy insert load with potentially long records (up to a kilobyte or two). I cannot get more than about 300-400 inserts per second with MyRocks. With the Aria engine, it's reaching up to 1900 inserts/sec with the same setup. The only config changes for MyRocks are: rocksdb-override-cf-options='cf1={compression=kLZ4Compression;bottommost_compression=kLZ4Compression;}' rocksdb_allow_concurrent_memtable_write = ON rocksdb_default_cf_options=block_based_table_factory={cache_index_and_filter_blocks=1;filter_policy=bloomfilter:10:false;whole_key_filtering=1};level_compaction_dynamic_level_bytes=true;optimize_filters_for_hits=true;compaction_pri=kMinOverlappingRatio;compression=kLZ4Compression plugin-load-add=ha_rocksdb.so Both MyRocks and Aria are the same hardware, the same setup SSD with software Raid0 and LVM. With Aria I have switched on aria_group_commit to "soft" with 500 ms delay, as I understand, I might lose some data if the server is hard killed or crashes. I am willing to take the risk unless s/o suggests a major speedup for the MyRocks. I have switched TRANSACTIONAL=1 for the table. The table has partitions on both Aria and MyRocks. Thank you for any help in advance, Jan

1 0

[Maria-discuss] Change delimiter with server_audit plugin
by Philippe Maladjian 22 Jun '22

22 Jun '22

Hi there, In order to monitor a database and especially the requests that could be in error, I activated the server_audit plugin. Plugin setup: show global VARIABLES like '%server_audit%'; +-------------------------------+---------------------------------+ | Variable_name | Value | +-------------------------------+---------------------------------+ | server_audit_events | QUERY | | server_audit_excl_users | user | | server_audit_file_path | /var/log/mysql/server_audti.log | | server_audit_file_rotate_now | OFF | | server_audit_file_rotate_size | 1000000 | | server_audit_file_rotations | 9 | | server_audit_incl_users | user | | server_audit_logging | ON | | server_audit_mode | 0 | | server_audit_output_type | file | | server_audit_query_log_limit | 1024 | | server_audit_syslog_facility | LOG_USER | | server_audit_syslog_ident | mysql-server_auditing | | server_audit_syslog_info | | | server_audit_syslog_priority | LOG_ERR | +-------------------------------+---------------------------------+ My problem is that the separator between each value is the comma and bad luck it's the same separator as in the query. Example of a line: 20220622 08:35:03,sserver,user,localhost,14858,7002875,QUERY,database,'UPDATE sorderq SET `odlqty` = "6", `soqsta` = "3", `sdhnum` = "LIVHIL22062", `sddlin` = 24000 WHERE `sohnum` = "NORHIL220601" AND `soplin` = 24000 AND `soqseq` = 24000',0 [...] 20220622 08:35:03,server,user,localhost,14858,7002878,QUERY,database,'INSERT INTO sdeliveryd(`sdhnum`, `itmref`, `sddlin`, `netprinot`, `qty`, `rtnqty`, `tsicod0`, `tsicod1`, `tsicod2`, `tsicod3`, `tsicod4`, `rep1`) VALUES("LIVHIL22061", "1-11325", 26000, 0.0, "12", "0", "STA", "05", " ", " ", " ", "093")',0 It is the last field that interests me because it is the return code of the request. Now if I want to automate the error processing (last field <> 0) I simply cannot because due to the identical separator between the fields of the request and the fields of the log line, the number of columns varies and the return code never has the same position. Is it possible to change the field separator in the plugin? Thanks in advance

1 0

[Maria-discuss] debug.csr error?
by Dave Pawson 19 Jun '22

19 Jun '22

Using create table. error shown > python createRItbl.py Debug.csr Traceback (most recent call last): File "/home/dpawson/Dropbox/2022/sibc/software/mariadb/createRItbl.py", line 82, in <module> showcsr(csr) File "/home/dpawson/Dropbox/2022/sibc/software/mariadb/createRItbl.py", line 40, in showcsr for item in csr: File "/home/dpawson/.local/lib/python3.10/site-packages/mysql/connector/cursor_cext.py", line 718, in fetchone return self._fetch_row() File "/home/dpawson/.local/lib/python3.10/site-packages/mysql/connector/cursor_cext.py", line 689, in _fetch_row row = self._rows[self._next_row] TypeError: 'NoneType' object is not subscriptable Called from Python. Table= f"CREATE TABLE IF NOT EXISTS rinkincome (\ matchdate DATE ,\ session ENUM('rollup','league','club match') ,\ code ENUM {costcodes} ,\ cashOrCard ENUM('card','cash'),\ amount DECIMAL(5,2) );" where costcodes=('a','b') form. # print Table out to check syntax #print(Table) #sys.exit(0) csr.execute(Table) showcsr(csr) Nothing shown to indicate which list / structure I'm trying to iterate over? Any suggestions to chase down the fault please. Pretty new to mariadb. regards -- Dave Pawson XSLT XSL-FO FAQ. Docbook FAQ.

1 0

[Maria-discuss] Incorrect Documentation: Replicating JSON from MySQL to MariaDB
by Gordan Bobic 29 May '22

29 May '22

On this page: https://mariadb.com/kb/en/json-data-type/ it states: If you must use row-based replication and cannot change the MySQL master from JSON to TEXT, you can try to introduce an intermediate MySQL slave and change the column type from JSON to TEXT on it. Then you replicate from this intermediate slave to MariaDB. I can confirm that this does not work with MySQL 5.7. If you have a 5.7 master and you replicate to 5.7 slave, and you convert the slave's json columns to longtext, replication fails with this error: "Column X of table 'dbname.tablename' cannot be converted from type 'json' to type 'longtext'" Using longblob doesn't work either. So it seems there is currently no viable solution for replicating anything that involves JSON columns from MySQL to MariaDB.

2 2

[Maria-discuss] Custom Galera SST Method Documentation
by Gordan Bobic 27 May '22

27 May '22

Hi, I vaguely remember reading something years ago about implementing a custom SST method, but I cannot seem to find any documentation for it now. Is there any documentation on the interfaces that scripts need to implement and how to hook up said scripts into the config files?

2 2

[Maria-discuss] dpkg: mariadb-client-10.x: dependency problems, but removing anyway as you requested
by William Edwards 25 May '22

25 May '22

Hi, Using the official MariaDB repos, since MariaDB 10.4, mariadb-client-10.x is removed, then installed on 'apt upgrade': ``` Unpacking libmariadb3:amd64 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... dpkg: mariadb-client-10.7: dependency problems, but removing anyway as you requested: mariadb-server-10.7 depends on mariadb-client-10.7 (>= 1:10.7.3+maria~buster). mariadb-client depends on mariadb-client-10.7 (>= 1:10.7.4+maria~buster). (Reading database ... 87804 files and directories currently installed.) Removing mariadb-client-10.7 (1:10.7.3+maria~buster) ... Setting up mysql-common (1:10.7.4+maria~buster) ... Setting up mariadb-common (1:10.7.4+maria~buster) ... (Reading database ... 87703 files and directories currently installed.) Preparing to unpack .../00-mariadb-server-10.7_1%3a10.7.4+maria~buster_amd64.deb ... /var/lib/mysql: found previous version 10.7 Unpacking mariadb-server-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../01-mariadb-server-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-server-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../02-mariadb-client-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Selecting previously unselected package mariadb-client-10.7. Preparing to unpack .../03-mariadb-client-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-10.7 (1:10.7.4+maria~buster) ... ``` This does not seem to be a problem, but I'd like to understand what changed between 10.3 and 10.4 that causes this. Policy output and full 'apt upgrade' transaction log: ``` root@http-msh01:~# apt upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done The following packages will be upgraded: filebeat libavcodec58 libavfilter7 libavformat58 libavutil56 libldap-2.4-2 libldap-common libmariadb-dev libmariadb-dev-compat libmariadb3 libpostproc55 libpq5 libssl-dev libssl1.1 libswresample3 libswscale5 libxml2 mariadb-client mariadb-client-10.7 mariadb-client-core-10.7 mariadb-common mariadb-server mariadb-server-10.7 mariadb-server-core-10.7 mysql-common nodejs openjdk-11-jre openjdk-11-jre-headless openssl php8.1 php8.1-bcmath php8.1-cli php8.1-common php8.1-curl php8.1-dev php8.1-fpm php8.1-gd php8.1-imap php8.1-intl php8.1-mbstring php8.1-mysql php8.1-opcache php8.1-readline php8.1-soap php8.1-sqlite3 php8.1-xml php8.1-zip sensu-go-agent 55 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 142 MB of archives. After this operation, 10.3 MB of additional disk space will be used. Do you want to continue? [Y/n] Get:1 http://security.debian.org/debian-security buster/updates/main amd64 libssl-dev amd64 1.1.1n-0+deb10u2 [1,807 kB] Get:9 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mysql-common all 1:10.7.4+maria~buster [2,880 B] Get:10 http://security.debian.org/debian-security buster/updates/main amd64 libssl1.1 amd64 1.1.1n-0+deb10u2 [1,551 kB] Get:11 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-common all 1:10.7.4+maria~buster [4,052 B] Get:12 http://security.debian.org/debian-security buster/updates/main amd64 libldap-common all 2.4.47+dfsg-3+deb10u7 [90.1 kB] Get:13 http://security.debian.org/debian-security buster/updates/main amd64 libldap-2.4-2 amd64 2.4.47+dfsg-3+deb10u7 [224 kB] Get:14 https://artifacts.elastic.co/packages/7.x/apt stable/main amd64 filebeat amd64 7.17.4 [37.8 MB] Get:15 http://security.debian.org/debian-security buster/updates/main amd64 libavfilter7 amd64 7:4.1.9-0+deb10u1 [1,053 kB] Get:16 https://packages.sury.org/php buster/main amd64 libxml2 amd64 2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45 [701 kB] Get:17 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-server all 1:10.7.4+maria~buster [2,832 B] Get:18 http://security.debian.org/debian-security buster/updates/main amd64 libswscale5 amd64 7:4.1.9-0+deb10u1 [209 kB] Get:19 http://security.debian.org/debian-security buster/updates/main amd64 libavformat58 amd64 7:4.1.9-0+deb10u1 [1,019 kB] Get:20 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-client all 1:10.7.4+maria~buster [2,704 B] Get:21 http://security.debian.org/debian-security buster/updates/main amd64 libavcodec58 amd64 7:4.1.9-0+deb10u1 [4,810 kB] Get:22 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 libmariadb-dev amd64 1:10.7.4+maria~buster [158 kB] Get:23 https://packages.sury.org/php buster/main amd64 php8.1-bcmath amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [15.4 kB] Get:24 https://packages.sury.org/php buster/main amd64 php8.1-zip amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [24.2 kB] Get:25 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 libmariadb-dev-compat amd64 1:10.7.4+maria~buster [3,084 B] Get:26 https://packages.sury.org/php buster/main amd64 php8.1-xml amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [107 kB] Get:27 https://packages.sury.org/php buster/main amd64 php8.1-sqlite3 amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [29.3 kB] Get:28 https://packages.sury.org/php buster/main amd64 php8.1-soap amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [120 kB] Get:29 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 libmariadb3 amd64 1:10.7.4+maria~buster [148 kB] Get:30 https://packages.sury.org/php buster/main amd64 php8.1-readline amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [12.6 kB] Get:31 https://packages.sury.org/php buster/main amd64 php8.1-opcache amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [332 kB] Get:32 https://packages.sury.org/php buster/main amd64 php8.1-mysql amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [116 kB] Get:33 https://packages.sury.org/php buster/main amd64 php8.1-mbstring amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [396 kB] Get:34 https://packages.sury.org/php buster/main amd64 php8.1-intl amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [127 kB] Get:35 https://packages.sury.org/php buster/main amd64 php8.1-imap amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [32.6 kB] Get:36 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-client-core-10.7 amd64 1:10.7.4+maria~buster [832 kB] Get:37 https://packages.sury.org/php buster/main amd64 php8.1-gd amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [28.5 kB] Get:38 https://packages.sury.org/php buster/main amd64 php8.1-dev amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [488 kB] Get:39 https://packages.sury.org/php buster/main amd64 php8.1-curl amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [34.4 kB] Get:40 https://packages.sury.org/php buster/main amd64 php8.1-fpm amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [1,672 kB] Get:41 http://security.debian.org/debian-security buster/updates/main amd64 libswresample3 amd64 7:4.1.9-0+deb10u1 [112 kB] Get:42 http://security.debian.org/debian-security buster/updates/main amd64 libpostproc55 amd64 7:4.1.9-0+deb10u1 [108 kB] Get:43 http://security.debian.org/debian-security buster/updates/main amd64 libavutil56 amd64 7:4.1.9-0+deb10u1 [244 kB] Get:44 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-server-10.7 amd64 1:10.7.4+maria~buster [3,461 kB] Get:45 https://packages.sury.org/php buster/main amd64 php8.1-cli amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [1,662 kB] Get:46 http://security.debian.org/debian-security buster/updates/main amd64 libpq5 amd64 11.16-0+deb10u1 [172 kB] Get:47 https://packages.sury.org/php buster/main amd64 php8.1-common amd64 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [660 kB] Get:48 http://security.debian.org/debian-security buster/updates/main amd64 openjdk-11-jre amd64 11.0.15+10-1~deb10u1 [174 kB] Get:49 https://packages.sury.org/php buster/main amd64 php8.1 all 8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1 [24.7 kB] Get:50 http://security.debian.org/debian-security buster/updates/main amd64 openjdk-11-jre-headless amd64 11.0.15+10-1~deb10u1 [37.2 MB] Get:51 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-client-10.7 amd64 1:10.7.4+maria~buster [2,411 kB] Get:52 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 mariadb-server-core-10.7 amd64 1:10.7.4+maria~buster [7,153 kB] Get:53 https://packagecloud.io/sensu/stable/debian buster/main amd64 sensu-go-agent amd64 6.7.2-6283 [6,975 kB] Get:54 http://security.debian.org/debian-security buster/updates/main amd64 openssl amd64 1.1.1n-0+deb10u2 [855 kB] Get:55 https://deb.nodesource.com/node_16.x buster/main amd64 nodejs amd64 16.15.0-deb-1nodesource1 [26.4 MB] Fetched 142 MB in 6s (24.2 MB/s) Reading changelogs... Done Extracting templates from packages: 100% Preconfiguring packages ... (Reading database ... 87804 files and directories currently installed.) Preparing to unpack .../0-mysql-common_1%3a10.7.4+maria~buster_all.deb ... Unpacking mysql-common (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../1-mariadb-common_1%3a10.7.4+maria~buster_all.deb ... Unpacking mariadb-common (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../2-mariadb-server_1%3a10.7.4+maria~buster_all.deb ... Unpacking mariadb-server (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../3-mariadb-client_1%3a10.7.4+maria~buster_all.deb ... Unpacking mariadb-client (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../4-libmariadb-dev_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking libmariadb-dev (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../5-libmariadb-dev-compat_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking libmariadb-dev-compat:amd64 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../6-libssl-dev_1.1.1n-0+deb10u2_amd64.deb ... Unpacking libssl-dev:amd64 (1.1.1n-0+deb10u2) over (1.1.1n-0+deb10u1) ... Preparing to unpack .../7-libssl1.1_1.1.1n-0+deb10u2_amd64.deb ... Unpacking libssl1.1:amd64 (1.1.1n-0+deb10u2) over (1.1.1n-0+deb10u1) ... Preparing to unpack .../8-libmariadb3_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking libmariadb3:amd64 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... dpkg: mariadb-client-10.7: dependency problems, but removing anyway as you requested: mariadb-server-10.7 depends on mariadb-client-10.7 (>= 1:10.7.3+maria~buster). mariadb-client depends on mariadb-client-10.7 (>= 1:10.7.4+maria~buster). (Reading database ... 87804 files and directories currently installed.) Removing mariadb-client-10.7 (1:10.7.3+maria~buster) ... Setting up mysql-common (1:10.7.4+maria~buster) ... Setting up mariadb-common (1:10.7.4+maria~buster) ... (Reading database ... 87703 files and directories currently installed.) Preparing to unpack .../00-mariadb-server-10.7_1%3a10.7.4+maria~buster_amd64.deb ... /var/lib/mysql: found previous version 10.7 Unpacking mariadb-server-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../01-mariadb-server-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-server-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Preparing to unpack .../02-mariadb-client-core-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-core-10.7 (1:10.7.4+maria~buster) over (1:10.7.3+maria~buster) ... Selecting previously unselected package mariadb-client-10.7. Preparing to unpack .../03-mariadb-client-10.7_1%3a10.7.4+maria~buster_amd64.deb ... Unpacking mariadb-client-10.7 (1:10.7.4+maria~buster) ... Preparing to unpack .../04-libldap-common_2.4.47+dfsg-3+deb10u7_all.deb ... Unpacking libldap-common (2.4.47+dfsg-3+deb10u7) over (2.4.47+dfsg-3+deb10u6) ... Preparing to unpack .../05-libldap-2.4-2_2.4.47+dfsg-3+deb10u7_amd64.deb ... Unpacking libldap-2.4-2:amd64 (2.4.47+dfsg-3+deb10u7) over (2.4.47+dfsg-3+deb10u6) ... Preparing to unpack .../06-libavfilter7_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavfilter7:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../07-libswscale5_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libswscale5:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../08-libavformat58_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavformat58:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../09-libavcodec58_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavcodec58:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../10-libswresample3_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libswresample3:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../11-libpostproc55_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libpostproc55:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../12-libavutil56_7%3a4.1.9-0+deb10u1_amd64.deb ... Unpacking libavutil56:amd64 (7:4.1.9-0+deb10u1) over (7:4.1.8-0+deb10u1) ... Preparing to unpack .../13-libxml2_2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45_amd64.deb ... Unpacking libxml2:amd64 (2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45) over (2.9.13+dfsg-0+0~20220410.11+debian10~1.gbp692312) ... Preparing to unpack .../14-libpq5_11.16-0+deb10u1_amd64.deb ... Unpacking libpq5:amd64 (11.16-0+deb10u1) over (11.14-0+deb10u1) ... Preparing to unpack .../15-nodejs_16.15.0-deb-1nodesource1_amd64.deb ... Unpacking nodejs (16.15.0-deb-1nodesource1) over (16.14.2-deb-1nodesource1) ... Preparing to unpack .../16-openjdk-11-jre_11.0.15+10-1~deb10u1_amd64.deb ... Unpacking openjdk-11-jre:amd64 (11.0.15+10-1~deb10u1) over (11.0.14+9-1~deb10u1) ... Preparing to unpack .../17-openjdk-11-jre-headless_11.0.15+10-1~deb10u1_amd64.deb ... Unpacking openjdk-11-jre-headless:amd64 (11.0.15+10-1~deb10u1) over (11.0.14+9-1~deb10u1) ... Preparing to unpack .../18-openssl_1.1.1n-0+deb10u2_amd64.deb ... Unpacking openssl (1.1.1n-0+deb10u2) over (1.1.1n-0+deb10u1) ... Preparing to unpack .../19-php8.1-bcmath_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-bcmath (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../20-php8.1-zip_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-zip (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../21-php8.1-xml_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-xml (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../22-php8.1-sqlite3_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-sqlite3 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../23-php8.1-soap_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-soap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../24-php8.1-readline_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-readline (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../25-php8.1-opcache_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-opcache (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../26-php8.1-mysql_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-mysql (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../27-php8.1-mbstring_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-mbstring (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../28-php8.1-intl_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-intl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../29-php8.1-imap_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-imap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../30-php8.1-gd_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-gd (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../31-php8.1-dev_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-dev (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../32-php8.1-curl_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-curl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../33-php8.1-fpm_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-fpm (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../34-php8.1-cli_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-cli (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../35-php8.1-common_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_amd64.deb ... Unpacking php8.1-common (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../36-php8.1_8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1_all.deb ... Unpacking php8.1 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) over (8.1.5-1+0~20220422.16+debian10~1.gbpfcaf04) ... Preparing to unpack .../44-sensu-go-agent_6.7.2-6283_amd64.deb ... Unpacking sensu-go-agent (6.7.2-6283) over (6.7.0-6196) ... Preparing to unpack .../45-filebeat_7.17.4_amd64.deb ... Unpacking filebeat (7.17.4) over (7.17.3) ... Setting up libssl1.1:amd64 (1.1.1n-0+deb10u2) ... Setting up openjdk-11-jre-headless:amd64 (11.0.15+10-1~deb10u1) ... Setting up openjdk-11-jre:amd64 (11.0.15+10-1~deb10u1) ... Setting up nodejs (16.15.0-deb-1nodesource1) ... Setting up libldap-common (2.4.47+dfsg-3+deb10u7) ... Setting up libavutil56:amd64 (7:4.1.9-0+deb10u1) ... Setting up libssl-dev:amd64 (1.1.1n-0+deb10u2) ... Setting up libpostproc55:amd64 (7:4.1.9-0+deb10u1) ... Setting up libmariadb3:amd64 (1:10.7.4+maria~buster) ... Setting up libmariadb-dev (1:10.7.4+maria~buster) ... Setting up sensu-go-agent (6.7.2-6283) ... Setting up libswscale5:amd64 (7:4.1.9-0+deb10u1) ... Setting up mariadb-server-core-10.7 (1:10.7.4+maria~buster) ... Setting up filebeat (7.17.4) ... Installing new version of config file /etc/filebeat/filebeat.reference.yml ... Configuration file '/etc/filebeat/filebeat.yml' ==> Modified (by you or by a script) since installation. ==> Package distributor has shipped an updated version. What would you like to do about it ? Your options are: Y or I : install the package maintainer's version N or O : keep your currently-installed version D : show the differences between the versions Z : start a shell to examine the situation The default action is to keep your current version. *** filebeat.yml (Y/I/N/O/D/Z) [default=N] ? Installing new version of config file /etc/filebeat/modules.d/azure.yml.disabled ... Setting up openssl (1.1.1n-0+deb10u2) ... Setting up libxml2:amd64 (2.9.14+dfsg-0+0~20220524.12+debian10~1.gbpc5dc45) ... Setting up libmariadb-dev-compat:amd64 (1:10.7.4+maria~buster) ... Installing all pip dependencies Requirement already satisfied: pika==1.2.0 in /usr/local/lib/python3.7/dist-packages (1.2.0) Setting up php8.1-common (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-imap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-gd (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libldap-2.4-2:amd64 (2.4.47+dfsg-3+deb10u7) ... Setting up libswresample3:amd64 (7:4.1.9-0+deb10u1) ... Setting up php8.1-curl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-sqlite3 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-xml (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-soap (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up mariadb-client-core-10.7 (1:10.7.4+maria~buster) ... Setting up php8.1-mysql (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-zip (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libavcodec58:amd64 (7:4.1.9-0+deb10u1) ... Setting up php8.1-readline (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up mariadb-client-10.7 (1:10.7.4+maria~buster) ... Setting up php8.1-opcache (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-intl (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-bcmath (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up mariadb-client (1:10.7.4+maria~buster) ... Setting up php8.1-mbstring (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libavformat58:amd64 (7:4.1.9-0+deb10u1) ... Setting up libpq5:amd64 (11.16-0+deb10u1) ... Setting up mariadb-server-10.7 (1:10.7.4+maria~buster) ... Installing new version of config file /etc/mysql/debian-start ... mariadb-extra.socket is a disabled or a static unit not running, not starting it. mariadb-extra.socket is a disabled or a static unit, not starting it. Setting up php8.1-cli (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1-dev (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up libavfilter7:amd64 (7:4.1.9-0+deb10u1) ... Setting up mariadb-server (1:10.7.4+maria~buster) ... Setting up php8.1-fpm (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Setting up php8.1 (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Processing triggers for hicolor-icon-theme (0.17-2) ... Processing triggers for libc-bin (2.28-10+deb10u1) ... Processing triggers for systemd (241-7~deb10u8) ... Processing triggers for man-db (2.8.5-2) ... Processing triggers for mime-support (3.62) ... Processing triggers for php8.1-cli (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... Processing triggers for php8.1-fpm (8.1.6-1+0~20220517.17+debian10~1.gbp6b3bd1) ... root@http-msh02:~# apt-cache policy libmariadb-dev libmariadb-dev-compat libmariadb3 mariadb-client mariadb-client-10.7 mariadb-client-core-10.7 mariadb-common mariadb-server mariadb-server-10.7 mariadb-server-core-10.7 mysql-common libmariadb-dev: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages libmariadb-dev-compat: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages libmariadb3: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-client: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-client-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mariadb-client-core-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mariadb-common: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-server: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 1:10.3.34-0+deb10u1 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages 1:10.3.25-0+deb10u1 500 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages mariadb-server-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mariadb-server-core-10.7: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages mysql-common: Installed: 1:10.7.3+maria~buster Candidate: 1:10.7.4+maria~buster Version table: 1:10.7.4+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages *** 1:10.7.3+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 100 /var/lib/dpkg/status 1:10.7.1+maria~buster 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages 5.8+1.0.5 500 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages root@http-msh02:~# apt-cache policy Package files: 100 /var/lib/dpkg/status release a=now 500 https://packages.sury.org/php buster/main amd64 Packages release o=deb.sury.org,a=buster,n=buster,c=main,b=amd64 origin packages.sury.org 500 https://packagecloud.io/sensu/stable/debian buster/main amd64 Packages release v=1,o=packagecloud.io/sensu/stable,a=buster,n=buster,l=stable,c=main,b=amd64 origin packagecloud.io 500 http://nginx.org/packages/mainline/debian buster/nginx amd64 Packages release v=10.0,o=nginx,a=stable,n=buster,l=nginx,c=nginx,b=amd64 origin nginx.org 100 http://debmirror.tuxis.nl/debian buster-backports/main amd64 Packages release o=Debian Backports,a=buster-backports,n=buster-backports,l=Debian Backports,c=main,b=amd64 origin debmirror.tuxis.nl 500 https://deb.nodesource.com/node_16.x buster/main amd64 Packages release o=Node Source,n=buster,l=Node Source,c=main,b=amd64 origin deb.nodesource.com 500 https://artifacts.elastic.co/packages/7.x/apt stable/main amd64 Packages release o=elastic,a=stable,n=stable,l=. stable,c=main,b=amd64 origin artifacts.elastic.co 500 https://apt.tuxis.nl/tuxis monitoring/main amd64 Packages release o=tuxis monitoring,a=monitoring,n=monitoring,l=tuxis monitoring,c=main,b=amd64 origin apt.tuxis.nl 500 https://apt.tuxis.nl/tuxis tuxis-cron/main amd64 Packages release o=tuxis tuxis-cron,a=tuxis-cron,n=tuxis-cron,l=tuxis tuxis-cron,c=main,b=amd64 origin apt.tuxis.nl 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main ppc64el Packages release o=MariaDB,n=buster,l=MariaDB,c=main,b=ppc64el origin ams2.mirrors.digitalocean.com 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main arm64 Packages release o=MariaDB,n=buster,l=MariaDB,c=main,b=arm64 origin ams2.mirrors.digitalocean.com 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.7/debian buster/main amd64 Packages release o=MariaDB,n=buster,l=MariaDB,c=main,b=amd64 origin ams2.mirrors.digitalocean.com 500 http://debmirror.tuxis.nl/debian buster-updates/main amd64 Packages release o=Debian,a=oldstable-updates,n=buster-updates,l=Debian,c=main,b=amd64 origin debmirror.tuxis.nl 500 http://security.debian.org/debian-security buster/updates/main amd64 Packages release v=10,o=Debian,a=oldstable,n=buster,l=Debian-Security,c=main,b=amd64 origin security.debian.org 500 http://debmirror.tuxis.nl/debian buster/main amd64 Packages release v=10.12,o=Debian,a=oldstable,n=buster,l=Debian,c=main,b=amd64 origin debmirror.tuxis.nl Pinned packages: ``` -- With kind regards, William Edwards

1 0

[Maria-discuss] In memory DB, how to in MariaDB?
by Eliezer Croitoru 23 May '22

23 May '22

I have seen the next blog post which had a video at 2014: https://blogs.oracle.com/pcoe/post/the-future-of-the-database-begins The demo video was removed from YouTube for some reason but I had a copy of it at: https://cloud1.ngtech.co.il/static/oracle/Oracle%20Database%20In-Memory%20Po wering%20the%20Real-Time%20Enterprise%20.mp4 I am not a MariaDB or MySQL or DB in general expert and was wondering if there is something these days in MariaDB that can be used in comparison to what Oracle DB demo shows? I have used LevelDB as a backend in a customized DB and it worked very very fast and it is great. With batches it works even faster but in general it works faster then standard MariaDB setups I have implemented. So what are the options? I have millions of values and I would like to be able to insert and select as fast as possible on a single DB Server. Currently I am using a Caching tier with a specific TTL to lower the stress off the DB, but, is I possible to make the DB Faster like maybe with some writeback (leaving aside fault tolerance for speed). Thanks, Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: <mailto:ngtech1ltd@gmail.com> ngtech1ltd(a)gmail.com

3 4

[Maria-discuss] Debian revision should not contain codename
by William Edwards 19 May '22

19 May '22

Hi, I'm attempting to upgrade a machine with MariaDB 10.6 from Buster to Bullseye using the official MariaDB repo. I was surprised to see that apt wanted to downgrade a few packages: ``` $ apt upgrade --without-new-pkgs The following packages will be DOWNGRADED: libmariadb-dev libmariadb-dev-compat libmariadb3 mysql-common ``` I was confused at first, as the priority of the candidate is higher, and the epoch is unchanged, and the upstream version is unchanged: ``` $ apt policy mysql-common mysql-common: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main ppc64el Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main ppc64el Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main arm64 Packages 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main ppc64el Packages 5.8+1.0.7 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages $ apt policy libmariadb3 libmariadb3: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.5.15-0+deb11u1 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages $ apt policy libmariadb-dev-compat libmariadb-dev-compat: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.5.15-0+deb11u1 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages $ apt policy libmariadb-dev libmariadb-dev: Installed: 1:10.6.7+maria~buster Candidate: 1:10.6.7+maria~bullseye Version table: *** 1:10.6.7+maria~buster 100 100 /var/lib/dpkg/status 1:10.6.7+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.5+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.6.4+maria~bullseye 1000 1000 http://ams2.mirrors.digitalocean.com/mariadb/repo/10.6/debian bullseye/main amd64 Packages 1:10.5.15-0+deb11u1 500 500 http://debmirror.tuxis.nl/debian bullseye/main amd64 Packages ``` A simulation also reported that apt would 'downgrade' to the same versions: ``` $ apt upgrade --without-new-pkgs -s Inst libmariadb-dev [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [amd64]) [] Inst libmariadb-dev-compat [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [amd64]) [] Inst libmariadb3 [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [amd64]) Inst mysql-common [1:10.6.7+maria~buster] (1:10.6.7+maria~bullseye MariaDB:ams2.mirrors.digitalocean.com [all]) ``` Some folks on IRC pointed me to the fact that the Debian revision has been updated from `maria~buster` to `maria~bullseye`. The following documentation at https://www.debian.org/doc/debian-policy/ch-controlfields.html#special-vers… says: > The lexical comparison is a comparison of ASCII values modified so that > all the letters sort earlier than all the non-letters and so that a > tilde sorts before anything, even the end of a part. 'bul' comes before 'bus', so the package for Bullseye is perceived as older, despite it being the same effective upstream version... According to https://www.debian.org/doc/debian-policy/ch-controlfields.html#special-vers…, the Debian revision should NOT contain the Debian release codename. This problem will re-appear with Bookworm. Could the package maintainer(s) attend to this? -- With kind regards, William Edwards

2 2

Re: [Maria-discuss] MariaDB latest source tarballs missing
by Sergei Golubchik 19 May '22

19 May '22

Hi, Shreenidhi, On May 19, Shreenidhi Shedi wrote: > > I am from VMware Photon OS engineering team. > > We are trying to fix few CVEs that are being reported in 10.2.x & > 10.3.x versions of MariaDB. > > There is release note for v10.2.44 but I cannot find the source > tarball in downloads page or in github tags of maria db server. You cannot find it, because it wasn't released yet. > https://mariadb.com/kb/en/mariadb-10244-release-notes/ This page says, on the very top, in a red box: Note: This page describes features in the source repository for MariaDB 10.2. There are currently no official packages or binaries available for download which contain the features. If you want to try out any of the new features described here you will need to get and compile the code yourself. > Can you guys please help me out here? Where can I get the latest > released source tarballs? https://mariadb.org/download/ > Also, when can we expect a fix for this? If at all this is not > released, when can we expect next release of MariaDB server versions? Any day now. Regards, Sergei VP of MariaDB Server Engineering and security(a)mariadb.org

1 0

[Maria-discuss] Galera: jump through major versions at once
by William Edwards 19 May '22

19 May '22

Hi, Does Galera support rolling upgrades between multiple major versions? I will be upgrading my Galera cluster from MariaDB 10.3.34 to 10.6.x. It'd save a lot of time to jump straight from 10.3 to 10.6 instead of upgrading 10.3 -> 10.4 -> 10.5 -> 10.6. The documentation at https://mariadb.com/kb/en/upgrading-from-mariadb-103-to-mariadb-104-with-ga… implies that the MariaDB version is irrelevant, and only the Galera version matters. > Next, make sure that the Galera version numbers are compatible. > > If you are upgrading from the most recent MariaDB 10.3 release to > MariaDB 10.4, then the versions will > be compatible. MariaDB 10.3 uses Galera 3 (i.e. Galera wsrep provider > versions 25.3.x), and MariaDB > 10.4 uses Galera 4 (i.e. Galera wsrep provider versions 26.4.x). This > means that upgrading to MariaDB > 10.4 also upgrades the system to Galera 4. However, Galera 3 and Galera > 4 should be compatible for the > purposes of a rolling upgrade, as long as you are using Galera 26.4.2 > or later. -- With kind regards, William Edwards

2 3

[Maria-discuss] FLUSH TABLES ... FOR EXPORT SLOW
by mariadb＠Biblestuph.com 18 May '22

18 May '22

I've recently updated from 10.3.14 => 10.6.7, and am running into an issue where FLUSH TABLES ... FOR EXPORT is sometimes very slow on large tables. One particular table that it seems to happen on often is over 20G. It doesn't hang, per se; it will complete eventually, but can take an hour or more. 2022-05-17 0:14:06 105636 [Note] InnoDB: Sync to disk of `MyDB`.`t1` started. 2022-05-17 0:14:06 105636 [Note] InnoDB: Writing table metadata to './MyDB/t1.cfg' 2022-05-17 0:14:06 105636 [Note] InnoDB: Table `MyDB`.`t1` flushed to disk 2022-05-17 0:14:06 105636 [Note] InnoDB: Sync to disk of `MyDB`.`t2` started. 2022-05-17 1:49:53 105636 [Note] InnoDB: Writing table metadata to './MyDB/t2.cfg' 2022-05-17 1:49:53 105636 [Note] InnoDB: Table `MyDB`.`t2` flushed to disk in the above the obfuscated table name t2 took about 1.5 hours to complete. In the previous version (10.3.14), these were always nearly instantaneous, even for the largest tables. At the time I'm executing the FLUSH TABLES the slave is stopped on the DB and there are no other users logged in to the DB (other than myself). I know from the docs that FLUSH TABLES has seen changes since my previous version, but I'm not clear as to what the process is waiting for (or how to avoid it). Shutting down the server first (I have innodb_fast_shutdown = 0) seems to prevent it; and the shutdown generally only takes 5-10 minutes or so. But I'd rather not shutdown if I don't have to (and I'm not 100% convinced that I won't someday see the issue in that scenario, as well). I've also tried this sequence thinking it might help: ---> STOP SLAVE Wed May 18 10:30:13 2022 ---> SLAVE STOPPED Wed May 18 10:30:13 2022 ---> FLUSH LOCAL TABLES WITH READ LOCK Wed May 18 10:30:14 2022 ---> UNLOCK TABLES Wed May 18 10:30:15 2022 ---> SET GLOBAL innodb_purge_rseg_truncate_frequency = 1 Wed May 18 10:30:15 2022 ---> SET GLOBAL innodb_max_purge_lag_wait = 0 Wed May 18 10:30:15 2022 ---> FLUSH TABLES ... FOR EXPORT Wed May 18 10:30:15 2022 but the FLUSH TABLES FOR EXPORT still waits on that large table. Is there a way to make this happen quicker without requiring the DB to be shutdown first? Or am I missing something else in the process? Thanks, Dan

1 0

[Maria-discuss] A federation bug was identified.
by 최혁규 11 May '22

11 May '22

A federation bug was identified. I have confirmed that the select where query does not work in the multi index field of some federated tables. A field in the table is used as a multi index. My server version : 10.8.2-MariaDB However, there is no problem with the server used in the previous version. The previous version is Server version: 10.5.10-MariaDB. The tested method was compared by creating a federated table on two servers with different versions. 1. 10.5.10 - MariaDB -> All queries are normally searched. 2. 10.8.2 - MariaDB -> Symptoms were confirmed in some multi index types. --> The table field datatype is (int, datetime) This is the table I created and the select query. Table Created CREATE TABLE `fd_partner_detail` ( `partner_id` varchar(100) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '파트너ID', `business_name` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '사업자상호명', `business_no` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '사업자번호', `online_marketing_business_no` varchar(45) NOT NULL DEFAULT '' COMMENT '통신판매업 신고번호', `representative` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '대표자명', `business_category` char(50) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '종목', `business_status` char(50) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '업종형태', `contact` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '연락처', `courier_code` varchar(45) NOT NULL DEFAULT '0' COMMENT '택배사코드', `postal_code` varchar(45) DEFAULT NULL COMMENT '우편번호', `address` varchar(45) DEFAULT NULL COMMENT '주소(도로명)', `address_detail` varchar(45) DEFAULT NULL COMMENT '상세주소', `officer` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '대표담당자명', `officer_contact` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '대표담당자연락처', `officer_email` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '대표담당자이메일', `order_officer` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '발주담당자명', `order_officer_contact` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '발주담당자연락처', `order_officer_email` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '발주담당자이메일', `calculate_order_officer` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '정산담당자명', `calculate_officer_contact` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '정산담당자연락처', `calculate_officer_email` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '정산담당자이메일', `cs_order_officer` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT 'CS담당자명', `cs_officer_contact` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT 'CS담당자연락처', `cs_officer_email` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT 'CS담당자이메일', `product_name` varchar(100) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '대표상품명', `product_url` varchar(255) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT '대표상품URL', `product_type` int(1) NOT NULL DEFAULT 0 COMMENT '대표상품제조구분 (1: 제조, 2:벤더)', `add_product_name_1` varchar(100) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '선택상품명1', `add_product_url_1` varchar(255) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '선택상품URL1', `add_product_type_1` int(1) DEFAULT 0 COMMENT '선택상품제조구분1', `add_product_name_2` varchar(100) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '선택상품명2', `add_product_url_2` varchar(255) CHARACTER SET utf8mb3 DEFAULT '' COMMENT '선택상품URL2', `add_product_type_2` int(1) DEFAULT 0 COMMENT '선택상품제조구분2', `calculate_bank_code` varchar(45) NOT NULL DEFAULT '' COMMENT '정산은행코드', `calculate_bank_no` varchar(45) NOT NULL DEFAULT '' COMMENT '정산계좌번호', `calculate_bank_name` varchar(45) NOT NULL DEFAULT '' COMMENT '정산예금주명', `file_bankbook` varchar(255) DEFAULT '' COMMENT '통장사본', `original_bankbook` varchar(255) DEFAULT '' COMMENT '통장사본원본명', `file_business_license` varchar(255) DEFAULT '' COMMENT '사업자등록증', `original_business_license` varchar(255) DEFAULT '' COMMENT '사업자등록증원본명', `file_document` varchar(255) DEFAULT '' COMMENT '기타서류', `original_document` varchar(255) DEFAULT '' COMMENT '기타서류원본명', `is_terms_service` int(1) NOT NULL DEFAULT 0 COMMENT '쇼핑몰이용약관동의여부', `is_privacy_consent` int(1) NOT NULL DEFAULT 0 COMMENT '개인정보처리방침동의여부', `join_status` int(1) NOT NULL DEFAULT 1 COMMENT '가입승인상태(1: 입점대기, 2: 입점반려, 3:입점승인, 4:입점불가)', `return_cause` text CHARACTER SET utf8mb3 DEFAULT NULL COMMENT '가입반려사유', `calculate_type` int(1) NOT NULL DEFAULT 1 COMMENT '정산주기유형(1:15일, 2:30일)', `dormant_change_date` datetime DEFAULT NULL COMMENT '휴면전환일', `dormant_cancel_date` datetime DEFAULT NULL COMMENT '휴면해제일', `join_date` datetime DEFAULT NULL COMMENT '가입승인일', `is_withdraw` int(1) NOT NULL DEFAULT 0 COMMENT '탈퇴회원여부', `introduce` text DEFAULT NULL COMMENT '회사소개', `memo` varchar(255) DEFAULT '' COMMENT '관리자 메모', `corporation_code` varchar(45) CHARACTER SET utf8mb3 NOT NULL COMMENT '회사코드', `marketplace_code` varchar(45) CHARACTER SET utf8mb3 NOT NULL COMMENT '쇼핑몰코드', `is_abolished` int(1) NOT NULL DEFAULT 0 COMMENT '삭제여부', `is_popup` int(1) DEFAULT 0 COMMENT '입점 승인', `application_code` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT '어플리케이션코드', `created_by` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT '생성자', `created_date` datetime DEFAULT NULL COMMENT '생성일', `modified_by` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT '수정자', `modified_date` datetime DEFAULT NULL COMMENT '수정일', `abolished_by` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT '삭제자', `abolished_date` datetime DEFAULT NULL COMMENT '삭제일', PRIMARY KEY (`partner_id`), KEY `IDX_R_1` (`is_abolished`), KEY `IDX_R_2` (`created_date`), KEY `IDX_U_1` (`courier_code`), KEY `IDX_U_2` (`postal_code`), KEY `IDX_U_3` (`calculate_bank_code`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='파트너상세정보' CONNECTION='fdc_partner_bh/fo_partner_detail' Table Select Query SELECT business_no, representative, business_name, contact, partner_id ,is_abolished FROM fd_partner_detail WHERE created_date = '1'; Select Query Result business_no representative business_name contact partner_id is_abolished ----------- -------------- ------------- ------- ---------- -------------- I want to know if what I checked is a bug.

2 1

[Maria-discuss] mariabackup is slow (log scanned up to)
by John Pace 29 Apr '22

29 Apr '22

Hi, I am using mariabackup to backup a database. On day 1 a full backup with mariabackup --backup --user=Backup --password=my-password --target-dir=path-to-full and on day 2-7 a incremental backup with mariabackup --backup --user=Backup --password=my-password --target-dir=path-to-inc --incremental-basedir=path-to-full Then follows again a new backup for day 1 and so on. The database can be used while the backup is running. A web application for Apache Tomcat uses the database. This worked very well for a couple of weeks, the backup was finished within 20 minutes. But recently I noticed that the incremental backup took much longer than before. I checked the output of mariabackup and it was spammed several hours with lines like these [00] 2022-04-20 00:48:00 >> log scanned up to (1747989580536) [00] 2022-04-20 00:48:01 >> log scanned up to (1747989580536) [00] 2022-04-20 00:48:02 >> log scanned up to (1747989580536) 2022-04-20 0:48:03 0 [Note] InnoDB: Read redo log up to LSN=1747989580800 [00] 2022-04-20 00:48:03 >> log scanned up to (1747989580536) [00] 2022-04-20 00:48:04 >> log scanned up to (1747989580536) [00] 2022-04-20 00:48:05 >> log scanned up to (1747989580536) [00] 2022-04-20 00:48:06 >> log scanned up to (1747989580536) Yesterday the incremental backup took 7 hours so I wonder if there is something wrong. MariaDB shows no error in the log: 2022-03-15 8:35:48 0 [Note] InnoDB: Using Linux native AIO 2022-03-15 8:35:48 0 [Note] InnoDB: Uses event mutexes 2022-03-15 8:35:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-03-15 8:35:48 0 [Note] InnoDB: Number of pools: 1 2022-03-15 8:35:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-03-15 8:35:48 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-03-15 8:35:48 0 [Note] InnoDB: Completed initialization of buffer pool 2022-03-15 8:35:48 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2022-03-15 8:35:49 0 [Note] InnoDB: 128 rollback segments are active. 2022-03-15 8:35:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-03-15 8:35:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-03-15 8:35:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-03-15 8:35:49 0 [Note] InnoDB: 10.5.8 started; log sequence number 1741176510061; transaction id 38228169 2022-03-15 8:35:49 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-03-15 8:35:49 0 [Note] InnoDB: Loading buffer pool(s) from /path-to-database/ib_buffer_pool 2022-03-15 8:35:49 0 [Note] Server socket created on IP: '::'. 2022-03-15 8:35:50 0 [Note] InnoDB: Buffer pool(s) load completed at 220315 8:35:50 2022-03-15 8:35:50 0 [Note] /path-to-mariadb/bin/mariadbd: ready for connections. Version: '10.5.8-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server PS: Sorry for my test-post. ------------------------------------------------------------------------------------------------- FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT

1 0

[Maria-discuss] test
by John Pace 29 Apr '22

29 Apr '22

------------------------------------------------------------------------------------------------- FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT

1 0

[Maria-discuss] Understanding SQL queries
by João Paulo Almeida 14 Apr '22

14 Apr '22

Dear MariaDB Users, We are currently carrying out some research on the understanding and usability of different relational schemas (as part of a Ph.D. student's thesis work). We would like to invite you to contribute to this research by answering a small number of questions on SQL query interpretation. Participation is via an anonymous form and there are only 7 questions, so it should not take more than 10 minutes of your time: https://forms.gle/EA2jYGf4CTmLfEiaA We thank you in advance and would appreciate it if you could also share this research with colleagues who also have a background on SQL. thank you, João Paulo A. Almeida Federal University of Espírito Santo

2 1

[Maria-discuss] mysql 5.5 client vs mariadb 10 server
by Oliver 22 Mar '22

22 Mar '22

Hi, I'm sorry for the question if it is clear that it isn't possible. I'm trying connect from a mysql 5.5.56 client against a mariadb 10 server and I'm having the next error: ERROR 2003 (HY000): Can't connect to MySQL server on 'server' (10061) Subnet source is allowed in mariadb server and grant is given for 'root'@'source_server', it is allowed both IP and hostname. So not sure if it is config problem or compatibility problem. Someone knows please? Thanks beforehand. P.D.: I can connect using dbeaver from my computer client using mysql binaries (but not sure what mysql client version uses dbeaver). Cheers...

4 5

[Maria-discuss] History Length: Purge-able vs. Not Purge-able metrics
by mariadb＠Biblestuph.com 10 Mar '22

10 Mar '22

Greetings, I know I can get the current undo log history length via: > show status like '%history%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | Innodb_history_list_length | 854 | +----------------------------+-------+ but my understanding is that at any given point in time that number represents both the records that can be purged because they are no longer needed by any current transactions (and the purge threads for whatever reason haven't gotten to them yet), as well as those that cannot be purged yet because there are current transactions running that may still need them. So the question is, is there any way to know the difference between those two? I.E., how many are waiting to be purged and how many cannot yet be purged? And a related question. Will the undo log size (the physical size of the file) grow even when there are many entries in the history that can be purged first? Or are those unneeded records purged first and that space reused before the undo log is made larger? Or perhaps I'm mis-understanding the process? TIA, Dan

1 0

[Maria-discuss] Unable to find specific format for mariaDB 10.6.*
by ragul rangarajan 25 Feb '22

25 Feb '22

Hi Team, I try to get MariaDB 10.6.* *bintar-linux-x86_64 tar* from http://archive.mariadb.org/ But I couldn't find any other formats except *bintar-linux-systemd-x86_64 *as in the older version. Can someone please share where to get* bintar-linux-x86-64 *for 10.6.* MariaDB version as like below for 10.5.* https://archive.mariadb.org/mariadb-10.5.15/bintar-linux-x86_64/mariadb-10.… Thanks and regards, Ragul

3 4

[Maria-discuss] demo: running MariaDB with rootless Podman and socket activation
by Erik Sjölund 17 Feb '22

17 Feb '22

Hi, Support for socket activation was added to MariaDB in release 10.6 (released April 2021). Podman also supports socket activation so I thought it would be interesting to combine both of them into a systemd user service. I wrote a small demo: https://github.com/eriksjolund/mariadb-podman-socket-activation (tweet: https://twitter.com/eriksjolundcomp/status/1491162016429768704) and got it to work. Do you have any suggestions on how to improve this? Thanks, Erik Sjölund

2 3

[Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.8.1 RC and MariaDB 10.7.2, 10.6.6, 10.5.14, 10.4.23, 10.3.33 and 10.2.42 now available
by Reindl Harald 10 Feb '22

10 Feb '22

https://downloads.mariadb.org/mariadb/10.3.33/ points to a form with 10.6 preselected because a redirect to https://mariadb.org/download/?t=mariadb&p=mariadb&r=10.6.5&os=Linux&cpu=x86… and in that useless form 10.3.32 is the newest you can select when trying to download sources is there a reason why such nonsense on download pages is developed other than "some people need to be busy"? when you change to 10.3 and have selcted "source" before the form goes back to Linux with systemd as selection head - table - match -------- Weitergeleitete Nachricht -------- Betreff: [MariaDB Announce] MariaDB 10.8.1 RC and MariaDB 10.7.2, 10.6.6, 10.5.14, 10.4.23, 10.3.33 and 10.2.42 now available MariaDB 10.3.33 - Release Notes: https://mariadb.com/kb/en/mdb-10333-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10333-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.3.33/

2 1

[Maria-discuss] Weird behavior in Fedora 34 server
by Miguel Lavalle 05 Jan '22

05 Jan '22

Hi, I am installing MariaDB in Fedora 34 server with the following sequence of commands: sudo dnf upgrade -y sudo dnf install -y mariadb-server mariadb-devel sudo dnf -y install git vim With this sequence of commands, I get the following installed: $ mysql --version mysql Ver 15.1 Distrib 10.5.13-MariaDB, for Linux (x86_64) using EditLine wrapper and I can successfully perform the initial setup of the root password: sudo mysqladmin -u root password password and continue with the rest of my installation. However, if I change the sequence of commands to: sudo dnf upgrade -y sudo dnf -y install git vim sudo dnf install -y mariadb-server mariadb-devel What I get installed instead is: $ mysql --version mysql Ver 8.0.27 for Linux on x86_64 (Source distribution) and the 'sudo mysqladmin -u root password password' command fails with: mysqladmin: unable to change password; error: 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '() IDENTIFIED BY 'secretdatabase'' at line 1' Could anyone shed some light on this? Thanks!

3 8

[Maria-discuss] Incremental backup with mariabackup and run-mariabackup
by Dave Wreski 02 Jan '22

02 Jan '22

Hi, I'm using mariadb-10.5.13 on fedora34 with run-mariabackup from https://github.com/omegazeng/run-mariabackup. Has anyone used this backup script or have any recommendations for ones that help to automate the process of using mariabackup for backups? This script appears to create an infinite amount of incremental backups once the original full backup is created. I believe this makes it necessary to restore each of the incrementals on top of the base. If the backups are stored off-site, this creates magnitudes more data that's needed to restore, and increases the time to restore it. It also only appears possible to backup the entire system, not just individual databases. Do you have any recommendations for other scripts that ease the process of making and restoring backups? Thanks, Dave

1 0

[Maria-discuss] sys schema backup
by William Edwards 04 Dec '21

04 Dec '21

Hi, The 'sys' schema is documented to be "A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage." Is there anything in this schema that should be backed up, or can I skip it when creating backups? -- With kind regards, William Edwards

3 2

[Maria-discuss] [Warning] WSREP: certification interval for trx source [...] exceeds the limit of 16384
by Giovanni Agozzino 01 Dec '21

01 Dec '21

Hi people, I'm relatively new to Mariadb+Galera and I'm trying to understand how to manage when a node goes down the best way. I don’t know if this is the right place to ask. If not, I’d appreciate suggestions for where to ask. I am using 1:10.6.5+maria~hirsute galera-4 26.4.9-hirsute I would understand what is the meaning of the warning: [Warning] WSREP: certification interval for trx source [...] exceeds the limit of 16384 and what are the ways to avoid it. I'll explain when I encounter it: I shut down one of my three mariadb nodes during peak hours and I wait to restart it until a SST is triggered. The SST is succesfully done (both the donor and the joiner go without errors). But when applying the IST post SST to keep up with the latest transactions, I see these warning in both donor (before switching from donor/desynced to synced state) and joiner (after completing SST). What is the implication of this warning? I suppose is not the certification failing or I would have errors, but I don't know if is serious business or not. And there is a parameter to tune in the way to avoid this warning? Thank you very much. Best regards, Giovanni

1 0