auto back up make zero size .zip backup file

[zeintiz]

hello

We have Odo 13. We have several databases in different sizes. We installed auto backup module , and worked fine until 10 days. It has been taking backups without error , but the backup size of our large database is zero. All our database backups are working properly (small size) , but the largest database( is around 1.7 gig) has zero size, and it is getting bigger day by day. Until last week, there have 15 concurrent users, and since last week, it has become 18 users.
I will send the specifications of the config file and automatic backup settings. I will also send the odoo server log. its our production server. that we don't have debug tools on it.

any idea. any help. please.

tankx in advance

configuration page:

odoo.conf:

[options]
addons_path = /usr/lib/python3/dist-packages/odoo/addons,/usr/lib/python3/dist-packages/odoo/addons-custom
admin_passwd = 92Bs3rg
csv_internal_sep = ,
data_dir = /var/lib/odoo/.local/share/Odoo
db_host = False
db_maxconn = 64
db_name = False
db_password = False
db_port = False
db_sslmode = prefer
db_template = template0
db_user = odoo
dbfilter =
demo = {}
email_from = False
geoip_database = /usr/share/GeoIP/GeoLite2-City.mmdb
http_enable = True
http_interface =
http_port = 8069
import_partial =
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 60
limit_time_real = 120
limit_time_real_cron = -1
list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
log_level = info
logfile = /var/log/odoo/odoo-server.log
longpolling_port = 8072
max_cron_threads = 2
osv_memory_age_limit = 1.0
osv_memory_count_limit = False
pg_path =
pidfile =
proxy_mode = False
reportgz = False
screencasts =
screenshots = /tmp/odoo_tests
server_wide_modules = base,web
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False
smtp_user = False
syslog = False
test_enable = False
test_file =
test_tags = None
translate_modules = ['all']
unaccent = False
upgrade_path =
without_demo = False
workers = 0

[zeintiz]

here is my odoo server log

2022-07-03 13:30:17,626 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:30:17,629 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:30:17] "POST /longpolling/poll HTTP/1.1" 404 - 1 0.003 0.011
2022-07-03 13:30:34,620 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:30:34,623 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:30:34] "POST /longpolling/poll HTTP/1.1" 404 - 1 0.005 0.013
2022-07-03 13:30:41,752 1581 INFO dbssfit odoo.addons.base.models.ir_cron: Starting job Backup scheduler.
2022-07-03 13:30:41,789 1581 INFO dbssfit odoo.addons.auto_backup.models.db_backup: DUMP DB: dbssfit format zip
2022-07-03 13:30:50,629 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:30:50,634 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:30:50] "POST /longpolling/poll HTTP/1.1" 404 - 1 0.003 0.015
2022-07-03 13:30:59,304 1581 INFO dbssfit odoo.addons.base.models.ir_cron: Job Backup scheduler done.
2022-07-03 13:31:14,619 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:31:14,624 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:31:14] "POST /longpolling/poll HTTP/1.1" 404 - 1 0.004 0.015
2022-07-03 13:31:44,622 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:31:44,626 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:31:44] "POST /longpolling/poll HTTP/1.1" 404 - 1 0.004 0.015
2022-07-03 13:31:58,132 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:31:58,135 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:31:58] "POST /longpolling/im_status HTTP/1.1" 404 - 1 0.004 0.013
2022-07-03 13:32:00,212 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:32:00] "POST /web/webclient/version_info HTTP/1.1" 200 - 1 0.004 0.015
2022-07-03 13:32:01,683 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:32:01,687 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:32:01] "POST /longpolling/poll HTTP/1.1" 404 - 1 0.004 0.013
2022-07-03 13:32:16,731 1581 WARNING ? odoo.http: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2022-07-03 13:32:16,734 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:32:16] "POST /longpolling/poll HTTP/1.1" 404 - 1 0.005 0.014
2022-07-03 13:32:31,221 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:32:31] "GET /web?db%3Ddbssfit HTTP/1.1" 303 - 2 0.009 0.022
2022-07-03 13:32:31,438 1581 INFO ? werkzeug: 192.168.65.125 - - [03/Jul/2022 13:32:31] "GET /web/database/selector HTTP/1.1"

[Saidlamzaouak]

@zeintiz I have the same problem

[an21mukhin]

Same problem on v.16, but all logs are fine. This module works fine on all my instances except one, that have the same configuration as worked ones, but generate 0-bytes .zip archives in manual and auto mode. I've tried to reinstall this module many times, down/up my container, have checked read/write to /tmp and /mnt, but result is the same.

[Desarrolladorpython03]

I have the same problem with Odoo 16 in docker. I can generate pg_dump file correctly but zip file is created with 0 bytes size.

[NickCoolii]

I have the same issue with odoo 14.
Before it was working fine, but now I have the 0 bytes zip backups.

I found an issue in my case (odoo 14, OS debian 10), the host system is CentOS 7 with PG 13.
The version of the Postgres client in our docker container was updated from 15 to 16.
This is the root cause of the issue.

I made the following change in my Dockerfile:
&& apt-get install --no-install-recommends -y postgresql-client
to
&& apt-get install --no-install-recommends -y postgresql-client-15 \

Also, I made some additional changes in the forked version of backup addon, like:

• log.error() instead of log.debug() if there are any issues with backup
• in the first place we are dumping DB, because issues will likely be with it, but not with the filestore backup.

Side notes:

• if Backup Type is "Dump", then .dump backup made just fine (it uses odoo.tools.exec_pg_command_pipe instead of exec_pg_command)
• if make a backup manually in the CLI of a container using pg_dump from PG client 16, then it works just fine
  (pg_dump -h 172.17.0.1 -d myDB -U odoo --no-owner --file=/tmp/dump.sql)

[an21mukhin]

Same problem on v.16, but all logs are fine. This module works fine on all my instances except one, that have the same configuration as worked ones, but generate 0-bytes .zip archives in manual and auto mode. I've tried to reinstall this module many times, down/up my container, have checked read/write to /tmp and /mnt, but result is the same.

I have just need to rebuild docker container, and this problem were gone.
Seems like one of the component in docker-container was updated and not working properly, then were fixed by developer, but I'm not sure.