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

"Schema already exists" when creating a table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0
    • 10.1.1.0
    • SQL
    • None

    Description

      When running a multithreaded program where several threads in parallell create tables in a schema that is not explicitly created, one often get the following exception:

      ERROR X0Y68: Schema 'TESTSCHEMA' already exists.
      at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:322)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(DataDictionaryImpl.java:1512)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptorNow(DataDictionaryImpl.java:1496)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(DataDictionaryImpl.java:1478)
      at org.apache.derby.impl.sql.execute.CreateSchemaConstantAction.executeConstantAction(CreateSchemaConstantAction.java:147)
      at org.apache.derby.impl.sql.execute.DDLConstantAction.getSchemaDescriptorForCreate(Unknown Source)
      at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(CreateTableConstantAction.java:213)
      at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:56)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:366)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1108)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:517)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:475)
      at derbytest.Main$CreateTable.run(Main.java:42)
      at java.lang.Thread.run(Thread.java:595)

      A program that reproduces this bug will be attached.

      Attachments

        1. Main.java
          5 kB
          Oystein Grovlen
        2. derby-230c.diff
          10 kB
          Oystein Grovlen

        Activity

          People

            oysteing Oystein Grovlen
            oysteing Oystein Grovlen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: