PSU hung after importing photos

[G8DHE]

I'll start a new thread as it may not be the same problem as associated with lockup at Sync during import that version 2487 cures ?

Problem started after removing some Labels on images, the system would lockup during Synching the images, the system would become non-responsive with no CPU time being recorded even after extended wait periods. After closing and restarting the images had been synched and all would appear well. However the sequence would repeat after making further changes to labels. Decided to Compact the database but this thru out the error below;

with error report details;

Code: Select all

IDI.v5.ApplicationException

----- details -----

ExceptionTimeStamp=2019-11-04T11:06:56.650Z
ExceptionThreadName=Main Thread
ExceptionClass=EDatabaseError
Exception=Transaction not set
Build=5.1.0.2459
Edition=Single
Architecture=64 bit
Platform=Windows
OperationSystem=Windows 10 64bit (Version: 10.0.18362)
Display=1920x1200
AvailableMemory=18.6 GB of 31.9 GB
ProcessorCores=12
Trial=no
UptimeSecs=1151
SystemID=284B564E0F11D90A2B2734D8CF89B7D5
CallStack=  $00000001004354E0  DATABASEERROR,  line 2264 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/base/db.pas
  $000000010044B09A  EXECUTEDIRECT,  line 1302 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/sqldb/sqldb.pp
  $000000010044AFB4  EXECUTEDIRECT,  line 1292 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/sqldb/sqldb.pp
  $000000010048198C  EXECUTEDIRECT,  line 1221 of ../../XOM/idsqlite3conn.pp
  $000000010077CCFB  BASECOMPACTDATABASE,  line 6252 of ../idDataModule.pas
  $00000001007A2CCC  COMPACTANDREPAIRDATABASE,  line 15459 of ../idDataModule.pas
  $00000001000FABA4  COMPACTANDREPAIRDATABASE,  line 4790 of ../uCatalog.pas
  $0000000100251150  COMPACTDATABASE,  line 10326 of ufmain.pas
  $000000010027207A  ASKOPENCATALOG,  line 17701 of ufmain.pas
  $000000010037BFFF  CLICK,  line 83 of include/menuitem.inc
  $000000010037C828  DOCLICKED,  line 293 of include/menuitem.inc
  $00000001000111F3  DISPATCH,  line 674 of ../inc/objpas.inc
  $0000000100327924  DOWINDOWPROC,  line 2078 of win32/win32callback.inc
  $00000001003292D7  WINDOWPROC,  line 2696 of win32/win32callback.inc
  $00007FF96F6463ED
  $00007FF96F645DE2
  $000000010032A3FE  APPPROCESSMESSAGES,  line 407 of win32/win32object.inc
DatabaseSystem=SQLite
ActiveCollectionCount=0
ActiveForm=  frmMain[TfrmMain]
ActiveForm.ActiveControl=  frmMain[TfrmMain]
  vxScene1[TvxScene]
ActiveForm.Scene.Focused=  Root1[TvxBackground]
  loApplication[TvxLayout]
  loApplicationContent[TvxLayout]
  loClientArea[TvxLayout]
  loCollectionViewer[TvxLayout]
  [TvxCollectionViewerTabComponent]
  [TvxCollectionViewerTabSheet]
  [TvxCollectionViewer]
ActiveForm.Scene.Hovered=  Root1[TvxBackground]
  loApplication[TvxLayout]
  loApplicationContent[TvxLayout]
  loClientArea[TvxLayout]
  loCollectionViewer[TvxLayout]
  [TvxCollectionViewerTabComponent]
  [TvxCollectionViewerTabSheet]
  [TvxCollectionViewer]

Now I've just restored back to a database which was pre-version 2487 and the code as well to version 2459 which had been compacted (during backup) and yet the same error is now being reported.
So now bemused as to is this a bug in the new version or a problem with my database ?

[Hert]

2487 doesn't have "sync cures" or any sync changes....2487 fixes the hang after an import that caused the application to freeze. It's a fix in the import module, not the syncing.
BTW; Shortly after 2487, 2490 was released and in a few minutes 2493 will be release.

BTW2; you also posted this in another topic, where I explained what you could try. Please do not cross post. I will merge the duplicate topics.

viewtopic.php?f=57&t=27816&start=15#p123300

[G8DHE]

Sorry about the cross posting.
Tried the above sequence,
1. I have login dialog enabled already
2. Started PSU
3. Selected the catalog and continued.
4. Selected Compact, after a few minutes it came back with the Transaction not set;

