Hi devs, we are evaluating wso2-EI 6.4 in pre-prod environment, running EI with analytics worker.
I followed the guide at https://docs.wso2.com/display/SP430/Configuring+Datasources to configure postgres datasources in deployment.yaml, for all dbs: METRICS_DB CARBON_DB PERMISSIONS_DB EI_ANALYTICS_DB Library is postgresql-42.2.2.jar The system works fine for some days but after a while the analytics worker stops responding. I need to manually kill the (worker) process because "carbon.sh stop" doesn't do the stuff, then restart the worker… that will be ok for 3 or 4 days. In comparison to datasources of wso2-EI in master-datasources.xml, db connector attributes are the same, except an extra one "testOnBorrow" set to true. Unfortunately this attribute is not allowed in deployment.yaml. Any help should be appreciate to get the system stable. [2019-01-24 01:48:52,291] INFO {org.wso2.carbon.databridge.core.DataBridge} - user admin connected [2019-01-24 01:48:52,291] INFO {org.wso2.carbon.databridge.core.DataBridge} - user admin connected [2019-01-24 01:48:52,289] WARN {org.apache.thrift.transport.TIOStreamTransport} - Error closing output stream. java.net.SocketException: Socket is closed at sun.security.ssl.SSLSocketImpl.checkEOF(SSLSocketImpl.java:1524) at sun.security.ssl.SSLSocketImpl.checkWrite(SSLSocketImpl.java:1545) at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:71) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) at java.io.FilterOutputStream.close(FilterOutputStream.java:158) at org.apache.thrift.transport.TIOStreamTransport.close(TIOStreamTransport.java:110) at org.apache.thrift.transport.TSocket.close(TSocket.java:196) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:304) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [2019-01-24 01:54:17,423] WARN {} - IOException occurred while connecting to pgsql.server.be:5440<http://pgsql.uclouvain.be:5440> java.io.EOFException at org.postgresql.core.PGStream.receiveChar(PGStream.java:295) at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:453) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) at org.postgresql.Driver.makeConnection(Driver.java:452) at org.postgresql.Driver.connect(Driver.java:254) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101) at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496) at com.zaxxer.hikari.pool.HikariPool.access$300(HikariPool.java:69) at com.zaxxer.hikari.pool.HikariPool$1.run(HikariPool.java:367) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [2019-01-24 01:54:22,204] ERROR {org.postgresql.Driver} - Connection error: org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) at org.postgresql.Driver.makeConnection(Driver.java:452) at org.postgresql.Driver.connect(Driver.java:254) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101) at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496) at com.zaxxer.hikari.pool.HikariPool.access$300(HikariPool.java:69) at com.zaxxer.hikari.pool.HikariPool$1.run(HikariPool.java:367) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.io.EOFException at org.postgresql.core.PGStream.receiveChar(PGStream.java:295) at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:453) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205) ... 14 more [2019-01-24 01:55:53,456] INFO {org.wso2.carbon.databridge.core.DataBridge} - user admin connected [2019-01-24 01:55:31,190] WARN {} - IOException occurred while connecting to pgsql.server.be<http://pgsql.uclouvain.be:5440>:5440<http://pgsql.uclouvain.be:5440> java.io.EOFException at org.postgresql.core.PGStream.receiveChar(PGStream.java:295) at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:453) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) at org.postgresql.Driver.makeConnection(Driver.java:452) at org.postgresql.Driver.connect(Driver.java:254) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101) at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496) at com.zaxxer.hikari.pool.HikariPool.access$300(HikariPool.java:69) at com.zaxxer.hikari.pool.HikariPool$1.run(HikariPool.java:367) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [2019-01-24 01:56:09,847] INFO {org.wso2.carbon.databridge.core.DataBridge} - user admin connected [2019-01-24 01:55:58,072] WARN {} - IOException occurred while connecting to pgsql.server.be<http://pgsql.uclouvain.be:5440>:5440<http://pgsql.uclouvain.be:5440> java.io.EOFException at org.postgresql.core.PGStream.receiveChar(PGStream.java:295) at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:453) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) at org.postgresql.Driver.makeConnection(Driver.java:452) at org.postgresql.Driver.connect(Driver.java:254) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101) at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:496) at com.zaxxer.hikari.pool.HikariPool.access$300(HikariPool.java:69) at com.zaxxer.hikari.pool.HikariPool$1.run(HikariPool.java:367) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
