Petals ESB Container

Database is not created correctly when configuring the registry with Postgre

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Resolution: Won't Fix
  • Affects Version/s: 3.1.3
  • Fix Version/s: None
  • Security Level: Public
  • Description:
    Hide

    Seen on the forum.

    • Configure a Petals node to store service information in a Postgre database.
    • Start the node.
    • An exception appears in the console.

    petals@localhost:/> [Petals.System.PersistenceServiceImpl]-WARNING 2011-10-10 16:25:23,744 Failed to delete old exchange data
    org.postgresql.util.PSQLException: ERREUR: la relation « message_exchange » n'existe pas
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    at org.ow2.petals.system.persistence.PersistenceServiceImpl$PersistenceCleaner.run(PersistenceServiceImpl.java:85)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)

    It seems the following tables are not created correctly:
    EXCHANGE_TIMESTAMP
    MESSAGE_EXCHANGE
    MESSAGE_EXCHANGE_PROPERTY
    NORMALIZED_MESSAGE

    Show
    Seen on the forum.
    • Configure a Petals node to store service information in a Postgre database.
    • Start the node.
    • An exception appears in the console.
    petals@localhost:/> [Petals.System.PersistenceServiceImpl]-WARNING 2011-10-10 16:25:23,744 Failed to delete old exchange data org.postgresql.util.PSQLException: ERREUR: la relation « message_exchange » n'existe pas at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.ow2.petals.system.persistence.PersistenceServiceImpl$PersistenceCleaner.run(PersistenceServiceImpl.java:85) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462)
    It seems the following tables are not created correctly: EXCHANGE_TIMESTAMP MESSAGE_EXCHANGE MESSAGE_EXCHANGE_PROPERTY NORMALIZED_MESSAGE
  • Environment:
    Unknown

Activity

Hide
Victor NOËL added a comment - Mon, 29 Feb 2016 - 10:59:52 +0100

Persistence service is being removed: PETALSESBCONT-402

Show
Victor NOËL added a comment - Mon, 29 Feb 2016 - 10:59:52 +0100 Persistence service is being removed: PETALSESBCONT-402

People

Dates

  • Created:
    Tue, 25 Oct 2011 - 14:44:46 +0200
    Updated:
    Mon, 29 Feb 2016 - 10:59:52 +0100
    Resolved:
    Mon, 29 Feb 2016 - 10:59:52 +0100