Backup: Add OpenSPP filestore backup

[atelal]

The backup script only takes care of the database backup, but not the OpenSPP filestore. This is needed for an on-premises deployment. An example of Docker volume backup can be found here.

[jeremi]

@atelal I think the best would be to store the files outside to another system the files for a large production workload.
We have added a module for this:
https://github.com/OpenSPP/OpenSPP2/tree/19.0/spp_storage_backend

This also enable you to use antivirus on the uploaded files:
https://github.com/OpenSPP/OpenSPP2/tree/19.0/spp_attachment_av_scan

But feel free to create a PR to improve our docker config.

[atelal]

Hello @jeremi,

While this module covers the upload client files to an external system (which is really good), it does not backup the Odoo filestore with the images and resources needed by Odoo itself.

If you have a mismatch between the Database and the Filestore, Odoo will not start. Odoo will fail to load the file, because it will not be found in the filestore.

Here is a sample log:

odoo-1  | 2026-03-30 09:54:03,639 143 ERROR dev odoo.http: Exception during request handling. 
odoo-1  | Traceback (most recent call last):
odoo-1  |   File "/opt/odoo/odoo/http.py", line 2410, in __call__
odoo-1  |     response = request._serve_db()
odoo-1  |   File "/opt/odoo/odoo/http.py", line 1985, in _serve_db
odoo-1  |     return service_model.retrying(self._serve_ir_http, self.env)
odoo-1  |   File "/opt/odoo/odoo/service/model.py", line 153, in retrying
odoo-1  |     result = func()
odoo-1  |   File "/opt/odoo/odoo/http.py", line 2013, in _serve_ir_http
odoo-1  |     response = self.dispatcher.dispatch(rule.endpoint, args)
odoo-1  |   File "/opt/odoo/odoo/http.py", line 2130, in dispatch
odoo-1  |     return self.request.registry['ir.http']._dispatch(endpoint)
odoo-1  |   File "/opt/odoo/odoo/addons/base/models/ir_http.py", line 221, in _dispatch
odoo-1  |     result = endpoint(**request.params)
odoo-1  |   File "/opt/odoo/odoo/http.py", line 799, in route_wrapper
odoo-1  |     result = endpoint(self, *args, **params_ok)
odoo-1  |   File "/opt/odoo/addons/bus/controllers/websocket.py", line 64, in get_websocket_worker_bundle
odoo-1  |     stream = request.env['ir.binary']._get_stream_from(bundle.js())
odoo-1  |   File "/opt/odoo/odoo/addons/base/models/ir_binary.py", line 126, in _get_stream_from
odoo-1  |     stream = self._record_to_stream(record, field_name)
odoo-1  |   File "/opt/odoo/odoo/addons/base/models/ir_binary.py", line 73, in _record_to_stream
odoo-1  |     return Stream.from_attachment(record)
odoo-1  |   File "/opt/odoo/odoo/http.py", line 538, in from_attachment
odoo-1  |     stat = os.stat(self.path)
odoo-1  | FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/odoo/filestore/dev/b3/b34bff8bf5a9c62a66e37eb6bb803ff91a2c20f5'

This can end up with a server crash, and an error 50x.

[jeremi]

Which files are missing?
Are they cached files that can be re-generated?

[atelal]

Hello,

If we are using the module you sent previously, and use S3 for instance.
The files uploaded will be sent on S3.
However, I think the default Odoo resources will not be backed up. It would give the error above.

Are they cached files that can be re-generated?

After research on my side, to regenerate some assets when the javascript is broken in Odoo, you will need to stop Odoo, and then connect to the database, and then use the following SQL statement to remove these files in order for Odoo to re-generate them:

DELETE FROM ir_attachment WHERE store_fname LIKE '%<the ending hash>%'

And then restart Odoo.
Source: odoo/odoo#9296 (comment)

In Odoo, when you make a backup, it is recommended to also backup the filestore.
I will open a PR for this. I have previously made docker volumes backups scripts to save the filestore, while also making a DB backup.

[atelal]

Hello,

If we are using the module you sent previously, and use S3 for instance.
The files uploaded will be sent on S3.
However, the default Odoo resources will not be backed up.

Are they cached files that can be re-generated?
To regenerate some assets when the javascript is broken in Odoo, you will need to stop Odoo, and then connect to the database, and then use the following SQL statement to remove these files in order for Odoo to re-generate them:

DELETE FROM ir_attachment WHERE store_fname LIKE '%<the ending hash>%'

And then restart Odoo.
Source: odoo/odoo#9296 (comment)

In Odoo, when you make a backup, it is recommended to also backup the filestore.
I will open a PR for this.

[Tarekchehahde]

Opened PR: #304

Local test summary: Shell/compose changes only; runtime backup test requires Docker production stack with odoo_data volume.