Error with my Nextcloud plugin after a update

[Leonard Lassen]

Hi there,
I get in the an Internal Server Error in my Browser after I tryed to update my Nextcloud from 21.0.1 to 21.0.2. My Nextcloud is running as a Pluign on a Truenas Server. I didnt know what I have to do now, A rollback with an snapshot didnt helped me

this is what I get in the browser

Code:

Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

can someone help me? I hope this Log file can help...

Best regards Leonard

 

[Leonard Lassen]

Hi, there a little addition:
I have a backup of it on a second server, I mirrored it back to the first server with a replication task and the iocage2 folder called, iocage is the old one where the Nextcloud doesn't work. and iocage the one with the backup, my idea was to rename the iocage folder to WinSCP and then to name the iocage2 folder iocage in order to have the working Nextcloud plugin again, but I can't rename the folder, what is the best thing to do here?

 

[Patrick M. Hausen]

zfs rename is your friend if you want to rename datasets.

 

[Leonard Lassen]

And then its working Right?

 

[Patrick M. Hausen]

Possibly ... no one can tell without access to your system.

You should be able to doe something like

Code:

zfs rename <yourpool>/iocage <yourpool>/iocage_old
zfs rename <yourpool>/iocage2 <yourpool>/iocage

 

[Leonard Lassen]

Possibly ... no one can tell without access to your system.

You should be able to doe something like

Code:

zfs rename <yourpool>/iocage <yourpool>/iocage_old
zfs rename <yourpool>/iocage2 <yourpool>/iocage

I get this error by trying to rename it

truenas# zfs rename apiopflege/iocage <yourpool>/iocage_old -sh: cannot open yourpool: No such file or directory truenas# zfs rename apiopflege/iocage apiopflege/iocage_old cannot unmount '/mnt/apiopflege/iocage/releases/12.1-RELEASE/root': unmount failed

What kind of information do you need from my system?

best regards Leoanrd

 

[Patrick M. Hausen]

Are all jails in that pool stopped? Possibly set autostart to "off" for all jails and reboot once.

 

[Leonard Lassen]

Yes the Jail was active, but it isnt working, what did you mean with reboot, the server?

best regards Leonard

 

[Patrick M. Hausen]

Yes, what else? Disable autostart for all jails, reboot, then try again.

Of course you cannot rename a dataset while it is mounted by a running jail ...

 

[Leonard Lassen]

No, it isnt working...

 

[Leonard Lassen]

and check box for boot enables himself automaticly

 

[Leonard Lassen]

I think this can be another way to solve IT, In my log file there is this entry:

Code:

2021/07/11 18:18:46 [error] 49020#101233: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /usr/local/www/nextcloud/lib/private/DB/Connection.php:85

can we try to solve the problem with this error in the Log?

best regards Leonard

 

[Patrick M. Hausen]

Probably your MySQL or MariaDB database is not running. Look in /var/db/mysql for a file ending in .err

 

[Leonard Lassen]

Hi, I found the file, here is an excerpt of the file.

Code:

