Support Topics Documentation Slack YouTube Blog

Data import fails with ProxySQL hostgroup error

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)

Hi Spencer,

Could you please check if the problem still happens for you? I just tried importing data into my app and it went through just fine.

Regards,
Mark

It’s working now, thanks!