Tiny Tiny RSS: Community

SQL Key Constraint Violation


#1

PLEASE READ THIS BEFORE POSTING: Read before posting / reporting bugs

Describe the problem you’re having:
Since yesterday there are several unique Key violations from the DB like the following:

|E_USER_NOTICE (1024)|/var/www/html/tt-rss/classes/rssutils.php:893|SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint “ttrss_entries_guid_key” DETAIL: Key (guid)=(SHA1:ad8e2a685050268b7d868480b13b66ae71294f68) already exists.#0 /var/www/html/tt-rss/classes/rssutils.php(893): PDOStatement->execute(Array)
#1 /var/www/html/tt-rss/classes/rssutils.php(190): RSSUtils::update_rss_feed(2, true, false)
#2 /var/www/html/tt-rss/update.php(209): RSSUtils::update_daemon_common(50)
#3 {main}||11:53|

Updated to the latest version and error keeps happening.

Not sure if its a faulty feed or a general problem: imho this could be a concurrency-issue, but im not fluent in php…

If possible include steps to reproduce the problem:

happens sometimes on update feeds

tt-rss version (including git commit id):
v18.12 (856e0c3)

Platform (i.e. Linux distro, PHP, PostgreSQL, etc) versions:
Raspbian Stretch Lite (Nov 2018), PHP 7.0, PostgreSQL 9.6.10, nginx 1.10.3

Please provide any additional information below:


#2

check out this thread: Intermittent PDOException

very likely
you can try doing non-forking updates for a while to see if errors disappear

definitely try non-forking updates


#3

Switching to update.php --daemon rather then update_daemon2.php and keep you posted. But you’re right: forgot I chose the multithreaded update and on a rather weak machine this is extremely likely to be the issue here.