[Building Sakai] mysql foreign key error and deadlock : Sakai_site_tool_property and sakai_site_tool
Sanghyun Jeon
euksa99 at gmail.com
Wed Jan 7 13:41:19 PST 2015
Hello All,
We are using Sakai 2.9.3 and mysql 5.5.38.
Recently our database cpu is frequently spiking up near 99% usage and
sometimes database is unresponsive. While we are investigating the root
cause of this cpu issue, running "show engine innodb status" shows the
foreign key error and deadlock related with sakai_site_tool_property and
sakai_site_tool
*------------------------*
*LATEST FOREIGN KEY ERROR*
*------------------------*
*141230 15:52:26 Transaction:*
*TRANSACTION E8DD365, ACTIVE 3 sec updating or deleting*
*mysql tables in use 1, locked 1*
*4 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1*
*MySQL thread id 59773, OS thread handle 0x7fe0774d3700, query id
3080494644 XXXX.edu XXXXXXX sakai updating*
*delete from SAKAI_SITE_TOOL where SITE_ID = x'43585F6D74675F3330353636'
and TOOL_ID =
x'61306365383466372D653438642D343764662D383032322D656561653130623536336662'*
*Foreign key constraint fails for table `sakai`.`SAKAI_SITE_TOOL_PROPERTY`:*
*,*
* CONSTRAINT `SAKAI_SITE_TOOL_PROPERTY_ibfk_1` FOREIGN KEY (`TOOL_ID`)
REFERENCES `SAKAI_SITE_TOOL` (`TOOL_ID`)*
*Trying to delete or update in parent table, in index `PRIMARY` tuple:*
*DATA TUPLE: 9 fields;*
* 0: len 36; hex
61306365383466372d653438642d343764662d383032322d656561653130623536336662;
asc a0ce84f7-e48d-47df-8022-eeae10b563fb;;*
* 1: len 6; hex 00000e8dd365; asc e;;*
* 2: len 7; hex 31000004da1e9e; asc 1 ;;*
* 3: len 36; hex
37326561666365652d316663392d343332362d303035362d646561633836666330393137;
asc 72eafcee-1fc9-4326-0056-deac86fc0917;;*
* 4: len 12; hex 43585f6d74675f3330353636; asc CX_mtg_30566;;*
* 5: len 17; hex 73616b61692e696672616d652e73697465; asc
sakai.iframe.site;;*
* 6: len 4; hex 80000001; asc ;;*
* 7: len 24; hex 5369746520496e666f726d6174696f6e20446973706c6179; asc Site
Information Display;;*
* 8: len 3; hex 302c30; asc 0,0;;*
*But in child table `sakai`.`SAKAI_SITE_TOOL_PROPERTY`, in index `PRIMARY`,
there is a record:*
*PHYSICAL RECORD: n_fields 6; compact format; info bits 0*
* 0: len 30; hex
61306365383466372d653438642d343764662d383032322d656561653130; asc
a0ce84f7-e48d-47df-8022-eeae10; (total 36 bytes);*
* 1: len 18; hex 786672616d652d6c6173742d737461747573; asc
xframe-last-status;;*
* 2: len 6; hex 00000e8dd1f7; asc ;;*
* 3: len 7; hex e70000012b0110; asc + ;;*
* 4: len 12; hex 43585f6d74675f3330353636; asc CX_mtg_30566;;*
* 5: len 5; hex 66616c7365; asc false;;*
*------------------------*
*LATEST DETECTED DEADLOCK*
*------------------------*
*141230 8:56:55*
**** (1) TRANSACTION:*
*TRANSACTION E8CC25C, ACTIVE 268 sec starting index read*
*mysql tables in use 1, locked 1*
*LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)*
*MySQL thread id 59698, OS thread handle 0x7fe084e1d700, query id
3077901698 XXX.edu XXXXXXXX sakai updating*
*delete from SAKAI_SITE_TOOL_PROPERTY where SITE_ID =
x'43585F6D74675F3739353837' and TOOL_ID =
x'61396462353561352D656262372D343936302D613465652D356232363830393839623137'*
**** (1) WAITING FOR THIS LOCK TO BE GRANTED:*
*RECORD LOCKS space id 2496 page no 1129 n bits 200 index `PRIMARY` of
table `sakai`.`SAKAI_SITE_TOOL_PROPERTY` trx id E8CC25C lock_mode X locks
rec but not gap waiting*
*Record lock, heap no 118 PHYSICAL RECORD: n_fields 6; compact format; info
bits 32*
* 0: len 30; hex
61396462353561352d656262372d343936302d613465652d356232363830; asc
a9db55a5-ebb7-4960-a4ee-5b2680; (total 36 bytes);*
* 1: len 6; hex 736f75726365; asc source;;*
* 2: len 6; hex 00000e8cc40f; asc ;;*
* 3: len 7; hex 3c000000352c92; asc < 5, ;;*
* 4: len 12; hex 43585f6d74675f3739353837; asc CX_mtg_79587;;*
* 5: len 30; hex
68747470733a2f2f766964656f34372e7069747a65722e6564752f6c6f67; asc
https://video47.pitzer.edu/log <https://video47.pitzer.edu/log>; (total 88
bytes);*
**** (2) TRANSACTION:*
*TRANSACTION E8CC40F, ACTIVE 0 sec updating or deleting*
*mysql tables in use 1, locked 1*
*5 lock struct(s), heap size 1248, 5 row lock(s), undo log entries 4*
*MySQL thread id 59351, OS thread handle 0x7fe077410700, query id
3077901699 sakai-tc3.pomona.edu <http://sakai-tc3.pomona.edu> 134.173.69.38
sakai updating*
*delete from SAKAI_SITE_TOOL where SITE_ID = x'43585F6D74675F3739353837'
and TOOL_ID =
x'61396462353561352D656262372D343936302D613465652D356232363830393839623137'*
**** (2) HOLDS THE LOCK(S):*
*RECORD LOCKS space id 2496 page no 1129 n bits 200 index `PRIMARY` of
table `sakai`.`SAKAI_SITE_TOOL_PROPERTY` trx id E8CC40F lock_mode X locks
rec but not gap*
*Record lock, heap no 118 PHYSICAL RECORD: n_fields 6; compact format; info
bits 32*
* 0: len 30; hex
61396462353561352d656262372d343936302d613465652d356232363830; asc
a9db55a5-ebb7-4960-a4ee-5b2680; (total 36 bytes);*
* 1: len 6; hex 736f75726365; asc source;;*
* 2: len 6; hex 00000e8cc40f; asc ;;*
* 3: len 7; hex 3c000000352c92; asc < 5, ;;*
* 4: len 12; hex 43585f6d74675f3739353837; asc CX_mtg_79587;;*
* 5: len 30; hex
68747470733a2f2f766964656f34372e7069747a65722e6564752f6c6f67; asc
https://video47.pitzer.edu/log <https://video47.pitzer.edu/log>; (total 88
bytes);*
*Record lock, heap no 119 PHYSICAL RECORD: n_fields 6; compact format; info
bits 32*
* 0: len 30; hex
61396462353561352d656262372d343936302d613465652d356232363830; asc
a9db55a5-ebb7-4960-a4ee-5b2680; (total 36 bytes);*
* 1: len 18; hex 786672616d652d6c6173742d737461747573; asc
xframe-last-status;;*
* 2: len 6; hex 00000e8cc40f; asc ;;*
* 3: len 7; hex 3c000000352d12; asc < 5- ;;*
* 4: len 12; hex 43585f6d74675f3739353837; asc CX_mtg_79587;;*
* 5: len 5; hex 66616c7365; asc false;;*
*Record lock, heap no 120 PHYSICAL RECORD: n_fields 6; compact format; info
bits 32*
* 0: len 30; hex
61396462353561352d656262372d343936302d613465652d356232363830; asc
a9db55a5-ebb7-4960-a4ee-5b2680; (total 36 bytes);*
* 1: len 16; hex 786672616d652d6c6173742d74696d65; asc xframe-last-time;;*
* 2: len 6; hex 00000e8cc40f; asc ;;*
* 3: len 7; hex 3c000000352daa; asc < 5- ;;*
* 4: len 12; hex 43585f6d74675f3739353837; asc CX_mtg_79587;;*
* 5: len 13; hex 31343139323034333030363136; asc 1419204300616;;*
**** (2) WAITING FOR THIS LOCK TO BE GRANTED:*
*RECORD LOCKS space id 2496 page no 1129 n bits 200 index `PRIMARY` of
table `sakai`.`SAKAI_SITE_TOOL_PROPERTY` trx id E8CC40F lock mode S waiting*
*Record lock, heap no 118 PHYSICAL RECORD: n_fields 6; compact format; info
bits 32*
* 0: len 30; hex
61396462353561352d656262372d343936302d613465652d356232363830; asc
a9db55a5-ebb7-4960-a4ee-5b2680; (total 36 bytes);*
* 1: len 6; hex 736f75726365; asc source;;*
* 2: len 6; hex 00000e8cc40f; asc ;;*
* 3: len 7; hex 3c000000352c92; asc < 5, ;;*
* 4: len 12; hex 43585f6d74675f3739353837; asc CX_mtg_79587;;*
* 5: len 30; hex
68747470733a2f2f766964656f34372e7069747a65722e6564752f6c6f67; asc
https://video47.pitzer.edu/log <https://video47.pitzer.edu/log>; (total 88
bytes);*
**** WE ROLL BACK TRANSACTION (1)*
*------------*
*TRANSACTIONS*
*------------*
*Trx id counter E90146E*
*Purge done for trx's n:o < E901456 undo n:o < 0*
*History list length 2503*
*LIST OF TRANSACTIONS FOR EACH SESSION:*
*---TRANSACTION 0, not started*
*MySQL thread id 60244, OS thread handle 0x7fe076f3d700, query id
3084636294 localhost root*
*show engine innodb status*
*---TRANSACTION 0, not started*
*MySQL thread id 60242, OS thread handle 0x7fe075efd700, query id
3084628719 localhost 127.0.0.1 root*
*---TRANSACTION 0, not started*
*MySQL thread id 60241, OS thread handle 0x7fe077bae700, query id
3084632708 localhost 127.0.0.1 root*
*---TRANSACTION E900986, not started*
*MySQL thread id 60204, OS thread handle 0x7fe075d36700, query id
3084557547 sakai-tc1.pomona.edu <http://sakai-tc1.pomona.edu> 134.173.69.31
sakai*
*---TRANSACTION E901466, not started*
*MySQL thread id 60174, OS thread handle 0x7fe077aeb700, query id
3084636285 sakai-tc2.pomona.edu <http://sakai-tc2.pomona.edu> 134.173.69.32
sakai*
*---TRANSACTION E901467, not started*
*MySQL thread id 60129, OS thread handle 0x7fe077514700, query id
3084636279 sakai-tc3.pomona.edu <http://sakai-tc3.pomona.edu> 134.173.69.38
sakai*
*---TRANSACTION E900FBC, not started*
*MySQL thread id 60106, OS thread handle 0x7fe0846c0700, query id
3084613718 sakai-tc3.pomona.edu <http://sakai-tc3.pomona.edu> 134.173.69.38
sakai*
*---TRANSACTION E90146D, not started*
*MySQL thread id 59944, OS thread handle 0x7fe6b00c7700, query id
3084636293 sakai-tc3.pomona.edu <http://sakai-tc3.pomona.edu> 134.173.69.38
sakai*
*---TRANSACTION E90146C, ACTIVE 2 sec*
*MySQL thread id 60225, OS thread handle 0x7fe085066700, query id
3084636268 sakai-tc1.pomona.edu <http://sakai-tc1.pomona.edu> 134.173.69.31
sakai*
*---TRANSACTION E90146B, ACTIVE 2 sec*
*MySQL thread id 60049, OS thread handle 0x7fe085949700, query id
3084636256 sakai-sis.pomona.edu <http://sakai-sis.pomona.edu> 134.173.69.35
sakai*
*---TRANSACTION E90146A, ACTIVE 3 sec*
*MySQL thread id 60095, OS thread handle 0x7fe0850e8700, query id
3084636253 sakai-tc2.pomona.edu <http://sakai-tc2.pomona.edu> 134.173.69.32
sakai*
*---TRANSACTION E901469, ACTIVE 3 sec*
*MySQL thread id 60118, OS thread handle 0x7fe084477700, query id
3084636250 sakai-tc1.pomona.edu <http://sakai-tc1.pomona.edu> 134.173.69.31
sakai*
*---TRANSACTION E901398, ACTIVE 219 sec*
*MySQL thread id 60219, OS thread handle 0x7fe085a0c700, query id
3084632593 sakai-tc2.pomona.edu <http://sakai-tc2.pomona.edu> 134.173.69.32
sakai*
*---TRANSACTION E901388, ACTIVE 227 sec*
*MySQL thread id 60111, OS thread handle 0x7fe076df8700, query id
3084632060 sakai-tc3.pomona.edu <http://sakai-tc3.pomona.edu> 134.173.69.38
sakai*
*---TRANSACTION E90131E, ACTIVE 302 sec*
*MySQL thread id 59594, OS thread handle 0x7fe085804700, query id
3084629683 sakai-tc1.pomona.edu <http://sakai-tc1.pomona.edu> 134.173.69.31
sakai*
*---TRANSACTION E900FA7, ACTIVE 1114 sec*
*MySQL thread id 60109, OS thread handle 0x7fe08563d700, query id
3084615296 sakai-tc1.pomona.edu <http://sakai-tc1.pomona.edu> 134.173.69.31
sakai*
*---TRANSACTION E900D08, ACTIVE 1659 sec*
*MySQL thread id 60201, OS thread handle 0x7fe084373700, query id
3084575980 sakai-tc1.pomona.edu <http://sakai-tc1.pomona.edu> 134.173.69.31
sakai*
*---TRANSACTION E900BB4, ACTIVE 1908 sec*
*MySQL thread id 60176, OS thread handle 0x7fe08598a700, query id
3084635294 sakai-tc2.pomona.edu <http://sakai-tc2.pomona.edu> 134.173.69.32
sakai*
*---TRANSACTION E900A92, ACTIVE 1969 sec*
*MySQL thread id 60232, OS thread handle 0x7fe076556700, query id
3084566962 sakai-tc2.pomona.edu <http://sakai-tc2.pomona.edu> 134.173.69.32
sakai*
*---TRANSACTION E900988, ACTIVE 2134 sec*
*MySQL thread id 60230, OS thread handle 0x7fe076f7e700, query id
3084563401 sakai-tc1.pomona.edu <http://sakai-tc1.pomona.edu> 134.173.69.31
sakai*
*---TRANSACTION E900896, ACTIVE 2343 sec*
*MySQL thread id 60229, OS thread handle 0x7fe0757a0700, query id
3084607499 sakai-tc3.pomona.edu <http://sakai-tc3.pomona.edu> 134.173.69.38
sakai*
*---TRANSACTION E8FFAD3, ACTIVE 3292 sec*
*MySQL thread id 60213, OS thread handle 0x7fe07638f700, query id
3084632252 sakai-tc2.pomona.edu <http://sakai-tc2.pomona.edu> 134.173.69.32
sakai*
*--------*
*FILE I/O*
*--------*
We also find out Sakai bug report at the same time as follows:
stack trace:
java.lang.RuntimeException: SqlService.dbWrite failure
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1143)
caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`sakai`.`SAKAI_SITE_TOOL_PROPERTY`, CONSTRAINT
`SAKAI_SITE_TOOL_PROPERTY_ibfk_1` FOREIGN KEY (`TOOL_ID`) REFERENCES
`SAKAI_SITE_TOOL` (`TOOL_ID`))
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.sakaiproject.db.impl.BasicSqlService.dbWriteCount(BasicSqlService.java:1247)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1143)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1059)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.saveToolConfigTx(DbSiteService.java:425)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage$2.run(DbSiteService.java:406)
at
org.sakaiproject.db.impl.BasicSqlService.transact(BasicSqlService.java:334)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.saveToolConfig(DbSiteService.java:402)
at
org.sakaiproject.site.impl.BaseToolConfiguration.save(BaseToolConfiguration.java:535)
at
org.sakaiproject.portlets.PortletIFrame.popupXFrame(PortletIFrame.java:428)
at
org.sakaiproject.portlets.PortletIFrame.doView(PortletIFrame.java:340)
at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:247)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:175)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:208)
at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:139)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
at
org.apache.pluto.core.DefaultPortletInvokerService.invoke(DefaultPortletInvokerService.java:167)
at
org.apache.pluto.core.DefaultPortletInvokerService.render(DefaultPortletInvokerService.java:101)
at
org.apache.pluto.core.PortletContainerImpl.doRender(PortletContainerImpl.java:172)
at
org.sakaiproject.portal.render.portlet.PortletToolRenderService$Sakai168RenderResult.renderResponse(PortletToolRenderService.java:298)
at
org.sakaiproject.portal.render.portlet.PortletToolRenderService$Sakai168RenderResult.getContent(PortletToolRenderService.java:334)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.includeTool(SkinnableCharonPortal.java:726)
at
org.sakaiproject.portal.charon.handlers.PageHandler.includePage(PageHandler.java:229)
at
org.sakaiproject.portal.charon.handlers.WorksiteHandler.includeWorksite(WorksiteHandler.java:205)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:293)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:135)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:894)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:695)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Tool Placement:
: ID:sakai.iframe.site
: Context:CX_mtg_30566
: Title:Site Information Display
stack trace:
java.lang.RuntimeException: SqlService.dbWrite failure
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1143)
caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`sakai`.`SAKAI_SITE_TOOL_PROPERTY`, CONSTRAINT
`SAKAI_SITE_TOOL_PROPERTY_ibfk_1` FOREIGN KEY (`TOOL_ID`) REFERENCES
`SAKAI_SITE_TOOL` (`TOOL_ID`))
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.sakaiproject.db.impl.BasicSqlService.dbWriteCount(BasicSqlService.java:1247)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1143)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1059)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.saveToolConfigTx(DbSiteService.java:425)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage$2.run(DbSiteService.java:406)
at
org.sakaiproject.db.impl.BasicSqlService.transact(BasicSqlService.java:334)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.saveToolConfig(DbSiteService.java:402)
at
org.sakaiproject.site.impl.BaseToolConfiguration.save(BaseToolConfiguration.java:535)
at
org.sakaiproject.portlets.PortletIFrame.popupXFrame(PortletIFrame.java:428)
at
org.sakaiproject.portlets.PortletIFrame.doView(PortletIFrame.java:340)
at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:247)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:175)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:208)
at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:139)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
at
org.apache.pluto.core.DefaultPortletInvokerService.invoke(DefaultPortletInvokerService.java:167)
at
org.apache.pluto.core.DefaultPortletInvokerService.render(DefaultPortletInvokerService.java:101)
at
org.apache.pluto.core.PortletContainerImpl.doRender(PortletContainerImpl.java:172)
at
org.sakaiproject.portal.render.portlet.PortletToolRenderService$Sakai168RenderResult.renderResponse(PortletToolRenderService.java:298)
at
org.sakaiproject.portal.render.portlet.PortletToolRenderService$Sakai168RenderResult.getContent(PortletToolRenderService.java:334)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.includeTool(SkinnableCharonPortal.java:726)
at
org.sakaiproject.portal.charon.handlers.PageHandler.includePage(PageHandler.java:229)
at
org.sakaiproject.portal.charon.handlers.WorksiteHandler.includeWorksite(WorksiteHandler.java:205)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:293)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:135)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:894)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:695)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Tool Placement:
: ID:sakai.iframe.site
: Context:CX_mtg_30566
: Title:Site Information Display
I am wondering what may cause this issue and how to resolve it.
Any help would be greatly appreciated.
S
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20150107/a1ad51c1/attachment.html
More information about the sakai-dev
mailing list