Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL, OrchardCore.ContentFields.Indexing.SQL, Specified key was too long; max key length is 3072 bytes #14338

Closed
hieucd04 opened this issue Sep 15, 2023 · 15 comments · Fixed by #14500 or #14513
Closed

MySQL, OrchardCore.ContentFields.Indexing.SQL, Specified key was too long; max key length is 3072 bytes #14338

hieucd04 opened this issue Sep 15, 2023 · 15 comments · Fixed by #14500 or #14513
Labels
bug 🐛
Milestone
1.7

Comments

@hieucd04
Copy link

hieucd04 commented Sep 15, 2023 •
edited
Loading

Multiple exceptions were thrown when I started a new MySQL based instance of Orchard Core CMS. Full log is at the end of this issue. Also, this looks like a regression bug to me as a similar issue happened in the past: #4753

To Reproduce

Sorry, I don't really have a step by step instruction. All I know is that I upgraded from 1.5.0 to 1.7.0 and this happens. Revert back to 1.5.0 fixes the issue for me. Also, to make sure I'm not chasing phantom issue, I ran the following cmd between downgrades and upgrades:

dotnet nuget locals all --clear // clear Nuget cache
git clean -ffdxq // clear local workspace, including all node_modules folders

Environment

  • I ran my application inside Docker Desktop which ran inside Windows 11.

Expected behavior

Application starts successfully without any exception.

Full log