Code: Select all

IDI.v5.ApplicationException

----- details -----

ExceptionTimeStamp=2019-11-04T11:45:24.552Z
ExceptionThreadName=Main Thread
ExceptionClass=EDatabaseError
Exception=Transaction not set
Build=5.1.2.2487
Edition=Single
Architecture=64 bit
Platform=Windows
OperationSystem=Windows 10 64bit (Version: 10.0.18362)
Display=1920x1200
AvailableMemory=18 GB of 31.9 GB
ProcessorCores=12
Trial=no
UptimeSecs=200
SystemID=284B564E0F11D90A2B2734D8CF89B7D5
CallStack=  $00000001004362B0  DATABASEERROR,  line 2264 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/base/db.pas
  $000000010044BE6A  EXECUTEDIRECT,  line 1302 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/sqldb/sqldb.pp
  $000000010044BD84  EXECUTEDIRECT,  line 1292 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/sqldb/sqldb.pp
  $000000010048275C  EXECUTEDIRECT,  line 1221 of ../../XOM/idsqlite3conn.pp
  $000000010077E6FB  BASECOMPACTDATABASE,  line 6252 of ../idDataModule.pas
  $00000001007A4BFC  COMPACTANDREPAIRDATABASE,  line 15540 of ../idDataModule.pas
  $00000001000FB2D4  COMPACTANDREPAIRDATABASE,  line 4814 of ../uCatalog.pas
  $0000000100251C50  COMPACTDATABASE,  line 10335 of ufmain.pas
  $000000010027296A  ASKOPENCATALOG,  line 17733 of ufmain.pas
  $000000010037CB5F  CLICK,  line 83 of include/menuitem.inc
  $000000010037D388  DOCLICKED,  line 293 of include/menuitem.inc
  $00000001000111F3  DISPATCH,  line 674 of ../inc/objpas.inc
  $0000000100328484  DOWINDOWPROC,  line 2078 of win32/win32callback.inc
  $0000000100329E37  WINDOWPROC,  line 2696 of win32/win32callback.inc
  $00007FF96F6463ED
  $00007FF96F645DE2
  $000000010032AF5E  APPPROCESSMESSAGES,  line 407 of win32/win32object.inc
DatabaseSystem=SQLite
ActiveCollectionCount=0
ActiveForm=  frmMain[TfrmMain]
ActiveForm.ActiveControl=  frmMain[TfrmMain]
  vxScene1[TvxScene]
ActiveForm.Scene.Focused=  Root1[TvxBackground]
  loApplication[TvxLayout]
  loApplicationContent[TvxLayout]
  loClientArea[TvxLayout]
  loCollectionViewer[TvxLayout]
  [TvxCollectionViewerTabComponent]
  [TvxCollectionViewerTabSheet]
  [TvxCollectionViewer]
ActiveForm.Scene.Hovered=  Root1[TvxBackground]
  loApplication[TvxLayout]
  loApplicationContent[TvxLayout]
  loClientArea[TvxLayout]
  loCollectionViewer[TvxLayout]
  [TvxCollectionViewerTabComponent]
  [TvxCollectionViewerTabSheet]
  [TvxCollectionViewer]

The exception was sent.
All on version 2487.

[Hert]

The log is telling me that you selected Catalog -> Open from the hamburger menu, not Catalog->Compact Current Catalog. Is that correct?

And which compact option did you select to lead to the error?

Compact.png (35.15 KiB) Viewed 1278 times

Also, the latest version is now 2493, did you install that already?

Thank you

[G8DHE]

No I pretty certain I selected the Catalog at the starting Menu, which is my usual procedure, then I choose Hamburger > Catalog >Compact and choose the first "Compact catalog database" option.

I will update to the latest version 2493 , next and try the sequence again next.

[G8DHE]

OK, Updated to version 2493,
Started new version
from the login/startup screen selected the catalog to use, then when the full window opened
Hamburger > Catalog > Compact >"Compact catalog database" wait 5 minutes then the Exception screen appears.

Code: Select all

IDI.v5.ApplicationException

----- details -----

