search

orso-co / Orso.Arpa.Api

Backend Code for arpa 2.0: Digital development in the cultural sector. ORSO Berlin develops choir and orchestra management software
http://arpa.orso.berlin/
European Union Public License 1.2
10 stars 1 forks source link

Startup crash: Relation "musician" does not exist #715

Closed Jargendas closed 1 year ago

Jargendas commented 1 year ago

Hi, great project! I'm currently trying to install Arpa for my choir using Docker. I think I got the frontend running, but I was not yet able to run the backend due to a database problem during startup with docker-compose up:

postgres_1  | 2023-04-25 01:18:53.608 UTC [30] ERROR:  relation "musician" does not exist at character 390
postgres_1  | 2023-04-25 01:18:53.608 UTC [30] STATEMENT:  create or replace View user_appointments_for_projects as
postgres_1  |   -- Termine, bei denen Projekte angegeben sind, für die der User mit mindestens einem Musikerprofil angemeldet ist
postgres_1  |   select m.given_name, m.surname, m.person_id, m.mp_id, a.id, a.name, a.public_details, a.internal_details, a.start_time, a.end_time
postgres_1  |     from appointments a, project_appointments pa, projects p, project_participations pp, musician m
postgres_1  |    where a.id=pa.appointment_id and pa.project_id=p.id and p.id=pp.project_id and pp.musician_profile_id=m.mp_id 
postgres_1  |      and a.deleted=false and pa.deleted=false and p.deleted=false and pp.deleted=false and p.is_hidden_for_performers = false
postgres_1  |      and (a.status <> 'Refused' OR a.status is null)
postgres_1  |      AND (pp.participation_status_inner <> 'Refusal' OR pp.participation_status_inner is null)
postgres_1  |      AND (pp.participation_status_internal <> 'Refusal' OR pp.participation_status_internal is null)
postgres_1  |      AND (p.status <> 'Cancelled' OR p.status is null)
postgres_1  |   
api_1       | 2023-04-25 01:18:53.6170|ERROR||Microsoft.EntityFrameworkCore.Database.Command|Failed executing DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
api_1       | create or replace View user_appointments_for_projects as
api_1       | -- Termine, bei denen Projekte angegeben sind, für die der User mit mindestens einem Musikerprofil angemeldet ist
api_1       | select m.given_name, m.surname, m.person_id, m.mp_id, a.id, a.name, a.public_details, a.internal_details, a.start_time, a.end_time
api_1       |   from appointments a, project_appointments pa, projects p, project_participations pp, musician m
api_1       |  where a.id=pa.appointment_id and pa.project_id=p.id and p.id=pp.project_id and pp.musician_profile_id=m.mp_id 
api_1       |    and a.deleted=false and pa.deleted=false and p.deleted=false and pp.deleted=false and p.is_hidden_for_performers = false
api_1       |    and (a.status <> 'Refused' OR a.status is null)
api_1       |    AND (pp.participation_status_inner <> 'Refusal' OR pp.participation_status_inner is null)
api_1       |    AND (pp.participation_status_internal <> 'Refusal' OR pp.participation_status_internal is null)
api_1       |    AND (p.status <> 'Cancelled' OR p.status is null)
api_1       | ;|url: |action: |exception: 
api_1       | 2023-04-25 01:18:53.6198|ERROR||Orso.Arpa.Api.Startup|An error occured during database migration|url: |action: |exception: Npgsql.PostgresException (0x80004005): 42P01: relation "musician" does not exist
api_1       | 
api_1       | POSITION: 390
api_1       |    at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|233_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
api_1       |    at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken)
api_1       |    at Orso.Arpa.Persistence.DataAccess.ArpaContext.ExecuteSqlAsync(String sqlStatement) in /home/app/Orso.Arpa.Persistence/DataAccess/ArpaContext.cs:line 337
api_1       |    at Orso.Arpa.Persistence.DataSeeder.SeedViewsAndFunctionsAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 53
api_1       |    at Orso.Arpa.Persistence.DataSeeder.SeedDataAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 44
api_1       |   Exception data:
api_1       |     Severity: ERROR
api_1       |     SqlState: 42P01
api_1       |     MessageText: relation "musician" does not exist
api_1       |     Position: 390
api_1       |     File: parse_relation.c
api_1       |     Line: 1177
api_1       |     Routine: parserOpenTable
api_1       | 2023-04-25 01:18:53.6363|FATAL||Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception|url: |action: |exception: Npgsql.PostgresException (0x80004005): 42P01: relation "musician" does not exist
api_1       | 
api_1       | POSITION: 390
api_1       |    at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|233_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
api_1       |    at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken)
api_1       |    at Orso.Arpa.Persistence.DataAccess.ArpaContext.ExecuteSqlAsync(String sqlStatement) in /home/app/Orso.Arpa.Persistence/DataAccess/ArpaContext.cs:line 337
api_1       |    at Orso.Arpa.Persistence.DataSeeder.SeedViewsAndFunctionsAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 53
api_1       |    at Orso.Arpa.Persistence.DataSeeder.SeedDataAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 44
api_1       |   Exception data:
api_1       |     Severity: ERROR
api_1       |     SqlState: 42P01
api_1       |     MessageText: relation "musician" does not exist
api_1       |     Position: 390
api_1       |     File: parse_relation.c
api_1       |     Line: 1177
api_1       |     Routine: parserOpenTable
api_1       | Unhandled exception. System.AggregateException: One or more errors occurred. (42P01: relation "musician" does not exist
api_1       | 
api_1       | POSITION: 390)
api_1       |  ---> Npgsql.PostgresException (0x80004005): 42P01: relation "musician" does not exist
api_1       | 
api_1       | POSITION: 390
api_1       |    at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|233_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
api_1       |    at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
api_1       |    at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
api_1       |    at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken)
api_1       |    at Orso.Arpa.Persistence.DataAccess.ArpaContext.ExecuteSqlAsync(String sqlStatement) in /home/app/Orso.Arpa.Persistence/DataAccess/ArpaContext.cs:line 337
api_1       |    at Orso.Arpa.Persistence.DataSeeder.SeedViewsAndFunctionsAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 53
api_1       |    at Orso.Arpa.Persistence.DataSeeder.SeedDataAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 44
api_1       |   Exception data:
api_1       |     Severity: ERROR
api_1       |     SqlState: 42P01
api_1       |     MessageText: relation "musician" does not exist
api_1       |     Position: 390
api_1       |     File: parse_relation.c
api_1       |     Line: 1177
api_1       |     Routine: parserOpenTable
api_1       |    --- End of inner exception stack trace ---
api_1       |    at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
api_1       |    at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
api_1       |    at System.Threading.Tasks.Task.Wait()
api_1       |    at Orso.Arpa.Api.Startup.EnsureDatabaseMigrations(IApplicationBuilder app) in /home/app/Orso.Arpa.Api/Startup.cs:line 525
api_1       |    at Orso.Arpa.Api.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env) in /home/app/Orso.Arpa.Api/Startup.cs:line 471
api_1       |    at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
api_1       |    at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
api_1       |    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
api_1       |    at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
api_1       |    at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)
api_1       |    at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
api_1       |    at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host)
api_1       |    at Orso.Arpa.Api.Program.Main(String[] args) in /home/app/Orso.Arpa.Api/Program.cs:line 26

What can I do about that?

wolfgangroese commented 1 year ago

Hey Jonathan,

thanks a lot for trying out ARPA .-) We’re still working on it! :-) I try to get some information about this „musician“, i had this problem once too, but can’t quite remember the reason for it. At the moment i run the backend also as docker on my macbook pro, and its all fine. As i am more in the frontend i have to ask Mira, she is the backend-genius ,-) Stay tuned, i will come back to you asap, just traveeling for rehearsals right now.

May I ask where you are from and for with ensemble you want it to use?

Cheers, Wolfie

Am 25.04.2023 um 09:17 schrieb Jonathan Schostak @.***>:

Hi, great project! I'm currently trying to install Arpa for my choir using Docker. I think I got the frontend running, but I was not yet able to run the backend due to a database problem during startup with docker-compose up:

postgres_1 | 2023-04-25 01:18:53.608 UTC [30] ERROR: relation "musician" does not exist at character 390 postgres_1 | 2023-04-25 01:18:53.608 UTC [30] STATEMENT: create or replace View user_appointments_for_projects as postgres_1 | -- Termine, bei denen Projekte angegeben sind, für die der User mit mindestens einem Musikerprofil angemeldet ist postgres_1 | select m.given_name, m.surname, m.person_id, m.mp_id, a.id, a.name, a.public_details, a.internal_details, a.start_time, a.end_time postgres_1 | from appointments a, project_appointments pa, projects p, project_participations pp, musician m postgres_1 | where a.id=pa.appointment_id and pa.project_id=p.id and p.id=pp.project_id and pp.musician_profile_id=m.mp_id postgres_1 | and a.deleted=false and pa.deleted=false and p.deleted=false and pp.deleted=false and p.is_hidden_for_performers = false postgres_1 | and (a.status <> 'Refused' OR a.status is null) postgres_1 | AND (pp.participation_status_inner <> 'Refusal' OR pp.participation_status_inner is null) postgres_1 | AND (pp.participation_status_internal <> 'Refusal' OR pp.participation_status_internal is null) postgres_1 | AND (p.status <> 'Cancelled' OR p.status is null) postgres_1 |
api_1 | 2023-04-25 01:18:53.6170|ERROR||Microsoft.EntityFrameworkCore.Database.Command|Failed executing DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] api_1 | create or replace View user_appointments_for_projects as api_1 | -- Termine, bei denen Projekte angegeben sind, für die der User mit mindestens einem Musikerprofil angemeldet ist api_1 | select m.given_name, m.surname, m.person_id, m.mp_id, a.id, a.name, a.public_details, a.internal_details, a.start_time, a.end_time api_1 | from appointments a, project_appointments pa, projects p, project_participations pp, musician m api_1 | where a.id=pa.appointment_id and pa.project_id=p.id and p.id=pp.project_id and pp.musician_profile_id=m.mp_id api_1 | and a.deleted=false and pa.deleted=false and p.deleted=false and pp.deleted=false and p.is_hidden_for_performers = false api_1 | and (a.status <> 'Refused' OR a.status is null) api_1 | AND (pp.participation_status_inner <> 'Refusal' OR pp.participation_status_inner is null) api_1 | AND (pp.participation_status_internal <> 'Refusal' OR pp.participation_status_internal is null) api_1 | AND (p.status <> 'Cancelled' OR p.status is null) api_1 | ;|url: |action: |exception: api_1 | 2023-04-25 01:18:53.6198|ERROR||Orso.Arpa.Api.Startup|An error occured during database migration|url: |action: |exception: Npgsql.PostgresException (0x80004005): 42P01: relation "musician" does not exist api_1 | api_1 | POSITION: 390 api_1 | at Npgsql.Internal.NpgsqlConnector.gReadMessageLong|233_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) api_1 | at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) api_1 | at Orso.Arpa.Persistence.DataAccess.ArpaContext.ExecuteSqlAsync(String sqlStatement) in /home/app/Orso.Arpa.Persistence/DataAccess/ArpaContext.cs:line 337 api_1 | at Orso.Arpa.Persistence.DataSeeder.SeedViewsAndFunctionsAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 53 api_1 | at Orso.Arpa.Persistence.DataSeeder.SeedDataAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 44 api_1 | Exception data: api_1 | Severity: ERROR api_1 | SqlState: 42P01 api_1 | MessageText: relation "musician" does not exist api_1 | Position: 390 api_1 | File: parse_relation.c api_1 | Line: 1177 api_1 | Routine: parserOpenTable api_1 | 2023-04-25 01:18:53.6363|FATAL||Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception|url: |action: |exception: Npgsql.PostgresException (0x80004005): 42P01: relation "musician" does not exist api_1 | api_1 | POSITION: 390 api_1 | at Npgsql.Internal.NpgsqlConnector.gReadMessageLong|233_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) api_1 | at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable1 parameters, CancellationToken cancellationToken) api_1 | at Orso.Arpa.Persistence.DataAccess.ArpaContext.ExecuteSqlAsync(String sqlStatement) in /home/app/Orso.Arpa.Persistence/DataAccess/ArpaContext.cs:line 337 api_1 | at Orso.Arpa.Persistence.DataSeeder.SeedViewsAndFunctionsAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 53 api_1 | at Orso.Arpa.Persistence.DataSeeder.SeedDataAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 44 api_1 | Exception data: api_1 | Severity: ERROR api_1 | SqlState: 42P01 api_1 | MessageText: relation "musician" does not exist api_1 | Position: 390 api_1 | File: parse_relation.c api_1 | Line: 1177 api_1 | Routine: parserOpenTable api_1 | Unhandled exception. System.AggregateException: One or more errors occurred. (42P01: relation "musician" does not exist api_1 | api_1 | POSITION: 390) api_1 | ---> Npgsql.PostgresException (0x80004005): 42P01: relation "musician" does not exist api_1 | api_1 | POSITION: 390 api_1 | at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|233_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) api_1 | at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) api_1 | at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) api_1 | at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable1 parameters, CancellationToken cancellationToken) api_1 | at Orso.Arpa.Persistence.DataAccess.ArpaContext.ExecuteSqlAsync(String sqlStatement) in /home/app/Orso.Arpa.Persistence/DataAccess/ArpaContext.cs:line 337 api_1 | at Orso.Arpa.Persistence.DataSeeder.SeedViewsAndFunctionsAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 53 api_1 | at Orso.Arpa.Persistence.DataSeeder.SeedDataAsync() in /home/app/Orso.Arpa.Persistence/DataSeeder.cs:line 44 api_1 | Exception data: api_1 | Severity: ERROR api_1 | SqlState: 42P01 api_1 | MessageText: relation "musician" does not exist api_1 | Position: 390 api_1 | File: parse_relation.c api_1 | Line: 1177 api_1 | Routine: parserOpenTable api_1 | --- End of inner exception stack trace --- api_1 | at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) api_1 | at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) api_1 | at System.Threading.Tasks.Task.Wait() api_1 | at Orso.Arpa.Api.Startup.EnsureDatabaseMigrations(IApplicationBuilder app) in /home/app/Orso.Arpa.Api/Startup.cs:line 525 api_1 | at Orso.Arpa.Api.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env) in /home/app/Orso.Arpa.Api/Startup.cs:line 471 api_1 | at System.RuntimeMethodHandle.InvokeMethod(Object target, Void* arguments, Signature sig, Boolean isConstructor) api_1 | at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr args, BindingFlags invokeAttr) api_1 | at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) api_1 | at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder) api_1 | at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken) api_1 | at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken) api_1 | at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token) api_1 | at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token) api_1 | at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host) api_1 | at Orso.Arpa.Api.Program.Main(String[] args) in /home/app/Orso.Arpa.Api/Program.cs:line 26 What can I do about that?

