spug icon indicating copy to clipboard operation
spug copied to clipboard

Bug: [windows]系统初始化错误,无法建立admin账户

Open DZG-MELODY opened this issue 1 year ago • 3 comments

Spug 版本:V3.3.3 操作系统:windows 11

问题重现步骤

启动镜像服务后,运行如下脚本:

docker exec spug init_spug admin spug.cc

报错/问题截图

No changes detected in apps 'repository', 'setting', 'schedule', 'monitor', 'alarm', 'app', 'notify', 'deploy', 'host', 'config', 'account', 'exec', 'home' Operations to perform: Apply all migrations: account, alarm, app, config, deploy, exec, home, host, monitor, notify, repository, schedule, setting Running migrations: Applying alarm.0001_initial... OK Applying config.0001_initial...Traceback (most recent call last): File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.10/dist-packages/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query')

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/data/spug/spug_api/manage.py", line 24, in main() File "/data/spug/spug_api/manage.py", line 20, in main execute_from_command_line(sys.argv) File "/usr/local/lib/python3.10/dist-packages/django/core/management/init.py", line 381, in execute_from_command_line utility.execute() File "/usr/local/lib/python3.10/dist-packages/django/core/management/init.py", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 323, in run_from_argv self.execute(*args, **cmd_options) File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 364, in execute output = self.handle(*args, **options) File "/data/spug/spug_api/apps/account/management/commands/updatedb.py", line 16, in handle execute_from_command_line(['manage.py', 'migrate']) File "/usr/local/lib/python3.10/dist-packages/django/core/management/init.py", line 381, in execute_from_command_line utility.execute() File "/usr/local/lib/python3.10/dist-packages/django/core/management/init.py", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 323, in run_from_argv self.execute(*args, **cmd_options) File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 364, in execute output = self.handle(*args, **options) File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 83, in wrapped
res = handle_func(*args, **kwargs) File "/usr/local/lib/python3.10/dist-packages/django/core/management/commands/migrate.py", line 232, in handle post_migrate_state = executor.migrate( File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 117, in migrate state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial) File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 244, in apply_migration with self.connection.schema_editor(atomic=migration.atomic) as schema_editor: File "/usr/local/lib/python3.10/dist-packages/django/db/backends/base/schema.py", line 110, in exit self.execute(sql) File "/usr/local/lib/python3.10/dist-packages/django/db/backends/base/schema.py", line 137, in execute cursor.execute(sql, params) File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 76, in _execute_with_w File "/usr/local/li File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.10/dist-packages/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')

期望的结果

DZG-MELODY avatar Nov 03 '24 11:11 DZG-MELODY

同问

wanxiaoxiang avatar Nov 20 '24 13:11 wanxiaoxiang

这个看起来是初始化的时候数据库连接失败了。检查一下你的数据库配置

zyupo avatar Apr 08 '25 08:04 zyupo

image: mariadb:10.6.23   数据库换这个版本试试 , 我的好了

LookUpPls avatar Oct 20 '25 10:10 LookUpPls