2023-09-15 13:55:37 warn: Microsoft.AspNetCore.DataProtection.Repositories.FileSystemXmlRepository[60]
2023-09-15 13:55:37       Storing keys in a directory '/root/.aspnet/DataProtection-Keys' that may not be persisted outside of the container. Protected data will be unavailable when container is destroyed.
2023-09-15 13:55:37 info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[62]
2023-09-15 13:55:37       User profile is available. Using '/root/.aspnet/DataProtection-Keys' as key repository; keys will not be encrypted at rest.
2023-09-15 13:55:37 info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[58]
2023-09-15 13:55:37       Creating key {a789d72e-e3e4-4643-9157-8cf98b06f27b} with creation date 2023-09-15 06:55:37Z, activation date 2023-09-15 06:55:37Z, and expiration date 2023-12-14 06:55:37Z.
2023-09-15 13:55:37 warn: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[35]
2023-09-15 13:55:37       No XML encryptor configured. Key {a789d72e-e3e4-4643-9157-8cf98b06f27b} may be persisted to storage in unencrypted form.
2023-09-15 13:55:37 info: Microsoft.AspNetCore.DataProtection.Repositories.FileSystemXmlRepository[39]
2023-09-15 13:55:37       Writing data to file '/root/.aspnet/DataProtection-Keys/key-a789d72e-e3e4-4643-9157-8cf98b06f27b.xml'.
2023-09-15 13:55:37 info: Microsoft.Hosting.Lifetime[14]
2023-09-15 13:55:37       Now listening on: http://0.0.0.0:5000
2023-09-15 13:55:37 info: Microsoft.Hosting.Lifetime[0]
2023-09-15 13:55:37       Application started. Press Ctrl+C to shut down.
2023-09-15 13:55:37 info: Microsoft.Hosting.Lifetime[0]
2023-09-15 13:55:37       Hosting environment: Production
2023-09-15 13:55:37 info: Microsoft.Hosting.Lifetime[0]
2023-09-15 13:55:37       Content root path: /miniskylab/
2023-09-15 13:57:39 info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
2023-09-15 13:57:39       Request starting HTTP/1.1 GET http://www.minilocallab.com/tachyon-cms - -
2023-09-15 13:57:40 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:40       Error while running migration version 0 for 'OrchardCore.ContentFields.Indexing.SQL'.
2023-09-15 13:57:40       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:40        ---> MySqlConnector.MySqlException (0x80004005): Specified key was too long; max key length is 3072 bytes
2023-09-15 13:57:40          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:40          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:40          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:40          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:40          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:40          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:40          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:40          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:40          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:40          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:40          at YesSql.Sql.SchemaBuilder.AlterTable(String name, Action`1 table)
2023-09-15 13:57:40          at YesSql.Sql.SchemaBuilder.AlterIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:40          at YesSql.Sql.SchemaBuilderExtensions.AlterIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:40          at OrchardCore.ContentFields.Indexing.SQL.Migrations.Create()
2023-09-15 13:57:40          at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
2023-09-15 13:57:40          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:40          --- End of inner exception stack trace ---
2023-09-15 13:57:40          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:40          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:40          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Contents'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__ContentItemIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.ContentManagement.Records.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.ContentFields.Indexing.SQL'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__TextFieldIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.ContentFields.Indexing.SQL.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Alias'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__AliasPartIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.Alias.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Autoroute'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__AutoroutePartIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.Autoroute.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Users'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__UserIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.Users.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Deployment'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__DeploymentPlanIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.Deployment.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Indexing'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__IndexingTask' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateTable(String name, Action`1 table)
2023-09-15 13:57:42          at OrchardCore.Indexing.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Layers'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__LayerMetadataIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.Layers.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.Lists'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__ContainedPartIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.Lists.Migrations.Create()
2023-09-15 13:57:42          at InvokeStub_Migrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 fail: OrchardCore.Recipes.Services.RecipeMigrator[0]
2023-09-15 13:57:42       IRecipeEnvironmentProvider thrown from OrchardCore.Settings.RecipeEnvironmentSiteNameProvider by InvalidOperationException
2023-09-15 13:57:42       System.InvalidOperationException: Incorrect attempt to update an object that doesn't exist. Ensure a new object was not saved with an identifier value.
2023-09-15 13:57:42          at YesSql.Session.UpdateEntityAsync(Object entity, Boolean tracked, String collection)
2023-09-15 13:57:42          at YesSql.Session.FlushAsync()
2023-09-15 13:57:42          at YesSql.Session.FlushAsync()
2023-09-15 13:57:42          at YesSql.Services.DefaultQuery.Query`1.FirstOrDefaultImpl()
2023-09-15 13:57:42          at OrchardCore.Data.Documents.DocumentStore.GetOrCreateImmutableAsync[T](Func`1 factoryAsync)
2023-09-15 13:57:42          at OrchardCore.Documents.DocumentManager`1.GetOrCreateImmutableAsync(Func`1 factoryAsync)
2023-09-15 13:57:42          at OrchardCore.Settings.Services.SiteService.GetSiteSettingsAsync()
2023-09-15 13:57:42          at OrchardCore.Settings.RecipeEnvironmentSiteNameProvider.PopulateEnvironmentAsync(IDictionary`2 environment)
2023-09-15 13:57:42          at OrchardCore.Modules.InvokeExtensions.InvokeAsync[TEvents,T1](IEnumerable`1 events, Func`3 dispatch, T1 arg1, ILogger logger)
2023-09-15 13:57:42 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-15 13:57:42       Error while running migration version 0 for 'OrchardCore.OpenId'.
2023-09-15 13:57:42       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-15 13:57:42        ---> MySqlConnector.MySqlException (0x80004005): Table 'OC__OpenId_OpenIdApplicationIndex' already exists
2023-09-15 13:57:42          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-15 13:57:42          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
2023-09-15 13:57:42          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-15 13:57:42          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-15 13:57:42          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-15 13:57:42          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilder.CreateMapIndexTable(Type indexType, Action`1 table, String collection)
2023-09-15 13:57:42          at YesSql.Sql.SchemaBuilderExtensions.CreateMapIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-15 13:57:42          at OrchardCore.OpenId.YesSql.Migrations.OpenIdMigrations.Create()
2023-09-15 13:57:42          at InvokeStub_OpenIdMigrations.Create(Object, Object, IntPtr*)
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          --- End of inner exception stack trace ---
2023-09-15 13:57:42          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-15 13:57:42          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-15 13:57:42          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)
2023-09-15 13:57:42 info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
2023-09-15 13:57:42       Request finished HTTP/1.1 GET http://www.minilocallab.com/tachyon-cms - - - 302 0 - 2805.2999ms
2023-09-15 13:57:42 info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
2023-09-15 13:57:42       Request starting HTTP/1.1 GET http://www.minilocallab.com/ - -
2023-09-15 13:57:43 info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[58]
2023-09-15 13:57:43       Creating key {9679f2e7-1db3-4abf-9b33-3bd082b50a85} with creation date 2023-09-15 06:57:43Z, activation date 2023-09-15 06:57:43Z, and expiration date 2023-12-14 06:57:43Z.
2023-09-15 13:57:43 info: Microsoft.AspNetCore.DataProtection.Repositories.FileSystemXmlRepository[39]
2023-09-15 13:57:43       Writing data to file '/miniskylab/App_Data/Sites/Default/DataProtection-Keys/key-9679f2e7-1db3-4abf-9b33-3bd082b50a85.xml'.
2023-09-15 13:57:43 info: Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler[7]
2023-09-15 13:57:43       Identity.Application was not authenticated. Failure message: Unprotect ticket failed
2023-09-15 13:57:43 info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
2023-09-15 13:57:43       Executing endpoint 'MiniSkyLab.Tachyon.TachyonPageController.Get (Orchard.Tachyon)'
2023-09-15 13:57:43 info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102]
2023-09-15 13:57:43       Route matched with {area = "Orchard.Tachyon", action = "Get", controller = "TachyonPage"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] Get(System.String) on controller MiniSkyLab.Tachyon.TachyonPageController (Orchard.Tachyon).
2023-09-15 13:57:43 info: Microsoft.AspNetCore.Mvc.StatusCodeResult[1]
2023-09-15 13:57:43       Executing StatusCodeResult, setting HTTP status code 404
2023-09-15 13:57:43 info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105]
2023-09-15 13:57:43       Executed action MiniSkyLab.Tachyon.TachyonPageController.Get (Orchard.Tachyon) in 59.29ms
2023-09-15 13:57:43 info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
2023-09-15 13:57:43       Executed endpoint 'MiniSkyLab.Tachyon.TachyonPageController.Get (Orchard.Tachyon)'
2023-09-15 13:57:43 info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
2023-09-15 13:57:43       Request finished HTTP/1.1 GET http://www.minilocallab.com/ - - - 404 0 - 908.7476ms
@hyzx86 hyzx86 mentioned this issue Sep 17, 2023
Open
@sebastienros
Copy link
Member

All I know is that I upgraded from 1.5.0 to 1.7.0

Have you tried to upgrade to 1.6 then 1.7?

@sebastienros sebastienros modified the milestones: 1.8, 1.7 Sep 28, 2023
@jtkech
Copy link
Member

jtkech commented Sep 28, 2023

The default MySql collation has changed, we already have to reduce the size of some indexes, from memory for Alias and Workflows but not yet for OrchardCore.ContentFields.Indexing.SQL.

#13585 (comment)

#13585 (comment)

See these comments

OrchardCore/src/OrchardCore.Modules/OrchardCore.Alias/Migrations.cs

Lines 25 to 33 in 9a76299

