Feedreader.com - Errors while closing Feedreader... - Comments

Those are not critical

ingmar — Thu, 21 Feb 2008 16:27:25 +0200

Those are not critical errors, create index errors are for notice. Those indexes have been created.

Deadlock found when trying to get lock; try restarting transaction insert into buffer. Those errors are also not critical, used for managing archive size. If not success in first time, next time will be this job done.
MYSQL has temp. tables, but there are still bugs, so we must use permanent buffer table. You can increase lock times in mysql my.ini innodb_lock_wait_timeout=95

If you have in you log errors like "Data provider returned E_FAIL" or some Access violations, then we have a problem.

Also for information, this version on MYSQL FR performs now "connection pings", so that mysql doesn't drop connections that are in idle.

Ingmar

------
FR dev

Should I post that stuff

premois — Thu, 21 Feb 2008 16:12:04 +0200

Should I post that stuff here?

21.02.2008 15:00:30: addr (005214DB) thrd: 2100 --- QRY OBJ 00000E4AEC4(THRD )2100[CONN OBJ 00000DFA2C0] # (-2147217900) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Can't DROP 'IDX_Feeds2OpmlMapping_1'; check that column/key exists DROP INDEX IDX_Feeds2OpmlMapping_1 ON Feeds2OpmlMapping # obj-state:stateActive
21.02.2008 15:00:31: addr (005214DB) thrd: 2100 --- QRY OBJ 00000E4AEC4(THRD )2100[CONN OBJ 00000DFA2C0] # (-2147217900) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Can't DROP 'IDX_Feeds2OpmlMapping_2'; check that column/key exists DROP INDEX IDX_Feeds2OpmlMapping_2 ON Feeds2OpmlMapping # obj-state:stateActive
21.02.2008 15:01:42: addr (005214DB) thrd: 2100 --- QRY OBJ 00000E4AEC4(THRD )2100[CONN OBJ 00000DFA2C0] # (-2147467259) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Duplicate key name 'IDX_Articles_feed_id' CREATE INDEX IDX_Articles_feed_id ON articles(feed_id) # obj-state:stateActive
21.02.2008 15:02:23: addr (0064AF3C) thrd: 6956 (processFeedData) X# Can't add/update feed. X
21.02.2008 15:02:30: addr (005214DB) thrd: 1948 --- QRY OBJ 00000E02EC4(THRD )1948[CONN OBJ 00000DFFF3C] # (-2147467259) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Deadlock found when trying to get lock; try restarting transaction insert into buffer(itemid_,type_,uniqId_)values(358603,1,99581758) # X
21.02.2008 15:05:10: addr (005214DB) thrd: 1744 --- QRY OBJ 00000E007E4(THRD )1744[CONN OBJ 00000DFFB9C] # (-2147467259) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Deadlock found when trying to get lock; try restarting transaction insert into buffer(itemid_,type_,uniqId_)values(455285,1,99733207) # X
21.02.2008 15:05:21: addr (005214DB) thrd: 7936 --- QRY OBJ 00000E01C10(THRD )7936[CONN OBJ 00000DFFD48] # (-2147467259) [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]Deadlock found when trying to get lock; try restarting transaction insert into buffer(itemid_,type_,uniqId_)values(474653,1,99744251) # X

Oh great! Didn't see it

premois — Thu, 21 Feb 2008 15:45:55 +0200

Oh great! Didn't see it yesterday but I'll try it now... can you tell my why my last message was filtered as spam here? I wanted to know if the order in which the filter words are has any influence on fetching speed...

Have you tried latest

ingmar — Thu, 21 Feb 2008 13:29:58 +0200

Have you tried latest release 2, with newest mysql odbc drivers.

Now FR creates in run directory file newsbrainErrors.txt, more like debug information.

Ingmar
------
FR dev

Errors while closing Feedreader...

premois — Wed, 20 Feb 2008 13:31:52 +0200

http://img175.imageshack.us/img175/4003/423525gj6.jpg
It's maybe the third time in 2 days that I got this kind of error. I think it started after I removed some old and added some new feeds.