Re: [Treebase-devel] FYI: sequence vs id dis-synch in some tables - FIXED

[Vladimir G. <vla...@du...>]

I have now updated sequence start values to be larger than max IDs in  
the corresponding tables.

Here a few observations of strange things, if someone wants to get  
concerned:

* Tables where sequences were at 1, but tables had much higher max IDs  
(in both DB instances):  chargroup, charset, charweight.
(I generally reinitialized these at the next thousand greater than  
their max ID)

* Table ancestralstate has no data, but the sequence is 4885 (I left  
it as this).  Ditto for usertype, but the sequence is just 4.

--Vladimir


On Feb 4, 2010, at 10:02 AM, Vladimir Gapeyev wrote:

> While uploading to 6666 one of the files sent yesterday by Bill
> (Diatrypaceae BETA.nex) I've got this SQL reject
>
> java.sql.BatchUpdateException: Batch entry 0 insert into CHARSET
> (VERSION, MATRIX_ID, Title, TYPE, CHARSET_ID) values (0, 4157, Gene1,
> 'U', 2) was aborted.
>
> The cause appears to be that some (not all) sequences start with 1,
> while their tables are far from empty.
>
> I'll check all tables and sequences in both treebasedev and
> treebasestage to fix this, hopefully by noon.
>
> --VG
>
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the  
> business
> Choose flexible plans and management services without long-term  
> contracts
> Personal 24x7 support from experience hosting pros just a phone call  
> away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel