Author: Christian Manal <moenoel AT informatik.uni-bremen DOT de>
Date: Sun, 05 Jul 2015 12:43:48 +0200
Hi list, I recently upgraded my Bacula director and storage to 7.0.5 from 5.2.x and now some jobs fail with the following error: Fatal error: sql_create.c:851 Fill Filename table Query failed: INSERT
Hello, It appears to me that for some reason you have duplicate filename entries in the Filename table. Perhaps you have a filename of NULL and a filename of "", which perhaps PostgreSQL treats as eq
Author: Christian Manal <moenoel AT informatik.uni-bremen DOT de>
Date: Sun, 05 Jul 2015 15:37:22 +0200
Hi Kern, I tried querying for the values that were indicated as duplicates by the error messages. I either got only one entry back or none at all. I also tried looking for duplicates in general with
When you did that PostgreSQL upgrade, did you export the database in .sql format before the upgrade then reload it back after the upgrade? If not, that is probably where things went wrong. With MySQL
Author: Christian Manal <moenoel AT informatik.uni-bremen DOT de>
Date: Sun, 05 Jul 2015 18:50:48 +0200
Am 05.07.2015 um 18:16 schrieb Kern Sibbald: I dumped it in Postgres' "custom" format on the old host, with "pg_dump -Fc", and then loaded it with pg_restore on the new host. But I just realized that
I don't know, because I am not an expert on PostgreSQL. In any case, now that it is created and you have used it, it might be hard to go back. I am sorry, but at this point, I am out of ideas. Good l
Author: Christian Manal <moenoel AT informatik.uni-bremen DOT de>
Date: Mon, 06 Jul 2015 10:10:53 +0200
Thanks your input anyway, Kern. I appreciate it. I just dumped my current db and restored it into a new database with the correct settings. Now I can find duplicates. In fact, there are 12 million du