Dear Thomas,
In message <[email protected]> you wrote:
> My guess is that during the migration from MySQL to Postgres, the
> sequences in Bacula did not get seeded right and probably are starting
> with a seed value of 1.
Do you have any idea why this would happen? Is this something I can
influence?
Are there any other variables that might hit by similar issues?
> the filesetid field in the fileset table is automatically populated by
> the fileset_filesetid_seq sequence.
>
> Run the following two queries and see what the results are - in
> particular, see what the last_value is for the sequence. This should be
> equal to the max value from the fileset table which it is in my Bacula
> database. If not, you'll need to manually fix it via a sql update
> command to the sequence.
>
> select max(filesetid) from fileset;
>
> select * from fileset_filesetid_seq;
This is what I get:
Enter SQL query: select max(filesetid) from fileset;
+------+
| max |
+------+
| 75 |
+------+
Enter SQL query: select * from fileset_filesetid_seq;
+-----------------------+------------+-------------+--------------+---------------------------+-----------+-------------+---------+-----------+-----------+
| sequence_name | last_value | start_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled | is_called |
+-----------------------+------------+-------------+--------------+---------------------------+-----------+-------------+---------+-----------+-----------+
| fileset_filesetid_seq | 4 | 1 | 1 |
9,223,372,036,854,775,807 | 1 | 1 | 32 | f | t
|
+-----------------------+------------+-------------+--------------+---------------------------+-----------+-------------+---------+-----------+-----------+
Enter SQL query:
Sorry, my DB / sql knowledge is somewhat limited (read: non-existient).
Could you please be so kind and tell me how I could fix that?
Thanks in advance!
Best regards,
Wolfgang Denk
--
DENX Software Engineering GmbH, MD: Wolfgang Denk & Detlev Zundel
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: [email protected]
Of course there's no reason for it, it's just our policy.
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
