search

ctron / package-drone

An OSGI first software artifact repository – Moved to the Eclipse Foundation
https://github.com/eclipse/packagedrone
Eclipse Public License 1.0
39 stars 13 forks source link

Problems with aspect "P2 Metadata Generator" #88

Closed afischer211 closed 9 years ago

afischer211 commented 9 years ago

I have a channel with OSGi-artifacts deployed from tycho or from other sources (so with p2 metadata and without). For a clear situation I have added the two aspects "P2 Metadata Generator" and "Tycho Cleaner". I want to ensure, that Package Drone generates the needed informations itself. This works so long, until I try to add artifacts with same metainformations. Then I get errors like this:

Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound]

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE)

How can I solve this problems? Without the aspect "P2 Metadata Generator" this problems does not occur. But than I have an nearly empty content.xml and artifacts.xml for the channel/p2-repository (no enlisted artifacts). So Tycho can not find the artifacts in the repository.

ctron commented 9 years ago

Can you give them last few steps to reproduce this issue so I can have a look at it tomorrow.

afischer211 commented 9 years ago

Some more informations: package-drone 0.8.1 with MySQL 5.1 and filesystem-storage for BLOBs channel with following aspects:

image

Cleanup-Configuration: image

Use the example-project of issue #85 and run deployment 3x quickly in series (mvn clean deploy -DaltDeploymentRepository=pdrone::default::http://...) Two times it works, on third run it fails with server-error 500 on Maven-side. The console-log of package-drone shows:

WARN o.e.jetty.servlet.ServletHandler [ServletHandler.java:620] javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@570d9d7) at de.dentrassi.pm.maven.internal.MavenServlet.doPut(MavenServlet.java:219) ~[de.dentrassi.pm.maven_1.0.0.20150513-1125.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) ~[javax.servlet-api_3.1.0.jar:3.1.0] at de.dentrassi.pm.storage.service.servlet.AbstractStorageServiceServlet.service(AbstractStorageServiceServlet.java:85) ~[de.dentrassi.pm.storage.service_1.0.0.20150508-1435.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[javax.servlet-api_3.1.0.jar:3.1.0] at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808) ~[na:na] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587) [org.eclipse.jetty.servlet_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577) [org.eclipse.jetty.security_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) [org.eclipse.jetty.servlet_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.Server.handle(Server.java:497) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) [org.eclipse.jetty.io_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) [org.eclipse.jetty.util_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) [org.eclipse.jetty.util_9.2.9.v20150224.jar:9.2.9.v20150224] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@570d9d7) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) ~[na:na] at de.dentrassi.pm.storage.service.jpa.LockManager.modifyCall(LockManager.java:63) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.internalCreateArtifact(StorageServiceImpl.java:203) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.createArtifact(StorageServiceImpl.java:198) ~[na:na] at de.dentrassi.pm.storage.service.jpa.ChannelImpl.createArtifact(ChannelImpl.java:124) ~[na:na] at de.dentrassi.pm.maven.internal.MavenServlet.storeArtifact(MavenServlet.java:509) ~[de.dentrassi.pm.maven_1.0.0.20150513-1125.jar:na] at de.dentrassi.pm.maven.internal.MavenServlet.processUpload(MavenServlet.java:284) ~[de.dentrassi.pm.maven_1.0.0.20150513-1125.jar:na] at de.dentrassi.pm.maven.internal.MavenServlet.processPut(MavenServlet.java:246) ~[de.dentrassi.pm.maven_1.0.0.20150513-1125.jar:na] at de.dentrassi.pm.maven.internal.MavenServlet.doPut(MavenServlet.java:211) ~[de.dentrassi.pm.maven_1.0.0.20150513-1125.jar:na]

May be the cleanup-aspect is not quickly enough? Or we have in general a problem with multiple deployment of the same artifact? But then the second or third deployment-run should be ignored by the repository.

ctron commented 9 years ago

This is strange. Which database engine are you using? InnoDB?

afischer211 commented 9 years ago

