Details
-
Bug
-
Resolution: Fixed
-
Low
-
2.0.1, 2.0.3, 2.6.1
-
MySQL 5.X and Oracle 10.X
Description
Crowd fails to add sequential LIST_INDEX numbers to table CWD_USER_CREDENTIAL_RECORD, setting the index to zero even if the user already has an entry, causing user deletion to fail.
ID, USER_ID, PASSWORD_HASH, LIST_INDEX "1","301015",7OXgRqJd6rgCcT0ZVGKYrYEJHA3CfIo9AuD79jbrSvIKIYt8p2fq0w7jR8UD+cCKoIKcou6md/gJQvXORbDArQ==,0 "2","301015",tG2gS45XeU2Brt3LgpS2/fd0uWx5DZ7fjxCLNHQlQ4NUg1wBRO0RVf3cWtG8kO5QY8M6I/niq4oY/tA+nmpJ7Q==,0 "3","301015",7OXgRqJd6rgCcT0ZVGKYrYEJHA3CfIo9AuD79jbrSvIKIYt8p2fq0w7jR8UD+cCKoIKcou6md/gJQvXORbDArQ==,0 "4","301015",tG2gS45XeU2Brt3LgpS2/fd0uWx5DZ7fjxCLNHQlQ4NUg1wBRO0RVf3cWtG8kO5QY8M6I/niq4oY/tA+nmpJ7Q==,0
2010-07-08 13:07:46,545 http-attuppaxxiam01%2F10.120.1.154-8095-16 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000 2010-07-08 13:07:46,545 http-attuppaxxiam01%2F10.120.1.154-8095-16 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-02292: integrity constraint (CROWD_PROD_USER.FK_USER_CRED_USER) violated - child record found 2010-07-08 13:07:46,545 http-attuppaxxiam01%2F10.120.1.154-8095-16 ERROR [hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update