If you are using MySQL 5.0.27 this is caused by a bug in that version. Either use an older version of MySQL or remove 'useCursorFetch=true' the db.url setting in your base.config file. The second option may give you out-of-memory problems if you have a large database. In that case, you must either get more memory or use an older MySQL version.
For more info see: http://base.thep.lu.se/ticket/568 /Nicklas Bernd Schwendele wrote: > Hi, > > I want to migrate an old BASE installation (1.2) to an newer one (2) > on another machine/arch. During the run of migrate_from_1.2.sh there > are many exceptions, e.g. > > 17:50:28,656 ERROR migration:85 - getSampleById > net.sf.basedb.core.BaseException: could not load an entity: > [net.sf.basedb.core.data.SampleData#2] at > net.sf.basedb.core.HibernateUtil.loadData(HibernateUtil.java:1063) at > net.sf.basedb.core.DbControl.loadItem(DbControl.java:681) at > net.sf.basedb.core.Sample.getById(Sample.java:88) at > net.sf.basedb.clients.migrate.SampleTransfer.getSampleById(SampleTransfer.java:143) > at > net.sf.basedb.clients.migrate.ExtractTransfer.createItem(ExtractTransfer.java:90) > at > net.sf.basedb.clients.migrate.ExtractTransfer.createItem(ExtractTransfer.java:44) > at net.sf.basedb.clients.migrate.Transfer.run(Transfer.java:346) at > net.sf.basedb.clients.migrate.ExtractTransfer.start(ExtractTransfer.java:70) > at > net.sf.basedb.clients.migrate.Migrater.startTransfer(Migrater.java:218) > at net.sf.basedb.clients.migrate.Migrater.run(Migrater.java:125) at > net.sf.basedb.clients.migrate.Migrater.main(Migrater.java:478) Caused > by: org.hibernate.exception.DataException: could not load an entity: > [net.sf.basedb.core.data.SampleData#2] at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) > at org.hibernate.loader.Loader.loadEntity(Loader.java:1865) at > org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) > at > org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) > at > org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3038) > at > org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395) > at > org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) > at > org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) > at > org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179) > at > org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) > at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at > org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) at > org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) at > net.sf.basedb.core.HibernateUtil.loadData(HibernateUtil.java:1059) > ... 10 more Caused by: com.mysql.jdbc.exceptions.MySQLDataException: > '8589934593' in column '15' is outside valid range for the datatype > INTEGER. at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:893) at > com.mysql.jdbc.ResultSet.throwRangeException(ResultSet.java:7391) at > com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3967) at > com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3892) at > com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2555) at > com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2570) at > com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2573) > at org.hibernate.type.IntegerType.get(IntegerType.java:28) at > org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163) at > org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154) at > org.hibernate.type.AbstractType.hydrate(AbstractType.java:81) at > org.hibernate.type.ComponentType.hydrate(ComponentType.java:560) at > org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:275) > at > org.hibernate.type.SpecialOneToOneType.hydrate(SpecialOneToOneType.java:58) > at > org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2092) > at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1371) > at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1299) > at org.hibernate.loader.Loader.getRow(Loader.java:1197) at > org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:568) at > org.hibernate.loader.Loader.doQuery(Loader.java:689) at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) > at org.hibernate.loader.Loader.loadEntity(Loader.java:1851) ... 22 > more > > Is there a bug in the migrate-Tool? Regards Bernd > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express Download DB2 Express C > - the FREE version of DB2 express and take control of your XML. No > limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ The BASE general > discussion mailing list basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]