cancel
Showing results for 
Search instead for 
Did you mean: 

Updating document properties in SQL does not reflect on the frontend without a Nuxeo restart?

Matthew_Roy
Champ on-the-rise
Champ on-the-rise

Hello all,

We needed to perform some SQL (MS-SQL) updates to documents stored in our db's. When we perform this update, we re-index those specific documents in Elasticsearch.

However, the data on the frontend still displays the old data, and not the new updated data. The only way we found to fix this is to completely restart Nuxeo.

Is there anyway to reflect these DB SQL updates on the frontend WITHOUT a restart?

Thanks!

2 REPLIES 2

Gregory_Carlin
Elite Collaborator
Elite Collaborator

Hello,

Can you explain why you're updating document properties in the DB directly instead of relying on the Nuxeo API? It is really surprising, and definitely not the recommended way of updating document properties.

Regards,

Patrick_Abgrall
Star Contributor
Star Contributor

There are a number of caches in Nuxeo. As long as these won't be flushed and/or data refreshed in the caches, you might hit stale data.