I upgraded to 25.0.11-ci12 and have the problem. Its even worst then before, the workaround doesn't work any time.
thomas_3037
@thomas_3037
Best posts made by thomas_3037
Latest posts made by thomas_3037
-
RE: proget 500 Internal server error when pushing to a proget docker feed
-
RE: proget 500 Internal server error when pushing to a proget docker feed
I dump the schema from the Database. The Function looks nearly identical. Only the varchar sizes are different.
CREATE FUNCTION public."DockerBlobs_CreateOrUpdateBlob"("@Feed_Id" integer, "@Blob_Digest" character varying, "@Blob_Size" bigint, "@MediaType_Name" character varying DEFAULT NULL::character varying, "@Cached_Indicator" boolean DEFAULT NULL::boolean, "@Download_Count" integer DEFAULT NULL::integer, "@DockerBlob_Id" integer DEFAULT NULL::integer) RETURNS integer LANGUAGE plpgsql AS $$ BEGIN SELECT "DockerBlob_Id" INTO "@DockerBlob_Id" FROM "DockerBlobs" WHERE ("Feed_Id" = "@Feed_Id" OR ("Feed_Id" IS NULL AND "@Feed_Id" IS NULL)) AND "Blob_Digest" = "@Blob_Digest"; WITH updated AS ( UPDATE "DockerBlobs" SET "Blob_Size" = "@Blob_Size", "MediaType_Name" = COALESCE("@MediaType_Name", "MediaType_Name"), "Cached_Indicator" = COALESCE("@Cached_Indicator", "Cached_Indicator") WHERE ("Feed_Id" = "@Feed_Id" OR ("Feed_Id" IS NULL AND "@Feed_Id" IS NULL)) AND "Blob_Digest" = "@Blob_Digest" RETURNING * ) INSERT INTO "DockerBlobs" ( "Feed_Id", "Blob_Digest", "Download_Count", "Blob_Size", "MediaType_Name", "Cached_Indicator" ) SELECT "@Feed_Id", "@Blob_Digest", COALESCE("@Download_Count", 0), "@Blob_Size", "@MediaType_Name", COALESCE("@Cached_Indicator", 'N') WHERE NOT EXISTS (SELECT * FROM updated) RETURNING "DockerBlob_Id" INTO "@DockerBlob_Id"; RETURN "@DockerBlob_Id"; END $$;
and the table schema
proget=# \d "DockerBlobs" Table "public.DockerBlobs" Column | Type | Collation | Nullable | Default --------------------+--------------------------+-----------+----------+------------------------------ Feed_Id | integer | | | Blob_Digest | character varying(128) | | not null | Download_Count | integer | | not null | LastRequested_Date | timestamp with time zone | | | Blob_Size | bigint | | not null | Cached_Indicator | boolean | | not null | MediaType_Name | character varying(255) | | | DockerBlob_Id | integer | | not null | generated always as identity LastScan_Date | timestamp with time zone | | | Indexes: "PK__DockerBlobs" PRIMARY KEY, btree ("DockerBlob_Id") "IX__DockerBlobs__Blob_Digest" btree ("Blob_Digest") "UQ__DockerBlobs" UNIQUE CONSTRAINT, btree ("Feed_Id", "Blob_Digest") Foreign-key constraints: "FK__DockerBlobs__Feeds" FOREIGN KEY ("Feed_Id") REFERENCES "Feeds"("Feed_Id") ON DELETE CASCADE Referenced by: TABLE ""DockerImageLayers"" CONSTRAINT "FK__DockerBlobIndex__DockerBlobs" FOREIGN KEY ("DockerBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE TABLE ""DockerBlobInfos"" CONSTRAINT "FK__DockerBlobInfos__DockerBlobs" FOREIGN KEY ("DockerBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE TABLE ""DockerBlobPackages"" CONSTRAINT "FK__DockerBlobPackages__DockerBlobs" FOREIGN KEY ("DockerBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE TABLE ""DockerImages"" CONSTRAINT "FK__DockerImages__DockerBlobs" FOREIGN KEY ("ContainerConfigBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE
-
RE: proget 500 Internal server error when pushing to a proget docker feed
Hey Fritz,
a colleague find out that the parameter "--compression-format zstd:chunked" in the podman push command helped.
You can also set this option globally.
# cat ~/.config/containers/containers.conf [engine] compression_format = "zstd:chunked"
Its a workaround, but it helped.
Thanks,
Marc -
Debian flat repository format
Hi,
has someone used a debian connector with a debian repository which is in flat repository format
(described here https://wiki.debian.org/DebianRepository/Format#Flat_Repository_Format )I would too use a repository which came from opensuse build service (https://ftp.gwdg.de/pub/opensuse/repositories/home:/alvistack/Debian_12/). The feed always reported a 404 error.
In the connector i configured
./
as distribution. On an debian server it worked.Thanks
Marc