Hello Guilherme, On 8/4/21 20:06, Guilherme Santos wrote: > Hey Eric, thanks to reply. Sorry, I said that the table has a about a > million lines... but it has more then 156 million lines.
So, we are more around 7.8 million jobs in your catalog if you have only standard Bacula log lines, congratulation! :-) > So, I did a query at table Log and it has information about the first > log (LogId = 1, JobId = 1). It indicates that no maintenance was done > yet. What do you suggest? > > The Bacula is configured do a prune at expired volumes everyday after > complete all backups. You can run a couple of queries to determine where the problem is, for example, list the number of lines per job SELECT JobId, count(1) Nb FROM Log GROUP BY JobId ORDER BY Nb DESC LIMIT 100; The second step would be to read the logs for these jobs and identify the pollution source. list joblog jobid=x or still via SQL SELECT LogText from Log WHERE JobId=x; Once you know the kind of line, you can reduce the verbosity of your procedures or correct the configuration. Hope it helps! Best Regards, Eric > Thanks! > > ________________________________ De: Eric Bollengier via Bacula-users > <bacula-users@lists.sourceforge.net> Enviado: quarta-feira, 4 de > agosto de 2021 11:56 Para: bacula-users@lists.sourceforge.net > <bacula-users@lists.sourceforge.net> Assunto: Re: [Bacula-users] Log > table so big > > Hello, > > On 8/4/21 15:37, Guilherme Santos wrote: >> Hello! First, thanks to suport. >> >> I'm using Bacula for a consider time and my Log table is about >> 19GB. What's the best solution to "solve" this? This table has more >> than a million lines. I'm using Bacula 9.4.4. >> > > 19GB for 1,000,000 records is a lot, you might double check if you > run the database maintenance tools properly. > > Then, I would suggest to have a look to the table content, the last > time I saw this problem, a couple of runscripts were generating 95% > of the content of the table. > > If you list the files you backup or something like that in the > Messages resource, it can be also very verbose, but you can configure > what you want to see or not. > > A regular job is probably around 20 lines, if you have more than > 50,000 jobs in your Job table, it might be normal as well. You can > prune your Jobs or also not use the catalog as a Messages > destination. > > Hope it helps! > > Best Regards, Eric > > _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
