[oi-dev] couchdb-31 is broken

[Marcel Telka]

On Fri, Feb 23, 2024 at 01:02:52AM +0100, Marcel Telka wrote:
> On Tue, Feb 20, 2024 at 09:58:02AM +0100, Marcel Telka wrote:
> > the couchdb-31 package is broken at the ips server:
> > 
> > Errors were encountered while attempting to retrieve package or file data for
> > the requested operation.
> > Details follow:
> > 
> > pkg://openindiana.org/database/couchdb-31@3.1.2,5.11-2023.0.0.0:20230609T222502Z
> >   Invalid content: manifest hash failure: fmri: pkg://openindiana.org/database/couchdb-31@3.1.2,5.11-2023.0.0.0:20230609T222502Z 
> > expected: 28185b5f27c3c0ce9ea1d8f129e0e5763f53e8ae computed: b371cc90d6fd42c5bafa55f85afb183b59c23960. (happened 4 times)
> 
> The problem is in the publisher/openindiana.org/catalog/catalog.base.C
> file.  However I do not know what is the proper way to fix it.
> Maybe simple sed would be enough?
> 
> sed -i -e \
> 	's/28185b5f27c3c0ce9ea1d8f129e0e5763f53e8ae/b371cc90d6fd42c5bafa55f85afb183b59c23960/' \
> 	publisher/openindiana.org/catalog/catalog.base.C

No, sed it not the proper way to fix this, because the file seems to
contain a signature (see below).

I ran `pkgrepo rebuild -s REPO -p openindiana.org --no-index` and I
found that it:

* removed the publisher/openindiana.org/index directory (a bit
  unexpected)
* removed all publisher/openindiana.org/catalog/update.* files
* modified publisher/openindiana.org/catalog/catalog.summary.C - with
  mostly not very importand changes
* updated publisher/openindiana.org/catalog/catalog.attrs - because
  other files in catalog changed/removed
* updated publisher/openindiana.org/catalog/catalog.base.C

and this revealed that there are six corrupted packages in the repo (the
list is below) and the corruption happened after 2023-10-11 21:22:16+0000.
Please note that luckily most corruptions are hidden because we do have
newer correct version of affecter packages in the repo, except
database/couchdb-31.


Here are differences between the old catalog.base.C and the new one:

$ diff -u <(jq < catalog.base.C-old) <(jq < catalog.base.C)
--- /dev/fd/63  2024-02-23 12:57:39.795696894 +0100
+++ /dev/fd/62  2024-02-23 12:57:39.795705684 +0100
@@ -66832,7 +66832,7 @@
     ],
     "database/couchdb-31": [
       {
-        "signature-sha-1": "28185b5f27c3c0ce9ea1d8f129e0e5763f53e8ae",
+        "signature-sha-1": "b371cc90d6fd42c5bafa55f85afb183b59c23960",
         "version": "3.1.2,5.11-2023.0.0.0:20230609T222502Z"
       }
     ],
@@ -121060,7 +121060,7 @@
     ],
     "developer/golang-119": [
       {
-        "signature-sha-1": "a22c9e5526b28eeb356a019a170848dd9cff0028",
+        "signature-sha-1": "84d0f3564243569662206ff01060c1d85a19060e",
         "version": "1.19.13,5.11-2023.0.0.0:20230907T190550Z"
       },
       {
@@ -121070,7 +121070,7 @@
     ],
     "developer/golang-120": [
       {
-        "signature-sha-1": "cefb854835a501b27a457630019ebc73cb3c099d",
+        "signature-sha-1": "e3d9c336f4cb17b3e0a8ea59c8a2003c4eae6db1",
         "version": "1.20.10,5.11-2023.0.0.0:20231011T212216Z"
       },
       {
@@ -121092,7 +121092,7 @@
     ],
     "developer/golang-121": [
       {
-        "signature-sha-1": "08961188c8156f97513be69282778fce0dea5ecd",
+        "signature-sha-1": "a19e750d1baa659c68c26e98ab65dcdad8990a15",
         "version": "1.21.3,5.11-2023.0.0.0:20231011T212236Z"
       },
       {
@@ -212320,7 +212320,7 @@
     ],
     "editor/codeblocks": [
       {
-        "signature-sha-1": "6ec033933597a8540df2a2948648736769fbf62a",
+        "signature-sha-1": "292dbc04410f76a4722345133e6a71c5a5e77423",
         "version": "20.3,5.11-2023.0.0.3:20230511T194351Z"
       },
       {
@@ -441060,7 +441060,7 @@
     ],
     "library/readline": [
       {
-        "signature-sha-1": "cb02cbdaa6cda8a1ed1915185fe38015a6dce552",
+        "signature-sha-1": "a159de951797140d09295c42401e58092f2c8fd9",
         "version": "6.3,5.11-2023.0.0.5:20230906T050309Z"
       },
       {
@@ -747074,6 +747074,6 @@
     ]
   },
   "_SIGNATURE": {
-    "sha-1": "d7273c3ee40be8cd541f8993658d7f0412648005"
+    "sha-1": "5007481277faa15f0386f02ad58a7b3511ee50a9"
   }
 }
$


-- 
+-------------------------------------------+
| Marcel Telka   e-mail:   marcel at telka.sk  |
|                homepage: http://telka.sk/ |
+-------------------------------------------+