From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id eP3ZMoX0wWBPFAEAgWs5BA (envelope-from ) for ; Thu, 10 Jun 2021 13:16:21 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id iFVYLoX0wWBQSwAAB5/wlQ (envelope-from ) for ; Thu, 10 Jun 2021 11:16:21 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id A675B159A8 for ; Thu, 10 Jun 2021 13:16:19 +0200 (CEST) Received: from localhost ([::1]:44376 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lrIfY-00066e-PW for larch@yhetil.org; Thu, 10 Jun 2021 07:16:16 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:56872) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lrIfL-00066Q-1Y for bug-guix@gnu.org; Thu, 10 Jun 2021 07:16:03 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:52259) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1lrIfK-00067y-Qo for bug-guix@gnu.org; Thu, 10 Jun 2021 07:16:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1lrIfJ-0007IZ-VJ for bug-guix@gnu.org; Thu, 10 Jun 2021 07:16:01 -0400 X-Loop: help-debbugs@gnu.org Subject: bug#48945: PostgreSQL + Cuirass Errors Resent-From: Eric Brown Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Thu, 10 Jun 2021 11:16:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 48945 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: 48945@debbugs.gnu.org X-Debbugs-Original-To: bug-guix@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.162332370427970 (code B ref -1); Thu, 10 Jun 2021 11:16:01 +0000 Received: (at submit) by debbugs.gnu.org; 10 Jun 2021 11:15:04 +0000 Received: from localhost ([127.0.0.1]:35571 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lrIeN-0007H3-RX for submit@debbugs.gnu.org; Thu, 10 Jun 2021 07:15:04 -0400 Received: from lists.gnu.org ([209.51.188.17]:60046) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lrIeL-0007Gv-Vv for submit@debbugs.gnu.org; Thu, 10 Jun 2021 07:15:02 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:56656) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lrIeL-0005xW-Px for bug-guix@gnu.org; Thu, 10 Jun 2021 07:15:01 -0400 Received: from out2-smtp.messagingengine.com ([66.111.4.26]:56373) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lrIeJ-0005O1-K2 for bug-guix@gnu.org; Thu, 10 Jun 2021 07:15:01 -0400 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 158D85C0228 for ; Thu, 10 Jun 2021 07:14:57 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 10 Jun 2021 07:14:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ericcbrown.com; h=from:to:subject:date:message-id:mime-version:content-type; s= fm2; bh=xxLSDyUTA4606cdYEMm5rSrALCOvvJw9gs4FTlhrMLs=; b=q7emE21u cDNioKpVf29yC/wBdHp7SBC+XaxLDlhdC/gJLJMCVfPOFxEaZA9iICFIUihVN921 j7F7XVyiGVbQeFTi7dNAp6D2CNwTNUvmyPG2qQYYWjBSNaS2A+U0PFOl7oYP4jdp EEj4XEU/uM9QG3S2C6zIPsBMgWk+iLZxodzwhOKru1mEqVPte3aniQHI3MQEeP/v 015lslscX7nXE2fo1egQitPxGgDHvF3gUvvoUgEd4C0qHUWx9qGLah1v8jodnZQY UFLW22lPc6gmIfpsbGiuVydXT8pKi+lUwEnfqtOekx/IzJ+UGZXBUmV3c5KeBtCn OUbDyxVCQHLvwg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:message-id :mime-version:subject:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=xxLSDyUTA4606cdYEMm5rSrALCOvv Jw9gs4FTlhrMLs=; b=P26+MEgaZ9ObO+pTcZ2BvJ3kBFKscBaWIlxSbDMTFrplC a0b0dRm1pFLLoLxLRoigQ4dnpzZXf05XxxnnEV36IGSpTNgnPJJdfTFj9lyh0P5S fEx8BckZps3ZQRCEb6VjMWHrHUSrSlt+GKT6+B6ZRMEzZ6QR4PzNLoEHvEHioqLa FbTygXqyuwiy9osradNsJn/fWq2xG3sFCkLKO8G/swOV/jRsJQnvsA46/LJg4bHu DnJ60LklK6S0kJSTydYwpVXtcpzDlBLIgQq2swtd7dL363aEPaB+Xrh+4EZpM+r6 L8mv+yGL+F7eD19VWdRSFg0tX+A0aN3arwcWhXlng== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrfedufedgfeejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefhvffufffkfgggtgesthdtredttd ertdenucfhrhhomhepgfhrihgtuceurhhofihnuceovggtsghrohifnhesvghrihgttggs rhhofihnrdgtohhmqeenucggtffrrghtthgvrhhnpedvveetuefhleetuedvhfegheffve ffteefkeduleektdffjefhgeetveejiefgvdenucevlhhushhtvghrufhiiigvpedtnecu rfgrrhgrmhepmhgrihhlfhhrohhmpegvtggsrhhofihnsegvrhhitggtsghrohifnhdrtg homh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA for ; Thu, 10 Jun 2021 07:14:56 -0400 (EDT) From: Eric Brown Mail-reply-to: Eric Brown Mail-followup-to: Eric Brown Date: Thu, 10 Jun 2021 06:14:55 -0500 Message-ID: <87h7i6otsg.fsf@ericcbrown.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=66.111.4.26; envelope-from=ecbrown@ericcbrown.com; helo=out2-smtp.messagingengine.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-guix@gnu.org List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-guix-bounces+larch=yhetil.org@gnu.org Sender: "bug-Guix" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1623323781; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:resent-cc:resent-from:resent-sender: resent-message-id:list-id:list-help:list-unsubscribe:list-subscribe: list-post:dkim-signature; bh=xxLSDyUTA4606cdYEMm5rSrALCOvvJw9gs4FTlhrMLs=; b=jpGSGPZsqB6NOTaThKqZ/DNppzWFzo1ed097xGlG7DpI4YsyKTiB+Z+1AfZO4+bOTvrvOI yV18auSQCw8vjCEMusM/3mHry14oJylY5X7K3nUWLrXmG0bvNRPtIpMuqyVpGPTS33qgq2 +M1n6UJ9Re49dQoy58J7EgUk96g8lN8geqHD0FRXtkyD4KaGdD6M+uV+H6EEeHfWV0M9BY Uib3238kVGHfCJFC7a80e5haDy1tbR87QihDYduuTW6A+93MZWGJzV8gvOTdBBawbAhXMf GwzjBqlk1y9uqU/JDDyMosgxKD7FoERoz7PMuNG8D/0KRqgtvVaMg2d9NbXwpQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1623323781; a=rsa-sha256; cv=none; b=O0TYtvL+lfvygwLLSx+/WUfgAAy/cZg03tU/99gdZ/F58LhS8C2qMsUXR5lboBfPANwvBb jFfQHB7u3pFOBBqg/2wvKEb3Tc8Reb8YfVqepOTHwiJ8hLZ/81t2+9apq6ie6cxvXwFBYr 4dgQxQOIMR+rdBQXoxqUsmESMcoOMO066A6E3dSm8bwpAv6tDBL/f9koE1C8SnxHp2yz7t 7LzVlx0sJJf4hT9Bhv/XxP0VGlf/JHFIs7f6gH90m4A0OU7OJnS+uNxwdeX4P8BLqKpUIb DDI8tgn2uFctTmTty/NrAdPoZ2coigrYFvIbxIvX4hqTpvzvwgyn3c9BCU6WwA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=ericcbrown.com header.s=fm2 header.b=q7emE21u; dkim=fail ("headers rsa verify failed") header.d=messagingengine.com header.s=fm3 header.b=P26+MEga; dmarc=none; spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Migadu-Spam-Score: -1.43 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=ericcbrown.com header.s=fm2 header.b=q7emE21u; dkim=fail ("headers rsa verify failed") header.d=messagingengine.com header.s=fm3 header.b=P26+MEga; dmarc=none; spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Migadu-Queue-Id: A675B159A8 X-Spam-Score: -1.43 X-Migadu-Scanner: scn1.migadu.com X-TUID: GPu87ueUpDBi Hello: Executive Summary: - Can't reinstall Cuirass and/or PostgreSQL - Divide by 0 error reported by postgres when computing metrics Details: I am having issues reconfiguring Cuirass and PostgreSQL . I wonder if these are related to several issues in PostgreSQL, and seem to occur when I reconfigure either cuirass and/or postgres without Cuirass present, i.e. my "database server" /etc/config.scm: ---------------- (define %cuirass-specs #~(list (specification (name "my-cbc") (build '(packages "cbc"))) (specification (name "my-ipopt") (build '(packages "ipopt"))) (specification (name "my-linux-libre") (build '(packages "linux-libre"))) (specification (name "my-openblas-ilp64") (build '(packages "openblas-ilp64"))) (specification (name "my-qtbase") (build '(packages "qtbase"))) (specification (name "my-sylpheed") (build '(packages "sylpheed"))) (specification (name "my-texlive") (build '(packages "texlive"))))) (service cuirass-service-type (cuirass-configuration (specifications %cuirass-specs))) An example session trying to get cuirass re-installed: 1. Comment out Cuirass in /etc/config.scm and reconfigure building /gnu/store/9nmk3q8nwk51wqanpw4a5agwak0yfhpj-upgrade-shepherd-services.scm.drv... shepherd: Removing service 'cuirass-web'... shepherd: Done. shepherd: Removing service 'postgres-roles'... shepherd: Done. shepherd: Removing service 'cuirass'... shepherd: Done. shepherd: Removing service 'postgres'... shepherd: Done. shepherd: Service host-name has been started. shepherd: Service user-homes has been started. shepherd: Service sysctl has been started. shepherd: Service host-name has been started. shepherd: Service term-auto could not be started. To complete the upgrade, run 'herd restart SERVICE' to stop, upgrade, and restart each service that was not automatically restarted. Run 'herd status' to view the list of services on your system 2) At shell: # rm -rf /var/log/cuirass /var/log/cuirass.log* /var/log/cuirass.log /var/log/cuirass-web.log /var/cache/cuirass /var/lib/postgresql/data /var/lib/cuirass 3) Reboot 4) Check no files above are regenerated, e.g. by other services requiring postgresql (none found) 5) Re-enable Cuirass in /etc/config.scm, reconfigure: (frequently observed error at end of this item) selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default timezone ... US/Central selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... sh: locale: command not found 2021-06-10 05:57:26.532 CDT [1370] WARNING: no usable system locales were found ok syncing data to disk ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: /gnu/store/jsa77nkqcvsck4ksvm2b8sccl174hai4-postgresql-10.17/bin/pg_ctl -D /var/lib/postgresql/data -l logfile start The following derivation will be built: /gnu/store/bmzhdkki40d8y6d6n9a3gw4g70xmv824-install-bootloader.scm.drv building /gnu/store/bmzhdkki40d8y6d6n9a3gw4g70xmv824-install-bootloader.scm.drv... guix system: bootloader successfully installed on '/boot/efi' shepherd: Service host-name has been started. shepherd: Service user-homes has been started. shepherd: Service sysctl has been started. shepherd: Service host-name has been started. shepherd: Service term-auto could not be started. guix system: warning: exception caught while executing 'start' on service 'postgres': Throw to key `%exception' with args `("#<&invoke-error program: \"/gnu/store/4x3h2096cvzvq65wv40a4acwdyks9ivc-pg_ctl-wrapper\" arguments: (\"start\") exit-status: 1 term-signal: #f stop-signal: #f>")'. guix system: warning: some services could not be upgraded hint: To allow changes to all the system services to take effect, you will need to reboot. 6) Reboot 7) telnet localhost 5432 telnet localhost 5432 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused -------- I am also observing divide-by-zero errors reported by a PG process when computing metrics. Perhaps it is ignorable, but it seems to throw a Scheme "stack trace" that doesn't look good. I was unable to capture the specific message due to thrashing to restart Curirass and the DB. I am able to reproduce this on several machines, this is my third attempt to install on a fresh machine, use as I expect (ability to add/remove/reconfigure services) etc. This may be a red herring, but I can't help but feel that postgres is getting pulled in from other services as well, and that there may be a collision (e.g. PostgreSQL 10 and 13 both seem to get referenced.) I have stripped this system back to (essentially) bare-bones.scm, and see that PostgreSQL is even referenced by networkmanager package/service. (Which I am loathe to revert to dhcp since it handles wireguard. :-( ) Best regards Eric PS I would add that i have seen an error like: guix system: warning: exception caught while executing 'start' on service 'postgres': Throw to key `%exception' with args `("#<&invoke-error program: \"/gnu/store/4x3h2096cvzvq65wv40a4acwdyks9ivc-pg_ ctl-wrapper\" arguments: (\"start\") exit-status: 1 term-signal: #f stop-signal: #f>")'. in another context, it was for nginx but a reboot fixed that and I can serve pages.