MySQL Table ‘/rdsdbdata/tmp/#sql13a_44eb_1’ is Full

Question & Answer
, ,
1

I am a Data Analyst, and I encountered an error while ingesting data from MySQL into AWS QuickSight. The ingestion fails with the following message:

  • Error Message: The table '/rdsdbdata/tmp/#sql13a_44eb_1' is full
  • Data Source: MySQL

I am using an RDS MySQL instance as my data source. A temporary workaround is restarting the instance, but I need a permanent fix. Please advise on the best way to resolve this issue permanently. Thank you.

2

Hello azzah,

I think the issue here is not with QuickSight rather RDS backend.

Do you use read replica for your RDS MySQL for quickSight or the RDS instance you are connecting is both for read/write ?
you may want to look into read replica option as well if its not the case at your end.

In addition, Please look into this post for TempTable Storage for RDS MySQL/Aurora

Hope this helps.

Cheers,
Deep

3

Hi @humairooh

This looks like a problem due to your temporary tablespace getting full. Your queries’ execution plan may be bad and it is taking too many resources to get the result or the data being pulled seems too big which exceeds the temp tablespace.

So you need to look at the query at the database level and fine tune to reduce the resources being used in the db

Regards,
Giri