You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2009/04/09 21:26:13 UTC

[jira] Created: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

jdbcapi/XATest.java  doesn't seem to be running anywhere
--------------------------------------------------------

                 Key: DERBY-4155
                 URL: https://issues.apache.org/jira/browse/DERBY-4155
             Project: Derby
          Issue Type: Bug
          Components: Test
    Affects Versions: 10.5.1.1, 10.6.0.0
         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.

            Reporter: Kathey Marsden
            Assignee: Kathey Marsden
            Priority: Minor




-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-4155:
---------------------------------

    Fix Version/s: 10.5.3.0

This fix appears to have been merged to the 10.5 branch in time to get onto the next release train so I am marking this as fixed in 10.5.3.

> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.0.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Tiago R. Espinha
>            Priority: Minor
>             Fix For: 10.5.3.0, 10.6.0.0
>
>         Attachments: DERBY-4155-XATest.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden resolved DERBY-4155.
-----------------------------------

       Resolution: Fixed
    Fix Version/s: 10.6.0.0

Resolving for 10.6. If backported DERBY-4310 needs to be backported as well.


> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.0.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.6.0.0
>
>         Attachments: DERBY-4155-XATest.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12731032#action_12731032 ] 

Kathey Marsden commented on DERBY-4155:
---------------------------------------

After Mamta's fix for DERBY-4053 I tried enable this test and ran suites.All three times.
First time I got well past XATest and my machine froze up in teh replication tests and I had to reboot.

Second  run I hit DERBY-4053 (even with the fix) a

Third run I hit a different problem:
junit.framework.AssertionFailedError: Column value mismatch @ column 'STATUS', row 1:
    Expected: >PREPARED<
    Found:    >IDLE<
        at junit.framework.Assert.fail(Assert.java:47)
        at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1095)
        at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1007)
        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:895)
        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:833)
        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:791)
        at org.apache.derbyTesting.junit.XATestUtil.checkXATransactionView(XATestUtil.java:82)
        at org.apache.derbyTesting.functionTests.tests.jdbcapi.XATest.testMorph(XATest.java:547)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:599)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:103)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
        at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
        at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.extensions.TestSetup.run(TestSetup.java:23)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at junit.textui.TestRunner.doRun(TestRunner.java:116)
        at junit.textui.TestRunner.start(TestRunner.java:172)
        at junit.textui.TestRunner.main(TestRunner.java:138)

This failure caused subsequent tests to run very slowly because of lock timeouts in CleanDatabaseSetup because there was a statement left prepared.  I am going to try again with just the jdbcapi suite.



> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.0.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>            Priority: Minor
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12731086#action_12731086 ] 

Kathey Marsden commented on DERBY-4155:
---------------------------------------

I changed the test to check for an unordered result set to avoid the PREPARED vs IDLE error above and get fairly consistently this issue on network shutdown running the test standalone if I use the derby-4053_diag_diff.txt patch.  I am guessing this error is the one that caused DERBY-4053 in the second run.

I am guessing this is some kind of embedded bug regarding closing BrokeredStatements when the referenced table had been dropped.  I will try to get  a stand-alone repro for that.


testDerby966 used 125 ms java.sql.SQLSyntaxErrorException: Table/View 'APP.FOO' does not exist.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:91)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:147)
        at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:105)
        at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1542)
        at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1423)
        at org.apache.derby.iapi.jdbc.BrokeredPreparedStatement30.createDuplicateStatement(BrokeredPreparedStatement30.j
ava:56)
        at org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(XAStatementControl.java:143)
        at org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(BrokeredPreparedStatement.java:526)

        at org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(BrokeredPreparedStatement.java:533)
        at org.apache.derby.iapi.jdbc.BrokeredStatement.close(BrokeredStatement.java:130)
        at org.apache.derby.impl.drda.DRDAStatement.close(DRDAStatement.java:1027)
        at org.apache.derby.impl.drda.Database.close(Database.java:352)
        at org.apache.derby.impl.drda.Session.close(Session.java:115)
        at org.apache.derby.impl.drda.NetworkServerControlImpl.blockingStart(NetworkServerControlImpl.java:826)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:599)
        at org.apache.derby.iapi.jdbc.DRDAServerStarter.run(DRDAServerStarter.java:236)
        at java.lang.Thread.run(Thread.java:735)
Caused by: java.sql.SQLException: Table/View 'APP.FOO' does not exist.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
9)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
        ... 24 more
Caused by: ERROR 42X05: Table/View 'APP.FOO' does not exist.
        at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:286)
        at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2463)
        at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2183)
        at org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:310)
        at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:390)
        at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:199)
        at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:137)
        at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:245)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:316)
        at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConne
ctionContext.java:822)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:129)
        ... 18 more
 

> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.0.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>            Priority: Minor
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Tiago R. Espinha (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tiago R. Espinha updated DERBY-4155:
------------------------------------

    Attachment: DERBY-4155-XATest.patch

I'm submitting a patch to this issue. This patch adds the XATest to the respective suite and adds two fixtures to test DERBY-4310. I'll be adding another patch to the other issue that fixes the behavior described on the comments.

> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.0.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>            Priority: Minor
>         Attachments: DERBY-4155-XATest.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali resolved DERBY-4155.
-----------------------------------

    Fix Version/s: 10.3.3.1
       Resolution: Fixed

I backported the test changes associated with this issue to 10.3.  

backporting the current state of XATest.java and XAtestUtil.java from trunk
to 10.3 branch. Disabled the test for DERBY-4731, to be enabled later when
that is backported. It looks like all of the changes for the rest of this
issue were already backported to 10.3 as part of the backport of DERBY-4310. 

> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.1.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Mike Matrigali
>            Priority: Minor
>             Fix For: 10.3.3.1, 10.6.1.0, 10.5.3.0
>
>         Attachments: DERBY-4155-XATest.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Reopened: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali reopened DERBY-4155:
-----------------------------------

      Assignee: Mike Matrigali  (was: Tiago R. Espinha)

reopening issue to look at backporting it to 10.3.  I am trying to backport fix for DERBY-4731
but this is blocking my testing of it there.

> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.1.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Mike Matrigali
>            Priority: Minor
>             Fix For: 10.5.3.0, 10.6.1.0
>
>         Attachments: DERBY-4155-XATest.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-4155:
----------------------------------

    Assignee: Tiago R. Espinha  (was: Kathey Marsden)

> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.0.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Tiago R. Espinha
>            Priority: Minor
>             Fix For: 10.6.0.0
>
>         Attachments: DERBY-4155-XATest.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (DERBY-4155) jdbcapi/XATest.java doesn't seem to be running anywhere

Posted by "Tiago R. Espinha (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tiago R. Espinha closed DERBY-4155.
-----------------------------------


Indeed, this issue was merged to 10.5 on revision 802397.

I'm closing the issue as for now I don't think we will be merging it to other branches.

> jdbcapi/XATest.java  doesn't seem to be running anywhere
> --------------------------------------------------------
>
>                 Key: DERBY-4155
>                 URL: https://issues.apache.org/jira/browse/DERBY-4155
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.1, 10.6.0.0
>         Environment: jdbcapi/XATest  does not seem to be included in any suite.  It currently fails in testMorph because a transaction is active when a connection is closed.  I think the error is correct and the test needs to be changed.
>            Reporter: Kathey Marsden
>            Assignee: Tiago R. Espinha
>            Priority: Minor
>             Fix For: 10.5.3.0, 10.6.0.0
>
>         Attachments: DERBY-4155-XATest.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.