Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 87CA4200C04 for ; Mon, 9 Jan 2017 11:35:01 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 869BE160B3E; Mon, 9 Jan 2017 10:35:01 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id B15F7160B4C for ; Mon, 9 Jan 2017 11:35:00 +0100 (CET) Received: (qmail 84919 invoked by uid 500); 9 Jan 2017 10:34:59 -0000 Mailing-List: contact dev-help@polygene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@polygene.apache.org Delivered-To: mailing list dev@polygene.apache.org Received: (qmail 84210 invoked by uid 99); 9 Jan 2017 10:34:59 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jan 2017 10:34:59 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 4B6662C2A6B for ; Mon, 9 Jan 2017 10:34:59 +0000 (UTC) Date: Mon, 9 Jan 2017 10:34:59 +0000 (UTC) From: "Paul Merlin (JIRA)" To: dev@polygene.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Comment Edited] (POLYGENE-222) Indexing-SQL is broken MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Mon, 09 Jan 2017 10:35:01 -0000 [ https://issues.apache.org/jira/browse/POLYGENE-222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15811410#comment-15811410 ] Paul Merlin edited comment on POLYGENE-222 at 1/9/17 10:34 AM: --------------------------------------------------------------- Instructions for reproducing, with PostgreSQL 9.x installed: Create test user {code} createuser -A -D -P -E -W jdbc_test_login {code} Create test db {code} createdb -w -O jdbc_test_login jdbc_test_db && psql -w jdbc_test_db -c "CREATE EXTENSION ltree;" {code} One-liner for easy cleanup in case of stale data (e.g. killed test): {code} dropdb jdbc_test_db && createdb -w -O jdbc_test_login jdbc_test_db && psql -w jdbc_test_db -c "CREATE EXTENSION ltree;" {code} The build system and project name have changed along the changes that affected Indexing SQL but the following command works along the whole history: {code} ./gradlew -p extensions/indexing-sql test {code} was (Author: eskatos): Instructions for reproducing, with PostgreSQL 9.x installed: Create test user {code} createuser -A -D -P -E -W jdbc_test_login {code} Create test db {code} createdb -w -O jdbc_test_login jdbc_test_db && psql -w jdbc_test_db -c "CREATE EXTENSION ltree;" {code} One-liner for easy cleanup in case of stale data (e.g. killed test): {code} dropdb jdbc_test_db && createdb -w -O jdbc_test_login jdbc_test_db && psql -w jdbc_test_db -c "CREATE EXTENSION ltree;" {code} > Indexing-SQL is broken > ---------------------- > > Key: POLYGENE-222 > URL: https://issues.apache.org/jira/browse/POLYGENE-222 > Project: Polygene > Issue Type: Bug > Reporter: Paul Merlin > Fix For: 3.0 > > Attachments: indexing-sql-test-report-0984d0ba.zip > > > In POLYGENE-180 we noticed that some Indexing SQL tests were failing. But the situation is not that simple. > I bisected to find the offending commits, here are my findings: > The last good commit is [4dabe5781cd73463526951b70b097c2f0b45b320|https://github.com/apache/polygene-java/commit/4dabe5781cd73463526951b70b097c2f0b45b320]. > [d845ea705b05b3d8182086ba82979fa8332bde78|https://github.com/apache/polygene-java/commit/d845ea705b05b3d8182086ba82979fa8332bde78] is the first bad commit with these 7 tests failing: > {code} > PostgreSQLEntityFinderTest. script03 > PostgreSQLEntityFinderTest. script18 > PostgreSQLEntityFinderTest. script19 > PostgreSQLQueryTest. script03 > PostgreSQLQueryTest. script17 > PostgreSQLQueryTest. script18 > PostgreSQLQueryTest. script19 > {code} > then [5d2a62bef95828222c17c1c2b413ac43d8d2b71b|https://github.com/apache/polygene-java/commit/5d2a62bef95828222c17c1c2b413ac43d8d2b71b] made ALL tests fail > then [a5be013f39cba9642114e01486cdff0c355569f2|https://github.com/apache/polygene-java/commit/a5be013f39cba9642114e01486cdff0c355569f2] fixed some tests but the following 19 still fail: > {code} > PostgreSQLComplexQueryTest. script01 > PostgreSQLComplexQueryTest. script02 > PostgreSQLComplexQueryTest. script03 > PostgreSQLComplexQueryTest. script05 > PostgreSQLComplexQueryTest. script06 > PostgreSQLComplexQueryTest. script07 > PostgreSQLComplexQueryTest. script08 > PostgreSQLComplexQueryTest. script09 > PostgreSQLComplexQueryTest. script10 > PostgreSQLComplexQueryTest. script11 > PostgreSQLEntityFinderTest. script03 > PostgreSQLEntityFinderTest. script18 > PostgreSQLEntityFinderTest. script19 > PostgreSQLQueryTest. script03 > PostgreSQLQueryTest. script17 > PostgreSQLQueryTest. script18 > PostgreSQLQueryTest. script19 > PostgreSQLQueryTest. script29 > PostgreSQLQueryTest. script32 > {code} > then [dedb068e4b56fce8d6c21f5938396eb84da63f7c|https://github.com/apache/polygene-java/commit/] made ALL tests fail again > then [e5c57f95e199f8a79763debb2e101028f8e8f896|https://github.com/apache/polygene-java/commit/e5c57f95e199f8a79763debb2e101028f8e8f896] fixed some tests but the following 19 still fail, same as above: > {code} > PostgreSQLComplexQueryTest. script01 > PostgreSQLComplexQueryTest. script02 > PostgreSQLComplexQueryTest. script03 > PostgreSQLComplexQueryTest. script05 > PostgreSQLComplexQueryTest. script06 > PostgreSQLComplexQueryTest. script07 > PostgreSQLComplexQueryTest. script08 > PostgreSQLComplexQueryTest. script09 > PostgreSQLComplexQueryTest. script10 > PostgreSQLComplexQueryTest. script11 > PostgreSQLEntityFinderTest. script03 > PostgreSQLEntityFinderTest. script18 > PostgreSQLEntityFinderTest. script19 > PostgreSQLQueryTest. script03 > PostgreSQLQueryTest. script17 > PostgreSQLQueryTest. script18 > PostgreSQLQueryTest. script19 > PostgreSQLQueryTest. script29 > PostgreSQLQueryTest. script32 > {code} > then with [962badcea188f48da722cba396fb2478375065e7|https://github.com/apache/polygene-java/commit/962badcea188f48da722cba396fb2478375065e7] only 16 tests still fail (see POLYGENE-137): > {code} > PostgreSQLComplexQueryTest. script03 > PostgreSQLComplexQueryTest. script05 > PostgreSQLComplexQueryTest. script06 > PostgreSQLComplexQueryTest. script07 > PostgreSQLComplexQueryTest. script08 > PostgreSQLComplexQueryTest. script09 > PostgreSQLComplexQueryTest. script10 > PostgreSQLComplexQueryTest. script11 > PostgreSQLEntityFinderTest. script03 > PostgreSQLEntityFinderTest. script18 > PostgreSQLEntityFinderTest. script19 > PostgreSQLQueryTest. script03 > PostgreSQLQueryTest. script17 > PostgreSQLQueryTest. script18 > PostgreSQLQueryTest. script19 > PostgreSQLQueryTest. script29 > {code} > then with [612f952a338ef93e305b90321de04b5ccc9c7930|https://github.com/apache/polygene-java/commit/612f952a338ef93e305b90321de04b5ccc9c7930] only 9 tests still fail: > {code} > PostgreSQLComplexQueryTest. script03 > PostgreSQLComplexQueryTest. script05 > PostgreSQLComplexQueryTest. script06 > PostgreSQLComplexQueryTest. script07 > PostgreSQLComplexQueryTest. script08 > PostgreSQLComplexQueryTest. script09 > PostgreSQLComplexQueryTest. script10 > PostgreSQLComplexQueryTest. script11 > PostgreSQLQueryTest. script29 > {code} > then [def7765f4a21a8ead434a7599c75f6bffd2c165e|https://github.com/apache/polygene-java/commit/def7765f4a21a8ead434a7599c75f6bffd2c165e] made ALL tests fail again > then [f21cc656a72b6fb5fdca112b05133d7e63455a3d|https://github.com/apache/polygene-java/commit/f21cc656a72b6fb5fdca112b05133d7e63455a3d] got us back to the 9 failing tests above > then [103c59cbeb2907d0b3a132a1aa852e2e1b8585ae|https://github.com/apache/polygene-java/commit/103c59cbeb2907d0b3a132a1aa852e2e1b8585ae] made a 10th test fail: > {code} > PostgreSQLComplexQueryTest. script03 > PostgreSQLComplexQueryTest. script05 > PostgreSQLComplexQueryTest. script06 > PostgreSQLComplexQueryTest. script07 > PostgreSQLComplexQueryTest. script08 > PostgreSQLComplexQueryTest. script09 > PostgreSQLComplexQueryTest. script10 > PostgreSQLComplexQueryTest. script11 > PostgreSQLQueryTest. script29 > PostgreSQLQueryTest. script34 > {code} > That last list is what actually fails on the head of {{develop}}. > Indexing SQL extension tests need a running PostgreSQL instance properly set up. That makes asserting that changes don't break it difficult. We really need a test harness for required external services, see POLYGENE-221 -- This message was sent by Atlassian JIRA (v6.3.4#6332)