Derby
  1. Derby
  2. DERBY-2017

Client driver can insert and commit partial data when a LOB stream throws IOException or does not match the specified length

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: 10.6.1.0
    • Component/s: JDBC, Network Client
    • Labels:
      None
    • Urgency:
      Normal
    • Issue & fix info:
      High Value Fix, Repro attached
    • Bug behavior facts:
      Data corruption, Wrong query result

      Description

      When a LOB stream throws an exception or does not match the specified length, the client driver does not raise an exception until it has finished executing the statement. Therefore, the statement will be executed (and possibly committed) on the server even though the client reports that the statement failed.

      1. StreamErrRepro.java
        2 kB
        Knut Anders Hatlen
      2. derby-2017-stream_status_preview.diff
        45 kB
        Kristian Waagan
      3. derby-2017-5a-binary_tests.diff
        22 kB
        Kristian Waagan
      4. derby-2017-4a-remove_test_workaround.diff
        1 kB
        Kristian Waagan
      5. derby-2017-3c-fix.diff
        57 kB
        Kristian Waagan
      6. derby-2017-3b-fix.diff
        56 kB
        Kristian Waagan
      7. derby-2017-3a-fix.stat
        0.9 kB
        Kristian Waagan
      8. derby-2017-3a-fix.diff
        41 kB
        Kristian Waagan
      9. derby-2017-2b-regression-test.diff
        36 kB
        Kristian Waagan
      10. derby-2017-2a-regression_test.diff
        9 kB
        Kristian Waagan
      11. derby2017_try1.diff
        3 kB
        Mayuresh Nirhali
      12. Derby_2017_v1.stat
        0.2 kB
        Saurabh Vyas
      13. Derby_2017_v1.diff
        2 kB
        Saurabh Vyas

        Issue Links

          Activity

          Knut Anders Hatlen created issue -
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Attachment StreamErrRepro.java [ 12343871 ]
          Daniel John Debrunner made changes -
          Link This issue is part of DERBY-2034 [ DERBY-2034 ]
          Saurabh Vyas made changes -
          Assignee Saurabh Vyas [ sv204098 ]
          Saurabh Vyas made changes -
          Attachment Derby_2017_v1.stat [ 12346657 ]
          Attachment Derby_2017_v1.diff [ 12346656 ]
          Saurabh Vyas made changes -
          Derby Info [Patch Available]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Saurabh Vyas made changes -
          Fix Version/s 10.2.2.0 [ 12312027 ]
          Rick Hillegas made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Fix Version/s 10.2.2.0 [ 12312027 ]
          Kristian Waagan made changes -
          Derby Info [Patch Available]
          Saurabh Vyas made changes -
          Assignee Saurabh Vyas [ sv204098 ]
          Mayuresh Nirhali made changes -
          Attachment derby2017_try1.diff [ 12358834 ]
          Mayuresh Nirhali made changes -
          Assignee Mayuresh Nirhali [ mayureshnirhali ]
          Mayuresh Nirhali made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Mayuresh Nirhali made changes -
          Assignee Mayuresh Nirhali [ mayureshnirhali ]
          Kathey Marsden made changes -
          Derby Categories [High Value Fix, Wrong query result]
          Dag H. Wanvik made changes -
          Issue & fix info [High Value Fix]
          Knut Anders Hatlen made changes -
          Urgency Normal
          Knut Anders Hatlen made changes -
          Issue & fix info [High Value Fix] [High Value Fix, Repro attached]
          Knut Anders Hatlen made changes -
          Bug behavior facts [Wrong query result] [Data corruption, Wrong query result]
          Kathey Marsden made changes -
          Link This issue incorporates DERBY-4315 [ DERBY-4315 ]
          Kristian Waagan made changes -
          Assignee Kristian Waagan [ kristwaa ]
          Kristian Waagan made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          Kristian Waagan made changes -
          Assignee Kristian Waagan [ kristwaa ]
          Kristian Waagan made changes -
          Attachment derby-2017-2a-regression_test.diff [ 12436844 ]
          Kristian Waagan made changes -
          Assignee Kristian Waagan [ kristwaa ]
          Kristian Waagan made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Kristian Waagan made changes -
          Attachment derby-2017-stream_status_preview.diff [ 12438916 ]
          Kristian Waagan made changes -
          Attachment derby-2017-2b-regression-test.diff [ 12439562 ]
          Kristian Waagan made changes -
          Attachment derby-2017-3a-fix.diff [ 12439673 ]
          Attachment derby-2017-3a-fix.stat [ 12439674 ]
          Kristian Waagan made changes -
          Issue & fix info [High Value Fix, Repro attached] [High Value Fix, Patch Available, Repro attached]
          Kristian Waagan made changes -
          Attachment derby-2017-3b-fix.diff [ 12439895 ]
          Kristian Waagan made changes -
          Attachment derby-2017-3c-fix.diff [ 12442590 ]
          Kristian Waagan made changes -
          Kristian Waagan made changes -
          Attachment derby-2017-5a-binary_tests.diff [ 12442670 ]
          Kristian Waagan made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Kristian Waagan made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Issue & fix info [High Value Fix, Patch Available, Repro attached] [High Value Fix, Repro attached]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kristian Waagan made changes -
          Link This issue incorporates DERBY-1658 [ DERBY-1658 ]
          Gavin made changes -
          Workflow jira [ 12388035 ] Default workflow, editable Closed status [ 12801484 ]
          Dyre Tjeldvoll made changes -
          Link This issue relates to DERBY-5317 [ DERBY-5317 ]

            People

            • Assignee:
              Kristian Waagan
              Reporter:
              Knut Anders Hatlen
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development