Перейти к содержимому

Database Sanity Check

Редактировал(а) Dmitriy Rybakov 05.08.2025, 13:07

This script is a sanity check of the database. There should be no results to the queries run if the database is in good state.
The data listed are data that should be deleted or fixed.

DOCUMENTS: checking for data with bad characters in document name

XWD_IDXWD_FULLNAME
-8021869209268196118XWiki.Полный доступ к ПиКД (редактирование + удаление)

PROPERTIES: This query should return no value. Returned values are properties left over for deleted objects

XWP_IDXWP_NAMEXWP_CLASSTYPE
-6339270635983597837contextDatabasecom.xpn.xwiki.objects.StringProperty
-6339270635983597837contextLangcom.xpn.xwiki.objects.StringProperty
-6339270635983597837contextUsercom.xpn.xwiki.objects.StringProperty
-6339270635983597837croncom.xpn.xwiki.objects.StringProperty
-6339270635983597837jobClasscom.xpn.xwiki.objects.StringProperty
-6339270635983597837jobDescriptioncom.xpn.xwiki.objects.LargeStringProperty
-6339270635983597837jobNamecom.xpn.xwiki.objects.StringProperty
-6339270635983597837scriptcom.xpn.xwiki.objects.LargeStringProperty
-6339270635983597837statuscom.xpn.xwiki.objects.StringProperty
-5159370127512925869contextDatabasecom.xpn.xwiki.objects.StringProperty
-5159370127512925869contextLangcom.xpn.xwiki.objects.StringProperty
-5159370127512925869contextUsercom.xpn.xwiki.objects.StringProperty
-5159370127512925869croncom.xpn.xwiki.objects.StringProperty
-5159370127512925869jobClasscom.xpn.xwiki.objects.StringProperty
-5159370127512925869jobDescriptioncom.xpn.xwiki.objects.LargeStringProperty
-5159370127512925869jobNamecom.xpn.xwiki.objects.StringProperty
-5159370127512925869scriptcom.xpn.xwiki.objects.LargeStringProperty
-5159370127512925869statuscom.xpn.xwiki.objects.StringProperty

PROPERTIES - String: checking for value in xwikiproperties declared as StringProperty and not in xwikistrings

XWP_IDXWP_NAMEXWP_CLASSTYPE
-6339270635983597837contextDatabasecom.xpn.xwiki.objects.StringProperty
-6339270635983597837contextLangcom.xpn.xwiki.objects.StringProperty
-6339270635983597837contextUsercom.xpn.xwiki.objects.StringProperty
-6339270635983597837croncom.xpn.xwiki.objects.StringProperty
-6339270635983597837jobClasscom.xpn.xwiki.objects.StringProperty
-6339270635983597837jobNamecom.xpn.xwiki.objects.StringProperty
-6339270635983597837statuscom.xpn.xwiki.objects.StringProperty
-5159370127512925869contextDatabasecom.xpn.xwiki.objects.StringProperty
-5159370127512925869contextLangcom.xpn.xwiki.objects.StringProperty
-5159370127512925869contextUsercom.xpn.xwiki.objects.StringProperty
-5159370127512925869croncom.xpn.xwiki.objects.StringProperty
-5159370127512925869jobClasscom.xpn.xwiki.objects.StringProperty
-5159370127512925869jobNamecom.xpn.xwiki.objects.StringProperty
-5159370127512925869statuscom.xpn.xwiki.objects.StringProperty

PROPERTIES - LargeString: Cheching for value existing in xwikilargestrings not in xwikiobjects

XWL_IDXWL_NAMEXWL_VALUE
-6339270635983597837jobDescription 
-6339270635983597837script 
-5159370127512925869jobDescription 
-5159370127512925869script 

PROPERTIES - StringList: Cheching for value existing in xwikilargestrings not in xwikiobjects

XWL_IDXWL_NAMEXWL_VALUE
-6339270635983597837jobDescription 
-6339270635983597837script 
-5159370127512925869jobDescription 
-5159370127512925869script 

112 sanity check queries have been run