Yes, I use (how in my other issues) MySQL5.1 with InnoDB. I think, the problem occurs, if the same artifact is deployed mutliple times. The aspects than have some problems with generating metainformations. Do you think, the migration to postgres is the general solution for my problems? I want to use your awesome repository for productive purposes and run into so tricky problems...

ctron commented 9 years ago

I will give it a try tomorrow.

ctron commented 9 years ago

Ok, thanks for the good report! The good thing is, I can reproduce it. The bad thing, is really seems to be a bug.

ctron commented 9 years ago

Also did I spot another issue there. Since the second run of mvn deploy actually deploy the artifacts as parents to the first deploy run?! Can you confirm this?

ctron commented 9 years ago

So this first bug of this issue is fixed. Release artifacts really got added as child elements.

ctron commented 9 years ago

Changing the "Number of Entries" from 1 to 2 solves the issue for me. And I think I know what causes this issue. Can you confirm that changing from 1 to 2 solves the issue on your end?

I know this is not the solution. Just checking!

afischer211 commented 9 years ago

I have attached a screenshot for the situation after running the deployment successfully 3x: image

I have configured the cleanup aspect to keep 3 instances of the artifact. You can see, that the second deploy is attached under the first deployment. The 3rd deployment is not included under another deployment.

afischer211 commented 9 years ago

Thanks for your informations: If I don't get any problem with other aspects (e.g. generation of p2-metadata) than I can change it to 2.

afischer211 commented 9 years ago

After my tries with the modified cleanup-settings (and with the deployed test-artifact) I tried to reload all aspects. After some time I get the following error in my browser:

HTTP ERROR 500

Problem accessing /channel/84BCE016-AD4E-4E1F-BCED-43AA26C43F2E/refreshAllAspects. Reason:

Server Error

Caused by:

javax.servlet.ServletException: javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.DispatcherServlet.service(DispatcherServlet.java:121) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at de.dentrassi.osgi.web.servlet.FilterTracker.doRunFilter(FilterTracker.java:135) at de.dentrassi.osgi.web.servlet.FilterTracker.access$1(FilterTracker.java:118) at de.dentrassi.osgi.web.servlet.FilterTracker$2.doFilter(FilterTracker.java:128) at de.dentrassi.pm.sec.web.filter.SecurityFilter.processFilter(SecurityFilter.java:102) at de.dentrassi.pm.sec.web.filter.SecurityFilter.doFilter(SecurityFilter.java:75) at de.dentrassi.osgi.web.servlet.FilterTracker$TrackedFilter.doFilter(FilterTracker.java:52) at de.dentrassi.osgi.web.servlet.FilterTracker.doRunFilter(FilterTracker.java:123) at de.dentrassi.osgi.web.servlet.FilterTracker.doFilter(FilterTracker.java:115) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:497) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:745) Caused by: javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.DispatcherServlet.service(DispatcherServlet.java:112) ... 31 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.call(ControllerCall.java:116) at de.dentrassi.osgi.web.controller.ControllerEntry.findHandler(ControllerEntry.java:108) at de.dentrassi.osgi.web.controller.ControllerTracker.handleRequest(ControllerTracker.java:133) at de.dentrassi.osgi.web.DispatcherServlet.mapRequest(DispatcherServlet.java:164) at de.dentrassi.osgi.web.DispatcherServlet.service(DispatcherServlet.java:98) ... 31 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:66) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$31/1169087526.apply(Unknown Source) at de.dentrassi.pm.sec.web.controller.SecuredControllerInterceptor.before(SecuredControllerInterceptor.java:57) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:59) at de.dentrassi.osgi.web.controller.ControllerCall.call(ControllerCall.java:103) ... 35 more Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:66) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$31/1169087526.apply(Unknown Source) at de.dentrassi.pm.sec.web.controller.HttpContraintControllerInterceptor.before(HttpContraintControllerInterceptor.java:49) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:59) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:62) ... 39 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at de.dentrassi.osgi.web.controller.binding.BindingManager$1.invoke(BindingManager.java:107) at de.dentrassi.osgi.web.controller.ControllerCall.processCall(ControllerCall.java:136) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$2(ControllerCall.java:103) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$28/1557146916.call(Unknown Source) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:72) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:62) ... 43 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) at de.dentrassi.pm.storage.service.jpa.LockManager.modifyRun(LockManager.java:50) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.refreshAllChannelAspects(StorageServiceImpl.java:396) at de.dentrassi.pm.storage.web.channel.ChannelController.refreshAllAspects(ChannelController.java:716) ... 53 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:124) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransactionVoid(AbstractJpaServiceImpl.java:58) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.doWithHandlerVoid(StorageServiceImpl.java:840) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$19(StorageServiceImpl.java:397) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$123/702191444.run(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.lambda$1(LockManager.java:51) at de.dentrassi.pm.storage.service.jpa.LockManager$$Lambda$95/1900771388.call(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.process(LockManager.java:111) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:83) ... 56 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:113) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl$$Lambda$6/1793744537.process(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithManager(AbstractJpaServiceImpl.java:48) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:68) ... 64 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.scanArtifacts(StorageHandlerImpl.java:945) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.createAllVirtualArtifacts(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.reprocessAspects(StorageHandlerImpl.java:860) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$57(StorageServiceImpl.java:403) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$124/2067784917.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$39(StorageServiceImpl.java:842) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$16/1066406837.processVoid(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$0(AbstractJpaServiceImpl.java:59) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl$$Lambda$5/900492073.process(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:80) ... 67 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.doStreamed(BlobStore.java:172) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$18(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$130/976627427.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.scanArtifacts(StorageHandlerImpl.java:941) ... 76 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.virtualize(P2Virtualizer.java:54) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$8(StorageHandlerImpl.java:598) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$90/1272797952.accept(Unknown Source) at de.dentrassi.pm.aspect.ChannelAspectProcessor.processWithAspect(ChannelAspectProcessor.java:171) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.createVirtualArtifacts(StorageHandlerImpl.java:598) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$28(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$131/2090570045.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.doStreamed(BlobStore.java:164) ... 79 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$ArtifactContextImpl.createVirtualArtifact(StorageHandlerImpl.java:253) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.createXmlVirtualArtifact(P2Virtualizer.java:156) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.createFeatureP2MetaData(P2Virtualizer.java:140) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.processVirtualize(P2Virtualizer.java:77) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.virtualize(P2Virtualizer.java:50) ... 86 more Caused by: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) at de.dentrassi.pm.storage.service.jpa.LockManager.modifyCall(LockManager.java:63) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.performStoreArtifact(StorageHandlerImpl.java:455) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$ArtifactContextImpl.createVirtualArtifact(StorageHandlerImpl.java:249) ... 90 more Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:879) at org.eclipse.persistence.internal.jpa.QueryImpl.performPreQueryFlush(QueryImpl.java:967) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:207) at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473) at de.dentrassi.pm.storage.service.jpa.ValidationHandler.aggregateArtifact(ValidationHandler.java:97) at de.dentrassi.pm.storage.service.jpa.ValidationMessageSink.flush(ValidationMessageSink.java:93) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$23(StorageHandlerImpl.java:470) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$85/1957689618.apply(Unknown Source) at de.dentrassi.pm.storage.service.jpa.blob.FilesystemBlobStoreProcessor.storeBlob(FilesystemBlobStoreProcessor.java:163) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.storeBlob(BlobStore.java:236) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$5(StorageHandlerImpl.java:467) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$77/1184911069.call(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.process(LockManager.java:111) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:83) ... 93 more Caused by: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:363) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301) at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1790) at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:227) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:194) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:139) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4260) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1587) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:455) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874) ... 106 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) at com.mysql.jdbc.Util.getInstance(Util.java:360) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892) ... 136 more Caused by:

javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.DispatcherServlet.service(DispatcherServlet.java:112) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at de.dentrassi.osgi.web.servlet.FilterTracker.doRunFilter(FilterTracker.java:135) at de.dentrassi.osgi.web.servlet.FilterTracker.access$1(FilterTracker.java:118) at de.dentrassi.osgi.web.servlet.FilterTracker$2.doFilter(FilterTracker.java:128) at de.dentrassi.pm.sec.web.filter.SecurityFilter.processFilter(SecurityFilter.java:102) at de.dentrassi.pm.sec.web.filter.SecurityFilter.doFilter(SecurityFilter.java:75) at de.dentrassi.osgi.web.servlet.FilterTracker$TrackedFilter.doFilter(FilterTracker.java:52) at de.dentrassi.osgi.web.servlet.FilterTracker.doRunFilter(FilterTracker.java:123) at de.dentrassi.osgi.web.servlet.FilterTracker.doFilter(FilterTracker.java:115) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:497) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.call(ControllerCall.java:116) at de.dentrassi.osgi.web.controller.ControllerEntry.findHandler(ControllerEntry.java:108) at de.dentrassi.osgi.web.controller.ControllerTracker.handleRequest(ControllerTracker.java:133) at de.dentrassi.osgi.web.DispatcherServlet.mapRequest(DispatcherServlet.java:164) at de.dentrassi.osgi.web.DispatcherServlet.service(DispatcherServlet.java:98) ... 31 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:66) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$31/1169087526.apply(Unknown Source) at de.dentrassi.pm.sec.web.controller.SecuredControllerInterceptor.before(SecuredControllerInterceptor.java:57) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:59) at de.dentrassi.osgi.web.controller.ControllerCall.call(ControllerCall.java:103) ... 35 more Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:66) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$31/1169087526.apply(Unknown Source) at de.dentrassi.pm.sec.web.controller.HttpContraintControllerInterceptor.before(HttpContraintControllerInterceptor.java:49) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:59) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:62) ... 39 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at de.dentrassi.osgi.web.controller.binding.BindingManager$1.invoke(BindingManager.java:107) at de.dentrassi.osgi.web.controller.ControllerCall.processCall(ControllerCall.java:136) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$2(ControllerCall.java:103) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$28/1557146916.call(Unknown Source) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:72) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:62) ... 43 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) at de.dentrassi.pm.storage.service.jpa.LockManager.modifyRun(LockManager.java:50) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.refreshAllChannelAspects(StorageServiceImpl.java:396) at de.dentrassi.pm.storage.web.channel.ChannelController.refreshAllAspects(ChannelController.java:716) ... 53 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:124) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransactionVoid(AbstractJpaServiceImpl.java:58) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.doWithHandlerVoid(StorageServiceImpl.java:840) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$19(StorageServiceImpl.java:397) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$123/702191444.run(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.lambda$1(LockManager.java:51) at de.dentrassi.pm.storage.service.jpa.LockManager$$Lambda$95/1900771388.call(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.process(LockManager.java:111) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:83) ... 56 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:113) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl$$Lambda$6/1793744537.process(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithManager(AbstractJpaServiceImpl.java:48) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:68) ... 64 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.scanArtifacts(StorageHandlerImpl.java:945) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.createAllVirtualArtifacts(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.reprocessAspects(StorageHandlerImpl.java:860) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$57(StorageServiceImpl.java:403) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$124/2067784917.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$39(StorageServiceImpl.java:842) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$16/1066406837.processVoid(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$0(AbstractJpaServiceImpl.java:59) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl$$Lambda$5/900492073.process(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:80) ... 67 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.doStreamed(BlobStore.java:172) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$18(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$130/976627427.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.scanArtifacts(StorageHandlerImpl.java:941) ... 76 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.virtualize(P2Virtualizer.java:54) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$8(StorageHandlerImpl.java:598) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$90/1272797952.accept(Unknown Source) at de.dentrassi.pm.aspect.ChannelAspectProcessor.processWithAspect(ChannelAspectProcessor.java:171) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.createVirtualArtifacts(StorageHandlerImpl.java:598) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$28(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$131/2090570045.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.doStreamed(BlobStore.java:164) ... 79 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$ArtifactContextImpl.createVirtualArtifact(StorageHandlerImpl.java:253) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.createXmlVirtualArtifact(P2Virtualizer.java:156) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.createFeatureP2MetaData(P2Virtualizer.java:140) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.processVirtualize(P2Virtualizer.java:77) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.virtualize(P2Virtualizer.java:50) ... 86 more Caused by: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) at de.dentrassi.pm.storage.service.jpa.LockManager.modifyCall(LockManager.java:63) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.performStoreArtifact(StorageHandlerImpl.java:455) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$ArtifactContextImpl.createVirtualArtifact(StorageHandlerImpl.java:249) ... 90 more Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:879) at org.eclipse.persistence.internal.jpa.QueryImpl.performPreQueryFlush(QueryImpl.java:967) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:207) at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473) at de.dentrassi.pm.storage.service.jpa.ValidationHandler.aggregateArtifact(ValidationHandler.java:97) at de.dentrassi.pm.storage.service.jpa.ValidationMessageSink.flush(ValidationMessageSink.java:93) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$23(StorageHandlerImpl.java:470) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$85/1957689618.apply(Unknown Source) at de.dentrassi.pm.storage.service.jpa.blob.FilesystemBlobStoreProcessor.storeBlob(FilesystemBlobStoreProcessor.java:163) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.storeBlob(BlobStore.java:236) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$5(StorageHandlerImpl.java:467) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$77/1184911069.call(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.process(LockManager.java:111) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:83) ... 93 more Caused by: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:363) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301) at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1790) at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:227) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:194) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:139) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4260) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1587) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:455) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874) ... 106 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) at com.mysql.jdbc.Util.getInstance(Util.java:360) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892) ... 136 more Caused by:

