Seit einigen Tagen meckert meine NC rum das in der Datenbank einige Indizes fehler wĂŒrden:
-
Fehlender Index "properties_pathonly_index" in der Tabelle "oc_properties". -
Fehlender Index "job_lastcheck_reserved" in der Tabelle "oc_jobs".
Wie angegeben einmal sudo -u www-data php occ db:add-missing-indices versucht und dann kommt:
Check indices of the share table.
Check indices of the filecache table.
Check indices of the twofactor_providers table.
Check indices of the login_flow_v2 table.
Check indices of the whats_new table.
Check indices of the cards table.
Check indices of the cards_properties table.
Check indices of the calendarobjects_props table.
Check indices of the schedulingobjects table.
Check indices of the oc_properties table.
Adding properties_pathonly_index index to the oc_properties table, this can take some timeâŠ
In ExceptionConverter.php line 114:
- An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes
In Exception.php line 26:
- SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes
In Connection.php line 82:
- SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes
db:add-missing-indices
ein Versuch mit `sudo -u www-data php occ maintenance:repair` brachte keine Besserung.
- Repair MySQL collation
- All tables already have the correct collation â nothing to do
- Repair mime types
- Clean tags and favorites
- 0 tags of deleted users have been removed.
- 0 tags for delete files have been removed.
- 0 tag entries for deleted tags have been removed.
- 0 tags with no entries have been removed.
- Repair invalid shares
- Move .step file of updater to backup location
- Add move avatar background job
- Repair step already executed
- Add preview cleanup background jobs
- Fix potential broken mount points
- No mounts updated
- Repair language codes
- Install new core bundle components
- Add log rotate job
- Clear frontend caches
- Image cache cleared
- SCSS cache cleared
- JS cache cleared
- Clear every generated avatar on major updates
- Add preview background cleanup job
- Queue a one-time job to cleanup old backups of the updater
- Cleanup invalid photocache files for carddav
- Add background job to cleanup login flow v2 tokens
- Remove potentially over exposing share links
- No need to remove link shares.
- Clear access cache of projects
- Reset generated avatar flag
- Keep legacy encryption enabled
- Check encryption key format
- Remove old dashboard app config data
- Add job to cleanup the bruteforce entries
- Queue a one-time job to check for user uploaded certificates
- Repair DAV shares
- Add background job to set the lookup server share state for users
- Update name of the stored view
- Upgrading Circles App
- Fix component of birthday calendars
- 0 birthday calendars updated.
- Regenerating birthday calendars to use new icons and fix old birthday events without year
- Repair step already executed
- Fix broken values of calendar objects
0 [->--------------------------] - Registering building of calendar search index as background job
- Repair step already executed
- Register building of social profile search index as background job
- Registering background jobs to update cache for webcal calendars
- Added 0 background jobs to update webcal calendars
- Registering building of calendar reminder index as background job
- Repair step already executed
- Clean up orphan event and contact data
- 0 events without a calendar have been cleaned up
- 0 properties without an events have been cleaned up
- 0 changes without a calendar have been cleaned up
- 0 cached events without a calendar subscription have been cleaned up
- 0 changes without a calendar subscription have been cleaned up
- 0 contacts without an addressbook have been cleaned up
- 0 properties without a contact have been cleaned up
- 0 changes without an addressbook have been cleaned up
- Remove activity entries of private events
- Removed 0 activity entries
- Clean up old calendar subscriptions from deleted users that were not cleaned-up
0 [----->----------------------]- 0 calendar subscriptions without an user have been cleaned up
- Rebuild font library
- Fix the share type of guest shares when migrating from ownCloud
- Copy the share password into the dedicated column
- Set existing shares as accepted
- Set binary permissions
- Update OAuth token expiration times
- onlyoffice
- Create help command
- Invalidate access cache for projects conversation provider
- Invalidation not required
- Cache the user display names
- Switches from default updater server to the customer one if a valid subscription is available
- Repair step already executed
- Send an admin notification if monthly report is disabled
- Add background job to check for backup codes
- Populating added database structures for workflows
Ich hab auch versucht in der Datenbank an sich rumzupfuschen (fĂŒr einen absoluter DB-Laie wie mich ist rumpfuschen noch sehr euphemistisch ausgedrĂŒckt) wie z.B. hier beschrieben, aber das war alles vorher schon so.
An anderer Stelle liest sich man solle innodb_default_row_format=dynamic hinzufĂŒgen. Ich weis nur nicht wo.
HinzufĂŒgen weiterer Zeilen in die /etc/mysql/my.cnf wie in Hier beschrieben hilft auch nicht.
Meine NC lĂ€uft als VM auf einem NAS, ich habe nach der Anleitung von Decatec installiert und das ganze ist ĂŒber eine Subdomain eines DynDNS Service zu erreichen. Die NC-Apps und die Linux-Pakete sind alle auf dem Stand was gerade aktuell ist.
APP: Kann man hier im Forum Text einfĂ€rben? Und wenn âJa.â wie?