// NOTE: The Alias Length has been upgraded from 64 characters to 767.
// For existing SQL databases update the AliasPartIndex tables Alias column length manually.
// INFO: The Alias Length is now of 735 chars, but this is only used on a new installation.
SchemaBuilder.CreateMapIndexTable<AliasPartIndex>(table => table
.Column<string>("Alias", col => col.WithLength(AliasPart.MaxAliasLength))
.Column<string>("ContentItemId", c => c.WithLength(26))
.Column<bool>("Latest", c => c.WithDefault(false))
.Column<bool>("Published", c => c.WithDefault(true))
);

OrchardCore/src/OrchardCore.Modules/OrchardCore.Alias/Models/AliasPart.cs

Lines 5 to 11 in 9a76299

public class AliasPart : ContentPart
{
// Maximum length that MySql can support in an index under utf8mb4 collation is 768,
// minus 2 for the `DocumentId` integer (bigint size = 8 bytes = 2 character size),
// minus 26 for the `ContentItemId` and 1 for the 'Published' and 'Latest' bools.
// minus 4 to allow at least to add a new integer column.
public const int MaxAliasLength = 735;

Just checking the TextFieldIndex, yes it is already too long, we would need to decrease for example the MaxContentTypeSize, MaxContentPartSize and MaxContentFieldSize.

Anyway would only work for fresh installations, so for now the column length of the related index tables need to be changed manually.

@hieucd04
Copy link
Author

@sebastienros

Have you tried to upgrade to 1.6 then 1.7?

I haven't.
However, I did tried something else:

  1. I factory reset my Docker -> So now, I should have a completely fresh start with no data left
  2. Build & deploy my project to Docker (which uses Orchard Core 1.7) -> Everything works fine, I can access the Dashboard without any exception thrown
  3. Create a test content type with a text field in it -> Still OK, no exception
  4. Enable Content Fields Indexing (SQL) feature -> Boom! Exception thrown
2023-09-29 16:56:41 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-09-29 16:56:41       Error while running migration version 0 for 'OrchardCore.ContentFields.Indexing.SQL'.
2023-09-29 16:56:41       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-09-29 16:56:41        ---> MySqlConnector.MySqlException (0x80004005): Specified key was too long; max key length is 3072 bytes
2023-09-29 16:56:41          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175
2023-09-29 16:56:41          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
2023-09-29 16:56:41          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493
2023-09-29 16:56:41          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77
2023-09-29 16:56:41          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-09-29 16:56:41          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-09-29 16:56:41          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-09-29 16:56:41          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-09-29 16:56:41          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-09-29 16:56:41          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-09-29 16:56:41          at YesSql.Sql.SchemaBuilder.AlterTable(String name, Action`1 table)
2023-09-29 16:56:41          at YesSql.Sql.SchemaBuilder.AlterIndexTable(Type indexType, Action`1 table, String collection)
2023-09-29 16:56:41          at YesSql.Sql.SchemaBuilderExtensions.AlterIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-09-29 16:56:41          at OrchardCore.ContentFields.Indexing.SQL.Migrations.Create()
2023-09-29 16:56:41          at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
2023-09-29 16:56:41          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-29 16:56:41          --- End of inner exception stack trace ---
2023-09-29 16:56:41          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-09-29 16:56:41          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-09-29 16:56:41          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)

@jtkech

Anyway would only work for fresh installations

Shouldn't be a problem.
I can export all my data to a zip file via Deployment Plan and then Re-import them after a fresh installation.

we would need to decrease for example the MaxContentTypeSize, MaxContentPartSize and MaxContentFieldSize

Just to confirm, is this something you guys will fix and release in upcoming versions of Orchard Core?

@sebastienros
Copy link
Member

We spent some time trying to understand the issue during triage and we think we understand the issues completely.

An index entry in MySQL can't contain more than 3072 bytes. With the current default utf8nb4 collation this accounts for 768 chars. This means that all the fields which make up an index entry can't go over that, but only in MySQL.

MySQL has a custom syntax to define the prefix size of an index, meaning the amount of data to use for each field. For instance we can limit the Alias field size in the index with CREATE INDEX ... (DocumentId, Alias(50), ...) and then it would only take the first 50 chars even if the content is bigger. This way we can have limits on the content itself, MaxAliasSize, but a distinct max size for the index. And we wouldn't need to constrain the field size to the index size for MySQL.

In YesSql the columns names are injected as-is in the SQL Query: https://github.com/sebastienros/yessql/blob/c0771eb555c67bf419859016cb3563a3540fe7c7/src/YesSql.Core/Sql/BaseComandInterpreter.cs#L233

So if we change the current migration to something like this, this would work:

            SchemaBuilder.AlterIndexTable<AliasPartIndex>(table => table
                .CreateIndex("IDX_AliasPartIndex_DocumentId",
                    "DocumentId",
                    "Alias(123)",
                    "ContentItemId",
                    "Published",
                    "Latest")
            );

