WCF Service Not releasing file

Pho3nix · Jul 13, 2015

Hi all.

Having an issue with a service.
File isn't being released by some "process" in the background and was hoping someone could advise how to eliviate the issue.

Background :

WCF is being used to log errors into a DB and txt file. ~> Works fine.
Email is sent to Support Team with txt file attached for quick debugging ~> not working.

Any assistance would be appreciated.

Hamster · Jul 13, 2015

How is it writing to the log file? Stream?

prod · Jul 13, 2015

Make sure the log is written in a using statement I guess?

Nether · Jul 13, 2015

Do you close the filesteam object once its done writing?
https://msdn.microsoft.com/en-us/library/aa328800(v=vs.71).aspx

Kilgore_Trout_Redux · Jul 14, 2015

Show us the code. It sounds like you aren't releasing a resource.

Pho3nix · Jul 14, 2015

Using this :https://logging.apache.org/log4net/release/sdk/log4net.Appender.FileAppender.html

I was being slightly lazy

Think I might have found issue at hand.
Working around this.

Side question though, how are you guys logging issues into a DB and text file?

Pho3nix · Jul 14, 2015

Code that was written :

Code:

private void LogMessageToFile(string filePath, string message)
        {
            // Ensure the directory exists.
            if (!Directory.Exists(Path.GetDirectoryName(filePath)))
            {
                Directory.CreateDirectory(Path.GetDirectoryName(filePath));
            }

            StreamWriter writer = null;

            // Ensure the file exists.
            if (!File.Exists(filePath))
            {
                writer = File.CreateText(filePath);

                writer.Close();
                writer.Dispose();
            }

            lock (this)
            {
                File.AppendAllLines(filePath, new List<string> { message, Environment.NewLine });
            }

        }

Hamster · Jul 14, 2015

Pho3nix said:
Using this :https://logging.apache.org/log4net/release/sdk/log4net.Appender.FileAppender.html

I was being slightly lazy Think I might have found issue at hand.
Working around this.

Side question though, how are you guys logging issues into a DB and text file?

With log4net - configure the FileAppender and DbAppender

Code:

<?xml version="1.0" encoding="utf-8" ?>
<log4net>
    <appender name="FileAppender" type="log4net.Appender.RollingFileAppender">
        ...
    </appender>

    <appender name="DbAppender" type="log4net.Appender.AdoNetAppender">
    ...
    </appender>

    <root>
        <level value="INFO" />
        <appender-ref ref="FileAppender" />
        <appender-ref ref="DbAppender" />
    </root>
</log4net>

Bighit · Jul 14, 2015

What Hamster said.

shauntir · Jul 14, 2015

Yep, no need to write your own method since most logging libraries should have the ability to configure targets.

You can also look at NLog and Serilog. Highly recommend serilog.

Pho3nix · Jul 14, 2015

Just checked. That is also being done.
Below is for the file :

Code:

<appender name="RollingFileErrorAppender" type="log4net.Appender.RollingFileAppender">
            <file value="File" />
            <appendToFile value="true" />
            <rollingStyle value="Size" />
            <maxSizeRollBackups value="5" />
            <maximumFileSize value="10MB" />
            <staticLogFileName value="true" />
            <layout type="log4net.Layout.PatternLayout">
                <conversionPattern value="%date - %logger - %message%newline" />
            </layout>
            <filter type="log4net.Filter.LevelMatchFilter">
                <levelToMatch value="ERROR"/>
            </filter>
            <filter type="log4net.Filter.DenyAllFilter" />
        </appender>

DB :

Code:

 <appender name="DatabaseAppender" type="log4net.Appender.AdoNetAppender">
            <connectionString value="Initial Catalog=AnalyticLogging;Data Source=local;/>
            <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral" />
            <bufferSize value="1"/>
            <commandText value="spLog" />
            <commandType value="StoredProcedure" />

            <parameter>
                <parameterName value="@LogDate" />
                <dbType value="DateTime" />
                <layout type="log4net.Layout.RawTimeStampLayout" />
            </parameter>
            <parameter>
                <parameterName value="@Thread" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%thread" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Loglevel" />
                <dbType value="String" />
                <size value="50" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%level" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Logger" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%logger" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@SourceApplication" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%property{SourceApplication}" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Message" />
                <dbType value="String" />
                <size value="4000" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%message" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Exception" />
                <dbType value="String" />
                <size value="2000" />
                <layout type="log4net.Layout.ExceptionLayout" />
            </parameter>

        </appender>

Hamster · Jul 14, 2015

Well then, what's the problem?

Kilgore_Trout_Redux · Jul 14, 2015

Pho3nix said:
Using this :https://logging.apache.org/log4net/release/sdk/log4net.Appender.FileAppender.html

I was being slightly lazy Think I might have found issue at hand.
Working around this.

Side question though, how are you guys logging issues into a DB and text file?

Log4net

CheekyC · Jul 14, 2015

lock(this) is bad practice. Read up on it.

Rather use
private readonly object lockObj = new object();

and then

lock(lockObj)

Pho3nix · Jul 14, 2015

Hamster said:
Well then, what's the problem?

It's not working

Code I posted in C# is from the .log4net source code, thought it might be of some help.

Hamster · Jul 14, 2015

Mind posting the whole xml file?

Pho3nix · Jul 15, 2015

Hamster said:
Mind posting the whole xml file?

Code:

