Hi Community. We've recently deployed a big website and can't get the database cache refreshed. I can replicate this on my dev setup with one backup from the live SQL server.
After clicking on the btn the same message cames back the same. On azure I got a timeout exception. did anyone had a similar problem? btw I'm on version 10.4.2
I have the same problem on Umbraco version 9.5.4. I have emptied the recycle bin, where there were some problems in deserializing data but got around that. There are no errors in the logs just a similar response in Published Cache Status.
I wanted to share some information about a specific issue we encountered. The website was storing a large amount of JSON data as property information in Umbraco. The client was using Umbraco in a way it wasn't originally designed for, which often leads to challenges.
I recommended that the client remove the JSON data from Umbraco and instead utilize custom tables or an alternative storage solution. The JSON was exclusively used to import data that would later be exposed as API data and did not relate to standard CMS pages.
To identify the specific node or document type causing the issue, I manually deleted entries. Before doing that, I searched for properties of type 'ntext' and ordered them by size in SQL. This process helped pinpoint the particular node(s) that, when removed, allowed the cache to function correctly again. Additionally, reducing the number of versions stored might also alleviate some of the issues.
It's important to thoroughly investigate the data to understand the source of the error, and that’s the approach I took. I also cloned the Umbraco repository and the specific version I was using, then debugged it with that database to understand the exact query or code block where it was failing. I hope this information is helpful to you.
Database cache is NOT ok
Hi Community. We've recently deployed a big website and can't get the database cache refreshed. I can replicate this on my dev setup with one backup from the live SQL server.
After clicking on the btn the same message cames back the same. On azure I got a timeout exception. did anyone had a similar problem? btw I'm on version 10.4.2
I have the same problem on Umbraco version 9.5.4. I have emptied the recycle bin, where there were some problems in deserializing data but got around that. There are no errors in the logs just a similar response in Published Cache Status.
Hi Jonas,
I wanted to share some information about a specific issue we encountered. The website was storing a large amount of JSON data as property information in Umbraco. The client was using Umbraco in a way it wasn't originally designed for, which often leads to challenges.
I recommended that the client remove the JSON data from Umbraco and instead utilize custom tables or an alternative storage solution. The JSON was exclusively used to import data that would later be exposed as API data and did not relate to standard CMS pages.
To identify the specific node or document type causing the issue, I manually deleted entries. Before doing that, I searched for properties of type 'ntext' and ordered them by size in SQL. This process helped pinpoint the particular node(s) that, when removed, allowed the cache to function correctly again. Additionally, reducing the number of versions stored might also alleviate some of the issues.
It's important to thoroughly investigate the data to understand the source of the error, and that’s the approach I took. I also cloned the Umbraco repository and the specific version I was using, then debugged it with that database to understand the exact query or code block where it was failing. I hope this information is helpful to you.
is working on a reply...