Search found 70 matches

by cqrt
21 May 2013, 20:37
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Still searching and reading - even though I mentioned above: date_updated doesn't exist in ttrss_user_entries... it is in ttrss_entries... I think this is what is causing the error... and you can't simply change the FROM statement cause int_id doesn't exist in ttrss_entries either... Don't think th...
by cqrt
21 May 2013, 11:13
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Yep, and as it turns out, you're not crazy. I just discovered my indexer process was not running and after starting it up, I have your exact error message in my pgsql log.
by cqrt
21 May 2013, 10:27
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Think I found the issue, I updated a post above that had the display of ttrss_user_entries... date_updated doesn't exist in ttrss_user_entries... it is in ttrss_entries... I think this is what is causing the error... and you can't simply change the FROM statement cause int_id doesn't exist in ttrss...
by cqrt
21 May 2013, 10:24
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

I've gone back through the current postgres log file and also the last rotation (19th) and that error doesn't show up. I certainly have many errors (below) but they all relate to my issue above ^^ and ever since I corrected the constraints foreign key, no errors. 2013-05-21 13:17:44 NZST ERROR: upd...
by cqrt
21 May 2013, 10:00
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

I've gone back through the current postgres log file and also the last rotation (19th) and that error doesn't show up. I certainly have many errors (below) but they all relate to my issue above ^^ and ever since I corrected the constraints foreign key, no errors. 2013-05-21 13:17:44 NZST ERROR: upd...
by cqrt
21 May 2013, 09:57
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Ok, so make sure your data source in sphinx.conf is set to 'pgsql' and all the relevant pgsql server settings are correct. See if that helps.
by cqrt
21 May 2013, 07:52
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Hmm. Do you have Sphinx Search enabled by chance?
by cqrt
21 May 2013, 07:44
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

su into a user with db privileges and post the output of:

> psql your_database_name
> \d ttrss_entries

Print the output here.
by cqrt
21 May 2013, 07:21
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

I've searched all objects in postgres from the schemas all the way down to functions and '@last_reindex' doesn't show up anywhere.
by cqrt
21 May 2013, 07:08
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

I've gone back through the current postgres log file and also the last rotation (19th) and that error doesn't show up. I certainly have many errors (below) but they all relate to my issue above ^^ and ever since I corrected the constraints foreign key, no errors. 2013-05-21 13:17:44 NZST ERROR: upda...
by cqrt
21 May 2013, 05:53
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Update: I should have checked my update daemon log. No cleaning has occurred since my migration from mysql. I rebuilt the indexes for good measure and examined the ttrss_enclosure, ttrss_entries and ttrss_user_entries tables. The ttrss_enclosures foreign key constraint (ttrss_enclosures_post_id_fkey...
by cqrt
21 May 2013, 04:52
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Although the migration to postgres completed successfully and I've noticed no ill effects I do have several worrisome errors in the system log. E_WARNING (2) classes/db/pgsql.php:66 pg_affected_rows() expects parameter 1 to be resource, boolean gien E_USER_ERROR (256) classes/db/pgsql.php:43 Query D...
by cqrt
20 May 2013, 05:24
Forum: Support
Topic: MySQL issues: Lock wait timeout exceeded;
Replies: 53
Views: 31221

Re: MySQL issues: Lock wait timeout exceeded;

Fox, could I assume you developed tt-rss exclusively using postgresql from the word go? You would know better than any why tt-rss performs well on postgresql. My understanding is the postgresql excels when dealing with complicated data and high transactional writes and is VERY good at optimization. ...

Go to advanced search