https://bugzilla.novell.com/show_bug.cgi?id=356296 Summary: OpenSUSE Frontend Error: Mysql::Error: Duplicate entry if you try to remove a target Product: openSUSE.org Version: unspecified Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: BuildService AssignedTo: abauer@novell.com ReportedBy: anschneider@novell.com QAContact: adrian@novell.com Found By: --- I tried to remove the SUSE Linux 10.0 target and got the following error: Error Details: Errorcode: uncaught_exception Message: Mysql::Error: Duplicate entry '2348-1' for key 3: UPDATE path_elements SET position = (position - 1) WHERE (parent_id = 2348 AND position > 1) Exception from API: ActiveRecord::StatementInvalid: Mysql::Error: Duplicate entry '2348-1' for key 3: UPDATE path_elements SET position = (position - 1) WHERE (parent_id = 2348 AND position > 1) Stack Trace: /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/connection_adapters/mysql_adapter.rb:243:in `execute' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/connection_adapters/mysql_adapter.rb:258:in `update' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/base.rb:497:in `update_all' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/acts/list.rb:221:in `decrement_positions_on_lower_items' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/acts/list.rb:125:in `remove_from_list' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:333:in `send' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:333:in `callback' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:330:in `each' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:330:in `callback' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:320:in `destroy_without_transactions' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:125:in `destroy' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/connection_adapters/abstract/database_statements.rb:59:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:95:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:121:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:125:in `destroy' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:335:in `callback' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/associations/association_proxy.rb:123:in `each' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/associations/association_proxy.rb:123:in `send' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/associations/association_proxy.rb:123:in `method_missing' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/associations/has_many_association.rb:98:in `method_missing' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:335:in `callback' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:335:in `callback' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:330:in `each' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:330:in `callback' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/callbacks.rb:320:in `destroy_without_transactions' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:125:in `destroy' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/connection_adapters/abstract/database_statements.rb:59:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:95:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:121:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:125:in `destroy' /srv/www/vhosts/opensuse.org/frontend/releases/20071106165258/app/models/db_project.rb:188:in `store_axml' /srv/www/vhosts/opensuse.org/frontend/releases/20071106165258/app/models/db_project.rb:179:in `each' /srv/www/vhosts/opensuse.org/frontend/releases/20071106165258/app/models/db_project.rb:179:in `store_axml' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/connection_adapters/abstract/database_statements.rb:59:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:95:in `transaction' /srv/www/vhosts/opensuse.org/frontend/releases/20071106165258/app/models/db_project.rb:55:in `store_axml' /srv/www/vhosts/opensuse.org/frontend/releases/20071106165258/app/models/db_project.rb:32:in `store_axml' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/connection_adapters/abstract/database_statements.rb:59:in `transaction' /usr/lib64/ruby/gems/1.8/gems/activerecord-1.15.5/lib/active_record/transactions.rb:95:in `transaction' /srv/www/vhosts/opensuse.org/frontend/releases/20071106165258/app/models/db_project.rb:28:in `store_axml' /srv/www/vhosts/opensuse.org/common/current/lib/activexml/transport.rb:230:in `save' /srv/www/vhosts/opensuse.org/common/current/lib/activexml/base.rb:89:in `save' /srv/www/vhosts/opensuse.org/frontend/releases/20071106165258/app/controllers/source_controller.rb:256:in `project_meta' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/base.rb:1101:in `send' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/base.rb:1101:in `perform_action_without_filters' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/filters.rb:696:in `call_filters' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/filters.rb:688:in `perform_action_without_benchmark' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue' /usr/lib64/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/rescue.rb:83:in `perform_action' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/base.rb:435:in `send' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/base.rb:435:in `process_without_filters' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/filters.rb:684:in `process_without_session_management_support' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/session_management.rb:114:in `process' /usr/lib64/ruby/gems/1.8/gems/actionpack-1.13.5/lib/action_controller/base.rb:334:in `process' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/dispatcher.rb:41:in `dispatch' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/fcgi_handler.rb:168:in `process_request' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/fcgi_handler.rb:143:in `process_each_request!' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/fcgi_handler.rb:109:in `with_signal_handler' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/fcgi_handler.rb:142:in `process_each_request!' /usr/lib64/ruby/vendor_ruby/1.8/fcgi.rb:612:in `each_cgi' /usr/lib64/ruby/vendor_ruby/1.8/fcgi.rb:609:in `each' /usr/lib64/ruby/vendor_ruby/1.8/fcgi.rb:609:in `each_cgi' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/fcgi_handler.rb:141:in `process_each_request!' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/fcgi_handler.rb:55:in `process!' /usr/lib64/ruby/gems/1.8/gems/rails-1.2.5/lib/fcgi_handler.rb:25:in `process!' /srv/www/vhosts/opensuse.org/frontend/current/public/dispatch.fcgi:24 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.