🐞 反馈问题：复杂项目多组件导出报错及导入如果包含大镜像组件和较多的组件也会导入失败

[PDMoFan]

请先确认以下事项：

• 请务必查看常见问题和故障排除
• 在 issues 页面搜索过问题（包括已关闭的 issue），但未能找到解决方法
• Rainbond 已升级到 最新版本

问题描述

我们项目比较复杂，大概有30多个组件，导出全部的时候会报错，选择几个的时候不会报错，应该是SQLite并发写入问题，SQLite 是一种文件级别的单写锁（独占写锁）数据库，它不支持多进程 / 多线程同时对数据库执行写入操作（INSERT/UPDATE/DELETE 等）。

该问题是否可以稳定重现？

可重现

重现步骤

导出20+复杂依赖的组件

截图

日志

以下是部分错误信息：
Traceback (most recent call last): File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 383, in execute return Database.Cursor.execute(self, query, params) sqlite3.OperationalError: database is locked The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/ui/console/views/service_share.py", line 461, in post record_event = share_service.sync_event(self.user, self.response_region, team_name, events[0]) File "/usr/local/lib/python3.6/contextlib.py", line 52, in inner return func(*args, **kwds) File "/app/ui/console/services/share_services.py", line 489, in sync_event event = self.create_publish_event(record_event, user.nick_name, event_type) File "/app/ui/console/services/share_services.py", line 478, in create_publish_event event.save() File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 741, in save force_update=force_update, update_fields=update_fields) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 779, in save_base force_update, using, update_fields, File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 870, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 908, in _do_insert using=using, raw=raw) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/app/ui/py_venv/lib/python3.6/site-packa

期望结果

希望复杂项目且包含大镜像组件的导出导入可以更稳定

解决方案（可选）

No response

操作系统 && Rainbond 版本

Ubuntu 20.04.6 LTS (Focal Fossa),k8s Version: v1.30.4+k3s1, Rainbond v6.4.1-release

是否愿意提交 PR 解决该问题？

• 我愿意提交 PR 来解决该问题

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Title: 🐞 Feedback problem: Complex project multi-component export error and import will also fail if it contains large mirror components and many components.

[PDMoFan]

补充一下界面的错误信息：
Traceback (most recent call last): File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 383, in execute return Database.Cursor.execute(self, query, params) sqlite3.OperationalError: database is locked The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/app/ui/py_venv/lib/python3.6/site-packages/rest_framework/views.py", line 471, in dispatch self.initial(request, *args, **kwargs) File "/app/ui/console/views/base.py", line 505, in initial super(RegionTenantHeaderView, self).initial(request, *args, **kwargs) File "/app/ui/console/views/base.py", line 400, in initial self.user = request.user File "/app/ui/py_venv/lib/python3.6/site-packages/rest_framework/request.py", line 222, in user self._authenticate() File "/app/ui/py_venv/lib/python3.6/site-packages/rest_framework/request.py", line 375, in _authenticate user_auth_tuple = authenticator.authenticate(self) File "/app/ui/console/views/base.py", line 130, in authenticate login_event.active() File "/app/ui/console/login/login_event.py", line 60, in active self.login_event.save() File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 741, in save force_update=force_update, update_fields=update_fields) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 779, in save_base force_update, using, update_fields, File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 851, in _save_table forced_update) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/base.py", line 900, in _do_update return filtered._update(values) > 0 File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/query.py", line 760, in _update return query.get_compiler(self.db).execute_sql(CURSOR) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1426, in execute_sql cursor = super().execute_sql(result_type) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1097, in execute_sql cursor.execute(sql, params) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers return executor(sql, params, many, context) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/utils.py", line 89, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/app/ui/py_venv/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 383, in execute return Database.Cursor.execute(self, query, params) django.db.utils.OperationalError: database is locked
在最新的v6.5.0-release版本，依然存在这个问题

[zzzhangqi]

这是比较明确的问题，导入的时候并发写导致sqlite锁库了，目前还没有比较合理的解决方案

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

This is a relatively clear problem. Concurrent writing during import causes SQLite to lock the library. There is currently no reasonable solution.