Skip to content

Instantly share code, notes, and snippets.

@object

object/BridgeSoap.20141201.txt

Created December 12, 2014 12:46
Show Gist options
  • Save object/593c46ebd31b1bcd49c8 to your computer and use it in GitHub Desktop.
Save object/593c46ebd31b1bcd49c8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
BridgeSoap.20141201.txt
{"Timestamp":"2014-12-01T00:00:13.2834210+01:00","Level":"Debug","MessageTemplate":"Fetching all changes from domain {Domain} since {SinceTime} (UTC: {SinceUTC})","RenderedMessage":"Fetching all changes from domain \"ndoa\" since 11/30/2014 13:42:14 (UTC: 11/30/2014 12:42:14)","Properties":{"Domain":"ndoa","SinceTime":"2014-11-30T13:42:14.0000000+01:00","SinceUTC":"2014-11-30T12:42:14.0000000Z"}}
{"Timestamp":"2014-12-01T00:00:13.2990212+01:00","Level":"Debug","MessageTemplate":"Search called for provider {ProviderName} with query={Query}","RenderedMessage":"Search called for provider \"g3db\" with query=\"Bridge.AssetService.G3.Queries.G3DbNotificationsByDateTimeQuery\"","Properties":{"ProviderName":"g3db","Query":"Bridge.AssetService.G3.Queries.G3DbNotificationsByDateTimeQuery","clientIp":"2002:a044:1512::a044:1512","sessionId":null}}
{"Timestamp":"2014-12-01T00:00:13.2990212+01:00","Level":"Debug","MessageTemplate":"Querying database for modified clips (including metadata-changed) newer than {ModifiedDate}","RenderedMessage":"Querying database for modified clips (including metadata-changed) newer than 11/30/2014 13:42:14","Properties":{"ModifiedDate":"2014-11-30T13:42:14.0000000+01:00","clientIp":"2002:a044:1512::a044:1512","sessionId":null}}
{"Timestamp":"2014-12-01T00:00:13.3146214+01:00","Level":"Debug","MessageTemplate":"Getting modified clips from G3 SQL: {ModifiedClips}","RenderedMessage":"Getting modified clips from G3 SQL: \"SELECT \r\n[Project2].[FLE_ID] AS [FLE_ID], \r\ncast(0 as bit) AS [C1], \r\n[Project2].[C2] AS [C2], \r\n[Extent3].[FLE_sharer_path] AS [FLE_sharer_path], \r\n[Extent4].[CLP_clip_title] AS [CLP_clip_title], \r\n[Project2].[C1] AS [C3]\r\nFROM (SELECT \r\n\t[Project1].[C1] AS [C1], \r\n\t[Project1].[FLE_ID] AS [FLE_ID], \r\n\t(SELECT \r\n\t\tCOUNT(1) AS [A1]\r\n\t\tFROM [dbo].[g3Media_FCH_FileChanges] AS [Extent2]\r\n\t\tWHERE ([Extent2].[FCH_Date_Written] > @p__linq__0) AND ([Project1].[FLE_ID] = [Extent2].[FLE_ID]) AND (1 <> [Extent2].[FCT_ID])) AS [C2]\r\n\tFROM ( SELECT \r\n\t\t[GroupBy1].[A1] AS [C1], \r\n\t\t[GroupBy1].[K1] AS [FLE_ID]\r\n\t\tFROM ( SELECT \r\n\t\t\t[Extent1].[FLE_ID] AS [K1], \r\n\t\t\tMAX([Extent1].[FCH_Date_Written]) AS [A1]\r\n\t\t\tFROM [dbo].[g3Media_FCH_FileChanges] AS [Extent1]\r\n\t\t\tWHERE [Extent1].[FCH_Date_Written] > @p__linq__0\r\n\t\t\tGROUP BY [Extent1].[FLE_ID]\r\n\t\t) AS [GroupBy1]\r\n\t) AS [Project1] ) AS [Project2]\r\nINNER JOIN [dbo].[OmniBus_FLE_Files] AS [Extent3] ON [Project2].[FLE_ID] = [Extent3].[FLE_ID]\r\nINNER JOIN [dbo].[OmniBus_CLP_Clips] AS [Extent4] ON [Project2].[FLE_ID] = [Extent4].[FLE_ID]\r\nWHERE (0 = [Extent3].[FLE_file_deleted]) AND (0 = [Extent3].[FLE_file_dustbinned])\"","Properties":{"ModifiedClips":"SELECT \r\n[Project2].[FLE_ID] AS [FLE_ID], \r\ncast(0 as bit) AS [C1], \r\n[Project2].[C2] AS [C2], \r\n[Extent3].[FLE_sharer_path] AS [FLE_sharer_path], \r\n[Extent4].[CLP_clip_title] AS [CLP_clip_title], \r\n[Project2].[C1] AS [C3]\r\nFROM (SELECT \r\n\t[Project1].[C1] AS [C1], \r\n\t[Project1].[FLE_ID] AS [FLE_ID], \r\n\t(SELECT \r\n\t\tCOUNT(1) AS [A1]\r\n\t\tFROM [dbo].[g3Media_FCH_FileChanges] AS [Extent2]\r\n\t\tWHERE ([Extent2].[FCH_Date_Written] > @p__linq__0) AND ([Project1].[FLE_ID] = [Extent2].[FLE_ID]) AND (1 <> [Extent2].[FCT_ID])) AS [C2]\r\n\tFROM ( SELECT \r\n\t\t[GroupBy1].[A1] AS [C1], \r\n\t\t[GroupBy1].[K1] AS [FLE_ID]\r\n\t\tFROM ( SELECT \r\n\t\t\t[Extent1].[FLE_ID] AS [K1], \r\n\t\t\tMAX([Extent1].[FCH_Date_Written]) AS [A1]\r\n\t\t\tFROM [dbo].[g3Media_FCH_FileChanges] AS [Extent1]\r\n\t\t\tWHERE [Extent1].[FCH_Date_Written] > @p__linq__0\r\n\t\t\tGROUP BY [Extent1].[FLE_ID]\r\n\t\t) AS [GroupBy1]\r\n\t) AS [Project1] ) AS [Project2]\r\nINNER JOIN [dbo].[OmniBus_FLE_Files] AS [Extent3] ON [Project2].[FLE_ID] = [Extent3].[FLE_ID]\r\nINNER JOIN [dbo].[OmniBus_CLP_Clips] AS [Extent4] ON [Project2].[FLE_ID] = [Extent4].[FLE_ID]\r\nWHERE (0 = [Extent3].[FLE_file_deleted]) AND (0 = [Extent3].[FLE_file_dustbinned])","clientIp":"2002:a044:1512::a044:1512","sessionId":null}}
{"Timestamp":"2014-12-01T00:00:13.3146214+01:00","Level":"Debug","MessageTemplate":"Querying database for deleted clips newer than {ModifiedDate}","RenderedMessage":"Querying database for deleted clips newer than 11/30/2014 13:42:14","Properties":{"ModifiedDate":"2014-11-30T13:42:14.0000000+01:00","clientIp":"2002:a044:1512::a044:1512","sessionId":null}}
{"Timestamp":"2014-12-01T00:00:13.3146214+01:00","Level":"Debug","MessageTemplate":"Getting deleted clips from G3 SQL: {DeletedClips}","RenderedMessage":"Getting deleted clips from G3 SQL: \"SELECT \r\n[Project1].[C3] AS [C1], \r\n[Project1].[C2] AS [C2], \r\n[Project1].[FLE_sharer_path] AS [FLE_sharer_path], \r\n[Project1].[CLP_clip_title] AS [CLP_clip_title], \r\n[Project1].[C1] AS [C3]\r\nFROM ( SELECT \r\n\t[GroupBy1].[A1] AS [C1], \r\n\t[Extent2].[FLE_sharer_path] AS [FLE_sharer_path], \r\n\t[Extent2].[FLE_date_modified] AS [FLE_date_modified], \r\n\t[Extent3].[CLP_clip_title] AS [CLP_clip_title], \r\n\tcast(1 as bit) AS [C2], \r\n\t0 AS [C3]\r\n\tFROM (SELECT \r\n\t\t[Extent1].[FLE_ID] AS [K1], \r\n\t\tMAX([Extent1].[FCH_Date_Written]) AS [A1]\r\n\t\tFROM [dbo].[g3Media_FCH_FileChanges] AS [Extent1]\r\n\t\tWHERE [Extent1].[FCH_Date_Written] > @p__linq__0\r\n\t\tGROUP BY [Extent1].[FLE_ID] ) AS [GroupBy1]\r\n\tINNER JOIN [dbo].[OmniBus_FLE_Files] AS [Extent2] ON [GroupBy1].[K1] = [Extent2].[FLE_ID]\r\n\tINNER JOIN [dbo].[OmniBus_CLP_Clips] AS [Extent3] ON [GroupBy1].[K1] = [Extent3].[FLE_ID]\r\n\tWHERE [Extent2].[FLE_file_deleted] = 1 OR [Extent2].[FLE_file_dustbinned] = 1\r\n) AS [Project1]\r\nORDER BY [Project1].[FLE_date_modified] ASC\"","Properties":{"DeletedClips":"SELECT \r\n[Project1].[C3] AS [C1], \r\n[Project1].[C2] AS [C2], \r\n[Project1].[FLE_sharer_path] AS [FLE_sharer_path], \r\n[Project1].[CLP_clip_title] AS [CLP_clip_title], \r\n[Project1].[C1] AS [C3]\r\nFROM ( SELECT \r\n\t[GroupBy1].[A1] AS [C1], \r\n\t[Extent2].[FLE_sharer_path] AS [FLE_sharer_path], \r\n\t[Extent2].[FLE_date_modified] AS [FLE_date_modified], \r\n\t[Extent3].[CLP_clip_title] AS [CLP_clip_title], \r\n\tcast(1 as bit) AS [C2], \r\n\t0 AS [C3]\r\n\tFROM (SELECT \r\n\t\t[Extent1].[FLE_ID] AS [K1], \r\n\t\tMAX([Extent1].[FCH_Date_Written]) AS [A1]\r\n\t\tFROM [dbo].[g3Media_FCH_FileChanges] AS [Extent1]\r\n\t\tWHERE [Extent1].[FCH_Date_Written] > @p__linq__0\r\n\t\tGROUP BY [Extent1].[FLE_ID] ) AS [GroupBy1]\r\n\tINNER JOIN [dbo].[OmniBus_FLE_Files] AS [Extent2] ON [GroupBy1].[K1] = [Extent2].[FLE_ID]\r\n\tINNER JOIN [dbo].[OmniBus_CLP_Clips] AS [Extent3] ON [GroupBy1].[K1] = [Extent3].[FLE_ID]\r\n\tWHERE [Extent2].[FLE_file_deleted] = 1 OR [Extent2].[FLE_file_dustbinned] = 1\r\n) AS [Project1]\r\nORDER BY [Project1].[FLE_date_modified] ASC","clientIp":"2002:a044:1512::a044:1512","sessionId":null}}
{"Timestamp":"2014-12-01T00:00:13.3146214+01:00","Level":"Debug","MessageTemplate":"Search for query={Query} returned from provider {ProviderName} after {Elapsed} milliseconds","RenderedMessage":"Search for query=\"Bridge.AssetService.G3.Queries.G3DbNotificationsByDateTimeQuery\" returned from provider \"g3db\" after 15 milliseconds","Properties":{"Query":"Bridge.AssetService.G3.Queries.G3DbNotificationsByDateTimeQuery","ProviderName":"g3db","Elapsed":15,"clientIp":"2002:a044:1512::a044:1512","sessionId":null}}
{"Timestamp":"2014-12-01T00:00:13.3146214+01:00","Level":"Debug","MessageTemplate":"G3DbChangesProvider: Got {ChangeCount} changes from G3 Db for domain {Domain}","RenderedMessage":"G3DbChangesProvider: Got 1 changes from G3 Db for domain \"NDOA\"","Properties":{"ChangeCount":1,"Domain":"NDOA"}}
{"Timestamp":"2014-12-01T00:00:13.3146214+01:00","Level":"Debug","MessageTemplate":"Setting InitialRun = {InitialRun} for domain {Domain} - lastNotification.Value = {LastNotification}","RenderedMessage":"Setting InitialRun = False for domain \"NDOA\" - lastNotification.Value = \"30.11.2014 12:42:14\"","Properties":{"InitialRun":false,"Domain":"NDOA","LastNotification":"30.11.2014 12:42:14"}}
{"Timestamp":"2014-12-01T00:00:13.3146214+01:00","Level":"Debug","MessageTemplate":"Removed {RemovedClipCount} clips from change list as they have just been indexed. {CachedClipCount} clips left.","RenderedMessage":"Removed 1 clips from change list as they have just been indexed. 0 clips left.","Properties":{"RemovedClipCount":1,"CachedClipCount":0}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment