subsonic.log in the "db" directory

[bushman4]

I have a question...

Does anyone know how to turn down the database command logging level?

I have a file in the "db" subdirectory of my subsonic.home directory called "subsonic.log" which is very different than the standard log file that you would find in the subsonic.home directory. It contains all of the database commands issued to the database apparantly, which would normally be a pretty cool thing.

But every two seconds or so three more lines are added to it, and this is the majority of the file (with different connection numbers):

Code: Select all

/*C2312569*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C2312570*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT

This file has grown to over 130 mb, and I would like to limit what is logged there. I don't mind the rest of the database commands logged there (like when I create a user or comment on a song or something) but these periodic connect/diconnect messages are a bit much.

Any way to tweak what is logged there?

Thanks,

Glenn

[3R3]

Wow! Just checked and mine is 93mb big o.O. I'd like to know if someone succeeded in turning that noise down too.

[bushman4]

A service restart clears the file, but I have not seen a way to turn down the logging.

I can schedule regular service restarts, but that is just "hokey" in my opinion... I'll do it, but I'd prefer not to.

Glenn

[3R3]

So that would mean that subsonic cannot by design run on a finite space hdd for extended periods of time (and high traffic/db load etc).
This is surprising news!

edit: just to be constructive too, I think the best way to make this optional is to make it a switch in the startup script for java, just make it a commented out parameter and point it out in a readme or in the install notes under tips and tricks or such. But can anyone tell me why one would need a cleartext log of every DB transaction? for reconstruction of the db?

[bushman4]

I tried to replace the file while subsonic is running, or to clear it, but Subsonic never releases the file from use while the service is running.

But yes, anyone running subsonic in a hosted environment, keep an eye on this file size!

Glenn