http://permalink.gmane.org/gmane.comp.apache.db.derby.devel hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95710 <pre>Mike Matrigali created DERBY-5785: ------------------------------------- Summary: investigate improving identity column performance by reusing nested transaction Key: DERBY-5785 URL: https://issues.apache.org/jira/browse/DERBY-5785 Project: Derby Issue Type: Improvement Components: SQL Affects Versions: 10.8.2.2 Reporter: Mike Matrigali Priority: Minor Currently every insert of row with an identity column creates a nested user transaction to update the value in syscolumns, and then destroys it. It seems like this transaction could be cached in the user context and then reused. I believe this is what is done for the nested read only transaction that is used for compiling statements. The change may improve performance and also lead to less objects being created/destroyed per insert. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIR</pre> Mike Matrigali (JIRA 2012-05-25T16:44:22 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95709 <pre> [ https://issues.apache.org/jira/browse/DERBY-5494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13283582#comment-13283582 ] Mike Matrigali edited comment on DERBY-5494 at 5/25/12 4:38 PM: ---------------------------------------------------------------- Here is proposed fix for performance degredation of identity columns caused by previous patch. All tests passed for me running sane, classes, write sync disabled, and no special handling for upgrade tests. I am concerned that tests took a lot longer (9+ hours) vs around 6 hours for runs in the past on this new machine doing sane, classes, write sync enabled, but I changed both the write sync option and the patch so don't have a good baseline. Am running more tests before commit. The patch changes some interfaces to allow creaters of nested user transactions to set the default sync on transaction end when they create the transaction, rather than just relying on type of transaction. The previous patch set th</pre> Mike Matrigali (JIRA 2012-05-25T16:38:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95708 <pre> [ https://issues.apache.org/jira/browse/DERBY-5494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mike Matrigali updated DERBY-5494: ---------------------------------- Attachment: derby-5494_3.diff Here is proposed fix for performance degredation of identity columns caused by previous patch. All tests passed for me running sane, classes, write sync disabled, and no special handling for upgrade tests. I am concerned that tests took a lot longer (9+ hours) vs around 6 hours for runs in the past on this new machine doing sane, classes, write sync enabled, but I changed both the write sync option and the patch so don't have a good baseline. Am running more tests before commit. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Mike Matrigali (JIRA 2012-05-25T16:34:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95707 <pre>[Auto-generated mail] *Daily* 1342306/2012-05-24 18:00:08 MEST Failed Tests OK Skip Duration Suite ------------------------------------------------------- *Jvm: 1.7* lin 0 15840 15840 0 .% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 .% derbyall 0 2 2 0 .% compatibility 0 2 2 0 .% demoSuite sol 0 15840 15840 0 .% suitesAll 0 15 15 0 .% jdbcapiAutoLoad 0 14 14 0 .% JDBCDriversAll 0 15 15 0 .% JDBCDriversClient 0 14 14 0 .% JDBCDriversEmbedded 0 166 166 0 .% derbyall 0 2 2 0 .% compatibility 0 2 2 0 .% demoSuite sol32 0 15840 15840 0 .% suitesAll 0 15 15</pre> Ole.Solberg-veTT2BtV2gBXrIkS9f7CXA< at >public.gmane.org 2012-05-25T15:55:25 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95706 <pre> [ https://issues.apache.org/jira/browse/DERBY-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-5688: --------------------------------- Attachment: derby-5688-04-aa-addBranchToWebsite.diff Attaching derby-5688-04-aa-addBranchToWebsite.diff, which adds 10.9 to the list of branches on our website. Committed at subversion revision 1342683. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Rick Hillegas (JIRA 2012-05-25T15:23:22 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95705 <pre> [ https://issues.apache.org/jira/browse/DERBY-5784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-5784: --------------------------------- Attachment: DERBY_5784.java Attaching repro. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Rick Hillegas (JIRA 2012-05-25T14:44:25 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95704 <pre>Rick Hillegas created DERBY-5784: ------------------------------------ Summary: Setting a parameter as NUMERIC fails to match stored value, but setting the parameter as untyped does match Key: DERBY-5784 URL: https://issues.apache.org/jira/browse/DERBY-5784 Project: Derby Issue Type: Bug Components: JDBC Affects Versions: 10.10.0.0 Reporter: Rick Hillegas I will attach a repro. The behavior should be the same according to table B-4 in the JDBC spec. Lance Andersen reports that other databases find the row using both setObject() overloads. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Rick Hillegas (JIRA 2012-05-25T14:42:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95703 <pre> [ https://issues.apache.org/jira/browse/DERBY-5508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5508. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T14:16:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95702 <pre> [ https://issues.apache.org/jira/browse/DERBY-5590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5590. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T14:02:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95701 <pre> [ https://issues.apache.org/jira/browse/DERBY-5691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5691. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:58:31 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95700 <pre> [ https://issues.apache.org/jira/browse/DERBY-5758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5758. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:54:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95699 <pre> [ https://issues.apache.org/jira/browse/DERBY-5566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5566. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:50:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95698 <pre> [ https://issues.apache.org/jira/browse/DERBY-5769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5769. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:50:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95697 <pre> [ https://issues.apache.org/jira/browse/DERBY-5756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5756. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:46:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95696 <pre> [ https://issues.apache.org/jira/browse/DERBY-5767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5767. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:42:26 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95695 <pre> [ https://issues.apache.org/jira/browse/DERBY-5763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5763. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:40:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95694 <pre> [ https://issues.apache.org/jira/browse/DERBY-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase closed DERBY-5591. ---------------------------- Changes have appeared in Latest Alpha Manuals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Kim Haase (JIRA 2012-05-25T13:34:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95693 <pre> [ https://issues.apache.org/jira/browse/DERBY-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=13283338#comment-13283338 ] Dag H. Wanvik commented on DERBY-118: ------------------------------------- Regressions showed no problems, building tests. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Dag H. Wanvik (JIRA 2012-05-25T12:28:24 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95692 <pre> [ https://issues.apache.org/jira/browse/DERBY-5783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-5783: -------------------------------------- Issue &amp; fix info: Patch Available -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Knut Anders Hatlen (JIRA 2012-05-25T11:58:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95691 <pre> [ https://issues.apache.org/jira/browse/DERBY-5783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-5783: -------------------------------------- Attachment: d5783-1a.diff The attached patch replaces two calls to the three-arg runUserCommandRemotely() method with calls to the four-arg variant of the method, and removes three methods that become unused because of the change. Replication tests passed with the patch. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira </pre> Knut Anders Hatlen (JIRA 2012-05-25T11:58:23 http://permalink.gmane.org/gmane.comp.apache.db.derby.devel/95690 <pre>Knut Anders Hatlen created DERBY-5783: ----------------------------------------- Summary: Remove duplicated code for starting remote processes in replication tests Key: DERBY-5783 URL: https://issues.apache.org/jira/browse/DERBY-5783 Project: Derby Issue Type: Improvement Components: Test Affects Versions: 10.10.0.0 Reporter: Knut Anders Hatlen Assignee: Knut Anders Hatlen Priority: Minor ReplicationRun has two copies of each of the methods runUserCommand(), runUserCommandRemotely() and processOutput(). One variant takes an id parameter (used only in debug output), and one doesn't. It would be sufficient to have one copy of each of these methods. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http:</pre> Knut Anders Hatlen (JIRA 2012-05-25T11:54:23 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.apache.db.derby.devel