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
  • Component/s: Installation/Deployment
  • 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

Ascending order - Click to sort in descending order
Hide
Permalink
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
Victor NOËL made changes - Mon, 29 Feb 2016 - 10:59:52 +0100
Field Original Value New Value
Resolution Won't Fix [ 2 ]
Status New [ 10000 ] Resolved [ 10004 ]
Assignee Christophe DENEUX [ cdeneux ] Victor NOËL [ vnoel ]
Transition Status Change Time Execution Times Last Executer Last Execution Date
New New Resolved Resolved
1587d 21h 15m
1
Victor NOËL
Mon, 29 Feb 2016 - 10:59:52 +0100



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
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Petals ESB. Try JIRA - bug tracking software for your team.