Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B448FCA6B for ; Thu, 7 Jun 2012 15:14:23 +0000 (UTC) Received: (qmail 78652 invoked by uid 500); 7 Jun 2012 15:14:23 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 78620 invoked by uid 500); 7 Jun 2012 15:14:23 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 78613 invoked by uid 99); 7 Jun 2012 15:14:23 -0000 Received: from issues-vm.apache.org (HELO issues-vm) (140.211.11.160) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jun 2012 15:14:23 +0000 Received: from isssues-vm.apache.org (localhost [127.0.0.1]) by issues-vm (Postfix) with ESMTP id 2AB6B140BEF for ; Thu, 7 Jun 2012 15:14:23 +0000 (UTC) Date: Thu, 7 Jun 2012 15:14:23 +0000 (UTC) From: "Mamta A. Satoor (JIRA)" To: derby-dev@db.apache.org Message-ID: <1148113379.48102.1339082063177.JavaMail.jiratomcat@issues-vm> In-Reply-To: <202816138.6641.1320674931639.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Comment Edited] (DERBY-5494) Same value returned by successive calls to a sequence generator flanking an unorderly shutdown. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-5494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13291063#comment-13291063 ] Mamta A. Satoor edited comment on DERBY-5494 at 6/7/12 3:13 PM: ---------------------------------------------------------------- For both identity column and sequences, I ran two kinds of tests, Here is what I got for 10.9 release candidate vs 10.8.1.2. I have run 3 times each of these 4 tests. The tests were run with write caching disabled. Identity test(default behavior. I haven't given any parameters for preallocation number, number of threads, number of tables or number of inserts per transaction) java -Dderby.system.home=./systest/db1 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,identityTest=1 -gen b2b ----------------------------------------------------------------------------------------------------------- 10.9| 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 5015 | 83.58333333333333 | 3889 | 64.81666666666666 ----------------------------------------------------------------------------------------------------------- 4697 | 78.28333333333333 | 4578 | 76.3 ----------------------------------------------------------------------------------------------------------- 5150 | 85.83333333333333 | 5016 | 83.6 ----------------------------------------------------------------------------------------------------------- Sequence test(default behavior. I haven't given any parameters for preallocation number, number of threads, number of tables or number of inserts per transaction) java -Dderby.system.home=./systest/db4 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,identityTest=0 -gen b2b ----------------------------------------------------------------------------------------------------------- 10.9| 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 5228 | 87.13333333333334 | 4330 | 72.16666666666667 ----------------------------------------------------------------------------------------------------------- 5206 | 86.76666666666667 | 5026 | 83.76527057882369 ----------------------------------------------------------------------------------------------------------- 5010 | 83.5 | 4489 | 74.81541974300428 ----------------------------------------------------------------------------------------------------------- Identity test(preallocation of 1, 1 thread, 1 table, inserts per transaction 100) java -Dderby.system.home=./systest/db7 -Dderby.language.sequence.preallocator=1 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=1,tablesPerGenerator=1,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 ----------------------------------------------------------------------------------------------------------- 10.9| 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 1537 | 25.616666666666667 | 1086 | 18.099698338361026 ----------------------------------------------------------------------------------------------------------- 1628 | 27.133333333333333 | 1518 | 25.3 ----------------------------------------------------------------------------------------------------------- 1514 | 25.230810252308103 | 1472 | 24.533333333333335 ----------------------------------------------------------------------------------------------------------- Sequence test(preallocation of 1, 1 thread, 1 table, inserts per transaction 100) java -Dderby.system.home=./systest/db11 -Dderby.language.sequence.preallocator=1 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=1,tablesPerGenerator=1,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 ----------------------------------------------------------------------------------------------------------- 10.9| 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 50 | 0.8333333333333334 | 3054 | 50.9 ----------------------------------------------------------------------------------------------------------- 47 | 0.7833333333333333 | 3033 | 50.55 ----------------------------------------------------------------------------------------------------------- 49 | 0.8166666666666667 | 3000 | 50.0 ----------------------------------------------------------------------------------------------------------- was (Author: mamtas): For both identity column and sequences, I ran two kinds of tests, Here is what I got for 10.9 release candidate vs 10.8.1.2. I have run 3 times each of these 4 tests. The tests were run with write caching disabled. Identity test(default behavior. I haven't given any parameters for preallocation number, number of threads, number of tables or number of inserts per transaction) java -Dderby.system.home=./systest/db1 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,identityTest=1 -gen b2b ----------------------------------------------------------------------------------------------------------- 10.9| 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 5015 | 83.58333333333333 | 3889 | 64.81666666666666 ----------------------------------------------------------------------------------------------------------- 4697 | 78.28333333333333 | 4578 | 76.3 ----------------------------------------------------------------------------------------------------------- 5150 | 85.83333333333333 | 5016 | 83.6 ----------------------------------------------------------------------------------------------------------- Sequence test(default behavior. I haven't given any parameters for preallocation number, number of threads, number of tables or number of inserts per transaction) java -Dderby.system.home=./systest/db4 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,identityTest=0 -gen b2b ----------------------------------------------------------------------------------------------------------- 10.9 | 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 5228 | 87.13333333333334 | 4330 | 72.16666666666667 ----------------------------------------------------------------------------------------------------------- 5206 | 86.76666666666667 | 5026 | 83.76527057882369 ----------------------------------------------------------------------------------------------------------- 5010 | 83.5 | 4489 | 74.81541974300428 ----------------------------------------------------------------------------------------------------------- Identity test(preallocation of 1, 1 thread, 1 table, inserts per transaction 100) java -Dderby.system.home=./systest/db7 -Dderby.language.sequence.preallocator=1 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=1,tablesPerGenerator=1,insertsPerTransaction=100,identityTest=1 -gen b2b -threads 1 ----------------------------------------------------------------------------------------------------------- 10.9 | 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 1537 | 25.616666666666667 | 1086 | 18.099698338361026 ----------------------------------------------------------------------------------------------------------- 1628 | 27.133333333333333 | 1518 | 25.3 ----------------------------------------------------------------------------------------------------------- 1514 | 25.230810252308103 | 1472 | 24.533333333333335 ----------------------------------------------------------------------------------------------------------- Sequence test(preallocation of 1, 1 thread, 1 table, inserts per transaction 100) java -Dderby.system.home=./systest/db11 -Dderby.language.sequence.preallocator=1 org.apache.derbyTesting.perf.clients.Runner -driver org.apache.derby.jdbc.EmbeddedDriver -init -load seq_gen -load_opts debugging=0,numberOfGenerators=1,tablesPerGenerator=1,insertsPerTransaction=100,identityTest=0 -gen b2b -threads 1 ----------------------------------------------------------------------------------------------------------- 10.9 | 10.8 ----------------------------------------------------------------------------------------------------------- - of transactions | Average Thruput | - of transactions | Average Thruput ----------------------------------------------------------------------------------------------------------- 50 | 0.8333333333333334 | 3054 | 50.9 ----------------------------------------------------------------------------------------------------------- 47 | 0.7833333333333333 | 3033 | 50.55 ----------------------------------------------------------------------------------------------------------- 49 | 0.8166666666666667 | 3000 | 50.0 ----------------------------------------------------------------------------------------------------------- > Same value returned by successive calls to a sequence generator flanking an unorderly shutdown. > ----------------------------------------------------------------------------------------------- > > Key: DERBY-5494 > URL: https://issues.apache.org/jira/browse/DERBY-5494 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.9.1.0 > Reporter: Rick Hillegas > Assignee: Mike Matrigali > Labels: derby_backport_reject_10_8, derby_triage10_9 > Fix For: 10.9.1.0, 10.10.0.0 > > Attachments: derby-5494_3.diff, derby-5494_diff_1a.txt, derby-5494_diff_2.txt > > > The following sequence of steps causes a sequence generator to return the same value on successive NEXT VALUE FOR calls. > 1) Bring up ij and issue the following commands: > connect 'jdbc:derby:db;create=true'; > create sequence s; > values next value for s; > 2) Control-c out of ij so that the engine comes down hard without an orderly shutdown. > 3) Now bring up ij again and issue the following commands: > connect 'jdbc:derby:db'; > values next value for s; > Thanks to Knut for finding this one. -- 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