Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jle8O-0005AM-Mx for pljava-dev@arkaria.postgresql.org; Wed, 17 Jun 2020 19:54:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jle8N-0000wL-Bk for pljava-dev@arkaria.postgresql.org; Wed, 17 Jun 2020 19:54:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jle8N-0000wD-7D for pljava-dev@lists.postgresql.org; Wed, 17 Jun 2020 19:54:07 +0000 Received: from anastigmatix.net ([68.171.219.55]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jle8J-0005qb-Na for pljava-dev@lists.postgresql.org; Wed, 17 Jun 2020 19:54:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:Cc:References:To:Subject:From:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=eXhg8ApJwEApY5MOUjZ32eH72GTPRnuWB9pyJqPatnM=; b=ctGShGY0VZYGFTukH34KSnY3ru GShEBRxr+VTAtGo8zSwSnbY+kR36cBgMiW456jHrJNh/WPRTLHi/KQN7ldSWgPqMNmVwS0xTNY3SG 1IC7uNjlzByp+a5uvc54L/36HZOUM1durMLnukHhxp3DPshyyCJEULuHNflKlhZg57NOaPT5FwxCQ zxsHdrumeKD1xR1qGioc94ZzEFAZoQiv51dZLXX/AGpuuAzJcW9Sbog/xQ5Rn33DEGq+DezlSbYEr udH/DyT7/C87qAFMyeeowdijHYVtaxlrIhDZ2y9bBibHQx6NKfE+1LSLB+plyZ5dfz2gSbyMo1Y5f FVmWw3fw==; Received: from [184.19.31.139] (port=34073) by bay.acenet.us with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.93) (envelope-from ) id 1jle8G-0018oY-G4; Wed, 17 Jun 2020 15:54:00 -0400 From: Chapman Flack Subject: Re: Detecting test failures reported as warnings To: Kartik Ohri References: <5EC17E17.7070002@anastigmatix.net> <5ED270BA.9010001@anastigmatix.net> <5ED3D488.1010401@anastigmatix.net> <5ED474CA.3000106@anastigmatix.net> <5ED4EA10.4030801@anastigmatix.net> <5ED7E74B.9020800@anastigmatix.net> <5EDA576E.2000204@anastigmatix.net> <5EDBA5D9.8090506@anastigmatix.net> <5EE7AE8C.2040201@anastigmatix.net> <5EEA6F85.9040009@anastigmatix.net> Cc: pljava-dev@lists.postgresql.org Message-ID: <5EEA74D7.60302@anastigmatix.net> Date: Wed, 17 Jun 2020 15:53:59 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-95.0 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - lists.postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap@anastigmatix.net X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: X-From-Rewrite: unmodified, already matched List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 06/17/20 15:42, Kartik Ohri wrote: >> There's a lot to like about a Java and JDBC approach. It shouldn't be hard >> to get off the ground, JDBC has a nice standard API for finding out about >> warnings (and reading through the pgJDBC code, I believe it is implemented, >> though I haven't done a test yet). >> >> Later on, as the prerequisites for migrating to TAP get accomplished, >> that code could just be evolved to match. >> > As of now, setting client log level seems to work very well. Should I try > to work out this approach or go ahead? That sounds adequate for now. Especially if log_min_messages is still at INFO (or could even go finer than that), and you can limit just the client messages to warning, use that to detect success/failure, but put the backend log into the build log. Regards, -Chap