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
50
votes
16 answers

SQLSTATE[HY000]: General error: 1835 Malformed communication packet on LARAVEL

Suddenly got SQLSTATE[HY000]: General error: 1835 Malformed communication packet (SQL: select * from tb_users where (username = 121211) limit 1) on Laravel. I already checked this: MySQL: ERROR 2027 (HY000): Malformed packet, but it seems a…
wbhuana
  • 845
  • 1
  • 7
  • 8
32
votes
13 answers

Getting error "Plugin 'InnoDB' registration as a STORAGE ENGINE failed" when starting MySQL

I found many similar question on Stackoverflow but didn't get the exact error solution. My issue is when starting MySQL service on one of the Dedicated Centos 6.5 machine, I am getting error : 141018 05:13:46 mysqld_safe Starting mysqld daemon with…
Ritesh Kumar
  • 2,183
  • 2
  • 20
  • 32
5
votes
2 answers

Update a field with specific value inside a Json Object with MariaDB

I'm trying to update the data stored in a json column in MariaDB (libmysql version - 5.6.43 , Server: 10.3.34-MariaDB-cll-lve - MariaDB Server). My data is structured like this: ID json_data 1 {....} 2 {....} where json_data is…
Jean
  • 453
  • 4
  • 16
3
votes
1 answer

Symfony SQLSTATE[42000]: Syntax error or access violation: 1064 during flush()

we use Docker and Symfony 5.6, PHP 8.0, xcaddy v2.7.3 and MariaDB 10.3.34 with Doctrine. The application is divided into cron, caddy, node, php, db, db-backup and mailer containers. The problem occures when creating any new entity and trying to save…
leon
  • 31
  • 2
3
votes
1 answer

Filtering on datetime field works different for SELECT and DELETE

I have following code: CREATE TABLE test_tab ( create_time datetime(6) NOT NULL, PRIMARY KEY (create_time) ); INSERT INTO test_tab (create_time) VALUES ('2023-04-21 00:17:24.000000000'); COMMIT; SELECT * FROM test_tab WHERE create_time =…
enedil
  • 1,605
  • 4
  • 18
  • 34
3
votes
2 answers

Convert table to JSON array with longtext column

I'm using mariaDB 10.3, I have a table: CREATE TABLE user(id INT NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL, parameters longtext, PRIMARY KEY(id)); With rows: INSERT INTO user VALUES (1, 'name1', '{"number": 1, "text": "some text"}'), (2,…
friltase
  • 33
  • 4
3
votes
1 answer

Why MariaDB try to preallocate a very large size of file when update table schema

When my SpringBoot application try to update a table schema via JPA, the mariadb instance preallocated a very huge size of file(almost 100GB, at /rdsdbdata/tmp/#sql_4c44_0.MAI),then the server storage become full immediately and cause the db…
yimlu
  • 175
  • 1
  • 12
3
votes
3 answers

mysql not using index on simple OR condition

I have ran into the age-old problem of MySQL refusing to use an index for seemingly basic stuff. The query in question: SELECT c.* FROM app_comments c LEFT JOIN app_comments reply_c ON c.reply_to = reply_c.id WHERE (c.external_id = '840774' AND…
jurchiks
  • 1,354
  • 4
  • 25
  • 55
3
votes
2 answers

Mysql Employee break time history with time difference

I have employee biometric log data with inoutmode flag. I am trying to get detail break time list and with time difference. inoutmode 4 as break-out and 5 as break-in. INSERT INTO `tbl_downloadentry` (`EmpMachineID`, `shift_date`, `AttenTime`,…
Yathav Sri Technology
  • 127
  • 1
  • 9
2
votes
2 answers

Slow queries for specific table after upgrading MariaDB 10.3 to 10.11

I recently upgraded our db servers from MariaDB 10.3 to 10.11 and one of our tables takes significantly longer to query than it did on 10.3. The following simple query takes about 10 seconds to query on 10.11, and it runs instantly on 10.3. The…
Nate L
  • 21
  • 3
2
votes
0 answers

Get category level in parent child table

I have category table which have category in parent and child relation For example, | cat_id | cat_parent_id |cat_name| | -------- | -------------- |--------- | 1 | |Car | 2 | 1 |Porsche | 3 | 2 …
Vishal Patel
  • 27
  • 6
2
votes
1 answer

Replace URL with different string

I try to replace all my URL with another into my mariadb database (10.3.31) URL's Example…
Nux Mr
  • 21
  • 3
2
votes
1 answer

MySQL syntax confusion - Merging together simple data for a graceful single-row insertion

I am building a MySQL table to aggregate a set of particular information for a customer. Much of it I've assembled and filtered successfully with simple INNER JOIN commands on records with shared keys/columns, but the pivoting/transposing of the…
Big Owls
  • 37
  • 6
2
votes
1 answer

MariaDB: ALTER TABLE command works on one table, but not the other

I have two tables (Django Models) in a MariaDB database: coredb_vsatservicerate and coredb_simservicerate. MariaDB [servicedbtest]> SHOW CREATE TABLE…
SMoenig
  • 486
  • 3
  • 11
2
votes
1 answer

Regular expression replace in MariaDB

I am trying to match internal links in an SMF forum and convert the BBC tag from url to iurl so that a link like this: [url=https://www.translatum.gr/forum/index.php?topic=989144.0]κατ' ἐπιταγήν -> by way of command[/url] Will…
greektranslator
  • 499
  • 1
  • 6
  • 19
1
2 3
…
11 12