Skip to content

Using the provided Docker image we get a Fatal Error when connecting to external database #6

@NBITDLZgit

Description

@NBITDLZgit

When starting fossology with a external database a fatal error prevents the application to start up:

`
fossology-fossology-1 | Removed 0 rows from tables with new constraints

fossology-fossology-1 | PHP Warning: pg_query(): Query failed: FEHLER: Spalte »fossdashconfig_pk« von Relation »fossdashconfig« existiert bereits in /usr/local/share/fossology/lib/php/Db/Driver/Postgres.php on line 68
fossology-fossology-1 | [2025-11-18T04:12:57.171439+00:00] /usr/local/share/fossology/lib/php/libschema.php.CRITICAL: FEHLER: Spalte »fossdashconfig_pk« von Relation »fossdashconfig« existiert bereits [] []
fossology-fossology-1 | PHP Fatal error: Uncaught Fossology\Lib\Exception: error executing: ALTER TABLE "fossdashconfig" ADD COLUMN "fossdashconfig_pk" int4 DEFAULT nextval('fossdashconfig_fossdashconfig_pk_seq'::regclass)
fossology-fossology-1 |
fossology-fossology-1 | FEHLER: Spalte »fossdashconfig_pk« von Relation »fossdashconfig« existiert bereits in /usr/local/share/fossology/lib/php/Db/DbManager.php:133
fossology-fossology-1 | Stack trace:
fossology-fossology-1 | #0 /usr/local/share/fossology/lib/php/Db/DbManager.php(192): Fossology\Lib\Db\DbManager->checkResult()
fossology-fossology-1 | #1 /usr/local/share/fossology/lib/php/libschema.php(320): Fossology\Lib\Db\DbManager->queryOnce()
fossology-fossology-1 | #2 /usr/local/share/fossology/lib/php/libschema.php(170): fo_libschema->applyTables()
fossology-fossology-1 | #3 /usr/local/lib/fossology/fossinit.php(189): fo_libschema->applySchema()
fossology-fossology-1 | #4 {main}
fossology-fossology-1 | thrown in /usr/local/share/fossology/lib/php/Db/DbManager.php on line 133
fossology-fossology-1 exited with code 255
`

... the same image runs well with the internal database. The problem is indeed that the column already exists. Unfortunately the application exits despite the database looking well.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions