Users take a long time to load and fields not showing correctly

Steps to reproduce

  1. Log in to your owncloud install via web with admin user.
  2. Access the users tab (index.php/settings/users)
  3. Wait for the load time to be epic and long.

Expected behaviour

The users table should load within a few seconds.

Actual behaviour

The users table shouldn’t take that long to load, I’m using regular users through database and nothing fancy like LDAP etc… and it takes ages to load I don’t even have 100 users and I would expect this to be faster as it makes it painfully long to add a new user or even manage the actual users.

Server configuration

Operating system: Ubuntu 18.04 LTS

Web server: Apache 2

Database: MySQL

PHP version: 7.2

ownCloud version: (see ownCloud admin page)
10.1.0.4

Updated from an older ownCloud or fresh install:
Fresh install

Where did you install ownCloud from:
Ubuntu repository

Signing status (ownCloud 9.0 and above):
(no clue what signing status is or where to get)

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

No errors have been found.

The content of config/config.php:

{
“system”: {
“updatechecker”: false,
“instanceid”: “oc9z25lemgxh”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“34.94.237.125”,
“cloud.mitu.pw”
],
“datadirectory”: “/mnt/cloud-mitu/cloud-data”,
“overwrite.cli.url”: “http://34.94.237.125”,
“dbtype”: “mysql”,
“version”: “10.1.0.4”,
“dbname”: “the-last-hope”,
“dbhost”: “130.211.207.85”,
“dbtableprefix”: “oc_”,
“dbuser”: “REMOVED SENSITIVE VALUE”,
“dbpassword”: “REMOVED SENSITIVE VALUE”,
“logtimezone”: “UTC”,
“installed”: true,
“maintenance”: false,
“skeletondirectory”: “”,
“files_external_allow_create_new_local”: true,
“log_type”: “owncloud”,
“logfile”: “owncloud.log”,
“loglevel”: “3”,
“mail_from_address”: “REMOVED SENSITIVE VALUE”,
“mail_smtpmode”: “smtp”,
“mail_domain”: “REMOVED SENSITIVE VALUE”,
“mail_smtpauthtype”: “LOGIN”,
“mail_smtpauth”: 1,
“mail_smtphost”: “REMOVED SENSITIVE VALUE”,
“mail_smtpport”: “587”,
“mail_smtpname”: “REMOVED SENSITIVE VALUE”,
“mail_smtppassword”: “REMOVED SENSITIVE VALUE”,
“mail_smtpsecure”: “tls”,
“integrity.ignore.missing.app.signature”: [
“theme-mitu”
],
“memcache.local”: “\OC\Memcache\Redis”,
“redis”: {
“host”: “10.168.0.5”,
“port”: 6379,
“password”: “REMOVED SENSITIVE VALUE
},
“memcache.locking”: “\OC\Memcache\Redis”,
“filelocking.enabled”: true
}
}

List of activated apps:

Enabled:

  • comments: 0.3.0
  • configreport: 0.1.1
  • dav: 0.4.0
  • federatedfilesharing: 0.3.1
  • federation: 0.1.0
  • files: 1.5.1
  • files_external: 0.7.1
  • files_sharing: 0.11.0
  • files_trashbin: 0.9.1
  • files_versions: 1.3.0
  • firstrunwizard: 1.1
  • market: 0.3.0
  • notifications: 0.4.1
  • provisioning_api: 0.5.0
  • systemtags: 0.3.0
  • theme-mitu: 1.0.0
  • updatenotification: 0.2.1
    Disabled:
  • encryption
  • external
  • files_videoplayer
  • user_external

Are you using external storage, if yes which one: local/smb/sftp/…
Yes, I have logs into the data folder and the rest of the accounts for users etc I use “gcsfuse” to mount a Google Storage Bucket to use as “main storage” since it only supports Amazon S3.

Are you using encryption:
no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
No

Client configuration

Browser:
Google Chrome

Operating system:
Mac OS High Sierra

ownCloud log (data/owncloud.log)

cat data/owncloud.log
{"reqId":"jJc2yyLpsHIfsSWgrkEc","level":3,"time":"2019-06-22T18:08:15+00:00","remoteAddr":"187.254.104.115","user":"--","app":"no app in context","method":"POST","url":"\/index.php","message":"User backend OC\\User\\Database is returning home: \/var\/www\/owncloud\/data\/admin for user: admin which differs from existing value: "}
{"reqId":"E0SHcLBhGYFsAlLH4Wza","level":2,"time":"2019-06-22T19:03:18+00:00","remoteAddr":"80.14.152.87","user":"--","app":"core","method":"GET","url":"\/","message":"Trusted domain error. \"80.14.152.87\" tried to access using \"mitu-cloud-testing.c.pepino-mitu-moto.internal\" as host."}

Browser log

a) The javascript console log
js.js?v=a63c8881a74e…98529f837e9a58:1088 Missing argument $row in OC.Notification.hide() call, caller needs to be adjusted to only dismiss its own notification
hide	@	js.js?v=a63c8881a74e…98529f837e9a58:1088
initDeleteHandling	@	users.js?v=a63c8881a…e98529f837e9a58:370
(anonymous)	@	users.js?v=a63c8881a…e98529f837e9a58:701
j	@	jquery.js:3099
fireWith	@	jquery.js:3211
ready	@	jquery.js:3417
I	@	jquery.js:3433

b) The network log 
I actually get a good response back but takes at least 3-5 min to load

checked default installation with ubuntu 16.04, php 7.1, mysql, apache 2.4 and 100 users: it works fine. It finish loading the page in around 6-7 secs for OC 10.1.0 and a bit faster (around 5.5 secs) for 10.2.1. Since my setup is running through local network connection (mysql, the server and the web), you can add some seconds, but I’m pretty sure it should take less than 10 secs to have the page ready, very far from those 3-5 minutes it takes for you.

If you say the problem is loading the page and not the network connection, you can try to disable your custom theme. Also check with a different browser.

I would start here:

  • Was the storage location moved somewhere?
  • Is it on an external disk?

As far as I know, that’s pretty common when you’re creating new users. I think there wasn’t any value before setting that one, so there shouldn’t be any problem there.

Hey,

personally i would start with updating this outdated version to the more recent 10.2.1.