On 30/11/2012 10:53, lst_ho...@kwsoft.de wrote: > Zitat von Julien Cochennec <julien.cochen...@mnhn.fr>: > >> Hi Everybody, >> I have a Dir Inserting Attribute (it's been 2 days now) so all my >> backups are stuck because of this. >> Is there a "quick fix", or even a "dirty fix" to get rid of this? >> I saw solutions about compiling again without a batch-insert option, but >> I really don't want to do that. >> I can configure anything on mysql server to make things go faster. >> Thanks. > You really should be more specific about your problem: > - Which Bacula version? > - Installed from scratch or has it worked before? > - What kind of Jobs are failing? > - Any errror in the Bacula/Db/Systemlog? > > and so on...
Bacula version is 5.0.1 It worked since many month, almost one year, first time I get this problem. The First Job that is "hanging" is many To (almost 4 To) and the others seem to be waiting for this one (?) Mysqladmin processlist shows this : | 1772 | bacula | localhost:58412 | bacula | Query | 105617 | Sending data | INSERT INTO Path (Path) SELECT a.Path FROM (SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS ( | | 1950 | bacula | localhost:58825 | bacula | Query | 100362 | Locked | LOCK TABLES Path write, batch write, Path as p write Where is the /bacula/Db/Systemlog? I found no file like this on my server. Thanks for your help. > > Normally inserting attributes, even many of them is not a problem so > there is no "dirty fix" to apply. > > Regards > > Andreas > > > > ------------------------------------------------------------------------------ > Keep yourself connected to Go Parallel: > TUNE You got it built. Now make it sing. Tune shows you how. > http://goparallel.sourceforge.net > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------------ Keep yourself connected to Go Parallel: TUNE You got it built. Now make it sing. Tune shows you how. http://goparallel.sourceforge.net _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
