MySQL binlog growing fast after update

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version : 21.0.1.1
Operating system and version: Ubuntu 20.04
Apache or nginx version Apache 2.4.41

PHP version : 7.4.3
MySQL Ver 8.0.23-

MySQL Logfiles “binlog” in var/lib/mysql are filling up the SSD. Roundabout every hour a 100 MB binlog file is generated. I’ve about 115 of those files now (most are hidden) and ran out of disk space.
What can I do to get rid of those files? In the below article it says the below commands (example) may purge the data, but I’m not sure of the impact for the DB.

PURGE BINARY LOGS TO 'mysql-bin.010';
PURGE BINARY LOGS BEFORE '2019-04-02 22:46:26';

I suspect the OnlyOffice document server has something to do with it, but I’m not sure.

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

Steps to replicate it:

  1. update from Nextcloud 20
  2. no specific steps

I’ve found an issue related to binlog which is very similar to what I have, even though it’s not related to Nextcloud

The output of your Nextcloud log in Admin > Logging:

0x7f0194096a92]\n [0x7f01934ad3c0]\n [0x7f0194095849]\n [0x7f01938b1072]\n [0x7f01938a5fb1]\n [0x7f0193873ebe]\n [0x7f019386a643]\n [0x000000748550]\n [0x00000076011b]\n [0x000000767895]\n [0x00000076af1d]\n [0x00000054034f]\n [0x7f019317e0b3]\n [0x000000745f93]\n[end of stack trace]\nIllegal instruction (core dumped)\n","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/documentserver_community/lib/DocumentConverter.php","line":125,"function":"run","class":"OCA\\DocumentServer\\Document\\ConverterBinary","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/DocumentConverter.php","line":80,"function":"runCommand","class":"OCA\\DocumentServer\\DocumentConverter","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/DocumentStore.php","line":156,"function":"saveChanges","class":"OCA\\DocumentServer\\DocumentConverter","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/LocalAppData.php","line":102,"function":"OCA\\DocumentServer\\Document\\{closure}","class":"OCA\\DocumentServer\\Document\\DocumentStore","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/DocumentStore.php","line":176,"function":"getReadWriteLocalPath","class":"OCA\\DocumentServer\\LocalAppData","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/SaveHandler.php","line":58,"function":"saveChanges","class":"OCA\\DocumentServer\\Document\\DocumentStore","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/BackgroundJob/Cleanup.php","line":71,"function":"flushChanges","class":"OCA\\DocumentServer\\Document\\SaveHandler","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\DocumentServer\\BackgroundJob\\Cleanup","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"}],"File":"/var/www/nextcloud/apps/documentserver_community/lib/Document/ConverterBinary.php","Line":66,"CustomMessage":"Error while applying changes for document 1855341689"},"userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":3,"time":"2021-05-08T01:35:09+00:00","remoteAddr":"","user":"--","app":"documentserver_community","method":"","url":"--","message":{"Exception":"OCA\\DocumentServer\\Document\\DocumentConversionException","Message":"\n#\n# Fatal error in v8::ToLocalChecked\n# Empty MaybeLocal.\n#\n\nReceived signal 4 ILL_ILLOPN 7fba76bee849\n\n==== C stack trace ===============================\n\n [0x7fba76befa92]\n [0x7fba760063c0]\n [0x7fba76bee849]\n [0x7fba7640a072]\n [0x7fba763fefb1]\n [0x7fba763ccebe]\n [0x7fba763c3643]\n [0x000000748550]\n [0x00000076011b]\n [0x000000767895]\n [0x00000076af1d]\n [0x00000054034f]\n [0x7fba75cd70b3]\n [0x000000745f93]\n[end of stack trace]\nIllegal instruction (core dumped)\n","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/documentserver_community/lib/DocumentConverter.php","line":125,"function":"run","class":"OCA\\DocumentServer\\Document\\ConverterBinary","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/DocumentConverter.php","line":80,"function":"runCommand","class":"OCA\\DocumentServer\\DocumentConverter","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/DocumentStore.php","line":156,"function":"saveChanges","class":"OCA\\DocumentServer\\DocumentConverter","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/LocalAppData.php","line":102,"function":"OCA\\DocumentServer\\Document\\{closure}","class":"OCA\\DocumentServer\\Document\\DocumentStore","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/DocumentStore.php","line":176,"function":"getReadWriteLocalPath","class":"OCA\\DocumentServer\\LocalAppData","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/SaveHandler.php","line":58,"function":"saveChanges","class":"OCA\\DocumentServer\\Document\\DocumentStore","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/BackgroundJob/Cleanup.php","line":71,"function":"flushChanges","class":"OCA\\DocumentServer\\Document\\SaveHandler","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\DocumentServer\\BackgroundJob\\Cleanup","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"}],"File":"/var/www/nextcloud/apps/documentserver_community/lib/Document/ConverterBinary.php","Line":66,"CustomMessage":"Error while applying changes for document 2147516186"},"userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":3,"time":"2021-05-08T01:35:14+00:00","remoteAddr":"","user":"--","app":"documentserver_community","method":"","url":"--","message":{"Exception":"OCA\\DocumentServer\\Document\\DocumentConversionException","Message":"\n#\n# Fatal error in v8::ToLocalChecked\n# Empty MaybeLocal.\n#\n\nReceived signal 4 ILL_ILLOPN 7f3eb2d88849\n\n==== C stack trace ===============================\n\n [0x7f3eb2d89a92]\n [0x7f3eb21a03c0]\n [0x7f3eb2d88849]\n [0x7f3eb25a4072]\n [0x7f3eb2598fb1]\n [0x7f3eb2566ebe]\n [0x7f3eb255d643]\n [0x000000748550]\n [0x00000074eefe]\n [0x000000768bda]\n [0x00000076aeec]\n [0x00000054034f]\n [0x7f3eb1e710b3]\n [0x000000745f93]\n[end of stack trace]\nIllegal instruction (core dumped)\n","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/documentserver_community/lib/DocumentConverter.php","line":125,"function":"run","class":"OCA\\DocumentServer\\Document\\ConverterBinary","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/DocumentConverter.php","line":80,"function":"runCommand","class":"OCA\\DocumentServer\\DocumentConverter","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/DocumentStore.php","line":156,"function":"saveChanges","class":"OCA\\DocumentServer\\DocumentConverter","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/LocalAppData.php","line":102,"function":"OCA\\DocumentServer\\Document\\{closure}","class":"OCA\\DocumentServer\\Document\\DocumentStore","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/DocumentStore.php","line":176,"function":"getReadWriteLocalPath","class":"OCA\\DocumentServer\\LocalAppData","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/SaveHandler.php","line":58,"function":"saveChanges","class":"OCA\\DocumentServer\\Document\\DocumentStore","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/BackgroundJob/Cleanup.php","line":71,"function":"flushChanges","class":"OCA\\DocumentServer\\Document\\SaveHandler","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\DocumentServer\\BackgroundJob\\Cleanup","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"}],"File":"/var/www/nextcloud/apps/documentserver_community/lib/Document/ConverterBinary.php","Line":66,"CustomMessage":"Error while applying changes for document 3042386676"},"userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":3,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"documentserver_community","method":"","url":"--","message":{"Exception":"OCP\\Files\\NotFoundException","Message":"/appdata_ocbv7pfxu3wi/documentserver_community/doc_896313357/owner","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/Files/Node/Folder.php","line":149,"function":"get","class":"OC\\Files\\Node\\Root","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":76,"function":"get","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/DocumentStore.php","line":137,"function":"getFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/Document/SaveHandler.php","line":58,"function":"saveChanges","class":"OCA\\DocumentServer\\Document\\DocumentStore","type":"->"},{"file":"/var/www/nextcloud/apps/documentserver_community/lib/BackgroundJob/Cleanup.php","line":71,"function":"flushChanges","class":"OCA\\DocumentServer\\Document\\SaveHandler","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\DocumentServer\\BackgroundJob\\Cleanup","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"}],"File":"/var/www/nextcloud/lib/private/Files/Node/Root.php","Line":205,"CustomMessage":"Error while applying changes for document 896313357"},"userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\DocumentServer\\BackgroundJob\\Cleanup job with ID 37 in 13 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Polls\\Cron\\NotificationCron job with ID 41","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Polls\\Cron\\NotificationCron job with ID 41 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Deck\\Cron\\DeleteCron job with ID 44","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Deck\\Cron\\DeleteCron job with ID 44 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Deck\\Cron\\ScheduledNotifications job with ID 45","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Deck\\Cron\\ScheduledNotifications job with ID 45 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Deck\\Cron\\CardDescriptionActivity job with ID 46","userAgent":"--","version":"21.0.1.1"}
{"reqId":"FgRYSyeCGJ2Rmav4tFAA","level":0,"time":"2021-05-08T01:35:15+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Deck\\Cron\\CardDescriptionActivity job with ID 46 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"contacts","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"documentserver_community","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"files_texteditor","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"onlyoffice","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash job with ID 5","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash job with ID 5 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Files_Versions\\BackgroundJob\\ExpireVersions job with ID 6","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Files_Versions\\BackgroundJob\\ExpireVersions job with ID 6 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Files\\BackgroundJob\\CleanupFileLocks job with ID 9","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Files\\BackgroundJob\\CleanupFileLocks job with ID 9 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Support\\BackgroundJobs\\CheckSubscription job with ID 11","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Support\\BackgroundJobs\\CheckSubscription job with ID 11 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OC\\Authentication\\Token\\DefaultTokenCleanupJob job with ID 19","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Invalidating session tokens older than 2021-05-07T01:40:02+00:00","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Invalidating remembered session tokens older than 2021-04-23T01:40:02+00:00","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Invalidating session tokens older than 2021-05-07T01:40:02+00:00","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Invalidating remembered session tokens older than 2021-04-23T01:40:02+00:00","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OC\\Authentication\\Token\\DefaultTokenCleanupJob job with ID 19 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OC\\Log\\Rotate job with ID 20","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OC\\Log\\Rotate job with ID 20 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\DAV\\BackgroundJob\\EventReminderJob job with ID 30","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\DAV\\BackgroundJob\\EventReminderJob job with ID 30 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Text\\Cron\\Cleanup job with ID 31","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"text","method":"","url":"--","message":"Run cleanup job for text sessions","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"text","method":"","url":"--","message":"Removed 0 inactive sessions","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Text\\Cron\\Cleanup job with ID 31 in 0 seconds","userAgent":"--","version":"21.0.1.1"}
{"reqId":"QItdJmhTcCzNI6nPkRmY","level":0,"time":"2021-05-08T01:40:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\DocumentServer\\BackgroundJob\\Cleanup job with ID 37","userAgent":"--","version":"21.0.1.1"}
{"reqId":"x0u5P7acK2uUzJ0azmIf","level":0,"time":"2021-05-08T01:45:02+00:00","remoteAddr":"","user":"--","app":"contacts","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"x0u5P7acK2uUzJ0azmIf","level":0,"time":"2021-05-08T01:45:02+00:00","remoteAddr":"","user":"--","app":"documentserver_community","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"x0u5P7acK2uUzJ0azmIf","level":0,"time":"2021-05-08T01:45:02+00:00","remoteAddr":"","user":"--","app":"files_sharing","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"x0u5P7acK2uUzJ0azmIf","level":0,"time":"2021-05-08T01:45:02+00:00","remoteAddr":"","user":"--","app":"files_texteditor","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"x0u5P7acK2uUzJ0azmIf","level":0,"time":"2021-05-08T01:45:02+00:00","remoteAddr":"","user":"--","app":"onlyoffice","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"reqId":"8BG4OCfYfSk2l2tEG4I8","level":0,"time":"2021-05-08T01:50:02+00:00","remoteAddr":"","user":"--","app":"contacts","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"21.0.1.1"}
{"re

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


$CONFIG = array (
  'passwordsalt' => '4FdSx+DE',
  'secret' => 'x33RlsECPKX',
  'trusted_domains' => 
  array (
    0 => 'localhost',
    1 => '',
    2 => '',
    3 => '.',
    4 => 'www..de',

 'datadirectory' => '/var/www/nextcloud/data',
  'default_language' => 'de',
  'dbtype' => 'mysql',
  'version' => '21.0.1.1',
  'overwrite.cli.url' => 'http://localhost',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => '',
  'installed' => true,
  'instanceid' => 'ocbv7p',
  'maintenance' => true,
  'theme' => '',
  'loglevel' => 0,
  'mail_from_address' => 'nc_sendmail',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => '',
  'mail_smtpauth' => 1,
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpsecure' => 'tls',
  'mail_smtphost' => '',
  'mail_smtpport' => '587',
  'mail_smtpname' => 'nc_sendmail',
  'mail_smtppassword' => '',
  'updater.secret' => '$6',
  'default_phone_region' => 'DE',

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

[Sat May 08 00:00:03.608108 2021] [mpm_prefork:notice] [pid 686] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations
[Sat May 08 00:00:03.608170 2021] [core:notice] [pid 686] AH00094: Command line: '/usr/sbin/apache2'
[Sat May 08 00:00:46.430508 2021] [access_compat:error] [pid 55948] [client 176.127.247.155:65430] AH01797: client denied by server configuration: /var/www/nextcloud/config
[Sat May 08 00:05:55.354548 2021] [php7:notice] [pid 55936] [client 77.185.48.16:36422] PHP Notice:  fwrite(): write of 1423 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.355386 2021] [php7:notice] [pid 55936] [client 77.185.48.16:36422] PHP Notice:  fwrite(): write of 1424 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.357165 2021] [php7:notice] [pid 55936] [client 77.185.48.16:36422] PHP Notice:  fwrite(): write of 1424 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.419464 2021] [php7:notice] [pid 55936] [client 77.185.48.16:36422] PHP Notice:  fwrite(): write of 3311 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.817542 2021] [php7:notice] [pid 55946] [client 77.185.48.16:36424] PHP Notice:  fwrite(): write of 2002 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.825961 2021] [php7:notice] [pid 55946] [client 77.185.48.16:36424] PHP Notice:  fwrite(): write of 1434 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.826653 2021] [php7:notice] [pid 55946] [client 77.185.48.16:36424] PHP Notice:  fwrite(): write of 1434 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.828024 2021] [php7:notice] [pid 55946] [client 77.185.48.16:36424] PHP Notice:  fwrite(): write of 1434 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:55.855273 2021] [php7:notice] [pid 55946] [client 77.185.48.16:36424] PHP Notice:  fwrite(): write of 3321 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:56.095528 2021] [php7:notice] [pid 55945] [client 77.185.48.16:36428] PHP Notice:  fwrite(): write of 2002 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:56.103981 2021] [php7:notice] [pid 55945] [client 77.185.48.16:36428] PHP Notice:  fwrite(): write of 1434 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:56.104649 2021] [php7:notice] [pid 55945] [client 77.185.48.16:36428] PHP Notice:  fwrite(): write of 1434 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:56.110248 2021] [php7:notice] [pid 55945] [client 77.185.48.16:36428] PHP Notice:  fwrite(): write of 1434 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:05:56.132540 2021] [php7:notice] [pid 55945] [client 77.185.48.16:36428] PHP Notice:  fwrite(): write of 3321 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:06:38.222684 2021] [php7:notice] [pid 55953] [client 2003:ed:718:d800:91c9:b766:f980:e1f2:38641] PHP Notice:  fwrite(): write of 2058 bytes failed with errno=28 No space left on device in /var/www/nextcloud/lib/private/Log/File.php on line 90
[Sat May 08 00:06:38.230548 2021] [php7:notice] [pid 55953] [client 2003:ed:718:d800:91c9:b766:f980:e1f2:38641] PHP Notice:  fwrite(): 

I did delete the binlog files with these commands

mysql -uroot -p
PURGE BINARY LOGS BEFORE '2019-04-02 22:46:26';

my config.php in nextcloud/config/ - was also broken. I had to restore it. Not sure if the issue will be fixed now. I will see if the logs will start growing fast again.

the culprit is found. It is log messages or core dumps that let the binlog grow constantly . The document server Document conversion is causing it and I’m still looking for the root cause of the error messages. For the time being there is no solution for this issue.
So I’m looking for a workaround, that would be to limit the size of the binlogs.

Has somebody an idea on how to limit the size / number of files of the binlogs?
Else , I guess I have to write a script that periodically deletes those files.