OpenKM freeze for no apparent reason

[manueldasilva]

Hello
for started, sorry for my english ...
we use version 6.3.7 CE and we have a hang that seems random.
When this lock appears, it is impossible to use openkm for about 1 minute.
I can not find anything in the logs (tomcat, openkm or postgresql).
I disabled all the crons, changed cache properties, optimized the indexes without it changing anything except perhaps speed up the display when everything is fine.

would anyone have an eventual track?

[manueldasilva]

We have advanced in our research.
it is the update of the metadata which seems to pose pb

if I repeat several times
curl -u Admin: Admin -H "Accept: application / json" -X PUT -H "Content type: application / xml" -d <simplePropertiesGroup> <simplePropertyGroup> <name> okp: grp.test </ name> <value> false </ value> </ simplePropertyGroup> </ simplePropertiesGroup> 'http: // localhost: 8080 / OpenKM / services / rest / propertyGroup / setPropertiesSimple? nodeId = 1234 \ & grpName = okg: grp

I freeze openkm for 1min but still without error.

an idea?

[jllort]

How many documents do you have? ->
SELECT COUNT(*) FROM OKM_NODE_BASE
SELECT COUNT(*) FROM OKM_NODE_DOCUMENT
SELECT COUNT(*) FROM OKM_NODE_FOLDER
SELECT COUNT(*) FROM OKM_NODE_MAIL

What hard disk type are you using? SATA ( 7200, 5400 ) , SSD ?

[manueldasilva]

Hello

OKM_NODE_BASE
1087799
OKM_NODE_DOCUMENT
700149
OKM_NODE_FOLDER
387650
OKM_NODE_MAIL
0

hard disk
SATA 7200