Dear Thomas,

In message <52d555c5.9070...@mtl.mit.edu> 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: w...@denx.de
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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to