click here for details... Sakai Executive Director Position Search now open
Issue Details (XML | Word | Printable)

Key: SAK-14939
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Carl Hall
Reporter: Sean Keesler
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Sakai

BasicSQLService error when creating sites

Created: 20-Nov-2008 11:39   Updated: 27-Oct-2009 13:39
Component/s: Content service (Pre-K1/2.6)
Affects Version/s: 2.6.0
Fix Version/s: 2.6.0, 2.7.0

Time Tracking:
Not Specified

File Attachments: 1. File sak-14939.diff (0.5 kB)
2. File sak-14939_oracle.diff (0.6 kB)
Environment: Ubuntu 8.10 HSQLDB
Issue Links:
Duplicate
 
Incorporate
 
Relate
 

2.6.x Status: Closed
2.5.x Status: None
2.4.x Status: None


 Description  « Hide
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)


 All   Comments   Work Log   Change History   Subversion Commits   git Commits      Sort Order: Ascending order - Click to sort in descending order
[ Permlink | « Hide ]
James Sloane added a comment - 20-Nov-2008 15:38
I'm seeing similar errors on QA1-AU and nightly2 ( http://nightly2.sakaiproject.org/logs/tomcat-nightly-oracle/catalina.out ) and found this jira that mentions this problem. http://bugs.sakaiproject.org/jira/browse/SAK-7670?focusedCommentId=64809#action_64809

There seems to be problems with this table on HSQLDB and Oracle.

[ Permlink | « Hide ]
Peter A. Knoop added a comment - 09-Dec-2008 13:32
Carl, sounds like this is related to the work you did on delayed notification. Can you give it a look? Thanks.

[ Permlink | « Hide ]
Carl Hall added a comment - 10-Dec-2008 10:58
SQL for HSQLDB was missing a comma between the last column def and the primary key. Patched attached to correct the issue.

[ Permlink | « Hide ]
Jean-François Lévêque added a comment - 11-Dec-2008 01:20
Your patch has not been commited to trunk yet, Carl.

[ Permlink | « Hide ]
Jean-François Lévêque added a comment - 11-Dec-2008 03:09
What about the Oracle part?

[ Permlink | « Hide ]
Carl Hall added a comment - 11-Dec-2008 05:33
Sorry, didn't realize there was an issue with the Oracle SQL, too. Adjusted the Oracle SQL and attached patch to fix it. MySql SQL has been tested and verified. I don't have access to MS SQL to verify the SQL for it.

[ Permlink | « Hide ]
Carl Hall added a comment - 11-Dec-2008 05:38
Patches attached that correct HSQLDB and Oracle. I don't have commit access to trunk so I'll have to rely on the branch maintainers to push these in. Thanks.

[ Permlink | « Hide ]
Zhen Qian added a comment - 11-Dec-2008 06:35
I changed the affected component from "Worksite Setup" to "Content" because of Carl's solution.

Thanks,

- Zhen

[ Permlink | « Hide ]
Stephen Marquard added a comment - 12-Dec-2008 01:51
Committed patches in r55207.

Needs to verified on trunk Oracle and HSQL instances on nightly2 (and examine tomcat logs to see that there are no errors).
Powered by a free Atlassian JIRA open source license for Sakai Foundation. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators