Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-11125

CollectionAliasTest and ReorderedMappingsCollectionAliasTest hang on mysql55 and all postresql databases

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • EAP_EWP 5.3.0.ER3
    • Hibernate
    • None
    • hibernate annotations 3.4.0.GA_CP06
      mysql55
      postgresql*
      postgresqlplus92

    • NEW

    Description

      org.hibernate.test.collectionalias.CollectionAliasTest
      org.hibernate.test.collectionalias.ReorderedMappingsCollectionAliasTest

      CollectionAliasTest log:

      16:55:30,247  INFO Environment:592 - Hibernate 3.3.2.GA_CP06
      16:55:30,250  INFO Environment:610 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=com.mysql.jdbc.Driver, hibernate.connection.isolation=, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.format_sql=true, hibernate.query.substitutions=yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=dballo01, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:mysql://db01.mw.lab.eng.bos.redhat.com:3306/dballo01, hibernate.show_sql=true, hibernate.bytecode.use_reflection_optimizer=false, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
      16:55:30,251  INFO Environment:641 - using java.io streams to persist binary types
      16:55:30,251  INFO Environment:803 - Bytecode provider name : javassist
      16:55:30,255  INFO Environment:684 - using JDK 1.4 java.sql.Timestamp handling
      16:55:30,260  INFO Dialect:175 - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
      16:55:30,292  INFO Version:39 - Hibernate Annotations 3.4.0.GA_CP06
      16:55:30,334  INFO Version:14 - Hibernate Commons Annotations 3.1.0.GA
      16:55:30,341  INFO HibernateSearchEventListenerRegister:53 - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
      16:55:30,374  INFO AnnotationBinder:427 - Binding entity from annotated class: org.hibernate.test.collectionalias.TableB
      16:55:30,391  INFO EntityBinder:423 - Bind entity org.hibernate.test.collectionalias.TableB on table TableB
      16:55:30,434  INFO AnnotationBinder:427 - Binding entity from annotated class: org.hibernate.test.collectionalias.TableA
      16:55:30,435  INFO EntityBinder:423 - Bind entity org.hibernate.test.collectionalias.TableA on table TableA
      16:55:30,438  INFO AnnotationBinder:427 - Binding entity from annotated class: org.hibernate.test.collectionalias.ATable
      16:55:30,438  INFO EntityBinder:423 - Bind entity org.hibernate.test.collectionalias.ATable on table ATable
      16:55:30,466  INFO CollectionBinder:661 - Mapping collection: org.hibernate.test.collectionalias.ATable.tablebs -> TableB
      16:55:30,467  INFO AnnotationConfiguration:369 - Hibernate Validator not found: ignoring
      16:55:30,493  INFO DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!)
      16:55:30,494  INFO DriverManagerConnectionProvider:65 - Hibernate connection pool size: 1
      16:55:30,494  INFO DriverManagerConnectionProvider:68 - autocommit mode: false
      16:55:30,502  INFO DriverManagerConnectionProvider:103 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://db01.mw.lab.eng.bos.redhat.com:3306/dballo01
      16:55:30,503  INFO DriverManagerConnectionProvider:109 - connection properties: {user=dballo01, password=****}
      16:55:33,251  INFO SettingsFactory:115 - RDBMS: MySQL, version: 5.5.34
      16:55:33,251  INFO SettingsFactory:116 - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.23 ( Revision: ${bzr.revision-id} )
      16:55:33,272  INFO Dialect:175 - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
      16:55:33,276  INFO TransactionFactoryFactory:58 - Using default transaction strategy (direct JDBC transactions)
      16:55:33,277  INFO TransactionManagerLookupFactory:79 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
      16:55:33,277  INFO SettingsFactory:165 - Automatic flush during beforeCompletion(): disabled
      16:55:33,277  INFO SettingsFactory:169 - Automatic session close at end of transaction: disabled
      16:55:33,277  INFO SettingsFactory:176 - JDBC batch size: 15
      16:55:33,278  INFO SettingsFactory:179 - JDBC batch updates for versioned data: enabled
      16:55:33,278  INFO SettingsFactory:184 - Scrollable result sets: enabled
      16:55:33,278  INFO SettingsFactory:192 - JDBC3 getGeneratedKeys(): enabled
      16:55:33,279  INFO SettingsFactory:200 - Connection release mode: auto
      16:55:33,279  INFO SettingsFactory:224 - Maximum outer join fetch depth: 1
      16:55:33,279  INFO SettingsFactory:227 - Default batch fetch size: 1
      16:55:33,280  INFO SettingsFactory:231 - Generate SQL with comments: disabled
      16:55:33,280  INFO SettingsFactory:235 - Order SQL updates by primary key: disabled
      16:55:33,280  INFO SettingsFactory:239 - Order SQL inserts for batching: disabled
      16:55:33,280  INFO SettingsFactory:402 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      16:55:33,282  INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
      16:55:33,282  INFO SettingsFactory:247 - Query language substitutions: {yes='Y', no='N'}
      16:55:33,282  INFO SettingsFactory:252 - JPA-QL strict compliance: disabled
      16:55:33,283  INFO SettingsFactory:257 - Second-level cache: enabled
      16:55:33,283  INFO SettingsFactory:261 - Query cache: disabled
      16:55:33,284  INFO SettingsFactory:387 - Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
      16:55:33,286  INFO RegionFactoryCacheProviderBridge:60 - Cache provider: org.hibernate.cache.HashtableCacheProvider
      16:55:33,286  INFO SettingsFactory:271 - Optimize cache for minimal puts: disabled
      16:55:33,287  INFO SettingsFactory:276 - Cache region prefix: hibernate.test
      16:55:33,287  INFO SettingsFactory:280 - Structured second-level cache entries: disabled
      16:55:33,290  INFO SettingsFactory:300 - Echoing all SQL to stdout
      16:55:33,291  INFO SettingsFactory:309 - Statistics: disabled
      16:55:33,291  INFO SettingsFactory:313 - Deleted entity synthetic identifier rollback: disabled
      16:55:33,292  INFO SettingsFactory:328 - Default entity-mode: pojo
      16:55:33,292  INFO SettingsFactory:332 - Named query checking : enabled
      16:55:33,303  INFO SessionFactoryImpl:194 - building session factory
      16:55:33,390  INFO SessionFactoryObjectFactory:104 - Not binding factory to JNDI, no JNDI name configured
      16:55:33,394  INFO SchemaExport:229 - Running hbm2ddl schema export
      16:55:33,394 DEBUG SchemaExport:245 - import file not found: /import.sql
      16:55:33,395  INFO SchemaExport:254 - exporting generated schema to database
      16:55:33,777 DEBUG SchemaExport:380 - 
          alter table TableB 
              drop 
              foreign key FK94DC2A54205D98F0
      16:55:34,139 DEBUG SchemaExport:365 - Unsuccessful: alter table TableB drop foreign key FK94DC2A54205D98F0
      16:55:34,140 DEBUG SchemaExport:366 - Error on rename of './dballo01/tableb' to './dballo01/#sql2-1012-2a7d5' (errno: 152)
      16:55:34,140 DEBUG SchemaExport:380 - 
          drop table if exists ATable
      16:55:34,528 DEBUG SchemaExport:380 - 
          drop table if exists TableA
      16:55:34,916 DEBUG SchemaExport:380 - 
          drop table if exists TableB
      16:55:35,320 DEBUG SchemaExport:380 - 
          create table ATable (
              idcolumn integer not null,
              primary key (idcolumn)
          ) ENGINE=InnoDB
      16:55:35,737 DEBUG SchemaExport:380 - 
          create table TableA (
              id integer not null,
              test varchar(255),
              test2 varchar(255),
              primary key (id)
          ) ENGINE=InnoDB
      16:55:36,157 DEBUG SchemaExport:380 - 
          create table TableB (
              idcolumn integer not null,
              idcolumn_second varchar(50) not null,
              thirdcolumn varchar(20) not null,
              primary key (idcolumn, idcolumn_second, thirdcolumn)
          ) ENGINE=InnoDB
      16:55:36,590 DEBUG SchemaExport:380 - 
          alter table TableB 
              add index FK94DC2A54205D98F0 (idcolumn), 
              add constraint FK94DC2A54205D98F0 
              foreign key (idcolumn) 
              references ATable (idcolumn)
      16:55:37,036  INFO SchemaExport:271 - schema export complete
      16:55:37,264 DEBUG SQL:111 - 
          select
              tableb_.idcolumn,
              tableb_.idcolumn_second,
              tableb_.thirdcolumn 
          from
              TableB tableb_ 
          where
              tableb_.idcolumn=? 
              and tableb_.idcolumn_second=? 
              and tableb_.thirdcolumn=?
      Hibernate: 
          select
              tableb_.idcolumn,
              tableb_.idcolumn_second,
              tableb_.thirdcolumn 
          from
              TableB tableb_ 
      
      

      Attachments

        Issue Links

          Activity

            People

              brmeyer_jira Brett Meyer (Inactive)
              msimka@redhat.com Martin Simka
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: