ERROR 1114 (HY000): Spectrum mysql temp table is full

book

Article ID: 193228

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

When trying to run a query within a Spectrum mysql database, you may receive an error similar to the following:

ERROR 1114 (HY000): The table '/ca/spectrum/mysql/tmp/#sql_1b99_0' is full

Cause

This error is caused by either a mysql table limit within the configuration or the system is out of disk space.

Environment

Release : 10.3.x 10.4.x

Component : Spectrum Applications

Resolution

If you have verified the system is not out of disk space then adding the following parameters to the <SPECROOT>/mysql/my-spectrum.cnf file and then restarting mysql will resolve the issue.

innodb_temp_data_file_path = ibtmp1:12M:autoextend
innodb_data_file_path = ibdata1:10M:autoextend