Upgrade problem regenerating database

User be1039f1ca

14-04-2009 18:43:05

I'm upgrading from 5.1 to 5.2 and JChemManager hangs when it's Regenerating my database.


It stops on Molecule count 128 every time and hangs for hours.


No error messages on the console.


Using MS SQL 2005.


 

ChemAxon 9c0afc9aaf

14-04-2009 19:04:45

Hi,


 


Could you check the usage of your CPU(s) whan the hang occurs ?


Is it around 100% or around 0% ?


 


Could you export end send us the first 200 structures to the support e-mail (link at top of this page) ?


(in the original format they were imported, or mrv)


 


Do you have any chemical terms columns defined for the table?


 


Please also send us the output of the following command:


java -version


Best regards,


 


Szilard

User be1039f1ca

14-04-2009 19:42:30

CPU hangs at 0%


How do I know what the first 200 structures are?


I can select top 200, but is that the same order that JChemManager pulls them?


I don't have any chemical terms that I know of.  Just one custom field.


 


java version "1.6.0_07"
Java(TM) SE Runtime Environment (build 1.6.0_07-b06)
Java HotSpot(TM) Client VM (build 10.0-b23, mixed mode, sharing)

ChemAxon 9c0afc9aaf

16-04-2009 18:00:49

The problem was dealt with and fixed off-line.


There was a deadlock in a certain MS SQL configurations (sessions waiting for each other).


The fix will be present in the coming minor release (5.2.1).


Szilard