Questions tagged [mariadb]
MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.
mariadb
14,494
questions
0
votes
1
answer
4
views
Galera syncronized but tables content looks different
I have a Galera replication between two mariadb 10.6.18 servers on ubuntu 22.04.
Checking the syncronization it seems ok.
SERVER 1
SHOW STATUS LIKE 'wsrep%';
+-------------------------------+----------...
- 9,400
0
votes
0
answers
10
views
Mysql error: Foreign key constraint is incorrectly formed [closed]
show create table in MariaDB 10.6.18 on Ubuntu server 22.04:
CREATE TABLE `transazioni` (
`id` char(16) NOT NULL,
`sistema` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ...
- 9,400
0
votes
1
answer
25
views
Linker Error with MariaDB Connector/C++ When Using CMake
I'm encountering a linker error while trying to build a project using the MariaDB Connector/C++ 1.1.4 on Windows with CMake. I installed the MariaDB Connector/C++ from the MariaDB download page and ...
0
votes
0
answers
5
views
Springboot not clearing Hikari Pool when refreshing datasource
I am trying to update my datasource with dynamic credentials that I get via Hashicorp Vault. I followed this tutorial: https://developer.hashicorp.com/vault/tutorials/app-integration/spring-reload-...
- 1
0
votes
0
answers
21
views
display hierarchical data with MariaDB query?
I am trying to display hierarchical data with MariaDB (V.10.4.32-MariaDB) query, to show relationships,( like list of recipes, corporate org chart or program hierarchy). I can do some manipulation in ...
- 39
0
votes
1
answer
13
views
Im using Xampp and phpmyadmin, why is there no account_locked column in mysql.user
Why is there no account_locked column in mysql.user, when i try to find it using
Select user,host,account_locked FROM mysql.user;
and this error appears
ERROR 1054 (42S22): Unknown column '...
- 1
-1
votes
1
answer
36
views
Is the batch processing speed of Python slower than that of Java?
I am working on migrating a function implemented in Java Spring Boot to Python Django.
I encountered an issue while migrating a function that retrieves a list of keywords through a select query and ...
- 3
0
votes
0
answers
10
views
SQL Query Hours subtracted from Request if opened after a certain time and passes next day time
My users create tickets for our quality group to come inspect projects. sometimes they create requests at the end of the day that the Quality team wont get to until the next morning.
Our Quality Team ...
- 1
-1
votes
0
answers
17
views
How to run mariadb in the docker build phase
I am trying to run mariadb in my dockerfile. The dockerfile's job is to build my app and leave a Docker image ready to run.
Some of my unit tests - that are part of the build - need mariadb to run.
...
- 847
0
votes
0
answers
16
views
Excessive Swap Memory Usage in MariaDB Server: Causes and Solutions? [migrated]
I am currently experiencing an issue with my MariaDB server where it is excessively using swap memory, leading to significant performance degradation. I am not sure why the swap memory usage is so ...
- 1
0
votes
0
answers
31
views
MariaDB 10 -> 11 migration, the 11th version stopped using possible_keys
I faced the issue during migration from MariaDB 10.11 to 11.0 version that some specific queries run longer.
During running EXPLAIN output I got this.
MariaDB 10.11
MariaDB [my_schema]> EXPLAIN ...
- 101
-1
votes
0
answers
12
views
xampp server could not be connected from another pc in the same network of windows 11 [closed]
A program developed in PyQt6 deployed in two PC in the same network. XAMPP server s installed in a machine having IP 192.168.29.100. The program reads required connection details from a text file that ...
- 19
0
votes
1
answer
51
views
How do I use MariaDB with POCO (https://pocoproject.org/), using C++ on Windows. Like how do I link in the MariaDB libraries etc. in CMake
this is the first time I've tried to link MariaDB to a C++ program in CMake
MariaDB MySQL version: 10.5.21 (what server uses)
The CMakeLists.txt that I have currently, that doesn't work looks like ...
0
votes
0
answers
21
views
Setting MariaDB encryption [migrated]
Hello I need to Configure a MariaDB server to provide data encryption during storage. I am performing the task on linux oracle 9. when I try to restart the server, I get the following message
[vagrant@...
-2
votes
0
answers
24
views
Can't connect to server error on raspberry pi [closed]
So this is my first time setting up a web server on my raspberry pi and the goal is to be able to take sensor readings from an arduino nano I have connected to my raspberry pi. These readings will be ...
