[ome-devel] image sequence is invalid

Josh Moore josh.moore at gmx.de
Sun Nov 13 13:34:18 GMT 2005


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

anyone know how this could have come about:

ome=# select image_id from images;
- -[ RECORD 1 ]
image_id | 1
- -[ RECORD 2 ]
image_id | 2
- -[ RECORD 3 ]
image_id | 3
- -[ RECORD 4 ]
image_id | 4
- -[ RECORD 5 ]
image_id | 5
- -[ RECORD 6 ]
image_id | 6
- -[ RECORD 7 ]
image_id | 7


ome=# select * from image_seq;
- -[ RECORD 1 ]-+--------------------
sequence_name | image_seq
last_value    | 2
increment_by  | 1
max_value     | 9223372036854775807
min_value     | 1
cache_value   | 1
log_cnt       | 31
is_cycled     | f
is_called     | t

I'm going to just call next() until it's at the proper level, but this
is obviously "Not Good (TM)". I restored the database recently, perhaps
that's the cause.

~ Josh.

PS this is a 2_5_0 database.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDd0DZIwpkR5bKmAsRAjr+AJ9HhFdv1OcCaKOX7W+NV605CVIWjQCfb8O3
KE/v7bmO8BfIJSfsRj5ajnc=
=n6sv
-----END PGP SIGNATURE-----


More information about the ome-devel mailing list