Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-3864

Migrating from HSQLDB fails when constraints are violated

    XMLWordPrintable

Details

    Description

      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)

      Attachments

        Issue Links

          Activity

            People

              tom@atlassian.com Tom Davies
              andrew.myers Andrew Myers [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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