Jump to content

[Fixed] 1210 InvalidOperationException

exterminador

By exterminador
in Daminion Server

 Share

Recommended Posts

exterminador Bronze Member

exterminador

Posted
Posted

Hi there,

 

Not sure if related to the upgrade, but after upgrading to build 1210 I'm getting this exception. There is no error on the interface but found it by taking a look at the log files.

 

Hope it helps

 

Regards!

 

2015-05-04 21:20:20,528 [16] DEBUG SQL [(null)] - select Id, RelativeDataPath, Dataoffset2, Length2 from ThumbnailStack where MediaItemId = @Id and RevisionId is null (@Id=1509592)
2015-05-04 21:20:20,526 [15] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - Start: (91) - 1509588 - 149 - 149
2015-05-04 21:20:20,531 [19] DEBUG SQL [(null)] - select Id, RelativeDataPath, Dataoffset2, Length2 from ThumbnailStack where MediaItemId = @Id and RevisionId is null (@Id=1509591)
2015-05-04 21:20:20,533 [15] DEBUG SQL [(null)] - select f.RelativePath, f.FileName from MediaItems mi left join Files f on mi.ID_File = f.ID where mi.ID = @MediaItemId (@MediaItemId=1509588)
2015-05-04 21:20:20,531 [11] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - End: (85) - 1509593 - 149 - 149
2015-05-04 21:20:20,536 [19] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - End: (87) - 1509591 - 149 - 149
2015-05-04 21:20:20,533 [17] DEBUG SQL [(null)] - select Id, RelativeDataPath, Dataoffset2, Length2 from ThumbnailStack where MediaItemId = @Id and RevisionId is null (@Id=1509589)
2015-05-04 21:20:20,533 [16] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - End: (86) - 1509592 - 149 - 149
2015-05-04 21:20:20,537 [15] DEBUG SQL [(null)] - select Id, RelativeDataPath, Dataoffset2, Length2 from ThumbnailStack where MediaItemId = @Id and RevisionId is null (@Id=1509588)
2015-05-04 21:20:20,538 [17] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - End: (90) - 1509589 - 149 - 149
2015-05-04 21:20:20,538 [15] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - End: (91) - 1509588 - 149 - 149
2015-05-04 21:20:21,007 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (98)
2015-05-04 21:20:21,008 [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 ()
2015-05-04 21:20:21,010 [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) ()
2015-05-04 21:20:21,011 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (98)
2015-05-04 21:20:22,522 [16] DEBUG PicaJet.Daminion.Service.Utils.GetMediaItemDataCommand [(null)] - Start: (99) - 1517429
2015-05-04 21:20:22,526 [16] DEBUG SQL [(null)] - select ID as mid, Name, MediaFormatUi, Deleted, HashCode, ID_ImportSession, ID_File, ID_TopMediaItemStack, CountOfStackItems, ID_Project, ID_Client, ID_Copyrights, ID_ImageProportion, ID_CameraVendor, ID_Lens, ID_ISO, ID_FocalLength, ID_FNumber, ID_ShutterSpeed, ID_Flash, ID_VideoCodec, ID_AudioBitrate, ID_AudioSampleRate, ID_ChannelMode, ID_MusicYear, ID_Software, ID_Owners from MediaItems where Id = @Id (@Id=1517429)
2015-05-04 21:20:22,529 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from Project_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,530 [16] ERROR PicaJet.Daminion.Service.Utils.TagsWorkerDbHelper [(null)] - System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.
  at Npgsql.NpgsqlCommand.CheckConnectionState() in c:\dev\TeamCity\buildAgent\work\45caad201a245970\Npgsql\Npgsql\NpgsqlCommand.Rewrite.cs:line 65
  at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) in c:\dev\TeamCity\buildAgent\work\45caad201a245970\Npgsql\Npgsql\NpgsqlCommand.PrepareExecute.cs:line 240
  at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) in c:\dev\TeamCity\buildAgent\work\45caad201a245970\Npgsql\Npgsql\NpgsqlCommand.PrepareExecute.cs:line 234
  at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\dev\TeamCity\buildAgent\work\45caad201a245970\Npgsql\Npgsql\NpgsqlCommand.PrepareExecute.cs:line 181
  at System.Data.Common.DbCommand.ExecuteReader()
  at PicaJet.Daminion.Service.DbCommandWrapper.ExecuteReader() in c:\DaminionAuto\Code\Service.DB\DbCommandWrapper.cs:line 47
  at PicaJet.Daminion.Service.DbCommandHelper.GetUniqueValue[T](IDbCommand command, SelectDelegate selectDelegate) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:line 147
  at PicaJet.Daminion.Service.DbCommandHelper.GetById[T](IDbCommand command, IMapper mapper, Int64 id) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:line 196
  at PicaJet.Daminion.Service.DbCommandHelper.GetById[T](DbConnection connection, IMapper mapper, Int64 id) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:line 203
  at PicaJet.Daminion.Service.Utils.TagsWorkerDbHelper.GetIndexedTagValue(IndexedTagInfo indexedTag, Int64 indexedTagValueId, Boolean needUpdate, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\TagsWorkerDbHelper.cs:line 115
  at PicaJet.Daminion.Service.Utils.AnotherTagsWorker.GetIndexedTagValue(Int64 indexedTagId, Int64 indexedTagValueId, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\AnotherTagsWorker.cs:line 308
  at PicaJet.Daminion.Service.Utils.MediaItemSelectWithUniqueValues.AddValueInMediaItem(MediaItemLocalEntity mediaItem, IndexedTagInfo indexedTag, Object indexedTagValueIdWithNullPossible) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\MediaItemSelectWithUniqueValues.cs:line 156
  at PicaJet.Daminion.Service.Utils.MediaItemSelectWithUniqueValues.SelectDelegate(DbDataReader reader, Object obj) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\MediaItemSelectWithUniqueValues.cs:line 114
  at PicaJet.Daminion.Service.DbCommandHelper.GetUniqueValue[T](IDbCommand command, SelectDelegateObj selectDelegate, T obj) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:line 169
  at PicaJet.Daminion.Service.Utils.TagsWorkerDbHelper.GetOrUpdateMediaItemFromDB(Int64 mediaItemId, MediaItemLocalEntity mediaItem, IList`1 indexedTags, IList`1 namespaceItems, ITagsWorker tagsWorker, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\TagsWorkerDbHelper.cs:line 595
2015-05-04 21:20:22,535 [16] DEBUG SQL [(null)] - select MediaItems.FileName, MediaItems.FileSize, MediaItems.NumberOfPages, MediaItems.MediaDuration, subject.Title, subject.Description, subject.RightsUsageTerms, subject.DocSubject, subject.DocManager, image.OriginalImageWidth, image.OriginalImageHeight, image.ColorDepth, image.ImageDPI, image.Vendor, image.GPSLatitude, image.GPSLongitude, image.GPSAltitude, music.MusicTitle, music.MusicAlbum, music.MusicConductor, ImportSession.ImportTime, ImportSession.Id, ImportSession.UserUid, MediaItems.Id, CustomNamespaceValues.Custom_8c314d94_7514_471d_9e36_3da0de25a4df, CustomNamespaceValues.Custom_199faaca_d09d_4fff_9ee0_5eec9018746b, music.MusicTrack, MediaItems.ID_TopMediaItemStack, MediaItems.CreationDatetime from MediaItems left join subject on MediaItems.ID = subject.ID_MediaItem left join image on MediaItems.ID = image.ID_MediaItem left join music on MediaItems.ID = music.ID_MediaItem left join ImportSession on MediaItems.ID_ImportSession = ImportSession.Id left join CustomNamespaceValues on MediaItems.ID = CustomNamespaceValues.ID_MediaItem  where MediaItems.ID = 1517429 ()
2015-05-04 21:20:22,541 [16] DEBUG SQL [(null)] - select l.ID_Value from Folder_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,542 [16] DEBUG SQL [(null)] - select l.ID_Value from CreationDatetimeIndexed_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,543 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from CreationDatetimeIndexed_Table where Id = @Id (@Id=3469)
2015-05-04 21:20:22,543 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from CreationDatetimeIndexed_Table where Id = @Id (@Id=5971)
2015-05-04 21:20:22,544 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from CreationDatetimeIndexed_Table where Id = @Id (@Id=3469)
2015-05-04 21:20:22,545 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from CreationDatetimeIndexed_Table where Id = @Id (@Id=5973)
2015-05-04 21:20:22,545 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from CreationDatetimeIndexed_Table where Id = @Id (@Id=5971)
2015-05-04 21:20:22,546 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from CreationDatetimeIndexed_Table where Id = @Id (@Id=3469)
2015-05-04 21:20:22,547 [16] DEBUG SQL [(null)] - select l.ID_Value from Keywords_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,547 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from Keywords_Table where Id = @Id (@Id=14)
2015-05-04 21:20:22,548 [16] DEBUG SQL [(null)] - select l.ID_Value from MusicGenres_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,549 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from MusicGenres_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,550 [16] DEBUG SQL [(null)] - select l.ID_Value from MusicArtists_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,551 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from MusicArtists_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,551 [16] DEBUG SQL [(null)] - select l.ID_Value from MusicComposers_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,552 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from MusicComposers_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,553 [16] DEBUG SQL [(null)] - select l.ID_Value from SystemCollection_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,554 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from SystemCollection_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,555 [16] DEBUG SQL [(null)] - select l.ID_Value from Scene_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,556 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from Scene_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,556 [16] DEBUG SQL [(null)] - select l.ID_Value from SubjectCode_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,557 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from SubjectCode_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,558 [16] DEBUG SQL [(null)] - select l.ID_Value from IntellectualGenre_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,559 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from IntellectualGenre_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,560 [16] DEBUG SQL [(null)] - select l.ID_Value from Custom_b31da4c9_2be8_4a04_ab8b_484b9dca2495_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,560 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from Custom_b31da4c9_2be8_4a04_ab8b_484b9dca2495_Table where Id = @Id (@Id=1)
2015-05-04 21:20:22,565 [16] DEBUG SQL [(null)] - select l.ID_Value from Tray_File l inner join MediaItems m on l.ID_MediaItem = m.Id where l.ID_MediaItem = @MediaItemId (@MediaItemId=1517429)
2015-05-04 21:20:22,567 [16] DEBUG PicaJet.Daminion.Service.Utils.GetMediaItemDataCommand [(null)] - End: (99) - 1517429
2015-05-04 21:20:22,728 [16] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - Start: (100) - 5 - -1 - 0 - 50
2015-05-04 21:20:22,729 [16] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved from ColorLabel_Table it where (not Hidded or Hidded is null) and not IsGroup LIMIT @Limit OFFSET @Offset (@Offset=0, @Limit=50)
2015-05-04 21:20:22,730 [16] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - End: (100) - 5 - -1 - 0 - 50
2015-05-04 21:20:25,632 [16] DEBUG PicaJet.Daminion.Service.Utils.IsFolderOfflineCommand [(null)] - Start: (101)
2015-05-04 21:20:25,640 [16] DEBUG PicaJet.Daminion.Service.Utils.IsFolderOfflineCommand [(null)] - End: (101)
2015-05-04 21:20:31,009 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (102)
2015-05-04 21:20:31,011 [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 ()
2015-05-04 21:20:31,013 [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) ()
2015-05-04 21:20:31,014 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (102)
2015-05-04 21:20:41,000 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (103)
2015-05-04 21:20:41,002 [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 ()
2015-05-04 21:20:41,004 [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) ()
2015-05-04 21:20:41,005 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (103)
2015-05-04 21:20:51,007 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (104)
2015-05-04 21:20:51,009 [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 ()
2015-05-04 21:20:51,011 [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) ()
2015-05-04 21:20:51,013 [sTP SmartThreadPool Thread #0] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (104)
2015-05-04 21:20:55,163 [17] DEBUG PicaJet.Daminion.Service.Utils.GetSynonymsCommand [(null)] - Start: (105)
2015-05-04 21:20:55,165 [17] DEBUG SQL [(null)] - SELECT Id, Value, ValueId, IsPrimary FROM Categories_Synonym WHERE ValueId = @ValueId AND not IsPrimary (@ValueId=1922)
2015-05-04 21:20:55,171 [17] DEBUG PicaJet.Daminion.Service.Utils.GetSynonymsCommand [(null)] - End: (105)

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.

×
 Share
Go to topic listing
×
×
  • Create New...