2021-07-11T16:47:18.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T18:42:53.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T18:42:53.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T18:42:54.013168Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T18:42:54.013183Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T18:42:54.013226Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T18:42:54.013414Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T18:42:54.013432Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T18:42:54.013439Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T18:42:54.013452Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T18:42:54.013482Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T18:42:54.015153Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 47067
2021-07-11T18:42:54.083530Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T18:42:54.842678Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T18:42:55.089148Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T18:42:55.213575Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T18:42:55.213875Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T18:42:55.224621Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T18:42:55.225274Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T18:42:56.181655Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T18:42:56.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T19:53:52.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T19:53:52.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T19:53:52.677782Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T19:53:52.677797Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T19:53:52.677814Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T19:53:52.677865Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T19:53:52.677883Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T19:53:52.677889Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T19:53:52.677902Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T19:53:52.677932Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T19:53:52.679533Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 51444
2021-07-11T19:53:52.724956Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T19:53:53.227363Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T19:53:53.395562Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T19:53:53.520794Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T19:53:53.521051Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T19:53:53.531399Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T19:53:53.532014Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T19:53:54.631783Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T19:53:54.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T20:47:57.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T20:47:57.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T20:47:58.163484Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T20:47:58.163498Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T20:47:58.163516Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T20:47:58.163568Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T20:47:58.163586Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T20:47:58.163592Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T20:47:58.163605Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T20:47:58.163634Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T20:47:58.165283Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 63942
2021-07-11T20:47:58.217941Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T20:47:59.219650Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T20:47:59.680154Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T20:47:59.965648Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T20:47:59.965904Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T20:47:59.978693Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T20:47:59.979311Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T20:48:00.783226Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T20:48:00.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T21:32:54.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T21:32:54.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T21:32:55.112638Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:32:55.112652Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:32:55.112670Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:32:55.112721Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:32:55.112738Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:32:55.112745Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:32:55.112758Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:32:55.112787Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:32:55.114454Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 67221
2021-07-11T21:32:55.175675Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T21:32:55.715701Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T21:32:55.891096Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T21:32:56.019941Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T21:32:56.020199Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T21:32:56.036406Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T21:32:56.037024Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T21:32:57.049257Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T21:32:57.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T21:37:41.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T21:37:41.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T21:37:42.269796Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:37:42.269811Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:37:42.269852Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:37:42.271036Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:37:42.271057Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:37:42.271064Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:37:42.271079Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:37:42.271109Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:37:42.272831Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 3822
2021-07-11T21:37:42.496049Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T21:37:44.214036Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T21:37:44.697752Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T21:37:45.656943Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T21:37:45.657233Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T21:37:45.747511Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T21:37:45.748310Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T21:37:46.940918Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T21:37:46.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T21:38:52.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T21:38:52.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T21:38:52.651365Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:38:52.651380Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:38:52.651423Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:38:52.651610Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:38:52.651629Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:38:52.651635Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:38:52.651649Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:38:52.651679Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:38:52.653336Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 5988
2021-07-11T21:38:52.704700Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T21:38:53.200489Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T21:38:53.364543Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T21:38:53.544515Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T21:38:53.544771Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T21:38:53.558186Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T21:38:53.558793Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T21:38:54.615469Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T21:38:54.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T21:39:30.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T21:39:30.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T21:39:30.811048Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:39:30.811063Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:39:30.811082Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:39:30.811134Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:39:30.811157Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:39:30.811188Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:39:30.811206Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:39:30.811236Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:39:30.812893Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 8132
2021-07-11T21:39:30.863023Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T21:39:31.360889Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T21:39:31.530058Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T21:39:31.666269Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T21:39:31.666531Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T21:39:31.679179Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T21:39:31.679800Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T21:39:32.690407Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T21:39:32.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T21:42:12.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T21:42:12.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T21:42:12.730393Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:42:12.730408Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:42:12.730425Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:42:12.730478Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:42:12.730496Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:42:12.730502Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:42:12.730515Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:42:12.730545Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:42:12.732166Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 10465
2021-07-11T21:42:12.778481Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T21:42:13.280774Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T21:42:13.462152Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T21:42:13.579060Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T21:42:13.579323Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T21:42:13.596608Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T21:42:13.597228Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T21:42:14.633956Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T21:42:14.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-11T21:58:45.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-11T21:58:45.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-11T21:58:45.371043Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:58:45.371058Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:58:45.371103Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:58:45.371287Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:58:45.371306Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:58:45.371312Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-11T21:58:45.371326Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T21:58:45.371356Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-11T21:58:45.373036Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 13078
2021-07-11T21:58:45.430874Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-11T21:58:45.941615Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-11T21:58:46.100854Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-11T21:58:46.280225Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-11T21:58:46.280479Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-11T21:58:46.295965Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=0'.
2021-07-11T21:58:46.296584Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T21:58:47.415613Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-11T21:58:47.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended

If I read it right, something was removed from the system and now we have the Issue?

Best regards Leonard

 

[Patrick M. Hausen]

