Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-14939

BasicSQLService error when creating sites

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.6.0
    • Fix Version/s: 2.6.0, 2.7.0
    • Labels:
      None
    • Environment:
      Ubuntu 8.10 HSQLDB

      Description

      I grabbed a copy of the source and deployed locally with HSQLDB on a
      Ubuntu box. I noticed the following the error in the logs when I click
      "Create Site" in Worksite Setup. It doesn't always pop up when I create a
      site, but tends to come up more often when I am creating a site with a
      lot of tools....

      12:58:41,729 WARN BasicSqlService.java:583 BasicSqlService:583 -
      Sql.dbRead: sql: select EVENT_DELAY_ID from SAKAI_EVENT_DELAY where
      RESOURCE = ? and EVENT = ? /content/private/sampleAccess/mercury/
      content.new
      java.sql.SQLException: Table not found in statement [select
      EVENT_DELAY_ID from SAKAI_EVENT_DELAY where RESOURCE = ? and EVENT = ?]
      at org.hsqldb.jdbc.Util.throwError(Unknown Source)
      at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      at
      org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
      at
      org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
      at
      org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
      at
      org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:464)
      at
      org.sakaiproject.content.providers.BaseEventDelayHandler.findDelayIds(BaseEventDelayHandler.java:149)
      at
      org.sakaiproject.content.providers.BaseEventDelayHandler.deleteDelay(BaseEventDelayHandler.java:235)
      at
      org.sakaiproject.event.impl.BaseEventTrackingService.cancelDelays(BaseEventTrackingService.java:362)
      at
      org.sakaiproject.event.cover.EventTrackingService.cancelDelays(EventTrackingService.java:155)
      at
      org.sakaiproject.content.impl.BaseContentService.commitCollection(BaseContentService.java:2696)
      at
      org.sakaiproject.sample.impl.SampleImplAccess.assureCollection(SampleImplAccess.java:295)
      at
      org.sakaiproject.sample.impl.SampleImplAccess.init(SampleImplAccess.java:355)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at
      org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1240)
      at
      org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1205)
      at
      org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
      at
      org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
      at
      org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
      at
      org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
      at
      org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
      at
      org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
      at
      org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
      at
      org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:74)
      at
      org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
      at
      org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:146)
      at
      org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:68)
      at
      org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:76)
      at
      org.sakaiproject.tool.cover.ActiveToolManager.getInstance(ActiveToolManager.java:53)
      at
      org.sakaiproject.tool.cover.ActiveToolManager.register(ActiveToolManager.java:130)
      at
      org.sakaiproject.util.ToolListener.contextInitialized(ToolListener.java:62)
      at
      org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
      at
      org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
      at
      org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
      at
      org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
      at
      org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
      at
      org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:831)
      at
      org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:720)
      at
      org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
      at
      org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
      at
      org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
      at
      org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
      at
      org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
      at
      org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
      at
      org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
      at
      org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      at
      org.apache.catalina.core.StandardService.start(StandardService.java:448)
      at
      org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  thecarlhall Carl Hall (Inactive)
                  Reporter:
                  smkeesle Sean Keesler (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code