[jira] Commented: (DERBY-2949) AssertionFailedError in testStalePlansOnLargeTable

2010-12-01 Thread Lily Wei (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965927#action_12965927 ] Lily Wei commented on DERBY-2949: - Hi Knut: I notice different in "Number of opens" an

[jira] Updated: (DERBY-2949) AssertionFailedError in testStalePlansOnLargeTable

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-2949: -- Attachment: expected-plan.txt For completeness, I'm also attaching a copy of the expect

[jira] Updated: (DERBY-2949) AssertionFailedError in testStalePlansOnLargeTable

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-2949: -- Attachment: plan.txt I managed to get hold of the query plan that was chosen when the t

[jira] Commented: (DERBY-4771) Continue investigation of automatic creation/update of index statistics

2010-12-01 Thread Kristian Waagan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965893#action_12965893 ] Kristian Waagan commented on DERBY-4771: Thanks for the comments, Dag! I'll get to

[jira] Commented: (DERBY-4771) Continue investigation of automatic creation/update of index statistics

2010-12-01 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965886#action_12965886 ] Dag H. Wanvik commented on DERBY-4771: -- Note that QueryTreeNode (also) has an unused m

[jira] Updated: (DERBY-4918) Minor refactoring of SPSDescriptor

2010-12-01 Thread Kristian Waagan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristian Waagan updated DERBY-4918: --- Issue & fix info: (was: [Patch Available]) Fix Version/s: 10.8.0.0 Committed patch 1

[jira] Commented: (DERBY-4771) Continue investigation of automatic creation/update of index statistics

2010-12-01 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965879#action_12965879 ] Dag H. Wanvik commented on DERBY-4771: -- Hi Kristian, some comments on the patch beyond

[jira] Commented: (DERBY-4927) Create a table function to wrap ParameterMetaData

2010-12-01 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965866#action_12965866 ] Dag H. Wanvik commented on DERBY-4927: -- Nice! Do you envision that such useful additio

[jira] Commented: (DERBY-4856) Add thread dump information when derby crash

2010-12-01 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965861#action_12965861 ] Kathey Marsden commented on DERBY-4856: --- I think the point of the move is to make the

[jira] Commented: (DERBY-3258) 'Unexpected row count: expected:<0> but was:<3>' in testReleaseCompileLocks

2010-12-01 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965860#action_12965860 ] Dag H. Wanvik commented on DERBY-3258: -- Looks like clean and good solution to me. +1

[jira] Commented: (DERBY-4771) Continue investigation of automatic creation/update of index statistics

2010-12-01 Thread Kristian Waagan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965851#action_12965851 ] Kristian Waagan commented on DERBY-4771: The only thing I can say based on the outp

[jira] Updated: (DERBY-4927) Create a table function to wrap ParameterMetaData

2010-12-01 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-4927: - Attachment: pmdwrapper.sql PMDWrapper.java Attaching PMDWrapper.java, a table fun

[jira] Created: (DERBY-4927) Create a table function to wrap ParameterMetaData

2010-12-01 Thread Rick Hillegas (JIRA)
Create a table function to wrap ParameterMetaData - Key: DERBY-4927 URL: https://issues.apache.org/jira/browse/DERBY-4927 Project: Derby Issue Type: Improvement Components: JDBC, SQL,

[jira] Updated: (DERBY-4926) Create a table function to wrap ResultSetMetaData

2010-12-01 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-4926: - Issue Type: Improvement (was: Bug) > Create a table function to wrap ResultSetMetaData > ---

[jira] Updated: (DERBY-3258) 'Unexpected row count: expected:<0> but was:<3>' in testReleaseCompileLocks

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-3258: -- Attachment: d3258.diff I am able to reproduce this fairly quickly in my environment if

[jira] Assigned: (DERBY-3258) 'Unexpected row count: expected:<0> but was:<3>' in testReleaseCompileLocks

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen reassigned DERBY-3258: - Assignee: Knut Anders Hatlen > 'Unexpected row count: expected:<0> but was:<3>' i

[jira] Issue Comment Edited: (DERBY-4926) Create a table function to wrap ResultSetMetaData

2010-12-01 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965802#action_12965802 ] Rick Hillegas edited comment on DERBY-4926 at 12/1/10 2:16 PM: --

[jira] Updated: (DERBY-4926) Create a table function to wrap ResultSetMetaData

2010-12-01 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-4926: - Attachment: rsmdwrapper.sql RSMDWrapper.java Attaching RSMDWrapper.sql, a table f

[jira] Created: (DERBY-4926) Create a table function to wrap ResultSetMetaData

2010-12-01 Thread Rick Hillegas (JIRA)
Create a table function to wrap ResultSetMetaData - Key: DERBY-4926 URL: https://issues.apache.org/jira/browse/DERBY-4926 Project: Derby Issue Type: Bug Components: JDBC, SQL, Tools

[jira] Issue Comment Edited: (DERBY-4856) Add thread dump information when derby crash

2010-12-01 Thread Lily Wei (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965578#action_12965578 ] Lily Wei edited comment on DERBY-4856 at 12/1/10 1:51 PM: -- Thanks

[jira] Commented: (DERBY-4856) Add thread dump information when derby crash

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965772#action_12965772 ] Knut Anders Hatlen commented on DERBY-4856: --- I think this is OK as long as the cl

[jira] Commented: (DERBY-4856) Add thread dump information when derby crash

2010-12-01 Thread Lily Wei (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965759#action_12965759 ] Lily Wei commented on DERBY-4856: - Thank you so much, Bryan. I run Suites.all and derbyall

[jira] Updated: (DERBY-4771) Continue investigation of automatic creation/update of index statistics

2010-12-01 Thread Lily Wei (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lily Wei updated DERBY-4771: Attachment: Derby-4771-2f-AutomaticIndexStatisticsTest_wondows7.rar Thanks Kristian for all the detail info

[jira] Commented: (DERBY-4910) Four replication tests fail on z/OS with junit.framework.AssertionFailedError: startMaster did not succeed.

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965758#action_12965758 ] Knut Anders Hatlen commented on DERBY-4910: --- I saw one of these failures again wi

[jira] Created: (DERBY-4925) AssertionFailedError: DerbyMBeanCount:5 in ManagementMBeanTest.testStartStopManagementFromApplication()

2010-12-01 Thread Knut Anders Hatlen (JIRA)
AssertionFailedError: DerbyMBeanCount:5 in ManagementMBeanTest.testStartStopManagementFromApplication() --- Key: DERBY-4925 URL: https://issues.apache.org/jira/bro

Regression Test Report - Daily 1040643 - Sun DBTG

2010-12-01 Thread Ole . Solberg
[Auto-generated mail] *Daily* 1040643/2010-11-30 18:00:24 MET Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin NA NA NANA suitesAll NA NA NANA jdbcapiAutoLoad NA

RE: Can someone tell me if "syscs_util.update_statistics" locks table/indexes being updated

2010-12-01 Thread Bergquist, Brett
Thank you very much for this quick response. Much appreciated. Brett From: Kristian Waagan [kristian.waa...@oracle.com] Sent: Wednesday, December 01, 2010 10:18 AM To: derby-dev@db.apache.org Subject: Re: Can someone tell me if "syscs_util.update_statistic

Re: Can someone tell me if "syscs_util.update_statistics" locks table/indexes being updated

2010-12-01 Thread Kristian Waagan
On 01.12.2010 15:32, Bryan Pendleton wrote: On 12/01/2010 05:26 AM, Bergquist, Brett wrote: If I have a table with millions of rows and I invoke syscs_util.update_statistics on it, will the table/indexes be lock such that inserts or updates will fail while this is being done. The documentatio

Re: Can someone tell me if "syscs_util.update_statistics" locks table/indexes being updated

2010-12-01 Thread Knut Anders Hatlen
"Bergquist, Brett" writes: > If I have a table with millions of rows and I invoke > syscs_util.update_statistics on it, will the table/indexes be lock > such that inserts or updates will fail while this is being done. It used to lock the table exclusively, but that was fixed in DERBY-4274/Derby

Re: Can someone tell me if "syscs_util.update_statistics" locks table/indexes being updated

2010-12-01 Thread Bryan Pendleton
On 12/01/2010 05:26 AM, Bergquist, Brett wrote: If I have a table with millions of rows and I invoke syscs_util.update_statistics on it, will the table/indexes be lock such that inserts or updates will fail while this is being done. The documentation is not clear if this is the case (at least

[jira] Commented: (DERBY-4856) Add thread dump information when derby crash

2010-12-01 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965686#action_12965686 ] Bryan Pendleton commented on DERBY-4856: +1 to the technique of the multi-step appr

[jira] Subscription: Derby: JIRA issues with patch available

2010-12-01 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (5 issues) Subscriber: derby-dev Key Summary DERBY-4771 Continue investigation of automatic creation/update of index statistics https://issues.apache.org/jira/browse/DERBY-4771 DERBY-4918 Minor refact

Can someone tell me if "syscs_util.update_statistics" locks table/indexes being updated

2010-12-01 Thread Bergquist, Brett
If I have a table with millions of rows and I invoke syscs_util.update_statistics on it, will the table/indexes be lock such that inserts or updates will fail while this is being done. The documentation is not clear if this is the case (at least to me). Thanks. Brett

[jira] Updated: (DERBY-4911) restoreIntrFlagIfSeen may throw ShutdownException causing confusing console stack trace at server shutdown

2010-12-01 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-4911: - Component/s: Store Network Server > restoreIntrFlagIfSeen may throw ShutdownExce

[jira] Commented: (DERBY-4914) Utf8CcsidManagerClientTest timed out waiting for network server to start

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965658#action_12965658 ] Knut Anders Hatlen commented on DERBY-4914: --- Happened again when testing the 10.7

[jira] Updated: (DERBY-4201) SecureServerTest AssertionFailedError: Timed out waiting for network server to start

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-4201: -- Affects Version/s: 10.7.1.1 Seen again when testing the 10.7.1.1 release candidate: ht

[jira] Commented: (DERBY-2947) Reoccurrence of DERBY-861: Intermittent failure of store/readlocks.sql

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12965655#action_12965655 ] Knut Anders Hatlen commented on DERBY-2947: --- Also seen with 10.7.1.1: http://dbt

[jira] Updated: (DERBY-3689) 'PrivilegedActionException: javax.management.InstanceNotFoundException' in '*(VersionMBeanTest / NetworkServerMBeanTest)'

2010-12-01 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-3689: -- Affects Version/s: 10.7.1.1 Seen again on the 10.7.1.1 release candidate: http://dbtg.