— Reply to this email directly, view it on GitHub https://github.com/orso-co/Orso.Arpa.Api/issues/715, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABCROUTPJ3LK47QN2RJJLM3XC53ALANCNFSM6AAAAAAXKSNDIA. You are receiving this because you are subscribed to this thread.

Jargendas commented 1 year ago

Hi Wolf,

it's for the CM, we've had a small e-mail contact about it before, but I thought I would make this an official issue in case someone else has the same problem in the future, I hope that's okay. 🙂

I am aware that it's not yet fully production ready, but I think it still makes sense to start using it and giving feedback early.

I think the problem might come from the fresh setup (vs. continuously updating the dev system), maybe the database is not generated correctly from scratch? Just a wild guess, I have no experience with .NET.

Should have added before: I'm working on an Ubuntu 22.04 Server with Docker 23.0.4.

wolfgangroese commented 1 year ago

Ahhh.. so cool, yes they tried for a long time and I was wondering if CM does make any progress ,-) Cool, that they found you to take care of the installation hehehe ,-)

I got an answer from my backend developer Mira: 

Sorry, for just providing screenshot in german, but i have to jump on the next train. Please feel free to get back to me if you have further questions. Are you speaking german as well? Anyways there is chatGPT for help, hehehehe ,-) Let me know, if you are successful or not.

Oh and please keep in mind: we need to make a new fork, because right now the system is very orso-centric, that means, our contact-data, dsgvo stuff, etc. and also a iframe to our library are still part of the system. We need to remove this data for other ensembles to be clean. Just small issues, but not done yet as we are very busy with 3 upcoming big concerts in germany in may ,-)

By the way: Are you a musician as well?

We can also have a chat on slack, zoom, jitsi, facetime or whatever if you like.

Have a nice weekend! Wolfie

Am 27.04.2023 um 00:36 schrieb Jonathan Schostak @.***>:

Hi Wolf,

it's for the CM, we've had a small e-mail contact about it before, but I thought I would make this an official issue in case someone else has the same problem in the future, I hope that's okay. 🙂

I am aware that it's not yet fully production ready, but I think it still makes sense to start using it and giving feedback early.

I think the problem might come from the fresh setup (vs. continuously updating the dev system), maybe the database is not generated correctly from scratch? Just a wild guess, I have no experience with .NET.

Should have added before: I'm working on an Ubuntu 22.04 Server with Docker 23.0.4.

— Reply to this email directly, view it on GitHub https://github.com/orso-co/Orso.Arpa.Api/issues/715#issuecomment-1524123535, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABCROUWIMTDPXS6GHNJHBP3XDGPO5ANCNFSM6AAAAAAXKSNDIA. You are receiving this because you commented.

Jargendas commented 1 year ago

Hi Wolf, unfortunately, the mentioned screenshot seems to not have been properly attached, could you please send that again.

Sure, if you prefer we can switch to German and to another platform. And yes, I sing in the grand choir of the CM, bass. :)