Burp Server Restore (self as client) via Download fails - Burpui.tasks.perform_restore[...OperationalError('(sqlite3.OperationalError) no such table: task')
Hello,
Burp Server Version: burp-2.4.0 Burp Client Version: burp-2.4 burp-ui: v1.0.0 () Python version: 3.10.6 Config file: /etc/burp/burpui.cfg
Using Burp-UI I performed a simple restore via ie; the Download of a single small file.
Bug summary
Opened the Burp Server via Burp-UI. Selected a single small file. Click the download button. This through the following error on the screen
Log file relative to the restore:
```Nov 18 18:57:07 servermatter burp[591449]: Compressing /SM_BACKUP/DATA/burp/sm_server_bkup/0000010 2022-11-18 11:00:02 -0800/restorelog to /SM_BACKUP/DATA/burp/sm_server_bkup/0000010 2022-11-18 11:00:02 -0800/restorelog.gz...
Nov 18 18:57:07 servermatter burp[591448]: restore finished
Nov 18 18:57:07 servermatter bui-celery[3049551]: [2022-11-18 18:57:07,570: ERROR/ForkPoolWorker-14] Task burpui.tasks.perform_restore[06fe25a1-6160-4d54-9f41-33d4a1e7948e] raised unexpected: OperationalError('(sqlite3.OperationalError) no such table: task')
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/base.py", line 1900, in _execute_context
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/default.py", line 736, in do_execute
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../burpui/extensions.py", line 306, in __call__
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../burpui/tasks.py", line 325, in perform_restore
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/orm/query.py", line 2823, in first
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/orm/query.py", line 2915, in _iter
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/orm/session.py", line 1714, in execute
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/base.py", line 1705, in _execute_20
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/base.py", line 1943, in _execute_context
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/util/compat.py", line 210, in raise_
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/base.py", line 1900, in _execute_context
Nov 18 18:57:07 servermatter bui-celery[3049551]: File "/venv_apps/bui/lib/python3.10/site-packages/burpui/engines/../../sqlalchemy/engine/default.py", line 736, in do_execute
Nov 18 18:57:07 servermatter burp[591449]: MESSAGE: Running notify script: sm_server_bkup /SM_BACKUP/DATA/burp/sm_server_bkup /SM_BACKUP/DATA/burp/sm_server_bkup/0000010 2022-11-18 11:00:02 -0800 restorelog restore 0 sendmail -t To: "admin@servermatter.com" From: "admin@servermatter.com" Subject: %b " Back
Nov 18 18:57:07 servermatter burp[591449]: main socket 9: Got network write error
Nov 18 18:57:07 servermatter burp[591449]: main socket 9: network write problem in asfd_do_write_ssl: 5 - 32=Broken pipe
Nov 18 18:57:07 servermatter burp[591449]: This is probably caused by the peer exiting.
Nov 18 18:57:07 servermatter burp[591449]: Please check the peer's logs.
Nov 18 18:57:07 servermatter burp[591449]: MESSAGE: ups: Internal: Success for compumatter.biz - system ": %c %w
Nov 18 18:57:07 servermatter burp[591449]: /usr/share/burp/scripts/notify_script returned: 0
Nov 18 18:57:07 servermatter burp[591449]: exit child
Nov 18 18:57:07 servermatter burp[750918]: pipe from child 10: end of data
Nov 18 18:57:07 servermatter burp[750918]: pipe from child 10: disconnected fd 10
Thanks