I am getting Db connectivity issue, Hikari pool error
ERROR 1 --- [ XNIO-1 task-2] .s.e.v.h.e.SyndesisServerExceptionMapper : Internal Server Exception. java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
at org.skife.jdbi.v2.DBI.open(DBI.java:229) ~[jdbi-2.78.jar!/:2.78]
at io.syndesis.server.jsondb.impl.SqlJsonDB.getAsStreamingOutput(SqlJsonDB.java:184) ~[server-jsondb-1.12.0.jar!/:1.12.0]
at io.syndesis.server.jsondb.JsonDB.getAsStream(JsonDB.java:161) ~[server-jsondb-1.12.0.jar!/:1.12.0]
at io.syndesis.server.jsondb.JsonDB.getAsByteArray(JsonDB.java:131) ~[server-jsondb-1.12.0.jar!/:1.12.0]
at io.syndesis.server.jsondb.dao.JsonDbDao.fetchAll(JsonDbDao.java:105) ~[server-jsondb-1.12.0.jar!/:1.12.0]
at io.syndesis.server.jsondb.dao.JsonDbDaoFastClassBySpringCGLIBa1de3bc1.invoke(<generated>) ~[server-jsondb-1.12.0.jar!/:1.12.0]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) ~[spring-aop-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.13.RELEASE.jar!/:5.2.13.RELEASE]
at io.syndesis.server.jsondb.dao.ConnectionJsonDbDaoEnhancerBySpringCGLIBc2d2f8eb.fetchAll(<generated>) ~[server-jsondb-1.12.0.jar!/:1.12.0]
at io.syndesis.server.dao.manager.DataManager.lambda$fetchAll$0(DataManager.java:242) ~[server-dao-1.12.0.jar!/:1.12.0]
at io.syndesis.server.dao.manager.DataManager.doWithDataAccessObject(DataManager.java:467) ~[server-dao-1.12.0.jar!/:1.12.0]
at io.syndesis.server.dao.manager.DataManager.fetchAll(DataManager.java:242) ~[server-dao-1.12.0.jar!/:1.12.0]
at io.syndesis.server.endpoint.v1.handler.BaseHandler.fetchAll(BaseHandler.java:46) ~[server-endpoint-1.12.0.jar!/:1.12.0]
at io.syndesis.server.endpoint.v1.handler.connection.ConnectionHandler.list(ConnectionHandler.java:103) ~[server-endpoint-1.12.0.jar!/:1.12.0]
at sun.reflect.GeneratedMethodAccessor913.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_201]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201]
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:170) ~[resteasy-core-4.6.0.Final.jar!/:4.6.0.Final]
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:130) ~[resteasy-core-4.6.0.Final.jar!/:4.6.0.Final]
at org.jboss.resteasy.core.ResourceMethodInvoker.internalInvokeOnTarget(ResourceMethodInvoker.java:646) ~[resteasy-core-4.6.0.Final.jar!/:4.6.0.Final]
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTargetAfterFilter(ResourceMethodInvoker.java:510) ~[resteasy-core-4.6.0.Final.jar!/:4.6.0.Final]
at org.jboss.resteasy.core.ResourceMethodInvoker.lambda$invokeOnTarget$2(ResourceMethodInvoker.java:460) ~[resteasy-core-4.6.0.Final.jar!/:4.6.0.Final]
at org.jboss.resteasy.core.in
Hello all,
Quick question: After installing Syndesis through the operator on my private OKD cluster i keep getting instability issues.
OKD runs on Azure on D-type machines.
The moment syndesis is deinstalled the issues with degrading operators / performance are gone.
Problem appears to start after starting the first build of an integration.
Anyone has seen similar issues and/or can point me in the right direction?
Thanks for the prompt reply @zregvart. Where/How can i send you an example, including screens etc.
2 other issues arose yesterday:
1: When there is an issue building an integration in some cases it happens that the build restarts 2 times and 1 is continuously failing in the background trying to rebuild over and over. Is this a known issue?
2: Issues related to the heapsize of the syndesis server. Since last week 5 people are building integrations for new platforms and first we noticed a slowdown, later resulting in memory heap issues in the syndesis-server. The problems appeared to have been resolved after adding more memory to it, yet slow down did not completely disappear. Is this also a known issue?
What information can i supply you with apart from the integrations? Any particular logdumps i can make which would make it easier to see how/what is going on.
Again, thanks in advance.
Hello! Has anyone has this issue? bash install_ocp.sh --setup keep failing to install Fuse Online / Syndesis on CRC / OCP on RHEL 8 Workstation
Ive installed CRC and OCP successfully, I believe
I then login with, oc login -u kubeadmin -p * https://api.crc.testing:6443
I then run the following script:
bash install_ocp.sh --setup
I then get the following error:
User kubeadmin is a cluster-admin
Installing Syndesis CRD
error: Object:
apiVersion: apiextensions.k8s.io/v1beta1
kind: CustomResourceDefinition
metadata:
labels:
app: camel-k
name: integrationplatforms.camel.apache.org
spec:
additionalPrinterColumns:
- JSONPath: .status.phase
description: The IntegrationPlatform phase
name: Phase
type: string
group: camel.apache.org
names:
kind: IntegrationPlatform
listKind: IntegrationPlatformList
plural: integrationplatforms
shortNames:
- ip
singular: integrationplatform
scope: Namespaced
subresources:
status: {}
version: v1alpha1
: no matches for kind "CustomResourceDefinition" in version "apiextensions.k8s.io/v1beta1"
Has anyone come across this issue previously? How did you resolve it?. Thanks in advance for your help
Hello Team,
I am unable to set output data type for S3Object from integration start. I have a Get File operation from source S3 as the first step of integration. Data type selection screen is missing after entering file name.
Any suggestions on what could be wrong and how to choose source data type for use in mapping step.
Hi,
Does any one know what could cause NullPointerException: stepsDone value
My Integration: