Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3870

Concurrent Inserts of rows with XML data results in an exception

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.1.3, 10.4.2.1, 10.5.2.0, 10.6.1.0
    • Fix Version/s: 10.8.2.2, 10.9.1.0
    • Component/s: SQL
    • Environment:
      System: MS windows server 2003 standard edition service pack 2. Derby is run as a server on port 1527.
    • Urgency:
      Normal
    • Issue & fix info:
      Known fix, Repro attached
    • Bug behavior facts:
      Crash

      Description

      We insert rows into a table using the following prepared statement (through JDBC):

      INSERT INTO USER1.PSTORE values(?,?, XMLPARSE(document CAST (? AS CLOB) preserve whitespace))

      where each of the ?'s are replaced with a string.

      One thread runs fine. Two or more result in the following exception:

      org.apache.derby.client.am.SqlException: Java exception: 'FWK005 parse may not be called while parsing.: org.xml.sax.SAXException'.
      at org.apache.derby.client.am.SqlException.<init>(Unknown Source)
      at org.apache.derby.client.am.SqlException.<init>(Unknown Source)

      We believe that this comes from the dBuilder.parse(InputSource) method.

        Attachments

        1. upgrade-with-test.diff
          7 kB
          Knut Anders Hatlen
        2. upgrade.diff
          3 kB
          Knut Anders Hatlen
        3. DerbyMultiInsertXmlException.zip
          17 kB
          Aleksander Slominski
        4. d3870-junit.diff
          8 kB
          Knut Anders Hatlen
        5. d3870-3a.stat
          0.5 kB
          Knut Anders Hatlen
        6. d3870-3a.diff
          27 kB
          Knut Anders Hatlen
        7. d3870-2a.diff
          4 kB
          Knut Anders Hatlen
        8. d3870-1a.stat
          0.7 kB
          Knut Anders Hatlen
        9. d3870-1a.diff
          26 kB
          Knut Anders Hatlen
        10. Copy of derby.log
          10 kB
          Aleksander Slominski

          Issue Links

            Activity

              People

              • Assignee:
                knutanders Knut Anders Hatlen
                Reporter:
                ronenr@cs.technion.ac.il Royi Ronen
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: