"An exception was thrown while activating λ:FluentMigrator.Runner.IVersionLoader." on Debian 11 "Bullseye"

2 месяца назад
Sorry, it's my fail :) I forgot that we're talking about Linux. You can check the logs by the following command:  
sudo journalctl -fu {nopCommerce-app-name}.service
2 месяца назад
Hi

Thank you very much for your feedback.

No - nothing happens after entering the command. The console seems to go in "listening mode", but after entering the installing page and then press OK (with same error), the console does not output anything:


[email protected]:~# journalctl -fu nopcommerce.service
-- Journal begins at Thu 2021-11-11 17:28:12 CET. --
2 месяца назад
Oh - the problem was that ´journalctl -fu ... ´ does react to EVERY (also non-existing) services names... so i didn't got any error messages for the wrong command ´journalctl -fu nopcommerce.service´ (or similar)

SO, the correct command is: ´journalctl -fu nopCommerce440´...

Will try to figure out not what the problem is - thank you very very much!! :-)
2 месяца назад
OK - here is the message. So i see, there are not authentications errors; and the database called "nopcommerce" does also exist on Postgres DBMS:


-- Journal begins at Thu 2021-11-11 17:28:12 CET. --
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1]
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]:       Executing ViewResult, running view Index.
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[4]
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]:       Executed ViewResult - view Index executed in 14.3369ms.
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]:       Executed action Nop.Web.Controllers.InstallController.Index (Nop.Web) in 642.2189ms
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]:       Executed endpoint 'Nop.Web.Controllers.InstallController.Index (Nop.Web)'
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Nov 16 10:42:17 debian-ll nopCommerce440-example[32026]:       Request finished HTTP/1.1 POST http://192.168.80.242/install application/x-www-form-urlencoded 534 - 200 - text/html;+charset=utf-8 699.1157ms
Nov 16 10:43:20 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Nov 16 10:43:20 debian-ll nopCommerce440-example[32026]:       Request starting HTTP/1.1 POST http://192.168.80.242/install application/x-www-form-urlencoded 536
Nov 16 10:43:20 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Nov 16 10:43:20 debian-ll nopCommerce440-example[32026]:       Executing endpoint 'Nop.Web.Controllers.InstallController.Index (Nop.Web)'
Nov 16 10:43:20 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Nov 16 10:43:20 debian-ll nopCommerce440-example[32026]:       Route matched with {action = "Index", controller = "Install", area = ""}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Index(Nop.Web.Models.Install.InstallModel) on controller Nop.Web.Controllers.InstallController (Nop.Web).
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.MigrationRunner[1000]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       VersionDescriptionMigration migrating
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.Processors.Postgres.PostgresProcessor[1004]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       Beginning Transaction
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.MigrationRunner[1004]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       AlterTable MigrationVersionInfo
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.Processors.Postgres.PostgresProcessor[1003]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.MigrationRunner[1002]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       => 0.0011705s
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.MigrationRunner[1004]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       CreateColumn MigrationVersionInfo Description citext
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.Processors.Postgres.PostgresProcessor[1003]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       ALTER TABLE "public"."MigrationVersionInfo" ADD "Description" citext NULL;
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: fail: FluentMigrator.Runner.MigrationRunner[0]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       An error occured executing the following sql:
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       ALTER TABLE "public"."MigrationVersionInfo" ADD "Description" citext NULL;
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       The error was 42704: Typ »citext« existiert nicht
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       System.Exception: An error occured executing the following sql:
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       ALTER TABLE "public"."MigrationVersionInfo" ADD "Description" citext NULL;
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       The error was 42704: Typ »citext« existiert nicht
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:        ---> Npgsql.PostgresException (0x80004005): 42704: Typ »citext« existiert nicht
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at Npgsql.NpgsqlDataReader.NextResult()
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at Npgsql.NpgsqlCommand.ExecuteNonQuery()
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Runner.Processors.Postgres.PostgresProcessor.Process(String sql)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:         Exception data:
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:           Severity: FEHLER
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:           SqlState: 42704
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:           MessageText: Typ »citext« existiert nicht
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:           Position: 63
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:           File: parse_type.c
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:           Line: 270
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:           Routine: typenameType
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          --- End of inner exception stack trace ---
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Runner.Processors.Postgres.PostgresProcessor.Process(String sql)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Runner.Processors.ProcessorBase.Process(CreateColumnExpression expression)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Expressions.CreateColumnExpression.ExecuteWith(IMigrationProcessor processor)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass80_0.<ExecuteExpressions>b__1()
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Runner.StopWatch.Time(Action action)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:          at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions)
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: FluentMigrator.Runner.Processors.Postgres.PostgresProcessor[1004]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       Rolling back transaction
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       Executing ViewResult, running view Index.
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[4]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       Executed ViewResult - view Index executed in 7.4811ms.
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       Executed action Nop.Web.Controllers.InstallController.Index (Nop.Web) in 1050.0954ms
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       Executed endpoint 'Nop.Web.Controllers.InstallController.Index (Nop.Web)'
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Nov 16 10:43:21 debian-ll nopCommerce440-example[32026]:       Request finished HTTP/1.1 POST http://192.168.80.242/install application/x-www-form-urlencoded 536 - 200 - text/html;+charset=utf-8 1060.2604ms
2 месяца назад
-> https://github.com/nopSolutions/nopCommerce/issues/5946
2 месяца назад
You need to install the "citext" extension for PostgreSQL.
The error was 42704: Typ »citext« existiert nicht
2 месяца назад
Thank you for your feedback, BUT: No, not really... after deleting the manually created postgres database called "nopcommerce", then selecting "create DB if not exist" on install page, it seems to work... but ONLY after clicking button "Reinstall with clear settings" button instead of default "Install" button...
2 месяца назад
Because of that, now i've submitted a bug here: https://github.com/nopSolutions/nopCommerce/issues/5946
2 месяца назад
Another question: If the file is called "web.config" on Windows, so what's the name of its equivalent in [Debian 11] Linux (or UNIX, maybe NopCommerce works also on UNIX) ?
2 месяца назад
"Thank you for your feedback, BUT: No, not really... after deleting the manually created postgres database called "nopcommerce", then selecting "create DB if not exist" on install page, it seems to work... but ONLY after clicking button "Reinstall with clear settings" button instead of default "Install" button..."

-> Not interested for that issues? If yes: Why?