Comment 4 for bug 538443

I think that has fixed it.

After I finally killed the hung process, I saw the following, which probably
is all the known bug, but I'll send it just in case:

net-responsibility-report[15216]: The following exception
(SQLite3::BusyException) is caused by a known bug. If you know how to fix
it, do tell! Otherwise, you can safely ignore it (I hope).
net-responsibility-report[15216]: /usr/lib/ruby/1.8/sqlite3/errors.rb:94:in
'check': Unable to close due to unfinalised statements
(SQLite3::BusyException)
net-responsibility-report[15216]: => from
/usr/lib/ruby/1.8/sqlite3/database.rb:154:in 'close'
net-responsibility-report[15216]: => from
/usr/local/bin/net-responsibility-report:114:in 'initialize'
net-responsibility-report[15216]: => from
/usr/local/bin/net-responsibility-report:137:in 'new'
net-responsibility-report[15216]: => from
/usr/local/bin/net-responsibility-report:137
net-responsibility-report[15216]: Time for this report: 22964.071385
/usr/lib/ruby/1.8/sqlite3/statement.rb:252:in `must_be_open!': cannot use a
closed statement (SQLite3::Exception)
        from /usr/lib/ruby/1.8/sqlite3/statement.rb:77:in `close'
        from /usr/lib/ruby/1.8/sqlite3/resultset.rb:170:in `close'
        from /usr/share/net-responsibility/lib/modules/db.rb:330:in
`delete_log_entries'
        from /usr/share/net-responsibility/lib/modules/db.rb:161:in
`rotate_log'
        from /usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `each_slice'
        from /usr/share/net-responsibility/lib/modules/db.rb:161:in `each'
        from /usr/share/net-responsibility/lib/modules/db.rb:161:in
`each_slice'
        from /usr/share/net-responsibility/lib/modules/db.rb:161:in
`rotate_log'
        from /usr/share/net-responsibility/lib/modules/db.rb:158:in `each'
        from /usr/share/net-responsibility/lib/modules/db.rb:158:in
`rotate_log'
        from /usr/local/bin/net-responsibility-report:109:in `initialize'
        from /usr/local/bin/net-responsibility-report:137:in `new'
        from /usr/local/bin/net-responsibility-report:137

Thanks for your help.

Martin

On 16 March 2010 18:42, Roggan <email address hidden> wrote:

> Your right, that's the problem!
> Rotating log actually means clearing history.
>
> Try to rename /var/log/net-responsibility.log to
> /var/log/net-responsibility.log.bak or something so you can change back
> later. Then restart net-responsibility.
> See if the problem remains, in that case we have to look closer to it.
>
> --
> Log does not clear
> https://bugs.launchpad.net/bugs/538443
> You received this bug notification because you are a direct subscriber
> of the bug.
>