Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- failure in postgresql with asp.net core 2.1 in this project
- Fallo en PostgreSQL con ASP.NET Core 2.1 en el proyecto
- PM> Update-Database
- The EF Core tools version '2.1.1-rtm-30846' is older than that of the runtime '2.1.8-servicing-32085'. Update the tools for the latest features and bug fixes.
- Microsoft.EntityFrameworkCore.Infrastructure[10403]
- Entity Framework Core 2.1.8-servicing-32085 initialized 'ApplicationDbContext' using provider 'Npgsql.EntityFrameworkCore.PostgreSQL' with options: None
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (52ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- SELECT EXISTS (SELECT 1 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace WHERE c.relname='__EFMigrationsHistory');
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (20ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- SELECT EXISTS (SELECT 1 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace WHERE c.relname='__EFMigrationsHistory');
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (135ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- SELECT "MigrationId", "ProductVersion"
- FROM "__EFMigrationsHistory"
- ORDER BY "MigrationId";
- Microsoft.EntityFrameworkCore.Migrations[20402]
- Applying migration '00000000000000_CreateIdentitySchema'.
- Applying migration '00000000000000_CreateIdentitySchema'.
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (918ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE TABLE "AspNetRoles" (
- "Id" text NOT NULL,
- "Name" varchar(256) NULL,
- "NormalizedName" varchar(256) NULL,
- "ConcurrencyStamp" text NULL,
- CONSTRAINT "PK_AspNetRoles" PRIMARY KEY ("Id")
- );
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (269ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE TABLE "AspNetUsers" (
- "Id" text NOT NULL,
- "UserName" varchar(256) NULL,
- "NormalizedUserName" varchar(256) NULL,
- "Email" varchar(256) NULL,
- "NormalizedEmail" varchar(256) NULL,
- "EmailConfirmed" boolean NOT NULL,
- "PasswordHash" text NULL,
- "SecurityStamp" text NULL,
- "ConcurrencyStamp" text NULL,
- "PhoneNumber" text NULL,
- "PhoneNumberConfirmed" boolean NOT NULL,
- "TwoFactorEnabled" boolean NOT NULL,
- "LockoutEnd" timestamp with time zone NULL,
- "LockoutEnabled" boolean NOT NULL,
- "AccessFailedCount" integer NOT NULL,
- CONSTRAINT "PK_AspNetUsers" PRIMARY KEY ("Id")
- );
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (262ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE TABLE "AspNetRoleClaims" (
- "Id" integer NOT NULL,
- "RoleId" text NOT NULL,
- "ClaimType" text NULL,
- "ClaimValue" text NULL,
- CONSTRAINT "PK_AspNetRoleClaims" PRIMARY KEY ("Id"),
- CONSTRAINT "FK_AspNetRoleClaims_AspNetRoles_RoleId" FOREIGN KEY ("RoleId") REFERENCES "AspNetRoles" ("Id") ON DELETE CASCADE
- );
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (105ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE TABLE "AspNetUserClaims" (
- "Id" integer NOT NULL,
- "UserId" text NOT NULL,
- "ClaimType" text NULL,
- "ClaimValue" text NULL,
- CONSTRAINT "PK_AspNetUserClaims" PRIMARY KEY ("Id"),
- CONSTRAINT "FK_AspNetUserClaims_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id") ON DELETE CASCADE
- );
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (121ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE TABLE "AspNetUserLogins" (
- "LoginProvider" varchar(128) NOT NULL,
- "ProviderKey" varchar(128) NOT NULL,
- "ProviderDisplayName" text NULL,
- "UserId" text NOT NULL,
- CONSTRAINT "PK_AspNetUserLogins" PRIMARY KEY ("LoginProvider", "ProviderKey"),
- CONSTRAINT "FK_AspNetUserLogins_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id") ON DELETE CASCADE
- );
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (229ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE TABLE "AspNetUserRoles" (
- "UserId" text NOT NULL,
- "RoleId" text NOT NULL,
- CONSTRAINT "PK_AspNetUserRoles" PRIMARY KEY ("UserId", "RoleId"),
- CONSTRAINT "FK_AspNetUserRoles_AspNetRoles_RoleId" FOREIGN KEY ("RoleId") REFERENCES "AspNetRoles" ("Id") ON DELETE CASCADE,
- CONSTRAINT "FK_AspNetUserRoles_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id") ON DELETE CASCADE
- );
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (83ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE TABLE "AspNetUserTokens" (
- "UserId" text NOT NULL,
- "LoginProvider" varchar(128) NOT NULL,
- "Name" varchar(128) NOT NULL,
- "Value" text NULL,
- CONSTRAINT "PK_AspNetUserTokens" PRIMARY KEY ("UserId", "LoginProvider", "Name"),
- CONSTRAINT "FK_AspNetUserTokens_AspNetUsers_UserId" FOREIGN KEY ("UserId") REFERENCES "AspNetUsers" ("Id") ON DELETE CASCADE
- );
- Microsoft.EntityFrameworkCore.Database.Command[20101]
- Executed DbCommand (107ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE INDEX "IX_AspNetRoleClaims_RoleId" ON "AspNetRoleClaims" ("RoleId");
- fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
- Failed executing DbCommand (147ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE UNIQUE INDEX "RoleNameIndex" ON "AspNetRoles" ("NormalizedName") WHERE [NormalizedName] IS NOT NULL;
- Npgsql.PostgresException (0x80004005): 42601: error de sintaxis en o cerca de «[»
- at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext()
- --- End of stack trace from previous location where exception was thrown ---
- at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext() in C:\projects\npgsql\src\Npgsql\NpgsqlConnector.cs:line 1032
- --- End of stack trace from previous location where exception was thrown ---
- at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming) in C:\projects\npgsql\src\Npgsql\NpgsqlDataReader.cs:line 444
- at Npgsql.NpgsqlDataReader.NextResult() in C:\projects\npgsql\src\Npgsql\NpgsqlDataReader.cs:line 332
- at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 1221
- at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken) in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 1044
- at Npgsql.NpgsqlCommand.ExecuteNonQuery() in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 1027
- at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
- Failed executing DbCommand (147ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
- CREATE UNIQUE INDEX "RoleNameIndex" ON "AspNetRoles" ("NormalizedName") WHERE [NormalizedName] IS NOT NULL;
- Npgsql.PostgresException (0x80004005): 42601: error de sintaxis en o cerca de «[»
- at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext()
- --- End of stack trace from previous location where exception was thrown ---
- at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext() in C:\projects\npgsql\src\Npgsql\NpgsqlConnector.cs:line 1032
- --- End of stack trace from previous location where exception was thrown ---
- at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming) in C:\projects\npgsql\src\Npgsql\NpgsqlDataReader.cs:line 444
- at Npgsql.NpgsqlDataReader.NextResult() in C:\projects\npgsql\src\Npgsql\NpgsqlDataReader.cs:line 332
- at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 1221
- at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken) in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 1044
- at Npgsql.NpgsqlCommand.ExecuteNonQuery() in C:\projects\npgsql\src\Npgsql\NpgsqlCommand.cs:line 1027
- at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
- at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
- at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
- at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
- at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
- at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType)
- at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_1.<.ctor>b__0()
- at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
- 42601: error de sintaxis en o cerca de «[»
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement