Question
Answer
One possibility is to clear the temporary tables and try to re-run the sync. Alternatively, you may need to increase the allocated memory for Aurora. Upgrading the connector to the latest version may also resolve the issue. For improving performance in loading big tables in MySQL, create a separate thread specifically for that issue on the same channel.
Maykon Lopes
10/05/2022, 12:12 AMCaused by: java.lang.RuntimeException: java.sql.SQLException: The table '/rdsdbdata/tmp/#sql129d_35_1' is full
at io.airbyte.db.jdbc.StreamingJdbcDatabase.unsafeQuery(StreamingJdbcDatabase.java:79)
at io.airbyte.db.jdbc.JdbcDatabase.unsafeQuery(JdbcDatabase.java:195)
at io.airbyte.integrations.source.relationaldb.AbstractRelationalDbSource.lambda$queryTable$0(AbstractRelationalDbSource.java:61)
... 34 more
Caused by: java.sql.SQLException: The table '/rdsdbdata/tmp/#sql129d_35_1' is full
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
Saj Dider (Airbyte)
10/05/2022, 2:39 PMMaykon Lopes
10/19/2022, 5:57 PMSaj Dider (Airbyte)
10/19/2022, 7:17 PM