Rare problem with null user value on initial page open

[pboguslawski]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

---

Steps to reproduce

Occurs rarely. Cannot reproduce. Possible race.

Expected behaviour

No internal error on spreed call page open from URL.

Actual behaviour

Noticed rare problem with null user (which displays Nextcloud internal error page) when opening spreed call page directly from external calendar (clicking URL https://my.nextcloud.domain.here/call/callidhere in mail application which opens web browser) after successful authentication on reverse proxy :

{"reqId":"[...]","level":3,"time":"2025-02-01T15:09:36+00:00","remoteAddr":"[...]","user":"--","app":"index","method":"GET","url":"/call/callidhere","message":"{\"Exception\":\"Exception\",\"Message\":\"OC\\\\Notification\\\\Notification::setUser(): Argument #1 ($user) must be of type string, null given, called in /var/www/nextcloud/apps/spreed/lib/Controller/PageController.php on line 180 in file '/var/www/nextcloud/lib/private/Notification/Notification.php' line 68\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/App.php\",\"line\":161,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/Route/Router.php\",\"line\":302,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/lib/base.php\",\"line\":1003,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/index.php\",\"line\":24,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"Line\":146,\"Previous\":{\"Exception\":\"TypeError\",\"Message\":\"OC\\\\Notification\\\\Notification::setUser(): Argument #1 ($user) must be of type string, null given, called in /var/www/nextcloud/apps/spreed/lib/Controller/PageController.php on line 180\",\"Code\":0,\"Trace\":[{\"file\":\"/var/www/nextcloud/apps/spreed/lib/Controller/PageController.php\",\"line\":180,\"function\":\"setUser\",\"class\":\"OC\\\\Notification\\\\Notification\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/apps/spreed/lib/Controller/PageController.php\",\"line\":103,\"function\":\"pageHandler\",\"class\":\"OCA\\\\Talk\\\\Controller\\\\PageController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":208,\"function\":\"showCall\",\"class\":\"OCA\\\\Talk\\\\Controller\\\\PageController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":114,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/App.php\",\"line\":161,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/Route/Router.php\",\"line\":302,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/lib/base.php\",\"line\":1003,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/index.php\",\"line\":24,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/lib/private/Notification/Notification.php\",\"Line\":68},\"message\":\"OC\\\\Notification\\\\Notification::setUser(): Argument #1 ($user) must be of type string, null given, called in /var/www/nextcloud/apps/spreed/lib/Controller/PageController.php on line 180 in file '/var/www/nextcloud/lib/private/Notification/Notification.php' line 68\",\"exception\":{},\"CustomMessage\":\"OC\\\\Notification\\\\Notification::setUser(): Argument #1 ($user) must be of type string, null given, called in /var/www/nextcloud/apps/spreed/lib/Controller/PageController.php on line 180 in file '/var/www/nextcloud/lib/private/Notification/Notification.php' line 68\"}","userAgent":"<Firefox ESR 128>","version":"30.0.5.1"}

Authentication is based on user_saml, getting login from apache env var (checked that reverse proxy identifies user correctly before sending request to nextcloud).

Such problem occurs rarely only on first page open (fresh session); after refreshing Nextcloud internal error page, spreed call page works ok with correct user identified.

Didn't notice such problem in other Nextcloud pages but log details contain "user":"--" in such situations so probably it's problem in user_saml not in spreed.

Similar error described in nextcloud/spreed#13517

server: v30.0.5
user_saml: v6.4.1
spreed: v20.1.3

Server configuration

Web server: Apache
Database: Maria
PHP version: 8.2

Browser

Browser name: Firefox
Browser version: 128 ESR 64-bit
Operating system: Linux

[pboguslawski]

Just noticed similar problem opening /apps/dashboard (but in earlier nc version /29/ with user_saml also) so probably it's not spreed problem:

{"reqId":"[...]","level":3,"time":"2024-10-13T12:05:18+00:00","remoteAddr":"[...]","user":"--","app":"index","method":"GET","url":"/apps/dashboard/","message":"{\"Exception\":\"OC\\\\DB\\\\Exceptions\\\\DbalException\",\"Message\":\"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'userid' cannot be null\",\"Code\":1048,\"Trace\":[{\"file\":\"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":328,\"function\":\"wrap\",\"class\":\"OC\\\\DB\\\\Exceptions\\\\DbalException\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php\",\"line\":477,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php\",\"line\":118,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AllConfig.php\",\"line\":297,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/apps/dashboard/lib/Controller/DashboardController.php\",\"line\":91,\"function\":\"setUserValue\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":232,\"function\":\"index\",\"class\":\"OCA\\\\Dashboard\\\\Controller\\\\DashboardController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":138,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/App.php\",\"line\":184,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/Route/Router.php\",\"line\":338,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/lib/base.php\",\"line\":1050,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php\",\"Line\":71,\"Previous\":{\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\NotNullConstraintViolationException\",\"Message\":\"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'userid' cannot be null\",\"Code\":1048,\"Trace\":[{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1943,\"function\":\"convert\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\API\\\\MySQL\\\\ExceptionConverter\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1885,\"function\":\"handleDriverException\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1213,\"function\":\"convertExceptionDuringQuery\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php\",\"line\":292,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php\",\"line\":373,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connections\\\\PrimaryReadReplicaConnection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php\",\"line\":393,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":280,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":326,\"function\":\"execute\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php\",\"line\":477,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php\",\"line\":118,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AllConfig.php\",\"line\":297,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/apps/dashboard/lib/Controller/DashboardController.php\",\"line\":91,\"function\":\"setUserValue\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":232,\"function\":\"index\",\"class\":\"OCA\\\\Dashboard\\\\Controller\\\\DashboardController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":138,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/App.php\",\"line\":184,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/Route/Router.php\",\"line\":338,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/lib/base.php\",\"line\":1050,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php\",\"Line\":114,\"Previous\":{\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'userid' cannot be null\",\"Code\":1048,\"Trace\":[{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php\",\"line\":132,\"function\":\"new\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1207,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Statement\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php\",\"line\":292,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php\",\"line\":373,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connections\\\\PrimaryReadReplicaConnection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php\",\"line\":393,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":280,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":326,\"function\":\"execute\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php\",\"line\":477,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php\",\"line\":118,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AllConfig.php\",\"line\":297,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/apps/dashboard/lib/Controller/DashboardController.php\",\"line\":91,\"function\":\"setUserValue\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":232,\"function\":\"index\",\"class\":\"OCA\\\\Dashboard\\\\Controller\\\\DashboardController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":138,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/App.php\",\"line\":184,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/Route/Router.php\",\"line\":338,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/lib/base.php\",\"line\":1050,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php\",\"Line\":28,\"Previous\":{\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'userid' cannot be null\",\"Code\":\"23000\",\"Trace\":[{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php\",\"line\":130,\"function\":\"execute\",\"class\":\"PDOStatement\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php\",\"line\":1207,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Statement\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php\",\"line\":292,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php\",\"line\":373,\"function\":\"executeStatement\",\"class\":\"Doctrine\\\\DBAL\\\\Connections\\\\PrimaryReadReplicaConnection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php\",\"line\":393,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":280,\"function\":\"execute\",\"class\":\"Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php\",\"line\":326,\"function\":\"execute\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php\",\"line\":477,\"function\":\"executeStatement\",\"class\":\"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php\",\"line\":118,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\Connection\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AllConfig.php\",\"line\":297,\"function\":\"setValues\",\"class\":\"OC\\\\DB\\\\ConnectionAdapter\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/apps/dashboard/lib/Controller/DashboardController.php\",\"line\":91,\"function\":\"setUserValue\",\"class\":\"OC\\\\AllConfig\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":232,\"function\":\"index\",\"class\":\"OCA\\\\Dashboard\\\\Controller\\\\DashboardController\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php\",\"line\":138,\"function\":\"executeController\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/AppFramework/App.php\",\"line\":184,\"function\":\"dispatch\",\"class\":\"OC\\\\AppFramework\\\\Http\\\\Dispatcher\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/lib/private/Route/Router.php\",\"line\":338,\"function\":\"main\",\"class\":\"OC\\\\AppFramework\\\\App\",\"type\":\"::\"},{\"file\":\"/var/www/nextcloud/lib/base.php\",\"line\":1050,\"function\":\"match\",\"class\":\"OC\\\\Route\\\\Router\",\"type\":\"->\"},{\"file\":\"/var/www/nextcloud/index.php\",\"line\":49,\"function\":\"handleRequest\",\"class\":\"OC\",\"type\":\"::\"}],\"File\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php\",\"Line\":130}}},\"message\":\"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'userid' cannot be null\",\"exception\":{},\"CustomMessage\":\"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'userid' cannot be null\"}","userAgent":"<Firefox 131.0","version":"29.0.2.2"}