Recommendation for table_definition_cache causes MariaDB to malfuntion

[gakowalski]

There is an unresolved bug in MariaDB regarding table_definition_cache: https://jira.mariadb.org/browse/MDEV-17124

It casues some web applications to throw error:

General error: 1615 Prepared statement needs to be re-prepared

This is z_aiops_mysql.cnf which made the bug appear in my environments:

[mysqld]
query_cache_type = 1 ### Previous value : OFF
query_cache_size = 128M ### Previous value : 0
query_cache_limit = 16M ### Previous value : 4194304
thread_cache_size = 256 ### Previous value : 256
key_buffer_size = 2147483648 ### Previous value : 2147483648
sort_buffer_size = 24M ### Previous value : 2097152
bulk_insert_buffer_size = 2M ### Previous value : 8388608
myisam_sort_buffer_size = 24M ### Previous value : 134216704
innodb_buffer_pool_instances = 1 ### Previous value : 3
innodb_buffer_pool_size = 2013265920 ### Previous value : 3221225472
max_heap_table_size = 256M ### Previous value : 268435456
tmp_table_size = 256M ### Previous value : 268435456
join_buffer_size = 8M ### Previous value : 25165824
max_connections = 256 ### Previous value : 256
interactive_timeout = 1200 ### Previous value : 12800
wait_timeout = 1200 ### Previous value : 12800
table_open_cache = 2048 ### Previous value : 2000
table_definition_cache = 1408 ### Previous value : 2048
innodb_flush_log_at_trx_commit = 2 ### Previous value : 1
innodb_log_file_size = 251658240 ### Previous value : 419430400
innodb_write_io_threads = 4 ### Previous value : 4
innodb_read_io_threads = 4 ### Previous value : 4
innodb_buffer_pool_chunk_size = 134217728 ### Previous value : 134217728`

Changing table_definition_cache to 2048 seems to fix the bug.

[gakowalski]

Forgot to write MariaDB version: 10.4.15

[drupaladmin]

It was fixed in MariaDB