Loading...
Loading...
A new code path was introduced as part of Zurich Patch 9 and Australia Patch 2 which introduces the MariaDBI18NSQLFormatter class. When the sys_properties record of "com.glide.db.session_language_collation_feature" property is set to true, it takes a code path upon upgrade or restart where a instance will not come up. This impacts mysql/mariadb and oracle instances. When "com.glide.db.session_language_collation_feature" is false, the code path exits early and doesn't cause this issue.
Have an instance pre-ZP9 or pre-AP2 that is mysql/mariadb or oracle Set sys_properties for "com.glide.db.session_language_collation_feature" to true Upgrade the instance to ZP9 or AP2 Instance will result in an outage Workaround 1) Determine first if the instance is on mariadb or oracle via http://<instance name>.service-now.com/xmlstats.do and search for "db.product_name". Oracle will return as: <db.product_name>Oracle</db.product_name> MySQL/MariaDB will return as: <db.product_name>MySQL</db.product_name> If the instance is NOT on Oracle or MySQL/MariaDB, the instance is not impacted by this issue. 2) Next, search for "com.glide.db.session_language_collation_feature" in sys_properties: https://<instance>.service-now.com/sys_properties_list.do?sysparm_query=GOTOnameLIKEcom.glide.db.session_language_collation_feature&sysparm_view= -- 3) Determine the path below: Pre-Upgrade to ZP9 or AP2: If an instance has the sys_properties record of "com.glide.db.session_language_collation_feature" set to true, and the instance has not upgraded to ZP9 or AP2 (and is planning to upgrade to those versions), set the property to false and proceed with the upgrade when ready. During upgrade to ZP9 or AP2: If an instance has the sys_properties record of "com.glide.db.session_language_collation_feature" set to true, and is currently in progress committing an upgrade to ZP9 or AP2, reach out to technical support to validate if the instance is stuck, then set "com.glide.db.session_language_collation_feature" as false and restart the instance. It's recommended to leave the property set to false until you are on a fixed version. A instance restart if the instance has the property set as true while on ZP9 or AP2 will also cause an outage until the instance is on a fixed version.
PRB2023239
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.