Re: users are dropped from mysql
"Lucy Mendel" <lucy-u2YUQdb6EcYUNg8y/[email protected]> Wed, 2 Apr 2008 15:09:40 -0400
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Message-ID | <[email protected]> |
Tomcat Version JVM Version JVM Vendor OS Name OS Version OS Architecture Apache Tomcat/5.5.26 1.5.0_15-b04 Sun Microsystems Inc. Linux 2.6.18.8-domU-linode7 i386 xplanner 0.7b7 On Wed, Apr 2, 2008 at 3:08 PM, Lucy Mendel <lucy-u2YUQdb6EcYUNg8y/[email protected]> wrote: > 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