User status not sticky since 28.0.4

cooper · April 8, 2024, 5:55pm

Nextcloud version : 28.0.4
Operating system and version: FreeBSD 13.2-RELEASE-p11
Apache or nginx version: Apache 2.4.59
PHP version: 8.2.17
Database backend: MySQL 8.0.35

The issue you are facing:

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

Set a status
After some random times (~5-18min) user’s status is set back to “meeting”

Hello all,

After doing the minor update from 28.0.3 to 28.0.4 with FreeBSD’s package manager and doing the usual occ upgrade, any users can’t make a status sticky; still set back to “meeting” status.
Any insights on how to prevent this to occurs?

Cheers

The output of your Nextcloud log in Admin > Logging:

{
	"reqId": "btsoi9w3OfCIYPKNAJMX",
	"level": 3,
	"time": "2024-04-08T16:48:20+00:00",
	"remoteAddr": "<REDACTED_FOR_PRIVACY>",
	"user": "bob",
	"app": "no app in context",
	"method": "PUT",
	"url": "/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json",
	"message": "Exception thrown: OC\\DB\\Exceptions\\DbalException",
	"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36",
	"version": "28.0.4.1",
	"exception": {
		"Exception": "OC\\DB\\Exceptions\\DbalException",
		"Message": "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bob' for key 'oc_user_status.user_status_uid_ix'",
		"Code": 1062,
		"Trace": [
			{
				"file": "/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
				"line": 328,
				"function": "wrap",
				"class": "OC\\DB\\Exceptions\\DbalException",
				"type": "::"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
				"line": 137,
				"function": "executeStatement",
				"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Service/StatusService.php",
				"line": 311,
				"function": "insert",
				"class": "OCP\\AppFramework\\Db\\QBMapper",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/apps-pkg/dav/lib/CalDAV/Status/StatusService.php",
				"line": 134,
				"function": "setUserStatus",
				"class": "OCA\\UserStatus\\Service\\StatusService",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Listener/UserLiveStatusListener.php",
				"line": 73,
				"function": "processCalendarStatus",
				"class": "OCA\\DAV\\CalDAV\\Status\\StatusService",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php",
				"line": 86,
				"function": "handle",
				"class": "OCA\\UserStatus\\Listener\\UserLiveStatusListener",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
				"line": 230,
				"function": "__invoke",
				"class": "OC\\EventDispatcher\\ServiceEventListener",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
				"line": 59,
				"function": "callListeners",
				"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
				"line": 94,
				"function": "dispatch",
				"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
				"line": 106,
				"function": "dispatch",
				"class": "OC\\EventDispatcher\\EventDispatcher",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Controller/HeartbeatController.php",
				"line": 100,
				"function": "dispatchTyped",
				"class": "OC\\EventDispatcher\\EventDispatcher",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
				"line": 230,
				"function": "heartbeat",
				"class": "OCA\\UserStatus\\Controller\\HeartbeatController",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
				"line": 137,
				"function": "executeController",
				"class": "OC\\AppFramework\\Http\\Dispatcher",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/private/AppFramework/App.php",
				"line": 184,
				"function": "dispatch",
				"class": "OC\\AppFramework\\Http\\Dispatcher",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/lib/private/Route/Router.php",
				"line": 315,
				"function": "main",
				"class": "OC\\AppFramework\\App",
				"type": "::"
			},
			{
				"file": "/usr/local/www/nextcloud/ocs/v1.php",
				"line": 65,
				"function": "match",
				"class": "OC\\Route\\Router",
				"type": "->"
			},
			{
				"file": "/usr/local/www/nextcloud/ocs/v2.php",
				"line": 23,
				"args": [
					"/usr/local/www/nextcloud/ocs/v1.php"
				],
				"function": "require_once"
			}
		],
		"File": "/usr/local/www/nextcloud/lib/private/DB/Exceptions/DbalException.php",
		"Line": 71,
		"Previous": {
			"Exception": "Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException",
			"Message": "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bob' for key 'oc_user_status.user_status_uid_ix'",
			"Code": 1062,
			"Trace": [
				{
					"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
					"line": 1938,
					"function": "convert",
					"class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
					"line": 1880,
					"function": "handleDriverException",
					"class": "Doctrine\\DBAL\\Connection",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
					"line": 1208,
					"function": "convertExceptionDuringQuery",
					"class": "Doctrine\\DBAL\\Connection",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/DB/Connection.php",
					"line": 294,
					"function": "executeStatement",
					"class": "Doctrine\\DBAL\\Connection",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
					"line": 386,
					"function": "executeStatement",
					"class": "OC\\DB\\Connection",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
					"line": 280,
					"function": "execute",
					"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
					"line": 326,
					"function": "execute",
					"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
					"line": 137,
					"function": "executeStatement",
					"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Service/StatusService.php",
					"line": 311,
					"function": "insert",
					"class": "OCP\\AppFramework\\Db\\QBMapper",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/apps-pkg/dav/lib/CalDAV/Status/StatusService.php",
					"line": 134,
					"function": "setUserStatus",
					"class": "OCA\\UserStatus\\Service\\StatusService",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Listener/UserLiveStatusListener.php",
					"line": 73,
					"function": "processCalendarStatus",
					"class": "OCA\\DAV\\CalDAV\\Status\\StatusService",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php",
					"line": 86,
					"function": "handle",
					"class": "OCA\\UserStatus\\Listener\\UserLiveStatusListener",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
					"line": 230,
					"function": "__invoke",
					"class": "OC\\EventDispatcher\\ServiceEventListener",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
					"line": 59,
					"function": "callListeners",
					"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
					"line": 94,
					"function": "dispatch",
					"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
					"line": 106,
					"function": "dispatch",
					"class": "OC\\EventDispatcher\\EventDispatcher",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Controller/HeartbeatController.php",
					"line": 100,
					"function": "dispatchTyped",
					"class": "OC\\EventDispatcher\\EventDispatcher",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
					"line": 230,
					"function": "heartbeat",
					"class": "OCA\\UserStatus\\Controller\\HeartbeatController",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
					"line": 137,
					"function": "executeController",
					"class": "OC\\AppFramework\\Http\\Dispatcher",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/AppFramework/App.php",
					"line": 184,
					"function": "dispatch",
					"class": "OC\\AppFramework\\Http\\Dispatcher",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/lib/private/Route/Router.php",
					"line": 315,
					"function": "main",
					"class": "OC\\AppFramework\\App",
					"type": "::"
				},
				{
					"file": "/usr/local/www/nextcloud/ocs/v1.php",
					"line": 65,
					"function": "match",
					"class": "OC\\Route\\Router",
					"type": "->"
				},
				{
					"file": "/usr/local/www/nextcloud/ocs/v2.php",
					"line": 23,
					"args": [
						"/usr/local/www/nextcloud/ocs/v1.php"
					],
					"function": "require_once"
				}
			],
			"File": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
			"Line": 62,
			"Previous": {
				"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
				"Message": "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bob' for key 'oc_user_status.user_status_uid_ix'",
				"Code": 1062,
				"Trace": [
					{
						"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
						"line": 132,
						"function": "new",
						"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
						"type": "::"
					},
					{
						"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
						"line": 1202,
						"function": "execute",
						"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/DB/Connection.php",
						"line": 294,
						"function": "executeStatement",
						"class": "Doctrine\\DBAL\\Connection",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
						"line": 386,
						"function": "executeStatement",
						"class": "OC\\DB\\Connection",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
						"line": 280,
						"function": "execute",
						"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
						"line": 326,
						"function": "execute",
						"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
						"line": 137,
						"function": "executeStatement",
						"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Service/StatusService.php",
						"line": 311,
						"function": "insert",
						"class": "OCP\\AppFramework\\Db\\QBMapper",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/apps-pkg/dav/lib/CalDAV/Status/StatusService.php",
						"line": 134,
						"function": "setUserStatus",
						"class": "OCA\\UserStatus\\Service\\StatusService",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Listener/UserLiveStatusListener.php",
						"line": 73,
						"function": "processCalendarStatus",
						"class": "OCA\\DAV\\CalDAV\\Status\\StatusService",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php",
						"line": 86,
						"function": "handle",
						"class": "OCA\\UserStatus\\Listener\\UserLiveStatusListener",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
						"line": 230,
						"function": "__invoke",
						"class": "OC\\EventDispatcher\\ServiceEventListener",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
						"line": 59,
						"function": "callListeners",
						"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
						"line": 94,
						"function": "dispatch",
						"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
						"line": 106,
						"function": "dispatch",
						"class": "OC\\EventDispatcher\\EventDispatcher",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Controller/HeartbeatController.php",
						"line": 100,
						"function": "dispatchTyped",
						"class": "OC\\EventDispatcher\\EventDispatcher",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
						"line": 230,
						"function": "heartbeat",
						"class": "OCA\\UserStatus\\Controller\\HeartbeatController",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
						"line": 137,
						"function": "executeController",
						"class": "OC\\AppFramework\\Http\\Dispatcher",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/AppFramework/App.php",
						"line": 184,
						"function": "dispatch",
						"class": "OC\\AppFramework\\Http\\Dispatcher",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/lib/private/Route/Router.php",
						"line": 315,
						"function": "main",
						"class": "OC\\AppFramework\\App",
						"type": "::"
					},
					{
						"file": "/usr/local/www/nextcloud/ocs/v1.php",
						"line": 65,
						"function": "match",
						"class": "OC\\Route\\Router",
						"type": "->"
					},
					{
						"file": "/usr/local/www/nextcloud/ocs/v2.php",
						"line": 23,
						"args": [
							"/usr/local/www/nextcloud/ocs/v1.php"
						],
						"function": "require_once"
					}
				],
				"File": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
				"Line": 28,
				"Previous": {
					"Exception": "PDOException",
					"Message": "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bob' for key 'oc_user_status.user_status_uid_ix'",
					"Code": "23000",
					"Trace": [
						{
							"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
							"line": 130,
							"function": "execute",
							"class": "PDOStatement",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
							"line": 1202,
							"function": "execute",
							"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/DB/Connection.php",
							"line": 294,
							"function": "executeStatement",
							"class": "Doctrine\\DBAL\\Connection",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
							"line": 386,
							"function": "executeStatement",
							"class": "OC\\DB\\Connection",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
							"line": 280,
							"function": "execute",
							"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
							"line": 326,
							"function": "execute",
							"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
							"line": 137,
							"function": "executeStatement",
							"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Service/StatusService.php",
							"line": 311,
							"function": "insert",
							"class": "OCP\\AppFramework\\Db\\QBMapper",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/apps-pkg/dav/lib/CalDAV/Status/StatusService.php",
							"line": 134,
							"function": "setUserStatus",
							"class": "OCA\\UserStatus\\Service\\StatusService",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Listener/UserLiveStatusListener.php",
							"line": 73,
							"function": "processCalendarStatus",
							"class": "OCA\\DAV\\CalDAV\\Status\\StatusService",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php",
							"line": 86,
							"function": "handle",
							"class": "OCA\\UserStatus\\Listener\\UserLiveStatusListener",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
							"line": 230,
							"function": "__invoke",
							"class": "OC\\EventDispatcher\\ServiceEventListener",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
							"line": 59,
							"function": "callListeners",
							"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
							"line": 94,
							"function": "dispatch",
							"class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
							"line": 106,
							"function": "dispatch",
							"class": "OC\\EventDispatcher\\EventDispatcher",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/apps-pkg/user_status/lib/Controller/HeartbeatController.php",
							"line": 100,
							"function": "dispatchTyped",
							"class": "OC\\EventDispatcher\\EventDispatcher",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
							"line": 230,
							"function": "heartbeat",
							"class": "OCA\\UserStatus\\Controller\\HeartbeatController",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
							"line": 137,
							"function": "executeController",
							"class": "OC\\AppFramework\\Http\\Dispatcher",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/AppFramework/App.php",
							"line": 184,
							"function": "dispatch",
							"class": "OC\\AppFramework\\Http\\Dispatcher",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/lib/private/Route/Router.php",
							"line": 315,
							"function": "main",
							"class": "OC\\AppFramework\\App",
							"type": "::"
						},
						{
							"file": "/usr/local/www/nextcloud/ocs/v1.php",
							"line": 65,
							"function": "match",
							"class": "OC\\Route\\Router",
							"type": "->"
						},
						{
							"file": "/usr/local/www/nextcloud/ocs/v2.php",
							"line": 23,
							"args": [
								"/usr/local/www/nextcloud/ocs/v1.php"
							],
							"function": "require_once"
						}
					],
					"File": "/usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
					"Line": 130
				}
			}
		},
		"CustomMessage": "Exception thrown: OC\\DB\\Exceptions\\DbalException"
	},
	"id": "661427729a883"
}

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'apps_paths' => 
  array (
    0 => 
    array (
      'path' => '/usr/local/www/nextcloud/apps',
      'url' => '/apps',
      'writable' => true,
    ),
    1 => 
    array (
      'path' => '/usr/local/www/nextcloud/apps-pkg',
      'url' => '/apps-pkg',
      'writable' => false,
    ),
  ),
  'logfile' => '/var/log/nextcloud/nextcloud.log',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'filelocking.enabled' => true,
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,
    'timeout' => 0.0,
  ),
  'instanceid' => '<REDACTED_FOR_PRIVACY>',
  'passwordsalt' => '<REDACTED_FOR_PRIVACY>',
  'secret' => '<REDACTED_FOR_PRIVACY>',
  'trusted_domains' => 
  array (
    0 => 'nc.example.net',
  ),
  'datadirectory' => '/usr/local/www/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '28.0.4.1',
  'overwrite.cli.url' => 'https://nc.example.net',
  'htaccess.RewriteBase' => '/',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'oc_bob',
  'dbpassword' => '<REDACTED_FOR_PRIVACY>',
  'installed' => true,
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_sendmailmode' => 'smtp',
  'default_locale' => 'fr_FR',
  'default_language' => 'fr',
  'default_phone_region' => 'FR',
  'maintenance_window_start' => 1,
  'mail_from_address' => 'nc',
  'mail_domain' => 'example.net',
  'mail_smtphost' => 'smtp.example.net',
  'mail_smtpport' => '465',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'bob@example.net',
  'mail_smtppassword' => '<REDACTED_FOR_PRIVACY>',
  'defaultapp' => '',
  'knowledgebaseenabled' => true,
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'integrity.check.disabled' => false,
  'skeletondirectory' => '',
);

