DSC EDB logs

This topic contains 13 replies, has 7 voices, and was last updated by Profile photo of Vladislav Nedosekin Vladislav Nedosekin 2 weeks ago.

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • #42990

    Hi All,

    I have a problem with the Devices.edb transactions logs.
    I have noticed that C:\Program Files\WindowsPowerShell\DscService folder is around 60Gb in size. When I have checked I have found that all of this is edbXXXXX.log (edb7DB4D.log) files. I have around 500K of those logs.

    Does any one know why this transactions logs are not committed, how to commit then and keep committed?

    I have tried to compress this folder, but it looks like it was not supported. ESENT has failed to read the DB.

    Also I have noticed that has broken PULL server as now none of the clients can download the modules that they were able to download before...

     Cannot find module xCertificate_2.0.0.0 from the server https://lbe-sh-mgmt-001.lbe.local/PSDSCPullServer.svc/Modules(ModuleName='xCertificate',ModuleVersion='2.0.0.0')/ModuleContent. 
    Could not install module dependencies needed by the configuration.
        + CategoryInfo          : ResourceUnavailable: (root/Microsoft/...gurationManager:String) [], CimException
        + FullyQualifiedErrorId : WebDownloadManagerModuleNotFound,Microsoft.PowerShell.DesiredStateConfiguration.Commands.GetDscModuleCommand
    

    I have both modules and checksums. Tried to update the checksums, but all is useless.

    Any suggestions?

    #43057
    Profile photo of Don Jones
    Don Jones
    Keymaster

    Never seen this before. The Report Server is, unfortunately, a little bit of a black box. I'd obviously check the diagnostics logs to see if anything came up, and honestly might try deleting the EDB entirely to see if it'll start over. Otherwise, you're probably looking at generating a support ticket with Microsoft.

    #43061

    I have fixed the Modules distribution by generating a new GUID for the nodes authentication.

    For the logs – still not clear.

    How I can raise a support ticket to MS?

    Thanks!

    #43063
    Profile photo of Don Jones
    Don Jones
    Keymaster

    I've pinged some friends on the team to see if they have any suggestions, but that might take some time. Opening a ticket involves calling Product Support, and it's something you'd need to pay for. If they determine that the problem is a bug, they refund that. You'd start by contacting Product Support in your region.

    #43076
    Profile photo of Arie H
    Arie H
    Participant

    Known issue with the amount and sizes of the log files.
    Was discussed on a post on this forum some time ago with one of the PS team pitching in.

    Its also reported on the github repo and iirc also on uservoice.

    Iirc its spoused to be fixed next release a.k.a. Win2016 server RTM or GA.

    #43090
    Profile photo of Jason Helmick
    Jason Helmick
    Keymaster

    There is a service entry – made a while ago – that asks about this. It's being investigated.
    https://windowsserver.uservoice.com/forums/301869-powershell/suggestions/13399740-dsc-esent-database-management

    #43758
    Profile photo of Jered Miller
    Jered Miller
    Participant

    Is there a way to reduce the growth of these EDB####.log files on my pull server? I only have a small sample of servers using my pull server and it generates an excessive amount of files that I have to purge every day.

    #43761
    Profile photo of Arie H
    Arie H
    Participant
    #43763
    Profile photo of Don Jones
    Don Jones
    Keymaster
    #43873
    Profile photo of Jered Miller
    Jered Miller
    Participant

    Wow, not sure how I missed this post. My apologies.

    #44213

    For now, the workaround is to create a scheduled task that will delete the *.log files from C:\Program Files\WindowsPowerShell\DscService.

    #44917

    Hi Indhu,
    And how then to deal with the EDB inconsistency?

    "w3wp (17636) PSDSCPullSever: Error -1811 (0xfffff8ed) occurred while opening logfile C:\Program Files\WindowsPowerShell\DscService\edbFCC97.log."

    Thanks!

    #45226
    Profile photo of Kyle Berger
    Kyle Berger
    Participant

    Restore from backup? 😛

    These log files are the devil. I can't wait until we get some utilities or the settings for these Transaction logs changes or something.

    I only have a few nodes and I get about 1 GB of logs in a few days. ESE for the lose.

    In the meantime: {gci 'C:\Program Files\WindowsPowerShell\DscService\*' -filter "edb*.log" -exclude "edb.log" | ri}

    *** Edit ***

    Wait, maybe this?

    gci 'C:\Program Files\WindowsPowerShell\DscService\*' -filter "edb*.log" -exclude "edb.log" | ?{$_.CreationTime -lt (gi 'C:\Program Files\WindowsPowerShell\DscService\edb.chk').CreationTime} | ri

    "The checkpoint file, Edb.chk, is created by the Jet Database. Edb.chk stores the database checkpoint, so that it can replay logs starting with the generation containing the checkpoint, if needed. The Edb.chk file is a pointer in the log sequence that maintains the status between memory and the database file on disk. In the event of a failure, it indicates the point in the log file from which the information store needs to start the recovery. The Edb.chk file is essential for efficient recovery because if it didn't exist, the information store must attempt recovery by starting from the beginning of the oldest log file it found on disk and has to check every page in every log file to determine whether it had already been written to the database. This process, of course, is very time consuming, especially if the only goal is to make the database consistent."

    https://technet.microsoft.com/en-us/library/cc961819.aspx?f=255&MSPPError=-2147217396

    • This reply was modified 2 months, 4 weeks ago by Profile photo of Kyle Berger Kyle Berger.
    #54006

    I have found the answer for this:
    ESENT cause not only this,but lots of other issues.

    Current scenarios require edit of database path in web.config: C:\inetpub\wwwroot\PSDSCPullServer\web.config
    find these two lines:

    replace with:

    It is also needed to copy Devices.mdb itself from the

    $pshome/modules/psdesiredstateconfiguration/pullserver

    to

    $env:PROGRAMFILES\WindowsPowerShell\DscService\

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic.