Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [mariadb-10.3]

MariaDB 10.3 was released as stable (GA) with version 10.3.7 on 25 May 2018. Please also tag with mariadb for search purposes.

0
votes
1answer
30 views

Do the type-specific WKT- constructors function differently from ST_GeomFromText?

From the docs on MariaDB, for ST_LineStringFromText Constructs a LINESTRING value using its WKT representation and SRID. ST_LineFromText(), ST_LineStringFromText(), ST_LineFromText() and ...
1
vote
1answer
18 views

Subset of Unordered Pairs of Distinct Primary Keys With Normalization

I am currently in the process of designing a database. I have one table as follows: CREATE TABLE Set ( id INT PRIMARY KEY AUTO_INCREMENT, -- other values ); Now I wish to create another ...
0
votes
1answer
26 views

Can you update invisible columns

I'm trying to update the row_start column on a table with Versioning set. The row_start column is invisible. UPDATE pgwebp.t_prov a INNER JOIN pgwebp.t_prov b ON a.prov_id_a = b.prov_id SET a....
0
votes
1answer
22 views

How can I add another .ibd file to my existing table when the memory space is full?

I am working on an enterprise solution on MariaDB. The biggest challenge we are facing is to find a solution if our tablespace is full (.ibd file) and how can we add another .ibd file which will work ...
0
votes
1answer
19 views

Unable to create an user using mysql_embedded

I am creating a docker mariadb image and wanted to create a database and user name before bootstrapping mysqld daemon. So as per the documentation I tried below queries. mysql_embedded -e "CREATE ...
0
votes
1answer
26 views

How to use mysql_plugin utility?

I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that Cannot read plugin config file unix_socket. Bad format in plugin ...
0
votes
0answers
19 views

How to execute multiple concatenated queries?

I wanted to grant privileges on some selected tables only. So far I could only gather the necessary queries but unable to execute those. SELECT CONCAT('GRANT SELECT ON drupal.', TABLE_NAME, ' to ...
0
votes
1answer
14 views

How to lock all tables except some specific table?

I am trying to set a stage server which replicate some tables like articles, user etc from master. If I start the slave server as read_only I am not able to my stage site up because there are some ...
0
votes
1answer
26 views

MariaDB replication from master to slave

After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them. I am ...
0
votes
1answer
29 views

MySQL vs. MariaDB Binary Logging Difference

I've been doing some testing with both MySQL and MariaDB and I've noticed a big difference with regards to the growth of binary logs - I can't find out much about this online. I have a test database, ...
0
votes
1answer
52 views

ERROR 1130 (HY000) not allowed to connect to this MariaDB server facing issue in granting permission

I am trying to connect to mariadb running different container.Getting below error $ mysql -u root -h test-mysql --port 3306 ERROR 1130 (HY000): Host 'test_1_73f6dacd1d23.test_bluenet' is not allowed ...
1
vote
1answer
36 views

MariaDB uses “wrong”/irrelevant Keys on large table

We have migrated our database from a local hosting company to AWS. Now when we run a particular query on AWS it finishes in about a minute (processlist says "sending data") where on the old server the ...
0
votes
0answers
27 views

Resolving “there is unknown charset/collation names” warnings on views

I recently moved our MySQL 5.6 server over to MariaDB 10.3.10 and, for the most part, have not had any problems. We have a couple of databases that have close to 1000 views which are now filling the ...
0
votes
2answers
50 views

Log full of [Note] InnoDB: ft_end() after upgrade to MariaDB 10.3.10

My upgrade path was MariaDB 10.2.18 to MariaDB 10.3.10. There are no bugs reported on mariadb or mysql bug tracker (at least that I could find). ... Oct 24 17:45:33 host1 mysqld[12196]: 2018-10-24 ...
1
vote
0answers
90 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
votes
0answers
18 views

mariadb service won't shutdown when running and the OS time update backwards

When I update the OS datetime backwards while mariadb is running, it causes mariadb to hang when I command it's service to stop. I've also noticed that this doesn't occur when I set the new OS ...
1
vote
1answer
14 views

How to update MariaDB if the current version is not in default directory?

I will try to update my MariaDB from 5.5.56-MariaDB to 10.3.9-MariaDB. However my current version was configured or located into another directory. How should i do it?
0
votes
1answer
28 views

MariaDB - how to drop partition on master but not on slave

I've read about filtering replication and I only run into information I know already, like you can select only a database or a table to do replication on. My use case is that I want to have a slim ...
2
votes
1answer
232 views

MySQL Workbench Visual Explain not working with MariaDB 10.3.9

I recently installed MySQL Workbench 8.0.12 and MariaDB 10.3.9. I created my database and want to start fine tuning indexes and views. I can run a query with the EXPLAIN button and get the results in ...
4
votes
2answers
120 views

What are “Invisible Columns” and how are they used?

I saw a new feature Invisible Columns in MariaDB 10.3.x. What are practical use cases for DBA and web developer? When to use this feature? Columns can be given an INVISIBLE attribute in a CREATE ...
0
votes
0answers
68 views

MariaDB galera cluster with Mroonga in wrapper mode doesn't synch

MariaDB Galera Cluster states that the storage engine needs to be InnoDB. I am using Mroonga on some tables in wrapper mode {which uses InnoDB under the hood as storage engine}. The problem I am ...
1
vote
1answer
200 views

MariaDB doesn't set authentication_string during installation

I'm setting up a new server using MariaDB (current stable version of 10.3) and I notice that all of my users - mainly root and debian-sys-maint - do not have an authentication_string after the ...
0
votes
1answer
1k views

Can upgrade from MariaDB 5.5 to MariaDB 10.3 directly?

We have a database running in MariaDB 5.5.60 and we want to upgrade it to the last 10.3.7 version. However I'm looking at MariaDB knowledge base ( https://mariadb.com/kb/en/library/upgrading/ ) and I'...
0
votes
2answers
155 views

How to filter for consecuting timeline events in pure SQL?

I run a LPR system on a parking lot, and I record every plate along with the camera that recorded it. I have 2 cameras, camera 1 is on the entry and camera 2 on the exit. So for every reading I ...
1
vote
1answer
378 views

Does MariaDB or MySQL implement the VALUES (expression) table value constructor?

I am just wondering if MariaDB or MySQL implements the <table value constructor> in the SQL Spec. In SQL Server and PostgreSQL this is done with standardized VALUES (expression)? SELECT * FROM (...