Main lobby for Eclipse Kapua | Kapua 1.4.3 now available! https://github.com/eclipse/kapua/releases/tag/1.4.3
Internal Exception: java.sql.SQLNonTransientConnectionException: (conn=445269) (conn=445269) Connection is closed
Error Code: 1220
Call: SELECT DISTINCT attributes, created_on, description, expiration_date, modified_on, name, optlock, parent_account_path, properties, created_by, id, modified_by, org_address_line_1, org_address_line_2, org_address_line_3, org_city, org_country, org_email, org_name, org_person_name, org_phone_number, org_state_province_county, org_zip_postcode, scope_id FROM act_account ORDER BY name ASC
Query: ReadAllQuery(referenceClass=AccountImpl sql="SELECT DISTINCT attributes, created_on, description, expiration_date, modified_on, name, optlock, parent_account_path, properties, created_by, id, modified_by, org_address_line_1, org_address_line_2, org_address_line_3, org_city, org_country, org_email, org_name, org_person_name, org_phone_number, org_state_province_county, org_zip_postcode, scope_id FROM act_account ORDER BY name ASC")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:691)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2099)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:265)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:277)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:263)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:334)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:746)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2759)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2712)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:584)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1232)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1191)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:485)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1279)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2983)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
... 18 common frames omitted
Caused by: java.sql.SQLNonTransientConnectionException: (conn=445269) (conn=445269) Connection is closed
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
...
Hi @Coduz, I'm trying to schedule a Batch Job in Kapua (v1.5.2). It's setup as follows:
An error occurred when sending the message: org.eclipse.kapua.service.device.management.configuration.message.internal.ConfigurationRequestMessage@641d8ee9
I've looking issues into github and seems exactly the same as eclipse/kapua#3481 reported by @pintify
Can someone kindly look at it and help us sort it out? Many thanks in advance
The image for the service you're trying to recreate has been removed. If you continue, volume data could be lost. Consider backing up your data before continuing.
Continue with the new image? [yN]y
Pulling consumer-telemetry (kapua/kapua-consumer-telemetry:latest)...
ERROR: pull access denied for kapua/kapua-consumer-telemetry, repository does not exist or may require 'docker login': denied: requested access to the resource is denied
Deploying Eclipse Kapua... ERROR!
I am trying to setup sensors-raspberry pi-mosquito-kura -kapua-grafana to collect and visualize agriculture related data ,however i am unable to connect kura to kapua ,i have followed all th steps mentioned here - https://github.com/eclipse/kapua/pull/780/files but the error im getting is "connection failed.unable to connect.please check your configuration and try again"
Warning
Failed to connect! Please review your configuration and try again later.
Show Stack Trace
Unknown.lh(denali-0.js)
Unknown.new Huc(denali-0.js)
Unknown.Muc(denali-0.js)
Unknown.Qeb(denali-0.js)
Unknown.Meb(denali-0.js)
Unknown.jdb(denali-0.js)
Unknown.Sdb(denali-0.js)
Unknown.es(denali-0.js)
Unknown.rs(denali-0.js)
Unknown.eval(denali-0.js)
Unknown.Wh(denali-0.js)
Unknown.Zh(denali-0.js)
Unknown.eval(denali-0.js)
I have check my logs on kura, heres what it says:
2022-03-22T09:44:49,575 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.DataServiceImpl - Connecting...
2022-03-22T09:44:49,575 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - Creating a new client instance
2022-03-22T09:44:49,575 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - Using memory persistence for in-flight messages
2022-03-22T09:44:49,577 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # ------------------------------------------------------------
2022-03-22T09:44:49,577 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # Connection Properties
2022-03-22T09:44:49,577 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # broker = tcp://192.168.1.192:1883
2022-03-22T09:44:49,578 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # clientId = zepto
2022-03-22T09:44:49,578 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # username = User123
2022-03-22T09:44:49,578 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # password = XXXXXXXXXXXXXX
2022-03-22T09:44:49,578 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # keepAlive = 30
2022-03-22T09:44:49,579 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # timeout = 10
2022-03-22T09:44:49,579 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # cleanSession = true
2022-03-22T09:44:49,579 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # MQTT version = 3.1.1
2022-03-22T09:44:49,579 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # willDestination = $EDC/Account123/zepto/MQTT/LWT
2022-03-22T09:44:49,580 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # willMessage =
2022-03-22T09:44:49,580 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - #
2022-03-22T09:44:49,580 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - # Connecting...
2022-03-22T09:44:49,581 [pool-15-thread-1] INFO o.e.k.c.s.r.LogStatusRunnable - Notification LED fast blinking
2022-03-22T09:44:50,665 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] WARN o.e.k.c.d.t.m.MqttDataTransport - xxxxx Connect failed. Forcing disconnect. xxxxx
2022-03-22T09:44:50,666 [DataServiceImpl:ReconnectTask:org.eclipse.kura.data.DataService-Kapua] INFO o.e.k.c.d.t.m.MqttDataTransport - Forcing client disconnect...
I am trying to update kura configuration from Kapua Swagger UI. It's showing configuration updated but it's not updated at all. If I try to update it from Kapua Console UI Configuration, it's reflecting the changes.
Here is the console log of Kura:
2022-05-25T21:40:00,042 [MQTT Call: Rasp-Ak] INFO o.e.k.c.c.CloudServiceImpl - Message arrived on topic: $EDC/lenovo1/Rasp-Ak/CONF-V1/PUT/configurations/Sensor
2022-05-25T21:40:00,044 [pool-27-thread-2] INFO o.e.k.c.c.CloudConfigurationHandler - Received new Configuration
2022-05-25T21:40:00,052 [pool-27-thread-2] INFO o.e.k.c.d.DataServiceImpl - Storing message on topic: $EDC/#account-name/KapuaPool-1653494866134-5279237929442601368/CONF-V1/REPLY/-27135401838548913, priority: 1
2022-05-25T21:40:00,063 [pool-27-thread-2] INFO o.e.k.c.d.DataServiceImpl - Stored message on topic: $EDC/#account-name/KapuaPool-1653494866134-5279237929442601368/CONF-V1/REPLY/-27135401838548913, priority: 1
2022-05-25T21:40:00,075 [DataServiceImpl:Submit] INFO o.e.k.c.d.t.m.MqttDataTransport - Publishing message on topic: $EDC/lenovo1/KapuaPool-1653494866134-5279237929442601368/CONF-V1/REPLY/-27135401838548913 with QoS: 0
2022-05-25T21:40:01,052 [UpdateConfigurationsCallable] INFO o.e.k.c.c.UpdateConfigurationsCallable - Updating configurations
2022-05-25T21:40:01,277 [UpdateConfigurationsCallable] INFO o.e.k.c.c.ConfigurationServiceImpl - Loading init configurations from: 1653494938154...
2022-05-25T21:40:01,476 [UpdateConfigurationsCallable] INFO o.e.k.c.c.ConfigurationServiceImpl - Merging configuration for pid: org.eclipse.kura.cloud.publisher.CloudPublisher
2022-05-25T21:40:01,491 [UpdateConfigurationsCallable] INFO o.e.k.c.c.ConfigurationServiceImpl - Updating Configuration of ConfigurableComponent Sensor ... Done.
2022-05-25T21:40:01,542 [UpdateConfigurationsCallable] INFO o.e.k.c.c.ConfigurationServiceImpl - Writing snapshot - Saving /opt/eclipse/kura/user/snapshots/snapshot_1653495001491.xml...
2022-05-25T21:40:01,629 [UpdateConfigurationsCallable] INFO o.e.k.c.c.ConfigurationServiceImpl - Writing snapshot - Saving /opt/eclipse/kura/user/snapshots/snapshot_1653495001491.xml... Done.
2022-05-25T21:40:01,631 [UpdateConfigurationsCallable] INFO o.e.k.c.c.ConfigurationServiceImpl - Snapshots Garbage Collector. Deleted /opt/eclipse/kura/user/snapshots/snapshot_1653493459319.xml