In /usr/local/etc/my.cnf or /usr/local/etc/mysql/<something> you will find a line query_cache_type=0. Remove that.

Seems like you updated MySQL and the new version does not support that option, anymore. This is not a TrueNAS issue but to be expected for *every* update of central components of Nextcloud. Reading release notes, following the update procedure outlined.

 

[Leonard Lassen]

okay I removed the line in /usr/local/etc/mysql/my.cnf

What now, its not running

Could be, I updated it in the plugin section, but yes I should look in the release notes

Best regards Leonard

 

[Leonard Lassen]

Can I downgrade MySQL?

 

[Patrick M. Hausen]

What now, its not running

service mysql-server restart, then look again in that .err file - until it starts.

Can I downgrade MySQL?

If the database was already upgraded, no. Plus Nextcloud 21 mandates MySQL 8 - which is probably why there was an update in the DB version in the first place. The MySQL 8 requirement can be found in the Nextcloud release notes. Deprecated configuration statements can be found in the MySQL release notes. None of this is a TrueNAS issue.

I am repeating this again and again, because if you are not capable to manage a complex 3-tier web application including a database server, you should probably reconsider running your own Nextcloud at all. Nextcloud as a product is more or less as complex as the entire TrueNAS.

 

[Leonard Lassen]

In the screenshot you can see what I get if I restart the Service. I couldnt find the File nextcloud-apiopflege.pid in /var/db/mysql/nextcloud-apiopflege.pid


This was in my .err file

Code:

2021-07-12T09:38:51.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-12T09:38:51.661410Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:38:51.661425Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:38:51.661443Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-12T09:38:51.661493Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-12T09:38:51.661511Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:38:51.661517Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:38:51.661530Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-12T09:38:51.661558Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-12T09:38:51.663190Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 37924
2021-07-12T09:38:51.708318Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-12T09:38:52.192242Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-12T09:38:52.347383Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-12T09:38:52.472189Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-12T09:38:52.472454Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-12T09:38:52.487167Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=0'.
2021-07-12T09:38:52.487774Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-12T09:38:53.541854Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-12T09:38:53.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-12T09:52:49.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-12T09:52:49.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-12T09:52:50.073465Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:52:50.073480Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:52:50.073498Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-12T09:52:50.073548Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-12T09:52:50.073566Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:52:50.073572Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:52:50.073585Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-12T09:52:50.073613Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-12T09:52:50.075280Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 39511
2021-07-12T09:52:50.121538Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-12T09:52:50.627793Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-12T09:52:50.783545Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-12T09:52:50.910719Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-12T09:52:50.910981Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-12T09:52:50.921543Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=0'.
2021-07-12T09:52:50.922161Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-12T09:52:51.972830Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-12T09:52:51.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended
2021-07-12T09:53:13.6NZ mysqld_safe Logging to '/var/db/mysql/nextcloud-apiopflege.err'.
2021-07-12T09:53:13.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-07-12T09:53:13.825324Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:53:13.825340Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:53:13.825358Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-12T09:53:13.825409Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-12T09:53:13.825426Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:53:13.825432Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-07-12T09:53:13.825446Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-12T09:53:13.825474Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-07-12T09:53:13.827127Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.25) starting as process 40799
2021-07-12T09:53:13.867371Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-12T09:53:15.014501Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-12T09:53:15.182082Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-07-12T09:53:15.307738Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-12T09:53:15.308001Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-12T09:53:15.318366Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=0'.
2021-07-12T09:53:15.318979Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-12T09:53:16.329976Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.25)  Source distribution.
2021-07-12T09:53:16.6NZ mysqld_safe mysqld from pid file /var/db/mysql/nextcloud-apiopflege.pid ended

Best regards Leonard

 

[Patrick M. Hausen]

The pid file is only supposed to exist while the server is running.
You still have the invalid setting in some config file:
2021-07-12T09:53:15.318366Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=0'.

You need to read the .err file and eliminate one error at a time until it starts. You can google for the individual error messages if you are unsure if statements need to be removed or changed.