relatively new errors.

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

relatively new errors.

Postby sleeper_service » 15 May 2013, 10:51

I've been seeing a bunch of errors like this in the last few days. I normally do a git pull every day or two.

Code: Select all

E_USER_ERROR (256)   classes/db/mysqli.php:30   Query DELETE FROM ttrss_user_entries USING ttrss_user_entries, ttrss_entries WHERE ttrss_entries.id = ref_id AND marked = false AND feed_id = '251' AND ttrss_entries.date_updated < DATE_SUB(NOW(), INTERVAL 60 DAY) failed: Deadlock found when trying to get lock; try restarting transaction      May 14, 17:42
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query DELETE FROM ttrss_user_entries USING ttrss_user_entries, ttrss_entries WHERE ttrss_entries.id = ref_id AND marked = false AND feed_id = '72' AND ttrss_entries.date_updated < DATE_SUB(NOW(), INTERVAL 60 DAY) failed: Deadlock found when trying to get lock; try restarting transaction      May 14, 17:42
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','science', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','science writing', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','work', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','the inner swine-dog', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','procrastination', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','post', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','goals', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   Query INSERT INTO ttrss_tags (owner_uid,tag_name,post_int_id) VALUES ('2','awards', '0') failed: Cannot add or update a child row: a foreign key constraint fails (`ttrss`.`ttrss_tags`, CONSTRAINT `ttrss_tags_ibfk_1` FOREIGN KEY (`post_int_id`) REFERENCES `ttrss_user_entries` (`int_id`) ON DELETE CASCADE)      May 14, 13:25
E_USER_ERROR (256)   classes/db/mysqli.php:30   


this isn't all, just a sampling.

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

Re: relatively new errors.

Postby fox » 15 May 2013, 10:58


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

Re: relatively new errors.

Postby sleeper_service » 15 May 2013, 12:00

Server version: 5.1.37 Source distribution

is there anything I can provide that might help?

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

Re: relatively new errors.

Postby fox » 15 May 2013, 12:09

I dunno why this happens (never seen it here), so unfortunately no idea. This could be caused if daemon screws up and tries to update same feed concurrently.

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

Re: relatively new errors.

Postby sleeper_service » 15 May 2013, 12:27

I've been using update_daemon2 --tasks=4, I'll try the plain update.php and see if I see anymore errors, and report back.


Return to “Support”

Who is online

Users browsing this forum: No registered users and 9 guests