Skip to content

Issues created while a project being imported break issue creation after

Update

Will be fixed with Allocate IIDs on importers (&16896).

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

  1. Start importing a project with 2 or more existing issues using GitLab export
  2. Immediately after starting the import, create an issue via the API
  3. Wait for the import to complete
  4. Try to create another issue via API or UI

Results:

  1. 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.
  2. 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.

  1. Get the issue statistics of the project GET /projects/:id/issues_statistics
  2. Take note of the count for all issues
  3. Create an issue while specifying an iid value of the all count + 1 POST /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 the internal_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

Screenshot 2025-02-13 at 13.34.36.png

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: [email protected]: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

https://gitlab.slack.com/archives/C03UW0HPBGD/p1739334558106379?thread_ts=1739320470.409109&cid=C03UW0HPBGD

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)

Edited by Magdalena Frankiewicz
OSZAR »