Dear Fabian,
Thank you for this stack trace.
I believe this relates to the bugs previously reported all relating to deleting a resource (#59, #67, #69, #101, #132, #151, #155, #194) http://code.google.com/p/gbif-providertoolkit/issues/list?can=1&q=delete...
You can see that some of these issues have been fixed already, but not yet released, and the remaining ones are underway to be fixed for the next release (in particular http://code.google.com/p/gbif-providertoolkit/issues/detail?id=155&can=1...) .
The next release of the IPT will be in the coming 2-3 weeks which will have many bug fixes. I recommend that you continue evaluation but consider upgrading to the newest version when it is released.
Please accept our apologies for the bugs you are seeing.
Best wishes, Tim
On Nov 11, 2009, at 8:36 AM, Fabian Haas wrote:
Dear all,
thanks for the help! This is a 'fresh' YIKES! report provoked through deleting the "Tse Tse Flies of East Africa" resource from within the IPT.
here is also the Cache Database section, ... well no, I dont find it, there is only an import button, and then the whole fracas starts again...
Best Fabian
Yikes!
javax.servlet.ServletException: could not execute update query at net.sf.ehcache.constructs.web.filter.Filter.logThrowable(Filter.java: 152) at net.sf.ehcache.constructs.web.filter.Filter.doFilter(Filter.java: 97) at org .apache .catalina .core .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 215) at org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org .appfuse .webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:74) at org .springframework .web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 76) at org .apache .catalina .core .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 215) at org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org .springframework .orm .hibernate3 .support .OpenSessionInViewFilter .doFilterInternal(OpenSessionInViewFilter.java:198) at org .springframework .web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 76) at org .apache .catalina .core .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 215) at org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:359) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke (FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter (FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .ui .ExceptionTranslationFilter .doFilterHttp(ExceptionTranslationFilter.java:101) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .providers .anonymous .AnonymousProcessingFilter .doFilterHttp(AnonymousProcessingFilter.java:105) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .ui .rememberme .RememberMeProcessingFilter .doFilterHttp(RememberMeProcessingFilter.java:116) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .wrapper .SecurityContextHolderAwareRequestFilter .doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .ui .basicauth .BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:172) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .ui .AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java: 268) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:87) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .ui .SessionFixationProtectionFilter .doFilterHttp(SessionFixationProtectionFilter.java:61) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security .context .HttpSessionContextIntegrationFilter .doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org .springframework .security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java: 53) at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java:371) at org .springframework .security.util.FilterChainProxy.doFilter(FilterChainProxy.java:174) at org .springframework .web .filter .DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org .springframework .web .filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org .apache .catalina .core .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 215) at org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (CharacterEncodingFilter.java:96) at org .springframework .web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 76) at org .apache .catalina .core .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 215) at org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org .apache .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 213) at org .apache .catalina.core.StandardContextValve.invoke(StandardContextValve.java: 172) at org .apache .catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org .apache .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org .apache .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 108) at org .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 174) at org .apache .coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:837) at org.apache.coyote.http11.Http11AprProtocol $Http11ConnectionHandler.process(Http11AprProtocol.java:640) at org.apache.tomcat.util.net.AprEndpoint $Worker.run(AprEndpoint.java:1286) at java.lang.Thread.run(Unknown Source)
Tim Robertson wrote:
Dear Fabian, Please do send the Yikes listing and we will do all we can to help Many thanks, Tim On Nov 10, 2009, at 6:39 AM, Fabian Haas wrote:
Dear all
ah well could not find the protocol, I believe I have seen something like that, but can you be even more precise with this.
alas I have to agree that IPT is very unstable, half of the things I am trying to do end up in a server restart...
Is the long YIKES listing useful to anybody? Than I would send it around.
Best from Nairoby
Fabian
--
fhaas@icipe.org, Extension -2052
The African Insect Taxonomy Toolkit AITT http://taxonomy.icipe.org
Dr. Fabian Haas Insect Taxonomist and ABS Specialist ICIPE - African Insect Science for Food and Health Duduville Campus, Kasarani P.O. Box 30772 - 00100 N A I R O B I Kenya
Telephone No. +254 (0)20 8632000 Fax No. +254 (0)20 8632001 Cell Phone +254 (0)728 132868
This position is supported by CIM, the Centre for International Migration www.cimonline.de