Chris Geer created RAVE-617:
-------------------------------
Summary: Rave fails with duplicate row in Page error
Key: RAVE-617
URL: https://issues.apache.org/jira/browse/RAVE-617
Project: Rave
Issue Type: Bug
Components: rave-portal
Affects Versions: 0.12
Reporter: Chris Geer
Priority: Blocker
The latest changes have a problem in the initial_data.sql script somewhere
which causes rave not to start.
INFO] [talledLocalContainer] 56170 ravePersistenceUnit TRACE [http-8080-2]
openjpa.jdbc.SQL - <t 1259760240, conn 1363565030> [0 ms] spent
[INFO] [talledLocalContainer] 56170 ravePersistenceUnit TRACE [http-8080-2]
openjpa.jdbc.SQL - <t 1259760240, conn 1363565030> executing prepstmnt
1535109899 INSERT INTO page_user (entity_id, editor, page_status,
render_sequence, page_id, user_id) VALUES (?, ?, ?, ?, ?, ?) [params=?, ?, ?,
?, ?, ?]
[INFO] [talledLocalContainer] 56170 ravePersistenceUnit TRACE [http-8080-2]
openjpa.jdbc.SQL - <t 1259760240, conn 1363565030> [0 ms] spent
[WARNING] [talledLocalContainer] May 10, 2012 10:11:56 AM
org.apache.catalina.core.StandardWrapperValve invoke
[WARNING] [talledLocalContainer] SEVERE: Servlet.service() for servlet
dispatcher threw exception
[WARNING] [talledLocalContainer] org.h2.jdbc.JdbcSQLException: Unique index or
primary key violation: "U_PAGE_OWNER_ID_INDEX_2 ON PUBLIC.PAGE(OWNER_ID, NAME,
PAGE_TYPE)"; SQL statement:
[WARNING] [talledLocalContainer] INSERT INTO page (entity_id, name, page_type,
owner_id, page_layout_id, parent_page_id) VALUES (?, ?, ?, ?, ?, ?) [23505-154]
[WARNING] [talledLocalContainer] at
org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
[WARNING] [talledLocalContainer] at
org.h2.message.DbException.get(DbException.java:167)
[WARNING] [talledLocalContainer] at
org.h2.message.DbException.get(DbException.java:144)
[WARNING] [talledLocalContainer] at
org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:80)
[WARNING] [talledLocalContainer] at
org.h2.index.PageBtree.find(PageBtree.java:121)
[WARNING] [talledLocalContainer] at
org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:146)
[WARNING] [talledLocalContainer] at
org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:100)
[WARNING] [talledLocalContainer] at
org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:93)
[WARNING] [talledLocalContainer] at
org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:84)
[WARNING] [talledLocalContainer] at
org.h2.table.RegularTable.addRow(RegularTable.java:127)
[WARNING] [talledLocalContainer] at
org.h2.command.dml.Insert.insertRows(Insert.java:126)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
