Log does not clear

[MQ]

Net responsibility 2.0a1
Ubuntu 8.04 (I think)

Reports are being sent which contain details of all usage in the last 2.5 months or more. I expect the log to clear/reset after each report so that only the usage since the last report is contained in each report.

[Roggan (roggan87)]

You're right, the log should be cleared every time a report is sent out.
Have you tried to send manual reports?

[MQ (martinquested)]

Hi,

after sending the email, the process hangs at:

net-responsibility-report[15216]: Rotating log

Think this is the problem!

M

On 16 March 2010 05:50, Roggan <email address hidden> wrote:

> You're right, the log should be cleared every time a report is sent out.
> Have you tried to send manual reports?
>
> --
> Log does not clear
> https://bugs.launchpad.net/bugs/538443
> You received this bug notification because you are a direct subscriber
> of the bug.
>

[Roggan (roggan87)]

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.

[MQ (martinquested)]

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