<?xml version="1.0"?>
<configuration>
 
  <configSections>
    <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
      <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
        <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
        <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
          <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere" />
          <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
          <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
          <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
        </sectionGroup>
      </sectionGroup>
    </sectionGroup>
      <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net, Version=1.2.13.0, Culture=neutral, PublicKeyToken=669e0ddf0bb1aa2a" />
  </configSections>

    <appSettings>
        <add key="log4net.Internal.Debug" value="true"/>
    </appSettings>
    
    <connectionStrings/>
  <system.web>
    <compilation debug="true">
      <assemblies>
        <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
      </assemblies>
    </compilation>
    <!--
        The <authentication> section enables configuration 
        of the security authentication mode used by 
        ASP.NET to identify an incoming user. 
    -->
    <authentication mode="Windows" />
    <!--
        The <customErrors> section enables configuration 
        of what to do if/when an unhandled error occurs 
        during the execution of a request. Specifically, 
        it enables developers to configure html error pages 
        to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
         <error statusCode="403" redirect="NoAccess.htm"/>
         <error statusCode="404" redirect="FileNotFound.htm"/>
        </customErrors>
    -->
    <pages>
      <controls>
        <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
      </controls>
    </pages>

    <httpHandlers>
      <remove verb="*" path="*.asmx"/>
      <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
      <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
      <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
    </httpHandlers>
    <httpModules>
      <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    </httpModules>
  </system.web>
  <system.codedom>
    <compilers>
      <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4"
                type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
        <providerOption name="CompilerVersion" value="v3.5"/>
        <providerOption name="WarnAsError" value="false"/>
      </compiler>
    </compilers>
  </system.codedom>
  <!-- 
      The system.webServer section is required for running ASP.NET AJAX under Internet
      Information Services 7.0.  It is not necessary for previous version of IIS.
  -->
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false"/>
    <modules>
      <remove name="ScriptModule" />
      <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    </modules>
    <handlers>
      <remove name="WebServiceHandlerFactory-Integrated"/>
      <remove name="ScriptHandlerFactory" />
      <remove name="ScriptHandlerFactoryAppServices" />
      <remove name="ScriptResource" />
      <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode"
           type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
      <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode"
           type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
      <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
    </handlers>
  </system.webServer>
  <runtime>
    <assemblyBinding appliesTo="v2.0.05727" xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <system.serviceModel>
    <services>
      <service behaviorConfiguration="SSISLogging.Service1Behavior"
        name="SSISLogging.SSISLog">
        <endpoint address="" binding="wsHttpBinding" contract="SSISLogging.ISSISLog">
          <identity>
            <dns value="localhost" />
          </identity>
        </endpoint>
        <endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />
      </service>
    </services>

Pho3nix · Jul 15, 2015

continued

Code:

    <behaviors>
      <serviceBehaviors>
        <behavior name="SSISLogging.Service1Behavior">
          <!-- To avoid disclosing metadata information, set the value below to false and remove the metadata endpoint above before deployment -->
          <serviceMetadata httpGetEnabled="true"/>
          <!-- To receive exception details in faults for debugging purposes, set the value below to true.  Set to false before deployment to avoid disclosing exception information -->
          <serviceDebug includeExceptionDetailInFaults="false"/>
        </behavior>
      </serviceBehaviors>
    </behaviors>
  </system.serviceModel>
    <log4net>
        <logger name="ErrorLog" level="Debug">
            <appender-ref ref="DatabaseAppender"/>
            <appender-ref ref="RollingFileErrorAppender"/>
        </logger>
        
        <appender name="DatabaseAppender" type="log4net.Appender.AdoNetAppender">
            <connectionString value="Initial Catalog=AnalyticLogging;Data Source=local" />
            <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
            <bufferSize value="1"/>
            <commandText value="spLog" />
            <commandType value="StoredProcedure" />

            <parameter>
                <parameterName value="@LogDate" />
                <dbType value="DateTime" />
                <layout type="log4net.Layout.RawTimeStampLayout" />
            </parameter>
            <parameter>
                <parameterName value="@Thread" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%thread" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Loglevel" />
                <dbType value="String" />
                <size value="50" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%level" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Logger" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%logger" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@SourceApplication" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%property{SourceApplication}" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Message" />
                <dbType value="String" />
                <size value="4000" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%message" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@Exception" />
                <dbType value="String" />
                <size value="2000" />
                <layout type="log4net.Layout.ExceptionLayout" />
            </parameter>

        </appender>

        <appender name="RollingFileErrorAppender" type="log4net.Appender.RollingFileAppender">
            <file value="ErrorLog.txt" />
            <appendToFile value="true" />
            <rollingStyle value="Size" />
            <maxSizeRollBackups value="5" />
            <maximumFileSize value="10MB" />
            <staticLogFileName value="true" />
            <layout type="log4net.Layout.PatternLayout">
                <conversionPattern value="%date - %logger - %message%newline" />
            </layout>
            <filter type="log4net.Filter.LevelMatchFilter">
                <levelToMatch value="ERROR"/>
            </filter>
            <filter type="log4net.Filter.DenyAllFilter" />
        </appender>
        
        <root>
            <appender-ref ref="DatabaseAppender"/>
            <appender-ref ref="RollingFileErrorAppender"/>
        </root>
    </log4net>
</configuration>

CamiKaze · Jul 15, 2015

Exception Handler? Can you step through the code and report back please.

Hamster · Jul 15, 2015

Try adding this inside the Db Appender section between <commandType> and the first <parameter>

Code:

    <commandType value="StoredProcedure" />
     
    [B]<reconnectonerror value="true"/>
    <threshold value="ERROR" />
    <bufferSize value="0" />[/B]

    <parameter>

Join the MyBroadband community

Get started

WCF Service Not releasing file

The Legend

Resident Rodent

Executive Member

Expert Member

Executive Member

The Legend

The Legend

Resident Rodent

Expert Member

Well-Known Member

The Legend

Resident Rodent

Executive Member

Senior Member

The Legend

Resident Rodent

The Legend

The Legend

Honorary Master

Resident Rodent