Jump to content

[1060] not able to delete images


alex.l

Recommended Posts

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)

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...