Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.4]

MariaDB 10.4 is an open source database server that offers drop-in replacement functionality for MySQL. Use this tag only when using MariaDB version 10.4.*

MariaDB 10.4 version was released in June 2019. It implements notable features such as instant DROP COLUMN and ordering change in InnoDB tables; Account Locking; User Password Expiry etc.

Complete list of changes and improvements can be seen here: https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-104/

156 questions
11
votes
5 answers

Too many open files with Mariadb 10.4.13 on Macos Catalina

i’m run on Macos 10.15.5, with mariadb 10.4.13. Since i did “brew upgrade” I have this error : Out of resources when opening file './pluto/_connection.MYD' (Errcode: 24 "Too many open files") I tried to modify this file /usr/local/etc/my.cnf to add…
Vika
  • 115
  • 1
  • 8
6
votes
2 answers

Mariadb installation on Amazon linux 2

Can someone provide steps to install mariadb on amazon linux 2? I am pretty new in linux, so a little detail will be greatly appreciated. I have seen few links to install maria db on centOs but not sure if the same works for Amazon linux 2
dbNovice
  • 399
  • 2
  • 4
  • 18
6
votes
1 answer

Name ' ' ignored for PRIMARY KEY [MySql MariaDB 10.4.11]

I have a problem with those lines on my MAC, on mariaDB 10.4.11 version. DROP DATABASE IF EXISTS Employe_Programmeurs; CREATE DATABASE Employe_Programmeurs; USE Employe_Programmeurs; CREATE TABLE Employe( noEmp INT(5), nom …
Faisal Hotak
  • 425
  • 1
  • 5
  • 10
5
votes
1 answer

Count how many rows have a nested value in the arrays of a json column in MariaDB 10.4

I have the following values ​​inside a cell of a json column in MariaDB 10.4: { "0": [ 21, "Pallet da 1250kg (50 * Sacco da 25kg)", "1250", "kg" ], "1": [ 21, "Sfuso", "12", …
Memmo
  • 298
  • 3
  • 8
  • 31
5
votes
1 answer

MariaDB - Inserting historical data into a system versioned (temporal) table

I have some tables in MariaDB that I have been tracking the changes for by using a separate "changelog" table that updates every time a record is updated. However I have recently learned about temporal data tables in MariaDB and I would like to…
zeke
  • 3,603
  • 2
  • 26
  • 41
3
votes
2 answers

MariaDB shutdown unexpectedly. mysqld.exe: Aria recovery failed

mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files I am using xampp and it was working perfectly. Today when I started my Windows computer and tried to start the MariaDB Server from…
Ali Shan
  • 459
  • 7
  • 14
3
votes
1 answer

MariaDB MAX_JOIN_SIZE error without index hint

There are MariaDB 10.4.14 with max_join_size = 300M and the coin InnoDB table with ~150,000 records inside. A simple enough query produces MAX_JOIN_SIZE error: SELECT * FROM coin z -- USE INDEX(PRIMARY) WHERE z.id IN (5510, 5511, 5512 /* more item…
Yuri
  • 313
  • 2
  • 9
3
votes
6 answers

Mysterious mariadb 10.4.1 ram ussage

i have upgraded from mariadb 10.1.36 to 10.4.8 and i can see mysterious increasing ram ussage on that new version. I also edited innodb_buffer_pool_size ant seems there is no effect if its set to 15M or 4G, ram is just slowly increasing. After while…
Jakub Barták
  • 51
  • 4
2
votes
2 answers

Recursive query in MySQL for adjacency list depth first?

The table this query running on is roughly structured like this: comments_table(PK id, FK reply_to_id, content) FK is a self join on itself It's running on 10.4.27-MariaDB And the data looks something like this: +----+-------------+---------+ |…
Jacopo V
  • 45
  • 4
2
votes
0 answers

deleting the database is not synchronized in another node

I used this tutorialand I have 2 servers (nodes). Everything works fine, the problem is when I stop MariaDB on both servers and then delete the database on the second node. When I try to synchronize again, the second server does not recognize the…
moh3en
  • 21
  • 3
2
votes
1 answer

SQL How to group a sequence of elements that share a chronological order

I have a set of records that consists of the start and stop dates, as the…
Rody
  • 59
  • 7
2
votes
1 answer

cannot add constraint to an existing table

i created a data base 'test' with table table 'user', inside the table there are 'id' and 'name' columns CREATE TABLE `test`.`user` (`id` INT NOT NULL AUTO_INCREMENT , `name` TEXT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; now i want to add a…
aditya shaikh
  • 21
  • 1
2
votes
0 answers

Decrese value on FIFO by primary SQL

I have tabels like this.. id code Name Quantity 1 A1 ABC 10 2 A2 BCD 20 3 A1 ABC 30 4 A1 ABC 10 5 A3 EDC 30 i want to decrese quantity with this tabel.. code Name Quantity A1 ABC 45 A2 BCD 5 then i want the result…
Iyang Agung Supriatna
  • 21
  • 2
2
votes
1 answer

Error: MySQL shutdown unexpectedly. Plugin 'FEEDBACK' is disabled

Today I run MySQL and MySQL is not working, giving the following error in the console: 8:30:43 AM [mysql] Error: MySQL shutdown unexpectedly. 8:30:43 AM [mysql] This may be due to a blocked port, missing dependencies, 8:30:43 AM [mysql] …
Artwin Wijaya
  • 21
  • 1
  • 2
2
votes
1 answer

Maxscale readwritesplit show the same number of connections

I've set up Maxscale to ReadWriteSplit with no reads to master (the default) to a Galera cluster (3 nodes). # # Global configuration # [maxscale] threads=auto local_address=10.1.0.11 query_retries=2 # #…
ac_s_fer
  • 53
  • 4
1
2 3
…
10 11