Re: users are dropped from mysql
"Lucy Mendel" <lucy-u2YUQdb6EcYUNg8y/[email protected]> Thu, 3 Apr 2008 12:33:56 -0400
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Message-ID | <[email protected]> |
The solution is tried worked:
I added a new user with the same information as before (probably
didn't matter that the information was the same).
and then updated the mysql table directly to make this new user's id
match the deleted user's id (good thing i remembered it! it is also in
the error message)
good as new.
Another administrator had deleted a project he was on
(acceptor/tracker/customer). two other users, including the deleted
user were also on that project. many users were editors. Not usre if
this caused the problem, but we're going to stop deleting projects
from now on. if I figure more out on my dev install i'll let ya'll
know.
Thanks,
Lucy.
On Wed, Apr 2, 2008 at 3:17 PM, Lucy Mendel <lucy-u2YUQdb6EcYUNg8y/[email protected]> wrote:
> 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