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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2011/03/14 14:50:29 UTC

[jira] Created: (DERBY-5131) Disable the istat daemon by default for 10.8.1

Disable the istat daemon by default for 10.8.1
----------------------------------------------

                 Key: DERBY-5131
                 URL: https://issues.apache.org/jira/browse/DERBY-5131
             Project: Derby
          Issue Type: Task
          Components: SQL, Test
            Reporter: Rick Hillegas


Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697

This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Updated: (DERBY-5131) Disable the istat daemon by default for 10.8.1

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

Mike Matrigali updated DERBY-5131:
----------------------------------


There should be a test in the suite that verified the default setting is whatever it is supposed to be.  Also we should figure out a way to run the istat tests even if it is not enabled by default. 

> Disable the istat daemon by default for 10.8.1
> ----------------------------------------------
>
>                 Key: DERBY-5131
>                 URL: https://issues.apache.org/jira/browse/DERBY-5131
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Test
>            Reporter: Rick Hillegas
>         Attachments: derby-5131-01-aa-disableIn10.8.1.diff
>
>
> Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697
> This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Commented: (DERBY-5131) Disable the istat daemon by default for 10.8.1

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

Mike Matrigali commented on DERBY-5131:
---------------------------------------

my thoughts was that these would be good tests in the 10.8 branch.   I agree that they are less useful for the trunk once it is on.  Since we will be supporting both istat=on and istat=off seems like we should test both modes.  It could be that off mode is already tested - I have not looked.  These need not be part of this JIRA.

> Disable the istat daemon by default for 10.8.1
> ----------------------------------------------
>
>                 Key: DERBY-5131
>                 URL: https://issues.apache.org/jira/browse/DERBY-5131
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Test
>            Reporter: Rick Hillegas
>         Attachments: derby-5131-01-aa-disableIn10.8.1.diff
>
>
> Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697
> This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (DERBY-5131) Disable the istat daemon by default for 10.8.1

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

Kristian Waagan commented on DERBY-5131:
----------------------------------------

Can this issue be resolved (invalid or won't fix?) and closed?

> Disable the istat daemon by default for 10.8.1
> ----------------------------------------------
>
>                 Key: DERBY-5131
>                 URL: https://issues.apache.org/jira/browse/DERBY-5131
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Test
>            Reporter: Rick Hillegas
>         Attachments: derby-5131-01-aa-disableIn10.8.1.diff, derby-5131-02-aa-enableAgain.diff
>
>
> Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697
> This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Closed] (DERBY-5131) Disable the istat daemon by default for 10.8.1

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

Rick Hillegas closed DERBY-5131.
--------------------------------

    Resolution: Won't Fix

Closing this issue because any remaining work can happen on derby-5132.

> Disable the istat daemon by default for 10.8.1
> ----------------------------------------------
>
>                 Key: DERBY-5131
>                 URL: https://issues.apache.org/jira/browse/DERBY-5131
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Test
>            Reporter: Rick Hillegas
>         Attachments: derby-5131-01-aa-disableIn10.8.1.diff, derby-5131-02-aa-enableAgain.diff
>
>
> Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697
> This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Updated: (DERBY-5131) Disable the istat daemon by default for 10.8.1

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

Rick Hillegas updated DERBY-5131:
---------------------------------

    Attachment: derby-5131-01-aa-disableIn10.8.1.diff

Attaching derby-5131-01-aa-disableIn10.8.1.diff. This patch turns off the istat daemon by default and disables the istat tests. Regression tests ran cleanly for me. I verified by hand that the istat tests now fail if you run them: the required statistics tuples no longer turn up. Committed at subversion revision 1081416.

Touches the following files:

--------

M      java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java

Turns off the istat daemon by default.

--------

M      java/testing/org/apache/derbyTesting/functionTests/tests/store/_Suite.java

Disables the istat tests.


> Disable the istat daemon by default for 10.8.1
> ----------------------------------------------
>
>                 Key: DERBY-5131
>                 URL: https://issues.apache.org/jira/browse/DERBY-5131
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Test
>            Reporter: Rick Hillegas
>         Attachments: derby-5131-01-aa-disableIn10.8.1.diff
>
>
> Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697
> This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Updated: (DERBY-5131) Disable the istat daemon by default for 10.8.1

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

Rick Hillegas updated DERBY-5131:
---------------------------------

    Attachment: derby-5131-02-aa-enableAgain.diff

Attaching derby-5131-02-aa-enableAgain.diff. This patch backs out the previous patch and re-enables istat=on as the default Derby behavior. I have hand verified that the two istat regression tests run cleanly standalone in my environment. Committed at subversion revision 1082671.

> Disable the istat daemon by default for 10.8.1
> ----------------------------------------------
>
>                 Key: DERBY-5131
>                 URL: https://issues.apache.org/jira/browse/DERBY-5131
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Test
>            Reporter: Rick Hillegas
>         Attachments: derby-5131-01-aa-disableIn10.8.1.diff, derby-5131-02-aa-enableAgain.diff
>
>
> Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697
> This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Commented: (DERBY-5131) Disable the istat daemon by default for 10.8.1

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

Rick Hillegas commented on DERBY-5131:
--------------------------------------

Hi Mike,

I am going to back out this change after I create the 10.8.1 branch so I don't see that we need to write those additional tests you recommend. By running the istat tests with this patch applied, I have verified that the default behavior (for the 10.8 branch) will be istat=off. Thanks.

> Disable the istat daemon by default for 10.8.1
> ----------------------------------------------
>
>                 Key: DERBY-5131
>                 URL: https://issues.apache.org/jira/browse/DERBY-5131
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Test
>            Reporter: Rick Hillegas
>         Attachments: derby-5131-01-aa-disableIn10.8.1.diff
>
>
> Turning on the istat daemon increases the risk of problems which arise when a database shuts down in the middle of collecting index statistics. There is concern that this increased risk could be significant. A consensus has developed that the istat daemon should not run by default in 10.8.1. For the shutdown-related problem, see DERBY-5108. For the community discussion of the risk to 10.8.1, see this email thread: http://old.nabble.com/opinions-on-a-less-aggressive-release-of-the-istats-feature--to31129980.html#a31143697
> This issue tracks the work needed to turn off the istat daemon (by default) in 10.8.1 but re-enable it as the default on the trunk.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira