Error in docker Community server under Version 11.1.0.1506

I can download files but NOT edit them. When I try to edit, I see this in svcNotify.log under Communityserver log area.

MySQL 5.7 runs under a container also not inside the Community server
It was created (and used to work) doing

START DOCKER CONTAINER MYSQL SERVER

docker run --net onlyoffice -i -t -d --name onlyoffice-mysql-server -p 3306:3306 \

-v /app/onlyoffice/mysql/conf.d:/etc/mysql/conf.d \

-v /app/onlyoffice/mysql/data:/var/lib/mysql \

-v /app/onlyoffice/mysql/initdb:/docker-entrypoint-initdb.d \

-v /app/onlyoffice/mysql/logs:/var/log/mysql \

-e MYSQL_ROOT_PASSWORD=XXXXXX \

-e MYSQL_DATABASE=onlyoffice \

mysql:5.7

2021-09-24 16:29:48,234 ERROR [14] ASC - MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column ‘q.auto_submitted’ in 'field list’
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in :0
at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00026] in :0
at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in :0
at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in :0
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00251] in :0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0030c] in :0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0
at System.Data.Common.DbCommand.ExecuteReader () [0x00000] in <2d547ce14b5c4254936ffeb73ed1353b>:0
at (wrapper remoting-invoke-with-check) System.Data.Common.DbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader (System.Data.Common.DbCommand command) [0x00000] in <83cbfc6ece0d432397ee6810dc678fae>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, System.String sql, System.Object[] parameters) [0x00008] in <83cbfc6ece0d432397ee6810dc678fae>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command) [0x00007] in <83cbfc6ece0d432397ee6810dc678fae>: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 <83cbfc6ece0d432397ee6810dc678fae>:0
at ASC.Common.Data.DbManager.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x0000d] in <83cbfc6ece0d432397ee6810dc678fae>:0
at ASC.Notify.DbWorker.GetMessages (System.Int32 count) [0x0011c] in <99591f9324574d00977f887284cd918c>:0
at ASC.Notify.NotifySender.ThreadManagerWork () [0x0004f] in <99591f9324574d00977f887284cd918c>:0 MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column ‘q.auto_submitted’ in ‘field list’
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in :0
at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00026] in :0
at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in :0
at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in :0
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00251] in :0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0030c] in :0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0
at System.Data.Common.DbCommand.ExecuteReader () [0x00000] in <2d547ce14b5c4254936ffeb73ed1353b>:0
at (wrapper remoting-invoke-with-check) System.Data.Common.DbCommand.ExecuteReader()
at ASC.Common.Data.DataExtensions.ExecuteListReader (System.Data.Common.DbCommand command) [0x00000] in <83cbfc6ece0d432397ee6810dc678fae>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command, System.String sql, System.Object[] parameters) [0x00008] in <83cbfc6ece0d432397ee6810dc678fae>:0
at ASC.Common.Data.DataExtensions.ExecuteList (System.Data.Common.DbCommand command) [0x00007] in <83cbfc6ece0d432397ee6810dc678fae>: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 <83cbfc6ece0d432397ee6810dc678fae>:0

Hello ivan.

Please clarify when the issues arose? What actions on the server side preceded?

I can download files but NOT edit them. When I try to edit, I see this in svcNotify.log under Communityserver log area.

Do you have any error in browser when you are trying to open a file?

Also please point me to the guide which you used for installation and output result of docker ps command from the host.

Alexandre, I think it may have been firewall related. the port on which the document server chats was closed after an OS upgrade. Its working now. MANY apologies. Please close the ticket.

1 Like