Questions tagged [mariadb-10.5]
The mariadb-10.5 tag has no usage guidance.
mariadb-10.5
118
questions
0
votes
0
answers
17
views
libmariadb3 and libmariadb-dev not installing in ubuntu
When I try to install libmariadb3 or libmariadb-dev I'm getting the error Err:2 https://dlm.mariadb.com/re po/mariadb- server/10.5/repo/ubuntu focal/main amd64 mariadb-server-10.5 amd64 1 :10.5.25+...
2
votes
3
answers
90
views
Difficulties with MariaDB syntax using CTEs
I have the following query:
WITH intervals AS (
SELECT rom_opening_interval.start,
rom_opening_interval.end,
priority,
DENSE_RANK() OVER (ORDER BY priority DESC) ...
0
votes
0
answers
41
views
Mysql trigger after insert with on duplicate key
This code does not work and I can't figure out why.
I use it with OCS Inventory agent and it creates a 500 error on the agent inventory which means there is clearly a defect inside but there are no ...
0
votes
1
answer
198
views
mariabackup mysqld got signal 11
i got error when i take full backup of my mariadb 10.5 database:
mariabackup --host=$DB_HOST --port=$DB_PORT --user=$DB_USER --password=$DB_PASSWORD --backup --target-dir=$RESTIC_PATH
logs:
[01] 2024-...
0
votes
1
answer
89
views
JAVA Spring calling a Stored Procedure expects 3 parameters when there should only be 2
my repository is as following:
@Repository
public interface StatisticsRepository extends JpaRepository<CampaignStatisticModel, Integer> {
@Procedure(value = "getCampaignStatistics&...
1
vote
2
answers
795
views
Often aborted connections to db (MariaDB)
I have a Windows server running a MySQL server. There are two databases for different applications on the MySQL server.
In total, around 25 users access the database server every day.
The database ...
1
vote
1
answer
86
views
How does mariaDB stored mediumText
I am using mariaDB(10.5.15) , I have a table with structure like
CREATE TABLE Persons (
id bigint AUTO_INCREMENT,
entityId varchar(50),
encrypted_file mediumtext,
created_at datetime,
...
1
vote
0
answers
116
views
Multiple UNION query causes MariaDB to be stuck
I have the following query:
SELECT
col1
FROM
table1
WHERE
pid NOT IN (
SELECT pid FROM table2 WHERE pid IS NOT NULL
UNION
SELECT pid FROM table3 WHERE pid IS NOT NULL
UNION
...
1
vote
0
answers
394
views
Error while Trying to start mariadb service using brew
% brew services start mariadb
Bootstrap failed: 5: Input/output error
Try re-running the command as root for richer errors.
Error: Failure while executing; /bin/launchctl bootstrap gui/501 /Users/me/...
0
votes
0
answers
13
views
DB alternative for ISPC in combination with Magento2?
Hosting ISPC 3.2.11p1 on Debian(11) with 10.5.21-MariaDB-0+deb11u1 & nginx webserver.
Hosting multiple WordPress and static websites. Magento2 2.4.3-release was required, during install the ...
-2
votes
1
answer
104
views
Recursive CTE to generate all combinations sub groups within a group
I am trying produce an aggregated result for all possible combinations of rows linked by one column (package_id) but where another column (package_item_id) does not match.
I have a derived table ...
0
votes
3
answers
76
views
Retrieving min value in json array from MariaDB table
I have a MariaDB table including a JSON field:
{
arrayOfDates : ['2020-01-11', '2021-01, 12', '2019-03-12'],
...
}
For each record in my-table I need to extract the field arrayOfDates and ...
0
votes
0
answers
70
views
MariaDB Connect engine pivoting table with date values
I am working with an Innodb table in long format (training) and need to pivot this to wide format (pivTraining) reporting the latest (MAX???) date for each program.
I am using the following statement ...
1
vote
1
answer
153
views
can I instruct mariadb-install-db and mariadb to ignore 'user' setting in config?
If I want to set up a mariadb a database and start mariadb as a local user:
I can easily override parameters such as --datadir=$HOME/mariadb/data or --error_log=$HOME/mariadb/log/mysql_error.log,
but ...
1
vote
0
answers
22
views
Inconsistent Hibernate Behavior while using GenerationType.SEQUENCE
I see inconsistent hibernate behavior when using sequence to generate id, I have simple project with one entity Fruit and I'm using spring.jpa.hibernate.ddl-auto=create-drop so hibernate is launching ...