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_
This error is caused by either a mysql table limit within the configuration or the system is out of disk space.
Release : 10.3.x 10.4.x
Component : Spectrum Applications
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