[GH-ISSUE #1567] Server postgreSQL initializing database error #344

New issue

Closed

opened 2026-03-07 20:47:59 +03:00 by kerem · 0 comments

kerem commented

2026-03-07 20:47:59 +03:00

Owner

Originally created by @cb-arkea on GitHub (Mar 24, 2023).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/1567

Originally assigned to: @alexander-skoblikov on GitHub.

Describe the bug
Server postgreSQL initializing database error

cloudbeaver.conf

  database: {
	        driver: "postgres-jdbc",
            url: "jdbc:postgresql://host:5432/dbeavercloud?targetServerType=primary",
            user: "dbeavercloud",
            password: "aaaa",
            initialDataConfiguration: "conf/initial-data.conf",
            pool: {
                minIdleConnections: 4,
                maxIdleConnections: 10,
                maxConnections: 50,
                validationQuery: "SELECT 1"
            }
        }

initial-data.conf

{
    adminName: "toto",
    adminPassword: "toto",
    roles: [
        {
            roleId: "admin",
            name: "Admin",
            description: "Administrative access. Has total and full authority.",
            permission: ["public", "admin"]
        },
        {
            roleId: "user",
            name: "User",
            description: "Standard user",
            permission: ["public"]
        }
    ]
}

Logs

12:43:14.091 [main] DEBUG i.c.service.security.db.CBDatabase -  Initiate connection pool with management database (PostgreSQL; jdbc:postgresql://host:5432/dbeavercloud?targetServerType=primary)
12:43:14.665 [main] DEBUG i.c.service.security.db.CBDatabase -  Connected to PostgreSQL 14.6
12:43:14.775 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Create new schema CB
12:43:15.369 [main] WARN  o.j.d.m.sql.schema.SQLSchemaManager - CB migration has been rolled back
12:43:15.371 [main] ERROR io.cloudbeaver.server.CBApplication - Error initializing database
org.jkiss.dbeaver.DBException: Error updating management database schema
        at io.cloudbeaver.service.security.db.CBDatabase.initialize(CBDatabase.java:193)
        at io.cloudbeaver.service.security.EmbeddedSecurityControllerFactory.createSecurityService(EmbeddedSecurityControllerFactory.java:64)
        at io.cloudbeaver.server.CBApplication.createGlobalSecurityController(CBApplication.java:484)
        at io.cloudbeaver.server.CBApplication.initializeSecurityController(CBApplication.java:480)
        at io.cloudbeaver.server.CBApplication.startServer(CBApplication.java:323)
        at io.cloudbeaver.model.app.BaseWebApplication.start(BaseWebApplication.java:186)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:136)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:402)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.base/java.lang.reflect.Method.invoke(Unknown Source)
        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:659)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:596)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1467)
        at org.eclipse.equinox.launcher.Main.main(Main.java:1440)
Caused by: org.jkiss.dbeaver.model.exec.DBCException: Error saving user teams in database
        at io.cloudbeaver.service.security.CBEmbeddedSecurityController.setUserTeams(CBEmbeddedSecurityController.java:188)
        at io.cloudbeaver.service.security.CBEmbeddedSecurityController.createUser(CBEmbeddedSecurityController.java:148)
        at io.cloudbeaver.service.security.db.CBDatabase.createAdminUser(CBDatabase.java:258)
        at io.cloudbeaver.service.security.db.CBDatabase$CBSchemaVersionManager.fillInitialSchemaData(CBDatabase.java:384)
        at org.jkiss.dbeaver.model.sql.schema.SQLSchemaManager.createNewSchema(SQLSchemaManager.java:159)
        at org.jkiss.dbeaver.model.sql.schema.SQLSchemaManager.updateSchema(SQLSchemaManager.java:91)
        at io.cloudbeaver.service.security.db.CBDatabase.initialize(CBDatabase.java:189)
        ... 18 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "cb_user_team" violates foreign key constraint "cb_user_team_team_id_fkey"
  Detail: Key (team_id)=(user) is not present in table "cb_team".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
        at io.cloudbeaver.service.security.CBEmbeddedSecurityController.setUserTeams(CBEmbeddedSecurityController.java:181)
        ... 24 common frames omitted
12:43:15.377 [Framework stop - Equinox Container: 8534262e-049f-4cf8-870a-787cc4e40f09] DEBUG io.cloudbeaver.server.CBPlatform - Shutdown Core...
12:43:15.480 [Framework stop - Equinox Container: 8534262e-049f-4cf8-870a-787cc4e40f09] DEBUG io.cloudbeaver.server.CBPlatform - Shutdown completed in 103ms
Job found still running after platform shutdown.  Jobs should be canceled by the plugin that scheduled them during shutdown: org.jkiss.dbeaver.model.navigator.DBNModel$EventProcessingJob

