View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000030 | NewsStats | Raw Data Gathering | public | 2011-01-19 22:53 | 2018-01-01 21:33 |
Reporter | thh | Assigned To | thh | ||
Priority | high | Severity | crash | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Projection | none | ETA | none | ||
Product Version | Product Build | ||||
Target Version | 0.01 | Fixed in Version | 0.01 | ||
Summary | 0000030: feedlog.pl will loose database connection permanently when interrupted | ||||
Description | When the mySQL server dies or is restarted, feedlog is * not only unable to INSERT data and * does not buffer it for later, but also * unable to reconnect to the database when it is available again. | ||||
Steps To Reproduce | Restart mysqld. feedlog will continue to log "server has gone away" and not resume work until it is restarted. | ||||
Additional Information | It should at least * log the Message-IDs of all postings it cannot INSERT into the database * reconnect as soon as the server is available again | ||||
Tags | No tags attached. | ||||
Quite high priority (avoid data loss). | |
Fix committed to next branch as 98563c619eeb66fee046c6acb3dfc0f14c442e8d: Refactor database initialisation in feedlog.pl. * Move database initialisation to a separate function. * (Re-)try to connect every five seconds (instead of going into an endless loop) and log successful (re-)connections. * Log postings that are dropped due to database failures to syslog (Message-ID) for recovery. * If the connection to the database is lost, try to recover it (every five seconds) and try again to write the pending data. * Input will be buffered automatically by INN until feedlog is able to process it (see man 5 newsfeeds). Fixes 0000030, 0000031. Signed-off-by: Thomas Hochstein <thh@inter.net> |
|
Mass closign resolved bugs. | |
NewsStats: next 98563c61 2012-10-12 23:27:54 Details Diff |
Refactor database initialisation in feedlog.pl. * Move database initialisation to a separate function. * (Re-)try to connect every five seconds (instead of going into an endless loop) and log successful (re-)connections. * Log postings that are dropped due to database failures to syslog (Message-ID) for recovery. * If the connection to the database is lost, try to recover it (every five seconds) and try again to write the pending data. * Input will be buffered automatically by INN until feedlog is able to process it (see man 5 newsfeeds). Fixes 0000030, 0000031. Signed-off-by: Thomas Hochstein <thh@inter.net> |
Affected Issues 0000030, 0000031 |
|
mod - feedlog.pl | Diff File | ||
mod - doc/TODO | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2011-01-19 22:53 | thh | New Issue | |
2011-01-19 22:54 | thh | Relationship added | child of 0000012 |
2011-01-19 22:54 | thh | Status | new => acknowledged |
2011-01-19 22:56 | thh | Relationship added | related to 0000031 |
2013-08-15 13:31 | thh | Note Added: 0000049 | |
2013-08-15 13:31 | thh | Assigned To | => thh |
2013-08-15 13:31 | thh | Status | acknowledged => assigned |
2013-09-02 06:58 | thh | Changeset attached | => NewsStats next 98563c61 |
2013-09-02 06:58 | thh | Note Added: 0000053 | |
2013-09-02 06:58 | thh | Status | assigned => resolved |
2013-09-02 06:58 | thh | Resolution | open => fixed |
2013-09-02 14:52 | thh | Fixed in Version | => 0.01 |
2018-01-01 21:33 | thh | Status | resolved => closed |
2018-01-01 21:33 | thh | Note Added: 0000073 |