DX Unified Infrastructure Management

  • Private Community

  • 1.  nas transactionlog.db is several GB

    Posted May 07, 2013 06:25 PM

    On my primary hub this morning I found that my data engine queue was fairly large.  now I am also finding that my transactionlog.db is about 4 GB.  I would like to find out what causes it and how I can clean it up. 



  • 2.  Re: nas transactionlog.db is several GB

    Posted May 08, 2013 07:20 AM

    Hi,

     

    Is any data at all being inserted into the database? You should check your data_engine, hub and nas logs.

     

    -jon



  • 3.  Re: nas transactionlog.db is several GB

    Posted May 08, 2013 12:25 PM

    This could be a flood of events that are either dropped in a profile or duplicates. Try using the SQLite browser to select a sample and see what is going on. You could also try putting on flood supression in the nas or, if you can get an idea where it is coming from, at selected robots.