Zitat von Julien Cochennec <julien.cochen...@mnhn.fr>: > 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
Might be that MySQL is deadlocked, but i don't know MySQL enough to confirm... > Where is the /bacula/Db/Systemlog? I found no file like this on my server. This means search the Bacula log, the Database (MySQL) log and the OS (Linux) system log for trouble. Your syslog configuration should tell you where to find these log files. 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
