Issues created while a project being imported break issue creation after
Summary
When an issue is created through the API at the same time a project is being imported, the issue counter is set. It appears when issues are imported, this does not set the counter right away, so the counter is stuck at a number that is below the number of issues.
This results in a 409 "Duplicated issue" error when trying to create new issues via API, and a 500 error when trying to create issues through the UI.
Steps to reproduce
- Start importing a project with 2 or more existing issues using GitLab export
- Immediately after starting the import, create an issue via the API
- Wait for the import to complete
- Try to create another issue via API or UI
Results:
- The original issue with ID of 1 from the GitLab export will not exist in the project. Instead the issue created by the API will.
- Any attempts to create an Issue will fail with a 409 (API) or 500 (UI)
Workaround
Create an issue via the API that includes an iid
. Specifying an iid
greater than the number of issues in the projects appears to update the tracker and allow future issues to be created. The iid can only be specified by a user with the Owner role or administrator rights.
- Get the issue statistics of the project
GET /projects/:id/issues_statistics
- Take note of the count for
all
issues - Create an issue while specifying an
iid
value of theall
count + 1POST /projects/:id/issues?title=test&iid=<all count +1>
Example Project
https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net/developers/import/
What is the current bug behavior?
Users are able to create issues in a project that is still being imported. If done, issues cannot be created in the project
- API requests to create new issues return a 409 "Duplicated issue" error
- UI attempts to create new issues result in a 500 error
- The
last_value
for theinternal_ids
table appears to be stuck on an existing issue ID, preventing the creation of new issues.
What is the expected correct behavior?
Issues cannot be created while the project import is still going.
OR
Issues are created during the import process, but the internal_id is updated at the end of the import.
Relevant logs and/or screenshots
Project import status
id 2
description null
name "import"
name_with_namespace "developers / import"
path "import"
path_with_namespace "developers/import"
created_at "2025-02-12T19:41:10.350Z"
import_status "finished"
import_type "gitlab_project"
correlation_id "01JKXTVXXBC396HT85MGV96B45"
failed_relations
0
id 1
created_at "2025-02-12T19:41:12.976Z"
exception_class "ActiveRecord::RecordNotUnique"
source "process_relation_item!"
exception_message null
relation_name "issues"
line_number 0
import_error null
stats null
Creating an issue via UI
GitLab Logs
==> /var/log/gitlab/gitlab-rails/application_json.log <==
{"severity":"INFO","time":"2025-02-13T00:32:25.114Z","correlation_id":"01JKYBH77T4T09HBBWZMQYS340","meta.caller_id":"Projects::IssuesController#create","meta.feature_category":"team_planning","meta.organization_id":1,"meta.remote_ip":"125.239.32.82","meta.user":"root","meta.user_id":1,"meta.project":"developers/import","meta.root_namespace":"developers","meta.client_id":"user/1","class":"Spam::SpamVerdictService","akismet_verdict":"allow","spam_check_verdict":null,"spam_check_rtt":8.115899981930852e-05,"final_verdict":"allow","username":"root","user_id":1,"target_type":"Issue","project_id":2}
==> /var/log/gitlab/postgresql/current <==
2025-02-13_00:32:25.17834 ERROR: duplicate key value violates unique constraint "index_issues_on_namespace_id_iid_unique"
2025-02-13_00:32:25.17838 DETAIL: Key (namespace_id, iid)=(6, 4) already exists.
2025-02-13_00:32:25.17838 STATEMENT: /*application:web,correlation_id:01JKYBH77T4T09HBBWZMQYS340,endpoint_id:Projects::IssuesController#create,db_config_database:gitlabhq_production,db_config_name:main*/ INSERT INTO "issues" ("title", "author_id", "project_id", "created_at", "updated_at", "description", "iid", "title_html", "description_html", "cached_markdown_version", "work_item_type_id", "namespace_id", "correct_work_item_type_id", "lock_version") VALUES ('500', 1, 2, '2025-02-13 00:32:25.144714', '2025-02-13 00:32:25.144714', '', 4, '500', '', 2162688, 1, 6, 1, 0) RETURNING "id"
==> /var/log/gitlab/gitlab-rails/production_json.log <==
{"method":"POST","path":"/developers/import/-/issues","format":"html","controller":"Projects::IssuesController","action":"create","status":500,"time":"2025-02-13T00:32:25.183Z","params":[{"key":"authenticity_token","value":"[FILTERED]"},{"key":"issue","value":{"title":"[FILTERED]","description":"[FILTERED]","confidential":"0","assignee_ids":["0"],"epic_id":"","milestone_id":"","weight":"","due_date":"","sprint_id":"","issue_type":"issue","lock_version":"0"}},{"key":"namespace_id","value":"developers"},{"key":"project_id","value":"import"}],"correlation_id":"01JKYBH77T4T09HBBWZMQYS340","meta.caller_id":"Projects::IssuesController#create","meta.feature_category":"team_planning","meta.organization_id":1,"meta.remote_ip":"125.239.32.82","meta.user":"root","meta.user_id":1,"meta.project":"developers/import","meta.root_namespace":"developers","meta.client_id":"user/1","remote_ip":"125.239.32.82","user_id":1,"username":"root","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:134.0) Gecko/20100101 Firefox/134.0","queue_duration_s":0.0148,"request_urgency":"low","target_duration_s":5,"redis_calls":25,"redis_allowed_cross_slot_calls":1,"redis_duration_s":0.0056879999999999995,"redis_read_bytes":3626,"redis_write_bytes":1913,"redis_db_load_balancing_calls":2,"redis_db_load_balancing_duration_s":0.000402,"redis_db_load_balancing_write_bytes":104,"redis_feature_flag_calls":16,"redis_feature_flag_duration_s":0.003446,"redis_feature_flag_read_bytes":3181,"redis_feature_flag_write_bytes":956,"redis_rate_limiting_calls":2,"redis_rate_limiting_duration_s":0.000661,"redis_rate_limiting_read_bytes":2,"redis_rate_limiting_write_bytes":140,"redis_repository_cache_calls":2,"redis_repository_cache_duration_s":0.000703,"redis_repository_cache_read_bytes":204,"redis_repository_cache_write_bytes":104,"redis_sessions_calls":3,"redis_sessions_allowed_cross_slot_calls":1,"redis_sessions_duration_s":0.000476,"redis_sessions_read_bytes":239,"redis_sessions_write_bytes":609,"db_count":30,"db_write_count":2,"db_cached_count":5,"db_txn_count":0,"db_replica_txn_count":0,"db_primary_txn_count":0,"db_replica_count":0,"db_primary_count":30,"db_replica_write_count":0,"db_primary_write_count":2,"db_replica_cached_count":0,"db_primary_cached_count":5,"db_replica_wal_count":0,"db_primary_wal_count":0,"db_replica_wal_cached_count":0,"db_primary_wal_cached_count":0,"db_replica_txn_max_duration_s":0.0,"db_primary_txn_max_duration_s":0.0,"db_replica_txn_duration_s":0.0,"db_primary_txn_duration_s":0.0,"db_replica_duration_s":0.0,"db_primary_duration_s":0.033,"db_main_txn_count":0,"db_ci_txn_count":0,"db_main_replica_txn_count":0,"db_ci_replica_txn_count":0,"db_main_count":30,"db_ci_count":0,"db_main_replica_count":0,"db_ci_replica_count":0,"db_main_write_count":2,"db_ci_write_count":0,"db_main_replica_write_count":0,"db_ci_replica_write_count":0,"db_main_cached_count":5,"db_ci_cached_count":0,"db_main_replica_cached_count":0,"db_ci_replica_cached_count":0,"db_main_wal_count":0,"db_ci_wal_count":0,"db_main_replica_wal_count":0,"db_ci_replica_wal_count":0,"db_main_wal_cached_count":0,"db_ci_wal_cached_count":0,"db_main_replica_wal_cached_count":0,"db_ci_replica_wal_cached_count":0,"db_main_txn_max_duration_s":0.0,"db_ci_txn_max_duration_s":0.0,"db_main_replica_txn_max_duration_s":0.0,"db_ci_replica_txn_max_duration_s":0.0,"db_main_txn_duration_s":0.0,"db_ci_txn_duration_s":0.0,"db_main_replica_txn_duration_s":0.0,"db_ci_replica_txn_duration_s":0.0,"db_main_duration_s":0.033,"db_ci_duration_s":0.0,"db_main_replica_duration_s":0.0,"db_ci_replica_duration_s":0.0,"cpu_s":0.293704,"mem_objects":91789,"mem_bytes":12996992,"mem_mallocs":50102,"mem_total_bytes":16668552,"pid":48655,"worker_id":"puma_4","rate_limiting_gates":["issues_create"],"exception.class":"ActiveRecord::RecordNotUnique","exception.message":"PG::UniqueViolation: ERROR: duplicate key value violates unique constraint \"index_issues_on_namespace_id_iid_unique\"\nDETAIL: Key (namespace_id, iid)=(6, 4) already exists.\n","exception.backtrace":["activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `exec_params'","activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `block (2 levels) in exec_no_cache'","activesupport (7.0.8.7) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'","activesupport (7.0.8.7) lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'","activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:767:in `block in exec_no_cache'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract_adapter.rb:752:in `block in log'","activesupport (7.0.8.7) lib/active_support/notifications/instrumenter.rb:24:in `instrument'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract_adapter.rb:743:in `log'","activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:766:in `exec_no_cache'","activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:745:in `execute_and_clear'","marginalia (1.11.1) lib/marginalia.rb:91:in `execute_and_clear_with_marginalia'","activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql/database_statements.rb:54:in `exec_query'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:132:in `exec_insert'","activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql/database_statements.rb:88:in `exec_insert'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:167:in `insert'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `insert'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `public_send'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `block in write_using_load_balancer'","lib/gitlab/database/load_balancing/load_balancer.rb:141:in `block in read_write'","lib/gitlab/database/load_balancing/load_balancer.rb:228:in `retry_with_backoff'","lib/gitlab/database/load_balancing/load_balancer.rb:130:in `read_write'","lib/gitlab/database/load_balancing/connection_proxy.rb:126:in `write_using_load_balancer'","lib/gitlab/database/load_balancing/connection_proxy.rb:61:in `block (2 levels) in <class:ConnectionProxy>'","activerecord (7.0.8.7) lib/active_record/persistence.rb:496:in `_insert_record'","activerecord (7.0.8.7) lib/active_record/persistence.rb:1098:in `_create_record'","activerecord (7.0.8.7) lib/active_record/counter_cache.rb:166:in `_create_record'","activerecord (7.0.8.7) lib/active_record/locking/optimistic.rb:84:in `_create_record'","activerecord (7.0.8.7) lib/active_record/attribute_methods/dirty.rb:222:in `_create_record'","activerecord (7.0.8.7) lib/active_record/callbacks.rb:459:in `block in _create_record'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:107:in `run_callbacks'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:929:in `_run_create_callbacks'","activerecord (7.0.8.7) lib/active_record/callbacks.rb:459:in `_create_record'","activerecord (7.0.8.7) lib/active_record/timestamp.rb:108:in `_create_record'","activerecord (7.0.8.7) lib/active_record/persistence.rb:1069:in `create_or_update'","activerecord (7.0.8.7) lib/active_record/callbacks.rb:455:in `block in create_or_update'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:118:in `block in run_callbacks'","activerecord (7.0.8.7) lib/active_record/autosave_association.rb:370:in `around_save_collection_association'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:138:in `run_callbacks'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:929:in `_run_save_callbacks'","activerecord (7.0.8.7) lib/active_record/callbacks.rb:455:in `create_or_update'","activerecord (7.0.8.7) lib/active_record/timestamp.rb:126:in `create_or_update'","activerecord (7.0.8.7) lib/active_record/persistence.rb:615:in `save'","activerecord (7.0.8.7) lib/active_record/validations.rb:47:in `save'","activerecord (7.0.8.7) lib/active_record/transactions.rb:298:in `block in save'","activerecord (7.0.8.7) lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `public_send'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `block in write_using_load_balancer'","lib/gitlab/database/load_balancing/load_balancer.rb:141:in `block in read_write'","lib/gitlab/database/load_balancing/load_balancer.rb:228:in `retry_with_backoff'","lib/gitlab/database/load_balancing/load_balancer.rb:130:in `read_write'","lib/gitlab/database/load_balancing/connection_proxy.rb:126:in `write_using_load_balancer'","lib/gitlab/database/load_balancing/connection_proxy.rb:78:in `transaction'","activerecord (7.0.8.7) lib/active_record/transactions.rb:350:in `with_transaction_returning_status'","activerecord (7.0.8.7) lib/active_record/transactions.rb:298:in `save'","activerecord (7.0.8.7) lib/active_record/suppressor.rb:50:in `save'","state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:511:in `block in save'","state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:530:in `block in around_save'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:150:in `block in run_actions'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:170:in `catch_exceptions'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:148:in `run_actions'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:133:in `run_callbacks'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:212:in `run_callbacks'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:63:in `block (2 levels) in perform'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:63:in `catch'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:63:in `block in perform'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:186:in `within_transaction'","state_machines (0.5.0) lib/state_machines/transition_collection.rb:62:in `perform'","state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:530:in `around_save'","state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:511:in `save'","app/services/issuable_base_service.rb:361:in `transaction_create'","ee/app/services/ee/issues/create_service.rb:28:in `transaction_create'","app/services/issuable_base_service.rb:208:in `block in create'","activerecord (7.0.8.7) lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'","activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'","activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `public_send'","lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `block in write_using_load_balancer'","lib/gitlab/database/load_balancing/load_balancer.rb:141:in `block in read_write'","lib/gitlab/database/load_balancing/load_balancer.rb:228:in `retry_with_backoff'","lib/gitlab/database/load_balancing/load_balancer.rb:130:in `read_write'","lib/gitlab/database/load_balancing/connection_proxy.rb:126:in `write_using_load_balancer'","lib/gitlab/database/load_balancing/connection_proxy.rb:78:in `transaction'","activerecord (7.0.8.7) lib/active_record/transactions.rb:350:in `with_transaction_returning_status'","app/services/issuable_base_service.rb:205:in `create'","ee/app/services/ee/issues/create_service.rb:16:in `create'","app/services/issues/create_service.rb:36:in `execute'","app/services/concerns/rate_limited_service.rb:84:in `execute'","app/controllers/projects/issues_controller.rb:164:in `create'","actionpack (7.0.8.7) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'","actionpack (7.0.8.7) lib/abstract_controller/base.rb:215:in `process_action'","actionpack (7.0.8.7) lib/action_controller/metal/rendering.rb:165:in `process_action'","actionpack (7.0.8.7) lib/abstract_controller/callbacks.rb:234:in `block in process_action'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:118:in `block in run_callbacks'","lib/gitlab/ip_address_state.rb:11:in `with'","ee/app/controllers/ee/application_controller.rb:45:in `set_current_ip_address'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","app/controllers/application_controller.rb:505:in `set_current_admin'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","lib/gitlab/session.rb:11:in `with_session'","app/controllers/application_controller.rb:496:in `set_session_storage'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","lib/gitlab/i18n.rb:114:in `with_locale'","lib/gitlab/i18n.rb:120:in `with_user_locale'","app/controllers/application_controller.rb:487:in `set_locale'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","app/controllers/application_controller.rb:480:in `set_current_context'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","marginalia (1.11.1) lib/marginalia.rb:109:in `record_query_comment'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","sentry-rails (5.22.1) lib/sentry/rails/controller_transaction.rb:34:in `block in sentry_around_action'","sentry-ruby (5.22.1) lib/sentry/hub.rb:108:in `with_child_span'","sentry-ruby (5.22.1) lib/sentry-ruby.rb:503:in `with_child_span'","sentry-rails (5.22.1) lib/sentry/rails/controller_transaction.rb:18:in `sentry_around_action'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:138:in `run_callbacks'","actionpack (7.0.8.7) lib/abstract_controller/callbacks.rb:233:in `process_action'","actionpack (7.0.8.7) lib/action_controller/metal/rescue.rb:23:in `process_action'","actionpack (7.0.8.7) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'","activesupport (7.0.8.7) lib/active_support/notifications.rb:206:in `block in instrument'","activesupport (7.0.8.7) lib/active_support/notifications/instrumenter.rb:24:in `instrument'","activesupport (7.0.8.7) lib/active_support/notifications.rb:206:in `instrument'","actionpack (7.0.8.7) lib/action_controller/metal/instrumentation.rb:66:in `process_action'","actionpack (7.0.8.7) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'","activerecord (7.0.8.7) lib/active_record/railties/controller_runtime.rb:27:in `process_action'","actionpack (7.0.8.7) lib/abstract_controller/base.rb:151:in `process'","actionview (7.0.8.7) lib/action_view/rendering.rb:39:in `process'","actionpack (7.0.8.7) lib/action_controller/metal.rb:188:in `dispatch'","actionpack (7.0.8.7) lib/action_controller/metal.rb:249:in `block in dispatch'","lib/gitlab/middleware/action_controller_static_context.rb:23:in `call'","actionpack (7.0.8.7) lib/action_controller/metal.rb:249:in `dispatch'","actionpack (7.0.8.7) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'","actionpack (7.0.8.7) lib/action_dispatch/routing/route_set.rb:32:in `serve'","actionpack (7.0.8.7) lib/action_dispatch/routing/mapper.rb:18:in `block in <class:Constraints>'","actionpack (7.0.8.7) lib/action_dispatch/routing/mapper.rb:48:in `serve'","actionpack (7.0.8.7) lib/action_dispatch/journey/router.rb:50:in `block in serve'","actionpack (7.0.8.7) lib/action_dispatch/journey/router.rb:32:in `each'","actionpack (7.0.8.7) lib/action_dispatch/journey/router.rb:32:in `serve'","actionpack (7.0.8.7) lib/action_dispatch/routing/route_set.rb:852:in `call'","gitlab-experiment (0.9.1) lib/gitlab/experiment/middleware.rb:19:in `call'","flipper (0.26.2) lib/flipper/middleware/memoizer.rb:72:in `memoized_call'","flipper (0.26.2) lib/flipper/middleware/memoizer.rb:37:in `call'","lib/gitlab/metrics/elasticsearch_rack_middleware.rb:16:in `call'","lib/gitlab/middleware/sidekiq_shard_awareness_validation.rb:20:in `block in call'","lib/gitlab/sidekiq_sharding/validator.rb:42:in `enabled'","lib/gitlab/middleware/sidekiq_shard_awareness_validation.rb:20:in `call'","lib/gitlab/middleware/memory_report.rb:13:in `call'","lib/gitlab/middleware/speedscope.rb:13:in `call'","lib/gitlab/database/load_balancing/rack_middleware.rb:23:in `call'","lib/gitlab/middleware/rails_queue_duration.rb:33:in `call'","lib/gitlab/etag_caching/middleware.rb:21:in `call'","lib/gitlab/metrics/rack_middleware.rb:16:in `block in call'","lib/gitlab/metrics/web_transaction.rb:46:in `run'","lib/gitlab/metrics/rack_middleware.rb:16:in `call'","lib/gitlab/middleware/go.rb:21:in `call'","lib/gitlab/middleware/query_analyzer.rb:11:in `block in call'","lib/gitlab/database/query_analyzer.rb:83:in `within'","lib/gitlab/middleware/query_analyzer.rb:11:in `call'","lib/ci/job_token/middleware.rb:11:in `call'","batch-loader (2.0.5) lib/batch_loader/middleware.rb:11:in `call'","rack-attack (6.7.0) lib/rack/attack.rb:103:in `call'","apollo_upload_server (2.1.6) lib/apollo_upload_server/middleware.rb:19:in `call'","lib/gitlab/middleware/multipart.rb:173:in `call'","rack-attack (6.7.0) lib/rack/attack.rb:127:in `call'","warden (1.2.9) lib/warden/manager.rb:36:in `block in call'","warden (1.2.9) lib/warden/manager.rb:34:in `catch'","warden (1.2.9) lib/warden/manager.rb:34:in `call'","rack-cors (2.0.2) lib/rack/cors.rb:102:in `call'","rack (2.2.10) lib/rack/tempfile_reaper.rb:15:in `call'","rack (2.2.10) lib/rack/etag.rb:27:in `call'","rack (2.2.10) lib/rack/conditional_get.rb:40:in `call'","rack (2.2.10) lib/rack/head.rb:12:in `call'","actionpack (7.0.8.7) lib/action_dispatch/http/permissions_policy.rb:38:in `call'","actionpack (7.0.8.7) lib/action_dispatch/http/content_security_policy.rb:39:in `call'","lib/gitlab/middleware/read_only/controller.rb:50:in `call'","lib/gitlab/middleware/read_only.rb:18:in `call'","lib/gitlab/middleware/unauthenticated_session_expiry.rb:18:in `call'","rack (2.2.10) lib/rack/session/abstract/id.rb:266:in `context'","rack (2.2.10) lib/rack/session/abstract/id.rb:260:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/cookies.rb:704:in `call'","lib/gitlab/middleware/same_site_cookies.rb:27:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'","activesupport (7.0.8.7) lib/active_support/callbacks.rb:99:in `run_callbacks'","actionpack (7.0.8.7) lib/action_dispatch/middleware/callbacks.rb:26:in `call'","sentry-rails (5.22.1) lib/sentry/rails/rescued_exception_interceptor.rb:14:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'","lib/gitlab/middleware/path_traversal_check.rb:35:in `call'","lib/gitlab/middleware/handle_malformed_strings.rb:21:in `call'","sentry-ruby (5.22.1) lib/sentry/rack/capture_exceptions.rb:30:in `block (2 levels) in call'","sentry-ruby (5.22.1) lib/sentry/hub.rb:269:in `with_session_tracking'","sentry-ruby (5.22.1) lib/sentry-ruby.rb:416:in `with_session_tracking'","sentry-ruby (5.22.1) lib/sentry/rack/capture_exceptions.rb:21:in `block in call'","sentry-ruby (5.22.1) lib/sentry/hub.rb:59:in `with_scope'","sentry-ruby (5.22.1) lib/sentry-ruby.rb:396:in `with_scope'","sentry-ruby (5.22.1) lib/sentry/rack/capture_exceptions.rb:20:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/show_exceptions.rb:29:in `call'","lib/gitlab/middleware/basic_health_check.rb:25:in `call'","lograge (0.11.2) lib/lograge/rails_ext/rack/logger.rb:15:in `call_app'","railties (7.0.8.7) lib/rails/rack/logger.rb:25:in `block in call'","activesupport (7.0.8.7) lib/active_support/tagged_logging.rb:99:in `block in tagged'","activesupport (7.0.8.7) lib/active_support/tagged_logging.rb:37:in `tagged'","activesupport (7.0.8.7) lib/active_support/tagged_logging.rb:99:in `tagged'","railties (7.0.8.7) lib/rails/rack/logger.rb:25:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/remote_ip.rb:93:in `call'","lib/gitlab/middleware/handle_ip_spoof_attack_error.rb:25:in `call'","lib/gitlab/middleware/request_context.rb:15:in `call'","lib/gitlab/middleware/webhook_recursion_detection.rb:15:in `call'","request_store (1.5.1) lib/request_store/middleware.rb:19:in `call'","rack (2.2.10) lib/rack/method_override.rb:24:in `call'","rack (2.2.10) lib/rack/runtime.rb:22:in `call'","rack-timeout (0.7.0) lib/rack/timeout/core.rb:154:in `block in call'","rack-timeout (0.7.0) lib/rack/timeout/support/timeout.rb:19:in `timeout'","rack-timeout (0.7.0) lib/rack/timeout/core.rb:153:in `call'","config/initializers/fix_local_cache_middleware.rb:11:in `call'","lib/gitlab/middleware/compressed_json.rb:44:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/executor.rb:14:in `call'","lib/gitlab/middleware/rack_multipart_tempfile_factory.rb:19:in `call'","rack (2.2.10) lib/rack/sendfile.rb:110:in `call'","lib/gitlab/middleware/sidekiq_web_static.rb:20:in `call'","lib/gitlab/metrics/requests_rack_middleware.rb:79:in `call'","gitlab-labkit (0.37.0) lib/labkit/middleware/rack.rb:22:in `block in call'","gitlab-labkit (0.37.0) lib/labkit/context.rb:35:in `with_context'","gitlab-labkit (0.37.0) lib/labkit/middleware/rack.rb:21:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/request_id.rb:26:in `call'","actionpack (7.0.8.7) lib/action_dispatch/middleware/host_authorization.rb:131:in `call'","railties (7.0.8.7) lib/rails/engine.rb:530:in `call'","railties (7.0.8.7) lib/rails/railtie.rb:226:in `public_send'","railties (7.0.8.7) lib/rails/railtie.rb:226:in `method_missing'","lib/gitlab/middleware/release_env.rb:12:in `call'","rack (2.2.10) lib/rack/urlmap.rb:74:in `block in call'","rack (2.2.10) lib/rack/urlmap.rb:58:in `each'","rack (2.2.10) lib/rack/urlmap.rb:58:in `call'","puma (6.5.0) lib/puma/configuration.rb:279:in `call'","puma (6.5.0) lib/puma/request.rb:99:in `block in handle_request'","puma (6.5.0) lib/puma/thread_pool.rb:389:in `with_force_shutdown'","puma (6.5.0) lib/puma/request.rb:98:in `handle_request'","puma (6.5.0) lib/puma/server.rb:468:in `process_client'","puma (6.5.0) lib/puma/server.rb:249:in `block in run'","puma (6.5.0) lib/puma/thread_pool.rb:166:in `block in spawn_thread'"],"exception.cause_class":"PG::UniqueViolation","exception.sql":"/*application:web,correlation_id:01JKYBH77T4T09HBBWZMQYS340,endpoint_id:Projects::IssuesController#create,db_config_database:gitlabhq_production,db_config_name:main*/ INSERT INTO \"issues\" (\"title\", \"author_id\", \"project_id\", \"created_at\", \"updated_at\", \"description\", \"iid\", \"title_html\", \"description_html\", \"cached_markdown_version\", \"work_item_type_id\", \"namespace_id\", \"correct_work_item_type_id\", \"lock_version\") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) RETURNING \"id\"","db_duration_s":0.06418,"view_duration_s":0.0,"duration_s":0.32363}
==> /var/log/gitlab/gitlab-rails/production.log <==
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_issues_on_namespace_id_iid_unique"
DETAIL: Key (namespace_id, iid)=(6, 4) already exists.
):
activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `exec_params'
activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `block (2 levels) in exec_no_cache'
activesupport (7.0.8.7) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport (7.0.8.7) lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:767:in `block in exec_no_cache'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract_adapter.rb:752:in `block in log'
activesupport (7.0.8.7) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract_adapter.rb:743:in `log'
activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:766:in `exec_no_cache'
activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql_adapter.rb:745:in `execute_and_clear'
marginalia (1.11.1) lib/marginalia.rb:91:in `execute_and_clear_with_marginalia'
activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql/database_statements.rb:54:in `exec_query'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:132:in `exec_insert'
activerecord (7.0.8.7) lib/active_record/connection_adapters/postgresql/database_statements.rb:88:in `exec_insert'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:167:in `insert'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `insert'
lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `public_send'
lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `block in write_using_load_balancer'
lib/gitlab/database/load_balancing/load_balancer.rb:141:in `block in read_write'
lib/gitlab/database/load_balancing/load_balancer.rb:228:in `retry_with_backoff'
lib/gitlab/database/load_balancing/load_balancer.rb:130:in `read_write'
lib/gitlab/database/load_balancing/connection_proxy.rb:126:in `write_using_load_balancer'
lib/gitlab/database/load_balancing/connection_proxy.rb:61:in `block (2 levels) in <class:ConnectionProxy>'
activerecord (7.0.8.7) lib/active_record/persistence.rb:496:in `_insert_record'
activerecord (7.0.8.7) lib/active_record/persistence.rb:1098:in `_create_record'
activerecord (7.0.8.7) lib/active_record/counter_cache.rb:166:in `_create_record'
activerecord (7.0.8.7) lib/active_record/locking/optimistic.rb:84:in `_create_record'
activerecord (7.0.8.7) lib/active_record/attribute_methods/dirty.rb:222:in `_create_record'
activerecord (7.0.8.7) lib/active_record/callbacks.rb:459:in `block in _create_record'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:107:in `run_callbacks'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:929:in `_run_create_callbacks'
activerecord (7.0.8.7) lib/active_record/callbacks.rb:459:in `_create_record'
activerecord (7.0.8.7) lib/active_record/timestamp.rb:108:in `_create_record'
activerecord (7.0.8.7) lib/active_record/persistence.rb:1069:in `create_or_update'
activerecord (7.0.8.7) lib/active_record/callbacks.rb:455:in `block in create_or_update'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
activerecord (7.0.8.7) lib/active_record/autosave_association.rb:370:in `around_save_collection_association'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:138:in `run_callbacks'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:929:in `_run_save_callbacks'
activerecord (7.0.8.7) lib/active_record/callbacks.rb:455:in `create_or_update'
activerecord (7.0.8.7) lib/active_record/timestamp.rb:126:in `create_or_update'
activerecord (7.0.8.7) lib/active_record/persistence.rb:615:in `save'
activerecord (7.0.8.7) lib/active_record/validations.rb:47:in `save'
activerecord (7.0.8.7) lib/active_record/transactions.rb:298:in `block in save'
activerecord (7.0.8.7) lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'
lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `public_send'
lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `block in write_using_load_balancer'
lib/gitlab/database/load_balancing/load_balancer.rb:141:in `block in read_write'
lib/gitlab/database/load_balancing/load_balancer.rb:228:in `retry_with_backoff'
lib/gitlab/database/load_balancing/load_balancer.rb:130:in `read_write'
lib/gitlab/database/load_balancing/connection_proxy.rb:126:in `write_using_load_balancer'
lib/gitlab/database/load_balancing/connection_proxy.rb:78:in `transaction'
activerecord (7.0.8.7) lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
activerecord (7.0.8.7) lib/active_record/transactions.rb:298:in `save'
activerecord (7.0.8.7) lib/active_record/suppressor.rb:50:in `save'
state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:511:in `block in save'
state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:530:in `block in around_save'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:150:in `block in run_actions'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:170:in `catch_exceptions'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:148:in `run_actions'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:133:in `run_callbacks'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:212:in `run_callbacks'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:63:in `block (2 levels) in perform'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:63:in `catch'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:63:in `block in perform'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:186:in `within_transaction'
state_machines (0.5.0) lib/state_machines/transition_collection.rb:62:in `perform'
state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:530:in `around_save'
state_machines-activerecord (0.8.0) lib/state_machines/integrations/active_record.rb:511:in `save'
app/services/issuable_base_service.rb:361:in `transaction_create'
ee/app/services/ee/issues/create_service.rb:28:in `transaction_create'
app/services/issuable_base_service.rb:208:in `block in create'
activerecord (7.0.8.7) lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (7.0.8.7) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
activerecord (7.0.8.7) lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `public_send'
lib/gitlab/database/load_balancing/connection_proxy.rb:127:in `block in write_using_load_balancer'
lib/gitlab/database/load_balancing/load_balancer.rb:141:in `block in read_write'
lib/gitlab/database/load_balancing/load_balancer.rb:228:in `retry_with_backoff'
lib/gitlab/database/load_balancing/load_balancer.rb:130:in `read_write'
lib/gitlab/database/load_balancing/connection_proxy.rb:126:in `write_using_load_balancer'
lib/gitlab/database/load_balancing/connection_proxy.rb:78:in `transaction'
activerecord (7.0.8.7) lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
app/services/issuable_base_service.rb:205:in `create'
ee/app/services/ee/issues/create_service.rb:16:in `create'
app/services/issues/create_service.rb:36:in `execute'
app/services/concerns/rate_limited_service.rb:84:in `execute'
app/controllers/projects/issues_controller.rb:164:in `create'
actionpack (7.0.8.7) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
actionpack (7.0.8.7) lib/abstract_controller/base.rb:215:in `process_action'
actionpack (7.0.8.7) lib/action_controller/metal/rendering.rb:165:in `process_action'
actionpack (7.0.8.7) lib/abstract_controller/callbacks.rb:234:in `block in process_action'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
lib/gitlab/ip_address_state.rb:11:in `with'
ee/app/controllers/ee/application_controller.rb:45:in `set_current_ip_address'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
app/controllers/application_controller.rb:505:in `set_current_admin'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
lib/gitlab/session.rb:11:in `with_session'
app/controllers/application_controller.rb:496:in `set_session_storage'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
lib/gitlab/i18n.rb:114:in `with_locale'
lib/gitlab/i18n.rb:120:in `with_user_locale'
app/controllers/application_controller.rb:487:in `set_locale'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
app/controllers/application_controller.rb:480:in `set_current_context'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
marginalia (1.11.1) lib/marginalia.rb:109:in `record_query_comment'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
sentry-rails (5.22.1) lib/sentry/rails/controller_transaction.rb:34:in `block in sentry_around_action'
sentry-ruby (5.22.1) lib/sentry/hub.rb:108:in `with_child_span'
sentry-ruby (5.22.1) lib/sentry-ruby.rb:503:in `with_child_span'
sentry-rails (5.22.1) lib/sentry/rails/controller_transaction.rb:18:in `sentry_around_action'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:138:in `run_callbacks'
actionpack (7.0.8.7) lib/abstract_controller/callbacks.rb:233:in `process_action'
actionpack (7.0.8.7) lib/action_controller/metal/rescue.rb:23:in `process_action'
actionpack (7.0.8.7) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
activesupport (7.0.8.7) lib/active_support/notifications.rb:206:in `block in instrument'
activesupport (7.0.8.7) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (7.0.8.7) lib/active_support/notifications.rb:206:in `instrument'
actionpack (7.0.8.7) lib/action_controller/metal/instrumentation.rb:66:in `process_action'
actionpack (7.0.8.7) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
activerecord (7.0.8.7) lib/active_record/railties/controller_runtime.rb:27:in `process_action'
actionpack (7.0.8.7) lib/abstract_controller/base.rb:151:in `process'
actionview (7.0.8.7) lib/action_view/rendering.rb:39:in `process'
actionpack (7.0.8.7) lib/action_controller/metal.rb:188:in `dispatch'
actionpack (7.0.8.7) lib/action_controller/metal.rb:249:in `block in dispatch'
lib/gitlab/middleware/action_controller_static_context.rb:23:in `call'
actionpack (7.0.8.7) lib/action_controller/metal.rb:249:in `dispatch'
actionpack (7.0.8.7) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
actionpack (7.0.8.7) lib/action_dispatch/routing/route_set.rb:32:in `serve'
actionpack (7.0.8.7) lib/action_dispatch/routing/mapper.rb:18:in `block in <class:Constraints>'
actionpack (7.0.8.7) lib/action_dispatch/routing/mapper.rb:48:in `serve'
actionpack (7.0.8.7) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (7.0.8.7) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (7.0.8.7) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (7.0.8.7) lib/action_dispatch/routing/route_set.rb:852:in `call'
gitlab-experiment (0.9.1) lib/gitlab/experiment/middleware.rb:19:in `call'
flipper (0.26.2) lib/flipper/middleware/memoizer.rb:72:in `memoized_call'
flipper (0.26.2) lib/flipper/middleware/memoizer.rb:37:in `call'
lib/gitlab/metrics/elasticsearch_rack_middleware.rb:16:in `call'
lib/gitlab/middleware/sidekiq_shard_awareness_validation.rb:20:in `block in call'
lib/gitlab/sidekiq_sharding/validator.rb:42:in `enabled'
lib/gitlab/middleware/sidekiq_shard_awareness_validation.rb:20:in `call'
lib/gitlab/middleware/memory_report.rb:13:in `call'
lib/gitlab/middleware/speedscope.rb:13:in `call'
lib/gitlab/database/load_balancing/rack_middleware.rb:23:in `call'
lib/gitlab/middleware/rails_queue_duration.rb:33:in `call'
lib/gitlab/etag_caching/middleware.rb:21:in `call'
lib/gitlab/metrics/rack_middleware.rb:16:in `block in call'
lib/gitlab/metrics/web_transaction.rb:46:in `run'
lib/gitlab/metrics/rack_middleware.rb:16:in `call'
lib/gitlab/middleware/go.rb:21:in `call'
lib/gitlab/middleware/query_analyzer.rb:11:in `block in call'
lib/gitlab/database/query_analyzer.rb:83:in `within'
lib/gitlab/middleware/query_analyzer.rb:11:in `call'
lib/ci/job_token/middleware.rb:11:in `call'
batch-loader (2.0.5) lib/batch_loader/middleware.rb:11:in `call'
rack-attack (6.7.0) lib/rack/attack.rb:103:in `call'
apollo_upload_server (2.1.6) lib/apollo_upload_server/middleware.rb:19:in `call'
lib/gitlab/middleware/multipart.rb:173:in `call'
rack-attack (6.7.0) lib/rack/attack.rb:127:in `call'
warden (1.2.9) lib/warden/manager.rb:36:in `block in call'
warden (1.2.9) lib/warden/manager.rb:34:in `catch'
warden (1.2.9) lib/warden/manager.rb:34:in `call'
rack-cors (2.0.2) lib/rack/cors.rb:102:in `call'
rack (2.2.10) lib/rack/tempfile_reaper.rb:15:in `call'
rack (2.2.10) lib/rack/etag.rb:27:in `call'
rack (2.2.10) lib/rack/conditional_get.rb:40:in `call'
rack (2.2.10) lib/rack/head.rb:12:in `call'
actionpack (7.0.8.7) lib/action_dispatch/http/permissions_policy.rb:38:in `call'
actionpack (7.0.8.7) lib/action_dispatch/http/content_security_policy.rb:39:in `call'
lib/gitlab/middleware/read_only/controller.rb:50:in `call'
lib/gitlab/middleware/read_only.rb:18:in `call'
lib/gitlab/middleware/unauthenticated_session_expiry.rb:18:in `call'
rack (2.2.10) lib/rack/session/abstract/id.rb:266:in `context'
rack (2.2.10) lib/rack/session/abstract/id.rb:260:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/cookies.rb:704:in `call'
lib/gitlab/middleware/same_site_cookies.rb:27:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
activesupport (7.0.8.7) lib/active_support/callbacks.rb:99:in `run_callbacks'
actionpack (7.0.8.7) lib/action_dispatch/middleware/callbacks.rb:26:in `call'
sentry-rails (5.22.1) lib/sentry/rails/rescued_exception_interceptor.rb:14:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'
lib/gitlab/middleware/path_traversal_check.rb:35:in `call'
lib/gitlab/middleware/handle_malformed_strings.rb:21:in `call'
sentry-ruby (5.22.1) lib/sentry/rack/capture_exceptions.rb:30:in `block (2 levels) in call'
sentry-ruby (5.22.1) lib/sentry/hub.rb:269:in `with_session_tracking'
sentry-ruby (5.22.1) lib/sentry-ruby.rb:416:in `with_session_tracking'
sentry-ruby (5.22.1) lib/sentry/rack/capture_exceptions.rb:21:in `block in call'
sentry-ruby (5.22.1) lib/sentry/hub.rb:59:in `with_scope'
sentry-ruby (5.22.1) lib/sentry-ruby.rb:396:in `with_scope'
sentry-ruby (5.22.1) lib/sentry/rack/capture_exceptions.rb:20:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/show_exceptions.rb:29:in `call'
lib/gitlab/middleware/basic_health_check.rb:25:in `call'
lograge (0.11.2) lib/lograge/rails_ext/rack/logger.rb:15:in `call_app'
railties (7.0.8.7) lib/rails/rack/logger.rb:25:in `block in call'
activesupport (7.0.8.7) lib/active_support/tagged_logging.rb:99:in `block in tagged'
activesupport (7.0.8.7) lib/active_support/tagged_logging.rb:37:in `tagged'
activesupport (7.0.8.7) lib/active_support/tagged_logging.rb:99:in `tagged'
railties (7.0.8.7) lib/rails/rack/logger.rb:25:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/remote_ip.rb:93:in `call'
lib/gitlab/middleware/handle_ip_spoof_attack_error.rb:25:in `call'
lib/gitlab/middleware/request_context.rb:15:in `call'
lib/gitlab/middleware/webhook_recursion_detection.rb:15:in `call'
request_store (1.5.1) lib/request_store/middleware.rb:19:in `call'
rack (2.2.10) lib/rack/method_override.rb:24:in `call'
rack (2.2.10) lib/rack/runtime.rb:22:in `call'
rack-timeout (0.7.0) lib/rack/timeout/core.rb:154:in `block in call'
rack-timeout (0.7.0) lib/rack/timeout/support/timeout.rb:19:in `timeout'
rack-timeout (0.7.0) lib/rack/timeout/core.rb:153:in `call'
config/initializers/fix_local_cache_middleware.rb:11:in `call'
lib/gitlab/middleware/compressed_json.rb:44:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/executor.rb:14:in `call'
lib/gitlab/middleware/rack_multipart_tempfile_factory.rb:19:in `call'
rack (2.2.10) lib/rack/sendfile.rb:110:in `call'
lib/gitlab/middleware/sidekiq_web_static.rb:20:in `call'
lib/gitlab/metrics/requests_rack_middleware.rb:79:in `call'
gitlab-labkit (0.37.0) lib/labkit/middleware/rack.rb:22:in `block in call'
gitlab-labkit (0.37.0) lib/labkit/context.rb:35:in `with_context'
gitlab-labkit (0.37.0) lib/labkit/middleware/rack.rb:21:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/request_id.rb:26:in `call'
actionpack (7.0.8.7) lib/action_dispatch/middleware/host_authorization.rb:131:in `call'
railties (7.0.8.7) lib/rails/engine.rb:530:in `call'
railties (7.0.8.7) lib/rails/railtie.rb:226:in `public_send'
railties (7.0.8.7) lib/rails/railtie.rb:226:in `method_missing'
lib/gitlab/middleware/release_env.rb:12:in `call'
rack (2.2.10) lib/rack/urlmap.rb:74:in `block in call'
rack (2.2.10) lib/rack/urlmap.rb:58:in `each'
rack (2.2.10) lib/rack/urlmap.rb:58:in `call'
puma (6.5.0) lib/puma/configuration.rb:279:in `call'
puma (6.5.0) lib/puma/request.rb:99:in `block in handle_request'
puma (6.5.0) lib/puma/thread_pool.rb:389:in `with_force_shutdown'
puma (6.5.0) lib/puma/request.rb:98:in `handle_request'
puma (6.5.0) lib/puma/server.rb:468:in `process_client'
puma (6.5.0) lib/puma/server.rb:249:in `block in run'
puma (6.5.0) lib/puma/thread_pool.rb:166:in `block in spawn_thread'
==> /var/log/gitlab/gitlab-workhorse/current <==
{"backend_id":"rails","content_type":"text/html; charset=utf-8","correlation_id":"01JKYBH77T4T09HBBWZMQYS340","duration_ms":365,"host":"irisb-latest.env-a72a3647.gcp.gitlabsandbox.net","level":"info","method":"POST","msg":"access","proto":"HTTP/1.1","referrer":"https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net/developers/import/-/issues/new","remote_addr":"125.239.32.82:0","remote_ip":"125.239.32.82","route":"","route_id":"default","status":500,"system":"http","time":"2025-02-13T00:32:25Z","ttfb_ms":365,"uri":"/developers/import/-/issues","user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:134.0) Gecko/20100101 Firefox/134.0","written_bytes":1624}
==> /var/log/gitlab/nginx/gitlab_access.log <==
125.239.32.82 - - [13/Feb/2025:00:32:25 +0000] "POST /developers/import/-/issues HTTP/2.0" 500 1624 "https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net/developers/import/-/issues/new" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:134.0) Gecko/20100101 Firefox/134.0" -
==> /var/log/gitlab/gitlab-workhorse/current <==
{"correlation_id":"01JKYBH7WK5XMB2NY2PWTZ9HZN","encoding":"","file":"/opt/gitlab/embedded/service/gitlab-rails/public/-/error-illustrations/error-500-lg.svg","level":"info","method":"GET","msg":"Send static file","time":"2025-02-13T00:32:25Z","uri":"/-/error-illustrations/error-500-lg.svg"}
{"backend_id":"rails","content_type":"image/svg+xml","correlation_id":"01JKYBH7WK5XMB2NY2PWTZ9HZN","duration_ms":0,"host":"irisb-latest.env-a72a3647.gcp.gitlabsandbox.net","level":"info","method":"GET","msg":"access","proto":"HTTP/1.1","referrer":"https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net/developers/import/-/issues","remote_addr":"125.239.32.82:0","remote_ip":"125.239.32.82","route":"^/-/","route_id":"dash","status":200,"system":"http","time":"2025-02-13T00:32:25Z","ttfb_ms":0,"uri":"/-/error-illustrations/error-500-lg.svg","user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:134.0) Gecko/20100101 Firefox/134.0","written_bytes":6506}
==> /var/log/gitlab/nginx/gitlab_access.log <==
125.239.32.82 - - [13/Feb/2025:00:32:25 +0000] "GET /-/error-illustrations/error-500-lg.svg HTTP/2.0" 200 6506 "https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net/developers/import/-/issues" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:134.0) Gecko/20100101 Firefox/134.0" -
Creating an issue via API Query
https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net/api/v4/projects/2/issues?title=goose&description=hello&assignees=89
GitLab logs
==> /var/log/gitlab/postgresql/current <==
2025-02-12_19:44:31.15917 ERROR: duplicate key value violates unique constraint "index_issues_on_namespace_id_iid_unique"
2025-02-12_19:44:31.15921 DETAIL: Key (namespace_id, iid)=(6, 2) already exists.
2025-02-12_19:44:31.15922 STATEMENT: /*application:web,correlation_id:01JKXV222KDSKE3RP1X6W7JF35,endpoint_id:POST /api/:version/projects/:id/issues,db_config_database:gitlabhq_production,db_config_name:main*/ INSERT INTO "issues" ("title", "author_id", "project_id", "created_at", "updated_at", "description", "iid", "title_html", "description_html", "cached_markdown_version", "work_item_type_id", "namespace_id", "correct_work_item_type_id", "lock_version") VALUES ('goose', 1, 2, '2025-02-12 19:44:31.121335', '2025-02-12 19:44:31.121335', 'hello', 2, 'goose', '<p data-sourcepos="1:1-1:5" dir="auto">hello</p>', 2162688, 1, 6, 1, 0) RETURNING "id"
==> /var/log/gitlab/gitlab-rails/api_json.log <==
{"time":"2025-02-12T19:44:31.167Z","severity":"INFO","duration_s":0.25925,"db_duration_s":0.02183,"view_duration_s":0.23742,"status":409,"method":"POST","path":"/api/v4/projects/2/issues","params":[{"key":"title","value":"[FILTERED]"},{"key":"description","value":"[FILTERED]"},{"key":"assignees","value":"89"}],"host":"irisb-latest.env-a72a3647.gcp.gitlabsandbox.net","remote_ip":"125.239.32.82, 125.239.32.82","ua":"PostmanRuntime/7.43.0","route":"/api/:version/projects/:id/issues","user_id":1,"username":"root","token_type":"PersonalAccessToken","token_id":2,"queue_duration_s":0.096487,"redis_calls":28,"redis_duration_s":0.008934,"redis_read_bytes":2905,"redis_write_bytes":1659,"redis_cache_calls":3,"redis_cache_duration_s":0.000639,"redis_cache_read_bytes":2,"redis_cache_write_bytes":222,"redis_db_load_balancing_calls":2,"redis_db_load_balancing_duration_s":0.000549,"redis_db_load_balancing_write_bytes":53,"redis_feature_flag_calls":16,"redis_feature_flag_duration_s":0.004809,"redis_feature_flag_read_bytes":2899,"redis_feature_flag_write_bytes":955,"redis_rate_limiting_calls":4,"redis_rate_limiting_duration_s":0.000889,"redis_rate_limiting_read_bytes":2,"redis_rate_limiting_write_bytes":140,"redis_shared_state_calls":3,"redis_shared_state_duration_s":0.002048,"redis_shared_state_read_bytes":2,"redis_shared_state_write_bytes":289,"db_count":28,"db_write_count":2,"db_cached_count":2,"db_txn_count":0,"db_replica_txn_count":0,"db_primary_txn_count":0,"db_replica_count":0,"db_primary_count":28,"db_replica_write_count":0,"db_primary_write_count":2,"db_replica_cached_count":0,"db_primary_cached_count":2,"db_replica_wal_count":0,"db_primary_wal_count":0,"db_replica_wal_cached_count":0,"db_primary_wal_cached_count":0,"db_replica_txn_max_duration_s":0.0,"db_primary_txn_max_duration_s":0.0,"db_replica_txn_duration_s":0.0,"db_primary_txn_duration_s":0.0,"db_replica_duration_s":0.0,"db_primary_duration_s":0.028,"db_main_txn_count":0,"db_ci_txn_count":0,"db_main_replica_txn_count":0,"db_ci_replica_txn_count":0,"db_main_count":28,"db_ci_count":0,"db_main_replica_count":0,"db_ci_replica_count":0,"db_main_write_count":2,"db_ci_write_count":0,"db_main_replica_write_count":0,"db_ci_replica_write_count":0,"db_main_cached_count":2,"db_ci_cached_count":0,"db_main_replica_cached_count":0,"db_ci_replica_cached_count":0,"db_main_wal_count":0,"db_ci_wal_count":0,"db_main_replica_wal_count":0,"db_ci_replica_wal_count":0,"db_main_wal_cached_count":0,"db_ci_wal_cached_count":0,"db_main_replica_wal_cached_count":0,"db_ci_replica_wal_cached_count":0,"db_main_txn_max_duration_s":0.0,"db_ci_txn_max_duration_s":0.0,"db_main_replica_txn_max_duration_s":0.0,"db_ci_replica_txn_max_duration_s":0.0,"db_main_txn_duration_s":0.0,"db_ci_txn_duration_s":0.0,"db_main_replica_txn_duration_s":0.0,"db_ci_replica_txn_duration_s":0.0,"db_main_duration_s":0.028,"db_ci_duration_s":0.0,"db_main_replica_duration_s":0.0,"db_ci_replica_duration_s":0.0,"cpu_s":0.335249,"mem_objects":52742,"mem_bytes":15242997,"mem_mallocs":15306,"mem_total_bytes":17352677,"pid":39302,"worker_id":"puma_4","rate_limiting_gates":["issues_create"],"exclusive_lock_requested_count":1,"exclusive_lock_wait_duration_s":0,"exclusive_lock_hold_duration_s":0.009724828,"correlation_id":"01JKXV222KDSKE3RP1X6W7JF35","meta.caller_id":"POST /api/:version/projects/:id/issues","meta.remote_ip":"125.239.32.82","meta.feature_category":"team_planning","meta.user":"root","meta.user_id":1,"meta.project":"developers/import","meta.root_namespace":"developers","meta.client_id":"user/1","content_length":"0","request_urgency":"low","target_duration_s":5}
==> /var/log/gitlab/gitlab-workhorse/current <==
{"backend_id":"rails","content_type":"application/json","correlation_id":"01JKXV222KDSKE3RP1X6W7JF35","duration_ms":366,"host":"irisb-latest.env-a72a3647.gcp.gitlabsandbox.net","level":"info","method":"POST","msg":"access","proto":"HTTP/1.1","referrer":"","remote_addr":"125.239.32.82:0","remote_ip":"125.239.32.82","route":"^/api/","route_id":"api","status":409,"system":"http","time":"2025-02-12T19:44:31Z","ttfb_ms":366,"uri":"/api/v4/projects/2/issues?title=[FILTERED]\u0026description=[FILTERED]\u0026assignees=89","user_agent":"PostmanRuntime/7.43.0","written_bytes":30}
==> /var/log/gitlab/nginx/gitlab_access.log <==
125.239.32.82 - - [12/Feb/2025:19:44:31 +0000] "POST /api/v4/projects/2/issues?title=goose&description=hello&assignees=89 HTTP/1.1" 409 30 "" "PostmanRuntime/7.43.0" -
API Response
{
"message": "Duplicated issue"
}
Output of checks
Results of GitLab environment info
Expand for output related to GitLab environment info
sudo gitlab-rake gitlab:env:info System information System: Ubuntu 20.04 Proxy: no Current User: git Using RVM: no Ruby Version: 3.2.5 Gem Version: 3.5.23 Bundler Version:2.5.11 Rake Version: 13.0.6 Redis Version: 7.0.15 Sidekiq Version:7.2.4 Go Version: unknown GitLab information Version: 17.8.1-ee Revision: a303ad659b5 Directory: /opt/gitlab/embedded/service/gitlab-rails DB Adapter: PostgreSQL DB Version: 14.15 URL: https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net HTTP Clone URL: https://irisb-latest.env-a72a3647.gcp.gitlabsandbox.net/some-group/some-project.git SSH Clone URL: git@irisb-latest.env-a72a3647.gcp.gitlabsandbox.net:some-group/some-project.git Elasticsearch: no Geo: no Using LDAP: no Using Omniauth: yes Omniauth Providers: GitLab Shell Version: 14.39.0 Repository storages: - default: unix:/var/opt/gitlab/gitaly/gitaly.socket GitLab Shell path: /opt/gitlab/embedded/service/gitlab-shell Gitaly - default Address: unix:/var/opt/gitlab/gitaly/gitaly.socket - default Version: 17.8.1 - default Git Version: 2.47.0
Results of GitLab application Check
Expand for output related to the GitLab application check
( sudo gitlab-rake gitlab:check SANITIZE=true Checking GitLab subtasks ... Checking GitLab Shell ... GitLab Shell: ... GitLab Shell version \\\\\\\\\\\\\\\>= 14.39.0 ? ... OK (14.39.0) Running /opt/gitlab/embedded/service/gitlab-shell/bin/gitlab-shell-check Internal API available: OK Redis available via internal API: OK gitlab-shell self-check successful Checking GitLab Shell ... Finished Checking Gitaly ... Gitaly: ... default ... OK Checking Gitaly ... Finished Checking Sidekiq ... Sidekiq: ... Running? ... yes Number of Sidekiq processes (cluster/worker) ... 1/1 Checking Sidekiq ... Finished Checking Incoming Email ... Incoming Email: ... Reply by email is disabled in config/gitlab.yml Checking Incoming Email ... Finished Checking LDAP ... LDAP: ... LDAP is disabled in config/gitlab.yml Checking LDAP ... Finished Checking GitLab App ... Database config exists? ... yes Tables are truncated? ... skipped All migrations up? ... yes Database contains orphaned GroupMembers? ... no GitLab config exists? ... yes GitLab config up to date? ... yes Cable config exists? ... yes Resque config exists? ... yes Log directory writable? ... yes Tmp directory writable? ... yes Uploads directory exists? ... yes Uploads directory has correct permissions? ... yes Uploads directory tmp has correct permissions? ... yes Systemd unit files or init script exist? ... skipped (omnibus-gitlab has neither init script nor systemd units) Systemd unit files or init script up-to-date? ... skipped (omnibus-gitlab has neither init script nor systemd units) Projects have namespace: ... 2/1 ... yes 2/2 ... yes 2/3 ... yes Redis version \\\\\\\\\\\\\\\>= 6.2.14? ... yes Ruby version \\\\\\\\\\\\\\\>= 3.0.6 ? ... yes (3.2.5) Git user has default SSH configuration? ... yes Active users: ... 1 Is authorized keys file accessible? ... yes GitLab configured to store new projects in hashed storage? ... yes All projects are in hashed storage? ... yes Elasticsearch version 7.x-8.x or OpenSearch version 1.x ... skipped (Advanced Search is disabled) All migrations must be finished before doing a major upgrade ... skipped (Advanced Search is disabled) Checking GitLab App ... Finished Checking GitLab subtasks ... Finished
Possible fixes
Per @jfarmiloe's testing
I just imported a project with 4 issues and once the import is complete there is no record in internal_ids
for that project/namespace.And then when I create a new issue in the imported project via the UI it looks for an existing row, doesn't find one, and creates a new one:
*application:web,correlation_id:01JKW35S5M4YM2BTRVPWF8K46W,endpoint_id:Projects::IssuesController#create,db_config_database:gitlabhq_production,db_config_name:main*/ UPDATE "internal_ids" SET "last_value" = ("internal_ids"."last_value" + 1) WHERE "internal_ids"."namespace_id" = 191 AND "internal_ids"."usage" = 0 RETURNING "last_value"
LOG: execute <unnamed>: /*application:web,correlation_id:01JKW35S5M4YM2BTRVPWF8K46W,endpoint_id:Projects::IssuesController#create,db_config_database:gitlabhq_production,db_config_name:main*/ SELECT MAX("issues"."iid") FROM "issues" WHERE "issues"."namespace_id" = 191
WHERE indrelid = '"internal_ids"'::regclass
AND t.relname = 'internal_ids'
LOG: execute <unnamed>: /*application:web,correlation_id:01JKW35S5M4YM2BTRVPWF8K46W,endpoint_id:Projects::IssuesController#create,db_config_database:gitlabhq_production,db_config_name:main*/ INSERT INTO "internal_ids" ("project_id","namespace_id","usage","last_value") VALUES (NULL, 191, 0, 5) ON CONFLICT DO NOTHING RETURNING "id"
LOG: execute <unnamed>: /*application:web,correlation_id:01JKW35S5M4YM2BTRVPWF8K46W,endpoint_id:Projects::IssuesController#create,db_config_database:gitlabhq_production,db_config_name:main*/ INSERT INTO "issues" ("title", "author_id", "project_id", "created_at", "updated_at", "description", "iid", "title_html", "description_html", "cached_markdown_version", "work_item_type_id", "namespace_id", "correct_work_item_type_id", "lock_version") VALUES ('test5', 1, 109, '2025-02-12 03:27:52.623865', '2025-02-12 03:27:52.623865', 'test', 5, 'test5', '<p data-sourcepos="1:1-1:4" dir="auto">test</p>', 2162688, 1, 191, 1, 0) RETURNING "id"
The IID generation is handled by this code :
def generate
InternalId.internal_id_transactions_increment(operation: :generate, usage: usage)
next_iid = update_record!(subject, scope, usage, arel_table[:last_value] + 1)
return next_iid if next_iid
create_record!(subject, scope, usage, initial_value(subject, scope) + 1)
rescue RecordAlreadyExists
retry
end
where it tries to increment the existing record and if there isn't one it creates it by querying the existing issue records and setting last_value to the max iid it finds (I think)