When adding/modifying/delete data in ST table, but an SQL SELECT query returns old data.

[serg]

Your Setup:

• Hardware or environment you use - Virtual Mashine with RH8
• SeaTable Edition (Developer or Enterprise) - enterprise edition
• SeaTable Version (only necessary for self-hosted): 5.2.7

Describe the Problem/Error/Question:

Only the initial data from table creation is visible; recent changes are not reflected. After 24 hours, the updated data becomes visible, but subsequent modifications still show outdated values.

Reproduce:

• create database
• add data into table - works correctly
• run ‘SQL query’ plugin (or api sql select request - same result)
• all data is visible in the SELECT results
• add/modify/delete any data into table - operations complete successfully
• again run ‘SQL query’ plugin (or api sql select request, no matter)
• only see the data as it was when the table was created; none of the changes are reflected. The next day, the data starts appearing, but when modified again, we only see the old values.

Error Messages:

No error messages for any steps

[cdb]

This is not the default behavior.
Are there any error messages visible in logs or the browser console?

[serg]

Thanks for the answer
No error was into browser.
After restarting the server, the issue disappeared and we are unable to reproduce it.
I suggest considering it resolved.