History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: SAK-12028
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Blocker Blocker
Assignee: John Ellis
Reporter: Daniel Parry
Votes: 0
Watchers: 0
Operations

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

QA1-uk startup often fails

Created: 23-Oct-2007 09:23   Updated: 23-Oct-2008 06:29
Component/s: Reports
Affects Version/s: 2.5.0
Fix Version/s: 2.5.0

Time Tracking:
Not Specified

Environment: MySQL 5.0.37 and mysql 5 connector, query cache enabled

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


 Description  « Hide
qa1-uk often, but not always fails on start up with:

INFO: Loaded Default Cache [ name = org.sakaiproject.news.api.NewsService.cache status = STATUS_ALIVE eternal = false overflowToDisk = false m
axElementsInMemory = 10000 maxElementsOnDisk = 0 memoryStoreEvictionPolicy = LRU timeToLiveSeconds = 300 timeToIdleSeconds = 300 diskPersisten
t = false diskExpiryThreadIntervalSeconds = 120 cacheEventListeners: hitCount = 0 memoryStoreHitCount = 0 diskStoreHitCount = 0 missCountNotFo
und = 0 missCountExpired = 0 ] (2007-10-23 17:11:24,674 main_org.sakaiproject.memory.impl.BasicMemoryService)
INFO: init() (2007-10-23 17:11:24,818 main_org.sakaiproject.presence.impl.BasePresenceService)
INFO: init() (2007-10-23 17:11:24,835 main_org.sakaiproject.component.app.profile.ProfileManagerImpl)
INFO: init() ReportsManagerImpl (2007-10-23 17:11:24,871 main_org.sakaiproject.reports.logic.impl.ReportsManagerImpl)
Compiler warnings:
jar:file:/home/qa1-uk/sakai_2-5-0_QA_010/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproje
ct/reports/conversion/: line 13: Attribute 'class' outside of element.
jar:file:/home/qa1-uk/sakai_2-5-0_QA_010/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproje
ct/reports/conversion/: line 23: Attribute 'class' outside of element.
jar:file:/home/qa1-uk/sakai_2-5-0_QA_010/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproje
ct/reports/conversion/: line 33: Attribute 'class' outside of element.
jar:file:/home/qa1-uk/sakai_2-5-0_QA_010/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproje
ct/reports/conversion/: line 43: Attribute 'bean' outside of element.
WARN: SQL Error: 1205, SQLState: 41000 (2007-10-23 17:12:18,982 main_org.hibernate.util.JDBCExceptionReporter)
ERROR: Lock wait timeout exceeded; try restarting transaction (2007-10-23 17:12:18,982 main_org.hibernate.util.JDBCExceptionReporter)
ERROR: Could not synchronize database state with session (2007-10-23 17:12:18,984 main_org.hibernate.event.def.AbstractFlushingEventListener)
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:686)
at org.sakaiproject.reports.logic.impl.ReportsManagerImpl.updateDefinition(ReportsManagerImpl.java:1697)
at org.sakaiproject.reports.logic.impl.ReportsManagerImpl.processDefinedDefinition(ReportsManagerImpl.java:1667)
at org.sakaiproject.reports.logic.impl.ReportsManagerImpl.initDefinedReportDefinitions(ReportsManagerImpl.java:1588)
at org.sakaiproject.reports.logic.impl.ReportsManagerImpl.init(ReportsManagerImpl.java:227)
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)

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
John Ellis - 30-Oct-2007 11:48
moved around the init so that it would be involved in the right tx.

Daniel Parry - 01-Nov-2007 07:04
Still seeing this behaviour in tag 11, but guess the fix may have not made that tag, so won't reopen at this point...

John Ellis - 01-Nov-2007 07:11
i think i just missed the tag cutoff when checking in.

Megan May - 01-Nov-2007 12:50
merged into 2.5.x

Megan May - 07-Nov-2007 09:30
Changing fix version to 2.5.0.013 as these JIRA are included in the latest tag

Daniel Parry - 08-Nov-2007 09:54
Still seeing:
Compiler warnings:
jar:file:/home/qa1-uk/sakai_2-5-0_QA_013/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproject/reports/conversion/: line 13: Attribute 'class' outside of element.
jar:file:/home/qa1-uk/sakai_2-5-0_QA_013/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproject/reports/conversion/: line 23: Attribute 'class' outside of element.
jar:file:/home/qa1-uk/sakai_2-5-0_QA_013/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproject/reports/conversion/: line 33: Attribute 'class' outside of element.
jar:file:/home/qa1-uk/sakai_2-5-0_QA_013/components/sakai-reports-components/WEB-INF/lib/sakai-reports-component-shared-M2.jar!/org/sakaiproject/reports/conversion/: line 43: Attribute 'bean' outside of element.

on startup. Should I be?

John Ellis - 08-Nov-2007 10:57
yeah... those are fine... i'm not sure why the xslt compiler is complaining about those, but the conversion is working fine.

Megan May - 08-Nov-2007 11:24
Perhaps creating a different, lower priority JIRA for these warnings would be a good idea?

Peter A. Knoop - 29-Feb-2008 09:41
Verified by subsequent start-ups during QA cycle going okay.