Hi.
I’m trying to update from 7.1.5 to 8.0.4 and also have problems with seahub.
I’ve made sure that libmariadbclient-dev and mysqlclient are installed as mentioned in this post, which removed the Error:Seahub failed to start error.
However, seahub exists just after printing Done right after it started. Looking at the logfile /opt/haiwen/logs/seahub.log. I have the following errors:
2021-03-30 18:58:34,429 [ERROR] seahub.api2.authentication:138 authenticate_v2 error when save token v2:
Traceback (most recent call last):
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/backends/mysql/base.py", line 71, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1665, 'Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/haiwen/seafile-server-8.0.4/seahub/seahub/api2/authentication.py", line 136, in authenticate_v2
token.save()
File "/opt/haiwen/seafile-server-8.0.4/seahub/seahub/api2/models.py", line 173, in save
return super(TokenV2, self).save(*args, **kwargs)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/models/base.py", line 744, in save
force_update=force_update, update_fields=update_fields)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/models/base.py", line 782, in save_base
force_update, using, update_fields,
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/models/base.py", line 854, in _save_table
forced_update)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/models/base.py", line 903, in _do_update
return filtered._update(values) > 0
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/models/query.py", line 760, in _update
return query.get_compiler(self.db).execute_sql(CURSOR)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/models/sql/compiler.py", line 1471, in execute_sql
cursor = super().execute_sql(result_type)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/models/sql/compiler.py", line 1142, in execute_sql
cursor.execute(sql, params)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/backends/utils.py", line 76, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/opt/haiwen/seafile-server-8.0.4/seahub/thirdpart/django/db/backends/mysql/base.py", line 71, in execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1665, 'Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.')
To me this seems like a problem related to MySQL/mariadb.
According to this post, this is fixed by setting binlog format to row. So I changed that with the following sql command:
SET GLOBAL binlog_format = 'ROW';
The entry in the logfile goes away, but seahub still restarts just as before.
Any ideas?
