Crowd fails to add sequential LIST_INDEX numbers to table CWD_USER_CREDENTIAL_RECORD

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 2.6.2
    • Affects Version/s: 2.0.1, 2.0.3, 2.6.1
    • Component/s: Authentication / Security
    • Environment:

      MySQL 5.X and Oracle 10.X

      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

            Assignee:
            Diego Berrueta
            Reporter:
            Renan Battaglin (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: