ONLYOFFICE 7.0: online forms, password protection in sheets, collaboration improvements and much more
ONLYOFFICE 7.0 released

Can't backup portal

Do you want to: Ask a how-to question
Community Server/Control Panel version: 11.6.0.1620 / 3.0.3.410
Type of installation of Workspace: docker
OS: Debian 11
Browser version: Chrome

When trying to backup from controlpanel/backup I got an error: Unable to convert MySQL date/time value to System.DateTime
Same in svcBackup.log:
2022-04-10 14:41:41,611 ERROR [27] ASC - MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime
at MySql.Data.Types.MySqlDateTime.GetDateTime () [0x00012] in <8235ed0ad41343b3a11f3dc973b415b6>:0
at MySql.Data.MySqlClient.MySqlDataReader.GetValue (System.Int32 i) [0x000ad] in <8235ed0ad41343b3a11f3dc973b415b6>:0
at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.Int32 i) [0x00000] in <8235ed0ad41343b3a11f3dc973b415b6>:0
at ASC.Common.Data.DataExtensions.ExecuteListReaderResult (System.Data.IDataReader reader) [0x0001a] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteListReader (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, System.String sql, System.Object[] parameters) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, ASC.Common.Data.Sql.ISqlInstruction sql, ASC.Common.Data.Sql.ISqlDialect dialect) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DbManager.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x0000d] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Data.Backup.Tasks.BackupPortalTask.GetDataWithPrimary (System.String t, System.Collections.Generic.List1[T] columns, System.String primary, System.Int32 start, System.Int32 step) [0x00043] in <8ad57f9204024ae59da40dac0991a2eb>:0 at ASC.Data.Backup.Tasks.BackupPortalTask.DumpTableData (System.String t, System.String dir, System.Int32 count) [0x001c2] in <8ad57f9204024ae59da40dac0991a2eb>:0 MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime at MySql.Data.Types.MySqlDateTime.GetDateTime () [0x00012] in <8235ed0ad41343b3a11f3dc973b415b6>:0 at MySql.Data.MySqlClient.MySqlDataReader.GetValue (System.Int32 i) [0x000ad] in <8235ed0ad41343b3a11f3dc973b415b6>:0 at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.Int32 i) [0x00000] in <8235ed0ad41343b3a11f3dc973b415b6>:0 at ASC.Common.Data.DataExtensions.ExecuteListReaderResult (System.Data.IDataReader reader) [0x0001a] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteListReader (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, System.String sql, System.Object[] parameters) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, ASC.Common.Data.Sql.ISqlInstruction sql, ASC.Common.Data.Sql.ISqlDialect dialect) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DbManager.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x0000d] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Data.Backup.Tasks.BackupPortalTask.GetDataWithPrimary (System.String t, System.Collections.Generic.List1[T] columns, System.String primary, System.Int32 start, System.Int32 step) [0x00043] in <8ad57f9204024ae59da40dac0991a2eb>:0
at ASC.Data.Backup.Tasks.BackupPortalTask.DumpTableData (System.String t, System.String dir, System.Int32 count) [0x001c2] in <8ad57f9204024ae59da40dac0991a2eb>:0
2022-04-10 14:41:41,637 ERROR [9] ASC - RunJob - Params: { Id = f6422fc0-f8ed-45ce-8245-6c62ae04350e, Tenant = 1, File = /var/www/onlyoffice/Data/temp/localhost_2022-04-10_14-41-37.tar.gz, BasePath = }, Error = System.AggregateException: One or more errors occurred. (Unable to convert MySQL date/time value to System.DateTime) —> MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime
at MySql.Data.Types.MySqlDateTime.GetDateTime () [0x00012] in <8235ed0ad41343b3a11f3dc973b415b6>:0
at MySql.Data.MySqlClient.MySqlDataReader.GetValue (System.Int32 i) [0x000ad] in <8235ed0ad41343b3a11f3dc973b415b6>:0
at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.Int32 i) [0x00000] in <8235ed0ad41343b3a11f3dc973b415b6>:0
at ASC.Common.Data.DataExtensions.ExecuteListReaderResult (System.Data.IDataReader reader) [0x0001a] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteListReader (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, System.String sql, System.Object[] parameters) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, ASC.Common.Data.Sql.ISqlInstruction sql, ASC.Common.Data.Sql.ISqlDialect dialect) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Common.Data.DbManager.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x0000d] in <96a81f2b5ce744ef90c32874e89bb46b>:0
at ASC.Data.Backup.Tasks.BackupPortalTask.GetDataWithPrimary (System.String t, System.Collections.Generic.List1[T] columns, System.String primary, System.Int32 start, System.Int32 step) [0x00043] in <8ad57f9204024ae59da40dac0991a2eb>:0 at ASC.Data.Backup.Tasks.BackupPortalTask.DumpTableData (System.String t, System.String dir, System.Int32 count) [0x0023b] in <8ad57f9204024ae59da40dac0991a2eb>:0 at ASC.Data.Backup.Tasks.BackupPortalTask+<>c__DisplayClass16_1.<DoDump>b__8 () [0x00032] in <8ad57f9204024ae59da40dac0991a2eb>:0 at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <f2b3ab7dfff746f594d2ef5b16ec3c90>:0 at System.Threading.Tasks.Task.Execute () [0x00000] in <f2b3ab7dfff746f594d2ef5b16ec3c90>:0 --- End of inner exception stack trace --- at System.Threading.Tasks.Task.WaitAll (System.Threading.Tasks.Task[] tasks, System.Int32 millisecondsTimeout, System.Threading.CancellationToken cancellationToken) [0x001c8] in <f2b3ab7dfff746f594d2ef5b16ec3c90>:0 at System.Threading.Tasks.Task.WaitAll (System.Threading.Tasks.Task[] tasks, System.Int32 millisecondsTimeout) [0x00000] in <f2b3ab7dfff746f594d2ef5b16ec3c90>:0 at System.Threading.Tasks.Task.WaitAll (System.Threading.Tasks.Task[] tasks) [0x00000] in <f2b3ab7dfff746f594d2ef5b16ec3c90>:0 at ASC.Data.Backup.Tasks.BackupPortalTask.DoDump (ASC.Data.Backup.IDataWriteOperator writer) [0x00344] in <8ad57f9204024ae59da40dac0991a2eb>:0 at ASC.Data.Backup.Tasks.BackupPortalTask.RunJob () [0x0003f] in <8ad57f9204024ae59da40dac0991a2eb>:0 at ASC.Data.Backup.Service.BackupWorker+BackupProgressItem.RunJob () [0x000b5] in <8ad57f9204024ae59da40dac0991a2eb>:0 ---> (Inner Exception #0) MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime at MySql.Data.Types.MySqlDateTime.GetDateTime () [0x00012] in <8235ed0ad41343b3a11f3dc973b415b6>:0 at MySql.Data.MySqlClient.MySqlDataReader.GetValue (System.Int32 i) [0x000ad] in <8235ed0ad41343b3a11f3dc973b415b6>:0 at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.Int32 i) [0x00000] in <8235ed0ad41343b3a11f3dc973b415b6>:0 at ASC.Common.Data.DataExtensions.ExecuteListReaderResult (System.Data.IDataReader reader) [0x0001a] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteListReader (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, System.String sql, System.Object[] parameters) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command) [0x00007] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, ASC.Common.Data.Sql.ISqlInstruction sql, ASC.Common.Data.Sql.ISqlDialect dialect) [0x00008] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Common.Data.DbManager.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x0000d] in <96a81f2b5ce744ef90c32874e89bb46b>:0 at ASC.Data.Backup.Tasks.BackupPortalTask.GetDataWithPrimary (System.String t, System.Collections.Generic.List1[T] columns, System.String primary, System.Int32 start, System.Int32 step) [0x00043] in <8ad57f9204024ae59da40dac0991a2eb>:0
at ASC.Data.Backup.Tasks.BackupPortalTask.DumpTableData (System.String t, System.String dir, System.Int32 count) [0x0023b] in <8ad57f9204024ae59da40dac0991a2eb>:0
at ASC.Data.Backup.Tasks.BackupPortalTask+<>c__DisplayClass16_1.b__8 () [0x00032] in <8ad57f9204024ae59da40dac0991a2eb>:0
at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in :0
at System.Threading.Tasks.Task.Execute () [0x00000] in :0 <—

I completely reinstalled OO in Docker with mysql dump and restore and that not helped