On 2012-11-29 09:04, Olivier Delestre wrote: > Le 29/11/2012 14:51, Dan Langille a écrit : >> On 2012-11-29 08:34, Olivier Delestre wrote: >>> Le 29/11/2012 13:55, Dan Langille a écrit : >>>> On 2012-11-29 07:38, Olivier Delestre wrote: >>>>> Hi, >>>>> >>>>> I upgrade bacula 5.0.3 ( psql 8.4 ) to 5.2.5 ( psql 9.1 ) on >>>>> ubuntu >>>>> 12.04.1 LTS. >>>>> >>>>> I asked about : >>>>> >>>>> 1) The documentation of bacula that saying : >>>>> >>>>> "If you configure the Batch Insert code in Bacula (attribute >>>>> inserts >>>>> are >>>>> 10 times faster), you MUST be using a PostgreSQL that was built >>>>> with >>>>> the --ENABLE-THREAD-SAFETY option, otherwise you will get >>>>> DATA CORRUPTION. Most major Linux distros have thread safety >>>>> turned >>>>> on, but >>>>> it is better to check. One way is to see if the PostgreSQL >>>>> library >>>>> that >>>>> Bacula will be linked against references pthreads. This can be >>>>> done >>>>> with a command such as: >>>>> nm /usr/lib/libpq.a | grep pthread_mutex_lock " >>>>> >>>>> But, no such file. What is its usefulness ? >>>> >>>> Different operating systems install this file in different places. >>>> Here is >>>> how I found it on a FreeBSD system: >>>> >>>> $ locate libpq.a >>>> /usr/local/lib/libpq.a >>>> >>>> And running the command: >>>> >>>> $ nm /usr/local/lib/libpq.a | grep pthread_mutex_lock >>>> U pthread_mutex_lock >>>> U pthread_mutex_lock >>>> >>>> >>>>> i found it by installing postgresql-server-dev-9.1. Not installed >>>>> from >>>>> scratch install or upgrade... >>>>> >>>>> I think the package bacula 5.2.5 is compiled with >>>>> enable-batch-insert >>>>> and postgresql 5.2.5 with enable-thread-safety ( obtain source >>>>> package >>>>> with apt-get source xxx ) >>>> >>>> Do you have any unanswered questions? >>> >>> I found /usr/lib/libpq.a if i installed postgresql-server-dev-9.1 >>> on >>> my test machine. what use is it ? >> >> I'm sorry, but I don't know for sure. I'm sure it is used by that >> package. :) >> >>> >>>> >>>>> 2) else since the update, i have a client with a state of "dir >>>>> inserting attribute" for 3 hours :( >>>>> This Client have 1,8 To and 16 Millions of files. An idea if >>>>> something >>>>> change since ?? >>>> >>>> That's a lot of inserts to do. It can take a while to insert 16 >>>> million rows. >>>> >>>>> >>>>> No grant privileges on Tables restoreobject* , like this urls say >>>>> ( >>>>> >>>>> >>>>> >>>>> http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg51149.html >>>>> >>>>> >>>>> ) >>>> >>>> I'm not sure why you mention this... :) >>> these are things that I could etrangent notes for the update... >>> Not important ? ... >> >> I don't know. >> >>>> >>>>> >>>>> everything works well apart this status "DIR inserting attribute" >>>>> for >>>>> one big client and libpq.a not installed. I'm a little worried. >>>> >>>> Are you sure that libpq.a is not installed? Please check again... >>> In prod, i very sure. >>>> >>>>> >>>>> Thank for any information. >>>> >>>> >>> I search ... I found a notion of "Spool attributes" ?? >> >> It sounds like your system is already spooling attributes. >> >> Perhaps if you pasted your Job and JobDefs (if applicable) for the >> Job >> in question. > ../.. > JobDefs { > Name = "DefaultJob" > Type = Backup > Level = Incremental > Schedule = "WeeklyCycle" > Storage = File > Messages = Standard > # > Reschedule On Error = yes > Reschedule Interval = 1h > Reschedule Times = 2 > # Fenetre = Max start delay + Max Run Time > # duree de demarrage max du job de 24h > Max Start Delay = 24h > # temps execution max du job 36 ou 12h > Full Max Run Time = 36h > Differential Max Run Time = 36h > Incremental Max Run Time = 36h > ## Incremental Max Run Time = 12h > Priority = 10 > } > # > # chargement des clients > # > @|"sh -c 'for f in /etc/bacula/Conf.d/Client/*.conf ; do echo @${f} ; > done'" > # > ../.. > > Job { > Name = "mail" > Enabled = yes > Client = mail-fd > JobDefs = "DefaultJob" > FileSet = "fileset_mail" > Pool = mail > Storage = mail > Schedule = "Weekly-mail" > Full Max Run Time = 47h > ## debut modif le 20100512 > # Incremental Max Run Time = 14h > Incremental Max Run Time = 16h > Reschedule On Error = no > Reschedule Times = 1 > ## fin modif le 20100512 > ClientRunBeforeJob = "/etc/bacula/scripts/before.sh" > ## ClientRunAfterJob = "/etc/bacula/scripts/after.sh" > RunScript { > RunsWhen = After > RunsOnFailure = yes > RunsOnClient = yes > RunsOnSuccess = yes > Command = "/etc/bacula/scripts/after.sh" > } > ## > Messages = MAIL-mail > Write Bootstrap = "/var/lib/bacula/mail.bsr" > } > > If you see something .
I am out of time just now. Hopefully someone else on the list can take over. (remember to do a reply-all) -- Dan Langille - http://langille.org/ ------------------------------------------------------------------------------ Keep yourself connected to Go Parallel: VERIFY Test and improve your parallel project with help from experts and peers. http://goparallel.sourceforge.net _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
