Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.3]

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL.

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL. Since version 10.0 MariaDB has veered off MySQL and now implements a different set of features.

MariaDB 10.3 implements system-versioning tables, PERCENTILE_CONT(), PERCENTILE_DISC(), and MEDIAN() window functions, INTERSECT and EXCEPT clauses, cursors with parameters, LIMIT in multi-table updates, LIMIT in GROUP_CONCAT(), and many other new features.

171 questions
0
votes
2 answers

Can't Grant SLAVE MONITOR to user on MariaDB 10.6 Primary

We recently replaced an old MariaDB 10.3 primary with one of it's replicas which is running 10.6.x. Hoping that this would resolve a weird Primary/replica issue that we have had since creating the replicas. The Struggle: Per the MariaDB…
DNate
  • 1
0
votes
0 answers

when i am running registration form after submitting form data it show like this?

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 ''userdetails'('sno','uname','gender','email','password','mobileno','address')...'
Annam Deepu
  • 1
0
votes
0 answers

MariaDB 10.3. - Error 2006 server has gone away in a PHP-Loop after a certain number of queries. Any idea?

EDIT: In my opinion is this not a duplicate because non of the mentioned answers are solving the problem. We have running a MariaDB 10.3. on a Synology-Server and almost everything works fine. But after a certain number of queries within one…
Harald Stoppel
  • 1
  • 2
0
votes
1 answer

DBRider: org.dbunit.database.AmbiguousTableNameException

I've migrated to Spring Boot 3, MariaDB 10.3 and DbRider 1.35.0 and I'm trying to run tests and I'm getting this weird error @SpringBootTest(classes = { HibernateTestConfig.class, DaoTest_List_DBUnitConfig.class }) @DBRider(dataSourceBeanName =…
Esteban
  • 1,496
  • 17
  • 22
0
votes
1 answer

FlyWay configuration for several databases

I'm integrating FlyWay to the project. Besides of migrations for working database I would like to setup database with fixtures for integration tests during gitlab pipeline job(just for cases when somebody pushes the branch). On project is used…
Sam Fisher
  • 746
  • 2
  • 10
  • 27
0
votes
0 answers

MariaDB on Azure; how to switch on error logging

i have a managed mariadb (10.3.23) in Azure. The log_error parameter is not available in the Azure portal and audit log i don't think will give me what i need. (i'm getting a few mariadb crashes that azure recovers ok but i'd like to know why..) is…
nigelgomm
  • 79
  • 9
0
votes
1 answer

mysqldump and "Can't find record" table errors on restore

I've been using the following mysqldump command to backup my mariadb databases for several years, and never had a problem restoring. Until today. Here is the command I've been using for one of the databases: /usr/bin/mysqldump --complete-insert…
Alex Regan
  • 477
  • 5
  • 16
0
votes
1 answer

MariaDB Backup is not possible anymore because InnoDB is broken, why so?

Version: mysql Ver 15.1 Distrib 10.3.34-MariaDB After trying to do a backup on my mariadb server i got: mysqldump: Couldn't execute 'show create table `transaction_registry`': Table 'mysql.transaction_registry' doesn't exist in engine (1932) Which…
Sergej Mamberger
  • 15
  • 6
0
votes
0 answers

Diskspace unaccounted for on azure managed mariadb

i have a managed Mariadb database (10.3.23) on Azure. Azure tells me that 2.4tb of disk space is used yet when i check the databases i don't reach that figure. select sum(data_length/1024/1024/1024) as data_length_gb, sum(data_free/1024/1024/1024)…
nigelgomm
  • 79
  • 9
0
votes
1 answer

Get max id from grouping two columns as pair

i have search a lot to find a solution to get the max id using group by of two columns as a pair in a data set but none of the queries i have found and used worked as expected. Below is an example data…
dimoss
  • 479
  • 1
  • 3
  • 10
0
votes
0 answers

Why does CONCAT'ed value in MariaDB query result in Illegal mix of collations (utf8mb4_bin,NONE) collation?

We have a query that CONCATs a bunch of values together, and then searches against it, and we're getting this error: Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' The strange thing is that on…
ilasno
  • 714
  • 1
  • 13
  • 31
0
votes
0 answers

Passing the result of one SQL query to another

I have a table in my DB (MariaDB 10.3) which shows the "rental" status of our product. Based on the percentage that is rented out, we need to retrieve a pricing formula. I can get the percentage using the the following SQL statement the percentage…
Effendi Baba
  • 1
  • 1
0
votes
0 answers

Getting data from json array mysql

Below is my json data which is saved in cold_storage_data column of inventory table [{ "qty_in_storage": "10", "cold_storage_id": "2", "cold_storage_lot_number": "678678" }, { "qty_in_storage": "15", "cold_storage_id": "1", …
urfusion
  • 5,528
  • 5
  • 50
  • 87
0
votes
0 answers

MariaDB aborted connections and lagging system

So I have this server that has the following settings under my.cnf: [mysqld] event_scheduler = off max_connections = 1200 wait_timeout = 60 #connect_timeout = 30 interactive_timeout = 60 innodb_buffer_pool_size = 134217728 max_allowed_packet =…
Amix
  • 1
  • 1
0
votes
0 answers

MariaDB - How to find the non english characters/words

Here we have the "name" column and values are "Kumaran", "Poziom insuliny", "surowicy", "Alphabets". The above values "Poziom insuliny", "surowicy" - are not an english words. Can you tell me how to find those words in mariaDB. Thanks in Advance
Ilaiyakumaran
  • 1
1 2 3
…
11 12