file /var/lib/mysql/owncloud/oc_authtoken.ibd grows until there is no more space in disk

[miguel-negrao]

Steps to reproduce

1. Attempt to login via web interface or via client programs.

Expected behaviour

Be able to login and use owncloud

Actual behaviour

• cannot login, after accepting credentials just keeps in login page with a circle rotating.
• file /var/lib/mysql/owncloud/oc_authtoken.ibd grows until all space in the server is used. It grows by several megabytes in seconds.
• At that point mysql cannot work anymore and owncloud is not accessible.
  Currently:
  3,0G /var/lib/mysql/owncloud/oc_authtoken.ibd
  df -h /
  Filesystem Size Used Avail Use% Mounted on
  /dev/ploop56504p1 11G 11G 16M 100% /

Server configuration

Operating system:
Ubuntu 16.04.2 LTS

Web server:
apache2
Version: 2.4.18-2ubuntu3.2

Database:
Package: mysql-common
Version: 5.7.18-0ubuntu0.16.04.1

PHP version:
PHP Version 7.0.15-0ubuntu0.16.04.4

ownCloud version: (see ownCloud admin page)
9.1.4.2

Updated from an older ownCloud or fresh install:
fresh install

Where did you install ownCloud from:
tar file

Signing status (ownCloud 9.0 and above):

cannot login but occ integrity:core gives

https://pastebin.com/YHU6wWkg

The content of config/config.php:

{
    "system": {
        "instanceid": "ocjnrm2893b8",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***"
        ],
        "datadirectory": "\/var\/www\/html\/owncloud\/data",
        "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "9.1.4.2",
        "dbname": "owncloud",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "forcessl": true,
        "forceSSLforSubdomains": true,
        "theme": "",
        "loglevel": 0,
        "maintenance": false,
        "trashbin_retention_obligation": "auto",
        "ldapIgnoreNamingRules": false
    }
}

List of activated apps:

Enabled:
  - activity: 2.3.2
  - calendar: true
  - comments: 0.3.0
  - configreport: 0.1.1
  - contacts: true
  - dav: 0.2.7
  - federatedfilesharing: 0.3.0
  - federation: 0.1.0
  - files: 1.5.1
  - files_pdfviewer: 0.8.1
  - files_sharing: 0.10.0
  - files_texteditor: 2.1
  - files_trashbin: 0.9.0
  - files_versions: 1.3.0
  - files_videoplayer: 0.9.8
  - firstrunwizard: 1.1
  - gallery: 15.0.0
  - notifications: 0.3.0
  - provisioning_api: 0.5.0
  - shorten: 0.0.15
  - systemtags: 0.3.0
  - tasks: 0.9.4
  - templateeditor: 0.1
  - updatenotification: 0.2.1
Disabled:
  - encryption
  - external
  - files_antivirus
  - files_external
  - user_external
  - user_ldap

Are you using external storage, if yes which one: local/smb/sftp/...
no

Are you using encryption: yes/no
no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
don't think so...

Client configuration

Browser:
firefox 45.3.0

Operating system:
linux debian testing

Logs

server log

/var/log/apache2/error.log

[Tue May 16 16:27:28.435925 2017] [log_config:warn] [pid 7624] (28)No space left on device: [client 5.249.56.221:56498] AH00646: Error writing to /var/log/apache2/access.log

mysql error log

from journalctl
reverse order

Mai 16 16:10:51 mysqld[626]: FAIL170516 16:10:51 [ERROR] mysqld: The table 'oc_authtoken' is full
Mai 16 16:10:51 mysqld[626]: InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
Mai 16 16:10:51 mysqld[626]: InnoDB: Some operating system error numbers are described at
Mai 16 16:10:51 mysqld[626]: InnoDB: Error number 28 means 'No space left on device'.
Mai 16 16:10:51 mysqld[626]: InnoDB: Check also that the disk is not full or a disk quota exceeded.
Mai 16 16:10:51 mysqld[626]: InnoDB: Check that your OS and file system support files of this size.
Mai 16 16:10:51 mysqld[626]: InnoDB: Operating system error number 28.
Mai 16 16:10:51 mysqld[626]: InnoDB: 1048576 bytes should have been written, only 958464 were written.
Mai 16 16:10:51 mysqld[626]: 2017-05-16 16:10:51 7f66bdb31700 InnoDB: Error: Write to file ./owncloud/oc_authtoken.ibd failed at offset 3116
Mai 16 16:10:51 mysqld[626]: 170516 16:10:51 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:51 mysqld[626]: 170516 16:10:51 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:51 mysqld[626]: 170516 16:10:51 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:50 mysqld[626]: 170516 16:10:50 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:50 mysqld[626]: 170516 16:10:50 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:50 mysqld[626]: 170516 16:10:50 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:50 mysqld[626]: 170516 16:10:50 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:50 mysqld[626]: 170516 16:10:50 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:50 mysqld[626]: 170516 16:10:50 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:49 mysqld[626]: 170516 16:10:49 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:49 mysqld[626]: 170516 16:10:49 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:49 mysqld[626]: 170516 16:10:49 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:49 mysqld[626]: 170516 16:10:49 [Note] InnoDB: Space id 193 trying to reserve 3 extents actually reserved 256  reserve 31 free 
Mai 16 16:10:49 mysqld[626]: 170516 16:10:49 [Note] InnoDB: Space id 193 trying to reserve 3 extents actuall

ownCloud log (data/owncloud.log)

{"reqId":"REMOVED","remoteAddr":"REMOVED","app":"index","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_authtoken`(`uid`,`login_name`,`password`,`name`,`token`,`type`,`last_activity`) VALUES(?,?,?,?,?,?,?)' with params [\\\"REMOVED\\\", \\\"REMOVED\\\", \\\"REMOVED|REMOVED\\\", \\\"Mozilla\\\\\\\/5.0 (X11; Linux x86_64; rv:45.0) Gecko\\\\\\\/20100101 Firefox\\\\\\\/45.0\\\", \\\"REMOVED\\\", 0, 1494943796]:\\n\\nSQLSTATE[HY000]: General error: 1114 The table 'oc_authtoken' is full\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/html\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/var\\\/www\\\/html\\\/owncloud\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(174): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO `oc...', Array)\\n#2  ...

Browser log

Not relevant ?

[ownclouders]

Hey, this issue has been closed because the label status/STALE is set and there were no updates for 7 days. Feel free to reopen this issue if you deem it appropriate.

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.