ExceptionTimeStamp=2019-11-04T14:14:26.328Z
ExceptionThreadName=Main Thread
ExceptionClass=EDatabaseError
Exception=Transaction not set
Build=5.1.2.2493
Edition=Single
Architecture=64 bit
Platform=Windows
OperationSystem=Windows 10 64bit (Version: 10.0.18362)
Display=1920x1200
AvailableMemory=15.3 GB of 31.9 GB
ProcessorCores=12
Trial=no
UptimeSecs=227
SystemID=284B564E0F11D90A2B2734D8CF89B7D5
CallStack=  $0000000100435F60  DATABASEERROR,  line 2264 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/base/db.pas
  $000000010044BB1A  EXECUTEDIRECT,  line 1302 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/sqldb/sqldb.pp
  $000000010044BA34  EXECUTEDIRECT,  line 1292 of ../../../nfreepascal/source/fpc/packages/fcl-db/src/sqldb/sqldb.pp
  $000000010048240C  EXECUTEDIRECT,  line 1221 of ../../XOM/idsqlite3conn.pp
  $000000010077E2FB  BASECOMPACTDATABASE,  line 6252 of ../idDataModule.pas
  $00000001007A47FC  COMPACTANDREPAIRDATABASE,  line 15540 of ../idDataModule.pas
  $00000001000FB0C4  COMPACTANDREPAIRDATABASE,  line 4790 of ../uCatalog.pas
  $0000000100251A40  COMPACTDATABASE,  line 10335 of ufmain.pas
  $000000010027275A  ASKOPENCATALOG,  line 17733 of ufmain.pas
  $000000010037C94F  CLICK,  line 83 of include/menuitem.inc
  $000000010037D178  DOCLICKED,  line 293 of include/menuitem.inc
  $00000001000111F3  DISPATCH,  line 674 of ../inc/objpas.inc
  $0000000100328274  DOWINDOWPROC,  line 2078 of win32/win32callback.inc
  $0000000100329C27  WINDOWPROC,  line 2696 of win32/win32callback.inc
  $00007FF96F6463ED
  $00007FF96F645DE2
  $000000010032AD4E  APPPROCESSMESSAGES,  line 407 of win32/win32object.inc
DatabaseSystem=SQLite
ActiveCollectionCount=0
ActiveForm=  frmMain[TfrmMain]
ActiveForm.ActiveControl=  frmMain[TfrmMain]
  vxScene1[TvxScene]
ActiveForm.Scene.Focused=  Root1[TvxBackground]
  loApplication[TvxLayout]
  loApplicationContent[TvxLayout]
  loClientArea[TvxLayout]
  loCollectionViewer[TvxLayout]
  [TvxCollectionViewerTabComponent]
  [TvxCollectionViewerTabSheet]
  [TvxCollectionViewer]
ActiveForm.Scene.Hovered=  Root1[TvxBackground]
  loApplication[TvxLayout]
  loApplicationContent[TvxLayout]
  loClientArea[TvxLayout]
  loCollectionViewer[TvxLayout]
  [TvxCollectionViewerTabComponent]
  [TvxCollectionViewerTabSheet]
  [TvxCollectionViewer]

I've actually captured the process as a video if its any help ... let me know.

[Hert]

Can you send me a copy of your catalog database (no need for the larger thumbs database)?
If possible, upload it to your cloud storage and send a link to support@idimager.com

[G8DHE]

Yup OK email sent with the link be aware its 17GBytes
I have a backup from Friday pre the updates so will check that out in the meantime.

[Hert]

It's downloading...but apparently this is on a slow server and will take 4 hours to finish. Since this is on such a slow server, compressing the file would save a lot of time. Is that still possible?

[Hert]

Did you also check for sufficient free disk space? To compact the database of your size, you'd need at least around 25GB of free disk space to successfully compact the catalog.

[G8DHE]

Yes there is sufficient diskspace that's not a problem, just compacted the previous backup no problems.
Yup will do regarding the Zip, its in progress now, I'll email a new link as soon as its complete and transffered to the server.

[Hert]

Hi Geoff, Thank you for providing the database. Not sure why only your database gives this error, but with it I could reproduce it. None of my test database lead to this error.
For the Single user there's now a 2497 update to fix this. The server Edition is still at 2493. Can you confirm this fixed?

[G8DHE]

OK downloaded and working OK on the laptop databases.
Won't be back to check out the main workstation till later today, but may get a chance to Remote access later and kick it off at least.
Thanks for the rapid responses very much appreciated!

[G8DHE]

Do I assume Hert that it was a bug and not a db error ?
The Compact has now been set running remotely and appears to have been going a while now without problems so looking good.

[G8DHE]

Yup all completed and other items and changes being made seemingly all OK.