Ghost Release: 1.20.2

TL;DR

Ghost 1.20.2 is a hotfix release that addresses critical database connection issues present in version 1.20.1. The update downgrades several database-related dependencies (knex and bookshelf) to resolve problems with excessive open database connections. It also fixes syntax errors in the codebase that could potentially affect theme developers. This release focuses on stability and performance rather than introducing new features.

Highlight of the Release

• Fixed excessive database connections issue from version 1.20.1
• Downgraded knex to version 0.12.9 and bookshelf to 0.10.3 to improve stability
• Fixed syntax errors in common.i18n references that could affect theme development

Migration Guide

No specific migration steps are required for this update. This is a standard minor version update that can be applied using the normal Ghost update process:

ghost update

If you're using Ghost(Pro), your blog will be updated automatically.

Upgrade Recommendations

Highly Recommended Upgrade

This upgrade is strongly recommended for all users running Ghost 1.20.1 due to the database connection issues that were identified. The excessive database connections could lead to performance degradation, potential database timeouts, and increased server resource usage.

Even if you haven't noticed any issues with version 1.20.1, upgrading to 1.20.2 is advised as a preventative measure to ensure the stability of your Ghost installation.

Bug Fixes

Database Connection Issues

• Fixed an issue where Ghost was keeping too many database connections open, potentially causing connection pool exhaustion
• Downgraded knex from 0.14.x to 0.12.9 to address connection management problems
• Downgraded bookshelf from a newer version to 0.10.3 to maintain compatibility with the knex downgrade
• Adjusted dependencies that relied on knex 0.14 to ensure compatibility

Code Fixes

• Fixed incorrect references to common.i18n that were introduced during a previous refactoring
• Resolved syntax errors that could potentially affect theme development

New Features

This release does not introduce any new features as it is focused on fixing critical bugs and performance issues from the previous version.

Security Updates

This release does not contain any specific security fixes.

Performance Improvements

Database Connection Management

• Improved database connection handling by reverting to more stable versions of database dependencies
• Reduced the number of open database connections, which should result in better resource utilization
• Potentially improved response times by preventing connection pool exhaustion

Impact Summary

Ghost 1.20.2 addresses critical performance and stability issues present in version 1.20.1. The primary fix involves downgrading database-related dependencies (knex and bookshelf) to resolve problems with excessive database connections remaining open. This issue could potentially lead to connection pool exhaustion, database timeouts, and increased server resource usage.

Additionally, the release fixes syntax errors in common.i18n references that were introduced during previous refactoring work. While these errors might not affect most users directly, they could potentially impact theme developers.

This release is focused entirely on bug fixes and performance improvements rather than introducing new features. The changes should result in a more stable Ghost installation with better resource utilization, particularly for busy sites that might otherwise encounter database connection limits.

Full Release Notes