Re: users are dropped from mysql
"Lucy Mendel" <lucy-u2YUQdb6EcYUNg8y/[email protected]> Wed, 2 Apr 2008 15:17:12 -0400
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Message-ID | <[email protected]> |
btw - The first time a user was deleted (which I shrugged off as 'setup' issues) was with tomcat5.0 and java 1.4.2. When I upgraded those two I simply used the same mysql database. On Wed, Apr 2, 2008 at 3:09 PM, Lucy Mendel <lucy-u2YUQdb6EcYUNg8y/[email protected]> wrote: > 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