Skip to content

Illuminate\Database\UniqueConstraintViolationException: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "dev_events_integration_source_unique" #699

@cronxco-sentry

Description

@cronxco-sentry

Sentry Issue: SPARKAPP-M2

PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "dev_events_integration_source_unique"
DETAIL:  Key (integration_id, source_id)=(fbfdc290-1935-4282-b877-c971db6d56e9, oura_activity_fbfdc290-1935-4282-b877-c971db6d56e9_2026-04-05) already exists.
  File "/app/Jobs/Data/Oura/OuraActivityData.php", line 97, in App\Jobs\Data\Oura\OuraActivityData::createEnhancedActivityEvent
    $event = Event::create([
  File "/app/Jobs/Data/Oura/OuraActivityData.php", line 61, in App\Jobs\Data\Oura\OuraActivityData::process
    $this->createEnhancedActivityEvent($plugin, $item, $existingSourceIds);
  File "/app/Jobs/Base/BaseProcessingJob.php", line 80, in App\Jobs\Base\BaseProcessingJob::handle
    $this->process();
...
(48 additional frame(s) were not displayed)

Illuminate\Database\UniqueConstraintViolationException: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "dev_events_integration_source_unique"
DETAIL:  Key (integration_id, source_id)=(fbfdc290-1935-4282-b877-c971db6d56e9, oura_activity_fbfdc290-1935-4282-b877-c971db6d56e9_2026-04-05) already exists. (Connection: pgsql, SQL: insert into "dev_events" ("source_id", "time", "integration_id", "actor_id", "service", "domain", "action", "value", "value_multiplier", "value_unit", "event_metadata", "target_id", "id", "updated_at", "created_at") values (oura_activity_fbfdc290-1935-4282-b877-c971db6d56e9_2026-04-05, 2026-04-05 00:00:00, fbfdc290-1935-4282-b877-c971db6d56e9, 7f1bd9ca-2340-4bd4-b09b-078022bffe82, oura, health, had_activity_score, 82, 1, percent, {"day":"2026-04-05","steps":6371,"calories_total":0}, 3b99c6dc-acce-4daf-802b-207cada6c291, b3e2a576-63c1-4516-9a40-6d892e2a3bae, 2026-04-06 07:57:56, 2026-04-06 07:57:56))
  File "/app/Jobs/Data/Oura/OuraActivityData.php", line 97, in App\Jobs\Data\Oura\OuraActivityData::createEnhancedActivityEvent
    $event = Event::create([
  File "/app/Jobs/Data/Oura/OuraActivityData.php", line 61, in App\Jobs\Data\Oura\OuraActivityData::process
    $this->createEnhancedActivityEvent($plugin, $item, $existingSourceIds);
  File "/app/Jobs/Base/BaseProcessingJob.php", line 80, in App\Jobs\Base\BaseProcessingJob::handle
    $this->process();
...
(46 additional frame(s) were not displayed)

This issue was automatically created by Sentry via high-priority-issue

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