Volker Posted August 1, 2014 Report Share Posted August 1, 2014 After resyncing a folder the thumbnails of newly added pictures are broken. I tried CTRL-B, but that didn't help. Quote Link to comment Share on other sites More sharing options...
Uwe Posted August 2, 2014 Report Share Posted August 2, 2014 Hello, a CTRL-B in build 1060 destoyes the thumbnail. It doesn't help to go back to 1059 or 1055. Also to remove and delete the items in 1055/1059 doesn't help - the thumbnails remain destroyed. Now I went back to 1055 and pressed CTRL-B of another item - also this thumbnail is destroyed. Is this a result of a problem in 1060 and now the error has an impact on the previous builds? Also when I import now new files in build 1055 the thumbnail is destroyed. This was not a problem before I'd temporary installed 1060 build. Regards, Uwe Quote Link to comment Share on other sites More sharing options...
Murat Posted August 2, 2014 Report Share Posted August 2, 2014 I am out of the office on this weekend. Is the problem reproduced with the 1059 build? Quote Link to comment Share on other sites More sharing options...
Volker Posted August 2, 2014 Author Report Share Posted August 2, 2014 I did now: - restore 1059 postgres database - downgrade to 1059 server - downgrade to 1059 client - delete local cache directory (C:\Users\vsiebelink\AppData\Local\Daminion Software\Daminion\Thumbs) The issue remains, but I can see that the freshly created files in the cache directory are valid jpg files. For the files with the broken thumbnails now also the fullscreen mode doesn't work. For the correctly displayed thumbnails CTRL-B destroys the thumbnail. I wonder whether there is a cache directory on the server side which could/should be cleaned too. In the server logs I can see: 2014-08-02 11:20:37,567 [15] WARN PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2 [(null)] - System.InvalidCastException: Die angegebene Umwandlung ist ungültig. bei Npgsql.NpgsqlDataReader.GetInt32(Int32 i) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:Zeile 293. bei PicaJet.Daminion.Service.Utils.RenderHelper.SelectDelegate(DbDataReader reader) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 215. bei PicaJet.Daminion.Service.DbCommandHelper.GetUniqueValue[T](IDbCommand command, SelectDelegate selectDelegate) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 157. bei PicaJet.Daminion.Service.Utils.RenderHelper.GetFileValues(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 195. bei PicaJet.Daminion.Service.Utils.RenderHelper.Render(String filePath, RenderInfo[] renders, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 42. bei PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2.GenerateCacheFileClass.GenerateCacheFileAndSaveStack(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\GetThumbnailServiceCommandV2.cs:Zeile 324. bei PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2.Treat(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\GetThumbnailServiceCommandV2.cs:Zeile 118. 2014-08-02 11:20:37,567 [15] DEBUG PicaJet.Daminion.Service.Utils.UpdateThumbnailCommand [(null)] - End: (1754) Quote Link to comment Share on other sites More sharing options...
Volker Posted August 2, 2014 Author Report Share Posted August 2, 2014 Apart from the problem with the thumbnails now Dominion does not create the xmp files anymore. Quote Link to comment Share on other sites More sharing options...
Volker Posted August 2, 2014 Author Report Share Posted August 2, 2014 My next test: I created a local catalog with 1059, imported about 50 pictures and had no problems at all. Overall I made the same experiences as Uwe had: going back to older versions does not solve the problem. Quote Link to comment Share on other sites More sharing options...
Volker Posted August 2, 2014 Author Report Share Posted August 2, 2014 The thumbnail cache on the server seems to be "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\Daminion Software\Daminion\Temporary\ThumbnailCache". It seems to me as if there are no file accesses anymore. Would it be a good way to delete all Daminions directories after deinstalling and the software and before reinstalling? Edit: I tried it. Directory "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\Daminion Software\Daminion\Temporary" has been created, but the subdirectory "ThumbnailCache" is missing. And I have these log entries: 2014-08-02 18:31:03,288 [26] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - Start: (1127) - 35 - 0 - 0 - 50 2014-08-02 18:31:03,289 [26] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon from SystemFlag_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-02 18:31:03,290 [26] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - End: (1127) - 35 - 0 - 0 - 50 2014-08-02 18:31:03,334 [26] DEBUG PicaJet.Daminion.Service.Utils.UpdateThumbnailCommand [(null)] - Start: (1128) 2014-08-02 18:31:03,335 [26] 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=45131) 2014-08-02 18:31:03,337 [26] DEBUG SQL [(null)] - select Id, RelativeDataPath, Dataoffset3, Length3 from ThumbnailStack where MediaItemId = @Id and RevisionId is null (@Id=45131) 2014-08-02 18:31:03,338 [26] DEBUG SQL [(null)] - select ID, MediaItemId, RevisionId, RelativeDataPath from ThumbnailStack where MediaItemId = @Id and RevisionId is null (@Id=45131) 2014-08-02 18:31:03,339 [26] DEBUG SQL [(null)] - select ImageOrientation from image where ID_MediaItem = @Id (@Id=45131) 2014-08-02 18:31:03,339 [26] DEBUG SQL [(null)] - select f.Id, f.ModifiedTime, f.filesize from Files f left join MediaItems m on f.ID = m.ID_File where m.ID = @Id (@Id=45131) 2014-08-02 18:31:03,340 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - Start: GetMediaFormat - \\zbox\Lough Ree\Hunde\Lough Ree\L-Wurf - 20140730\20140731\DSC_2805.NEF 2014-08-02 18:31:03,348 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - End: GetMediaFormat - \\zbox\Lough Ree\Hunde\Lough Ree\L-Wurf - 20140730\20140731\DSC_2805.NEF 2014-08-02 18:31:03,349 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - Start: GetDefaultMediaFormatThumbnail - PicaJet.Daminion.MediaProcessing.MediaFormat 2014-08-02 18:31:03,349 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - End: GetDefaultMediaFormatThumbnail - PicaJet.Daminion.MediaProcessing.MediaFormat 2014-08-02 18:31:03,349 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - Start: GetOfflineThumbnail 2014-08-02 18:31:03,349 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - End: GetOfflineThumbnail 2014-08-02 18:31:03,350 [26] WARN PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2 [(null)] - System.InvalidCastException: Die angegebene Umwandlung ist ungültig. bei Npgsql.NpgsqlDataReader.GetInt32(Int32 i) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:Zeile 293. bei PicaJet.Daminion.Service.Utils.RenderHelper.SelectDelegate(DbDataReader reader) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 215. bei PicaJet.Daminion.Service.DbCommandHelper.GetUniqueValue[T](IDbCommand command, SelectDelegate selectDelegate) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 157. bei PicaJet.Daminion.Service.Utils.RenderHelper.GetFileValues(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 195. bei PicaJet.Daminion.Service.Utils.RenderHelper.Render(String filePath, RenderInfo[] renders, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 42. bei PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2.GenerateCacheFileClass.GenerateCacheFileAndSaveStack(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\GetThumbnailServiceCommandV2.cs:Zeile 324. bei PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2.Treat(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\GetThumbnailServiceCommandV2.cs:Zeile 118. 2014-08-02 18:31:03,351 [26] DEBUG PicaJet.Daminion.Service.Utils.UpdateThumbnailCommand [(null)] - End: (1128) 2014-08-02 18:31:03,395 [26] DEBUG PicaJet.Daminion.Service.Utils.GetMediaItemDataCommand [(null)] - Start: (1130) - 45131 2014-08-02 18:31:03,396 [26] DEBUG SQL [(null)] - select MediaItems.ID_TopMediaItemStack from MediaItems where MediaItems.ID = 45131 () 2014-08-02 18:31:03,397 [26] DEBUG PicaJet.Daminion.Service.Utils.GetMediaItemDataCommand [(null)] - End: (1130) - 45131 2014-08-02 18:31:03,403 [26] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - Start: (1131) - 45131 - 190 - 190 2014-08-02 18:31:03,403 [26] 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=45131) 2014-08-02 18:31:03,406 [26] DEBUG SQL [(null)] - select Id, RelativeDataPath, Dataoffset2, Length2 from ThumbnailStack where MediaItemId = @Id and RevisionId is null (@Id=45131) 2014-08-02 18:31:03,407 [26] DEBUG SQL [(null)] - select ImageOrientation from image where ID_MediaItem = @Id (@Id=45131) 2014-08-02 18:31:03,407 [26] DEBUG SQL [(null)] - select f.Id, f.ModifiedTime, f.filesize from Files f left join MediaItems m on f.ID = m.ID_File where m.ID = @Id (@Id=45131) 2014-08-02 18:31:03,409 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - Start: GetMediaFormat - \\zbox\Lough Ree\Hunde\Lough Ree\L-Wurf - 20140730\20140731\DSC_2805.NEF 2014-08-02 18:31:03,416 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - End: GetMediaFormat - \\zbox\Lough Ree\Hunde\Lough Ree\L-Wurf - 20140730\20140731\DSC_2805.NEF 2014-08-02 18:31:03,417 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - Start: GetDefaultMediaFormatThumbnail - PicaJet.Daminion.MediaProcessing.MediaFormat 2014-08-02 18:31:03,417 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - End: GetDefaultMediaFormatThumbnail - PicaJet.Daminion.MediaProcessing.MediaFormat 2014-08-02 18:31:03,417 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - Start: GetOfflineThumbnail 2014-08-02 18:31:03,418 [26] DEBUG PicaJet.Daminion.Service.Utils.LoggedMetadataService [(null)] - End: GetOfflineThumbnail 2014-08-02 18:31:03,418 [26] WARN PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2 [(null)] - System.InvalidCastException: Die angegebene Umwandlung ist ungültig. bei Npgsql.NpgsqlDataReader.GetInt32(Int32 i) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:Zeile 293. bei PicaJet.Daminion.Service.Utils.RenderHelper.SelectDelegate(DbDataReader reader) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 215. bei PicaJet.Daminion.Service.DbCommandHelper.GetUniqueValue[T](IDbCommand command, SelectDelegate selectDelegate) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 157. bei PicaJet.Daminion.Service.Utils.RenderHelper.GetFileValues(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 195. bei PicaJet.Daminion.Service.Utils.RenderHelper.Render(String filePath, RenderInfo[] renders, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\RenderHelper.cs:Zeile 42. bei PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2.GenerateCacheFileClass.GenerateCacheFileAndSaveStack(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\GetThumbnailServiceCommandV2.cs:Zeile 324. bei PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommandV2.Treat(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\GetThumbnailServiceCommandV2.cs:Zeile 118. 2014-08-02 18:31:03,419 [26] DEBUG PicaJet.Daminion.Service.Utils.GetThumbnailServiceCommand [(null)] - End: (1131) - 45131 - 190 - 190 2014-08-02 18:31:04,740 [sTP SmartThreadPool Thread #2] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - Start: (1133) 2014-08-02 18:31:04,741 [sTP SmartThreadPool Thread #2] 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-02 18:31:04,742 [sTP SmartThreadPool Thread #2] 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-02 18:31:04,743 [sTP SmartThreadPool Thread #2] DEBUG PicaJet.Daminion.Service.Utils.GetSynchronizeStateCommand [(null)] - End: (1133) Quote Link to comment Share on other sites More sharing options...
Uwe Posted August 2, 2014 Report Share Posted August 2, 2014 Hello, maybe there was something wrong with the settings in 1060. When you deinstall/install Daminion the settings remain and will be used by the new installed build. Maybe this is the reason that the problem is still there even after a complete new installation of PostgreSQL and Daminion. Regards, Uwe update: no, it doesn't help to rename the settings folder 1.0 to ~1.0 and let Daminion create new settings in build 1055. The thumbnails remain broken Quote Link to comment Share on other sites More sharing options...
Volker Posted August 3, 2014 Author Report Share Posted August 3, 2014 I went back to 944 -> thumbnails are ok Next updated to 1037 -> ok next updated to 1044 -> thumbnails not working next downgraded to 1040 -> also not ok next downgraded to 1039 -> thumbnails working edit: the xmp files are not created :-( Quote Link to comment Share on other sites More sharing options...
alex.l Posted August 3, 2014 Report Share Posted August 3, 2014 Yeah this is related to my bug report, sorry I didn't see that. I thought I had done something weird with the upgrade and screwed up the database. I must say, that even though this a beta/alpha release, it worries me that such essential functionality is broken. Quote Link to comment Share on other sites More sharing options...
Volker Posted August 3, 2014 Author Report Share Posted August 3, 2014 I must say, that even though this a beta/alpha release, it worries me that such essential functionality is broken. It worries me that (at least at the moment) there seems to be no way back to a fully functional version. Quote Link to comment Share on other sites More sharing options...
Murat Posted August 4, 2014 Report Share Posted August 4, 2014 Sorry for the inconvenience. The 1060 build was uploaded in a hurry without testing. The issue will be fixed today. Nothing serious. In the next build it should works. The error occured while trying to read the filesize from catalog with the incorrect conversion rule. Quote Link to comment Share on other sites More sharing options...
Murat Posted August 4, 2014 Report Share Posted August 4, 2014 Please update to the 1061 build. Quote Link to comment Share on other sites More sharing options...
Volker Posted August 4, 2014 Author Report Share Posted August 4, 2014 There still is the problem that Daminion doesn't write the xmp files anymore. The message is: 2014-08-04 11:27:54,300 [16] ERROR PicaJet.Daminion.Service.Utils.SynchronizeMediaItemCommand [(null)] - Error: (2234) - 45234 System.InvalidCastException: Die angegebene Umwandlung ist ungültig. bei Npgsql.NpgsqlDataReader.GetInt32(Int32 i) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:Zeile 293. bei PicaJet.Daminion.Service.Utils.Mapper.FileMapper.Map(DbDataReader reader) in c:\DaminionAuto\Code\Service.Utils.Uni\Mapper\FileMapper.cs:Zeile 36. bei PicaJet.Daminion.Service.Utils.Mapper.FileMapper.Get(DbDataReader reader) in c:\DaminionAuto\Code\Service.Utils.Uni\Mapper\FileMapper.cs:Zeile 187. bei PicaJet.Daminion.Service.DbCommandHelper.GetUniqueValue[T](IDbCommand command, SelectDelegate selectDelegate) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 157. bei PicaJet.Daminion.Service.DbCommandHelper.GetById[T](IDbCommand command, IMapper mapper, Int64 id) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 223. bei PicaJet.Daminion.Service.DbCommandHelper.GetById[T](DbConnection connection, Int64 id) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 247. bei PicaJet.Daminion.Service.Utils.SynchronizeMediaItemCommand.ProcessMediaItem(MediaItemLocalEntity mediaItem, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\SynchronizeMediaItemCommand.cs:Zeile 130. bei PicaJet.Daminion.Service.Utils.SynchronizeMediaItemCommand.Start(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\SynchronizeMediaItemCommand.cs:Zeile 45. bei PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:Zeile 109. bei PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:Zeile 50. 2014-08-04 11:27:54,301 [16] DEBUG SQL [(null)] - delete from Synchronize where ID_MediaItem = @MediaItemId; (@MediaItemId=45234) Quote Link to comment Share on other sites More sharing options...
Murat Posted August 5, 2014 Report Share Posted August 5, 2014 Thanks for the bug report. Please upgrade to the 1062 build. Quote Link to comment Share on other sites More sharing options...
Uwe Posted August 6, 2014 Report Share Posted August 6, 2014 Hello, just a final question: why didn't help to go back to a previous build? Also in this case the problem with the broken thumbnails was there. In my case I made a complets new setup of PostgreSQL (from 32 to 64 bit) and a Deinstallation/Installation of Daminion ( Regards, Uwe Quote Link to comment Share on other sites More sharing options...
Murat Posted August 7, 2014 Report Share Posted August 7, 2014 just a final question: why didn't help to go back to a previous build? Because the problem was due to the minor bug in the code. Quote Link to comment Share on other sites More sharing options...
Uwe Posted August 7, 2014 Report Share Posted August 7, 2014 Hello Murat, that's what I didn't understand. I've deinstalled PostgreSQL and Daminion and I thought all code is also deinstalled of build 1060 and installed from a build that worked before 1060. Regards, Uwe 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.