java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.call(ControllerCall.java:116) at de.dentrassi.osgi.web.controller.ControllerEntry.findHandler(ControllerEntry.java:108) at de.dentrassi.osgi.web.controller.ControllerTracker.handleRequest(ControllerTracker.java:133) at de.dentrassi.osgi.web.DispatcherServlet.mapRequest(DispatcherServlet.java:164) at de.dentrassi.osgi.web.DispatcherServlet.service(DispatcherServlet.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at de.dentrassi.osgi.web.servlet.FilterTracker.doRunFilter(FilterTracker.java:135) at de.dentrassi.osgi.web.servlet.FilterTracker.access$1(FilterTracker.java:118) at de.dentrassi.osgi.web.servlet.FilterTracker$2.doFilter(FilterTracker.java:128) at de.dentrassi.pm.sec.web.filter.SecurityFilter.processFilter(SecurityFilter.java:102) at de.dentrassi.pm.sec.web.filter.SecurityFilter.doFilter(SecurityFilter.java:75) at de.dentrassi.osgi.web.servlet.FilterTracker$TrackedFilter.doFilter(FilterTracker.java:52) at de.dentrassi.osgi.web.servlet.FilterTracker.doRunFilter(FilterTracker.java:123) at de.dentrassi.osgi.web.servlet.FilterTracker.doFilter(FilterTracker.java:115) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:497) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:66) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$31/1169087526.apply(Unknown Source) at de.dentrassi.pm.sec.web.controller.SecuredControllerInterceptor.before(SecuredControllerInterceptor.java:57) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:59) at de.dentrassi.osgi.web.controller.ControllerCall.call(ControllerCall.java:103) ... 35 more Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:66) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$31/1169087526.apply(Unknown Source) at de.dentrassi.pm.sec.web.controller.HttpContraintControllerInterceptor.before(HttpContraintControllerInterceptor.java:49) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:59) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:62) ... 39 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at de.dentrassi.osgi.web.controller.binding.BindingManager$1.invoke(BindingManager.java:107) at de.dentrassi.osgi.web.controller.ControllerCall.processCall(ControllerCall.java:136) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$2(ControllerCall.java:103) at de.dentrassi.osgi.web.controller.ControllerCall$$Lambda$28/1557146916.call(Unknown Source) at de.dentrassi.osgi.web.controller.ControllerCall.runForward(ControllerCall.java:72) at de.dentrassi.osgi.web.controller.ControllerCall.lambda$0(ControllerCall.java:62) ... 43 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) at de.dentrassi.pm.storage.service.jpa.LockManager.modifyRun(LockManager.java:50) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.refreshAllChannelAspects(StorageServiceImpl.java:396) at de.dentrassi.pm.storage.web.channel.ChannelController.refreshAllAspects(ChannelController.java:716) ... 53 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:124) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransactionVoid(AbstractJpaServiceImpl.java:58) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.doWithHandlerVoid(StorageServiceImpl.java:840) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$19(StorageServiceImpl.java:397) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$123/702191444.run(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.lambda$1(LockManager.java:51) at de.dentrassi.pm.storage.service.jpa.LockManager$$Lambda$95/1900771388.call(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.process(LockManager.java:111) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:83) ... 56 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:113) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl$$Lambda$6/1793744537.process(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithManager(AbstractJpaServiceImpl.java:48) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:68) ... 64 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.scanArtifacts(StorageHandlerImpl.java:945) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.createAllVirtualArtifacts(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.reprocessAspects(StorageHandlerImpl.java:860) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$57(StorageServiceImpl.java:403) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$124/2067784917.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$39(StorageServiceImpl.java:842) at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$16/1066406837.processVoid(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$0(AbstractJpaServiceImpl.java:59) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl$$Lambda$5/900492073.process(Unknown Source) at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:80) ... 67 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.doStreamed(BlobStore.java:172) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$18(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$130/976627427.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.scanArtifacts(StorageHandlerImpl.java:941) ... 76 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.virtualize(P2Virtualizer.java:54) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$8(StorageHandlerImpl.java:598) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$90/1272797952.accept(Unknown Source) at de.dentrassi.pm.aspect.ChannelAspectProcessor.processWithAspect(ChannelAspectProcessor.java:171) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.createVirtualArtifacts(StorageHandlerImpl.java:598) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$28(StorageHandlerImpl.java:1084) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$131/2090570045.accept(Unknown Source) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.doStreamed(BlobStore.java:164) ... 79 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$ArtifactContextImpl.createVirtualArtifact(StorageHandlerImpl.java:253) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.createXmlVirtualArtifact(P2Virtualizer.java:156) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.createFeatureP2MetaData(P2Virtualizer.java:140) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.processVirtualize(P2Virtualizer.java:77) at de.dentrassi.pm.aspect.common.p2.P2Virtualizer.virtualize(P2Virtualizer.java:50) ... 86 more Caused by: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) at de.dentrassi.pm.storage.service.jpa.LockManager.modifyCall(LockManager.java:63) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.performStoreArtifact(StorageHandlerImpl.java:455) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$ArtifactContextImpl.createVirtualArtifact(StorageHandlerImpl.java:249) ... 90 more Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:879) at org.eclipse.persistence.internal.jpa.QueryImpl.performPreQueryFlush(QueryImpl.java:967) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:207) at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473) at de.dentrassi.pm.storage.service.jpa.ValidationHandler.aggregateArtifact(ValidationHandler.java:97) at de.dentrassi.pm.storage.service.jpa.ValidationMessageSink.flush(ValidationMessageSink.java:93) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$23(StorageHandlerImpl.java:470) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$85/1957689618.apply(Unknown Source) at de.dentrassi.pm.storage.service.jpa.blob.FilesystemBlobStoreProcessor.storeBlob(FilesystemBlobStoreProcessor.java:163) at de.dentrassi.pm.storage.service.jpa.blob.BlobStore.storeBlob(BlobStore.java:236) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl.lambda$5(StorageHandlerImpl.java:467) at de.dentrassi.pm.storage.service.jpa.StorageHandlerImpl$$Lambda$77/1184911069.call(Unknown Source) at de.dentrassi.pm.storage.service.jpa.LockManager.process(LockManager.java:111) at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:83) ... 93 more Caused by: Exception [EclipseLink-4002](Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) Error Code: 1452 Call: INSERT INTO ARTIFACTS (ID, AGR_NUM_ERR, AGR_NUM_WARN, CREATION_TS, NAME, SIZE, CHANNEL_ID, PARENT, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound] Query: InsertObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@25ca8959) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:363) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301) at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1790) at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:227) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:194) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:139) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4260) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1587) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:455) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:874) ... 106 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (pd.ARTIFACTS, CONSTRAINT ARTIFACTS_ibfk_2 FOREIGN KEY (PARENT) REFERENCES ARTIFACTS (ID) ON DELETE CASCADE) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) at com.mysql.jdbc.Util.getInstance(Util.java:360) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892) ... 136 more

