Re: How to Force-Update a Node's Cache from the Database?
The internal / undocumented API of the NodeDAO provides a setCheckNodeConsistency method to disable use of the shared cache of the nodesTransactionalCache for the current transaction, which will result in always loading the state / identity data from the DB. This does not however affect the caches for aspects and properties, but these should not be a problem since their value key includes the node identity data (including the ID of the txn when the node was last changed), so if the node was updated, it will bypass the stale, cached data and also load the current data from the database.
Though I do question the setup of having a write-enabled server connected to the same DB without being part of the cluster. It is generally possible to do this for read-only servers (when disabling some shared caches), i.e. to offload work for indexing without cluster communication adding more load, but IMHO should not be used for write-enabled servers.