Im getting a bunch of backups made when its only supposed to be a daily backup, plus the backups are empty zip files.
Im using the automated database backup module on v11.
And when I try to do a manual backup from /web/database/manager i get a HTTP 500 Error.
Settings:
localhost
ZIP backup type
Backup Scheduler
Number of Calls -1
Execute Every 1Days
Priority 5
If i click Run Manually I get the 0 sized ZIP files in my backup folder. But it used to work.
Here is the relevant log error:
Traceback (most recent call last):
File "/opt/odoo/odoo/addons/bus/models/bus.py", line 181, in run
self.loop()
File "/opt/odoo/odoo/addons/bus/models/bus.py", line 176, in loop
event.set()
File "/opt/odoo/odoo/odoo/sql_db.py", line 404, in __exit__
self.close()
File "/opt/odoo/odoo/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo/odoo/sql_db.py", line 288, in close
return self._close(False)
File "/opt/odoo/odoo/odoo/sql_db.py", line 318, in _close
self._cnx.rollback()
psycopg2.InterfaceError: connection already closed
2021-02-02 13:50:38,170 29144 INFO Company_production_2020-12-01_15-17-58 werkzeug: 205.211.254.213 - - [02/Feb/2021 13:50:38] "POST /web/dataset/call_button HTTP/1.1" 500 -
2021-02-02 13:50:38,177 29144 ERROR Company_production_2020-12-01_15-17-58 werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/werkzeug/serving.py", line 205, in run_wsgi
execute(self.server.app)
File "/usr/local/lib/python3.6/dist-packages/werkzeug/serving.py", line 193, in execute
application_iter = app(environ, start_response)
File "/opt/odoo/odoo/odoo/service/server.py", line 348, in app
return self.app(e, s)
File "/opt/odoo/odoo/odoo/service/wsgi_server.py", line 180, in application
return application_unproxied(environ, start_response)
File "/opt/odoo/odoo/odoo/service/wsgi_server.py", line 154, in application_unproxied
result = handler(environ, start_response)
File "/opt/odoo/odoo/odoo/http.py", line 1321, in __call__
return self.dispatch(environ, start_response)
File "/opt/odoo/odoo/odoo/http.py", line 1295, in __call__
return self.app(environ, start_wrapped)
File "/usr/local/lib/python3.6/dist-packages/werkzeug/wsgi.py", line 599, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/odoo/http.py", line 1497, in dispatch
response = self.get_response(httprequest, result, explicit_session)
File "/opt/odoo/odoo/odoo/http.py", line 289, in __exit__
self._cr.close()
File "/opt/odoo/odoo/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo/odoo/sql_db.py", line 288, in close
return self._close(False)
File "/opt/odoo/odoo/odoo/sql_db.py", line 318, in _close
self._cnx.rollback()
psycopg2.InterfaceError: connection already closed
2021-02-02 13:50:38,343 29144 INFO Company_production_2020-12-01_15-17-58 odoo.sql_db: Connection to the database failed
2021-02-02 13:50:38,343 29144 INFO Company_production_2020-12-01_15-17-58 odoo.http: Generating nondb routing
2021-02-02 13:50:38,376 29144 INFO Company_production_2020-12-01_15-17-58 werkzeug: 205.211.254.213 - - [02/Feb/2021 13:50:38] "POST /web/dataset/call_kw/ir.cron/read HTTP/1.1" 404 -
2021-02-02 13:50:40,376 29144 INFO Company_production_2020-12-01_15-17-58 werkzeug: 205.211.254.213 - - [02/Feb/2021 13:50:40] "POST /web/webclient/version_info HTTP/1.1" 200 -
2021-02-02 13:50:51,700 29144 INFO Company_production_2020-12-01_15-17-58 werkzeug: 200.52.144.226 - - [02/Feb/2021 13:50:51] "POST /longpolling/poll HTTP/1.1" 200 -
Please check your log files for information about the cause.
The only thing related to that i found is a file not found error. I posted it, please check
Have you checked the module documentation? I’m thinking that if it used to work for you it may be due to some changes you’ve made.
The module doesn’t work if list_db is set to False (or is not configured).
You can find the readme here:
https://github.com/Yenthe666/auto_backup/tree/11.0
list_db is set to True and it still doesnt work
Please check yourself, the error message is clear and easily understandable. We have no access to your server's file system.
Im simply asking because I don't know how to fix it. I don't understand why File Not Found error is the cause since a backup means it will create a backup file instead of reading a file.
I ran the manual scheduled action and took the server log's most recent entry lines. It mentions something about -cnx.rollback()