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 1t96uS-007p1b-FV for pgsql-admin@arkaria.postgresql.org; Thu, 07 Nov 2024 18:07:07 +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 1t96uP-000mU9-N9 for pgsql-admin@arkaria.postgresql.org; Thu, 07 Nov 2024 18:07:06 +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 1t96uP-000mRJ-8D for pgsql-admin@lists.postgresql.org; Thu, 07 Nov 2024 18:07:05 +0000 Received: from mail-pf1-x42f.google.com ([2607:f8b0:4864:20::42f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t96uN-000feV-Fn for pgsql-admin@lists.postgresql.org; Thu, 07 Nov 2024 18:07:04 +0000 Received: by mail-pf1-x42f.google.com with SMTP id d2e1a72fcca58-71e52582cf8so1008357b3a.2 for ; Thu, 07 Nov 2024 10:07:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1731002822; x=1731607622; darn=lists.postgresql.org; h=mime-version:content-language:accept-language:message-id:date :thread-index:thread-topic:subject:to:from:from:to:cc:subject:date :message-id:reply-to; bh=af5WREIehchNIkHHSqlyOPz7CzZBY4xxUOf4q78Y93E=; b=mQLO7Phka7YnsjEZDjiUqByM2mq/+X6eJNXAFsd3VHXOK5UaXxR4qjWTSkW22eF+6b JBb1o2Vb1MxevEToiBWS5FhwSMfqhnKgdfEj2iS6R2xCq6cxSHJkmQuW6DNx1Zq87D/s nCBYrXmdsm8JvdEffDttVjoH5303PqFYDASSSC6IcCJQWxZmt7h2ZK7N8q0gWTATpjAe QAhm/g5YzENHOq0LxRTQ4rRiYlVuhkPYSnnwmyinoJfD6lJL2sWLg5Fz/WW2VOj4Qblo yYrs6wRAVLHV148Nqvm7B2N3igh9UBNlWIDwfRfsqpHKQTx1qV93XzhBUD6hvTXVU0Qc pw6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731002822; x=1731607622; h=mime-version:content-language:accept-language:message-id:date :thread-index:thread-topic:subject:to:from:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=af5WREIehchNIkHHSqlyOPz7CzZBY4xxUOf4q78Y93E=; b=C76RZVdh/j3Uqi67LZs6uIUx9hl5dl4cJ1stTla/Tr/zTdRcc7FOv6kV/sEBDOt4wf BCfaHt8es85rHyeEos02dWDbnyd89wk18HOGMUenQp75/mtg1D+/SpBtL8DhcWNXqQJm V2A0S6WGUUoRSemfowt6nfucozfjGMJjbmjKWQXY0kIRSCGAb8HHpCGOmCD9nBgQWFYp TnoOpcLqjOdLYbyqjzlM2ZBkvme/ohD+cu2xBxttDLXHOccwVZ2kIxlzqIw7l5iJ7Koi TduUk4R5r7eRvkbV8i/eCiG1ry+xX0BSu4bldgs5GosGdaDE8SJJNKqCAvM6ltch7n9u Dw+Q== X-Gm-Message-State: AOJu0YybrAWneZBPbGAqiYe5MLco2a3F/qCE4LHa6tsMHE9dtd3V44jy Tdan7C8QxCPZQs5hYDhurp9ypSTkqnLKRaQk0Nswv3I0cW9lVk3YbnvvJQ== X-Google-Smtp-Source: AGHT+IH3s4LN0Q4bzlm1DlFdEs6KZ9j1T9vGFQg+ZpH4W2H9kFk/u3MCR1k4dqPZb6AXnARYqAfwCQ== X-Received: by 2002:a05:6a20:9f95:b0:1d9:18b7:496 with SMTP id adf61e73a8af0-1dc20646235mr539638637.45.1731002822220; Thu, 07 Nov 2024 10:07:02 -0800 (PST) Received: from AM6PR03MB5558.eurprd03.prod.outlook.com ([2603:1026:c03:28fc::5]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-7f41f48d94bsm1731078a12.6.2024.11.07.10.07.00 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 07 Nov 2024 10:07:01 -0800 (PST) From: =?iso-8859-1?Q?P=E4r_Mattsson?= To: "pgsql-admin@lists.postgresql.org" Subject: Hi Corruption in Postgres Thread-Topic: Hi Corruption in Postgres Thread-Index: AQHbMT+KNVEZkQNcsEWv015rCrZYUQ== X-MS-Exchange-MessageSentRepresentingType: 1 Date: Thu, 7 Nov 2024 18:06:58 +0000 Message-ID: Accept-Language: sv-SE, en-US Content-Language: sv-SE X-MS-Has-Attach: X-MS-Exchange-Organization-SCL: -1 X-MS-TNEF-Correlator: X-MS-Exchange-Organization-RecordReviewCfmType: 0 x-ms-reactions: allow Content-Type: multipart/alternative; boundary="_000_AM6PR03MB55589D8CDAA42888E971C1D7A25C2AM6PR03MB5558eurp_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AM6PR03MB55589D8CDAA42888E971C1D7A25C2AM6PR03MB5558eurp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Har n=E5gon typ av korruptionsproblematik sen 1/10 p=E5 lfv produktion : pg_dump: error: Dumping the contents of table "aim_notam_originalpart" fail= ed: PQgetResult() failed. pg_dump: error: Error message from server: ERROR: unexpected chunk size 14= 08 (expected 1661) in chunk 0 of 1 for toast value 18918695 in pg_toast_181= 94 pg_dump: error: The command was: COPY aim.aim_notam_originalpart (notam_id,= part_num, created_at, e_details, canonical_filing_dtg, canonical_orig_addr= , canonical_text) TO stdout; aimdb_dump: pg_dump failed 1500000 rows Mvh P=E4r --_000_AM6PR03MB55589D8CDAA42888E971C1D7A25C2AM6PR03MB5558eurp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Har n=E5gon typ av korruptionsproblematik sen 1/10 p=E5 lfv produktio= n : 

pg_dump: error: Dumping the contents of table "aim_notam_origina= lpart" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR:  unexpected chunk si= ze 1408 (expected 1661) in chunk 0 of 1 for toast value 18918695 in pg_toas= t_18194
pg_dump: error: The command was: COPY aim.aim_notam_originalpart (notam_id,= part_num, created_at, e_details, canonical_filing_dtg, canonical_orig_addr= , canonical_text) TO stdout;
aimdb_dump: pg_dump failed


1500000 rows



Mvh P=E4r
--_000_AM6PR03MB55589D8CDAA42888E971C1D7A25C2AM6PR03MB5558eurp_--