Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmgnq-008c4v-0I for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 20:43:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qmgnn-00Fc6B-FS for pgsql-general@arkaria.postgresql.org; Sat, 30 Sep 2023 20:43:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmgnl-00Fc4V-GH for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 20:43:02 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmgnd-007VKQ-C5 for pgsql-general@lists.postgresql.org; Sat, 30 Sep 2023 20:42:59 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 8A7E43201227; Sat, 30 Sep 2023 16:40:40 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sat, 30 Sep 2023 16:40:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm1; t= 1696106440; x=1696192840; bh=Y0kcFm5ZDLrCghbj1MG0XPwX0k3Frv5vLZB kIjQIWvY=; b=AOPua29H29GQA3Z/Fn0ShcRB/rGhZFTMKIT+Hpg+rzJmmJnhmSN dyxw0K3+os3HZEKwfPxFmcRs4JR8GYgGawqI0bs6SBKAOc3YM7QPwGYf7ymtARGx t2Jp0v2QjRUTsck2GVUi7KmcoYP/u1gP3AoxHEAfJ9TBHf5B9HEpE3OJ+8b2N4Yb FD+kOUsyCtN5Ifht1A+E0clU8YQV1BFX19dO5JUvh3wlYEGOPqbJbaSIhPUzG3vb N1isr3IclzfrcHu2HMG89Q09DlrijagyALff7MIhCV60YCPh0edONuJe1u0DERXw +wPfZR5Krhah0VU1CidS3bZVHR4BPYqASxg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1696106440; x= 1696192840; bh=Y0kcFm5ZDLrCghbj1MG0XPwX0k3Frv5vLZBkIjQIWvY=; b=h vMPUS7HSS/RtLJIQ0UJKwZy6rcVeE0jRR9m33ZzHcAChmIaSi8TmsdD1oGn7e8aL lEg6uzYui22rPeWjdMLUI2xec600S1YipT3p2L1iexSbUDG9wjRAHsFS2/2Hee1G SgFS+9htbHWQ3nRI+AggCs+MjX7m7YDssm98bzJoKbjuc5P3EHWsPM+QE9J7JBgZ kDDHQHHne/mk/PCHm9Ce2/uBobk0G4MCB/M/JZF+dvJUi/O2AcBm7J+J1pnZXvNi 4ueiTunG/VZ3AvZz0uAX8AnRF7oJzza6THTb3Isdvc5YaYiZzR2+/HVQCmBBGyJy PS2WWZyAOukkqbgFtO2hQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudefgddviecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuffvfhfhjggtgfesthejre dttddvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhl rghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeefudehkeelie fffeejfffhhefhfefhleekueehheekffevfeduvdejfedvudevueenucffohhmrghinhep mhgrghgvihgrrdhorhhgpdhpshihtghophhgrdhorhhgpdhgihhthhhusgdrtghomhenuc evlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgr nhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 30 Sep 2023 16:40:38 -0400 (EDT) Message-ID: <1aa75625-219e-45f1-bcfc-d2c9ee118cb6@aklaver.com> Date: Sat, 30 Sep 2023 13:40:37 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: cache lookup failed for function 0 To: pf@pfortin.com, pgsql-general@lists.postgresql.org References: <20230929163739.3bea46e5.pfortin@pfortin.com> <8fd58b4c-ef57-3218-b7e3-f087e15db784@aklaver.com> <20230930100132.44da3c45@pfortin.com> <20230930123527.4efb81e4@pfortin.com> <1561293.1696094414@sss.pgh.pa.us> <20230930143255.0d278307@pfortin.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <20230930143255.0d278307@pfortin.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/30/23 11:32, pf@pfortin.com wrote: > On Sat, 30 Sep 2023 13:20:14 -0400 Tom Lane wrote: > > As vanilla as it gets... Standard locale (C). The only odd thing that > happened: a system update the other day installed and started something > called tracker-miners which I was not happy with: > https://bugs.mageia.org/show_bug.cgi?id=32340 > I was quite upset that the distro guys would install/run what they thought > could be a "cool" tool (as you'll see in the above link). > >> 2. There's something wrong with your Postgres installation. > > Scary; but that's what I'm suspecting too now... The script ran on my installation also. It would seem it is something on your end. Has there been any issues with your machine and/or database e.g. crashes or other odd behavior(not counting the tracker-miners update)? FYI, since you are using psycopg2 you might want to use the built in tools for: a) Dynamic SQL https://www.psycopg.org/docs/sql.html b) COPY https://www.psycopg.org/docs/usage.html#using-copy-to-and-copy-from > > Understood; I wasn't sure which rabbit hole to go down; but this is > starting to smell like a DB issue... I'll see about re-installing the > server and pray the DB is sane... If the above tracker-miners found my > postgres installation and added something to it; then I will be EXTREMELY > upset... From here: https://github.com/GNOME/tracker-miners it looks like the software use SQLite for data storage. > > Thanks for confirming my simple SQL runs... > >> regards, tom lane > > Thanks Tom! > > -- Adrian Klaver adrian.klaver@aklaver.com