subsonic.log in the "db" directory

General discussions.

Moderator: moderators

subsonic.log in the "db" directory

Postby bushman4 » Mon Feb 28, 2011 4:17 pm

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
User avatar
bushman4
 
Posts: 867
Joined: Thu Dec 02, 2010 1:47 pm
Location: Massachusetts, USA

Postby 3R3 » Sat Mar 05, 2011 10:23 am

Wow! Just checked and mine is 93mb big o.O. I'd like to know if someone succeeded in turning that noise down too.
User avatar
3R3
 
Posts: 332
Joined: Mon May 04, 2009 2:09 pm
Location: Germany

Postby bushman4 » Sat Mar 05, 2011 3:47 pm

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
User avatar
bushman4
 
Posts: 867
Joined: Thu Dec 02, 2010 1:47 pm
Location: Massachusetts, USA

Postby 3R3 » Sat Mar 05, 2011 6:22 pm

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?
Last edited by 3R3 on Tue Mar 08, 2011 2:54 am, edited 1 time in total.
User avatar
3R3
 
Posts: 332
Joined: Mon May 04, 2009 2:09 pm
Location: Germany

Postby bushman4 » Mon Mar 07, 2011 3:40 pm

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
User avatar
bushman4
 
Posts: 867
Joined: Thu Dec 02, 2010 1:47 pm
Location: Massachusetts, USA


Return to General

Who is online

Users browsing this forum: No registered users and 8 guests