afischer211 commented 9 years ago

After removing the test-artifacts (all instances) from the channel the refresh of the channel-aspects is working again (there are many other artifacts in the channel).

ctron commented 9 years ago

So this sums up to two bugs.

The first bug, as already mentioned: Release type artifacts got added as children.

The second bug: Artifacts whose parents got deleted during some channel operations but still got queue to be persisted caused the failure. So for now the resolution is to check if the parent is persisted before storing the artifact itself.

This fix will be in the next version. I am still unsure if this will be 0.8.2 or 0.9.0.

afischer211 commented 9 years ago

Hello, I see your preparation for the next release 0.9.0. Can I get an rpm-package (yum-installation) for the next version for installing and testing? Or do I have to checkout and build the version myself?

ctron commented 9 years ago

I made a snapshot build with RPMs for you [1].

But please be aware that:

[1] https://www.wuala.com/ctron/drone/?key=rTnBx1xnFmFD

afischer211 commented 9 years ago

Thanks for your attention. I will give it a try with a new database scheme.

afischer211 commented 9 years ago

I have successfully updated. After this I deployed an artifact to pdrone, which is already deployed there --> error 500 In the console-log I retrieve the following exceptions: 12:57:35.725 [qtp1884166752-34] WARN o.e.jetty.servlet.ServletHandler [ServletHandler.java:620] javax.servlet.ServletException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.NullPointerException at de.dentrassi.pm.maven.internal.MavenServlet.doPut(MavenServlet.java:219) ~[de.dentrassi.pm.maven_1.0.0.20150519-1423.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) ~[javax.servlet-api_3.1.0.jar:3.1.0] at de.dentrassi.pm.storage.service.servlet.AbstractStorageServiceServlet.service(AbstractStorageServiceServlet.java:85) ~[de.dentrassi.pm.storage.service_1.0.0.20150508-1435.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[javax.servlet-api_3.1.0.jar:3.1.0] at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808) ~[na:na] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587) [org.eclipse.jetty.servlet_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577) [org.eclipse.jetty.security_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) [org.eclipse.jetty.servlet_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.Server.handle(Server.java:497) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) [org.eclipse.jetty.server_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) [org.eclipse.jetty.io_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) [org.eclipse.jetty.util_9.2.9.v20150224.jar:9.2.9.v20150224] at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) [org.eclipse.jetty.util_9.2.9.v20150224.jar:9.2.9.v20150224] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_45] Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.NullPointerException at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:87) ~[na:na] at de.dentrassi.pm.storage.service.jpa.LockManager.modifyCall(LockManager.java:63) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.internalCreateArtifact(StorageServiceImpl.java:203) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.createArtifact(StorageServiceImpl.java:198) ~[na:na] at de.dentrassi.pm.storage.service.jpa.ChannelImpl.createArtifact(ChannelImpl.java:124) ~[na:na] at de.dentrassi.pm.maven.internal.MavenServlet.storeArtifact(MavenServlet.java:531) ~[de.dentrassi.pm.maven_1.0.0.20150519-1423.jar:na] at de.dentrassi.pm.maven.internal.MavenServlet.processUpload(MavenServlet.java:297) ~[de.dentrassi.pm.maven_1.0.0.20150519-1423.jar:na] at de.dentrassi.pm.maven.internal.MavenServlet.processPut(MavenServlet.java:246) ~[de.dentrassi.pm.maven_1.0.0.20150519-1423.jar:na] at de.dentrassi.pm.maven.internal.MavenServlet.doPut(MavenServlet.java:211) ~[de.dentrassi.pm.maven_1.0.0.20150519-1423.jar:na] ... 23 common frames omitted Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.NullPointerException at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:124) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.doWithHandler(StorageServiceImpl.java:848) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$6(StorageServiceImpl.java:204) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$77/732189197.call(Unknown Source) ~[na:na] at de.dentrassi.pm.storage.service.jpa.LockManager.process(LockManager.java:111) ~[na:na] at de.dentrassi.pm.storage.service.jpa.LockManager.act(LockManager.java:83) ~[na:na] ... 31 common frames omitted Caused by: java.lang.RuntimeException: java.lang.NullPointerException at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:113) ~[na:na] at de.dentrassi.pm.common.service.AbstractJpaServiceImpl$$Lambda$12/1847420574.process(Unknown Source) ~[na:na] at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithManager(AbstractJpaServiceImpl.java:48) ~[na:na] at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.doWithTransaction(AbstractJpaServiceImpl.java:68) ~[na:na] ... 36 common frames omitted Caused by: java.lang.NullPointerException: null at java.util.TreeMap.put(TreeMap.java:563) ~[na:1.8.0_45] at java.util.TreeSet.add(TreeSet.java:255) ~[na:1.8.0_45] at de.dentrassi.pm.storage.service.jpa.StreamServiceHelper.convert(StreamServiceHelper.java:116) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.convert(StorageServiceImpl.java:305) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$53(StorageServiceImpl.java:216) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$79/302523694.process(Unknown Source) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl.lambda$40(StorageServiceImpl.java:850) ~[na:na] at de.dentrassi.pm.storage.service.jpa.StorageServiceImpl$$Lambda$50/1711427470.process(Unknown Source) ~[na:na] at de.dentrassi.pm.common.service.AbstractJpaServiceImpl.lambda$1(AbstractJpaServiceImpl.java:80) ~[na:na] ... 39 common frames omitted

