[MDEV-27673] Warning after "select progress from information_schema.processlist" Created: 2022-01-28  Updated: 2023-09-27  Resolved: 2022-04-05

Status: Closed
Project: MariaDB Server
Component/s: Information Schema
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4

Type: Bug Priority: Critical
Reporter: Edward Stoever Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-24510 Assertion `tmp != ((long long) 0x8000... Closed
blocks MDEV-26507 Assertion `tmp != ((long long) 0x8000... Closed
Duplicate
is duplicated by MDEV-28131 Unexpected warning while selecting fr... Closed

 Description   

A warning is generated when querying progress from information_schema.processlist.

MariaDB [(none)]> select progress from information_schema.processlist;
+----------+
| progress |
+----------+
|        0 |
|        0 |
+----------+
2 rows in set, 2 warnings (0.001 sec)
 
MariaDB [(none)]> show warnings;
+---------+------+---------------------------------------------------------+
| Level   | Code | Message                                                 |
+---------+------+---------------------------------------------------------+
| Warning | 1918 | Encountered illegal value '' when converting to DECIMAL |
| Warning | 1918 | Encountered illegal value '' when converting to DECIMAL |
+---------+------+---------------------------------------------------------+
2 rows in set (0.000 sec)
 
MariaDB [(none)]>



 Comments   
Comment by Sergei Golubchik [ 2022-03-16 ]

Likely caused by https://github.com/MariaDB/server/commit/e64084d5a3a or a followup https://github.com/MariaDB/server/commit/4e503aec7fe

Comment by Sergei Golubchik [ 2022-03-23 ]

when fixed, need to remove the fix for MDEV-28131

Generated at Thu Feb 08 09:54:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.