Welcome to the Seq documentation hub. You'll find comprehensive guides and documentation to help you start working with Seq as quickly as possible, as well as support if you get stuck. Let's jump right in!
Hi, I'm trying to display a table of the time since last event grouped by various parameters select Round(TotalMilliSeconds(Now() - max(@Timestamp)) / (1000 * 3600), 0) as HoursSinceLastEvent from stream group by Tenant, Application, StockImportName, StockExportName order by HoursSinceLastEvent And while this works great in the query editor, it doesn't work as a table dashboard widget, with the error message "The `for window()` directive cannot be applied to this query because of embedded temporal clauses." Somehow weirdly, it works as a line/bar/point graph, but not as a table. If I display @Timestamp instead of calculating the time since timestamp it works as a table
Posted by Tore Birkeland about a year ago
Hi, What is the recommended strategy when you have multiple web apps logging to a single Seq instance? I ask this as logging to a Seq instance just logs the information globally and I would like a way of filtering the logs based on which web app they belong?
Posted by Peter Hitchens about a year ago
var expression = new SignalExpressionPart(); expression.Kind = SignalExpressionKind.Signal; expression.SignalId = "testsign"; var resultSet = await connection.Events.InSignalAsync( unsavedSignal: null, signal: expression, render: true, afterId: lastReadEventId); I got exception when try to get the result set.
Posted by XIAOJUN CHEN about a year ago
Hello, We are currently using the freebie seq logging and considering purchasing enterprise. One question we have is, within the UI, how can we separate logging from our various regions (Dev, Test, Staging, Prod)? Do we have to purchase a separate seq instance per region (hopefully not) or is there a way within a single seq instance to provide this separation? Thanks!
Posted by Brian B. about a year ago
Hello, Now that we use Seq on all of our application, space is going to be important and we need to have a smaller retention. In the idea of performing backups, what if we need to restore them for example to check what happened on a certain date? Is there a way we can put them online then delete after?
Posted by Paolo Ponzano about a year ago
One of our logged properties is the Logger Fullname so an example would be "datalust.seq.operations.anotherthing" Now imagine we have a bunch of things under datalust.seq.common. From a performance point of view would it be okay to do create an exclude against StartsWith('datalust.seq.common') or should we do datalust.seq.common.class1, datalust.seq.common.class2 as individual excludes?
Posted by Shane Courtrille about a year ago
Do you support the OpenTelemetry specification (opentelemtry.io)? Or do you support distributed tracing? More Details: https://devblogs.microsoft.com/aspnet/improvements-in-net-core-3-0-for-troubleshooting-and-monitoring-distributed-apps/
Posted by Toni Wenzel about a year ago
Hi! I am trying to set up mail notification using Seq.App.EmailPlus using SMTP on our Office 365 but fail to do so. One requirement to use the SMTP in O365 is to use TLS but I can't figure out if that is my problem or if the app actually uses TLS? https://docs.microsoft.com/en-us/exchange/mail-flow-best-practices/how-to-set-up-a-multifunction-device-or-application-to-send-email-using-office-3
Posted by Andreas Lalloo about a year ago
Hi folks, I'm having a hard time with SeriLog & Seq. I did a fresh new install of Seq UI on my dev machine. Created a dummy Console app. Logger config is stored in app.config. The events logged by the console app are showing correctly in Seq. Then I try the same thing in my web application. Same config settings stored in the web.config and same events logging code. But Seq UI stays empty.... Tried to enable the SelfLog to log in the console while debugging but I get no message there either. Any clue about how to troubleshoot this if calling Log.Debug(... does not generate any exception and SelfLog does not show anything ? Thanks,
Posted by Sébastien about a year ago
Hi, we are using Seq in a Kubernetes/Docker environment and I noticed Seq is taking a huge amount of RAM. Looking through the discussions here I found out, that seq is using as much ram as it can get, but that I can define a quota what percentage of the available ram Seq may use. Is there a way to tell SEQ to keep only the events from e.g. the last day in ram? Otherwise we would need to use hard pod/container limits. Best regards, Matthias
Posted by Matthias about a year ago
Is there a way to exclude search results based on a partial string contained within the log? I know I can exclude based on type using a filter, but I want to exclude using a text query in my search or dashboard for when the type is unreliable.
Posted by KW about a year ago
I'm getting the error "Seq is unavailable. Failed to initialize storage: Primary index is corrupt. The database must be defragmented or the table deleted." running Seq locally on Windows x64 Version 10.0.19013 Build 19013. Sequence: 1. Installed Seq with choco install Seq (https://chocolatey.org/packages/seq) 2. Initially it worked locally 3. A few days later I ran Seq locally and received above error 4. Uninstalled Seq using choco uninstall Seq 5. Downloaded and installed Seq cleanly from https://datalust.co/download 6. Receive same error Full error from log file follows. {"@t":"2019-11-04T18:10:09.2997685Z","@mt":"Signalling for {Workers} worker task(s) to complete","Workers":2,"SourceContext":"Flare.Workers.WorkerPool"} {"@t":"2019-11-04T18:10:11.2573499Z","@mt":"Stopping broadcast channel","SourceContext":"Flare.Events.Broadcast.BroadcastChannel"} {"@t":"2019-11-04T18:10:11.8951545Z","@mt":"Server stopped cleanly"} {"@t":"2019-11-04T18:10:14.1536073Z","@mt":"Seq {SeqVersion} running on OS {OSCaption}","SeqVersion":"5.1.3200","OSCaption":"Microsoft Windows 10 Pro","SourceContext":"Seq.Server.Features.Diagnostics.EnvironmentInformationWriter"} {"@t":"2019-11-04T18:10:14.2066522Z","@mt":"Running in Windows Service host"} {"@t":"2019-11-04T18:10:14.9704710Z","@mt":"Seq listening on {ListenUris}","ListenUris":["http://localhost:5351/"]} {"@t":"2019-11-04T18:10:15.0901254Z","@mt":"Opening document store {DatabasePath}","DatabasePath":"C:\\ProgramData\\Seq\\Documents\\default.quince","InstanceName":"Quince","SourceContext":"Quince.Storage.Esent.EsentDocumentStore"} {"@t":"2019-11-04T18:10:15.1968359Z","@mt":"Opening event store at {ExtentsPath}","ExtentsPath":"C:\\ProgramData\\Seq\\Extents","SourceContext":"Flare.Events.EventStore"} {"@t":"2019-11-04T18:10:15.1972593Z","@mt":"Available storage engines in order of preference are {Engines}","Engines":["FLARE","ESENT","LMDB"],"SourceContext":"Flare.Events.EventStore"} {"@t":"2019-11-04T18:10:15.2666952Z","@mt":"Cache warm-up is required","SourceContext":"Flare.Events.Cache.SegmentCache","OperationId":"b44f6dc9-9627-47ba-8a14-2585ceb9635c"} {"@t":"2019-11-04T18:10:15.3707548Z","@mt":"Initial memory cache warm-up {Outcome} in {Elapsed:0.0} ms","@r":["103.8"],"Outcome":"completed","Elapsed":103.75070000000001,"OperationId":"b44f6dc9-9627-47ba-8a14-2585ceb9635c"} {"@t":"2019-11-04T18:10:15.3724444Z","@mt":"Session initialization failed","@l":"Error","@x":"Microsoft.Isam.Esent.Interop.EsentPrimaryIndexCorruptedException: Primary index is corrupt. The database must be defragmented or the table deleted.\r\n at Quince.Storage.Esent.EsentDocumentSession..ctor(Instance instance, String path)","SessionId":"JET_SESID(0x1e67bf209a0)","SourceContext":"Quince.Storage.Esent.EsentDocumentSession"} {"@t":"2019-11-04T18:10:15.3789962Z","@mt":"{WarmSegments} segments warmed up ({@Shared})","WarmSegments":168,"Shared":{"Schemata":48,"Strings":257},"SourceContext":"Flare.Events.Cache.SegmentCache"} {"@t":"2019-11-04T18:10:15.3939472Z","@mt":"Closing document store","InstanceName":"Quince","SourceContext":"Quince.Storage.Esent.EsentDocumentStore"} {"@t":"2019-11-04T18:10:15.4112599Z","@mt":"Closing event store","SourceContext":"Flare.Events.EventStore"} {"@t":"2019-11-04T18:10:15.4184396Z","@mt":"Uncaught exception from worker {WorkDescription} ({WorkId})","@l":"Error","@x":"Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = TelemetryController (ReflectionActivator), Services = [Seq.Server.Features.Telemetry.TelemetryController], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = SystemSettings (ReflectionActivator), Services = [Seq.Server.Features.Settings.SystemSettings], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = IDocumentStore (DelegateActivator), Services = [Quince.IDocumentStore], Lifetime = Autofac.Core.Lifetime.CurrentScopeLifetime, Sharing = None, Ownership = ExternallyOwned ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) (See inner exception for details.) (See inner exception for details.) (See inner exception for details.) ---> Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = SystemSettings (ReflectionActivator), Services = [Seq.Server.Features.Settings.SystemSettings], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = IDocumentStore (DelegateActivator), Services = [Quince.IDocumentStore], Lifetime = Autofac.Core.Lifetime.CurrentScopeLifetime, Sharing = None, Ownership = ExternallyOwned ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) (See inner exception for details.) (See inner exception for details.) ---> Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = IDocumentStore (DelegateActivator), Services = [Quince.IDocumentStore], Lifetime = Autofac.Core.Lifetime.CurrentScopeLifetime, Sharing = None, Ownership = ExternallyOwned ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) (See inner exception for details.) ---> Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) ---> Microsoft.Isam.Esent.Interop.EsentPrimaryIndexCorruptedException: Primary index is corrupt. The database must be defragmented or the table deleted.\r\n at Quince.Storage.Esent.EsentDocumentSession..ctor(Instance instance, String path)\r\n at Quince.Storage.Esent.EsentDocumentStore.BeginEsentDocumentSession(String tag)\r\n at Quince.Storage.Esent.Migration.Migrator.GetAppliedMigrations(EsentDocumentStore store, ILogger log)\r\n at Quince.Storage.Esent.Migration.Migrator.Migrate(EsentDocumentStore store, IEnumerable`1 migrations, ILogger migrationLog)\r\n at Seq.Server.SeqServerModule.InitStorageSubsystem(IComponentContext c)\r\n at Autofac.Builder.RegistrationBuilder.<>c__DisplayClass0_0`1.<ForDelegate>b__0(IComponentContext c, IEnumerable`1 p)\r\n at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)\r\n at Autofac.ResolutionExtensions.ResolveService(IComponentContext context, Service service, IEnumerable`1 parameters)\r\n at Autofac.ResolutionExtensions.Resolve[TService](IComponentContext context, IEnumerable`1 parameters)\r\n at Seq.Server.SeqServerModule.<>c.<Load>b__14_10(IComponentContext c)\r\n at Autofac.Builder.RegistrationBuilder.<>c__DisplayClass0_0`1.<ForDelegate>b__0(IComponentContext c, IEnumerable`1 p)\r\n at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()\r\n at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()\r\n at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Features.LazyDependencies.LazyRegistrationSource.<>c__DisplayClass5_1`1.<CreateLazyRegistration>b__1()\r\n at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)\r\n at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)\r\n at System.Lazy`1.CreateValue()\r\n at Seq.Server.ServiceProcess.ServerService.<Start>b__13_0(CancellationToken cancel)\r\n at Flare.Workers.WorkerPool.<>c__DisplayClass4_0.<Run>g__DoWork|0()","WorkDescription":"Start background processes","WorkId":"a4858be1-3d6d-478e-875c-d4775da8abf8","SourceContext":"Flare.Workers.WorkerPool"} {"@t":"2019-11-04T18:23:46.1772055Z","@mt":"Signalling for {Workers} worker task(s) to complete","Workers":2,"SourceContext":"Flare.Workers.WorkerPool"} {"@t":"2019-11-04T18:23:47.6994372Z","@mt":"Stopping broadcast channel","SourceContext":"Flare.Events.Broadcast.BroadcastChannel"} {"@t":"2019-11-04T18:23:48.6585836Z","@mt":"Server stopped cleanly"} {"@t":"2019-11-04T18:26:31.3584131Z","@mt":"Seq {SeqVersion} running on OS {OSCaption}","SeqVersion":"5.1.3200","OSCaption":"Microsoft Windows 10 Pro","SourceContext":"Seq.Server.Features.Diagnostics.EnvironmentInformationWriter"} {"@t":"2019-11-04T18:26:31.4546242Z","@mt":"Running in Windows Service host"} {"@t":"2019-11-04T18:26:33.9023594Z","@mt":"Seq listening on {ListenUris}","ListenUris":["http://localhost:5351/"]} {"@t":"2019-11-04T18:26:34.1054631Z","@mt":"Opening document store {DatabasePath}","DatabasePath":"C:\\ProgramData\\Seq\\Documents\\default.quince","InstanceName":"Quince","SourceContext":"Quince.Storage.Esent.EsentDocumentStore"} {"@t":"2019-11-04T18:26:34.2041707Z","@mt":"Opening event store at {ExtentsPath}","ExtentsPath":"C:\\ProgramData\\Seq\\Extents","SourceContext":"Flare.Events.EventStore"} {"@t":"2019-11-04T18:26:34.2047422Z","@mt":"Available storage engines in order of preference are {Engines}","Engines":["FLARE","ESENT","LMDB"],"SourceContext":"Flare.Events.EventStore"} {"@t":"2019-11-04T18:26:34.2850641Z","@mt":"Cache warm-up is required","SourceContext":"Flare.Events.Cache.SegmentCache","OperationId":"5803cf34-e369-41df-a8a3-5b415ee4de31"} {"@t":"2019-11-04T18:26:34.3225122Z","@mt":"Initial memory cache warm-up {Outcome} in {Elapsed:0.0} ms","@r":["37.3"],"Outcome":"completed","Elapsed":37.2858,"OperationId":"5803cf34-e369-41df-a8a3-5b415ee4de31"} {"@t":"2019-11-04T18:26:34.3312030Z","@mt":"{WarmSegments} segments warmed up ({@Shared})","WarmSegments":168,"Shared":{"Schemata":48,"Strings":257},"SourceContext":"Flare.Events.Cache.SegmentCache"} {"@t":"2019-11-04T18:26:34.3733307Z","@mt":"Session initialization failed","@l":"Error","@x":"Microsoft.Isam.Esent.Interop.EsentPrimaryIndexCorruptedException: Primary index is corrupt. The database must be defragmented or the table deleted.\r\n at Quince.Storage.Esent.EsentDocumentSession..ctor(Instance instance, String path)","SessionId":"JET_SESID(0x266455c09a0)","SourceContext":"Quince.Storage.Esent.EsentDocumentSession"} {"@t":"2019-11-04T18:26:34.4437077Z","@mt":"Closing document store","InstanceName":"Quince","SourceContext":"Quince.Storage.Esent.EsentDocumentStore"} {"@t":"2019-11-04T18:26:34.4650995Z","@mt":"Closing event store","SourceContext":"Flare.Events.EventStore"} {"@t":"2019-11-04T18:26:34.4727727Z","@mt":"Uncaught exception from worker {WorkDescription} ({WorkId})","@l":"Error","@x":"Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = TelemetryController (ReflectionActivator), Services = [Seq.Server.Features.Telemetry.TelemetryController], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = SystemSettings (ReflectionActivator), Services = [Seq.Server.Features.Settings.SystemSettings], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = IDocumentStore (DelegateActivator), Services = [Quince.IDocumentStore], Lifetime = Autofac.Core.Lifetime.CurrentScopeLifetime, Sharing = None, Ownership = ExternallyOwned ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) (See inner exception for details.) (See inner exception for details.) (See inner exception for details.) ---> Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = SystemSettings (ReflectionActivator), Services = [Seq.Server.Features.Settings.SystemSettings], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = IDocumentStore (DelegateActivator), Services = [Quince.IDocumentStore], Lifetime = Autofac.Core.Lifetime.CurrentScopeLifetime, Sharing = None, Ownership = ExternallyOwned ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) (See inner exception for details.) (See inner exception for details.) ---> Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = IDocumentStore (DelegateActivator), Services = [Quince.IDocumentStore], Lifetime = Autofac.Core.Lifetime.CurrentScopeLifetime, Sharing = None, Ownership = ExternallyOwned ---> An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) (See inner exception for details.) ---> Autofac.Core.DependencyResolutionException: An error occurred during the activation of a particular registration. See the inner exception for details. Registration: Activator = StorageSubsystem (DelegateActivator), Services = [Seq.Server.Storage.StorageSubsystem], Lifetime = Autofac.Core.Lifetime.RootScopeLifetime, Sharing = Shared, Ownership = OwnedByLifetimeScope ---> Primary index is corrupt. The database must be defragmented or the table deleted. (See inner exception for details.) ---> Microsoft.Isam.Esent.Interop.EsentPrimaryIndexCorruptedException: Primary index is corrupt. The database must be defragmented or the table deleted.\r\n at Quince.Storage.Esent.EsentDocumentSession..ctor(Instance instance, String path)\r\n at Quince.Storage.Esent.EsentDocumentStore.BeginEsentDocumentSession(String tag)\r\n at Quince.Storage.Esent.Migration.Migrator.GetAppliedMigrations(EsentDocumentStore store, ILogger log)\r\n at Quince.Storage.Esent.Migration.Migrator.Migrate(EsentDocumentStore store, IEnumerable`1 migrations, ILogger migrationLog)\r\n at Seq.Server.SeqServerModule.InitStorageSubsystem(IComponentContext c)\r\n at Autofac.Builder.RegistrationBuilder.<>c__DisplayClass0_0`1.<ForDelegate>b__0(IComponentContext c, IEnumerable`1 p)\r\n at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)\r\n at Autofac.ResolutionExtensions.ResolveService(IComponentContext context, Service service, IEnumerable`1 parameters)\r\n at Autofac.ResolutionExtensions.Resolve[TService](IComponentContext context, IEnumerable`1 parameters)\r\n at Seq.Server.SeqServerModule.<>c.<Load>b__14_10(IComponentContext c)\r\n at Autofac.Builder.RegistrationBuilder.<>c__DisplayClass0_0`1.<ForDelegate>b__0(IComponentContext c, IEnumerable`1 p)\r\n at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()\r\n at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()\r\n at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n --- End of inner exception stack trace ---\r\n at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters, Object& decoratorTarget)\r\n at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)\r\n at Autofac.Core.Resolving.InstanceLookup.Execute()\r\n at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters)\r\n at Autofac.Features.LazyDependencies.LazyRegistrationSource.<>c__DisplayClass5_1`1.<CreateLazyRegistration>b__1()\r\n at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)\r\n at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)\r\n at System.Lazy`1.CreateValue()\r\n at Seq.Server.ServiceProcess.ServerService.<Start>b__13_0(CancellationToken cancel)\r\n at Flare.Workers.WorkerPool.<>c__DisplayClass4_0.<Run>g__DoWork|0()","WorkDescription":"Start background processes","WorkId":"cf356e7c-ddd7-4f17-a6ea-7431aabcdfdc","SourceContext":"Flare.Workers.WorkerPool"}
Posted by Geoff Hudik about a year ago
We noticed that if a dashboard contains events both before and after implementation of DST locally. That the cutoff time for the date is set at 23:00 instead of 00:00. Causing the data to end up being presented on the wrong day (one day early). This happens when presenting a number of days per day. Is there a way to prevent this from happening/fixing the problem?
Posted by Micah van der Vaart about a year ago
Is there a way to create custom aggregate operators? What I'm interested in doing is taking this: `percentile(ElapsedMilliseconds, 95)` and turning it into `p95(ElapsedMilliseconds)` Or an alias might also work. Cheers, Dave
Posted by Dave White about a year ago