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
Bug
Resolved
