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

GitHub | rayluch | 4 months ago
  1. 0

    Error with beef-strike and Armitage

    GitHub | 4 months ago | rayluch
    org.postgresql.util.PSQLException: ERROR: invalid input syntax for type inet: "null"
  2. 0

    Stop Hibernate from trying to re-create indexes on every startup

    Stack Overflow | 2 years ago | Evgeny Chesnokov
    org.postgresql.util.PSQLException: ERROR: relation "statusindex" already exists
  3. 0

    Syntax error while upgrading Liferay 6.0.5 to 6.1.0

    Stack Overflow | 2 years ago
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s" Position: 81
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I have an application that invokes Liquibase.update(Contexts contexts, Writer output). I want it to only show the changes and not risk making any changes, hence I set the connection to be read-only: {code} def liquibaseConnection = new JdbcConnection(connection) liquibaseConnection.setReadOnly(true) def liquibase = new Liquibase("my-changelog.xml", resourceAccessor, liquibaseConnection) def contexts = new Contexts() liquibase.update(contexts, getOutputWriter()) {code} However, even though if I instantiate Liquibase with a read-only connection, it still attempts to perform a database update to release the lock: {code} org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction 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 org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302) at liquibase.executor.jvm.JdbcExecutor$1UpdateStatementCallback.doInStatement(JdbcExecutor.java:231) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.update(JdbcExecutor.java:240) at liquibase.executor.jvm.JdbcExecutor.update(JdbcExecutor.java:214) at liquibase.lockservice.StandardLockService.releaseLock(StandardLockService.java:232) at liquibase.Liquibase.update(Liquibase.java:264) at liquibase.Liquibase.update(Liquibase.java:240) {code} Note that the error only occurs after the updateSQL operation was completed successfully. Even lock acquisition seems to work (probably by not touching the database). For some reason that is unclear to me, it seems that only the release part is failing to work properly with a read-only connection.

    JIRA | 2 years ago | Rafael Chaves
    org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction

  1. silex 2 times, last 3 weeks ago
  2. silex 18 times, last 6 months ago
20 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: invalid input syntax for type inet: "null"

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
    6 frames
  3. msf
    RpcQueue.run
    1. msf.DatabaseImpl.executeUpdate(DatabaseImpl.java:109)
    2. msf.DatabaseImpl.execute(DatabaseImpl.java:594)
    3. msf.RpcConnectionImpl.execute(RpcConnectionImpl.java:140)
    4. msf.RpcQueue.processRequest(RpcQueue.java:33)
    5. msf.RpcQueue.run(RpcQueue.java:83)
    5 frames
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame