Good Day, I am receiving the below email when trying to import my data. I am not sure where the problem lies and was hoping you could assist. I see the import fails as the “Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535”, but none of my rows are so long.
===================================================================
Backendless finished import your data unsuccessfully for application: WorkshopPro.
The Import log located in File Service’s “import” directory.
See Import log bellow:
1 08:15:18 IMPORT_DATA Importing Started.
2 08:15:18 IMPORT_DATA Preparing files to import
3 08:15:18 IMPORT_DATA Creating temporary tables
4 08:15:18 IMPORT_DATA Creating user’s tables
5 08:15:18 IMPORT_DATA Checking for existing views with the same names as in imported tables
6 08:15:18 IMPORT_DATA Checking denied, duplicate and dataSize for columns.
7 08:15:18 IMPORT_DATA Preparing WorkshopPro table: create schema.
8 08:15:18 IMPORT_DATA Preparing WorkshopPro table: initializing columns.
9 08:15:25 IMPORT_DATA Import of tables failed: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
10 08:15:25 IMPORT_DATA Importing failed. Exception:java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
11
12 com.backendless.management.impex.manager.imports.data.CommonDatabaseUtils.alterColumnToTable(CommonDatabaseUtils.java:124)
13 com.backendless.management.impex.manager.imports.data.ImportDataManager.initNonRelationColumn(ImportDataManager.java:935)
14 com.backendless.management.impex.manager.imports.data.ImportDataManager.initColumns(ImportDataManager.java:847)
15 com.backendless.management.impex.manager.imports.data.ImportDataManager.initTables(ImportDataManager.java:789)
16 com.backendless.tasks.impex.ImportDataTask.doExecute(ImportDataTask.java:223)
17 com.backendless.tasks.impex.ImportDataTask.executeImpl(ImportDataTask.java:153)
18 com.backendless.tasks.impex.AbstractImportTask.execute(AbstractImportTask.java:71)
19 com.backendless.taskman.Task.run(Task.java:107)
20 com.backendless.taskman.TimeoutFixedThreadPoolExecutor.executeTaskWithTracker(TimeoutFixedThreadPoolExecutor.java:91)
21 com.backendless.taskman.TimeoutFixedThreadPoolExecutor.lambda$invoke$0(TimeoutFixedThreadPoolExecutor.java:39)
22 java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
23 java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
24 java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
25 java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
26 java.base/java.lang.Thread.run(Thread.java:829)
27 Caused by: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
28
29 com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
30 com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
31 com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
32 com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
33 com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
34 com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
35 com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)
36 jdk.internal.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
37 java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
38 java.base/java.lang.reflect.Method.invoke(Method.java:566)
39 com.mysql.cj.jdbc.ha.MultiHostConnectionProxy$JdbcInterfaceProxy.invoke(MultiHostConnectionProxy.java:107)
40 com.mysql.cj.jdbc.ha.FailoverConnectionProxy$FailoverJdbcInterfaceProxy.invoke(FailoverConnectionProxy.java:98)
41 com.sun.proxy.$Proxy275.executeUpdate(Unknown Source)
42 org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
43 com.backendless.management.impex.manager.imports.data.CommonDatabaseUtils.alterColumnToTable(CommonDatabaseUtils.java:118)
44 com.backendless.management.impex.manager.imports.data.ImportDataManager.initNonRelationColumn(ImportDataManager.java:935)
45 com.backendless.management.impex.manager.imports.data.ImportDataManager.initColumns(ImportDataManager.java:847)
46 com.backendless.management.impex.manager.imports.data.ImportDataManager.initTables(ImportDataManager.java:789)
47 com.backendless.tasks.impex.ImportDataTask.doExecute(ImportDataTask.java:223)
48 com.backendless.tasks.impex.ImportDataTask.executeImpl(ImportDataTask.java:153)
49 com.backendless.tasks.impex.AbstractImportTask.execute(AbstractImportTask.java:71)
50 com.backendless.taskman.Task.run(Task.java:107)
51 com.backendless.taskman.TimeoutFixedThreadPoolExecutor.executeTaskWithTracker(TimeoutFixedThreadPoolExecutor.java:91)
52 com.backendless.taskman.TimeoutFixedThreadPoolExecutor.lambda$invoke$0(TimeoutFixedThreadPoolExecutor.java:39)
53 java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
54 java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
55 java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
56 java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
57 java.base/java.lang.Thread.run(Thread.java:829)