... as long as the sum of these constraints is less than 767 chars. (this doesn't work on binary formats, e.g. bools, numbers, ...)

But this only works for MySql, so if we don't want to change YesSql we need to do an if on the db provider in the Schema generation (is that possible?).

The other option is to use this syntax in all cases (any db provider) and have YesSql custom command interpreters exclude this part when it's not supported.

@MikeAlhayek MikeAlhayek mentioned this issue Oct 10, 2023
Merged
@hishamco hishamco mentioned this issue Oct 12, 2023
Merged
MikeAlhayek added a commit that referenced this issue Oct 12, 2023
@MikeAlhayek
Set index length limit for MySQL
d1e60dc 
Fix #14338
@MikeAlhayek MikeAlhayek mentioned this issue Oct 12, 2023
Merged
sebastienros pushed a commit that referenced this issue Oct 13, 2023
@MikeAlhayek
Set index length limit for MySQL (#14500)
031db8f 
Fix #14338
MikeAlhayek added a commit that referenced this issue Oct 13, 2023
@MikeAlhayek
Set index length limit for MySQL (#14500)
6a958ca 
Fix #14338
sebastienros pushed a commit that referenced this issue Oct 13, 2023
@MikeAlhayek @yaricrolletservico @hishamco
Release 1.7.1 (#14474)
d2f29c5 
Fix #14338

---------

Co-authored-by: yaricrolletservico <101557629+yaricrolletservico@users.noreply.github.com>
Co-authored-by: Hisham Bin Ateya <hishamco_2007@yahoo.com>
@hieucd04
Copy link
Author

@sebastienros @jtkech:
I'm just asking ... is this fixed in 1.7.1 release?
Because I was testing 1.7.1 and was still able to reproduce this issue with the steps I mentioned above:

  1. I factory reset my Docker -> So now, I should have a completely fresh start with no data left
  2. Build & deploy my project to Docker (which uses Orchard Core 1.7.1) -> Everything works fine, I can access the Dashboard without any exception thrown
  3. Create a test content type with a text field in it -> Still OK, no exception
  4. Enable Content Fields Indexing (SQL) feature -> Boom! Exception thrown

(New logs pasted from Docker)

2023-10-15 19:49:02 fail: OrchardCore.Data.Migration.DataMigrationManager[0]
2023-10-15 19:49:02       Error while running migration version 0 for 'OrchardCore.ContentFields.Indexing.SQL'.
2023-10-15 19:49:02       System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
2023-10-15 19:49:02        ---> MySqlConnector.MySqlException (0x80004005): Specified key was too long; max key length is 3072 bytes
2023-10-15 19:49:02          at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175
2023-10-15 19:49:02          at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133
2023-10-15 19:49:02          at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493
2023-10-15 19:49:02          at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77
2023-10-15 19:49:02          at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 296
2023-10-15 19:49:02          at MySqlConnector.MySqlCommand.ExecuteNonQuery() in /_/src/MySqlConnector/MySqlCommand.cs:line 107
2023-10-15 19:49:02          at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader) in /_/Dapper/SqlMapper.cs:line 2848
2023-10-15 19:49:02          at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command) in /_/Dapper/SqlMapper.cs:line 581
2023-10-15 19:49:02          at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 452
2023-10-15 19:49:02          at YesSql.Sql.SchemaBuilder.Execute(IEnumerable`1 statements)
2023-10-15 19:49:02          at YesSql.Sql.SchemaBuilder.AlterTable(String name, Action`1 table)
2023-10-15 19:49:02          at YesSql.Sql.SchemaBuilder.AlterIndexTable(Type indexType, Action`1 table, String collection)
2023-10-15 19:49:02          at YesSql.Sql.SchemaBuilderExtensions.AlterIndexTable[T](ISchemaBuilder builder, Action`1 table, String collection)
2023-10-15 19:49:02          at OrchardCore.ContentFields.Indexing.SQL.Migrations.Create()
2023-10-15 19:49:02          at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
2023-10-15 19:49:02          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-10-15 19:49:02          --- End of inner exception stack trace ---
2023-10-15 19:49:02          at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
2023-10-15 19:49:02          at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
2023-10-15 19:49:02          at OrchardCore.Data.Migration.DataMigrationManager.UpdateAsync(String featureId)

@jtkech
Copy link
Member

jtkech commented Oct 15, 2023 •
edited
Loading

After a quick look there is at least one missing index that has not been reduced

This one has been reduced

        // The index in MySQL can accommodate up to 768 characters or 3072 bytes.
        // DocumentId (2) + ContentType (254) + ContentPart (254) + ContentField (254)
        // + Published (1) + Latest (1) = 766 (less than 768)
        SchemaBuilder.AlterIndexTable<TextFieldIndex>(table => table
            .CreateIndex("IDX_TextFieldIndex_DocumentId_ContentType",
                "DocumentId",
                "ContentType(254)",
                "ContentPart(254)",
                "ContentField(254)",
                "Published",
                "Latest")
        );

But not this one, the size of Text being of MaxTextSize equal to 766 chars size.

So DocumentId (2) + Text (766) + even if both booleans only take 1 char size = 769 chars.

No luck, the max is 768 chars size => 768 * 4 = 3072 bytes ;)

        SchemaBuilder.AlterIndexTable<TextFieldIndex>(table => table
            .CreateIndex("IDX_TextFieldIndex_DocumentId_Text",
                "DocumentId",
                "Text", // <= 766 chars size
                "Published",
                "Latest")
        );

Edited: Idem for this one

        SchemaBuilder.AlterIndexTable<LinkFieldIndex>(table => table
            .CreateIndex("IDX_LinkFieldIndex_DocumentId_Url",
                "DocumentId",
                "Url", // <= 766 chars size
                "Published",
                "Latest")
        );

And this one

        SchemaBuilder.AlterIndexTable<MultiTextFieldIndex>(table => table
            .CreateIndex("IDX_MultiTextFieldIndex_DocumentId_Value",
                "DocumentId",
                "Value", // <= 766 chars size
                "Published",
                "Latest")
        );

@hishamco
Copy link
Member

Is that mean we need a hot fix?

@jtkech
Copy link
Member

jtkech commented Oct 15, 2023

Yes I think, maybe 1.7.2 ;)

@sebastienros
Copy link
Member

