alex.l Posted August 4, 2014 Report Share Posted August 4, 2014 Couldn't change the header anymore. it is version 1061 I'm trying to delete some images to the recycle bin. but it takes forever and no progress is shown. when pressing cancel, it still states waiting.Ok...the files seem to be removed, but have to use task manager to kill the process. See log 2014-08-04 20:35:49,080 [5] DEBUG PicaJet.Daminion.Service.Utils.DeleteMediaItemsCommand [(null)] - End: (6605) 2014-08-04 20:35:49,098 [29] DEBUG PicaJet.Daminion.Service.Utils.GetCatalogParamCommand [(null)] - Start: (6650) 2014-08-04 20:35:49,099 [29] DEBUG SQL [(null)] - select Value from Params where Key = @Key (@Key=cpCloudTagsSettings) 2014-08-04 20:35:49,101 [29] DEBUG PicaJet.Daminion.Service.Utils.GetCatalogParamCommand [(null)] - End: (6650) 2014-08-04 20:35:49,217 [29] DEBUG PicaJet.Daminion.Service.Utils.GetTotalRecordsInCatalogCommand [(null)] - Start: (6651) 2014-08-04 20:35:49,218 [29] DEBUG SQL [(null)] - select count(Id) from MediaItems where not Deleted () 2014-08-04 20:35:49,229 [5] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - Start: (6652) - 38 - 0 - 0 - 50 2014-08-04 20:35:49,241 [29] DEBUG PicaJet.Daminion.Service.Utils.GetTotalRecordsInCatalogCommand [(null)] - End: (6651) 2014-08-04 20:35:49,267 [19] DEBUG PicaJet.Daminion.Service.Utils.CreateMediaItemsBookCommand [(null)] - Start: (6653) - 2 - 2 - 3 - 0 - 1000 2014-08-04 20:35:49,282 [19] DEBUG SQL [(null)] - select m.ID as mid, m.Name, m.MediaFormatUi, m.Deleted, m.HashCode, m.ID_ImportSession, m.ID_File, m.ID_TopMediaItemStack, CountOfStackItems, c_a01.GPSLatitude, c_a11.GPSLongitude, image.GPSLatitude as GPSLatitude, image.GPSLongitude as GPSLongitude from MediaItems m left join image a_a01 on m.ID = a_a01.ID_MediaItem left join image a_a11 on m.ID = a_a11.ID_MediaItem left join image a_a21 on m.ID = a_a21.ID_MediaItem left join image a_a31 on m.ID = a_a31.ID_MediaItem left join image a_a41 on m.ID = a_a41.ID_MediaItem left join image a_a51 on m.ID = a_a51.ID_MediaItem left join image c_a01 on m.ID = c_a01.ID_MediaItem left join image c_a11 on m.ID = c_a11.ID_MediaItem left join image image on m.ID = image.ID_MediaItem where not m.Deleted and (( (a_a01.GPSLatitude > @cd74583845ce44189e93c5be42cdaafb) And (a_a11.GPSLatitude < @6a5510217a8a437c8bc9caad6f1e249d) And (a_a21.GPSLongitude > @9406af8c2dd6405ea623fe1a1091ee1e) And (a_a31.GPSLongitude < @d4b7afe7c165418aba651f9daf58339f) And (a_a41.GPSLatitude <> @45845f06114f474ca3ff3cb479a4527a) And (a_a51.GPSLongitude <> @f82264298ca7439088535a1770b3627c) ) And ( exists (select 1 from CreationDatetimeIndexed_File where ID_Value = @f0c8ac09e3f84cfc99933120692b5864 and m.ID = ID_MediaItem) ) ) order by c_a01.GPSLatitude Desc, c_a11.GPSLongitude Desc LIMIT @Limit OFFSET @Offset (@Limit=1001, @Offset=0, @UserGuid=00000000-0000-0000-0000-000000000000, @cd74583845ce44189e93c5be42cdaafb=51,9856333956345, @6a5510217a8a437c8bc9caad6f1e249d=51,9916721984443, @9406af8c2dd6405ea623fe1a1091ee1e=5,43585062026978, @d4b7afe7c165418aba651f9daf58339f=5,46224355697632, @45845f06114f474ca3ff3cb479a4527a=0, @f82264298ca7439088535a1770b3627c=0, @f0c8ac09e3f84cfc99933120692b5864=1141) 2014-08-04 20:35:49,379 [5] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon from Custom_8917c258_3e30_4aee_ad96_ea22548cb20c_Table it where (not Hidded or Hidded is null) and ParentValueId = @ParentId order by Upper(Value), Id LIMIT @Limit OFFSET @Offset (@ParentId=0, @Offset=0, @Limit=50) 2014-08-04 20:35:49,383 [5] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - End: (6652) - 38 - 0 - 0 - 50 2014-08-04 20:35:49,462 [19] DEBUG PicaJet.Daminion.Service.Utils.CreateMediaItemsBookCommand [(null)] - End: (6653) - 2 - 2 - 3 - 0 - 1000 - 26d9971f-92c6-4cf4-b680-37b816179090 2014-08-04 20:35:49,463 [19] DEBUG PicaJet.Daminion.Service.Utils.GetMediaItemsCommand [(null)] - Start: (6654) - 26d9971f-92c6-4cf4-b680-37b816179090 - 0 - 50 2014-08-04 20:35:49,467 [19] DEBUG PicaJet.Daminion.Service.Utils.GetMediaItemsCommand [(null)] - End: (6654) - 26d9971f-92c6-4cf4-b680-37b816179090 - 0 - 50 2014-08-04 20:35:49,468 [19] DEBUG PicaJet.Daminion.Service.Utils.CloseBookCommand [(null)] - Start: (6655) : 26d9971f-92c6-4cf4-b680-37b816179090 2014-08-04 20:35:49,468 [19] DEBUG PicaJet.Daminion.Service.Utils.CloseBookCommand [(null)] - End: (6655) : 26d9971f-92c6-4cf4-b680-37b816179090 2014-08-04 20:35:55,948 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6656) 2014-08-04 20:35:55,951 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:35:55,953 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:35:55,954 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6656) 2014-08-04 20:36:06,088 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6657) 2014-08-04 20:36:06,090 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:36:06,092 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:36:06,096 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6657) 2014-08-04 20:36:16,228 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6658) 2014-08-04 20:36:16,230 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:36:16,232 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:36:16,233 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6658) 2014-08-04 20:36:25,668 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6659) 2014-08-04 20:36:25,669 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:36:25,671 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:36:25,673 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6659) 2014-08-04 20:36:35,495 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6660) 2014-08-04 20:36:35,497 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:36:35,498 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:36:35,500 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6660) 2014-08-04 20:36:45,635 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6661) 2014-08-04 20:36:45,637 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:36:45,638 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:36:45,643 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6661) 2014-08-04 20:36:55,775 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6662) 2014-08-04 20:36:55,779 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:36:55,781 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:36:55,782 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6662) 2014-08-04 20:37:05,915 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6663) 2014-08-04 20:37:05,917 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:37:05,919 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:37:05,920 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6663) 2014-08-04 20:37:16,056 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6664) 2014-08-04 20:37:16,058 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:37:16,062 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:37:16,064 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6664) 2014-08-04 20:37:26,195 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6665) 2014-08-04 20:37:26,197 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:37:26,199 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:37:26,200 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6665) 2014-08-04 20:37:36,349 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6666) 2014-08-04 20:37:36,351 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:37:36,353 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:37:36,355 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6666) 2014-08-04 20:37:45,463 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6667) 2014-08-04 20:37:45,466 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:37:45,468 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:37:45,469 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6667) 2014-08-04 20:37:55,616 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6668) 2014-08-04 20:37:55,618 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:37:55,620 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:37:55,622 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6668) 2014-08-04 20:38:05,741 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6669) 2014-08-04 20:38:05,745 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:38:05,747 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:38:05,749 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6669) 2014-08-04 20:38:15,881 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6670) 2014-08-04 20:38:15,883 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:38:15,885 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:38:15,887 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6670) 2014-08-04 20:38:26,021 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (6671) 2014-08-04 20:38:26,023 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - select count(*), sum(case when Offline or Processed then 0 else 1 end) from (select distinct s.ID_MediaItem as ID_MediaItem, m.Deleted, f.Offline, s.Processed from Synchronize s left join MediaItems m on (s.ID_MediaItem = m.Id) left join Files f on (s.ID_File = f.Id)) vv () 2014-08-04 20:38:26,027 [sTP SmartThreadPool Thread #0] DEBUG SQL [(null)] - delete from Synchronize where Id in (select s.Id from Synchronize s left join MediaItems m on s.Id_MediaItem = m.Id where m.Deleted) () 2014-08-04 20:38:26,029 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (6671) Quote Link to comment Share on other sites More sharing options...
Murat Posted August 5, 2014 Report Share Posted August 5, 2014 - Do you work with the local or shared catalog? - How many items in your catalog? - Can you send me your catalog for analyzing? - Did you try to remove files from a local or remote folder? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.