Questions tagged [mariadb-10.5]
100 questions
5
votes
1 answer
FlywayException : Unsupported Database: MariaDB 10.5
mariadb version is Server version: 10.5.9-MariaDB Homebrew
Flyway version is "org.flywaydb" % "flyway-core" % "8.2.1"
HikariCP version is "com.zaxxer" % "HikariCP" % "5.0.1"
Mariadb jdbc client versionis "org.mariadb.jdbc" % "mariadb-java-client" %…
Avinash Reddy
- 2,204
- 3
- 25
- 44
3
votes
3 answers
Using Indexes results in Update locks cannot be acquired during a READ UNCOMMITTED transaction
After upgrading to mariadb 10.5.11 I ran into a weird problem with the indexes.
Simple table with two colums Type(varchar) and Point(point)
An index on Type(Tindex) and a spatial index on Point(Pindex)
Now a query like
SELECT X(Point) as x,Y(Point)…
brbrbr
- 31
- 2
2
votes
0 answers
How to scrape metrics from bitnami/mariadb helm deployment with kube-prometheus-stack
I am using bitnami/mariadb helm chart deployments. I tried to enable the metrics and servicemonitor like below in the primary and secondary section in values.yaml file. And I noticed that the sidecar container and servicemonitor are not creating.
…
Stuart Michael
- 21
- 2
2
votes
0 answers
MariaDB Check String Length Performance
Can anybody explain the impact on the performance of the query when we are using the Length() function to check the length of string (Varchar) data?
SELECT LENGTH(FIRST_NAME), FIRST_NAME FROM MIT_STUDENTS;
This is my query above for the length()…
Aadarsh Vikram Singh
- 21
- 2
2
votes
2 answers
MariaDB trigger to perform an UPDATE and then an INSERT on the same table
I currently have an account table and an account_audit table (all codes are available on a fiddle here).
I have two triggers that insert records into the account_audit table based on data inserted into the account table.
1 trigger is an ON INSERT…
SQL_Padawan
- 25
- 6
2
votes
4 answers
MySQL Nested aggregation query with selection of specific intermediate items
This is my activities table.
activities
+----+---------+----------+-----------------+
| id | user_id | activity | log_time |
+----+---------+----------+-----------------+
| 6 | 1 | start | 12 Oct, 1000hrs |
| 2 | 1 | task …
Kaya Toast
- 5,267
- 8
- 35
- 59
2
votes
1 answer
How to cast value as JSON in MariaDB?
I want to extract a JSON with table name and columns inside each table.
Here is my SQL:
SELECT
JSON_OBJECTAGG(table_name, columns)
FROM (
SELECT
table_name,
JSON_OBJECTAGG(column_name, data_type) as columns
FROM…
tom10271
- 4,222
- 5
- 33
- 62
2
votes
0 answers
Why does (mariadb) mysqldump replace some varchar with NULL?
mysqldump: Ver 10.17 Distrib 10.5.4-MariaDB, for debian-linux-gnu (x86_64)
mysql: Ver 15.1 Distrib 10.5.4-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Strange one here, the following command dumps the database as requested however, it…
Jonathan Moss
- 21
- 2
2
votes
1 answer
MariaDB query columns into JSON
I've been going around in circles for a while and just not sure how to tackle this using the available JSON functions.
I have a database table with item names and a count for a player identifier and I'd like to represent this set of records as a…
Stephen York
- 1,247
- 1
- 13
- 42
2
votes
2 answers
Mariadb 10.5.x and issues with Wordpress thanks to "mysql.user" being a view now
I just discovered the silly new issue of MariaDB's latest version having mysql.user as a view. All my imported Wordpress databases suddenly cannot connect from the blogs. When I try to even list mysql.user it shows me this:
> select * from…
PKHunter
- 682
- 2
- 13
- 28
2
votes
0 answers
MariaDB / Galera - Hanging node freezes whole three node cluster
i hope you are all healthy. :-)
Currently I have a recurring problem. Our database cluster, consisting of three nodes, currently fails almost daily. The reason is repeated that one of the three nodes hangs and thus somehow hangs the whole cluster.…
Binarycoded_M
- 21
- 3
2
votes
1 answer
SQL Error (1038): Out of sort memory, consider increasing server sort buffer
I have upgraded MariaDB 10.3.13 to the latest version 10.5.6. Once deployed, one of my queries started giving this error:
SQL Error (1038): Out of sort memory, consider increasing server sort buffer
I managed to simplify query while keeping the…
Andrej Piatnica
- 41
- 4
2
votes
2 answers
auto_increment jumps by 3 and not 1
I have noticed that in my mysql server, the auto_increment setting increments by 3, for example 3 6 9 12 15 etc.
All the tables in the database are having the same problem.
I'm using mariadb 10.5 on debian 10.
Could it be because of having a 3 vps…
diaconu liviu
- 1,032
- 2
- 13
- 30
2
votes
2 answers
Use a user-defined variable to dynamically name second database to JOIN tables with that second database
I need to JOIN two different databases which I've already accomplished statically for testing purposes only.
The first database is already defined in the connection itself.
The second database must be dynamically derived from information within the…
John
- 1
- 13
- 98
- 177
2
votes
2 answers
MariaDB root login problem. (can login but, not security)
I have some problem.
Install MariaDB success.
mysql_secure_installation setting complete.
but I login mysql -u root -p
Insert Any password can login on linux root user.
(not root user has to enter the correct password)
This problem does not occur…
MiraiTech
- 43
- 4