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

Bug 900436 (JBPAPP6-914)

Summary:	Tests hang randomly on mssql2008R1 and mssql2008R2 and several Tests fail
Product:	[JBoss] JBoss Enterprise Application Platform 6	Reporter:	Madhumita Sadhukhan <msadhukh>
Component:	Hibernate	Assignee:	Zbyněk Roubalík <zroubali>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	6.0.0	CC:	msadhukh, pslavice, zroubali
Target Milestone:	---
Target Release:	EAP 6.0.1
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/JBPAPP6-914
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-10-04 09:33:07 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:
Bug Blocks:	900451, 900612

Description Madhumita Sadhukhan 2012-05-15 11:56:03 UTC

Workaround Description: Skip the testcase SQLServerDialectTest.testMaxResultsSqlServerWithCaseSensitiveCollation while running Hibernate testsuite on mssql2008R1 and mssql2008R2
project_key: JBPAPP6

The mssql2008R1 and R2 databases were restarted and had some dballocator/cleanup issues during ER7 cycle.
However despite the restart I still see tests hanging randomly on these two databases and also huge number of failures mostly due to column names not found which look like case sensitivity issue for eg:

org.hibernate.test.component.basic.ComponentTest.testCustomColumnReadAndWrite

org.hibernate.exception.SQLGrammarException: Invalid column name 'username'.
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)



org.hibernate.test.hql.BulkManipulationTest.testDeleteWithMetadataWhereFragments

Stacktrace

org.hibernate.exception.SQLGrammarException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CS_AS" in the equal to operation.
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)


However eng-ops confirmed that no config was changed at the database end

I verified that DB collation for mssql dbs is:

Collation: Latin1_General_CS_AS

and server collation is SQL_Latin1_General_CP1_CI_AS

is the dballocator picking up wrong collation or is it some regression from code change?

Comment 1 Madhumita Sadhukhan 2012-05-15 12:37:03 UTC

Strong,

      Could you please confirm what is the expected collation I believe we should have case sensitive property disabled for hibernate testsuite.

Comment 2 Madhumita Sadhukhan 2012-05-18 06:53:07 UTC

This was a problem with collation used for mssql2008R1 and R2 as the dballocator accounts/databases was picking up a different collation than the one set for the DB system.

It seems like the collation got tampered accidentally and was fixed by correcting the dballocator accounts/databases to read the same collation value which is SQL_Latin1_General_CP1_CI_AS

Ticket <URL: https://engineering.redhat.com/rt/Ticket/Display.html?id=153481 >

This was purely environmental issue and required no code fix.

Comment 3 Madhumita Sadhukhan 2012-05-23 09:19:37 UTC

Reopening as this issue occurs due to collation changed by SQLServerDialectTest.testMaxResultsSqlServerWithCaseSensitiveCollation which fails and does not revert back the Collation

Comment 4 Madhumita Sadhukhan 2012-05-23 09:20:56 UTC

Workaround Description: Added: Skip the testcase SQLServerDialectTest.testMaxResultsSqlServerWithCaseSensitiveCollation while running Hibernate testsuite on mssql2008R1 and mssql2008R2

Comment 5 Madhumita Sadhukhan 2012-05-23 09:21:24 UTC

Link: Added: This issue is a dependency of JBPAPP-9041

Comment 6 Rajesh Rajasekaran 2012-06-06 23:00:22 UTC

Link: Added: This issue is a dependency of JBPAPP-9292

Comment 7 Madhumita Sadhukhan 2012-06-08 16:43:29 UTC

This works after applying workaround specified in JBPAPP-9041(removing test and rerunning) and will be fixed once fix for JBPAPP-9041 is in.
Hence marking fix version same as JBPAPP-9041 and assigning to Zbynek for verification

Comment 8 Zbyněk Roubalík 2012-10-04 09:33:07 UTC

Verified.

Comment 9 Anne-Louise Tangring 2012-11-13 20:07:48 UTC

Docs QE Status: Removed: NEW