- discuss - lists.mariadb.org

Advice concerning inconsistent query results
by Jef Van Loon 24 Mar '24

24 Mar '24

Hello, I am looking for advice concering inconsistent query results. Problem: We are observing queries that return inconsistent query results. The query in question selects records within a period of time (e.g., month) based on a datetime column. The result set is missing random records within the queried time period. It appears that the inconsistent result is produced when the query uses an index containing the datetime column. When the index is not used, the result seems to contain all records. Dropping and recreating the index caused the result to be complete again. However, this has NOT solved the problem permanently as the wrong behaviour has reappeared afterwards. On second appearance, we have used OPTIMIZE table on the table in question which has again resolved the problem, we will have to wait to see whether the problem occurs again. CHECK TABLE returned no erros for the affected table. The problem does not seem to be limited to one installation, we are seing it on different MariaDB installations. Questions: - Has anybody seen such behaviour in the past? - How can we diagnose the problem? Environment: - MariaDB Version: MariaDB 10.5.13 - MariaDB Storage engine: InnoDB - MariaDB Collation: utf8mb4_unicode_ci - OS: Windows Server Kind regards, Jef

4 7

Possible Security Bug
by Gordan Bobic 24 Mar '24

24 Mar '24

Hi, What is an appropriate forum for discussing what seems to be a security bug that I ran into?

3 3

Re: Setting up a jira self hosted instance
by Daniel Black 20 Mar '24

20 Mar '24

Query obviously from connector. Works in 11.3.3 MariaDB [test]> SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout\G *************************** 1. row *************************** auto_increment_increment: 1 character_set_client: utf8mb3 character_set_connection: utf8mb3 character_set_results: utf8mb3 character_set_server: latin1 collation_server: latin1_swedish_ci collation_connection: utf8mb3_general_ci init_connect: interactive_timeout: 28800 license: GPL lower_case_table_names: 0 max_allowed_packet: 16777216 net_write_timeout: 60 performance_schema: 0 sql_mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION system_time_zone: AEDT time_zone: SYSTEM transaction_isolation: REPEATABLE-READ wait_timeout: 28800 1 row in set (0.001 sec) MariaDB [test]> select version(); +----------------+ | version() | +----------------+ | 11.3.3-MariaDB | +----------------+ 1 row in set (0.000 sec) Obviously fails in earlier versions: MariaDB [test]> SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, -> @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout\G ERROR 1193 (HY000): Unknown system variable 'transaction_isolation' MariaDB [test]> select version(); +-----------------+ | version() | +-----------------+ | 10.11.8-MariaDB | +-----------------+ 1 row in set (0.000 sec) Are you sure you have the right version of MariaDB that you described? Otherwise upgrade/use MariaDB Connector/J. On Thu, 21 Mar 2024 at 04:45, <juanhernandez98(a)gmail.com> wrote: > > Just as a FYI, I enabled the MariaDB general logs: > > And I'm getting this when the jira instance tries and connect to my mriadb server: > > 240319 14:28:23 239 Connect jira@localhost on jira using TCP/IP > 239 Query SET SESSION default_storage_engine=InnoDB > 239 Query /* mysql-connector-j-8.3.0 (Revision: 805f872a57875f311cb82487efcfb070411a3fa0) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout > > > -----Original Message----- > From: Daniel Black via discuss <discuss(a)lists.mariadb.org> > Sent: Tuesday, March 19, 2024 9:57 PM > To: discuss(a)lists.mariadb.org > Subject: [MariaDB discuss] Re: Setting up a jira self hosted instance > > On Wed, 20 Mar 2024 at 07:20, Juan Hernandez via discuss <discuss(a)lists.mariadb.org> wrote: > > > > 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. > > > > Is that from the driver or from JIRA? > > > 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' > > https://jira.mariadb.org/browse/MDEV-21921 - added this to 11.1, so you should be right in 11.3. Its not 10.11.3 right? > > Can JIRA use the MariaDB Java Connector v3.3.3? > > A last resort is to specify the version=5.7.44 (any 5.7) and/or use a > 5.7 compatible mysql java connector. > > > > 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. > > Us too. We're still battling against JIRA supported databases a little after all these years. > _______________________________________________ > discuss mailing list -- discuss(a)lists.mariadb.org To unsubscribe send an email to discuss-leave(a)lists.mariadb.org >

1 0

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

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