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

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

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