Unable to delete entries
Hey,
I can't delete entries.
I right click an entry and choosing 'delete' then clicking yes and the entry stays.
I'm using latest version of RDM connected to MariaDB and logged in as Administrator.
Second PC with another user still see's the object.
Only after disabling Caching mode I see the changes on my PC.
Second PC still see's the entry, only after disabling Caching mode as well it's I can see the changes.
So what I understand from this the problem is with the intelligent caching.
I can't disable it because a lot of times we are working offline.
I was shouting at my workers that they are not doing what I've asked but after checking the logs and seeing by myself I now know that they did do what I've asked and the problem is with the Caching mode.
So, how do we solve this?
using latest version 2020.1.20.0 64bit
All Comments (14)
After the delete if you perform a "full refresh" (CTRL + Refresh Button) does the session disappear? If so, this confirms the issue is in the cache. You can actually use this as a temporary work around while we investigate the issue on our side.
Best regards,
Stéfane Lavergne
- you are fast!
- Yes Ctrl+Refresh (Ctrl+F5) worked.
Thank you.
I'm not able to reproduce at the moment. Could you please send us your data source information (File > My Data Source Information > Send Report to Support)?
Thank you,
Stéfane Lavergne
Sent.
Can you please send us your database schema for analysis?
File > Data Sources > Upgrade (tab) > Send Schema to Support
Best regards,
Stéfane Lavergne
After some investigation I suspect the issue to be in the database. The client cache relies on the database to flag deletes and edits accordingly. I believe in your case the schema might be missing some triggers/functions. The schema dump will allow us to confirm and resolve the issue.
Please send me your schema when you have a minute.
Best regards,
Stéfane Lavergne
Sent Schema.Thank you and sorry for the delay, was on vacation yesteraday.
Thank you for the schema.
As I expected the schema is missing all triggers. The triggers flag internal flags within the database to allow the client cache to do it's work. We usually see this when a database was scripted and triggers were not included.
I will be sending you a SQL script to be run via MySQL Workbench (or other similar tool) against your database. Once executed please send us your schema again for final validation.
Best regards,
Stéfane Lavergne
No problem thank you.
I will send you the script via private message in the next few minutes . The script is specific to your situation, I wouldn't want anyone else to execute it and cause other issues.
Before running any manual SQL script, I strongly recommend you perform a proper backup of your database.
Best regards,
Stéfane Lavergne
Thank you, will run it in the end of the day so I will not disturb anyone who is working at the moment.
Please send me your database schema for validation (File > Data Sources > Upgrade (tab) > Send Schema to Support). I would like to be 100% sure the script executed correctly.
Best regards,
Stéfane Lavergne
Sent
I'm assuming all is working properly now that the schema is good.
If not please let me know.
Best regards,
Stéfane Lavergne