[Bug 297818] www/nextcloud: ERROR: time zone "UTC" appears to use leap seconds

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=297818

            Bug ID: 297818
           Summary: www/nextcloud: ERROR:  time zone "UTC" appears to use
                    leap seconds
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: brnrd@freebsd.org
          Reporter: ohartmann@walstatt.org
          Assignee: brnrd@freebsd.org
             Flags: maintainer-feedback?(brnrd@freebsd.org)

Running latest www/nextcloud (nextcloud-php84-34.0.3 ) in a jail (host: FreeBSD
16.0-CURRENT #16 main-n288499-3481a9cdc4dc: Sat Aug 22 07:26:10 CEST 2026
amd64, jail as well), a couple of weeks ago I got struck out of the sudden
aufter an upgrade of both nextcloud and database server (also a jail, running
same OS as the webservice providing nextcloud, DB is
postgresql18-server|client|contrib-18.6 (config options see below) with the
error shown below.

Remark: The ports are poudriere built and "homebrewn" - for the PostgreSQL port
the options set are shown below.

I remember having such a catastrophic event one with PostgreSQL backend and
netbox, I never figured out what caused the problem so we stopped using netbox. 

[...]
# su -m www -c "php ../occ upgrade"
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:235
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(946):
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(1415):
OC\DB\QueryBuilder\QueryBuilder->expr()
#7 /usr/local/www/nextcloud/lib/private/AppConfig.php(310):
OC\AppConfig->loadConfig()
#8 /usr/local/www/nextcloud/lib/private/AppConfig.php(1910):
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(1305): OC::init()
#28 /usr/local/www/nextcloud/console.php(32): require_once('...')
#29 /usr/local/www/nextcloud/occ(33): require_once('...')
#30 {main}root@www:/usr/local/www/nextcloud/config #

Just in case settings of how databases/postgresql18-server|client|contrib is
compiled I give below the options set.

databases/postgresql18-server # make showconfig
===> The following configuration options are available for
postgresql18-server-18.6:
     DEBUG=off: Build with debugging support
     DOCS=on: Build and/or install documentation
     DTRACE=off: Build with DTrace probes
     GSSAPI=off: Build with GSSAPI from base (security/krb5)
     LDAP=off: Build with LDAP authentication support
     LLVM=on: Build with support for JIT-compiling expressions
     LZ4=on: Build with LZ4 compression support
     NLS=on: Use internationalized messages
     OPTIMIZED_CFLAGS=off: Builds with compiler optimizations (-O3)
     PAM=off: Build with PAM Support
     SSL=on: Build with OpenSSL support
     TZDATA=off: Use internal timezone database
     XML=on: Build with XML data type
     ZSTD=on: Build with ZSTD compression support
===> Use 'make config' to modify these settings

databases/postgresql18-client # make showconfig
===> The following configuration options are available for
postgresql18-client-18.6:
     DEBUG=off: Build with debugging support
     DOCS=on: Build and/or install documentation
     GSSAPI=off: Build with GSSAPI from base (security/krb5)
     LIBEDIT=off: Use non-GPL libedit instead of readline
     NLS=on: Use internationalized messages
     OPTIMIZED_CFLAGS=off: Builds with compiler optimizations (-O3)
     PAM=off: Build with PAM Support
     SSL=on: Build with OpenSSL support
     ZSTD=on: Build with ZSTD compression support
===> Use 'make config' to modify these settings

-- 
You are receiving this mail because:
You are the assignee for the bug.