db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6183) rlliso2multi and rlliso3multi failing with [WARNING 01004: Data truncation]
Date Mon, 15 Apr 2013 22:28:16 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13632297#comment-13632297
] 

Mike Matrigali commented on DERBY-6183:
---------------------------------------

Here is the lock_table2 view:
-- lock table with no join.
create view lock_table2 as
select
    cast(l.xid as char(8)) as xid,
    cast(l.type as char(8)) as type,
    cast(lockcount as char(3)) as cnt,
    mode,
    cast(tablename as char(12)) as tabname,
    cast(lockname as char(10)) as lockname,
    state
from
    syscs_diag.lock_table l
where l.tableType <> 'S' ;


Could it be that the problem rows are the ones not being returned?  Is there some way to write
the query so that cast would only apply to
qualifying rows?  Since this issue is intermittent I am thinking that maybe some background
locks are causing problem.  The query is written
to not print system locks, so likely background system locks have affected the test in the
past.

The casts are pretty arbitrary, they are there just to make the table human readable, in IJ,
and make the output not wrap.  
This particular view is not used very much, so tempted to remove the cases and update the
masters as necessary.

So far I have not been able to reproduce.  Have just been trying running the StoreScripts
suite a bunch of times.
                
> rlliso2multi and rlliso3multi failing with [WARNING 01004: Data truncation]
> ---------------------------------------------------------------------------
>
>                 Key: DERBY-6183
>                 URL: https://issues.apache.org/jira/browse/DERBY-6183
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.10.1.2
>         Environment: Windows XP with IBM jdk 1.7
>            Reporter: Mamta A. Satoor
>         Attachments: derbyFor_rlliso2multi.log, derbyFor_rlliso3multi.log, error-stacktraceFor_rlliso2multi.out,
error-stacktraceFor_rlliso3multi.out
>
>
> 1) rlliso2multi(org.apache.derbyTesting.functionTests.tests.store.StoreScriptsTest)junit.framework.ComparisonFailure:
Output at line 1188 expected:<[TABLE   |1  |IX  |TEST_11     |Tablelock |GRANT]> but
was:<[WARNING 01004: Data truncation]>
> 	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:109)
> 	at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:204)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:442)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:459)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 2) rlliso3multi(org.apache.derbyTesting.functionTests.tests.store.StoreScriptsTest)junit.framework.ComparisonFailure:
Output at line 602 expected:<[TABLE   |1  |IX  |TEST_6      |Tablelock |GRANT]> but
was:<[WARNING 01004: Data truncation]>
> 	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:109)
> 	at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:204)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:442)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:459)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message