harbor/harbor
harbor/harbor
Watch
2
0
Fork
You've already forked harbor
 0
Code Issues 125 Pull requests 7 Projects Releases 24 Packages 9 Wiki Activity Actions

Query error in moderation service #1856

New issue
Closed
opened 2026-10-13 08:41:10 +00:00 by thomas · 1 comment
thomas commented 2026-10-13 08:41:10 +00:00
Member
Copy link

Summary

Error: create_pending error, Query Error: error returned from database: duplicate key value violates unique constraint "processed_content_pkey" at line 666.

Steps to reproduce

Platform information

What is the current bug behavior?

What is the expected correct behavior?

Relevant logs and/or screenshots

Possible fixes

<!--- Before opening this issue, please search existing issues with the "Type/Bug" label to make sure it isn't already reported. ---> ### Summary Error: `create_pending error`, ` Query Error: error returned from database: duplicate key value violates unique constraint "processed_content_pkey" at line 666`. ### Steps to reproduce <!--- List the exact steps to trigger the bug, as a numbered list. Mention whether it happens every time or only sometimes. ---> ### Platform information <!--- Tell us where you saw this: web or native app, browser and version, device and OS, app version, and screen size if it looks layout-related. ---> ### What is the current _bug_ behavior? <!--- Describe what actually happens. ---> ### What is the expected _correct_ behavior? <!--- Describe what you expected to happen instead. ---> ### Relevant logs and/or screenshots <!--- Add screenshots and paste any console or server logs. Wrap logs in code blocks (```) so they stay readable. ---> ### Possible fixes <!--- Optional: if you have a hunch, link to the line of code that might be responsible. --->
thomas commented 2026-10-13 08:41:21 +00:00
Author
Member
Copy link

Seems like we're missing an on conflict handler.

Seems like we're missing an on conflict handler.
thomas self-assigned this 2026-10-13 09:03:04 +00:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
develop
bh/login-manager
dp/e2e-staging-failure-nicer-reporting
dp/mention-colors
dp/mention-protected-ranges
dp/drop-dedicated-alias-mentions
jy/pairing-service-test
jy/grayjay-emoji-script
dp/twemoji-font-outside-text
thomas/231-validate-ffi
jy/identity_and_pairing_utilities
bh/inject-latest-only
dp/platform-identitfiers
thomas/disable-sqlx-statement-cache
ps/profile-identity-display
thomas/231-doc-limits
dp/fix-emojis
dp/app-links
dp/mentions-denote
thomas/231-put_events-validation
thomas/remove-double-limit-incr
bh/testing-ci
thomas/put_event-reject-same-key-different-content
bh/base64
mh/fix-ci-3
renovate/html-get-2.x-lockfile
renovate/androidx.test
renovate/noble-hashes-2.x-lockfile
renovate/aws-sdk-rust-monorepo
renovate/aquasec-trivy-0.x
renovate/vitest-monorepo
renovate/rust-wasm-bindgen-monorepo
renovate/react-native-ecosystem-modules
renovate/expo-packages
jy/ktlint
mh/docker-ci-speed
dp/fix-suggest-follow-pagination
mh/threadlist-bottom-scroll
jy/labels-on-search
mh/github-ci
mh/shared-cache
ps/server-level-bans
tlg/secure-key-storage
ps/link-previews-deployment-update
jy/web-flashlist
mh/eas-cache
mh/local-apks
mh/moderation-svc
tlg/server-debug-ui
tlg/streamline-onboarding
tlg/web-cf-pages
tlg/stabilize-develop
mh/expo-ci
mh/server-img
tlg/web-shell
kotlin-wrapper
mh/clean
tlg/clean-staging
v2.21.0
v2.19.0
v2.20.0
v2.18.0
v2.17.0
v2.16.0
v2.15.0
v2.14.0
v2.13.0
v2.12.0
v2.11.0
v2.10.0
v2.0.9
v2.0.8
v2.0.7
v2.0.6
v2.0.5
v2.0.4
v2.0.3
v2.0.2
v2.0.1
v2.0.0
v2.0.0-alpha.3
v1.9.9
v2.0.0-alpha.2
rs-sdk-0.0.2
rs-sdk-0.0.1
js-sdk-0.0.1
sdk-0.0.1
builder-tlg-tests
polycentric-core-v0.2.1
polycentric-core-v0.2.0
Labels
Clear labels   
Ad-hoc
Issues added after a sprint has started

  
Bug
cannot reproduce

  
Module
Core
 Work that touches the shared foundation of the product rather than a single feature area

  
Module
Moderation
 Work related to reviewing, filtering, or acting on user-generated content and policy enforcement

  
Module
Notifications

  
Module
Posts

  
Module
Reactions

  
Module
Verifications

  
PR / Build App / Android APK
Builds a staging android apk

  
Platform / Android

   
Platform / Mobile

   
Platform / Services

   
Platform / Web

   
Platform / iOS
  
Priority
1
 High priority issue that should be addressed as soon as possible

  
Priority
2
 Should be addressed in the few releases

  
Priority
3
 We want to address but there are higher priorities

  
Priority
4
 This probably won't be addressed anytime soon

  
Retro
Overestimated
 The task was simpler or faster than anticipated (e.g., a 5-point issue felt like a 1- or 2-pointer).

  
Retro
Spot-On
 The issue took roughly as much effort as the assigned weight suggested.

  
Retro
Underestimated
 The task was significantly harder or took longer than the assigned weight (e.g., a 2-point issue behaved like a 5-pointer).

  
Status/Backlog
  
Status
Blocked
 Work cannot progress until something outside this issue is resolved

  
Status
In Progress
 Work has started and is actively being worked on

  
Status
Review
 Implementation is complete and the work is waiting for review

  
Type
Bug
 Something is broken or behaving incorrectly compared with expected behaviour

  
Type
Chore
 Maintenance and routine work that isn’t a new feature or a bug fix

  
Type
Enhancement
 Improvement to existing functionality without introducing an entirely new feature or fixing a defect

  
Type/Epic
A large body of work that groups related issues rather than a single implementable change

  
Type
Feature
 New user-facing functionality or a meaningful expansion of existing behaviour

  
Weight
1
 Very small effort. A quick, well-understood change that can usually be finished in a short sitting

  
Weight
13
 Epic-scale effort. Too large to treat as a normal implementation ticket without breaking it down

  
Weight
2
 Small effort. Straightforward work that takes a bit more than a tiny tweak, but is still well understood

  
Weight
3
 Medium effort. Meaningful work with a clear goal, but more than a small, contained change

  
Weight
5
 Large effort. Significant work with real complexity, coordination, or surface area

  
Weight
8
 Extra-large effort. Complex work with significant scope, uncertainty, or coordination

  
ui
No labels
Ad-hoc
Bug
cannot reproduce
Module
Core
Module
Moderation
Module
Notifications
Module
Posts
Module
Reactions
Module
Verifications
PR / Build App / Android APK
Platform / Android
Platform / Mobile
Platform / Services
Platform / Web
Platform / iOS
Priority
1
Priority
2
Priority
3
Priority
4
Retro
Overestimated
Retro
Spot-On
Retro
Underestimated
Status/Backlog
Status
Blocked
Status
In Progress
Status
Review
Type
Bug
Type
Chore
Type
Enhancement
Type/Epic
Type
Feature
Weight
1
Weight
13
Weight
2
Weight
3
Weight
5
Weight
8
ui
Milestone
Clear milestone
No items
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
thomas
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
harbor/harbor#1856
No description provided.