Hi Bruno, its me once again. The next run with excluded pg_subtrans dir fails on the base directory:
JobId 5116772: Fatal error: bareosfd: Traceback (most recent call last): File "/usr/lib64/bareos/plugins/BareosFdWrapper.py", line 61, in start_backup_file return bareos_fd_plugin_object.start_backup_file(savepkt) File "/usr/lib64/bareos/plugins/bareos-fd-postgresql.py", line 703, in start_backup_file return super().start_backup_file(savepkt) File "/usr/lib64/bareos/plugins/BareosFdPluginLocalFilesBaseclass.py", line 118, in start_backup_file mystatp.st_mode = statp.st_mode UnboundLocalError: local variable 'statp' referenced before assignment JobId 5116772: Error: python3-fd-mod: Could net get stat-info for file /db/pgsql/pgsql-15/base/16386/2117113: "[Errno 2] No such file or directory: '/db/pgsql/pgsql-15/base/16386/2117113'" It is a active database. Any thoughts on this? With kind regards, Dennis -------- Ursprüngliche Nachricht -------- Von: Bruno Friedmann (bruno-at-bareos) <[email protected]> An: bareos-users <[email protected]> Betreff: Re: [bareos-users] New PostgreSQL plugin search volunteers for testing Datum: 18.09.2023 16:04:42 Sorry in fact it is in 15 doc too. Le lundi 18 septembre 2023 à 15:59:34 UTC+2, Bruno Friedmann (bruno-at- bareos) a écrit : > Hello Dennis, > > Nice you already tried the fresh PG16 meat, after checking the new > documentation about subtrans we can see that upstream has added that > directory as shouldn't be saved. > > ```The contents of the > directories pg_dynshmem/, pg_notify/, pg_serial/, pg_snapshots/, pg_s > tat_tmp/, and pg_subtrans/ (but not the directories themselves) can > be omitted from the backup as they will be initialized on postmaster > startup.``` > > Will apply that to the plugin by default before release. > > Le lundi 18 septembre 2023 à 15:26:24 UTC+2, Dennis Benndorf a > écrit : > > Hi Bruno, > > > > we tested your new plugin with a quite large database with a > > running application using it. > > When doing a full backup we ran into: > > > > JobId 5116734: Fatal error: bareosfd: Traceback (most recent call > > last): > > File "/usr/lib64/bareos/plugins/BareosFdWrapper.py", line 61, in > > start_backup_file > > return bareos_fd_plugin_object.start_backup_file(savepkt) > > File "/usr/lib64/bareos/plugins/bareos-fd-postgresql.py", line 703, > > in start_backup_file > > return super().start_backup_file(savepkt) > > File > > "/usr/lib64/bareos/plugins/BareosFdPluginLocalFilesBaseclass.py", > > line 118, in start_backup_file > > mystatp.st_mode = statp.st_mode > > UnboundLocalError: local variable 'statp' referenced before > > assignment > > > > JobId 5116734: Error: python3-fd-mod: Could net get stat-info for > > file /db/pgsql/pgsql-15/pg_subtrans/00BF: "[Errno 2] No such file > > or directory: '/db/pgsql/pgsql-15/pg_subtrans/00BF'" > > > > It seems that the plugin fails when it wants to backup a > > subtransaction that has been commited and removed from that > > directory in the meantime. > > > > Is it save to exclude the pg_subtrans directory? > > > > With kind regards, > > Dennis > > > > -------- Ursprüngliche Nachricht -------- > > Von: Bruno Friedmann <[email protected]> > > An: bareos-users <[email protected]> > > Betreff: [bareos-users] New PostgreSQL plugin search volunteers for > > testing > > Datum: 13.09.2023 09:46:08 > > > > Hi community, users and customers, > > > > As we're moving towards Bareos 23, we could use some help testing > > the all new PostgreSQL plugin which is needed because of changes > > happened in PostgreSQL 15. > > > > Main features compared to the old one: > > - use non exclusive mode > > - support all clusters starting from version 10 > > - support clusters with tablespace > > - support non standard port > > - support password parameter > > - better debugging > > - renew of parameters names and variables > > - renewed documentation > > > > We're looking for a few early adopters to work with directly. If > > you'd like to participate please contact https://bareos.com/contact > > with a small description of your environment to have multiple > > environments as test scenarios. > > > > And "For all others who'd like to test without early adapters > > program the testing packages are now available > > at this address https://download.bareos.org/experimental/PR-1541/ > > The corresponding documentation is also available on > > https://download.bareos.org/experimental/PR-1541/BareosMainReference/TasksAndConcepts/Plugins.html#postgresql-plugin > > > > The ongoing development PR is available here > > https://github.com/bareos/bareos/pull/1541 > > > > We would really appreciate comments, remarks, and tests. > > Better to use github comments if you want to participate, and help. > > > > The new plugin aims to replace the old one, and will be delivered > > in the same package > > bareos-filedaemon-postgresql-python-plugin > > Notice The old plugin (deprecated) will still also be delivered in > > 23, but we recommend (not sure if we will force) its usage to only > > restore previous backups done with, until you migrate to the new > > one. > > > > Thanks and all the best > > -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/a866bc4d3707cd451e491b1f604f3a7f02b7fdf7.camel%40googlemail.com.
