SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'USERNAME' for key 'notset_user' at <<closure>>

notset_user · August 22, 2023, 10:31pm

Hello dear forum members,

searching this forum for errors, I found several topics mentioning “SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry” but none was referring to “notset_user”. So I hope not to create a duplicate.

Nextcloud version: 27.0.1.2
Operating system and version: Raspberry Pi 3 Model B PLus Rev 1.3 Debian GNU/Linux 11. 5.10.92-v8+ (aarch64)
NextcloudPi version: v1.52.4
Apache version: Apache 2.4.56
PHP version: 8.1.11

Is this the first time you’ve seen this error? (Y/N):
Yes, but the error is persistent since over a month despite of rebooting the system.

Steps to replicate it:

Only two users are affected: They can’t login anymore. They share most of their calendars and address books.
There is an additional “empty” admin account and another user account. This one is sharing (hosting) two of his calendars and three of his address books via a group with the two affected users.
Unfortunately I have not found the source yet. The error logs keep piling up irregularly. The time between two errors varies from under a minute up to about an hour.

The output of your Nextcloud log in Admin > Logging:

webdav

[webdav] Fehler: Sabre\DAV\Exception\ServiceUnavailable: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

0. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 180
   OCA\DAV\Connector\Sabre\Auth->check()
1. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 135
   Sabre\DAV\Auth\Plugin->check()
2. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
   Sabre\DAV\Auth\Plugin->beforeMethod()
3. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 456
   Sabre\DAV\Server->emit()
4. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 253
   Sabre\DAV\Server->invokeMethod()
5. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 321
   Sabre\DAV\Server->start()
6. /var/www/nextcloud/apps/dav/lib/Server.php line 364
   Sabre\DAV\Server->exec()
7. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
   OCA\DAV\Server->exec()
8. /var/www/nextcloud/remote.php line 172
   require_once("/var/www/nextcl ... p")

PROPFIND /remote.php/dav/files/*USERNAME*/
from 93.244.93.157 by *USERNAME* at 2023-08-22T21:44:47+00:00

no app in context

[no app in context] Fehler: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 328
    OC\DB\Exceptions\DbalException::wrap()
 1. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 2. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 3. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
 4. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
 5. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
 6. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
 7. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
 8. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
 9. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
10. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
11. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
12. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
13. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 114
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
14. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Backend/AbstractBasic.php line 103
    OCA\DAV\Connector\Sabre\Auth->validateUserPass("*** sensitive parameters replaced ***")
15. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 232
    Sabre\DAV\Auth\Backend\AbstractBasic->check()
16. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 139
    OCA\DAV\Connector\Sabre\Auth->auth()
17. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 180
    OCA\DAV\Connector\Sabre\Auth->check()
18. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 135
    Sabre\DAV\Auth\Plugin->check()
19. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\Auth\Plugin->beforeMethod()
20. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 456
    Sabre\DAV\Server->emit()
21. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
22. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
23. /var/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
24. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
25. /var/www/nextcloud/remote.php line 172
    require_once("/var/www/nextcl ... p")

Caused by:

Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1163
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/nextcloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 4. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 8. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 9. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
10. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
12. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
15. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
16. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
17. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 114
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
20. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Backend/AbstractBasic.php line 103
    OCA\DAV\Connector\Sabre\Auth->validateUserPass("*** sensitive parameters replaced ***")
21. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 232
    Sabre\DAV\Auth\Backend\AbstractBasic->check()
22. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 139
    OCA\DAV\Connector\Sabre\Auth->auth()
23. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 180
    OCA\DAV\Connector\Sabre\Auth->check()
24. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 135
    Sabre\DAV\Auth\Plugin->check()
25. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\Auth\Plugin->beforeMethod()
26. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 456
    Sabre\DAV\Server->emit()
27. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
28. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
29. /var/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
30. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
31. /var/www/nextcloud/remote.php line 172
    require_once("/var/www/nextcl ... p")

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 8. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
 9. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
10. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
12. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
15. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
16. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
17. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 114
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Backend/AbstractBasic.php line 103
    OCA\DAV\Connector\Sabre\Auth->validateUserPass("*** sensitive parameters replaced ***")
20. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 232
    Sabre\DAV\Auth\Backend\AbstractBasic->check()
21. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 139
    OCA\DAV\Connector\Sabre\Auth->auth()
22. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 180
    OCA\DAV\Connector\Sabre\Auth->check()
23. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 135
    Sabre\DAV\Auth\Plugin->check()
24. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\Auth\Plugin->beforeMethod()
25. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 456
    Sabre\DAV\Server->emit()
26. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
27. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
28. /var/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
29. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
30. /var/www/nextcloud/remote.php line 172
    require_once("/var/www/nextcl ... p")

Caused by:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 8. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
 9. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
10. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
12. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
15. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
16. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
17. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 114
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Backend/AbstractBasic.php line 103
    OCA\DAV\Connector\Sabre\Auth->validateUserPass("*** sensitive parameters replaced ***")
20. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 232
    Sabre\DAV\Auth\Backend\AbstractBasic->check()
21. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php line 139
    OCA\DAV\Connector\Sabre\Auth->auth()
22. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 180
    OCA\DAV\Connector\Sabre\Auth->check()
23. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php line 135
    Sabre\DAV\Auth\Plugin->check()
24. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\Auth\Plugin->beforeMethod()
25. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 456
    Sabre\DAV\Server->emit()
26. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 253
    Sabre\DAV\Server->invokeMethod()
27. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 321
    Sabre\DAV\Server->start()
28. /var/www/nextcloud/apps/dav/lib/Server.php line 364
    Sabre\DAV\Server->exec()
29. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
30. /var/www/nextcloud/remote.php line 172
    require_once("/var/www/nextcl ... p")

PROPFIND /remote.php/dav/files/*USERNAME*/
from 93.244.93.157 by *USERNAME* at 2023-08-22T21:44:45+00:00

index

[index] Fehler: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 328
    OC\DB\Exceptions\DbalException::wrap()
 1. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 2. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 3. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
 4. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
 5. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
 6. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
 7. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
 8. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
 9. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
10. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
11. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
12. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
13. /var/www/nextcloud/lib/private/User/Session.php line 580
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
14. /var/www/nextcloud/lib/base.php line 1150
    OC\User\Session->tryBasicAuthLogin()
15. /var/www/nextcloud/lib/base.php line 1060
    OC::handleLogin()
16. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1814
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1749
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1163
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/nextcloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 4. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 8. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 9. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
10. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
12. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
15. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
16. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
17. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/lib/private/User/Session.php line 580
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
20. /var/www/nextcloud/lib/base.php line 1150
    OC\User\Session->tryBasicAuthLogin()
21. /var/www/nextcloud/lib/base.php line 1060
    OC::handleLogin()
22. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 103
    Doctrine\DBAL\Driver\PDO\Exception::new()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 8. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
 9. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
10. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
12. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
15. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
16. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
17. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/lib/private/User/Session.php line 580
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/lib/base.php line 1150
    OC\User\Session->tryBasicAuthLogin()
20. /var/www/nextcloud/lib/base.php line 1060
    OC::handleLogin()
21. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '*USERNAME*' for key 'notset_user' at <<closure>>

 0. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 101
    PDOStatement->execute()
 1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1153
    Doctrine\DBAL\Driver\PDO\Statement->execute()
 2. /var/www/nextcloud/lib/private/DB/Connection.php line 295
    Doctrine\DBAL\Connection->executeStatement()
 3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 354
    OC\DB\Connection->executeStatement()
 4. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 280
    Doctrine\DBAL\Query\QueryBuilder->execute()
 5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 326
    OC\DB\QueryBuilder\QueryBuilder->execute()
 6. /var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php line 137
    OC\DB\QueryBuilder\QueryBuilder->executeStatement()
 7. /var/www/nextcloud/apps/notifications/lib/Model/SettingsMapper.php line 84
    OCP\AppFramework\Db\QBMapper->insert()
 8. /var/www/nextcloud/apps/notifications/lib/Listener/PostLoginListener.php line 75
    OCA\Notifications\Model\SettingsMapper->setBatchSettingForUser()
 9. /var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php line 86
    OCA\Notifications\Listener\PostLoginListener->handle()
10. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 251
    OC\EventDispatcher\ServiceEventListener->__invoke()
11. /var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php line 73
    Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
12. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 94
    Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
13. /var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php line 106
    OC\EventDispatcher\EventDispatcher->dispatch()
14. /var/www/nextcloud/lib/private/User/Session.php line 392
    OC\EventDispatcher\EventDispatcher->dispatchTyped()
15. /var/www/nextcloud/lib/private/User/Session.php line 662
    OC\User\Session->completeLogin("*** sensitive parameters replaced ***")
16. /var/www/nextcloud/lib/private/User/Session.php line 353
    OC\User\Session->loginWithToken("*** sensitive parameters replaced ***")
17. /var/www/nextcloud/lib/private/User/Session.php line 452
    OC\User\Session->login("*** sensitive parameters replaced ***")
18. /var/www/nextcloud/lib/private/User/Session.php line 580
    OC\User\Session->logClientIn("*** sensitive parameters replaced ***")
19. /var/www/nextcloud/lib/base.php line 1150
    OC\User\Session->tryBasicAuthLogin()
20. /var/www/nextcloud/lib/base.php line 1060
    OC::handleLogin()
21. /var/www/nextcloud/index.php line 36
    OC::handleRequest()

GET /index.php/204
from 93.244.93.157 by *USERNAME* at 2023-08-22T20:18:43+00:00

Thank you very much in advance!

Best regards
notset_user

jtr · August 24, 2023, 7:36pm

Any idea what may have possibly changed a month or so ago? An upgrade? A new app installed? Etc.

What database are you using?

notset_user · August 25, 2023, 7:16pm

Thank you jtr for your quick response!
I’m shure that I didn’t de-/ install any apps. The following ones are installed:

app list

activated
Activity - 2.19.0
Calendar - 4.4.4
Client Push - 0.6.3
Contacts - 5.3.2
Deleted files - 1.17.0
File sharing - 1.19.0
Group folders - 15.0.2
Log Reader - 2.12.0
Monitoring - 1.17.0
News - 23.0.0
Nextcloud announcements - 1.16.0
NextCloudPi - 0.0.1
Notifications - 2.15.0
Password policy - 1.17.0
Photos - 2.3.0
Polls - 5.2.0
Preview Generator - 99.99.99
Privacy - 1.11.0
Related Resources - 1.2.0
Right click - 1.6.0
Support - 1.10.0
Tasks - 0.15.0
Versions - 1.20.0

deactivated
Auditing / Logging - 1.17.0
Brute-force settings - 2.7.0
Circles - 27.0.1
Collaborative tags - 1.17.0
Comments - 1.17.0
Contacts Interaction - 1.8.0
Dashboard - 7.7.0
Default encryption module - 2.15.0
External storage support - 1.19.0
Federation - 1.17.0
First run wizard - 2.16.0
LDAP user and group backend - 1.17.0
PDF viewer - 2.8.0
Recommendations - 1.6.0
Share by mail - 1.17.0
Suspicious Login - 5.0.0
Text - 3.8.0
Two-Factor TOTP Provider - 9.0.0
Update notification - 1.17.0
Usage survey - 1.15.0
User status - 1.7.0
Weather status - 1.7.0

Because I restricted the access to my NextcloudPi control page to the local network and I’m not at home, I can’t search in that section for logs for the time of the last update. I will add that as soon as possible.
However, an update could indeed be a probable cause.

I’m using a 10.5.19 mysql database.