Nextcloud 23 stop working and show that error:
"Error interno del servidor
El servidor no ha podido completar tu petición.
Si sucede de nuevo, por favor, envía los detalles técnicos a continuación al administrador del servidor.
Pueden verse más detalles en el registro del servidor.
### Detalles técnicos
** Dirección remota: 1.x.x.x*
** ID de la solicitud: 9BaiX0ksjUdQg2zmWKLD*
"
[/details]
[Nextcloud Hub II] (23.0.0)
Operating system and version Ubuntu 18.04.6 LTS
version Apache/2.4.29
Version PHP 7.4.27
The issue you are facing:
Is this the first time you’ve seen this error? yes
Steps to replicate it:
- Activate File sharing
Aplication show a yelow error:
“Error: This app cannot be enabled because it makes the server unstable”
and afther some seconds web server not work properly and show an error:
"Error interno del servidor…*
for recover the web server I disabhle the app form comman line:
sudo -u www-data php occ app:disable files_sharing
The output of your Nextcloud log in Admin > Logging:
Error index Doctrine\DBAL\Schema\SchemaException: There is no column with name 'object_id' on table 'oc_activity'.
2021-12-30T16:33:08+0100
Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size
2021-12-30T16:26:13+0100
Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size
2021-12-30T16:26:00+0100
Error index Doctrine\DBAL\Schema\SchemaException: There is no column with name 'object_id' on table 'oc_activity'.
2021-12-30T16:13:19+0100
Error index Doctrine\DBAL\Schema\SchemaException: There is no column with name 'object_id' on table 'oc_activity'.
2021-12-30T16:13:08+0100
Error index Doctrine\DBAL\Schema\SchemaException: There is no column with name 'object_id' on table 'oc_activity'.
2021-12-30T16:12:39+0100
Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size
2021-12-30T16:11:27+0100
Warning core Login failed: 'rortigosa' (Remote IP: '10.252.2.142')
2021-12-30T16:11:09+0100
Warning user_ldap Bind failed: 49: Invalid credentials
2021-12-30T16:11:08+0100
Warning user_ldap Bind failed: 49: Invalid credentials
2021-12-30T16:11:08+0100
Info updater \OC\Updater::resetLogLevel: Reset log level to Warning(2)
2021-12-30T16:09:57+0100
Info updater \OC\Updater::maintenanceDisabled: Turned off maintenance mode
2021-12-30T16:09:57+0100
Info updater \OC\Updater::updateEnd: Update successful
2021-12-30T16:09:57+0100
Info updater \OC\Updater::finishedCheckCodeIntegrity: Finished code integrity check
2021-12-30T16:09:57+0100
Info no app in context Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "photos.page.index" as such route does not exist.
2021-12-30T16:09:49+0100
Info no app in context Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "files.view.index" as such route does not exist.
2021-12-30T16:09:49+0100
Info no app in context Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "dashboard.dashboard.index" as such route does not exist.
2021-12-30T16:09:49+0100
Info no app in context Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "ocs.password_policy.API.validate" as such route does not exist.
2021-12-30T16:09:49+0100
Info no app in context Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "ocs.password_policy.API.generate" as such route does not exist.
2021-12-30T16:09:49+0100
Info no app in context Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "cloud_federation_api.RequestHandler.addShare" as such route does not exist.
2021-12-30T16:09:49+0100
Info no app in context Symfony\Component\Routing\Exception\RouteNotFoundException: Unable to generate a URL for the named route "ocs.files.DirectEditing.info" as such route does not exist.
2021-12-30T16:09:49+0100
Debug no app in context JSCombiner: successfully cached: merged-template-prepend.js
2021-12-30T16:09:48+0100
Info updater \OC\Updater::startCheckCodeIntegrity: Starting code integrity check...
2021-12-30T16:09:01+0100
Info updater \OC\Repair::step: Repair step: Add background job to set the lookup server share state for users
2021-12-30T16:09:01+0100
Info no app in context Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent is used
2021-12-30T16:09:01+0100
Info updater \OC\Repair::step: Repair step: Repair DAV shares
2021-12-30T16:09:01+0100
Info no app in context Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent is used
2021-12-30T16:09:01+0100
Info updater \OC\Repair::step: Repair step: Queue a one-time job to check for user uploaded certificates
2021-12-30T16:09:01+0100
Info no app in context Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent is used
2021-12-30T16:09:01+0100
Info updater \OC\Repair::step: Repair step: Add job to cleanup the bruteforce entries
2021-12-30T16:09:01+0100
Info no app in context Deprecated event type for \OC\Repair::step: Symfony\Component\EventDispatcher\GenericEvent is used
2021-12-30T16:09:01+0100
Info updater \OC\Repair::step: Repair step: Remove old dashboard app config data
2021-12-30T16:09:01+0100
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
'datadirectory' => '/var/www/owncloud/data',
'dbtype' => 'mysql',
'version' => '23.0.0.10',
'installed' => true,
'dbname' => 'owncloud_db',
'dbhost' => 'localhost',
'dbtableprefix' => 'oc_',
'dbuser' => 'userowncloud',
'dbpassword' => 'xxxxxxxxx',
'forcessl' => true,
'theme' => '',
'maintenance' => false,
'ldapIgnoreNamingRules' => false,
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'tls',
'mail_smtpauthtype' => 'LOGIN',
'mail_smtpauth' => 1,
'loglevel' => '2',
'mail_from_address' => 'xxxxx',
'mail_domain' => 'dddddd.com',
'mail_smtphost' => 'ddddd.com',
'mail_smtpname' => 'dddddd,
'mail_smtppassword' => 'dddddd',
'secret' => 'asdfasdfasdfasdfasdfasdfasdfd asdfasdfasdfasdfdsfasddfasdfasdfsadfasdf',
'mail_smtpport' => '25',
'overwrite.cli.url' => 'https://owncloud.midominio.com',
'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
'updater.release.channel' => 'stable',
);
The output of your Apache/nginx/system log in /var/log/____:
[Thu Dec 30 14:43:36.015728 2021] [ssl:warn] [pid 847] AH01909: owncloud.midominio2.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 30 14:43:36.078671 2021] [ssl:warn] [pid 847] AH01909: 127.0.1.1:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 30 14:43:40.204807 2021] [ssl:warn] [pid 870] AH01909: owncloud.midominio2.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 30 14:43:40.205142 2021] [ssl:warn] [pid 870] AH01909: 127.0.1.1:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 30 14:43:40.208885 2021] [mpm_prefork:notice] [pid 870] AH00163: Apache/2.4.29 (Ubuntu) OpenSSL/1.1.1 configured -- resuming normal operations
[Thu Dec 30 14:43:40.208905 2021] [core:notice] [pid 870] AH00094: Command line: '/usr/sbin/apache2'
[Thu Dec 30 15:38:04.010725 2021] [access_compat:error] [pid 1857] [client 10.252.2.142:52418] AH01797: client denied by server configuration: /var/www/owncloud/data/.ocdata
[Thu Dec 30 16:12:35.680621 2021] [access_compat:error] [pid 2373] [client 10.252.2.142:52959] AH01797: client denied by server configuration: /var/www/owncloud/data/.ocdata
[Thu Dec 30 16:13:03.582191 2021] [access_compat:error] [pid 2257] [client 10.252.2.142:52980] AH01797: client denied by server configuration: /var/www/owncloud/data/.ocdata
[Thu Dec 30 16:13:16.853396 2021] [access_compat:error] [pid 2373] [client 10.252.2.142:52989] AH01797: client denied by server configuration: /var/www/owncloud/data/.ocdata
[Thu Dec 30 16:33:07.068439 2021] [access_compat:error] [pid 2401] [client 10.252.2.142:53228] AH01797: client denied by server configuration: /var/www/owncloud/data/.ocdata