- Issue created by @joelpittet
- 🇨🇦Canada joelpittet Vancouver
More context: this is stored in our private directory which is mounted NFS, outside the webroot and this is only happening on 1 or 2 feeds at the moment. The other feeds seem to be fine.
And it seems to happen on cron every hour after this error
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9-141838' for key 'feeds_clean_list.PRIMARY': INSERT INTO "feeds_clean_list" ("feed_id", "entity_id") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1), (:db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 9 [:db_insert_placeholder_1] => 141838 [:db_insert_placeholder_2] => 9 [:db_insert_placeholder_3] => 141914 )
The feeds are triggered every minute, though maybe the solution is to stop that...
- 🇳🇱Netherlands megachriz
It sounds like this could be related to or a duplicate of ✨ Add support for remote file systems for http downloaded data Active .
The duplicate entry issue (for the feeds_clean_list table) could be a completely different issue, however.
- 🇨🇦Canada joelpittet Vancouver
Thanks @megachriz, I was going to post there (I linked it as a parent issue) but I wasn't quite sure if it's related. The feeds_clean_list seems to trigger this issue in my case because it always starts fine. I unlock the feed, it seems to work for a bit, then starts with that error, then later this tempnam() keeps happening.
I feel like I am missing something in this and started a new issue as to not conflate the issues (yet) until I know for sure.
- 🇳🇱Netherlands megachriz
Alright, good idea to have this issue separate for now :)
- Status changed to Closed: cannot reproduce
2 months ago 12:16am 10 February 2025 - 🇨🇦Canada joelpittet Vancouver
This was terribly tricky to reproduce so I will close for now.