sudo journalctl -fu {nopCommerce-app-name}.service
root@debian-ll:~# journalctl -fu nopcommerce.service
-- Journal begins at Thu 2021-11-11 17:28:12 CET. --
-- 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