From dev-return-38965-archive-asf-public=cust-asf.ponee.io@subversion.apache.org Tue Jan 22 22:52:40 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 7F641180634 for ; Tue, 22 Jan 2019 22:52:39 +0100 (CET) Received: (qmail 29503 invoked by uid 500); 22 Jan 2019 21:52:38 -0000 Mailing-List: contact dev-help@subversion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list dev@subversion.apache.org Received: (qmail 29490 invoked by uid 99); 22 Jan 2019 21:52:38 -0000 Received: from mail-relay.apache.org (HELO mailrelay2-lw-us.apache.org) (207.244.88.137) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jan 2019 21:52:38 +0000 Received: from [172.23.17.71] (89-233-126-4.dynamic.t-2.net [89.233.126.4]) by mailrelay2-lw-us.apache.org (ASF Mail Server at mailrelay2-lw-us.apache.org) with ESMTPSA id D4BD13EAA; Tue, 22 Jan 2019 21:52:36 +0000 (UTC) Subject: Re: wc-queries-test test failure with -DSQLITE_ENABLE_STMT_SCANSTATUS To: dev@subversion.apache.org References: Cc: Thomas Deutschmann From: =?UTF-8?Q?Branko_=c4=8cibej?= Openpgp: preference=signencrypt Autocrypt: addr=brane@apache.org; prefer-encrypt=mutual; keydata= mQINBFG3qpMBEACi+jRQDd2TiYeAxVgrLZ3cyyuGOFSMh4nCyUOG9BwXC69cDLH48RcE0Mpu TFTGlfdokz6JgLKU3uqShPXiflrL6JIVnJX4rTEKRzFNkcS6Zq0PfNRnFnkwiD2KIzyAG8XE y0c1Bt7hqZ5dfXaC1b7Xo+1cnlqjdLAOnr1ruTrtfQ5sO81p9jYtARVa+iVmf8bs/FvC9Yn2 QtEDtuUfUUHx2bnB9vmh8tOjErfIcWtzCPt8uTUkmiszlkRMiB5/X97oqXlX/5dSQWE9m4M5 6Fc9ixIrmCwkF515RLrCNTv/YAtmpu4VaB0rxgTuSku0cVk83xSMrH2hNFx1fAeYBZpwp2GL ONlTy3D2N+BjWXjEUE9baGOoYM7QUbAdj4JMstSByppaAi4AiG9+raxknTWtWt2IT9LHW7Pu i6S3k4WL5jmTdQKqNQ9/+vRqiSVsA98yHQLa+s19IYh4F7WIfo2lzBAn06HEntpKS9TtV20o JyMBLOVqQP1dARWRfB0xIxGtbI61CfjEhCeG8H+UynCrHkUxgUoKsXXkI/JxsIMZ3TivFj3U MJVur7KVwg/isqqaEyMfUnCrXJxexZp8kuTjkzzvDKfYs0vHJezPQYhlqBLkK2w9VzktGjA7 lb+TO69bEyPOcBjVsCtrdYVc442/Z37G+1UV5+1X06m14Pt9UQARAQABtCBCcmFua28gxIxp YmVqIDxicmFuZUBhcGFjaGUub3JnPokCOgQTAQoAJAIbAwULCQgHAwUVCgkICwUWAgMBAAIe AQIXgAUCUbetMwIZAQAKCRAbymWGo0eUP2tOD/9KOLYfxwTcGV/Nj3lnKE4Y4gRl0r4cfnWm 1/2KyPYVsmQ8vWRUZxjuVHAvZrAkTBvlu+CVzrCWEEpCzQC/jki0xkPQchTEU2XOHQ6PzkXB 17o1NSSu/vyKynh0pXMRTHm4wZodzUw/tHn/Ism5QyRyhlYUP4mVX8v2hbN+stkJHrkdVBPm FspnFidhulUP5hr+LWz2qd+Ab8MOn3+x25jsGE8yaUiqmNdrmq/trvHPGThySa4Hz0uEkhfP K2knc6PpV5GTbeRn/J1eu17xVgXYVgko35Qwz5s/LRat+5R79tgBAL9SKFybCVBPr6/1Zp4u w9b0NcHW6t3aQHCxv8iEqxrJ7UIDhh/hXh4no0vzpPR1Cgjn6fK997WrpUyaAtlnbSH5QGad YY9rpFka3o2Gj+f+cr75hq6c7DnNJo94eGw9L0JEjfgordi8UkWErGOklnGf8N8brlVG0TdW 7KOz60m1E3UzIwd2lQd9a0zd8Mqrmn2MMPdJt4EpKQWaJsoK+FOdEBX0Ezm3StEXufe1IOG9 DihVcOnsx/G6aTS9GyKjURVt0jDB4wsVSzsRHYHmQpw7/ekvHFNKZS5yMNwSt2X/Szmk4GmV 69gaI79kf8VD87xwE31p0s0uVIVp7MTOTEYT5HUh5Rz6Rr66+vg9qgN1enMj5sh4f8krXgRR wLkCDQRRt6qTARAAnxIdGqDTC2FU9AE2ElT/m/Hs/57BwqUUb8qod3mJ6Qkp7PpHCBnvtbwm krrCsJl5rR1fliton6qoJUNCSfmcfeujcU8Be+q75rNZxIWi6AjMmyrjyMp9JIO7g/7+VYmL dm9c1wRn4QDnIKxl7qMPz9q8/OF6BGEMEW4zRL8rHvM7CCapOikHUKKq7GnZMVyYbue6KUTA Tczxjt6E9Av1QDnnW9zbW56jqUKdgpNek/bSTuef2xYEDzIzFPQREyw8E/C3xx8zZfOJ0+XV s1n39GLp3vugP5IBNE2pgqcyFtKISj1pVJgDr7zXjD92ZGS8xgqDxePTuf1LcCwd65BJNVVK IFsFicvBVhdslCZ7l8jkCuZAzYoFJZthUKuuJg1n7HYi8XLifZmun9Z3fbM5gk9/vA1rXsWt An597BACKDUkWA5tOb3Si4/MaRDiZYvzplHGc4sTn4aBIj3VFGGFNlOUPFLWjZLHdudNOBGj 3eIlz/DQZh/mwNGn5g98c3xehHnWxcXa0PsN2Xl1iRM2dec8drEVVRYaWPcOmGhKfqnlwl2z OeuST2TMcWhxKshVimR9eSt5pX1oGOD9PZ9V0gQDIr4d35UjQaW5ABCWbgTd7e3yPTlHoWx4 qyv+YoxEf6AlQ4nvE+q1s4wRBs/eNVQsROnYmhKhYPZUsDE6EocAEQEAAYkCHwQYAQoACQUC UbeqkwIbDAAKCRAbymWGo0eUPwd6D/92i5LBHSluiBdnzYH3kYlkIMjhy3lcqtxb/TWV1X/z CVpaZkEXvL9NQ44ZqfiOFB8fnaJvy+9rfIL3MwHKLVHOjsurBRP2DJ8H/EI6QuZV//Nxh66A dicXlE5SSiKQ5KcIH+eqZHa4XjVeXGeNZummrlhOv3ItKXETVhh2qeIQ/7zCjuw5rQk606+2 isg6cs4Nwtie1rXQ1KFtkTNQqWfqyM4PrEP9Bq5pWBQVkcxDsxk1Yj3A8L80IY3Hzwm8nRlq F+HkD/0IPgHICVDyiOB4XZtqVk+DHNOolCcdrFSXOcwt+qwD5zk4p0hdHKHagAPGBDXS8shm k2vaUDbKMUoVDdj579Jtp4tNOoVEEqqXspT995w7+ckbHGoQhFlSxCwtaXCr/8wwdwcCA2eO w0aLYrU04EbnH7Ryj4aTjsBGvJdmyZQT8/lTj5VARbEkNXTdTOs61pebDliyWtcF9Uz9b44p cLNniphcBO4SP/IMlEh8pBAJ1C2QlD4G90iJ1WK0MsJsUDix9Vb5s1AE6WA/Ss1iPCOdhhif eToCAwoobIipoxUZF2ik3oESskmMDolpVBiaPaFg+YPtNp/53dLap7jBNRNgyKXaGJAZaolp L+9hCU1EOWswqusDHDFSRUuYOXfuXZJxcbQUTnhQhRbvSDy3tDMRGd252Ur1sCOU5g== Organization: The Apache Software Foundation Message-ID: <5d502461-063e-61ec-9cbc-b731e0b68852@apache.org> Date: Tue, 22 Jan 2019 22:52:34 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: sl [Moving to the correct list.] On 22.01.2019 22:18, Thomas Deutschmann wrote: > Hi, > > in Gentoo Linux, wc-queries-test test is failing (verified > against v1.9.7-1.11.1: > >> START: wc-queries-test >> DBG: Using Sqlite 3.25.3 >> PASS: wc-queries-test 1: sqlite up-to-date >> PASS: wc-queries-test 2: queries are parsable >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MERGE' in explanation >> DBG: Unhandled sqlite operation 'LEFT' in explanation >> DBG: Unhandled sqlite operation 'RIGHT' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' >> DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation >> DBG: Unhandled sqlite operation 'UNION' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' >> DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation >> DBG: Unhandled sqlite operation 'UNION' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' >> DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'UNION' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'MERGE' in explanation >> DBG: Unhandled sqlite operation 'LEFT' in explanation >> DBG: Unhandled sqlite operation 'RIGHT' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'MERGE' in explanation >> DBG: Unhandled sqlite operation 'LEFT' in explanation >> DBG: Unhandled sqlite operation 'RIGHT' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'SCALAR' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' >> DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'UNION' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CO-ROUTINE' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MERGE' in explanation >> DBG: Unhandled sqlite operation 'LEFT' in explanation >> DBG: Expected 'TABLE', got 'CONSTANT' in 'SCAN CONSTANT ROW' >> DBG: Unhandled sqlite operation 'RIGHT' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MERGE' in explanation >> DBG: Unhandled sqlite operation 'LEFT' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'RIGHT' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> DBG: Unhandled sqlite operation 'CORRELATED' in explanation >> DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation >> svn_tests: E200006: STMT_FINALIZE_UPDATE_MOVE: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS update_move_list >> svn_tests: E200006: STMT_FINALIZE_UPDATE_MOVE: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS update_move_list >> svn_tests: E200006: STMT_FINALIZE_UPDATE_MOVE: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS update_move_list >> svn_tests: E200006: STMT_FINALIZE_DELETE: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS delete_list >> svn_tests: E200006: STMT_FINALIZE_DELETE: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS delete_list >> svn_tests: E200006: STMT_FINALIZE_DELETE: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS delete_list >> svn_tests: E200006: STMT_DROP_REVERT_LIST: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS revert_list >> svn_tests: E200006: STMT_DROP_REVERT_LIST: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS revert_list >> svn_tests: E200006: STMT_DROP_REVERT_LIST: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE IF EXISTS revert_list >> svn_tests: E200006: STMT_DROP_TARGETS_LIST: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE targets_list >> svn_tests: E200006: STMT_DROP_TARGETS_LIST: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE targets_list >> svn_tests: E200006: STMT_DROP_TARGETS_LIST: Uses sqlite_master with only 0 index component: ((null)) >> DROP TABLE targets_list >> svn_tests: E200042: Additional errors: >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> svn_tests: E200035: |SCAN TABLE sqlite_master >> FAIL: wc-queries-test 3: test query expectations >> PASS: wc-queries-test 4: test query duplicates >> PASS: wc-queries-test 5: test schema statistics >> PASS: wc-queries-test 6: verify queries are parsable >> END: wc-queries-test >> ELAPSED: wc-queries-test 0:00:00.167083 > After some research we found the problem causing the test failure: > > In Gentoo we are building sqlite with > >> -DSQLITE_ENABLE_STMT_SCANSTATUS > option set. If we disable that option, the test is passing. > > Downstream-bug: https://bugs.gentoo.org/605438 > >