users are dropped from mysql
"Lucy Mendel" <lucy-u2YUQdb6EcYUNg8y/[email protected]> Wed, 2 Apr 2008 15:08:19 -0400
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Message-ID | <[email protected]> |
yo,
I have this problem where users are being deleted for some unknown
reason. When I run mysql and do
use xplanner;
select * from person;
I don't see a user who I know has been using the system for a few weeks now.
When I go to an iteration page that contains tasks accepted by that
person (and perhaps they were customers of stories in that iteration),
I get a lazily failed error, no doubt due to not finding that person
in the database.
Yikes!
Any ideas why this occurred and what I can do about it? I want to lose
as little information as possible!
This happened when I first setup xplanner, but I shrugged it off as my
just being confused. Now I am certain there is a problem. The user
removed was my administrator account (not sysadmin).
Thanks,
Lucy.
http://64.22.103.24:8080/xplanner/do/view/iteration?projectId=0&returnto=%2Fdo%2Fview%2Fprojects&oid=1102
Cause
net.sf.hibernate.LazyInitializationException: Failed to lazily
initialize a collection
[hide] Stack Trace
net.sf.hibernate.LazyInitializationException: Failed to lazily
initialize a collection
at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:201)
at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71)
at net.sf.hibernate.collection.Set.isEmpty(Set.java:114)
at com.technoetic.xplanner.util.CollectionUtils.sum(CollectionUtils.java:10)
at com.technoetic.xplanner.domain.Iteration.getSumOfStoryProperty(Iteration.java:257)
at com.technoetic.xplanner.domain.Iteration.getCachedActualHours(Iteration.java:83)
at org.apache.jsp.WEB_002dINF.jsp.view.iterationProgress_jsp._jspService(iterationProgress_jsp.java:90)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:584)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:497)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.WEB_002dINF.jsp.view.iteration_jsp._jspx_meth_tiles_005fput_005f4(iteration_jsp.java:1430)
at org.apache.jsp.WEB_002dINF.jsp.view.iteration_jsp._jspService(iteration_jsp.java:223)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:320)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
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(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.technoetic.xplanner.filters.RequestCharacterEncodingFilter.doFilter(RequestCharacterEncodingFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.technoetic.xplanner.security.filter.AbstractSecurityFilter.doFilter(AbstractSecurityFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.technoetic.xplanner.filters.ServletRequestFilter.doFilter(ServletRequestFilter.java:24)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.technoetic.xplanner.db.hibernate.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.technoetic.xplanner.filters.ActivityLogFilter.doFilter(ActivityLogFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: net.sf.hibernate.UnresolvableObjectException: No row with
the given identifier exists: 232, of class:
com.technoetic.xplanner.domain.Person
at net.sf.hibernate.UnresolvableObjectException.throwIfNull(UnresolvableObjectException.java:38)
at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1964)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:69)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:208)
at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:2219)
at net.sf.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:319)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:309)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995)
at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93)
at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288)
at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315)
at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195)
... 74 more
System Environment
[hide] Build
* Version: 0.7b7
* Build Date: 05/24/2006
* Build Revision: 1149
* Build Package: War
[hide] Database
* Dialect: com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect
* Driver: com.mysql.jdbc.Driver
* Driver Version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17
15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
* Database Vendor: MySQL
* Database Version: 4.1.22-standard
* Database Name: xplanner
* Database Url: jdbc:mysql://localhost/xplanner
* Database User Name: xplanner
* Database User Password: ******
* Database Patch Level: 14
[hide] App Server
* Application Server: Apache Tomcat/5.5.26
* Servlet Version: 2.4
[hide] Memory
* Total Memory: 63MB
* Free Memory: 7MB
* Used Memory: 56MB
[hide] System
* System Date: Apr 2, 2008
* System Time: 2:56:22 PM
* Current directory: /usr/local/tomcat55/apache-tomcat-5.5.26/bin
* Java Version: 1.5.0_15
* Java Vendor: Sun Microsystems Inc.
* JVM Version: 1.0
* JVM Vendor: Sun Microsystems Inc.
* JVM Implementation Version: 1.5.0_15-b04
* Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
* Java VM: Java HotSpot(TM) Client VM
* User Name: lucy
* User Timezone: America/New_York
* Operating System: Linux 2.6.18.8-domU-linode7
* OS Architecture: i386
Request Information
[hide] General
* Referer URL: http://64.22.103.24:8080/xplanner/do/view/projects
* Locale: en_US
* URL:
o Scheme: http
o Server: 64.22.103.24
o Port: 8080
o URI: /xplanner/WEB-INF/jsp/common/unexpectedError.jsp
+ Context Path: /xplanner
+ Servlet Path: /WEB-INF/jsp/common/unexpectedError.jsp
+ Path Info:
+ Query String:
projectId=0&returnto=%2Fdo%2Fview%2Fprojects&oid=1102
[hide] Parameters
* oid: 1102
* projectId: 0
* returnto: /do/view/projects
[hide] Attributes
* OpenSessionInViewFilter.FILTERED: true
* domainContext: com.technoetic.xplanner.tags.DomainContext@e94afa
* iteration: Iteration{id='1102, projectId='1049, name='Crow'}
* javax.servlet.error.exception:
net.sf.hibernate.LazyInitializationException: Failed to lazily
initialize a collection
* javax.servlet.error.exception_type: class
net.sf.hibernate.LazyInitializationException
* javax.servlet.error.message: Failed to lazily initialize a collection
* javax.servlet.error.request_uri: /xplanner/do/view/iteration
* javax.servlet.error.servlet_name: XPlannerServlet
* javax.servlet.error.status_code: 500
* javax.servlet.forward.context_path: /xplanner
* javax.servlet.forward.path_info: /WEB-INF/jsp/common/unexpectedError.jsp
* javax.servlet.forward.query_string:
projectId=0&returnto=%2Fdo%2Fview%2Fprojects&oid=1102
* javax.servlet.forward.request_uri: /xplanner/do/view/iteration
* javax.servlet.forward.servlet_path: /do
* org.apache.struts.action.MESSAGE:
org.apache.struts.util.PropertyMessageResources@630e23
* org.apache.struts.action.MODULE:
org.apache.struts.config.impl.ModuleConfigImpl@12dfb78
* org.apache.struts.action.mapping.instance:
ActionConfig[path=/view/iteration,scope=session,type=com.technoetic.xplanner.actions.ViewObjectAction
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace