Closed stoamandl closed 9 months ago
pixel8383
commented
11 months ago The same is happening on two Nextcloud instances I manage.
One instance is running on: OS: FreeBSD 13.1-RELEASE-p7 amd64 PHP version: 8.1.20 SQL version: mysql 8.0.32
The second instance is running on: OS: Linux 5.15.0-1040-oracle x86_64 PHP version: 8.1.2 SQL version: mysql 10.6.12
I have a third instance running on a server like the second one but updated without issues to fulltextsearch 27.0.2.
alxrdn
commented
11 months ago same here
stoamandl
commented
11 months ago @ArtificialOwl Is there a solution to get the app working again? The app is now disabled in Version 27.0.2. When I try to turn it on again I get the error message with duplicate entry. So no more Fulltext search is Working on the NC instance.
I tried to delete the row that the Updater mentions as duplicate. But after that the Updater say there is the next duplicate in the table oc_fulltextsearch_index.
stoamandl
commented
11 months ago Unfortunately there is no solution or answer from the developers yet. The work around is to install version 27.0.1 manually again.
Disable the app, then delete (or rename to fulltextsearch_broken_version) fulltextsearch from the apps/ folder. Download the old version from: https://github.com/nextcloud-releases/fulltextsearch/releases/tag/27.0.1 Extract the folder back to the apps folder. Enable the app again. @alxrdn Hope this also solves your conflict.
stoamandl
commented
11 months ago @pixel8383 did you get a solution? since 3 weeks no response from dev site :-( With the downgrade its running again, but in this case this will block my update to next NC Version. (the nc update will automatic update this version to the last fulltext search version)
pixel8383
commented
11 months ago @stoamandl you can upgrade your NC instance and downgrade the fulltextsearch app later (until the developers will release a fix for it).
ArtificialOwl
commented
10 months ago this should fix your upgrade issue: https://github.com/nextcloud/fulltextsearch/pull/802
charismeki
commented
10 months ago same here...
enspiro
commented
9 months ago same here. Error on my end: Database error when running migration 2801Date202309200001 for app fulltextsearch An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files-305060-local' for key 'PRIMARY'
alxrdn
commented
9 months ago Hello, how to know in which app release version this fix will be deployed? I can't see no more recent version than 27.0.2 released on Sept. 26 (https://apps.nextcloud.com/apps/fulltextsearch/releases) Thanks
⚠️ This issue respects the following points: ⚠️
Bug description
Server stuck in maintenance mode after Update Fulltextsearch from 27.0.1 to 27.0.2 I was only able to get the server out of maintenance mode by manually disabling the app via occ:app disabel fulltextsearch and setting the maintenance mode to true in config.php.
Server configuration detail
Operating system: Linux 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64
Webserver: Apache (fpm-fcgi)
Database: mysql 8.0.34
PHP version: 8.1.23
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, Reflection, SPL, session, standard, sodium, cgi-fcgi, mysqlnd, PDO, xml, apcu, bcmath, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, gmp, iconv, igbinary, imagick, intl, ldap, exif, memcache, mysqli, pdo_mysql, Phar, posix, readline, redis, shmop, SimpleXML, smbclient, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlrpc, xmlwriter, xsl, zip, libsmbclient, Zend OPcache
Nextcloud version: 27.1.1 - 27.1.1.0
Updated from an older Nextcloud/ownCloud or fresh install:
Where did you install Nextcloud from: unknown
Signing status
[]List of activated apps
``` Enabled: - activity: 2.19.0 - admin_audit: 1.17.0 - analytics: 4.10.0 - announcementcenter: 6.6.2 - appointments: 1.15.3 - approval: 1.1.0 - bookmarks: 13.1.1 - bruteforcesettings: 2.7.0 - calendar: 4.5.1 - circles: 27.0.1 - cloud_federation_api: 1.10.0 - cloud_py_api: 0.1.8 - comments: 1.17.0 - contacts: 5.4.2 - contactsinteraction: 1.8.0 - cospend: 1.5.10 - dashboard: 7.7.0 - dav: 1.27.0 - deck: 1.11.0 - drawio: 2.1.2 - federatedfilesharing: 1.17.0 - federation: 1.17.0 - files: 1.22.0 - files_external: 1.19.0 - files_fulltextsearch: 27.0.1 - files_fulltextsearch_tesseract: 27.0.0 - files_pdfviewer: 2.8.0 - files_reminders: 1.0.0 - files_rightclick: 1.6.0 - files_sharing: 1.19.0 - files_trashbin: 1.17.0 - files_versions: 1.20.0 - firstrunwizard: 2.16.0 - fulltextsearch_elasticsearch: 27.0.2 - impersonate: 1.14.0 - logreader: 2.12.0 - lookup_server_connector: 1.15.0 - mail: 3.4.0 - maps: 1.1.1 - mediadc: 0.3.6 - metadata: 0.19.0 - news: 23.0.0 - nextcloud_announcements: 1.16.0 - notifications: 2.15.0 - oauth2: 1.15.1 - password_policy: 1.17.0 - passwords: 2023.9.30 - photos: 2.3.0 - privacy: 1.11.0 - provisioning_api: 1.17.0 - quota_warning: 1.17.0 - recommendations: 1.6.0 - related_resources: 1.2.0 - richdocuments: 8.2.0 - richdocumentscode: 23.5.402 - serverinfo: 1.17.0 - settings: 1.9.0 - sharebymail: 1.17.0 - spreed: 17.1.1 - support: 1.10.0 - survey_client: 1.15.0 - suspicious_login: 5.0.0 - systemtags: 1.17.0 - text: 3.8.0 - theming: 2.2.0 - timemanager: 0.3.8 - timetracker: 0.0.80 - twofactor_backupcodes: 1.16.0 - twofactor_totp: 9.0.0 - updatenotification: 1.17.0 - user_status: 1.7.0 - viewer: 2.1.0 - weather_status: 1.7.0 - workflow_pdf_converter: 1.12.0 - workflowengine: 2.9.0 Disabled: - dicomviewer: 1.2.4 - encryption - fulltextsearch: 27.0.1 - talk_matterbridge: 1.26.0 - user_ldap ```Configuration (config/config.php)
``` { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "cloud.binaryfour.de" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "27.1.1.0", "overwrite.cli.url": "https:\/\/cloud.binaryfour.de", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "memcache.local": "OC\\Memcache\\APCu", "filelocking.enabled": "true", "memcache.locking": "OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379, "password": "***REMOVED SENSITIVE VALUE***", "timeout": 0 }, "tempdirectory": "\/home\/binaryfour\/domains\/cloud.binaryfour.de\/tmp\/nextcloudtemp", "app_install_overwrite": [ "timetracker", "spreed", "deck", "files_fulltextsearch", "dicomviewer", "talk_matterbridge", "fulltextsearch", "fulltextsearch_elasticsearch", "files_fulltextsearch_tesseract", "impersonate" ], "maintenance": false, "mail_smtpmode": "smtp", "mail_smtpsecure": "tls", "mail_sendmailmode": "smtp", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "PLAIN", "mail_smtpauth": 1, "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "587", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "updater.release.channel": "stable", "versions_retention_obligation": "auto, 30", "theme": "", "loglevel": 3, "default_phone_region": "DE", "enable_previews": true, "preview_max_x": 8096, "preview_max_y": 8096, "preview_max_filesize_image": 50, "preview_libreoffice_path": "\/usr\/bin\/libreoffice", "preview_office_cl_parameters": " --headless --nologo --nofirststartwizard --invisible --norestore --convert-to png --outdir ", "enabledPreviewProviders": [ "OC\\Preview\\PNG", "OC\\Preview\\JPEG", "OC\\Preview\\GIF", "OC\\Preview\\BMP", "OC\\Preview\\XBitmap", "OC\\Preview\\MP3", "OC\\Preview\\TXT", "OC\\Preview\\MarkDown", "OC\\Preview\\OpenDocument", "OC\\Preview\\Krita" ] } ```Cron Configuration: Array ( [backgroundjobs_mode] => cron [lastcron] => 1695879068 )
External storages: yes
External storage configuration
``` +----------+-----------------------+-----------+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+------------------+-------------------+-------+ | Mount ID | Mount Point | Storage | Authentication Type | Configuration | Options | Applicable Users | Applicable Groups | Type | +----------+-----------------------+-----------+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+------------------+-------------------+-------+ | 2 | /ContaboObjectStorage | Amazon S3 | Zugangsschlüssel | bucket: "cloud.binaryfour.de", hostname: "eu2.contabostorage.com", port: "443", region: "European Union", use_ssl: true, use_path_style: false, legacy_auth: false, key: "***", secret: "***" | enable_sharing: true, filesystem_check_changes: 0 | jan | | Admin | +----------+-----------------------+-----------+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+------------------+-------------------+-------+ ```Encryption: no
User-backends:
After the Update via Update App from 27.0.1 to 27.0.2 the updateprocess stuck with this error.
Log 1:
[updater] Information: \OC\Updater::appUpgradeStarted: Updating ...
at 2023-09-28T05:23:43+00:00
Log 2:
[no app in context] Fehler: Exception: Database error when running migration 2801Date202309200001 for app fulltextsearch An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files-678242-local' for key 'oc_fulltextsearch_index.PRIMARY' at <>
Caused by:
OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files-678242-local' for key 'oc_fulltextsearch_index.PRIMARY' at <>
Caused by:
Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files-678242-local' for key 'oc_fulltextsearch_index.PRIMARY' at <>
Caused by:
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files-678242-local' for key 'oc_fulltextsearch_index.PRIMARY' at <>
Caused by:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files-678242-local' for key 'oc_fulltextsearch_index.PRIMARY' at <>
at 2023-09-28T05:23:44+00:00
Log 3:
[updater] Fehler: \OC\Updater::failure: Exception: Database error when running migration 2801Date202309200001 for app fulltextsearch An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files-678242-local' for key 'oc_fulltextsearch_index.PRIMARY'
at 2023-09-28T05:23:44+00:00