The feature needs to be enabled in functional tests as part of the fix.

@MikeAlhayek MikeAlhayek mentioned this issue Oct 16, 2023
Merged
@hishamco
Copy link
Member

IMHO no need to rush during the release to avoid such issues

@MikeAlhayek
Copy link
Member

@hieucd04 1.7.2 was released today. Please give that a try and let us know if you run into additional issues.

Thank you

@hieucd04
Copy link
Author

hieucd04 commented Oct 18, 2023 •
edited
Loading

@MikeAlhayek
Yes! I'm testing 1.7.2 with my data and I don't see any exception relating to the MySQL index issue in the log stream anymore.
At this point, I would say 1.7.2 did fixed the MySQL index issue on my side. Thank you all for your efforts. Appreciate it!

FYI, while testing 1.7.2, I got some exceptions thrown in the log stream which I've never seen before while using Orchard Core.
I've opened a new issue to track it: #14539

@jtkech
Copy link
Member

jtkech commented Oct 18, 2023

Yes I saw the issue, are you using the OpenId feature?

@hieucd04
Copy link
Author

@jtkech
Yes, I do!

I enabled the below OpenId features:

"OrchardCore.OpenId.Server",
"OrchardCore.OpenId.Validation",

@jtkech
Copy link
Member

jtkech commented Oct 18, 2023

Can't repro by just enabling these 2 features but there is nothing to prune, but I can see the query well executed in the background task (I set the period to 1 minute for testing).

I will copy paste this comment in the related issue