The output of your Apache/nginx/system log in /var/log/____:
access.log

[08/04/2024:18:48:20] "GET /ocs/v2.php/apps/guests/api/v1/groups HTTP/2.0" 200 188 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /apps/theming/favicon/files?v=a144bfd0 HTTP/2.0" 304 - "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /ocs/v2.php/apps/user_status/api/v1/user_status HTTP/2.0" 200 173 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "PUT /ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json HTTP/2.0" 500 100 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /avatar/bob/64?v=3 HTTP/2.0" 304 - "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/2.0" 200 81 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /avatar/alain/32 HTTP/2.0" 304 - "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /index.php/apps/files/preview-service-worker.js HTTP/2.0" 200 14649 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /apps/theming/manifest/files?v=a144bfd0 HTTP/2.0" 200 260 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /apps/theming/icon/files?v=33 HTTP/2.0" 304 - "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"
[08/04/2024:18:48:20] "GET /apps/dashboard/ HTTP/2.0" 200 14103 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36"

error.log

cooper · April 12, 2024, 1:25pm

Just an update about how I could resolved this problem.

A user’s status is tighly tied to events status (BUSY or FREE):

https://docs.nextcloud.com/server/28/user_manual/en/groupware/calendar.html#automated-user-status

So whenever an event has a BUSY status, user’s status is automatically set to “In meeting”.

Hope this help others as to why their status could change automatically

system · April 20, 2024, 1:25pm

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.