[Solved] Local server 0.23.2 and postgresql error at start

Solved
1

Hi all.
Today I update fron 0.23.1 to 0.23.2 server. When I start it I see a new next error message than in
0.23.1 version no. And the server work worst. The devices disconnect frequently.
Is there something I’m missing?
Regards,
Jaume Nogués
rPrim Tech School

    2017 1:45:15 PM org.postgresql.Driver connect
SEVERE: Connection error:
org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
        at org.postgresql.Driver.makeConnection(Driver.java:431)
        at org.postgresql.Driver.connect(Driver.java:247)
        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.PoolBase.newConnection(PoolBase.java:356)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
        at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
        at cc.blynk.server.db.DBManager.<init>(DBManager.java:78)
        at cc.blynk.server.db.DBManager.<init>(DBManager.java:51)
        at cc.blynk.server.Holder.<init>(Holder.java:113)
        at cc.blynk.server.launcher.ServerLauncher.start(ServerLauncher.java:71)
        at cc.blynk.server.launcher.ServerLauncher.main(ServerLauncher.java:65)
Caused by: java.net.ConnectException: S’ha refusat la connexió
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at org.postgresql.core.PGStream.<init>(PGStream.java:62)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
        ... 17 more
2

Do you use DB on your local server? Where do you see this error? It is not related to “device offline”.

3

My server is a raspberry pi. I don’t use DB. The devices are online but suddenly the connections is lost. The connections is recovery but seconds or minutes later disconnect another time. With 0.23.1 server the system work rock solid!

4

Latest server hasn’t any changes regarding active connections handling. Most probably issue in your code.

Regarding exception - in what log do you see it? If in postgres.log that is fine and you may ignore it.

5

Thanks Dimitry.

Jaume

6

I also had this issue when upgrading from 0.23.1. It looks like it was enabling raw data storage (I think that’s what it’s called). Either you can disable it or just install PostgresSQL, I did the latter and it’s working perfectly now.

7

Hi ThatGuy, I have in my server.properties this:

#enable raw data storage to DB
enable.raw.db.data.store=false

Is enough? or I must do something more?

regards

8

same error for me on windows 10 64bit… local server

Mar 25, 2017 6:01:56 PM org.postgresql.Driver connect
SEVERE: Connection error:
org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
        at org.postgresql.Driver.makeConnection(Driver.java:431)
        at org.postgresql.Driver.connect(Driver.java:247)
        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.PoolBase.newConnection(PoolBase.java:356)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
        at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
        at cc.blynk.server.db.DBManager.<init>(DBManager.java:78)
        at cc.blynk.server.db.DBManager.<init>(DBManager.java:51)
        at cc.blynk.server.Holder.<init>(Holder.java:113)
        at cc.blynk.server.launcher.ServerLauncher.start(ServerLauncher.java:71)
        at cc.blynk.server.launcher.ServerLauncher.main(ServerLauncher.java:65)
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
        at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
        at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at org.postgresql.core.PGStream.<init>(PGStream.java:62)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
        ... 17 more


Blynk Server 0.23.2 successfully started.
All server output is stored in folder 'C:\My_Server\.\logs' file.

DB not in use

#enable raw data storage to DB
enable.raw.db.data.store=false

postgres.log

2017-03-25 18:01:55.083 - DB url : jdbc:postgresql://localhost:5432/blynk?tcpKeepAlive=true&socketTimeout=150
2017-03-25 18:01:55.083 - DB user : test
2017-03-25 18:01:55.085 - Connecting to DB...
2017-03-25 18:01:57.347 - Not able connect to DB. Skipping. Reason : Failed to initialize pool: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
9

Please use latest server version. This issue is fixed there.

10

@Dmitriy

Blynk Server 0.23.3 successfully started.

work fine.

11

Server 0.23.3 works fine !!!
Good job!