Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 900451 (JBPAPP6-954)

Summary: SQLServerDialectTest.testMaxResultsSqlServerWithCaseSensitiveCollation fails on mssql2008R1 and mssql2008R2 due to Lock request TimeOut period exceeded
Product: [JBoss] JBoss Enterprise Application Platform 6 Reporter: Madhumita Sadhukhan <msadhukh>
Component: HibernateAssignee: Strong Liu <stliu>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0CC: msadhukh, pslavice, zroubali
Target Milestone: ---   
Target Release: EAP 6.0.1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/JBPAPP6-954
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-10-04 09:34:20 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 900436    
Bug Blocks: 900612    

Description Madhumita Sadhukhan 2012-05-16 20:35:30 UTC 
project_key: JBPAPP6

https://hudson.qa.jboss.com/hudson/view/EAP6/view/EAP6-Hibernate/job/eap6-hibernate-core-master-testsuite-testDB2Sybase/43/database=mssql2008R2,jdk=java16_default,label=hibernate/testReport/junit/org.hibernate.test.dialect.functional/SQLServerDialectTest/testMaxResultsSqlServerWithCaseSensitiveCollation/

SQLServerDialectTest.testMaxResultsSqlServerWithCaseSensitiveCollation fails on mssql2008R1 and mssql2008R2 with following stacktrace:

org.hibernate.hql.internal.ast.QuerySyntaxException: Product is not mapped [from Product where description like 'Kit%']
	at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)
	at org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
	at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93)
	at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:324)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3270)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3159)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)...........
...........................................................................................................................


Query failing:

- select id from Product2 with (updlock, rowlock, nowait) where id =?
08:38:09,174  WARN SqlExceptionHelper:143 - SQL Error: 1222, SQLState: S00051
08:38:09,175 ERROR SqlExceptionHelper:144 - Lock request time out period exceeded.

This testcase failure is causing the database collation to be modified permanently causing further testsuite failures for case sensitive collation on these databases
Comment 1 Madhumita Sadhukhan 2012-05-16 20:41:08 UTC 
https://hibernate.onjira.com/browse/HHH-7323
Comment 2 Madhumita Sadhukhan 2012-05-23 09:21:24 UTC 
Link: Added: This issue depends JBPAPP-9021
Comment 3 Zbyněk Roubalík 2012-06-07 09:22:12 UTC 
Link: Added: This issue is a dependency of JBPAPP-9292
Comment 4 Zbyněk Roubalík 2012-10-04 09:34:20 UTC 
Verified.
Comment 5 Anne-Louise Tangring 2012-11-13 20:07:53 UTC 
Docs QE Status: Removed: NEW