[
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
