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
0
votes
2 answers

The "NEW" table in a trigger sometimes contains column and sometimes it does not

I've been trying to create an INSERT trigger and in a simple trigger body I can access the "NEW" table just fine. But in an example where the "NEW" table is used deeper into the body it no longer finds the column I need. I can find the column…
Cristian Benescu
  • 3
  • 2
0
votes
1 answer

Can you change anonymous in mysql general_logs?

I have mariadb server, which contains database and i have my website on apache server that connects to this database through PHP and my general logs seems like this: logs and i dont like it shows "as anonymous" instead of for example "as apache".…
M3zuss
  • 45
  • 4
0
votes
1 answer

Unable to create partition on Mariadb on this child table where Foreign Key Exists?

Unable to create partition this child table "city" with parent table "country" It is showing below error "Foreign Key Not Supported". Without foreign key how relation maintain ForeignKey not supported by partition] [2]…
Sheikh Wasiu Al Hasib
  • 450
  • 5
  • 18
0
votes
1 answer

select a column with how many same value present

i have string data on my column ------------ name ------------ john-yolo john-yolo john-yolo felix-goran carine-carin carine-carin i want to select name column with how many times the name present ex : ------------ name…
tiwtiwtiwtiwaaaaa
  • 110
  • 9
0
votes
1 answer

Maria DB, locking table for replacement?

I have a web application using a mariaDB10.4.10 INNO_DB table which is updated every 5 minutes from a script. The script is working like: Create a temp table from a table XY and writing data to the temp table from a received csv file. When the data…
Thallius
  • 2,482
  • 2
  • 18
  • 36
0
votes
1 answer

Split JSON "dictonary" into separate rows

colleagues. I have a table like this: id param1 param2 config 123 456 789 {"confToUse": "b", "configs": {"a": { "qwe": "rty" }, "b": { "asd", "fgh" } } } Small explanation: configurations live in a json 'dictionary' property configs,…
Ivan Khorin
  • 827
  • 1
  • 5
  • 17
0
votes
3 answers

SQL Update for cases

I'm trying to update a column after I join two tables. If one column matches another I want to change another to 'W' and if it is already blank/NULL I want to leave it, otherwise I want to change it to 'L'. Here is what I have: UPDATE user_games…
Geomon
  • 13
  • 5
0
votes
0 answers

MariaDB is not starting even after port has been change

Can any body tell how backup database without mysql start. Mysql error log is below InnoDB: using atomic writes. 2021-09-10 23:59:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-09-10 23:59:01 0 [Note] InnoDB: Uses…
Hardeep Singh
  • 743
  • 1
  • 8
  • 18
0
votes
1 answer

Why does this query give a different result when it's used as a sub-query?

I have this data: "config_timeslice_id","config_id","created" 14326,1145,"2021-08-31 13:45:00" 14325,1145,"2021-08-22 13:34:51" 14321,1145,"2021-06-16 10:47:59" 2357,942,"2019-12-24 10:09:38" When I run this query: SELECT config_timeslice_id FROM…
John Lindal
  • 616
  • 5
  • 11
0
votes
0 answers

How can I set default root password for MariaDB > 10.4 via SaltStack?

According to the MariaDB documentation, new MariaDB installations now allow the root user to use both the unix_socket and mysql_native_password plugins. However, the password is initially made invalid. Thus, the only way to log in as root is…
vpseg
  • 71
  • 5
0
votes
0 answers

Increase Django logs query time precision

I am currently using the Django shell in debugging mode in order to benchmark my queries. This is an example of what I get: >>> Item.objects.filter(param1=63) (0.001) SELECT `items`.`id`, `items`.`param1`, `items`.`param2`, FROM `items` WHERE…
Atenea_v10
  • 87
  • 1
  • 8
0
votes
1 answer

Compare and insert date and calendar week with two different tables

I have two tables in my database. In the first table is a column named date where i insert a date period in a 1 day interval. In the second table are the calendar weeks of the same date period and an autoincrement column weekid. For example I have…
Gandalfthegrey
  • 45
  • 7
0
votes
1 answer

Retrieving rows where a set integer is > the count of an aggregate relation

Been having a bit of trouble with this one, getting pretty close but not quite there. I have looked through other answers, and none quite seem to capture this. There is a shared system for a library group with multiple locations, and the ultimate…
Jordan Steinberg
  • 41
  • 5
0
votes
0 answers

why my mysql keep shutting down previously it was working fine

why my mysql keep shutting down previously it was working fine just giving some js error on browser but still working that time, now it is keep shutting down here's the error log enter image description here
Syed Zahab
  • 1
  • 1
0
votes
1 answer

MySqlCommandBuilder.DeriveParameters: Specified cast is not valid

I am using MySql.Data version 8.0.22 on IIS/Windows to try and connect to MariaDB 10.4.12 (Linux). I am trying to use MySqlCommandBuilder.DeriveParameters to fetch parameter information: cmd.CommandText = "Mail_SaveEvent"; …
Kris Oye
  • 1,158
  • 14
  • 27
1 2 3
…
10 11