I ran into an issue where MariaDB in XAMPP refused to start and showed this error: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed Fatal error: Can't open and ...

DELIMITER // CREATE FUNCTION total_cost_for_customer ( custNumber INT ) RETURNS INT DETERMINISTIC READS SQL DATA BEGIN DECLARE total INT; SELECT SUM(unitPrice) INTO total FROM ...

First of all, Qt version is 6.10.0, testing on Arch Linux rolling. I think I've found a bug in Qt but maybe it's just my fault. My program asks MariaDB database for some data and displays it in ...

I would like to store data remotely in a MariaDB (Xampp) running on Ubuntu. It is running on a totally isolated LAN - no external connection. I have been looking at various places, but seem to be more ...

Situation I have two tables. ing_master is a master list of ingredients; pdet is a product table, with an ingredients field formatted as json array. For each product's ingredient list in pdet, I want ...

I'm trying to help a user in another stackoverflow question and have bumped by head into a strange behaviour. As I rarely use MariaDB, I'm opening another question to investigate the behaviour, ...

I am using MariaDB v10.11.15 (a MySQL fork) which does not support the LATERAL keyword, to lookup the countries of 30 IPv4 numbers. I have the following query that retrieves the country when given an ...

MariaDB version is 10.4.34. The query looks like: SELECT bet.* FROM Bet bet WHERE bet.placed >= '2025-10-29T00:00:00' AND bet.placed <= '2025-10-29T23:59:59' AND EXISTS ( SELECT 1 FROM ...

I'm getting a number of these errors printed in the systemd journal when i restart mariadb: Nov 07 17:56:05 p2 /etc/mysql/debian-start[8427]: -------------- Nov 07 17:56:05 p2 /etc/mysql/debian-start[...

I’m running an application on JBoss 7 connected to a MariaDB database hosted on a separate AWS EC2 instance (c5.9xlarge). The SQL query execution itself is extremely fast (around 57ms), but when ...

I have four tables, one primary and three dependents, let's call them A, B, C and D. All tables have the column ID, with ID being the primary key for A and the foreign key for B-D. B-D also have a ...

I have a MariaDB cluster made with Galera and my clients use MaxScale with RW router. I'm having an issue because the application has something this sequential steps: Start trx1 Insert new record ...

The Laravel project on production continues to show the error below intermittently: SQLSTATE[HY000] [1130] Host 'localhost' is not allowed to connect to this MariaDB server (Connection: mysql, SQL: ...

we have a Galera (wsrep_provider_version 4.23) cluster over 3 MariaDB 11.8.3 nodes. Our application has a number of migration scripts (about 50) that run on startup, via Flyway. At some point in the ...

I have this insert query for my MariaDB 10.6.19 database: CREATE TABLE manufacturers ( manufacturers_id int(11) NOT NULL AUTO_INCREMENT key, manufacturers_name varchar(32) unique NOT NULL, ...