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.

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

GSSAPI on MariaDB

I'm using Maria 10.2.13 on Windows Server 2012 and I want to use GSSAPI authentication with it so that we can continue using windows auth. I have followed this tutorial: https://mariadb.com/kb/en/...
2
votes
0answers
13 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 ...
1
vote
1answer
144 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 ...
1
vote
0answers
758 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 ...
1
vote
0answers
42 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. ...
1
vote
1answer
205 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 ...
1
vote
0answers
320 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 ...
0
votes
0answers
56 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 ...
0
votes
0answers
109 views

1 Galera node freezes, rejoin is ok but not working

We have a 5-node Galera cluster in a high-load application. One of the nodes freezes in production. Still the cluster-size=5 and Galera/WSREP writes to this node, but the node is not working. Then we ...
0
votes
1answer
13 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 ...
0
votes
1answer
208 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 ...
0
votes
0answers
20 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 ...
0
votes
1answer
1k 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....
0
votes
0answers
74 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(...
0
votes
1answer
125 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 ...
0
votes
0answers
223 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 ...
0
votes
1answer
33 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 ...
0
votes
0answers
65 views

Prepared query refused by MySQL when using placeholders

I'm trying to make a prepared query but MySQL refuses to accept it when I use placeholders: This query works WITH x AS (SELECT 'root' as user_id) SELECT x.user_id FROM x LEFT JOIN user ON (x.user_id ...