Nextcloud is a jail-based service we provide on a development platform running recent CURRENT as jail on host running same CURRENT. The database. postgresql 18 from recent (latest) ports is running on another jail on the same box. After the most recent upgrade of packages (the packages a self built via poudriere using the recent ports tree), nextcloud (nextcloud-php84-34.0.1_1) fails to provide the service: [... Browser Error ...] Internal Server Error The server encountered an internal error and was unable to complete your request. Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report. More details can be found in the server log [no, can't!]. [...] After searching the Apache24 logs on the Nextcloud providing host for errors and not finding any trying to upgrade nextcloud via CLI as shown below reveals some issues with the database and/or PHP84, see below. When trying to upgrade manually, see below, I face a well known almost forgotten issue having had eons ago with PostgreSQL and netbox: time zone "UTC" appears to use leap seconds This is driving me nuts! I never found out why Netbox has been corrupted almost out of nowhere after a simple upgrade and now the same phenomenon seems to strike me with Nextcloud. As far as I can see, there is no PHP84 upgrade and php84 is still the default version, although nextcloud recommend php85. [...] # su -m www -c "php ./occ" An unhandled exception has been thrown: Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[22023]: Invalid parameter value: 7 ERROR: time zone "UTC" appears to use leap seconds DETAIL: PostgreSQL does not support leap seconds. in /usr/local/www/nextcloud/lib/private/DB/Connection.php:228 Stack trace: #0 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(458): OC\DB\Connection->connect() #1 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(416): Doctrine\DBAL\Connection->getDatabasePlatformVersion() #2 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(323): Doctrine\DBAL\Connection->detectDatabasePlatform() #3 /usr/local/www/nextcloud/lib/private/DB/Connection.php(928): Doctrine\DBAL\Connection->getDatabasePlatform() #4 /usr/local/www/nextcloud/lib/private/DB/ConnectionAdapter.php(277): OC\DB\Connection->getDatabaseProvider() #5 /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(85): OC\DB\ConnectionAdapter->getDatabaseProvider() #6 /usr/local/www/nextcloud/lib/private/AppConfig.php(1408): OC\DB\QueryBuilder\QueryBuilder->expr() #7 /usr/local/www/nextcloud/lib/private/AppConfig.php(303): OC\AppConfig->loadConfig() #8 /usr/local/www/nextcloud/lib/private/AppConfig.php(1903): OC\AppConfig->searchValues() #9 /usr/local/www/nextcloud/lib/private/Memcache/Factory.php(124): OC\AppConfig->getAppInstalledVersions() #10 /usr/local/www/nextcloud/lib/private/Memcache/Factory.php(166): OC\Memcache\Factory->getGlobalPrefix() #11 /usr/local/www/nextcloud/lib/private/Server.php(972): OC\Memcache\Factory->createLocking() #12 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(176): OC\Server->{closure:OC\Server::__construct():965}() #13 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->{closure:OC\AppFramework\Utility\SimpleContainer::registerService():175}() #14 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(150): Pimple\Container->offsetGet() #15 /usr/local/www/nextcloud/lib/private/ServerContainer.php(149): OC\AppFramework\Utility\SimpleContainer->query() #16 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(44): OC\ServerContainer->query() #17 /usr/local/www/nextcloud/lib/public/Server.php(37): OC\AppFramework\Utility\SimpleContainer->get() #18 /usr/local/www/nextcloud/lib/private/Files/View.php(92): OCP\Server::get() #19 /usr/local/www/nextcloud/lib/private/Server.php(460): OC\Files\View->__construct() #20 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(176): OC\Server->{closure:OC\Server::__construct():457}() #21 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->{closure:OC\AppFramework\Utility\SimpleContainer::registerService():175}() #22 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(150): Pimple\Container->offsetGet() #23 /usr/local/www/nextcloud/lib/private/ServerContainer.php(149): OC\AppFramework\Utility\SimpleContainer->query() #24 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(44): OC\ServerContainer->query() #25 /usr/local/www/nextcloud/lib/private/Server.php(1335): OC\AppFramework\Utility\SimpleContainer->get() #26 /usr/local/www/nextcloud/lib/base.php(702): OC\Server->boot() #27 /usr/local/www/nextcloud/lib/base.php(1292): OC::init() #28 /usr/local/www/nextcloud/console.php(32): require_once('...') #29 /usr/local/www/nextcloud/occ(33): require_once('...')