Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [mariadb-10.2]

MariaDB 10.2 was released as stable (GA) with version 10.2.6 on 23 May 2017. Please also tag with mariadb for search purposes.

22 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
439 views

Finding temporary table name in MariaDB

As I reported some days ago to MariaDB bug tracker the following bug: https://jira.mariadb.org/browse/MDEV-17420, slave replicas with version 10.2.x are leaking temporary tables on MyISAM files. Our ...
Gabriel Gomiz's user avatar
2 votes
0 answers
27 views

Enforce existence of cartesian product in join table without triggers in MariaDB 10.2

Given tables A, B and C, where C holds a foreign key to both A and B (i.e. C is a "join table"), is it possible to define a constraint so that C contains the whole Cartesian product A x B without ...
Tobias Bengtsson's user avatar
1 vote
0 answers
270 views

How can I prevent overload of Mariadb server?

I'm running MariaDB 10.2.27 on Ubuntu 16.04 (10 cores, 40 GB RAM). We have a queued message handling system (using Symfony Messenger) that normally has 20 workers consuming messages from the queue. ...
lfjeff's user avatar
  • 101
1 vote
1 answer
846 views

Mysql service stops with [ERROR] InnoDB: CORRUPT LOG RECORD FOUND

In my Plesk Obsidian version 18.0.42 running on CentOS Linux release 7.9.2009 with MySQL version 10.2.43-MariaDB. All of a sudden database stopped working. Mysql service never comes up on start ...
nisamudeen97's user avatar
1 vote
0 answers
236 views

mariaDB 10.2: sql mode has changed

The Upgrading from MariaDB 10.1 to MariaDB 10.2 states: SQL_MODE has been changed; in particular, NOT NULL fields with no default will no longer fall back to a dummy value for inserts which do not ...
nulll's user avatar
  • 151
1 vote
1 answer
301 views

Connection aborts is happening in MariaDB 10.2 but not in 10.1 even with log_warnings level set to 2

I am noticing different behavior in mariadb 10.1 & 10.2 reg.connection aborts. I noticed connection getting aborted after 7 minutes(wait_timeout) of any query execution. There are few random ...
ragul rangarajan's user avatar
1 vote
0 answers
606 views

Why is PDO::ATTR_EMULATE_PREPARES = false causing "MySQL server has gone away" errors?

I've been using PHP PDO with the default setting of ATTR_EMULATE_PREPARES = true and it was working fine. However, I wanted to be able to select database values as integers instead of having them ...
lfjeff's user avatar
  • 101
1 vote
0 answers
1k views

MariaDB 10.3 slave fails to replicate from a MariaDB 10.2 master

We have a 10.2.18 master and 4 slaves with 10.2.18. Because of this bug that I've reported last week (https://jira.mariadb.org/browse/MDEV-17420) we tried to upgrade one of the replicas to 10.3.10 to ...
Gabriel Gomiz's user avatar
1 vote
0 answers
57 views

MySQL InnoDB stop locking when large sql is executed

We face a issue that the InnoDB table is locked, when a sql file that is executed is large than a certain file size. The problem does not appear when the file size is much lower, for example 25MB. ...
JGeer's user avatar
  • 111
1 vote
1 answer
318 views

Setup replication between two Galera nodes

I've been using MariaDB 10.2 Galera with 3 nodes successfully on local servers. Now, I have a second 3-nodes Galera cluster on another location, joined by an Site-to-Site IPSec Tunnel. I can't really ...
Hakujou's user avatar
  • 11
1 vote
0 answers
392 views

Unable to install Mariadb on Fedora 27 due to SELinux issue

I followed these instructions in installing mariadb on my fedora 27 VM. My mariadb.repo is configured as follows: [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.2.12/fedora26-amd64 ...
Dark Star1's user avatar
0 votes
1 answer
38 views

Can't export MariaDB large table by mysqldump when row_format is compressed

I have a MariaDB 10.2.13 server. This server contains a database called 'factory'. This database contains a table called 'client'. This is a large table. client table structure: CREATE TABLE `client` (...
user3637971's user avatar
0 votes
1 answer
143 views

Unable to DROP or MODIFY a column because row size is too large

I've tried to ALTER the table to DROP the unused columns or to change the data type of some VARCHAR columns to TEXT, but I always get this error: ERROR 1118 (42000) at line 1: Row size too large (>...
lfjeff's user avatar
  • 101
0 votes
1 answer
24 views

Why is it not possible to "SELECT" Data as parameters for certain clauses like LIMIT?

EXAMPLE: CREATE TABLE t (A INT); INSERT INTO t VALUES(1),(2),(3),(4),(5); This works: SELECT A FROM t WHERE A=(SELECT 1) This does not: SELECT A FROM t LIMIT (SELECT 1); This works: SELECT A ...
ashycharlize's user avatar
0 votes
0 answers
31 views

MariaDB Replication - Missing ^M Characters on Slave

I've got a simple single master->slave replication setup with MIXED binlog format for mariadb 10.2.22-1 on RHEL7. I believe I'm having an issue where '^M' characters in a longtext column are not ...
TheOneWhoDoesItAll's user avatar
0 votes
1 answer
3k views

Mysql_upgrade fails, table is corrupted

I have a mariaDB with a table that is corrupted. It's useless data to me, so I've tried to drop the schema but it won't drop. Instead, it gives me this error when trying to drop it: "Error Code: 1805....
Yodavish's user avatar
0 votes
0 answers
203 views

Fulltext search in a CTE result - missing fulltext index

My question applies to MariaDB 10.2.7 The query WITH prefiltered AS ( SELECT id, fulltext_indexed_column FROM fulltext_table WHERE id < 30 ) SELECT * FROM prefiltered WHERE MATCH(...
Martin's user avatar
  • 101
0 votes
1 answer
323 views

MariaDB 10.2.22 Galera Cluster Using Bad Indexes After Analyze

I'm using Drupal on a MariaDB Galera 10.2.22 3 node cluster and I'm having some problems with one query. I have a table (InnoDB) called field_data_field_department which has a bunch of indexes. If I ...
Charles Tassell's user avatar
0 votes
0 answers
424 views

MariaDB 10.2 crash on innodb table corruption - trying to restore the database

I'm running MariaDB 10.2 on Windows and had some hard drive corruption on my server that messed up some innodb tables. Unfortunately this also affected backups, so I'm trying to dump the tables and ...
Justin M's user avatar
0 votes
1 answer
363 views

perform non locking select when updating another table

We need to perform the following (periodic) query in mariadb: update A set status='INACTIVE' where status='ACTIVE' and a.b_id in (select id from B where ... LOCK IN SHARE MODE); Unfortunately it ...
Roman's user avatar
  • 101
0 votes
1 answer
2k views

Mysql service down with [ERROR] InnoDB: Page log sequence number is in the future

I have a Centos 7.9 server with MariaDB version 10.2.43. All of a sudden on May 2 2022, I have started receiving mysql down alerts. On checking I could see below log information in logs. Error 2:- ...
nisamudeen97's user avatar
-1 votes
1 answer
678 views

Mariadb encryption

I have a requirement to encrypt certain column of DB tables. Going through the links, have followed the below steps: In /etc/my.cnf [mysqld] plugin-load-add = file_key_management ...
Pooja's user avatar
  • 1