Log files getting out of control.

Phil.Bobbett

The log files being generated by ssql source control are filling up the disc on the server it is installed on. I have looked into the log and found the followng error over and over. Any idea what I can do to fix it?

Thanks

Phil

10:21:49.242|Debug |ndardBindingSelector|55 |#55:Resolving binding for active request for #Egz
10:21:49.242|Debug |ndardBindingSelector|55 |#55:1 candidate binding available for service #Egz
10:21:49.242|Debug |ndardBindingSelector|55 |#55:One default binding and 0 conditional bindings match the current context
10:21:49.242|Debug |ndardBindingSelector|55 |#55:No conditional bindings matched, falling back on default binding.
10:21:49.242|Debug |ning.StandardPlanner|55 |#55:Activation plan for type #Egz requested by default self-binding of #Egz (via #oKi)
10:21:49.242|Debug |ning.StandardPlanner|55 |#55:Using already-generated plan from cache
10:21:49.273|Debug |ndardBindingSelector|59 |#59:Resolving binding for active request for #Egz
10:21:49.273|Debug |ndardBindingSelector|59 |#59:1 candidate binding available for service #Egz
10:21:49.273|Debug |ndardBindingSelector|59 |#59:One default binding and 0 conditional bindings match the current context
10:21:49.273|Debug |ndardBindingSelector|59 |#59:No conditional bindings matched, falling back on default binding.
10:21:49.273|Debug |ning.StandardPlanner|59 |#59:Activation plan for type #Egz requested by default self-binding of #Egz (via #oKi)
10:21:49.273|Debug |ning.StandardPlanner|59 |#59:Using already-generated plan from cache
10:21:49.273|Debug |ndardBindingSelector|59 |#59:Resolving binding for active request for #Egz
10:21:49.273|Debug |ndardBindingSelector|59 |#59:1 candidate binding available for service #Egz
10:21:49.273|Debug |ndardBindingSelector|59 |#59:One default binding and 0 conditional bindings match the current context
10:21:49.273|Debug |ndardBindingSelector|59 |#59:No conditional bindings matched, falling back on default binding.
10:21:49.273|Debug |ning.StandardPlanner|59 |#59:Activation plan for type #Egz requested by default self-binding of #Egz (via #oKi)
10:21:49.273|Debug |ning.StandardPlanner|59 |#59:Using already-generated plan from cache
10:21:49.273|Debug |ndardBindingSelector|59 |#59:Resolving binding for active request for #Egz
10:21:49.273|Debug |ndardBindingSelector|59 |#59:1 candidate binding available for service #Egz
10:21:49.273|Debug |ndardBindingSelector|59 |#59:One default binding and 0 conditional bindings match the current context
10:21:49.273|Debug |ndardBindingSelector|59 |#59:No conditional bindings matched, falling back on default binding.
10:21:49.273|Debug |ning.StandardPlanner|59 |#59:Activation plan for type #Egz requested by default self-binding of #Egz (via #oKi)
10:21:49.273|Debug |ning.StandardPlanner|59 |#59:Using already-generated plan from cache
10:21:49.273|Info |Handling.OptionsBase|59 |#59:Constructing options with stack trace:
at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at RedGate.SQLSourceControl.Engine.OptionsHandling.OptionsBase..ctor()
at RedGate.SQLSourceControl.CommonUI.UIOptions..ctor()
at OptionsClassc72a4d116ef143f29ffddcba1775822c..ctor()
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at RedGate.Shared.Utils.IO.Serialization.XMLSerializeFormatter.DeserializeRootObject(XmlReader xmlReader, String name, String typeName)
at RedGate.Shared.Utils.IO.Serialization.XMLSerializeFormatter.DeserializeRootObject(TextReader reader, String name, String typeName)
at RedGate.SQLSourceControl.Engine.OptionsHandling.OptionsBase.#J2c(Type , String )
at RedGate.SQLSourceControl.Engine.OptionsHandling.OptionsBase.#J2c(Type )
at RedGate.SQLSourceControl.Engine.OptionsHandling.OptionsBase.#N2c(Object , FileSystemEventArgs )
at System.IO.FileSystemWatcher.OnChanged(FileSystemEventArgs e)
at System.IO.FileSystemWatcher.NotifyFileSystemEventArgs(Int32 action, String name)
at System.IO.FileSystemWatcher.CompletionStatusChanged(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* overlappedPointer)
at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)

James B

Which version are you running? I believe newer builds reduced the amount of logging information (a lot of the messages you see can safely be ignored)

Phil.Bobbett

Version 3.0.4.24

csmith

Hi

I believe there was a logging bug in that version of the product that we have subsequently fixed. Can you please download the latest version via the Check For Updates option in the SQL Source Control Help menu?

If the problem still occurs, please contact support@red-gate.com and we will do what we can to resolve the issue.

Best regards,
Chris