Nextcloud version : 24.0.3
Operating system and version : 20.04.4 LTS
Apache or nginx version: Apache 2.4.41
PHP version : PHP 8.1.8
Hallo Zusammen,
ich habe seit neuestem alle zwei Minuten einen Fehler im Log.
OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
Hat jemand ne Ahnung woher das kommt?
Danke schon mal für eure Hilfe.
Gruss, Sascha
Hier mal noch die komplette Meldung
Error core OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 329:
OC\DB\Exceptions\DbalException::wrap()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()
Caused by Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780:
Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719:
Doctrine\DBAL\Connection->handleDriverException()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1173:
Doctrine\DBAL\Connection->convertExceptionDuringQuery()
/var/www/nextcloud/lib/private/DB/Connection.php - line 294:
Doctrine\DBAL\Connection->executeStatement()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:
OC\DB\Connection->executeStatement()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 327:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()
Caused by Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 94:
Doctrine\DBAL\Driver\PDO\Exception::new()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:
Doctrine\DBAL\Driver\PDO\Statement->execute()
/var/www/nextcloud/lib/private/DB/Connection.php - line 294:
Doctrine\DBAL\Connection->executeStatement()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:
OC\DB\Connection->executeStatement()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 327:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()
Caused by PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'next_send_time' at row 1
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 92:
PDOStatement->execute()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:
Doctrine\DBAL\Driver\PDO\Statement->execute()
/var/www/nextcloud/lib/private/DB/Connection.php - line 294:
Doctrine\DBAL\Connection->executeStatement()
/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:
OC\DB\Connection->executeStatement()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 281:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 327:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 221:
OC\DB\QueryBuilder\QueryBuilder->executeStatement()
/var/www/nextcloud/apps/notifications/lib/MailNotifications.php - line 150:
OCP\AppFramework\Db\QBMapper->update("*** sensiti ... *")
/var/www/nextcloud/apps/notifications/lib/BackgroundJob/SendNotificationMails.php - line 49:
OCA\Notifications\MailNotifications->sendEmails()
/var/www/nextcloud/lib/public/BackgroundJob/Job.php - line 79:
OCA\Notifications\BackgroundJob\SendNotificationMails->run()
/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 95:
OCP\BackgroundJob\Job->execute()
/var/www/nextcloud/cron.php - line 151:
OCP\BackgroundJob\TimedJob->execute()
Output Nextcloud Log (oben im Detail):
Apache2 Error Log
[Tue Jul 19 00:00:02.237145 2022] [mpm_event:notice] [pid 1180370:tid 139929362852928] AH00489: Apache/2.4.41 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.1.1f configured -- resuming normal operations
[Tue Jul 19 00:00:02.237177 2022] [core:notice] [pid 1180370:tid 139929362852928] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jul 19 07:38:24.768783 2022] [ssl:error] [pid 2706086:tid 139928339994368] [client 54.89.101.244:47972] AH02042: rejecting client initiated renegotiation
Inhalt der config.php
<?php
$CONFIG = array (
'instanceid' => 'xxxx',
'passwordsalt' => 'xxxx',
'secret' => 'xxxx',
'trusted_domains' =>
array (
0 => 'xxx.xxx.com',
1 => '172.16.xxx.xxx',
),
'datadirectory' => '/mnt/data/nextcloud',
'dbtype' => 'mysql',
'version' => '24.0.3.2',
'overwrite.cli.url' => 'https://xxx.xxx.com/nextcloud',
'htaccess.RewriteBase' => '/',
'dbname' => 'nextcloud_new',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'xxxx',
'dbpassword' => 'xxxx',
'defaultapp' => 'files',
'default_phone_region' => 'CH',
'installed' => true,
'skeletondirectory' => '/mnt/data/skeleton',
'tempdirectory' => '/mnt/data/temp_dir',
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'tls',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'nextcloud',
'mail_domain' => 'xxxx.com',
'mail_smtphost' => 'xxxx.xxxx.com',
'mail_smtpport' => '587',
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.distributed' => '\\OC\\Memcache\\Redis',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '127.0.0.1',
'port' => 6379,
),
'filelocking.enabled' => true,
'ldapIgnoreNamingRules' => false,
'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
'ldapUserCleanupInterval' => 20,
'remember_login_cookie_lifetime' => '1800',
'overwriteprotocol' => 'https',
'app_install_overwrite' =>
array (
0 => 'flowupload',
1 => 'bruteforcesettings',
2 => 'files_trackdownloads',
3 => 'user_saml',
4 => 'suspicious_login',
),
'updater.release.channel' => 'stable',
'lost_password_link' => 'disabled',
'auth.webauthn.enabled' => false,
'maintenance' => false,
'allow_local_remote_servers' => true,
'theme' => '',
'loglevel' => 2,
'encryption.legacy_format_support' => false,
'encryption.key_storage_migrated' => false,
'trusted_proxies' =>
array (
0 => '127.0.0.1',
1 => '::1',
2 => '172.16.xxx.xxx',
),
'updater.secret' => '$2y$10$oaJ1wE40BW7rByE2/PwicuB.u04tQQH2c4XMlC5An/gzaQtMJN/2.',
);