View Issue Details

IDProjectCategoryView StatusLast Update
0000030NewsStatsRaw Data Gatheringpublic2018-01-01 21:33
ReporterthhAssigned Tothh 
PriorityhighSeveritycrashReproducibilityalways
Status closedResolutionfixed 
ProjectionnoneETAnone 
Product VersionProduct Build 
Target Version0.01Fixed in Version0.01 
Summary0000030: feedlog.pl will loose database connection permanently when interrupted
DescriptionWhen 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 ReproduceRestart mysqld.

feedlog will continue to log "server has gone away" and not resume work until it is restarted.
Additional InformationIt 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
TagsNo tags attached.

Relationships

related to 0000031 closedthh feedlog.pl should be able to buffer output 
child of 0000012 acknowledged Enhance input validation and error handling. 

Activities

thh

thh

2013-08-15 13:31

administrator   ~0000049

Quite high priority (avoid data loss).
thh

thh

2013-09-02 06:58

administrator   ~0000053

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

thh

2018-01-01 21:33

administrator   ~0000073

Mass closign resolved bugs.

Related Changesets

NewsStats: next 98563c61

2012-10-12 23:27:54

thh

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

Issue History

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