Data Loss (potentially due to server outage?)

A few completed interviews seem to be missing on the server, which was out of service for several hours on Monday, 14.02.2022. We would like to check whether they have indeed been lost forever or they could still be retrieved from the database. We did the following:

  • searched in the web interface at …/primary/Interviews, searching for the known interview key
  • searched in the PostgreSQL db for the assignment associated with the interview, and then searched for the corresponding public_key using it as the interview__id in the questionnaires of the same database
  • using the public_key from the previous step as the Interview Id, searched in the API interface at …/primary/apidocs/index.html
    All attempts resulted in kinds of a “nothing found” response.

Below is an excerpt from the log file.

Thank you very much for your support with this.

{"@t":"2022-02-14T04:24:47.2098280Z","@m":"HTTP \"GET\" \"/primary/api/interviewer/v2/questionnaires/90e8a87d-1034-4b25-97eb-56de6c89a415/1/assembly\" responded 500 in 1192.0045 ms","@i":"62d0885c","@l":"Error","@x":"NHibernate.Exceptions.GenericADOException: could not insert: [WB.Core.BoundedContexts.Headquarters.Views.SynchronizationLog.SynchronizationLogItem#75464707][SQL: INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]\r\n ---> Npgsql.PostgresException (0x80004005): 53100: konnte Datei »base/16571/17166« nicht erweitern: No space left on device\r\n   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)\r\n   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlDataReader.NextResult()\r\n   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteNonQuery()\r\n   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)\r\n   at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation)\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n  Exception data:\r\n    Severity: FEHLER\r\n    SqlState: 53100\r\n    MessageText: konnte Datei »base/16571/17166« nicht erweitern: No space left on device\r\n    Hint: Prüfen Sie den freien Festplattenplatz.\r\n    File: d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c\r\n    Line: 462\r\n    Routine: mdextend\r\n   --- End of inner exception stack trace ---\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)\r\n   at NHibernate.Action.EntityInsertAction.Execute()\r\n   at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable)\r\n   at NHibernate.Engine.ActionQueue.ExecuteActions[T](List`1 list)\r\n   at NHibernate.Engine.ActionQueue.ExecuteActions()\r\n   at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)\r\n   at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)\r\n   at NHibernate.Impl.SessionImpl.Flush()\r\n   at NHibernate.Impl.SessionImpl.FlushBeforeTransactionCompletion()\r\n   at NHibernate.Impl.SessionImpl.BeforeTransactionCompletion(ITransaction tx)\r\n   at NHibernate.Transaction.AdoTransaction.Commit()\r\n   at WB.Infrastructure.Native.Storage.Postgre.UnitOfWork.Dispose()\r\n   at Autofac.Core.Disposer.Dispose(Boolean disposing)\r\n   at Autofac.Util.Disposable.Dispose()\r\n   at Autofac.Core.Lifetime.LifetimeScope.Dispose(Boolean disposing)\r\n   at Autofac.Util.Disposable.Dispose()\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.Dispose(Boolean disposing)\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.Dispose()\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceScope.Dispose(Boolean disposing)\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceScope.Dispose()\r\n   at WB.UI.Headquarters.Code.Workspaces.WorkspaceMiddleware.<>c__DisplayClass2_0.<<Invoke>g__InvokeNextWithScope|0>d.MoveNext()\r\n--- End of stack trace from previous location ---\r\n   at WB.UI.Headquarters.Code.Workspaces.WorkspaceMiddleware.Invoke(HttpContext context)\r\n   at Serilog.AspNetCore.RequestLoggingMiddleware.Invoke(HttpContext httpContext)","RequestMethod":"GET","RequestPath":"/primary/api/interviewer/v2/questionnaires/90e8a87d-1034-4b25-97eb-56de6c89a415/1/assembly","StatusCode":500,"Elapsed":1192.0045,"SourceContext":"Serilog.AspNetCore.RequestLoggingMiddleware","RequestId":"0HMFFDO7SBLNJ:00000009","ConnectionId":"0HMFFDO7SBLNJ","ExceptionDetail":{"HResult":-2146233088,"Message":"could not insert: [WB.Core.BoundedContexts.Headquarters.Views.SynchronizationLog.SynchronizationLogItem#75464707][SQL: INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]","Source":"NHibernate","InnerException":{"Data":{"Severity":"FEHLER","InvariantSeverity":"ERROR","SqlState":"53100","MessageText":"konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Hint":"Prüfen Sie den freien Festplattenplatz.","File":"d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c","Line":"462","Routine":"mdextend","actual-sql-query":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9)"},"HResult":-2147467259,"Message":"53100: konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Source":"Npgsql","IsTransient":true,"Statement":{"SQL":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)","StatementType":"Unknown","Rows":0,"LongRows":0,"OID":0,"InputParameters":[null,null,null,null,null,null,null,null,null,null]},"Severity":"FEHLER","InvariantSeverity":"ERROR","SqlState":"53100","Code":"53100","MessageText":"konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Detail":null,"Hint":"Prüfen Sie den freien Festplattenplatz.","Position":0,"InternalPosition":0,"InternalQuery":null,"Where":null,"SchemaName":null,"TableName":null,"ColumnName":null,"DataTypeName":null,"ConstraintName":null,"File":"d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c","Line":"462","Routine":"mdextend","ErrorCode":-2147467259,"Type":"Npgsql.PostgresException"},"SqlString":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)","Type":"NHibernate.Exceptions.GenericADOException"},"Environment":"Production","Version":"21.6.3.31513","VersionInfo":"21.06.3 (build 31513)","AppType":"Headquarters"}
{"@t":"2022-02-14T04:24:47.2461878Z","@m":"An unhandled exception has occurred, logging to Exceptional","@i":"71f60047","@l":"Error","@x":"NHibernate.Exceptions.GenericADOException: could not insert: [WB.Core.BoundedContexts.Headquarters.Views.SynchronizationLog.SynchronizationLogItem#75464707][SQL: INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]\r\n ---> Npgsql.PostgresException (0x80004005): 53100: konnte Datei »base/16571/17166« nicht erweitern: No space left on device\r\n   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)\r\n   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlDataReader.NextResult()\r\n   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteNonQuery()\r\n   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)\r\n   at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation)\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n  Exception data:\r\n    Severity: FEHLER\r\n    SqlState: 53100\r\n    MessageText: konnte Datei »base/16571/17166« nicht erweitern: No space left on device\r\n    Hint: Prüfen Sie den freien Festplattenplatz.\r\n    File: d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c\r\n    Line: 462\r\n    Routine: mdextend\r\n   --- End of inner exception stack trace ---\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)\r\n   at NHibernate.Action.EntityInsertAction.Execute()\r\n   at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable)\r\n   at NHibernate.Engine.ActionQueue.ExecuteActions[T](List`1 list)\r\n   at NHibernate.Engine.ActionQueue.ExecuteActions()\r\n   at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)\r\n   at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)\r\n   at NHibernate.Impl.SessionImpl.Flush()\r\n   at NHibernate.Impl.SessionImpl.FlushBeforeTransactionCompletion()\r\n   at NHibernate.Impl.SessionImpl.BeforeTransactionCompletion(ITransaction tx)\r\n   at NHibernate.Transaction.AdoTransaction.Commit()\r\n   at WB.Infrastructure.Native.Storage.Postgre.UnitOfWork.Dispose()\r\n   at Autofac.Core.Disposer.Dispose(Boolean disposing)\r\n   at Autofac.Util.Disposable.Dispose()\r\n   at Autofac.Core.Lifetime.LifetimeScope.Dispose(Boolean disposing)\r\n   at Autofac.Util.Disposable.Dispose()\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.Dispose(Boolean disposing)\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.Dispose()\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceScope.Dispose(Boolean disposing)\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceScope.Dispose()\r\n   at WB.UI.Headquarters.Code.Workspaces.WorkspaceMiddleware.<>c__DisplayClass2_0.<<Invoke>g__InvokeNextWithScope|0>d.MoveNext()\r\n--- End of stack trace from previous location ---\r\n   at WB.UI.Headquarters.Code.Workspaces.WorkspaceMiddleware.Invoke(HttpContext context)\r\n   at Serilog.AspNetCore.RequestLoggingMiddleware.Invoke(HttpContext httpContext)\r\n   at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)\r\n   at StackExchange.Exceptional.ExceptionalMiddleware.Invoke(HttpContext context)","SourceContext":"StackExchange.Exceptional.ExceptionalMiddleware","RequestId":"0HMFFDO7SBLNJ:00000009","RequestPath":"/primary/api/interviewer/v2/questionnaires/90e8a87d-1034-4b25-97eb-56de6c89a415/1/assembly","ConnectionId":"0HMFFDO7SBLNJ","ExceptionDetail":{"HResult":-2146233088,"Message":"could not insert: [WB.Core.BoundedContexts.Headquarters.Views.SynchronizationLog.SynchronizationLogItem#75464707][SQL: INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]","Source":"NHibernate","InnerException":{"Data":{"Severity":"FEHLER","InvariantSeverity":"ERROR","SqlState":"53100","MessageText":"konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Hint":"Prüfen Sie den freien Festplattenplatz.","File":"d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c","Line":"462","Routine":"mdextend","actual-sql-query":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9)"},"HResult":-2147467259,"Message":"53100: konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Source":"Npgsql","IsTransient":true,"Statement":{"SQL":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)","StatementType":"Unknown","Rows":0,"LongRows":0,"OID":0,"InputParameters":[null,null,null,null,null,null,null,null,null,null]},"Severity":"FEHLER","InvariantSeverity":"ERROR","SqlState":"53100","Code":"53100","MessageText":"konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Detail":null,"Hint":"Prüfen Sie den freien Festplattenplatz.","Position":0,"InternalPosition":0,"InternalQuery":null,"Where":null,"SchemaName":null,"TableName":null,"ColumnName":null,"DataTypeName":null,"ConstraintName":null,"File":"d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c","Line":"462","Routine":"mdextend","ErrorCode":-2147467259,"Type":"Npgsql.PostgresException"},"SqlString":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)","Type":"NHibernate.Exceptions.GenericADOException"},"Environment":"Production","Version":"21.6.3.31513","VersionInfo":"21.06.3 (build 31513)","AppType":"Headquarters"}
{"@t":"2022-02-14T04:24:47.3573155Z","@m":"Connection id \"\"0HMFFDO7SBLNJ\"\", Request id \"\"0HMFFDO7SBLNJ:00000009\"\": An unhandled exception was thrown by the application.","@i":"560e7d32","@l":"Error","@x":"NHibernate.Exceptions.GenericADOException: could not insert: [WB.Core.BoundedContexts.Headquarters.Views.SynchronizationLog.SynchronizationLogItem#75464707][SQL: INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]\r\n ---> Npgsql.PostgresException (0x80004005): 53100: konnte Datei »base/16571/17166« nicht erweitern: No space left on device\r\n   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)\r\n   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlDataReader.NextResult()\r\n   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)\r\n   at Npgsql.NpgsqlCommand.ExecuteNonQuery()\r\n   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)\r\n   at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation)\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n  Exception data:\r\n    Severity: FEHLER\r\n    SqlState: 53100\r\n    MessageText: konnte Datei »base/16571/17166« nicht erweitern: No space left on device\r\n    Hint: Prüfen Sie den freien Festplattenplatz.\r\n    File: d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c\r\n    Line: 462\r\n    Routine: mdextend\r\n   --- End of inner exception stack trace ---\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)\r\n   at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)\r\n   at NHibernate.Action.EntityInsertAction.Execute()\r\n   at NHibernate.Engine.ActionQueue.InnerExecute(IExecutable executable)\r\n   at NHibernate.Engine.ActionQueue.ExecuteActions[T](List`1 list)\r\n   at NHibernate.Engine.ActionQueue.ExecuteActions()\r\n   at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)\r\n   at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)\r\n   at NHibernate.Impl.SessionImpl.Flush()\r\n   at NHibernate.Impl.SessionImpl.FlushBeforeTransactionCompletion()\r\n   at NHibernate.Impl.SessionImpl.BeforeTransactionCompletion(ITransaction tx)\r\n   at NHibernate.Transaction.AdoTransaction.Commit()\r\n   at WB.Infrastructure.Native.Storage.Postgre.UnitOfWork.Dispose()\r\n   at Autofac.Core.Disposer.Dispose(Boolean disposing)\r\n   at Autofac.Util.Disposable.Dispose()\r\n   at Autofac.Core.Lifetime.LifetimeScope.Dispose(Boolean disposing)\r\n   at Autofac.Util.Disposable.Dispose()\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.Dispose(Boolean disposing)\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.Dispose()\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceScope.Dispose(Boolean disposing)\r\n   at Autofac.Extensions.DependencyInjection.AutofacServiceScope.Dispose()\r\n   at WB.UI.Headquarters.Code.Workspaces.WorkspaceMiddleware.<>c__DisplayClass2_0.<<Invoke>g__InvokeNextWithScope|0>d.MoveNext()\r\n--- End of stack trace from previous location ---\r\n   at WB.UI.Headquarters.Code.Workspaces.WorkspaceMiddleware.Invoke(HttpContext context)\r\n   at Serilog.AspNetCore.RequestLoggingMiddleware.Invoke(HttpContext httpContext)\r\n   at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)\r\n   at StackExchange.Exceptional.ExceptionalMiddleware.Invoke(HttpContext context)\r\n   at StackExchange.Exceptional.ExceptionalMiddleware.Invoke(HttpContext context)\r\n   at Microsoft.AspNetCore.Server.IISIntegration.IISMiddleware.Invoke(HttpContext httpContext)\r\n   at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)","ConnectionId":"0HMFFDO7SBLNJ","TraceIdentifier":"0HMFFDO7SBLNJ:00000009","EventId":{"Id":13,"Name":"ApplicationError"},"SourceContext":"Microsoft.AspNetCore.Server.Kestrel","RequestId":"0HMFFDO7SBLNJ:00000009","RequestPath":"/primary/api/interviewer/v2/questionnaires/90e8a87d-1034-4b25-97eb-56de6c89a415/1/assembly","ExceptionDetail":{"HResult":-2146233088,"Message":"could not insert: [WB.Core.BoundedContexts.Headquarters.Views.SynchronizationLog.SynchronizationLogItem#75464707][SQL: INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]","Source":"NHibernate","InnerException":{"Data":{"Severity":"FEHLER","InvariantSeverity":"ERROR","SqlState":"53100","MessageText":"konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Hint":"Prüfen Sie den freien Festplattenplatz.","File":"d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c","Line":"462","Routine":"mdextend","actual-sql-query":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9)"},"HResult":-2147467259,"Message":"53100: konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Source":"Npgsql","IsTransient":true,"Statement":{"SQL":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)","StatementType":"Unknown","Rows":0,"LongRows":0,"OID":0,"InputParameters":[null,null,null,null,null,null,null,null,null,null]},"Severity":"FEHLER","InvariantSeverity":"ERROR","SqlState":"53100","Code":"53100","MessageText":"konnte Datei »base/16571/17166« nicht erweitern: No space left on device","Detail":null,"Hint":"Prüfen Sie den freien Festplattenplatz.","Position":0,"InternalPosition":0,"InternalQuery":null,"Where":null,"SchemaName":null,"TableName":null,"ColumnName":null,"DataTypeName":null,"ConstraintName":null,"File":"d:\\pginstaller_13.auto\\postgres.windows-x64\\src\\backend\\storage\\smgr\\md.c","Line":"462","Routine":"mdextend","ErrorCode":-2147467259,"Type":"Npgsql.PostgresException"},"SqlString":"INSERT INTO SynchronizationLog (InterviewerId, InterviewId, InterviewerName, DeviceId, LogDate, Type, Log, ActionExceptionType, ActionExceptionMessage, Id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)","Type":"NHibernate.Exceptions.GenericADOException"},"Environment":"Production","Version":"21.6.3.31513","VersionInfo":"21.06.3 (build 31513)","AppType":"Headquarters"}

53100: konnte Datei »base/16571/17166« nicht erweitern: No space left on device

Well, that is bad. You don’t have any more storage space left so the DB system couldn’t store the information to the DB.

Whether all, some, or no information has been recorded is circumstantial.