Feedreader 3

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...

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

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