search

OHDSI / WebAPI

OHDSI WebAPI contains all OHDSI services that can be called from OHDSI applications
Apache License 2.0
126 stars 156 forks source link

Configuring Broadsea WebAPI #2306

Open dxy257 opened 10 months ago

dxy257 commented 10 months ago

Expected behavior

When we run the WebAPI docker container, we expected the server http://127.0.0.1/ to be opened. However, after we pulled the missing drivers (Oracle, Cloudera Impala, Starschema BigQuery, Netezza, simbam1Postgres) in addition to our existing drivers (ohdsi-atlas, broadsea-atlasdb, ohdsi-webapi), and tried to run this command "docker compose pull && docker compose --profile webapi-from-image --profile atlas-from-image --profile atlasdb --profile cloudera_driver --profile starschema_driver --profile oracle_driver --profile netezza_driver --profile apacheHive_driver --profile simbam1Postgres_driver up", the server start running but there is a schema called "starschema" running again and again. But it's not stopping.

2304

How we can fix the start level of the WebAPI configurations, including the all the docker images that required by the OHDSI/WebAPI ?

================================================================================== STACK TRACE:

starschema | [20:41:04 INF HostedJob 'AppConfigAutoRefresh'] Executed DbCommand (0ms) [Parameters=[@p_0='?' (Size = 22)], CommandType='Text', CommandTimeout='30'] starschema | SELECT "f"."Name", "f"."Content", "f"."ContentType", "f"."LastUpdated" starschema | FROM "Files" AS "f" starschema | WHERE "f"."Name" = @__p_0 starschema | LIMIT 1 starschema | [20:41:04 INF HostedJob 'AppConfigAutoRefresh'] Hosted job: 'AppConfigAutoRefresh' completed successfully starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Entity Framework Core 6.0.6 initialized 'SqliteDbContext' using provider 'Microsoft.EntityFrameworkCore.Sqlite:6.0.6' with options: DetailedErrorsEnabled MigrationsHistoryTable=EFMigrationsHistory starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Executed DbCommand (0ms) [Parameters=[@p_0='?' (Size = 15)], CommandType='Text', CommandTimeout='30'] starschema | SELECT "f"."Name", "f"."Content", "f"."ContentType", "f"."LastUpdated" starschema | FROM "Files" AS "f" starschema | WHERE "f"."Name" = @__p_0 starschema | LIMIT 1 starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Entity Framework Core 6.0.6 initialized 'SqliteDbContext' using provider 'Microsoft.EntityFrameworkCore.Sqlite:6.0.6' with options: DetailedErrorsEnabled MigrationsHistoryTable=EFMigrationsHistory starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Executed DbCommand (0ms) [Parameters=[@__p_0='?' (Size = 22)], CommandType='Text', CommandTimeout='30'] starschema | SELECT "f"."Name", "f"."Content", "f"."ContentType", "f"."LastUpdated" starschema | FROM "Files" AS "f" starschema | WHERE "f"."Name" = @__p_0 starschema | LIMIT 1 starschema | [20:41:14 INF HostedJob 'AppConfigAutoRefresh'] Hosted job: 'AppConfigAutoRefresh' completed successfully

=================================================================================

konstjar commented 9 months ago

@dxy257 I think it's better to open the ticket in the Broadsea repository.