[Gusdev-gusdev] Problem with ga registration/update - Primary key constraint

[Thomas O. <ot...@fi...>]

Hi,

I did an update via cvs, rebuild the stuff, worked more or less fine.

But this the ga wanted to be registered another time:
USER ERROR: GUS::PluginMgr::GusApplication revision 1.52 has not been 
registered.
Please use 'ga +meta --commit'

The error of this command see below. There is a conflict of the primary 
key...
So I changed the cvs version and the MD5 checksum in the table.

But I have to do this for all the plugins - no fun...

Who can help me?

Thomas


ERROR: of ga + meta --commit
DBD::Oracle::st execute failed: ORA-00001: unique constraint 
(CORE.PK_ALGORITHMIMPLEMENTATION) violated (DBD ERROR: OCIStmtExecute) 
at /home/oracle/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 145.

 SQL ERROR!! involving
 
    INSERT INTO Core.AlgorithmImplementation (  other_read, group_write, 
cvs_revision, algorithm_id, group_read, cvs_tag, user_read, row_user_id, 
description, algorithm_implementation_id, other_write, 
modification_date, row_project_id, row_alg_invocation_id, 
executable_md5, executable, row_group_id, user_write )
    VALUES   (  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE, ?, ?, ?, ?, ?, 
? ) 
 Values: 1, 1, 1.52, 2, 1,  , 1, 1, update for GUS 3.0, 22, 0, 1, 1, 
c1212c2753960e177d29b40d5a313f59, GUS::PluginMgr::GusApplication, 1, 1 
at /home/oracle/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 185
        
GUS::ObjRelP::DbiDbHandle::death('GUS::ObjRelP::DbiDbHandle=HASH(0x8691088)','\x{a} 
SQL ERROR!! involving\x{a} \x{a}    INSERT INTO Core.AlgorithmImple...') 
called at /home/oracle/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 148
        
GUS::ObjRelP::DbiDbHandle::sqlExec('GUS::ObjRelP::DbiDbHandle=HASH(0x8691088)','GUS::ObjRelP::DbiDbHandle::st=HASH(0x87d1e30)','ARRAY(0x87d1ef0)','\x{a}    
INSERT INTO Core.AlgorithmImplementation (  other_read, ...') called at 
/home/oracle/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm line 681
        
GUS::ObjRelP::DbiRow::quote_and_insert('GUS::Model::Core::AlgorithmImplementation=HASH(0x870d390)','HASH(0x86f1b28)') 
called at /home/oracle/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm line 628
        
GUS::ObjRelP::DbiRow::insert('GUS::Model::Core::AlgorithmImplementation=HASH(0x870d390)') 
called at /home/oracle/gus_home/lib/perl/GUS/Model/GusRow.pm line 1677
        
GUS::Model::GusRow::submit('GUS::Model::Core::AlgorithmImplementation=HASH(0x870d390)','undef',1) 
called at /home/oracle/gus_home/lib/perl/GUS/Model/GusRow.pm line 1764
        
GUS::Model::GusRow::submitChildrenInClass('GUS::Model::Core::Algorithm=HASH(0x8690ff8)','GUS::Model::Core::AlgorithmImplementation') 
called at /home/oracle/gus_home/lib/perl/GUS/Model/GusRow.pm line 1745
        
GUS::Model::GusRow::submitAllChildren('GUS::Model::Core::Algorithm=HASH(0x8690ff8)') 
called at /home/oracle/gus_home/lib/perl/GUS/Model/GusRow.pm line 1684
        
GUS::Model::GusRow::submit('GUS::Model::Core::Algorithm=HASH(0x8690ff8)') 
called at /home/oracle/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm 
line 361
        
GUS::PluginMgr::GusApplication::doMajorMode_Meta('GUS::PluginMgr::GusApplication=HASH(0x804d00c)','undef') 
called at /home/oracle/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm 
line 289
        
GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr::GusApplication=HASH(0x804d00c)','undef') 
called at /home/oracle/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm 
line 198
        
GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr::GusApplication=HASH(0x804d00c)','ARRAY(0x8060684)') 
called at /home/oracle/gus_home/bin/ga line 11



ERROR of Submitrow:
DBD::Oracle::st execute failed: ORA-00001: unique constraint 
(CORE.PK_ALGORITHMIMPLEMENTATION) violated (DBD ERROR: OCIStmtExecute) 
at /home/oracle/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 145.

 SQL ERROR!! involving
 
    INSERT INTO Core.AlgorithmImplementation (  other_read, group_write, 
cvs_revision, algorithm_id, group_read, cvs_tag, user_read, row_user_id, 
description, algorithm_implementation_id, other_write, 
modification_date, row_project_id, row_alg_invocation_id, 
executable_md5, executable, row_group_id, user_write )
    VALUES   (  ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE, ?, ?, ?, ?, ?, 
? ) 
 Values: 1, 1, 1.9, 3, 1,  , 1, 1, make consistent with GUS 3.0, 24, 0, 
1, 1, 60470c8cf30c7cea218fcbbb48840d97, GUS::Common::Plugin::SubmitRow, 
1, 1 at /home/oracle/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 185