org.postgresql.util.PSQLException: ERROR: invalid input syntax for type inet: "null"

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via GitHub by rayluch
, 1 year ago
ERROR: invalid input syntax for type inet: "null"
via Google Groups by Michael Paesold, 3 months ago
ERROR: syntax error at or near "$2"
via Stack Overflow by Zsolt J&#225;nos
, 2 months ago
ERROR: syntax error at or near "$2" Position: 177
via stackexchange.com by Unknown author, 1 year ago
via adempiere by vpj-cd
, 1 year ago
ERROR: column "entitytype" cannot be cast to type "pg\_catalog.numeric"; State=42804; ErrorCode=0
via GitHub by jayp
, 2 years ago
ERROR: column "data" is of type json but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 51
org.postgresql.util.PSQLException: ERROR: invalid input syntax for type inet: "null"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at msf.DatabaseImpl.executeUpdate(DatabaseImpl.java:109)
at msf.DatabaseImpl.execute(DatabaseImpl.java:594)
at msf.RpcConnectionImpl.execute(RpcConnectionImpl.java:140)
at msf.RpcQueue.processRequest(RpcQueue.java:33)
at msf.RpcQueue.run(RpcQueue.java:83)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 3 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
18 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
103 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.