Re: [Bacula-users] Duplicate entries on mysql database

2011-04-18 Thread Leonardo Almeida Lage
Hello, Thanks for replies... I my case, I'm running bacula on vps server, de dbcheck fix problems, but delay a big time to finish.. . I make a single purge of old backups too (my File table have 10GB!) and now problem is fixed... now i migrate bacula db for a more best server too. If problem

Re: [Bacula-users] Duplicate entries on mysql database

2011-04-18 Thread Matias Banchoff
Hi! once I had a problem with our MySQL catalog. I don't know if the problem is the same, but perhaps this helps you... 1) First, make a dump of your database, just in case 2) You can run from the mysql console: - check table, to verify data and indexes integrity. - Repair table, fixe

Re: [Bacula-users] Duplicate entries on mysql database

2011-04-16 Thread Jari Fredriksson
16.4.2011 2:37, Leonardo Almeida Lage kirjoitti: > Hello Friends, > > I'm using bacula at one month.. no problems, but this week, many jobs > fail, with this error: > > 2011-04-15 20:19:25 JobId 637: Fatal error: sql_create.c:875 Fill > Filename table Query failed: INSERT INTO Filename (Name) S

Re: [Bacula-users] Duplicate entries on mysql database

2011-04-15 Thread James Harper
> Hello Friends, > > I'm using bacula at one month.. no problems, but this week, many jobs > fail, with this error: > > 2011-04-15 20:19:25 JobId 637: Fatal error: sql_create.c:875 Fill > Filename table Query failed: INSERT INTO Filename (Name) SELECT a.Name > FROM (SELECT DISTINCT Name FROM batc

[Bacula-users] Duplicate entries on mysql database

2011-04-15 Thread Leonardo Almeida Lage
Hello Friends, I'm using bacula at one month.. no problems, but this week, many jobs fail, with this error: 2011-04-15 20:19:25 JobId 637: Fatal error: sql_create.c:875 Fill Filename table Query failed: INSERT INTO Filename (Name) SELECT a.Name FROM (SELECT DISTINCT Name FROM batch) AS a WHERE