Originally created by @cb-arkea on GitHub (Mar 24, 2023). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/1567 Originally assigned to: @alexander-skoblikov on GitHub. **Describe the bug** Server postgreSQL initializing database error **cloudbeaver.conf** ``` database: { driver: "postgres-jdbc", url: "jdbc:postgresql://host:5432/dbeavercloud?targetServerType=primary", user: "dbeavercloud", password: "aaaa", initialDataConfiguration: "conf/initial-data.conf", pool: { minIdleConnections: 4, maxIdleConnections: 10, maxConnections: 50, validationQuery: "SELECT 1" } } ``` **initial-data.conf** ``` { adminName: "toto", adminPassword: "toto", roles: [ { roleId: "admin", name: "Admin", description: "Administrative access. Has total and full authority.", permission: ["public", "admin"] }, { roleId: "user", name: "User", description: "Standard user", permission: ["public"] } ] } ``` **Logs** ``` 12:43:14.091 [main] DEBUG i.c.service.security.db.CBDatabase - Initiate connection pool with management database (PostgreSQL; jdbc:postgresql://host:5432/dbeavercloud?targetServerType=primary) 12:43:14.665 [main] DEBUG i.c.service.security.db.CBDatabase - Connected to PostgreSQL 14.6 12:43:14.775 [main] DEBUG o.j.d.m.sql.schema.SQLSchemaManager - Create new schema CB 12:43:15.369 [main] WARN o.j.d.m.sql.schema.SQLSchemaManager - CB migration has been rolled back 12:43:15.371 [main] ERROR io.cloudbeaver.server.CBApplication - Error initializing database org.jkiss.dbeaver.DBException: Error updating management database schema at io.cloudbeaver.service.security.db.CBDatabase.initialize(CBDatabase.java:193) at io.cloudbeaver.service.security.EmbeddedSecurityControllerFactory.createSecurityService(EmbeddedSecurityControllerFactory.java:64) at io.cloudbeaver.server.CBApplication.createGlobalSecurityController(CBApplication.java:484) at io.cloudbeaver.server.CBApplication.initializeSecurityController(CBApplication.java:480) at io.cloudbeaver.server.CBApplication.startServer(CBApplication.java:323) at io.cloudbeaver.model.app.BaseWebApplication.start(BaseWebApplication.java:186) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:136) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:402) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:659) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:596) at org.eclipse.equinox.launcher.Main.run(Main.java:1467) at org.eclipse.equinox.launcher.Main.main(Main.java:1440) Caused by: org.jkiss.dbeaver.model.exec.DBCException: Error saving user teams in database at io.cloudbeaver.service.security.CBEmbeddedSecurityController.setUserTeams(CBEmbeddedSecurityController.java:188) at io.cloudbeaver.service.security.CBEmbeddedSecurityController.createUser(CBEmbeddedSecurityController.java:148) at io.cloudbeaver.service.security.db.CBDatabase.createAdminUser(CBDatabase.java:258) at io.cloudbeaver.service.security.db.CBDatabase$CBSchemaVersionManager.fillInitialSchemaData(CBDatabase.java:384) at org.jkiss.dbeaver.model.sql.schema.SQLSchemaManager.createNewSchema(SQLSchemaManager.java:159) at org.jkiss.dbeaver.model.sql.schema.SQLSchemaManager.updateSchema(SQLSchemaManager.java:91) at io.cloudbeaver.service.security.db.CBDatabase.initialize(CBDatabase.java:189) ... 18 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "cb_user_team" violates foreign key constraint "cb_user_team_team_id_fkey" Detail: Key (team_id)=(user) is not present in table "cb_team". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177) at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at io.cloudbeaver.service.security.CBEmbeddedSecurityController.setUserTeams(CBEmbeddedSecurityController.java:181) ... 24 common frames omitted 12:43:15.377 [Framework stop - Equinox Container: 8534262e-049f-4cf8-870a-787cc4e40f09] DEBUG io.cloudbeaver.server.CBPlatform - Shutdown Core... 12:43:15.480 [Framework stop - Equinox Container: 8534262e-049f-4cf8-870a-787cc4e40f09] DEBUG io.cloudbeaver.server.CBPlatform - Shutdown completed in 103ms Job found still running after platform shutdown. Jobs should be canceled by the plugin that scheduled them during shutdown: org.jkiss.dbeaver.model.navigator.DBNModel$EventProcessingJob ```