Mission: CLOUD CODER
Task: Create a data retrieval API service using Codeless
Hi - I needed to re-import the world-database (previous mission deleted cities data).
I tried both with and without checkbox to overwrite.
In both situations the data import failed with
ProxySQL Error: connection is locked to hostgroup 11 but trying to reach hostgroup 10
Full log sent to my email is:
1 17:55:23 IMPORT_DATA Importing Started.
2 17:55:23 IMPORT_DATA Preparing files to import
3 17:55:23 IMPORT_DATA Creating temporary tables
4 17:55:23 IMPORT_DATA Creating user's tables
5 17:55:23 IMPORT_DATA Preparing Country table: initializing columns.
6 17:55:23 IMPORT_DATA Import of tables failed: java.sql.SQLException: ProxySQL Error: connection is locked to hostgroup 11 but trying to reach hostgroup 10
7 17:55:23 IMPORT_DATA Importing failed. Exception:java.lang.RuntimeException: java.sql.SQLException: ProxySQL Error: connection is locked to hostgroup 11 but trying to reach hostgroup 10
8
9 com.backendless.services.persistence.schema.DatabaseOperation.handleDdlException(DatabaseOperation.java:199)
10 com.backendless.services.persistence.schema.DatabaseOperation.lambda$doExecute$2(DatabaseOperation.java:176)
11 com.backendless.datamodel.dao.JpaTransactionService.executeSync(JpaTransactionService.java:206)
12 com.backendless.datamodel.dao.JpaTransactionService.executeAppSync(JpaTransactionService.java:275)
13 com.backendless.datamodel.dao.JpaTransactionService.lambda$executeApp$1(JpaTransactionService.java:70)
14 java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
15 java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
16 java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
17 java.base/java.lang.Thread.run(Thread.java:834)
18 Caused by: java.sql.SQLException: ProxySQL Error: connection is locked to hostgroup 11 but trying to reach hostgroup 10
19
20 com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
21 com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
22 com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
23 com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
24 com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
25 org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
26 org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
27 org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)
28 org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)
29 org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)
30 org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:259)
31 org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:241)
32 org.hibernate.loader.entity.plan.LegacyBatchingEntityLoaderBuilder$LegacyBatchingEntityLoader.load(LegacyBatchingEntityLoaderBuilder.java:137)
33 org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4415)
34 org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4405)
35 org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:569)
36 org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:537)
37 org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208)
38 org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:332)
39 org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108)
40 org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74)
41 org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:113)
42 org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1184)
43 org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1173)
44 org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:194)
45 org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2784)
46 org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2765)
47 org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2721)
48 org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2765)
49 org.hibernate.internal.SessionImpl.find(SessionImpl.java:3320)
50 org.hibernate.internal.SessionImpl.find(SessionImpl.java:3282)
51 com.backendless.datamodel.dao.AbstractEntityManager.find(AbstractEntityManager.java:104)
52 com.backendless.datamodel.dao.AbstractEntityDAO.lambda$find$1(AbstractEntityDAO.java:40)
53 com.backendless.datamodel.dao.JpaContext.executeAppSync(JpaContext.java:125)
54 com.backendless.datamodel.dao.JpaContext.executeApp(JpaContext.java:159)
55 com.backendless.datamodel.dao.JpaContext.execute(JpaContext.java:51)
56 com.backendless.datamodel.dao.JpaContextService.execute(JpaContextService.java:16)
57 com.backendless.datamodel.dao.AbstractEntityDAO.find(AbstractEntityDAO.java:40)
58 com.backendless.datamodel.dao.AbstractEntityDAO.lambda$update$2(AbstractEntityDAO.java:47)
59 com.backendless.datamodel.dao.JpaTransactionService.executeSync(JpaTransactionService.java:206)
60 com.backendless.datamodel.dao.JpaTransactionService.executeAppSync(JpaTransactionService.java:275)
61 com.backendless.datamodel.dao.JpaTransactionService.executeApp(JpaTransactionService.java:80)
62 com.backendless.datamodel.dao.JpaTransactionService.execute(JpaTransactionService.java:32)
63 com.backendless.datamodel.dao.AbstractEntityDAO.update(AbstractEntityDAO.java:46)
64 com.backendless.services.persistence.schema.UpdateColumnOperation.executeOperation(UpdateColumnOperation.java:501)
65 com.backendless.services.persistence.schema.DatabaseOperation.lambda$doExecute$2(DatabaseOperation.java:168)
66 com.backendless.datamodel.dao.JpaTransactionService.executeSync(JpaTransactionService.java:206)
67 com.backendless.datamodel.dao.JpaTransactionService.executeAppSync(JpaTransactionService.java:275)
68 com.backendless.datamodel.dao.JpaTransactionService.lambda$executeApp$1(JpaTransactionService.java:70)
69 java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
70 java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
71 java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
72 java.base/java.lang.Thread.run(Thread.java:834)