Migrating from HSQLDB fails when constraints are violated

XMLWordPrintable

      If you try to store a review title that is > 255 characters it is not saved and there is no indication of failure in the UI.

      The logs dump something like:

      Caused by: java.sql.BatchUpdateException: Batch entry 0 update cru_review set cru_review_type='1', cru_name='0123456789012345.....6789', cru_default_source='BranchTest', cru_state='Review', cru_description='SAMPLE-1
      TST-1
      
      ', cru_summary=NULL, cru_allow_reviewer_to_join='1', cru_create_date='1280381875156', cru_metrics_version='1', cru_all_reviewers_complete='1', cru_due_date='1280986675000', cru_issue_key='TST-1', cru_parent_review=NULL, cru_creator='2', cru_project='1' where cru_review_id='1' was aborted.  Call getNextException to see the cause.
              at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

            Assignee:
            Tom Davies
            Reporter:
            Andrew Myers [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 13h Time Not Required
                13h