Skip to content

[Airbrake] [Production] PG::NotNullViolation: ERROR: null value in column "id" violates not-null constraint DETAIL: Failing row contains (null, null, https://dcte.ade.arkansas.gov/Page/Pathways, Introductory college-level course. Cultivate understand... #96

@edgarf

Description

@edgarf

Airbrake error: #2102
Airbrake project: OCN RB

Error type: ActiveRecord::NotNullViolation
Error message: PG::NotNullViolation: ERROR: null value in column "id" violates not-null constraint DETAIL: Failing row contains (null, null, https://dcte.ade.arkansas.gov/Page/Pathways, Introductory college-level course. Cultivate understanding of co..., https://credentialengineregistry.org/resources/ce-7cf8323a-c79b-..., AP Computer Science A, LearningOpportunity, 2025-11-05 16:06:58.29244, 2025-11-05 16:06:58.29244).
Where: sidekiq#ActiveJob::QueueAdapters::SidekiqAdapter::JobWrapper
Occurred at: Nov 05, 2025 16:06:58 UTC
First seen at: Nov 05, 2025 16:06:58 UTC
Occurrences: 0 (0 since last deploy on <no information>)
Severity: error

URL: <no information>
File: /GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb

Backtrace:

/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in exec
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in perform_query
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:556:in block (2 levels) in raw_execute
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:1011:in block in with_raw_connection
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/concurrency/null_lock.rb:9:in synchronize
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:983:in with_raw_connection
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:555:in block in raw_execute
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/notifications/instrumenter.rb:58:in instrument
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:1129:in log
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:554:in raw_execute
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:591:in internal_execute
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:547:in internal_exec_query
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:693:in select
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:73:in select_all
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:248:in block in select_all
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:286:in block (2 levels) in cache_sql
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:80:in compute_if_absent
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:284:in block in cache_sql
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/concurrency/null_lock.rb:9:in synchronize
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:283:in cache_sql
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/query_cache.rb:248:in select_all
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in select_rows
/GEM_ROOT/gems/activerecord-8.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:96:in select_values
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/adapters/postgresql_adapter.rb:33:in insert_many
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:835:in block in import_without_validations_or_callbacks
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:831:in each
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:831:in each_slice
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:831:in import_without_validations_or_callbacks
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:771:in import_with_validations
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:702:in import_helper
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:536:in bulk_import
/GEM_ROOT/gems/activerecord-import-2.0.0/lib/activerecord-import/import.rb:551:in bulk_import!
/PROJECT_ROOT/app/services/node_directory_entry_sync.rb:182:in update_contextualizing_objects!
/PROJECT_ROOT/app/services/node_directory_entry_sync.rb:16:in sync!
/PROJECT_ROOT/app/jobs/node_directory_entry_sync_job.rb:13:in perform
/GEM_ROOT/gems/activejob-8.0.0/lib/active_job/execution.rb:68:in block in _perform_job
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/callbacks.rb:120:in block in run_callbacks
/GEM_ROOT/gems/airbrake-13.0.4/lib/airbrake/rails/active_job.rb:22:in block in perform
/GEM_ROOT/gems/airbrake-ruby-6.2.2/lib/airbrake-ruby/benchmark.rb:13:in measure
/GEM_ROOT/gems/airbrake-13.0.4/lib/airbrake/rails/active_job.rb:21:in perform
/GEM_ROOT/gems/airbrake-13.0.4/lib/airbrake/rails/active_job.rb:45:in block (2 levels) in <module:ActiveJob>
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/callbacks.rb:129:in instance_exec
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/callbacks.rb:129:in block in run_callbacks
/GEM_ROOT/gems/i18n-1.14.6/lib/i18n.rb:353:in with_locale
/GEM_ROOT/gems/activejob-8.0.0/lib/active_job/translation.rb:9:in block (2 levels) in <module:Translation>
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/callbacks.rb:129:in instance_exec
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/callbacks.rb:129:in block in run_callbacks
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/core_ext/time/zones.rb:65:in use_zone
/GEM_ROOT/gems/activejob-8.0.0/lib/active_job/timezones.rb:9:in block (2 levels) in <module:Timezones>
/GEM_ROOT/gems/activesupport-8.0.0/lib/active_support/callbacks.rb:129:in instance_exec
...
Caused by PG::NotNullViolation: ERROR:  null value in column "id" violates not-null constraint
DETAIL:  Failing row contains (null, null, https://dcte.ade.arkansas.gov/Page/Pathways, Introductory college-level course. Cultivate understanding of co..., https://credentialengineregistry.org/resources/ce-7cf8323a-c79b-..., AP Computer Science A, LearningOpportunity, 2025-11-05 16:06:58.29244, 2025-11-05 16:06:58.29244).

Visit Airbrake error to view the full backtrace.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions