[MDEV-22087] Increase buffer size for query in SHOW ENGINE INNODB STATUS output Created: 2020-03-31  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.31, 10.3.22, 10.4.12
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17237 thread IDs are printed in different f... Open
relates to MDEV-17238 Document special thread IDs used in S... Open
relates to MDEV-18391 Print ENGINE INNODB STATUS in machine... Open
relates to MDEV-18429 Consistent non-locking reads do not a... Closed
relates to MDEV-18572 Thread executing DROP TABLE listed tw... Open
relates to MDEV-18582 Port status variables related to SHOW... Closed
relates to MDEV-18698 Show InnoDB's internal background thr... Open
relates to MDEV-21330 Lock monitor doesn't print a semaphor... Closed
relates to MDEV-21390 lock_print_info_summary() should work... Closed
relates to MDEV-21566 Lock monitor doesn't print a name for... Closed

 Description   

In SHOW ENGINE INNODB STATUS output or in the output of the lock monitor, the query text and other basic information about the session seems to get copied to a buffer that is only 1024 bytes large. See here:

https://github.com/MariaDB/server/blob/mariadb-10.2.31/storage/innobase/handler/ha_innodb.cc#L2155

This means that even moderately long queries can be truncated.

Maybe we should increase the size of this buffer.
Generated at Thu Feb 08 09:12:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.