mariadb-10.2 is an open source database server that offers Window Functions for Analytical Queries.
Questions tagged [mariadb-10.2]
28 questions
4
votes
1 answer
Row vanished from MySQL, could the maximum allowed size be the cause?
I have a table that holds some data.
From the log, I can see that it inserted a record, and got its ID.
The ID came from MySQL as it’s an auto-increment. Then, about 2 seconds later, that record must have vanished as, from a log, I can see it could…
user5542121
- 1,051
- 12
- 28
3
votes
1 answer
Extract JSON Value from Table
I have a MariaDB table called genres with these columns (genres is a JSON column):
+----+------------------------------------+
| id | genres |
+----+------------------------------------+
| 1 | ["Action", "Martial Arts",…
GTS Joe
- 3,612
- 12
- 52
- 94
2
votes
2 answers
Find out the sum of all the elements in json array in mysql with filtering
I am using mariadb version 10.2.43-MariaDB-1:10.2.43+maria~bionic
Table schema
The table has a columns id attribute and details array with the following two rows of data :
{
"id": 9,
"details": [
{
"amount": 100,
"flag": true,
…
Gourav Roy
- 163
- 1
- 2
- 5
2
votes
2 answers
mysql FUNCTION GROUPING does not exist
When using WITH ROLLUP I receive this error:
#1305 - FUNCTION GROUPING does not exist
My DB version:
innodb_version 5.7.28
version 10.2.30-MariaDB
Strange that WITH ROLLUP works, but not GROUPING(). I would like to replace the nulls
Any…
Frits Nagtegaal
- 61
- 1
- 6
2
votes
1 answer
5th percentile on MySQL (MariaDB)
I'm trying to find the 95th percentile (and the highest buy) of the item-price using the order in my ~300k row table.
I've been successful in finding the 95th percentile and the highest buy for one single item with this code:
SELECT type_id,
…
TheJozzle
- 23
- 4
2
votes
2 answers
How to flatten a table from row to columns
I use MariaDB 10.2.21
I have not seen this exact case elsewhere, hence my request for assistance.
I have a History table containing one record per change on any of the fields in a JIRA…
Szjoin
- 47
- 1
- 6
1
vote
1 answer
mysqld got signal 6 when running simple query
I've started having mysql crashing and restarting. The system has been completely stable, and this has started happening after creating the following table. I successfully inserted about 210,000 records using a INSERT INTO command. But then I…
TipsTrade Ltd.
- 126
- 9
1
vote
3 answers
Access denied to remote user when doing LOCK TABLES
I'm running mariadb-server v10.2.33-1 on two openwrt-qemu systems. I want a remote user to achieve LOCK TABLE on a particular table.
In the local mysql server, I have created a remote user and granted LOCK TABLES privilege using the following…
Arijit Pramanick
- 11
- 4
1
vote
3 answers
Select rows from a table, ignore rows until a field value is encountered
Let's say I have a table that contains information about user savings to a thrift society and the assessment of each deposit type as good or bad based on internal logic. How do I select rows from this table so that all preceding rows to the last…
Olaseni
- 7,698
- 16
- 44
- 68
1
vote
1 answer
MariaDB 10.2 , jdbcCompliantTruncation=false not working
We have migrated from MariaDB 10.0 to 10.2 and now facing an issue related to data too long for column
We were using jdbcCompliantTruncation=false in the DB connection string for MariaDB 10.0, and it was helping in truncating the long values for…
Sunil
- 364
- 1
- 14
0
votes
1 answer
MySQL update 10.2 to 11.0 with yum issue (centos 7.9)
After I changed repo for Marinadb from 10.2 to 11 and launch yum update the server stack on error with not update/remove marinadb-server.
-bash-# yum -y update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving…
Intacto
- 527
- 3
- 8
0
votes
0 answers
Having connection issue while connecting to MariaDb Galera cluster using mariadb jdbc connector plugin
Error: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: (conn=6037539) Client does not support authentication protocol requested by server;…
0
votes
0 answers
Insert into two tables simultaneously, using **ID**(primary key, auto increment) from first table to store data on second table
I need to store data on two tables simultaneously.
with first table window having columns (ID, start_time, stop_time, message) and second table windowClients having columns (ID, Clients).
ID is auto-incremented in table window, i want to insert…
yadavender yadav
- 101
- 6
0
votes
2 answers
Select row with most recent date per location and increment recent date by 1 for each row by location using MariaDB
I have a table of location which has 'Date column'. I have to find recent date by each group of locationID for e.g. locationID 1 has most recent date '31 May 2022'. After finding recent date from the group of locationID I have to add 14 days in that…
Rob04
- 11
- 2
0
votes
0 answers
MariaDB init_connect not working for one user
I have strange problem, im using 10.2.27 mariadb version .
created procedure for auditing user connections using init_connect parameter to call the procedure.
this procedure working for all the users except one user who is having REPLICATION CLIENT…
Prabhakar
- 1
- 1