[
https://issues.apache.org/jira/browse/WOOKIE-168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12966058#action_12966058
]
Paul Sharples commented on WOOKIE-168:
--------------------------------------
Still problems to do with deleting widgets & instances...
To reproduce...
(1) Start wookie in standalone mode
(2) Go to http://localhost:8080/wookie
(3) Go to the gallery page and click on the API test widget to instantiate it
(4) Login to the admin section of wookie
(5) Using the 'delete widget' section of the wookie admin, try to remove the
widget
I get the following stacktrace...
[java] FailedObject:
org.apache.wookie.beans.jpa.impl.WidgetInstanceImpl-719
[java] <openjpa-2.0.0-r422266:935683 fatal general error>
org.apache.openjpa.persistence.PersistenceException: The transaction has been
rolled back. See the nested exceptions for details on the errors that occurred.
[java] FailedObject:
org.apache.wookie.beans.jpa.impl.WidgetInstanceImpl-719
[java] at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2302)
[java] at
org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2139)
[java] at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2037)
[java] at
org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1808)
[java] at
org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:971)
[java] at
org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:851)
[java] at
org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:792)
[java] at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
[java] at
org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:288)
[java] at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
[java] at
org.apache.wookie.beans.jpa.JPAPersistenceManager.findParticipants(JPAPersistenceManager.java:690)
[java] at
org.apache.wookie.helpers.WidgetFactory.destroy(WidgetFactory.java:261)
[java] at
org.apache.wookie.helpers.WidgetFactory.destroy(WidgetFactory.java:230)
[java] at
org.apache.wookie.WidgetAdminServlet.removeWidget(WidgetAdminServlet.java:378)
[java] at
org.apache.wookie.WidgetAdminServlet.doGet(WidgetAdminServlet.java:202)
[java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
[java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
[java] at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
[java] at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1098)
[java] at
org.apache.wookie.server.CharSetFilter.doFilter(CharSetFilter.java:34)
[java] at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1089)
[java] at
org.apache.wookie.server.MainFilter.doFilter(MainFilter.java:63)
[java] at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1089)
[java] at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:365)
[java] at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
[java] at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
[java] at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
[java] at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
[java] at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
[java] at org.mortbay.jetty.Server.handle(Server.java:285)
[java] at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502)
[java] at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:821)
[java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
[java] at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208)
[java] at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
[java] at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:226)
[java] at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
[java] Caused by: <openjpa-2.0.0-r422266:935683 fatal general error>
org.apache.openjpa.persistence.PersistenceException: DELETE on table
'WIDGETINSTANCE' caused a violation of foreign key constraint 'FKPREFERENCE1'
for key (719). The statement has been rolled back. {prepstmnt 24631307 DELETE
FROM JAVA.WidgetInstance WHERE ID = ? AND JPA_VERSION = ? [params=(int) 719,
(int) 1]} [code=20000, state=23503]
[java] FailedObject:
org.apache.wookie.beans.jpa.impl.WidgetInstanceImpl-719
[java] at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4821)
[java] at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4787)
[java] at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
[java] at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
[java] at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143)
[java] at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
[java] at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
[java] at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
[java] at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:357)
[java] at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:349)
[java] at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:111)
[java] at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
[java] at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
[java] at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
[java] at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:751)
[java] at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
[java] at
org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:540)
[java] at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
[java] ... 36 more
> Cannot remove widget from wookie after it has become an instance.
> -----------------------------------------------------------------
>
> Key: WOOKIE-168
> URL: https://issues.apache.org/jira/browse/WOOKIE-168
> Project: Wookie
> Issue Type: Bug
> Components: Server
> Affects Versions: 0.9.0
> Environment: Win Vista (all browsers)
> Reporter: Paul Sharples
> Priority: Critical
> Fix For: 0.9.0
>
>
> This problem occurs when you import a widget into wookie and you also
> instantiate it - For example choosing it from the gallery. If you then try to
> remove it from wookie, a stacktrace appears in the log.
> To reproduce...
> (1) Start wookie in standalone mode
> (2) Go to http://localhost:8080/wookie
> (3) Drag 'n drop a .wgt package into the hot deploy folder of wookie
> (4) Login to the admin section of wookie & verifiy that it is installed
> correctly.
> (5) Using the 'delete widget' section of the wookie admin, remove the widget
> (this should work okay)
> (6) Repeat steps 3 & 4. only
> (7) Go to the gallery page and click on the newly imported widget, so that it
> becomes an instance.
> (8) Return to the admin section of wookie & try to delete the widget (step 5)
> The second time an error occurs with the following stacktrace...
> [java] 14:45:41,320 ERROR log:? - /wookie/admin/WidgetAdminServlet
> [java] java.lang.RuntimeException: Persistence commit exception caught
> for transaction: org.apache.wookie.beans.util.PersistenceCommitException:
> Transaction commit exception: <openjpa-2.0.0-r422266:935683 fatal store
> error> org.apache.openjpa.persistence.RollbackException: The transaction has
> been rolled back. See the nested exceptions for details on the errors that
> occurred.
> [java] FailedObject: org.apache.wookie.beans.jpa.impl.WidgetImpl-22
> [java] at
> org.apache.wookie.server.MainFilter.doFilter(MainFilter.java:80)
> [java] at
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1089)
> [java] at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:365)
> [java] at
> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
> [java] at
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
> [java] at
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
> [java] at
> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
> [java] at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
> [java] at org.mortbay.jetty.Server.handle(Server.java:285)
> [java] at
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502)
> [java] at
> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:821)
> [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
> [java] at
> org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208)
> [java] at
> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
> [java] at
> org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:226)
> [java] at
> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
> [java] Caused by:
> org.apache.wookie.beans.util.PersistenceCommitException: Transaction commit
> exception: <openjpa-2.0.0-r422266:935683 fatal store error>
> org.apache.openjpa.persistence.RollbackException: The transaction has been
> rolled back. See the nested exceptions for details on the errors that
> occurred.
> [java] FailedObject: org.apache.wookie.beans.jpa.impl.WidgetImpl-22
> [java] at
> org.apache.wookie.beans.jpa.JPAPersistenceManager.commit(JPAPersistenceManager.java:370)
> [java] at
> org.apache.wookie.server.MainFilter.doFilter(MainFilter.java:64)
> [java] ... 15 more
> [java] Caused by: <openjpa-2.0.0-r422266:935683 fatal store error>
> org.apache.openjpa.persistence.RollbackException: The transaction has been
> rolled back. See the nested exceptions for details on the errors that
> occurred.
> [java] FailedObject: org.apache.wookie.beans.jpa.impl.WidgetImpl-22
> [java] at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:583)
> [java] at
> org.apache.wookie.beans.jpa.JPAPersistenceManager.commit(JPAPersistenceManager.java:366)
> [java] ... 16 more
> [java] Caused by: <openjpa-2.0.0-r422266:935683 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: The transaction has been
> rolled back. See the nested exceptions for details on the errors that
> occurred.
> [java] FailedObject: org.apache.wookie.beans.jpa.impl.WidgetImpl-22
> [java] at
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2302)
> [java] at
> org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2139)
> [java] at
> org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2037)
> [java] at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1955)
> [java] at
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> [java] at
> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1479)
> [java] at
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925)
> [java] at
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:559)
> [java] ... 17 more
> [java] Caused by: <openjpa-2.0.0-r422266:935683 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: DELETE on table 'WIDGET'
> caused a violation of foreign key constraint 'FKPARTICIPANT1' for key (22).
> The statement has been rolled back. {prepstmnt 32437201 DELETE FROM
> JAVA.WIDGET WHERE ID = ? AND JPA_VERSION = ? [params=(int) 22, (int) 1]}
> [code=20000, state=23503]
> [java] FailedObject: org.apache.wookie.beans.jpa.impl.WidgetImpl-22
> [java] at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4821)
> [java] at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4787)
> [java] at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> [java] at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
> [java] at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143)
> [java] at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
> [java] at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
> [java] at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
> [java] at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:357)
> [java] at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:349)
> [java] at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:111)
> [java] at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> [java] at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
> [java] at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
> [java] at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:751)
> [java] at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> [java] at
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:540)
> [java] at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> [java] ... 24 more
> [java] Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
> DELETE on table 'WIDGET' caused a violation of foreign key constraint
> 'FKPARTICIPANT1' for key (22). The statement has been rolled back.
> {prepstmnt 32437201 DELETE FROM JAVA.WIDGET WHERE ID = ? AND JPA_VERSION = ?
> [params=(int) 22, (int) 1]} [code=20000, state=23503]
> [java] at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257)
> [java] at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:233)
> [java] at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:70)
> [java] at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1079)
> [java] at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:285)
> [java] at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1722)
> [java] at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267)
> [java] at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118)
> [java] ... 37 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
