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
1
vote
0 answers

SEVERE: Exception loading sessions from persistent storage java.io.InvalidClassException: com.vaadin.server.VaadinServletRequest; no valid constructor

I created the war file of a web application and deployed on tomcat and started the tomcat server. server is started successfully but I can see below exception in catalina.out file. SEVERE: Exception loading sessions from persistent…
RKM
  • 21
  • 1
1
vote
3 answers

Find availability in multiple calendars with relation using MySQL

I own something that I frequently rent out. It consists of several parts. It can either be rented part by part, or as a whole. If one part is rented out, you wont be able to rent it as a whole. An example can be that I rent out a car. This car has…
Joachim
  • 320
  • 3
  • 12
1
vote
0 answers

Unable to connect to MariaDB via SSL on Google Apps Script

I'm having difficulties connecting Google Apps Script to my MariaDB instance. This is the GAS I am using for this example: https://gist.github.com/HappymanOkajima/8740727662e9ba0e0ffd52006484c47f The MariaDB instance is from the original dockerhub…
alderson59
  • 11
  • 2
1
vote
1 answer

How to optimize this SQL query to filter on a longtext/JSON field

I have a table with a column of type longtext that stores nutrient values in JSON format. Here's an example of what the data looks…
Charles
  • 189
  • 1
  • 10
1
vote
1 answer

JSON in MySQL : get data from an object within a range of keys

What I have: A mysql table, say table1 table1 contains two columns viz. id and data id is int but the twist is data is JSON type and its keys are comparable the table1 contains only one row (for the sake of this…
Deepam Gupta
  • 2,374
  • 1
  • 30
  • 33
1
vote
1 answer

MySQL crashed with un-answered memory issue

My website (Wordpress) sometimes stopped working with message "cannot connect to Datatabse". I checked the log file of MySQL and I found the following crash-info: ---------- 2021-01-21 0:44:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic…
Jame Goat
  • 11
  • 3
1
vote
2 answers

Is there any way in MariaDB to search for less than value from array of json objects

Here's my json doc: [ { "ID":1, "Label":"Price", "Value":399 }, { "ID":2, "Label":"Company", "Value":"Apple" }, { "ID":2, "Label":"Model", "Value":"iPhone SE" }, ] Here's my table: …
Lankesh Zade
  • 83
  • 9
1
vote
2 answers

query logging in MariaDB on Windows 10

How to enable {all type of, not just slow} query logging to FILE in MariaDB Server version: 10.4.11 running on Windows 10 ? I have modified my.ini file and added these line at the bottom but it did not…
Sourav
  • 17,065
  • 35
  • 101
  • 159
1
vote
2 answers

MariaDB JSON remove key and its values

I have a TABLBE like CREATE TABLE `saved_links` ( `link_entry_id` bigint(20) NOT NULL AUTO_INCREMENT, `link_id` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `user_data_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, PRIMARY…
ErickBest
  • 4,586
  • 5
  • 31
  • 43
1
vote
1 answer

how to validate date null in mysql?

I'm working with MariaDB. when I try to show some result don't show me nothing. select if(fecha is null,'hello','bye') dat from table I'm trying to show me some result, but I don't know how?
Mau España
  • 124
  • 6
1
vote
1 answer

Mysql JSON update key value

I have a table like: CREATE TABLE `campus_tb` ( `campus_id` int(11) NOT NULL AUTO_INCREMENT, `campus_dataJSON` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`campus_dataJSON`)), PRIMARY KEY (`campus_id`) )…
ErickBest
  • 4,586
  • 5
  • 31
  • 43
1
vote
1 answer

SQL SELECT statement doesn't work for DELETE

I have an SQL statement that I am trying to run to delete an answer associated with a user_id and a username. The query works when trying to select, but doesn't work for delete. The error that I get on the DELETE statement is as follows: You have an…
Revvz
  • 455
  • 1
  • 6
  • 14
1
vote
4 answers

MariaDB 10.4 random performance degradation

I have a server with such parameters: OS: Ubuntu 18.04.4 LTS x86_64 Host: X11DPi-N(T) Kernel: 4.15.0-112-generic CPU: Intel Xeon Silver 4214 (48) @ 2.201GHz GPU: ASPEED Technology, Inc. ASPEED Graphics Family Memory: 18552MiB / 96336MiB SSD SAMSUNG…
Red October
  • 689
  • 2
  • 12
  • 31
1
vote
1 answer

How I can connect and fetch the data from multiple mysql databases on multiple severs?

I want to fetch data from multiple mysql databases which are on multiple servers. I'm using phpmyadmin (mysql). All the databases will be mysql database (same vendor) which are on multiple servers. First I want to connect to those server databases…
Rohit Swamy
  • 11
  • 1
1
vote
0 answers

Spring Data JPA Method threw 'org.springframework.dao.InvalidDataAccessResourceUsageException' exception While limiting the ResultSet

Problem: I want to fetch list of records with provided limit at JPA query/query Method level (using MariaDb). What I am trying or have tried: I have been trying to get List of POJO. I used JPA query @Query with LIMIT 1, but It's not accepting the…
Ram
  • 3,887
  • 4
  • 27
  • 49
1 2
3
…
10 11