DrewScoggins added a commit to dotnet-perf-bot/OrchardCore that referenced this issue Dec 1, 2023
@DrewScoggins @agriffard
@sebastienros @MikeAlhayek @hishamco @ludovic-th @hyzx86 @jtkech @netwavebe @vjacquet @SzymonSel @emrahtokalak @xperiandri @yaricrolletservico @tbolon @giannik @wAsnk @lampersky @DemeSzabolcs @Piedone @spyraklas @mvarblow @elaurentin @minhtaile2712
Fix lock issue (#9)
53d8d60 
* mkdocs-material 9.2.8

* Release 1.7 (OrchardCMS#14111)

* Switch to 1.8.0-preview

* Position the modal over the navbar (OrchardCMS#14270)

* Add 1.8 release notes file. (OrchardCMS#14277)

* jQuery 3.7.1 (OrchardCMS#14231)

* Add @brutoledo as a contributor

* Add @dannyd89 as a contributor

* Typo SMS features

* Update libphonenumber-csharp 8.13.20 (OrchardCMS#14287)

* NLog.Web.AspNetCore 5.3.4 (OrchardCMS#14283)

* leaflet 1.9.4 (OrchardCMS#14054)

* bootstrap-select 1.14.0-beta3 (OrchardCMS#14282)

* Fixes invalid cookie name (OrchardCMS#14280)

* Add @ludovic-th as a contributor

* Move Moq into tests libraries (OrchardCMS#14260)

* Microsoft.Identity.Web 2.13.4 (OrchardCMS#14292)

* BenchmarkDotNet 0.13.8 (OrchardCMS#14293)

* mkdocs-material 9.3.0

* mkdocs-material 9.3.1

* Remove duplicate alert in settings (OrchardCMS#14299)

* Make WorkflowType extension able (OrchardCMS#14275)

* NET 6.0.22, 7.0.11 (OrchardCMS#14320)

* Update OpenIddict 4.8.0 (OrchardCMS#14321)

* Update Jint 3.0.0-beta-2051 (OrchardCMS#14322)

* Add IsViewOrPageResult() extension (OrchardCMS#14228)

* Use language keywords instead of framework type names for type references (IDE0049) (OrchardCMS#14273)

* Few missing language types in .cs (OrchardCMS#14323)

* Language Types in Razor files (OrchardCMS#14324)

* Handle InvalidToken in UserService.ProcessValidationErrors() (OrchardCMS#14331)

Co-authored-by: Mike Alhayek <mike@crestapps.com>

* Make SRI hashes consistent (OrchardCMS#13775)

* Update Form Migrations Create() (OrchardCMS#14272)

* Fix media item icon (OrchardCMS#14342)

* Update Azure.Storage.Blobs 12.18.0 (OrchardCMS#14326)

* mkdocs 1.5.3

* mkdocs-material 9.3.2

* Update Jint to 3.0.0-beta-2052 (OrchardCMS#14369)

* Update libphonenumber-csharp 8.13.21 (OrchardCMS#14376)

* xunit 2.5.1, xunit.runner.visualstudio 2.5.1, xunit.runner.visualstudio 1.3.0 (OrchardCMS#14379)

* Azure.Identity 1.10.1 (OrchardCMS#14378)

* ZString 2.5.1 (OrchardCMS#14377)

* mkdocs-material 9.4.0

* mkdocs-material 9.4.1

* mkdocs-material 9.4.2

* Fix Monaco doc link (OrchardCMS#14387)

* Upgrade to Bootstrap 5.3.2 (OrchardCMS#14294)

* Fixing Icon-Picker and cleanup sass (OrchardCMS#14393)

* Set html classes to make the scripts work again (removed in OrchardCMS#9371) (OrchardCMS#14367)

* Add a fallback function to crypto.randomUUID (OrchardCMS#14371)

* Update HtmlSantizer 8.0.718 (OrchardCMS#14395)

* Update Microsoft.Identity.Web 2.14.0 (OrchardCMS#14394)

* SASS files cleanup in TheAdmin theme (OrchardCMS#14399)

* Fix validation color in the login layout (OrchardCMS#14400)

* Update Fluid 2.5.0 (OrchardCMS#14402)

* Trim Async suffix (OrchardCMS#14407)

Co-authored-by: Vincent Jacquet <vjacquet@wmcsoft.com>

* Typos in OrchardCore.Notifications (OrchardCMS#14409)

* Update libphonenumber-csharp 8.13.22 (OrchardCMS#14408)

* Fix doc typo (OrchardCMS#14411)

* mkdocs-material 9.4.3

* fix: workflow module page list issue when using PostgreSQL OrchardCMS#14334 (OrchardCMS#14412)

* Add @emrahtokalak as a contributor

* Add @vjacquet as a contributor

* Fix randomUUID, modal dialog and duplicate alerts

* Add a fallback function to crypto.randomUUID (OrchardCMS#14371)
* Fix modal dialog location
* Remove duplicate alert in settings (OrchardCMS#14299)
Co-authored-by: Hisham Bin Ateya <hishamco_2007@yahoo.com>

* Add OC.Notifications.Abstractions docs (OrchardCMS#14427)

* Fix `Creating a modular ASP.NET Core application` tutorial (OrchardCMS#14415)

Emphasize that reference must be added from the applicaiton to the module

* mkdocs-material 9.4.4

* Fix form validation and link decoration (BS 5.3) (OrchardCMS#14432)

* Fix admin menu background color on small screen. (OrchardCMS#14434)

* Open the front page in the same browser instead of a blank tab. (OrchardCMS#14435)

* Fix Publish Later Buttons (OrchardCMS#14438)

* Cleanup Archive/Publish Later and remove unnecessary assets and resources (OrchardCMS#14441)

* BenchmarkDotNet 0.13.9 (OrchardCMS#14436)

* Update HtmlSantizer 8.0.723 (OrchardCMS#14429)

* Microsoft.Identity.Web 2.15.1 (OrchardCMS#14437)

* AdminBranding (OrchardCMS#14453)

* Admin Navbar link (OrchardCMS#14454)

* Upgrade TheTheme to use Bootstrap 5.3.2 (OrchardCMS#14451)

* Fix sortable widgets (OrchardCMS#14467)

* Remove "Cannot update your own roles" warning (OrchardCMS#14440)

* Fix null exception in EmailTask (OrchardCMS#14471)

* mkdocs-material 9.4.5

* Fix WidgetsListPart UI (OrchardCMS#14461)

* Memory Leaks (OrchardCMS#14348)

* Update 7.0.12 & 6.0.23 (OrchardCMS#14478)

* OpenIddict 4.9.0 (OrchardCMS#14463)

* Fix an exception in ListPart with header (OrchardCMS#14473)

* fix: workflow module page list issue when using PostgreSQL OrchardCMS#14334 (OrchardCMS#14412) (OrchardCMS#14428)

* Fix roles filter (OrchardCMS#14468)

* Docs tabs

* Enable tabs

* Docs missing links

* Docs enable footer (Previous, Next link)

* Typo Release 1.8

* Docs reference links

* Azure.Identity 1.10.2 (OrchardCMS#14494)

* Update Taxomony field (OrchardCMS#14477)

* Introduce a new Narbar shape (OrchardCMS#14488)

* Can't Reload Stream Config Provider (OrchardCMS#14499)

* Update YesSQL 3.4.0 (OrchardCMS#14491)

* NRE in query editor (OrchardCMS#14501)

* Set index length limit for MySQL (OrchardCMS#14500)

Fix OrchardCMS#14338

* Fix a typo (OrchardCMS#14503)

* Fix TheBlogTheme shared views (OrchardCMS#14493)

* Release 1.7.1 (OrchardCMS#14474)

Fix OrchardCMS#14338

---------

Co-authored-by: yaricrolletservico <101557629+yaricrolletservico@users.noreply.github.com>
Co-authored-by: Hisham Bin Ateya <hishamco_2007@yahoo.com>

* Fix mysql functional tests (OrchardCMS#14502)

* Release 1.7.1 (OrchardCMS#14506)

Co-authored-by: Sébastien Ros <sebastienros@gmail.com>

* Add @yaricrolletservico as a contributor

* mkdocs-material 9.4.6

* Docs GraphQL: Fix url api/graphql

* Fix messages class names (OrchardCMS#14508)

* Update 1.7.1 release notes (OrchardCMS#14509)

* js-cookie does not need to depend on jQuery (OrchardCMS#14511)

* mkdocs-git-revision-date-localized-plugin 1.2.1

* NLog.Web.AspNetCore 5.3.5

* centrally define media resources (OrchardCMS#14512)

* Fix TheAdmin & TheTheme for RTL languages (OrchardCMS#14486)

* Fixing TheTheme newly intruduced accessibility rules and HTML rules violations (Lombiq Technologies: NEST-462) (OrchardCMS#14523)

* Update libphonenumber-csharp 8.13.23 (OrchardCMS#14529)

* Add @yk as a contributor

* Fix MySQL index length (OrchardCMS#14513)

* Release 1.7.2 (OrchardCMS#14532)

* Revert " Add @yk as a contributor"

This reverts commit ce82352.

* Save Shell Config SubSections (OrchardCMS#14490)

* Microsoft.Identity.Web 2.15.2 (OrchardCMS#14540)

* SMTP should send the email if the SSL certificate is invalid (OrchardCMS#14444)

Co-authored-by: Sébastien Ros <sebastienros@gmail.com>

* Thumbnails for media app (OrchardCMS#14528)

* Add a way to restart a workflow instance (OrchardCMS#14470)

* pymdown-extensions 10.3.1

* Cleanup ReCaptcha services (OrchardCMS#14333)

Co-authored-by: Sébastien Ros <sebastienros@gmail.com>

* Change how ReCaptchaService consumes HttpClient (OrchardCMS#14544)

* Move ContentRootPoFileLocationProvider to OC.Localization.Core.PortableObject folder (OrchardCMS#13713)

* User Accounts and Custom User Settings Deployment (OrchardCMS#14208)

Co-authored-by: Mike Alhayek <mike@crestapps.com>
Co-authored-by: Hisham Bin Ateya <hishamco_2007@yahoo.com>

* xunit 2.5.3 (OrchardCMS#14558)

* Azure.Identity 1.10.3 (OrchardCMS#14557)

* Microsoft.Identity.Web 2.15.3 (OrchardCMS#14556)

* Jint 3.0.0-beta-2053 (OrchardCMS#14560)

* Media caches cleanups (OrchardCMS#14087)

* Add KeyVault without building a config (OrchardCMS#14550)

* Dotnet 8.0 (OrchardCMS#14058)

* Missing sdk (OrchardCMS#14561)

* js-cookie 3.0.5 (OrchardCMS#14559)

* HtmlSanitizer 8.0.746 (OrchardCMS#14577)

* correct bootstrap-select dependency (OrchardCMS#14578)

* Throw descriptive exception when a field is added with no type. (OrchardCMS#14569)

* Add extensions for IDisplayManager (OrchardCMS#14579)

* Register ReCaptchaService as singleton (OrchardCMS#14583)

Co-authored-by: Sébastien Ros <sebastienros@gmail.com>

* Assign the technical name of the field as the display name by default (OrchardCMS#14571)

* Use shape when rendering Http errors to allow cusomization from the UI (OrchardCMS#14545)

* Fix field wrappers CSS class names (OrchardCMS#14547)

* Cleanup ReCaptchaService after changing the registration type (OrchardCMS#14587)

* .NET 6.0.24, 7.0.13 (OrchardCMS#14575)

* Update GetPartWrapperCssClasses and GetFieldWrapperCssClasses helpers (OrchardCMS#14591)

* mkdocs-material 9.4.7

* Improve AdminDashboard Styling (OrchardCMS#14593)

* Monaco 0.44.0

* remove admin.css resource dependency on audit trail list (OrchardCMS#14608)

fixes OrchardCMS#14607

* Update the Admin Dashboard documentation. (OrchardCMS#14602)

* Monaco js error fix (OrchardCMS#14601)

* Remove admin.js dependency on fields and parts (OrchardCMS#14600)

* Update libphonenumber-csharp 8.13.24 (OrchardCMS#14619)

* xunit 2.6.0 (OrchardCMS#14618)

* Update StackExchange.Redis 2.7.4 (OrchardCMS#14620)

* Use CommitAsync() instead od Commit() (OrchardCMS#14622)

* BenchmarkDotNet 0.13.10 (OrchardCMS#14623)

* Add a shortcode for cache busting (OrchardCMS#14621)

Co-authored-by: Zoltán Lehóczky <zoltan.lehoczky@lombiq.com>
Co-authored-by: Hisham Bin Ateya <hishamco_2007@yahoo.com>

* Invalidate cache on updating store (OrchardCMS#14612)

* Improve performance for CssClass extensions (OrchardCMS#14615)

* Do not show dashboard widget when `DashboardWidget` is removed. (OrchardCMS#14603)

* mkdocs-material 9.4.8

* Update Jint 3.0.0-beta-2054 (OrchardCMS#14633)

* Address CssClasses helper warning (OrchardCMS#14643)

* Fix content preview editor resource dependency (OrchardCMS#14642)

* Fix the Content-preview script (OrchardCMS#14644)

* Azure.Storage.Blobs 12.19.0 (OrchardCMS#14647)

* xunit 2.6.1 (OrchardCMS#14646)

* Register TwoFactorAuthenticationClaimsProvider service (OrchardCMS#14651)

Fix OrchardCMS#14650

* Fix monaco editor widget error

* Initialize logger for YesSql to enable logging (OrchardCMS#14659)

* Cleanup workflow activities (OrchardCMS#14597)

* Microsoft.NET.Test.Sdk 17.8.0 (OrchardCMS#14665)

* pymdown-extensions 10.4

* Minor performance update for HtmlContentBuilderExtensions (OrchardCMS#14664)

* Update MailKit & MimiKit 4.3.0 (OrchardCMS#14669)

* Update xUnit Analyzers 1.5.0 (OrchardCMS#14670)

* Update Azure.Extensions.AspNetCore.Configuration.Secrets 1.3.0 (OrchardCMS#14672)

* Update Jint 3.0.0-beta-2055 (OrchardCMS#14671)

* Log a message every time Redis ConnectionMultiplexer is created

* Update Azure Identity 1.10.4 (OrchardCMS#14690)

* .NET 8.0.0 (OrchardCMS#14688)

* Update Azure Blobs 12.19.1 (OrchardCMS#14691)

* Update .NET 7.0.14 & .NET 6.0.25 (OrchardCMS#14689)

* Fix missing claims for OpenID code flow. (OrchardCMS#14686)

* OpenIddict 4.10.0 (OrchardCMS#14692)

* Add form originated http redirect task (OrchardCMS#14610)

* Set the docker image to .NET 8 (OrchardCMS#14696)

* Update workflows and test runners to use .net 8 (OrchardCMS#14702)

* Update YesSql to version 3.5.0 (OrchardCMS#14706)

* Update Moq 4.20.69 (OrchardCMS#14705)

* Drop support for .NET 6/7 (OrchardCMS#14695)

* mkdocs-material 9.4.9

* Update Microsoft.SourceLink.GitHub 8.0.0 (OrchardCMS#14714)

* Remove 'Async' term from a synchronous method (OrchardCMS#14710)

* Missing connection dispose (OrchardCMS#14709)

* Use C# 12.0 (OrchardCMS#14713)

* Little cleanup (OrchardCMS#14711)

* Register DataProtection_Azure asynchronously (OrchardCMS#14687)

* Typos in Media (OrchardCMS#14708)

* Update DocumentFormat.OpenXml 3.0.0 (OrchardCMS#14718)

* mkdocs-material 9.4.10

* xUnit VS runner (OrchardCMS#14725)

* Update xunit analyzers 1.6.0 (OrchardCMS#14724)

* Update xunit 2.6.2 (OrchardCMS#14723)

* Should not invalidate the cache of a Volatile Document. (OrchardCMS#14720)

As it is never persisted and can't be retrieved from a given store, see PR comment.

* Update Jint 3.0.0-beta-2056 (OrchardCMS#14729)

* Fix the Github release action on Windows (OrchardCMS#14707)

* Add a way to Remove User from a Role (Issue OrchardCMS#14632) (OrchardCMS#14652)

---------

Co-authored-by: Mike Alhayek <mike@crestapps.com>

* Update Microsoft.Identity.Web 2.15.5 (OrchardCMS#14733)

* Update libphonenumber-csharp  8.13.24 (OrchardCMS#14734)

* Fix Docker build (OrchardCMS#14736)

* Fix docker build (OrchardCMS#14737)

* Fix doc semantic error (OrchardCMS#14742)

* mkdocs-material>=9.4.11

* Add Async method to ContentDefinitionManager to prevent possible thread starvation (OrchardCMS#14668)

* Cleanup notifications module (OrchardCMS#14745)

* Pre-render Navbar to allow resource injection (OrchardCMS#14747)

* Add As/Put method to ISite to allow caching (OrchardCMS#14372)

* Typo (OrchardCMS#14741)

* Cleanup (OrchardCMS#14740)

* Remove compiler directives (OrchardCMS#14739)

* mkdocs-material 9.4.12

* Update HtmlSanitizer 8.0.795 (OrchardCMS#14753)

* Update  AngleSharp 1.0.6 (OrchardCMS#14673)

* pymdown-extensions 10.5

* mkdocs-material 9.4.13

* Pre-render Navbar to allow resource injection (OrchardCMS#14755)

* Don't throw lock timeout if shell activated (OrchardCMS#14756)

* Azure DP Initializer (OrchardCMS#14750)

* mkdocs-material 9.4.14

* Update Microsoft.Identity.Web 2.16.0 (OrchardCMS#14778)

* Missing OC.Media dependency (OrchardCMS#14758)

* Remove the double scroll in the notification item (OrchardCMS#14781)

* Update libphonenumber-csharp 8.13.26 (OrchardCMS#14788)

* Fix multi-targeting file locks (OrchardCMS#14732)

* Fix send button style in OC.Email (OrchardCMS#14804)

* Adding helpful methods for ContentPart, ContentType builders and Cont… (OrchardCMS#14717)

* Add full type name for Lucene lock type

In net9.0 the runtime now exposes it's own `Lock` type, dotnet/runtime#87672. This causes
a build break as there is a collision between the Lucene type and the
runtime type.

---------

Co-authored-by: Antoine Griffard <agriffard@hotmail.com>
Co-authored-by: Sébastien Ros <sebastienros@gmail.com>
Co-authored-by: Mike Alhayek <mike@crestapps.com>
Co-authored-by: Hisham Bin Ateya <hishamco_2007@yahoo.com>
Co-authored-by: ludovic-th <65158865+ludovic-th@users.noreply.github.com>
Co-authored-by: Tony Han <huarui2219@qq.com>
Co-authored-by: Jean-Thierry Kéchichian <jean-thierry.kechichian@wanadoo.fr>
Co-authored-by: Steven Spits <steven@netwave.be>
Co-authored-by: vjacquet <vjacquet@users.noreply.github.com>
Co-authored-by: Vincent Jacquet <vjacquet@wmcsoft.com>
Co-authored-by: Szymon Seliga <SzymonSel@users.noreply.github.com>
Co-authored-by: Emrah Tokalak <emrahtokalak@gmail.com>
Co-authored-by: Andrii Chebukin <XperiAndri@Outlook.com>
Co-authored-by: yaricrolletservico <101557629+yaricrolletservico@users.noreply.github.com>
Co-authored-by: Thomas Bolon <tbolon@users.noreply.github.com>
Co-authored-by: yk <giannkyrias@gmail.com>
Co-authored-by: Krisztián Németh <krisztian.nemeth@lombiq.com>
Co-authored-by: lampersky <lampersky@gmail.com>
Co-authored-by: Szabolcs Deme <80963259+DemeSzabolcs@users.noreply.github.com>
Co-authored-by: Zoltán Lehóczky <zoltan.lehoczky@lombiq.com>
Co-authored-by: Spyros <93044877+spyraklas@users.noreply.github.com>
Co-authored-by: Matt Varblow <mvarblow@users.noreply.github.com>
Co-authored-by: Banzai316 <elaurentin@users.noreply.github.com>
Co-authored-by: minhtaile2712 <minhtaile2712@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug 🐛
Projects
None yet
Milestone
1.7
5 participants
@sebastienros @hishamco @jtkech @MikeAlhayek @hieucd04