The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

[ERROR] mysqld: The table 'catalog_product_index_price_temp' is full

hey, I have a magento 2.3.1 store with 400k products and i am getting this message in mysql error log:

[ERROR] mysqld: The table 'catalog_product_index_price_temp' is full

catalog_product_index_price_temp is a virtual table ... i guess

some of my settings:

tmp-table-size = 1M max-heap-table-size = 32M

innodb_data_file_path = ibdata1:10M:autoextend tmp_table_size = 1M max_heap_table_size = 1M

can you help me with some ideeas to solve this?

thanks

Answer Answered by Daniel Black in this comment.

This looks like a frequently hit issue https://github.com/magento/magento2/issues/6415 . Be careful reading these comments to determine which are MariaDB and which are MYSQL as MySQL particularly 8 does temp tables things a bit differently.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.