Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

Unhandled exception in execution #xxx: 42702: column reference "DatabasePath_Text" is ambiguous



  • Npgsql.PostgresException (0x80004005): 42702: column reference "DatabasePath_Text" is ambiguous
       at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
       at 
    <snip>
    Inedo.ProGet.Feeds.Docker.BlobScanner.DockerBlobScanner.ScanBlobAsync(DockerBlobs blobData, Stream blobStream, ILogSink log) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E653823\Src\src\ProGet\Feeds\Docker\BlobScanner\DockerBlobScanner.cs:line 112
    <snip>
      Exception data:
        Severity: ERROR
        SqlState: 42702
        MessageText: column reference "DatabasePath_Text" is ambiguous
        InternalPosition: 750
        InternalQuery: WITH BlobPackages_Table AS (
            SELECT * FROM jsonb_to_recordset("@BlobPackages_Table") AS ("DatabasePath_Text" VARCHAR(200), "PackageVersion_Id" INT)
        ),
        packagesToRemove AS (
            SELECT *
              FROM "DockerBlobPackages" DBP
              LEFT JOIN BlobPackages_Table BPT 
                     ON BPT."DatabasePath_Text" = DBP."DatabasePath_Text" 
                    AND BPT."PackageVersion_Id" = DBP."PackageVersion_Id"
             WHERE DBP."DockerBlob_Id" = "@DockerBlob_Id" 
               AND BPT."PackageVersion_Id" IS NULL
        ),
        deletes AS  (
            DELETE FROM "DockerBlobPackages" DBP
                  USING packagesToRemove PTR
                  WHERE DBP."DockerBlob_Id" = "@DockerBlob_Id"
                    AND DBP."DatabasePath_Text" = PTR."DatabasePath_Text" 
                    AND DBP."PackageVersion_Id" = PTR."PackageVersion_Id"
        ),
        newBlobPackages AS (
            SELECT BPT.*
              FROM BlobPackages_Table BPT
                   LEFT JOIN "DockerBlobPackages" DBP 
                          ON DBP."DockerBlob_Id" = "@DockerBlob_Id" 
                         AND BPT."DatabasePath_Text" = DBP."DatabasePath_Text" 
                         AND BPT."PackageVersion_Id" = DBP."PackageVersion_Id"
             WHERE DBP."PackageVersion_Id" IS NULL
        )
        INSERT INTO "DockerBlobPackages"
             SELECT "@DockerBlob_Id",
                    "DatabasePath_Text",
                    "PackageVersion_Id"
               FROM newBlobPackages BPT
        Where: PL/pgSQL function "DockerBlobs_RecordScanData"(integer,xml,jsonb) line 18 at SQL statement
        File: parse_relation.c
        Line: 831
        Routine: scanRTEForColumn
    

    Is it possible we have something misconfigured on our Aurora Postgres instance? Or is this a bug in the application?

    Version 2025.25 (Build 11)


Log in to reply
 

Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation