docker-db-backup icon indicating copy to clipboard operation
docker-db-backup copied to clipboard

DB backup doesn't performed on Ubuntu 18.04

Open dajnz opened this issue 4 years ago • 10 comments

Hello, thank you for this tool, but unfortunately, it looks like I have an issue with it.

I added this backup tool as an additional service to my docker-compose file like this:

...

  dbbackup:
    image: tiredofit/db-backup:latest
    container_name: db-backupper
    environment:
      DB_TYPE: pgsql
      DB_HOST: storage-db
      DB_NAME: storage_db
      DB_USER: postgres
      DB_PASS: ${POSTGRES_PASSWORD}
      # Test db backup each 3 minutes
      DB_DUMP_FREQ: 3
      # Cleanup backups older than 3 days
      DB_CLEANUP_TIME: 4320
    depends_on:
      - db
    networks:
      - my-network
    volumes:
      - ${DB_BACKUP_DIR}:/backup

I just added the line with more frequent DB backupping for debugging.

On my local computer with Ubuntu 16.04, it works just fine, but after I pushed my services on a remote server under Ubuntu 18.04 I see no backups at all.

Checking logs with docker logs CONTAINER-NAME gives the output below, and as I see it the only suspicious line is s6-svc: fatal: unable to control /var/run/s6/services/-d: No such file or directory, but my knowledge of that system stuff is very limited.

[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] 00-functions: applying... 
[fix-attrs.d] 00-functions: exited 0.
[fix-attrs.d] 01-s6: applying... 
[fix-attrs.d] 01-s6: exited 0.
[fix-attrs.d] 02-zabbix: applying... 
[fix-attrs.d] 02-zabbix: exited 0.
[fix-attrs.d] 03-logrotate: applying... 
[fix-attrs.d] 03-logrotate: exited 0.
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] 00-startup: executing... 
[cont-init.d] 00-startup: exited 0.
[cont-init.d] 01-timezone: executing... 
[NOTICE] ** [timezone] Setting timezone to 'America/Vancouver'
[cont-init.d] 01-timezone: exited 0.
[cont-init.d] 02-permissions: executing... 
[cont-init.d] 02-permissions: exited 0.
[cont-init.d] 03-zabbix: executing... 
[NOTICE] ** [zabbix] Disabling Zabbix Monitoring Functionality
s6-svc: fatal: unable to control /var/run/s6/services/-d: No such file or directory
[cont-init.d] 03-zabbix: exited 0.
[cont-init.d] 04-cron: executing... 
[NOTICE] ** [cron] Disabling Cron
[cont-init.d] 04-cron: exited 0.
[cont-init.d] 05-smtp: executing... 
[NOTICE] ** [smtp] Disabling SMTP Features
[cont-init.d] 05-smtp: exited 0.
[cont-init.d] 99-container: executing... 
[cont-init.d] 99-container: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.

Maybe you have some ideas about what's went wrong? Thank you for your time.

dajnz avatar Mar 14 '20 22:03 dajnz

Wow that is strange.

Can You send me privately (my email is in the changelog) a log with the environment variable DEBUG_MODE=TRUE. How long has this been happening for as well? Recently or is this first time trying to use.

tiredofit avatar Mar 14 '20 23:03 tiredofit

I noticed this issue several days ago (2-3), after pushing my changes to 2 new servers with Ubuntu 18.04, and all that time it hasn't created any backup. An interesting fact is that locally it works properly with the same config for docker-compose service.

I have tried to re-deploy it with changing backup frequency with no luck, unfortunately. I also just checked the changelog of this project but noticed there only Github emails of users who made pull requests, can you point me more detailed where to find it please?

dajnz avatar Mar 15 '20 00:03 dajnz

Is your filesystem standard (ie ext4?) I Have it running on ext4 and btrfs without issues. My email is dave at (githubusername) dot ca

tiredofit avatar Mar 15 '20 00:03 tiredofit

Yes, ext4 on both local and remote computers.

dajnz avatar Mar 15 '20 01:03 dajnz

Thanks. I received the log. So, good news. The error you are getting is related to Zabbix only and my startup routines. That's a base image issue which I'll troubleshoot. The bad news is that the backup service isn't even starting :)

Can you try this tag? tiredofit/db-backup:1.16

tiredofit avatar Mar 15 '20 01:03 tiredofit

Rebuilding the alpine base images to fix the Zabbix error, once built will be able to run tests to see if there is a problem within the DB Backup image. Sadly Docker Hub takes about 2 days to build all images so once it is done I'll finish this off.

tiredofit avatar Mar 15 '20 01:03 tiredofit

Found the problem with the image. New images coming!

tiredofit avatar Mar 16 '20 19:03 tiredofit

@tiredofit was this resolved?

daecepi avatar May 17 '21 06:05 daecepi

Should have been. I can't see the error throughout this thread other than it looking like a build problem.

tiredofit avatar May 17 '21 14:05 tiredofit

Thank you very much!

dajnz avatar May 17 '21 22:05 dajnz