From continuum-users-return-5148-apmail-maven-continuum-users-archive=maven.apache.org@maven.apache.org Fri Nov 02 15:05:59 2007 Return-Path: Delivered-To: apmail-maven-continuum-users-archive@www.apache.org Received: (qmail 14792 invoked from network); 2 Nov 2007 15:05:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Nov 2007 15:05:59 -0000 Received: (qmail 59227 invoked by uid 500); 2 Nov 2007 15:05:46 -0000 Delivered-To: apmail-maven-continuum-users-archive@maven.apache.org Received: (qmail 58777 invoked by uid 500); 2 Nov 2007 15:05:45 -0000 Mailing-List: contact continuum-users-help@maven.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: continuum-users@maven.apache.org Delivered-To: mailing list continuum-users@maven.apache.org Received: (qmail 58766 invoked by uid 99); 2 Nov 2007 15:05:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Nov 2007 08:05:45 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [80.168.101.19] (HELO relay01-mail.uk.clara.net) (80.168.101.19) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Nov 2007 15:06:07 +0000 Received: from chb28-2-88-163-39-128.fbx.proxad.net ([88.163.39.128]:45303 helo=[127.0.0.1]) by relay01-mail.uk.clara.net (smtp-vh.amenworld.com [195.8.80.31]:251) with esmtpa (authdaemon_plain:emmanuel@venisse.net) id 1Iny5O-0003bL-4C (Exim 4.60) for continuum-users@maven.apache.org (return-path ); Fri, 02 Nov 2007 15:05:26 +0000 Message-ID: <472B3D22.9070609@venisse.net> Date: Fri, 02 Nov 2007 16:07:14 +0100 From: Emmanuel Venisse User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: continuum-users@maven.apache.org Subject: Re: Migration from beta-3 to beta-4 problem References: <47299AFF.9010903@venisse.net> <472B1FDD.9020908@venisse.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org Maybe you can delete all datas in the DB with some sql requests. Emmanuel Thomas Recloux a écrit : > Yes, it has just been initialized by the first start. > > > 2007/11/2, Emmanuel Venisse : >> ok, but the jdbc url for the import use a clean db? >> >> Emmanuel >> >> Thomas Recloux a écrit : >>> No, I exported from a beta-3 to a new beta-4 >>> >>> 2007/11/1, Emmanuel Venisse : >>>> Do you run Export and Import on the same database? >>>> >>>> Emmanuel >>>> >>>> Thomas Recloux a écrit : >>>>> Hi, >>>>> >>>>> I have got the following error during the builds import with the >>>> migration >>>>> tool. >>>>> >>>>> It looks like the migration tool tries to delete 'BUILDDEFINITION' >>>> entries >>>>> but a child entry blocks the statement. >>>>> If you give me the child table, I could delete it manually. >>>>> >>>>> I do not undestand why the BUILDDEFINITION table is not empty. >>>>> >>>>> Thanks, Thomas >>>>> >>>>> ERROR 23503: DELETE on table 'BUILDDEFINITION' caused a violation of >>>> foreign >>>>> key constraint 'BUILDDEFINITCE_FK2' for key (3). The statement has >> been >>>>> rolled back. >>>>> at org.apache.derby.iapi.error.StandardException.newException >>>> (Unknown >>>>> Source) >>>>> at >>>> org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck >> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck >>>> (Unknown >>>>> Source) >>>>> at >>>>> org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.DeleteResultSet.open >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.GenericPreparedStatement.execute >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement >>>> (Unknown >>>>> Source) >>>>> at >>>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement >>>> (Unknown >>>>> Source) >>>>> at >>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown >>>>> Source) >>>>> at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate( >>>>> RDBMSManager.java:572) >>>>> at org.jpox.store.rdbms.request.DeleteRequest.execute( >>>>> DeleteRequest.java:274) >>>>> at org.jpox.store.rdbms.table.ClassTable.delete( >> ClassTable.java >>>>> :2611) >>>>> at org.jpox.store.StoreManager.delete(StoreManager.java:981) >>>>> at org.jpox.state.StateManagerImpl.internalDeletePersistent( >>>>> StateManagerImpl.java:4395) >>>>> at org.jpox.state.StateManagerImpl.deletePersistent( >>>>> StateManagerImpl.java:4350) >>>>> at >> org.jpox.AbstractPersistenceManager.internalDeletePersistent( >>>>> AbstractPersistenceManager.java:1473) >>>>> at org.jpox.AbstractPersistenceManager.deletePersistentAll( >>>>> AbstractPersistenceManager.java:1516) >>>>> at org.jpox.store.rdbms.scostore.ElementContainerStore.clear( >>>>> ElementContainerStore.java:659) >>>>> at org.jpox.store.mapping.CollectionMapping.deleteDependent( >>>>> CollectionMapping.java:334) >>>>> at org.jpox.store.rdbms.table.ClassTable.deleteDependent( >>>>> ClassTable.java:2651) >>>>> at org.jpox.store.StoreManager.deleteDependent( >> StoreManager.java >>>>> :1019) >>>>> at org.jpox.state.StateManagerImpl.deletePersistent( >>>>> StateManagerImpl.java:4332) >>>>> at >> org.jpox.AbstractPersistenceManager.internalDeletePersistent( >>>>> AbstractPersistenceManager.java:1473) >>>>> at org.jpox.AbstractPersistenceManager.deletePersistentAll( >>>>> AbstractPersistenceManager.java:1516) >>>>> at >>>> org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll( >>>>> JDOQLQuery.java:687) >>>>> at org.jpox.store.query.Query.deletePersistentAll(Query.java >>>> :1120) >>>>> at org.jpox.store.query.Query.deletePersistentAll(Query.java >>>> :1075) >>>>> at org.jpox.store.query.Query.deletePersistentAll(Query.java >>>> :1049) >>>>> at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll( >>>>> PlexusJdoUtils.java:444) >>>>> at >>>> org.apache.maven.continuum.store.JdoContinuumStore.eraseDatabase( >>>>> JdoContinuumStore.java:1961) >>>>> at >>>>> >> org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase( >>>>> JdoDataManagementTool.java:127) >>>>> at >>>>> >> org.apache.maven.continuum.management.DataManagementCli.processDatabase( >>>>> DataManagementCli.java:254) >>>>> at >> org.apache.maven.continuum.management.DataManagementCli.main( >>>>> DataManagementCli.java:158) >>>>> >>>>> >>> >> > >