Derby
  1. Derby
  2. DERBY-3870

Concurrent Inserts of rows with XML data results in an exception

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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.

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

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Knut Anders Hatlen
              Reporter:
              Royi Ronen
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development