[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14079762#comment-14079762
]
Karl Wright commented on DERBY-6669:
Mike,
All of what you ask is described in detail
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14079769#comment-14079769
]
Karl Wright commented on DERBY-6669:
bq. scanned through the log provided with does
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14079989#comment-14079989
]
Karl Wright commented on DERBY-6669:
Hi Mike,
I'm still not seeing the expected
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1408#comment-1408
]
Karl Wright commented on DERBY-6669:
Ok, I found the problem. Just running the test
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karl Wright updated DERBY-6669:
---
Attachment: DERBY-6669.zip
This is a *different* run of the test case.
Included are the manifoldcf
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karl Wright updated DERBY-6669:
---
Attachment: manifoldcf.log
This is the annotated manifoldcf.log. I have not correlated back to
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14080066#comment-14080066
]
Karl Wright edited comment on DERBY-6669 at 7/30/14 10:18 PM:
--
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14076240#comment-14076240
]
Karl Wright commented on DERBY-6669:
I do not have a small test case, I am afraid.
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14076345#comment-14076345
]
Karl Wright commented on DERBY-6669:
I'd like to further point out that this
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14070173#comment-14070173
]
Karl Wright commented on DERBY-6669:
To clarify this ticket further, so people don't
Karl Wright created DERBY-6669:
--
Summary: Transactional integrity not maintained properly in
multi-threaded system
Key: DERBY-6669
URL: https://issues.apache.org/jira/browse/DERBY-6669
Project: Derby
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14064846#comment-14064846
]
Karl Wright commented on DERBY-6669:
Also: this test works properly on the other three
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14065019#comment-14065019
]
Karl Wright commented on DERBY-6669:
Hi Rick,
MVCC support should not matter in this
[
https://issues.apache.org/jira/browse/DERBY-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karl Wright updated DERBY-6669:
---
Description:
The Apache ManifoldCF project uses Derby for testing and small deployments.
We're
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13632949#comment-13632949
]
Karl Wright commented on DERBY-6011:
I did confirm that the fix worked for ManifoldCF.
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13616959#comment-13616959
]
Karl Wright commented on DERBY-6011:
Any chance the 10.9.2 release will take place
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13567033#comment-13567033
]
Karl Wright commented on DERBY-6011:
What is the next potential release vehicle this
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13556270#comment-13556270
]
Karl Wright commented on DERBY-6011:
@Bryan: The application technique is not very
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13552638#comment-13552638
]
Karl Wright commented on DERBY-6011:
Worst comes to worst, ManifoldCF can force
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13552645#comment-13552645
]
Karl Wright commented on DERBY-6011:
Indexes on the carrydown table are as follows:
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13551206#comment-13551206
]
Karl Wright commented on DERBY-6011:
I changed that particular transaction to use READ
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13551423#comment-13551423
]
Karl Wright edited comment on DERBY-6011 at 1/11/13 7:19 PM:
-
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13551423#comment-13551423
]
Karl Wright commented on DERBY-6011:
The dataset is extremely small - 100 rows. As
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13551426#comment-13551426
]
Karl Wright commented on DERBY-6011:
How can I get a lock list dump via jdbc?
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13545736#comment-13545736
]
Karl Wright commented on DERBY-6011:
This query selects for a single row.
This is
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13542038#comment-13542038
]
Karl Wright commented on DERBY-6011:
Any further comment on this ticket?
FWIW, the
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13531160#comment-13531160
]
Karl Wright commented on DERBY-6011:
This parameter we attempt to set:
static
{
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13531280#comment-13531280
]
Karl Wright commented on DERBY-6011:
Adding derby.locks.deadlockTimeout=0 cuts the
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karl Wright updated DERBY-6011:
---
Attachment: manifoldcf.log
derby.log
Here are the output logs. Please advise were I
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13530520#comment-13530520
]
Karl Wright commented on DERBY-6011:
Is normal deadlock behavior a wait of 30-60
[
https://issues.apache.org/jira/browse/DERBY-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13530544#comment-13530544
]
Karl Wright commented on DERBY-6011:
I added code to dump the order in which FOR
Karl Wright created DERBY-6011:
--
Summary: Derby performs very badly (seems to deadlock and timeout)
in very simple multi-threaded tests
Key: DERBY-6011
URL: https://issues.apache.org/jira/browse/DERBY-6011
Derby intermittently fails with an internal error
-
Key: DERBY-5169
URL: https://issues.apache.org/jira/browse/DERBY-5169
Project: Derby
Issue Type: Bug
Environment: Derby 10.7.1.1 +
[
https://issues.apache.org/jira/browse/DERBY-5142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13010128#comment-13010128
]
Karl Wright commented on DERBY-5142:
I'm using 10.7.1.1 plus a patch for the
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13008736#comment-13008736
]
Karl Wright commented on DERBY-5073:
Created a new ticket for the optimizer problem,
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007843#comment-13007843
]
Karl Wright commented on DERBY-5073:
Turning on query plan output had some interesting
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007966#comment-13007966
]
Karl Wright commented on DERBY-5073:
The update statistics macro I cannot get to run.
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007975#comment-13007975
]
Karl Wright commented on DERBY-5073:
More research shows that the problem is that you
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007989#comment-13007989
]
Karl Wright commented on DERBY-5073:
Never mind; it cares about case for the table
Optimizer uses table scan when it could use index when multiple OR clauses
--
Key: DERBY-5142
URL: https://issues.apache.org/jira/browse/DERBY-5142
Project: Derby
Issue
[
https://issues.apache.org/jira/browse/DERBY-5142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karl Wright updated DERBY-5142:
---
Description:
The Derby optimizer doesn't seem to recognize that a query like this:
SELECT
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007399#comment-13007399
]
Karl Wright commented on DERBY-5073:
The tests at the client site have passed, so the
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007709#comment-13007709
]
Karl Wright commented on DERBY-5073:
Hmm. I merged the fix into 10.7.1.1, and ran a
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007722#comment-13007722
]
Karl Wright commented on DERBY-5073:
A trunk build does the same thing on my test
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007741#comment-13007741
]
Karl Wright commented on DERBY-5073:
Doesn't act like a very long running query; just
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007749#comment-13007749
]
Karl Wright commented on DERBY-5073:
More research confirms absolutely no progress of
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13007756#comment-13007756
]
Karl Wright commented on DERBY-5073:
Hey, it looks like it unwedged itself after some
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13006584#comment-13006584
]
Karl Wright commented on DERBY-5073:
I built Derby trunk and checked it in, and
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13005768#comment-13005768
]
Karl Wright commented on DERBY-5073:
I'll keep my eyes open for the final patch, and
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13001957#comment-13001957
]
Karl Wright commented on DERBY-5073:
It looks to me like this is getting truncated.
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13001989#comment-13001989
]
Karl Wright commented on DERBY-5073:
Ok, this is better:
ij select * from
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13002004#comment-13002004
]
Karl Wright commented on DERBY-5073:
So, am I wrong to expect that Derby should detect
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13001385#comment-13001385
]
Karl Wright commented on DERBY-5073:
The locks table at the time of a hang looks like
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13001558#comment-13001558
]
Karl Wright commented on DERBY-5073:
Is there anything else that would be helpful to
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13001724#comment-13001724
]
Karl Wright commented on DERBY-5073:
I'm sorry - which diagnostic table has a STATE
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13000338#comment-13000338
]
Karl Wright commented on DERBY-5073:
(1) Yes, the wait timeout is set to infinity.
(2)
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13000409#comment-13000409
]
Karl Wright commented on DERBY-5073:
The deadlock timeout is NOT set to infinity, but
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13000411#comment-13000411
]
Karl Wright commented on DERBY-5073:
Also, just to make it very clear, I am already
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13000605#comment-13000605
]
Karl Wright commented on DERBY-5073:
bq. Note that Derby will only detect a deadlock
Derby deadlocks without recourse on simultaneous correlated subqueries
--
Key: DERBY-5073
URL: https://issues.apache.org/jira/browse/DERBY-5073
Project: Derby
Issue Type:
[
https://issues.apache.org/jira/browse/DERBY-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1289#comment-1289
]
Karl Wright commented on DERBY-5073:
A thread dump on 10.5.3.0 yielded multiple
61 matches
Mail list logo
