- discuss - lists.mariadb.org

Setting up a jira self hosted instance
by juanhernandez98＠gmail.com 20 Mar '24

20 Mar '24

Hi, So I've been running MariaDB 11.3 for a while. I have various applications working great with this server. I want to setup a Jira 9.14 self hosted instance on one of my servers. I see mariadb.com uses Jira. So I put the mysql java connector v8.3.0, and the mariadb java connector v3.3.3 installed in my /opt/Atlassian/jira/lib directory. I tried connecting jira via the setup web interface to my maria db, using the mysql 8.0 driver, and I get the error that I'm not running the right version. I then added under [mysqld] in my.cnf, version = "8.0.25-0" and now get the below error. Error connecting to database Unknown system variable 'transaction_isolation' I am now getting this error when testing the connection in jira: I don't want to setup a postgresql instance or a mysql 8 instance, can I get this to work? Any help would be greatly appreciated. Best Juan

2 1

Trigger Fails
by steffan＠hldns.com 15 Mar '24

15 Mar '24

I just converted to MariaDB from MySQL where this trigger worked fine. DELIMITER ;; CREATE TRIGGER `email_uuid_before_insert` BEFORE INSERT ON `email` FOR EACH ROW BEGIN IF new.id_email IS NULL THEN SET new.id_email = uuid(); END IF; END;; DELIMITER ;; In MariaDB, it creates with no errors but when adding a row, I get an error 1062 : Duplicate entry '' for key 'PRIMARY' It’s caused because the last row that inserted wasn’t populated with that UUID – meaning the trigger failed. What would cause this to fail? Thank you, Steffan Cline steffan(a)hldns.com<mailto:steffan@hldns.com> 602-793-0014

2 2

Support for MariaDB Community Repo after EL7 EOL
by james.manley＠jadu.co.uk 14 Mar '24

14 Mar '24

Hi, We currently use MariaDB 10.5 from the MariaDB Community Repo on EL7. EL7 is end of life at the end of June 2024. Will MariaDB 10.5 continue to receive support and security updates until its end of life, or will support and updates stop on EL7 once the OS reaches end of life? Thanks!

2 1

MariaDB's Percona Tookit Fork Source Code Repository?
by Gordan Bobic 13 Mar '24

13 Mar '24

Hi, I noticed references to these tools: https://mariadb.com/kb/en/mariadb-tools/ but the github links are all 404. Where can all of the sources for these be downloaded from?

3 4

next and previous words
by ChipsRunner 24 Feb '24

24 Feb '24

Hi I've noticed that between debian 10 and 11 (mariadb-client-core-10.3 and mariadb-client-core-10.5) the client console tool (CLI) treats words in a different way: alt+f and alt+b will skip the dot on the new version. Example if I have something like 'test.domain.com' using alt+f on the old version would treat 'test', 'domain' and 'com' as three separate words while the new version would skip at the end of '.com' Is there a way to restore the old behaviour ? Thank you, PM

2 2

Back again for more help
by Ken Wright 21 Feb '24

21 Feb '24

Now that you kind people have pointed me in the right direction as far as log-bin was concerned, I've moved on to trying to replicate the databases from the primary to the secondary. I've created the connection profile and started the secondary connection, but when I ran show slave 'master01' status\G I got the following error: Last_Errno: 1062 Last_Error: Could not execute Write_rows_v1 event on table databasename.oc_filecache; Duplicate entry '110' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.00000#, end_log_pos ###### How do I resolve this duplicate entry error? And do I need to do the same resolution on the primary as well? Ubuntu Server 23.10, mariadb version 15.1 Distrib 10.11.6-MariaDB Ken -- If you ever think international affairs make sense, remember this: because a Serb shot an Austrian in Bosnia, Germany invaded Belgium.

3 2

External MyISAM partitions
by Jan Křístek 20 Feb '24

20 Feb '24

Hi, We have an old instance of MariaDB 10.3.9/10.3.39, with historical data. Every month I copy an old MyISAM partition (binary files) from the same version of the engine (but a different instance) to a big volume and replace an empty partition in the database with symlinks to the newly copied two files (MYD, MYI - when the engine is stopped). I have been doing it for a year or two, checking each time the data are accessible afterwards. This month it happened, that the data are not accessible anymore, and the database throwing an exception: *Got error 140: "Wrong create options" from storage engine MyISAM.* I tried doing it in a new instance, each time I replace a partition with a link to file elsewhere, the error appeared again. Does anyone have any ideas, why it's showing the error and how to avoid it? I cannot recall changing anything in the database configuration, upgrading any database, or doing any other changes. Thanks for any help you can provide, Jan

2 2

Setting up primary-secondary replication
by Ken Wright 17 Feb '24

17 Feb '24

Greetings! I'm trying to set up a backup email server using Ubuntu 23.10 Server. I want to replicate my MariaDB databases from the primary email server to the secondary, but whenever I add the line log-bin = /var/log/mysql/master-bin to /etc/mysql/mariadb.conf.d/50-server.cnf MariaDB fails to restart. I've looked for help online, but haven't had any luck. Can anyone help? Further details available on request. Ken -- If you ever think international affairs make sense, remember this: because a Serb shot an Austrian in Bosnia, Germany invaded Belgium.

3 4

Windows downloads
by madhon＠madhon.co.uk 16 Feb '24

16 Feb '24

Have the windows downloads for versions 10.6.17 and 10.11.7 been pulled as the only option i see are source and linux ?

3 2

Slow log and processlist.memory_used
by Gordan Bobic 13 Feb '24

13 Feb '24

In processlist, there is a column called memory_used. Is there a way to make the peak value for a query get logged into slow log? Failing that, does the performance_schema provide any such info for previously run statements to go with statement digests? Or is the only place where this can be found in the information_schema.processlist table while the query is running?

1 0