unable to jump to row 0

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

unable to jump to row 0

Postby sleeper_service » 14 Jan 2016, 04:12

I'm currently running v16.1 (393fc7d)
I've been seeing these in the ttrss error log the last couple weeks:

Code: Select all

pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 857 [Last query: SELECT tag_cache FROM ttrss_user_entries WHERE ref_id = '4428947' AND owner_uid = 2]1. classes/db/pgsql.php(65): pg_fetch_result(Resource id #857, 0, tag_cache)
2. classes/db.php(82): fetch_result(Resource id #857, 0, tag_cache)
3. include/db.php(21): fetch_result(Resource id #857, 0, tag_cache)
4. include/functions2.php(1124): db_fetch_result(Resource id #857, 0, tag_cache)
5. include/rssfuncs.php(708): get_article_tags(4428947, 2)
6. include/rssfuncs.php(209): update_rss_feed(360, 1, )
7. update.php(187): update_daemon_common(50)


it happened once an hour today from around 0800 till around 1500 hours. the result index, and ref_id numbers were different for each logged instance. the feed number (from update_rss_feed) is the same each time, (360) and that comes back to http://io9.com/rss

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: unable to jump to row 0

Postby fox » 14 Jan 2016, 12:11

that's strange. is the article with ref_id = 4428947 actually in ttrss_user_entries?

also: update to c352248

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: unable to jump to row 0

Postby sleeper_service » 14 Jan 2016, 23:21

as of now, it was not. if necessary, i could rollback the db to yesterday to check if it was in there then.

updated.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: unable to jump to row 0

Postby fox » 14 Jan 2016, 23:35

i don't think it's worth it to rollback tbh


Return to “Support”

Who is online

Users browsing this forum: No registered users and 24 guests