Questions tagged [mariadb]
MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.
mariadb
14,480
questions
0
votes
1
answer
26
views
Trigger to get a column value from tableA to tableB by select statement
Table1
CREATE TABLE `active_year` (
`ActiveYearId` int(8) UNSIGNED NOT NULL PRIMARY KEY ,
`StartYear` date NOT NULL,
`EndYear` date NOT NULL,
`ActiveId` tinyint(1) UNSIGNED NOT NULL
) ENGINE=...
-1
votes
0
answers
16
views
HikariCP Read timed out
I've been getting the following stack track in my production logs, but haven't been able to determine a process to reproduce the errors or a reason why the error is occurring. Any clues regarding the ...
0
votes
2
answers
23
views
Shell script not working when run as wsrep_notify_cmd by Galera Cluster for MariaDB
I have a simple shell script that I'm trying to use to test Galera Cluster for MariaDB's node state change notification mechanism, running on an AWS Ubuntu 20.04 LTS instance. The script is a ...
0
votes
1
answer
26
views
Use of GROUP_CONCAT() results in error 1064
I have a very simple table:
CREATE TABLE `invoice_physician` (
`INVOICENR` varchar(12) NOT NULL,
`PHYSICIAN` varchar(255) NOT NULL DEFAULT '',
`modified` timestamp NOT NULL DEFAULT ...
0
votes
0
answers
15
views
What would be a good way to establish communication between servers with a queue?
I'm looking for a decentralized way to exchange messages (JSON) between two linux servers. The difficult thing is making sure the messages arrive in case of an outage. Its crucial, that no message ...
-1
votes
0
answers
19
views
MariaDB Over SSH Tunnel Lost Connection
I have two RHEL9 servers. I turned off SELinux on both using "sudo setenforce 0" to make sure that has nothing to do with this issue.
I am on server 'admin' and I am trying to connect to ...
0
votes
0
answers
57
views
Is it possible for PHP/PDO/MySQL to perform a transaction on its own? [closed]
I have ZERO transaction code in my PHP script. That was done on purpose. My application is too simple to need it.
Starting less than a week ago, without any code changes on my part, records written to ...
0
votes
1
answer
39
views
An efficient way to insert data into MariaDB [duplicate]
I have an API, created with TypeScript and Node.js which is connected to the MariaDB database. For database communication I am using „mariadb“ package.
One of the calls accepts payload with the data, ...
0
votes
0
answers
76
views
Using PHP/PDO/MySQL: Records have started vanishing (literally) without changes to the code [closed]
I assume whoever closed this because it "lacked detail or clarity" didn't actually read the whole thing. Or, perhaps, thought I was just an idiot.
I know, the subject line makes no sense -- ...
0
votes
1
answer
60
views
SQL - Display 0 on a count with months where there is no data [closed]
I hope someone can help.
I have been attempting to tackle this problem for some time. I have two tables "admissions" and "month data".
The admissions table contains the two fields &...
0
votes
1
answer
37
views
System.NotSupportedException: Versions of MySQL prior to 5.6 are not currently supported
I am not able to connect to MariaDB with EF. I am using libraries:
MySql.Data v9.0.0
MySql.Data.EntityFramework v9.0.0
MariaDB version: 10.5.8-MariaDB-log
My app.config
<entityFramework>
&...
1
vote
0
answers
19
views
How to disable binary logs in RDS using MariaDB?
I am using MariaDB 10.11 on Amazon RDS and want to disable binary logs.
I created a custom parameter group but can't find the appropriate option. It seems that MySQL binary logs can be disabled using ...
2
votes
1
answer
47
views
Using REGEXP or REGEXP_SUBSTR in an MariaDB query to extract all of the image source links
I'm trying to use REGEXP in an MariaDB 11.0.2 query to extract all of the image source links within the HTML and text of the field post_content that is in each row in wp_posts. I've looked at related ...
3
votes
2
answers
98
views
concat two column in mysql , one of them is an auto-increments, using trigger
Dears, please below is my first trigger to make a column as a concat a two column .. but it is not working ?! can i know where is the error
create table `concatcolumn`(
`id` int(10) ...
-1
votes
0
answers
14
views
Fixing the server restart problem for MySQL database replication using XAMPP
So, I have successfully created a Master-Slave replication between 2 machines using XAMPP. There are a few problems I am facing:
1- Each time I try to see the logs in the Master, the position changes, ...