Resolution: Won't Fix
Affects Version/s: 6.1.30 EE GA3, 6.2.0 CE M2
AS: Tomcat 7.0.x
JVM: Sun JDK 6
RDBMS: MySQL, Oracle, DB2, SQL Server 2008
Portal 6.1.x GIT ID: 657ef7d30e6e8482e7a1c3fc5fe4b9815727ee4e
Portal 6.2.x GIT ID: 3cd9429080a2f47e9d05830dbe6900cacdebec5c
Similar Issues:Show 5 results
LPS-25086 Upgrade from version 5.2.3 fails (during 6.0.3 upgrade part) with error java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__UserGroupRole__690797E6'. Cannot insert duplicate key in object 'dbo.UserGroupRole'. LPS-22790 Foreign Key as Primary Key LPS-44370 No RepositoryEntry exists with the primary key LPS-10427 No User exists with the primary key 0 LPS-2197 AssetPublisher: No TagsAsset exists with the primary key 0
LockLocalServiceTest produces DB level unique constrain violation if two threads (or more than one node of a cluster) tries to acquire the same lock nearly at the same time.
Steps to reproduce: Execute the pertinent test case (LockLocalServiceTest).
Unfortunately LockLocalService does not work well under the aforementioned race condition on trunk either and produces unique constraint violation on almost every RDBMS (except MySQL):
- MySQL -> Deadlock
- SQL Server -> Cannot insert duplicate key row in object 'dbo.Lock' with unique index 'IX_DD635956'._
- DB2 -> SQL0803N
- Oracle -> ORA-00001: unique constraint (LPORTAL_6200.IX_DD635956) violated.