Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.3]

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL.

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL. Since version 10.0 MariaDB has veered off MySQL and now implements a different set of features.

MariaDB 10.3 implements system-versioning tables, PERCENTILE_CONT(), PERCENTILE_DISC(), and MEDIAN() window functions, INTERSECT and EXCEPT clauses, cursors with parameters, LIMIT in multi-table updates, LIMIT in GROUP_CONCAT(), and many other new features.

171 questions
0
votes
2 answers

Is there a limit for simultaneous transactions in MariaDB?

There is Centos 7 server with Asterisk PBX 11.25.3 and mysql Ver 15.1 Distrib 10.3.18-MariaDB, for Linux (x86_64). extensions.conf: [from-main-asterisk] exten => _9XXXXXXXXXXXX,1,MYSQL(Connect connid localhost root rootpasswd mydatabase) exten =>…
harp1814
  • 1,494
  • 3
  • 13
  • 31
0
votes
0 answers

MariaDB 10.3.18 does not recognize any command line options

I have a CentOS 7 box on which Mariadb 10.3.18 is installed from the mariadb repo. After recent update via yum, the mysqld is no longer accepting any command line parameters: # mysqld --print-defaults mysql: unknown option '--print-defaults' it…
user2531657
  • 339
  • 2
  • 9
0
votes
0 answers

how can I upload large SQL DB files into myphpadmin? (Using MariaDB 10.3.7, Innodb, PHP 7.2 on the synology server)

I have been stucked with large sql file uploading into my phpmyadmin. I'm using the synology DSM 6.2, wordpress, MariaDB 10.3.7-0051, PHP 7.2, innodb, apache http 2.4 server. My exported sql file size is about 360M but whenever I upload the sql file…
BurstWatermelon
  • 1
0
votes
1 answer

SQL Group rows in left join into one

i try create query with left join when i combine multiple rows into one. I try with GROUP_CONTENT function but when i try use it my db server is going down. I use MariaDB 10.3.17. I have tables like: Games: game_id game_name 1 Test 2 …
Patryk Tchórzewski
  • 125
  • 2
  • 16
0
votes
1 answer

JDBC Authentication Failure from Dockerized SpringBoot to External MariaDB

I am encountering a problem with a SpringBoot web service failing to successfully authenticate to a bare metal MariaDB 10.3.8 database when the SpringBoot service is run from inside a Docker container. The same SpringBoot service JAR connects…
stratfanstl
  • 1
  • 1
0
votes
2 answers

Get the latest order_date after aggregation my rows

I have 2 tables: Customers table (which has a customer_id column) Orders table (which has customer_id and order_date columns) Is there a way to fetch all orders count for each customer with the latest order date in a single query ordered by the…
MAZux
  • 911
  • 1
  • 15
  • 28
0
votes
1 answer

MariaDB 10.3.16 inserting multiple rows with a single data entry

MariaDB is inserting unknown rows before the actual data in a single insert statement. Example insert into my_table (id_person, id_department, job_date) values (1, 1, '2019-01-01') when you do a select * from my_table you'll get, for example, but…
Leandro Jacques
  • 413
  • 5
  • 19
0
votes
2 answers

How to find parent based on node level

I have table tbl_budget with columns id, budget_code and level. Level tell the hierarchy current table view i want to find the parent of each budget code based on its level this query do find first level parents fine, but not after that SELECT…
Irfan Zafar
  • 21
  • 5
0
votes
5 answers

How chceck is id is used in other column in same table

I'm using MariaDB 10.3 and I have table like: post_id post_content post_user_id post_shared 1 Test1 1 0 2 Test2 2 0 3 Test2 1 2 post_shared = 0 means this is original post…
Patryk Tchórzewski
  • 125
  • 2
  • 16
-1
votes
1 answer

Syntax error during creation of trigger on mySQL 10.3.17-MariaDB-log version

I'm trying to add a trigger that should automatically update a datetime column only if is not present a SQL variable. The trigger code is the following delimiter | CREATE TRIGGER update_sync_date BEFORE UPDATE ON posts FOR EACH ROW BEGIN IF…
Alessandro Cerutti
  • 39
  • 3
-1
votes
1 answer

MariaDB server version for the right syntax to use near 'FOR CHANNEL 'master1_test116'' at line 1

MariaDB [(none)]> CHANGE MASTER TO MASTER_HOST='192.168.56.116', MASTER_PORT=3306, MASTER_USER='replica1', MASTER_PASSWORD='pass@123', MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=327 FOR CHANNEL 'master1_test116'; ERROR 1064 (42000): You…
Manish
  • 1
-1
votes
1 answer

SQLAlchemy ORM is not updating row

I am using SQLAlchemy ORM with MariaDB (mariadbconnector). The database updates with the add_conversation function but when trying to update a value it does nothing and there is no error. Instead of filter_by() I tried get() but then I received this…
user3079103
  • 49
  • 1
  • 7
-1
votes
1 answer

Getting errors with my mariadb-10.3 version

I'm looking for a function that insert data if they are not existing. I tried with IF not exists but I think that my mariadb version is no up enought to handle this. So I'm trying with NOT IN, but get the same issue... CREATE…
C0casio45
  • 11
  • 1
  • 4
-1
votes
2 answers

Unable to get where query working in not in

DELETE FROM `tblinvoices` WHERE userid NOT IN (SELECT f.id FROM `tblclients` f); I am running the above query to delete invoices where the userid doesn't exist in the client pool. In theory, each part of this query works individually but when…
Charlotte Wells
  • 375
  • 1
  • 2
  • 8
-1
votes
1 answer

How i can solve this problem "systemctl start mariadb"

I am facing this error root@localhost:~# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. root@localhost:~#…
VINIT KUMAR
  • 1
  • 4
1 2 3
…
11
12