ctron commented 9 years ago

So you did deploy the same artifact a second time? I am not sure I understood that correctly.

ctron commented 9 years ago

Ok, I think I known where this problem is coming from.

I did add a sort field to my clean up configuration for ("core:timestamp"), so that only the oldest artifacts get deleted. But I remember you did not sort your artifacts.

So when I reverse the sort order for my sample, to force deleting the artifact which just got added I run into the same issue.

Could you add a sort field for "core" / "timestamp" and re-check.

afischer211 commented 9 years ago

I have different artifacts in one channel. If I try to deploy such an artifact again into the same channel, then I get the stacktrace. I have tried it explicitly with our test-feature. The first deployment is successfull, the result in the channel is: image

The second deployment fails with error 500, the channel looks like: image

Only the pom-artifact is updated. The stacktrace is the same like in my last comment.

ctron commented 9 years ago

If you can tell me if you need the "el6" or "el7" variant I would make a quick test for you.

afischer211 commented 9 years ago

With your suggested configuration-change (sorter within cleanup aspect) the repeated deployment works successfully without any exceptions! I use the el7-variant for CentOS7.

ctron commented 9 years ago

I will upload the (hopefully) final release RPM package-drone-server-0.9.0-1.el7.noarch.rpm to the same link as before. It should register as an upgrade.

afischer211 commented 9 years ago

I have installed successfully the new patch-version. After the last suggested config-changes the deployment already works. I will create a new test-channel with the old cleanup-config and test the new version again. The productive channels will keep the new cleanup-configuration. Thanks for your quick response!

afischer211 commented 9 years ago

The repeated deployment of one artifact to the same channel works now. Without cleanup-aspect I have the artifact multiple times inside the channel. How can I come to the official 0.9.0 release - or is my special version the same code-version?

ctron commented 9 years ago

Just download the RPM from github and install it with rpm -Uvh --force file.rpm ... And burn the other file ;-)

afischer211 commented 9 years ago

Ok, I have updated to the official 0.9.0-release (thanks for your hints). The tests with my old channel-cleanup configuration (without sorting config) are successful, so I can close the issue.