[Building Sakai] Problem to delete a gradebook
Manuel Pérez
manuelpg07 at gmail.com
Mon Jan 18 14:50:09 PST 2010
Hi, I have the following problem, when i try to delete a site and the
GradebookFrameworkService try to delete the associate gradebook it can't do
it, any solution?
INFO: Gradebook being deleted from context testsite1 (2010-01-18
23:44:40,876 ht
tp-8080-Processor25_org.sakaiproject.tool.gradebook.facades.sakai2impl.Gradebook
EntityProducer)
INFO: Deleting gradebook uid=testsite1 by userUid=admin (2010-01-18
23:44:40,877
http-8080-Processor25_org.sakaiproject.component.gradebook.GradebookFrameworkSe
rviceImpl)
WARN: SQL Error: 1451, SQLState: 23000 (2010-01-18 23:44:40,937
http-8080-Proces
sor25_org.hibernate.util.JDBCExceptionReporter)
ERROR: Cannot delete or update a parent row: a foreign key constraint fails
(`sa
kai/gb_comment_t`, CONSTRAINT `FK7977DFF06F98CFF` FOREIGN KEY
(`GRADABLE_OBJECT_
ID`) REFERENCES `gb_gradable_object_t` (`ID`)) (2010-01-18 23:44:40,938
http-808
0-Processor25_org.hibernate.util.JDBCExceptionReporter)
ERROR: Could not synchronize database state with session (2010-01-18
23:44:40,94
1
http-8080-Processor25_org.hibernate.event.def.AbstractFlushingEventListener)
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.sak
aiproject.tool.gradebook.Assignment#2]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:71)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(Abstrac
tEntityPersister.java:2308)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(Abstrac
tEntityPersister.java:2440)
at
org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.ja
va:73)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:297)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at
org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate
(HibernateTemplate.java:815)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:366)
at
org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateT
emplate.java:813)
at
org.sakaiproject.component.gradebook.GradebookFrameworkServiceImpl.de
leteGradebook(GradebookFrameworkServiceImpl.java:282)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:287)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:181)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
at $Proxy28.deleteGradebook(Unknown Source)
at
org.sakaiproject.tool.gradebook.facades.sakai2impl.GradebookEntityPro
ducer.contextDeleted(GradebookEntityProducer.java:89)
at
org.sakaiproject.site.impl.BaseSiteService.disableRelated(BaseSiteSer
vice.java:1829)
at
org.sakaiproject.site.impl.BaseSiteService.removeSite(BaseSiteService
.java:1066)
at
org.sakaiproject.site.cover.SiteService.removeSite(SiteService.java:2
26)
at
org.unioviproject.OSIDUnitTest.CourseManagementUnitTest.deleteTest(Co
urseManagementUnitTest.java:409)
at
org.unioviproject.OSIDUnitTest.CourseManagementUnitTest.doGet(CourseM
anagementUnitTest.java:93)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
at java.lang.Thread.run(Thread.java:595)
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`sakai/gb
_comment_t`, CONSTRAINT `FK7977DFF06F98CFF` FOREIGN KEY
(`GRADABLE_OBJECT_ID`) R
EFERENCES `gb_gradable_object_t` (`ID`))
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1332)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1604)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1519)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1504)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
egatingPreparedStatement.java:101)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(Abstrac
tEntityPersister.java:2294)
... 45 more
Thanks in advanve, greetings
Manuel Pérez González
Universidad de Oviedo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100118/626be2d5/attachment.html
More information about the sakai-dev
mailing list