search

nextcloud / polls

🗳️ Polls app for Nextcloud
https://apps.nextcloud.com/apps/polls
GNU Affero General Public License v3.0
254 stars 73 forks source link

Error in Nextcloud AIO Database Container related to Polls (polls_polls..deleted) #3220

Closed elephantastyczny closed 8 months ago

elephantastyczny commented 8 months ago

⚠️ This issue respects the following points: ⚠️

What went wrong, what did you observe?

Nothing wrong, but I've noticed in container logs that there are some errors and I'd like to know how to fix it.

What did you expect, how polls should behave instead?

N/A

What steps does it need to replay this bug?

  1. Unknown

Installation method

Installed/updated from the appstore (Apps section of your site)

Installation type

Updated from a minor version within same major version (i.e. 4.0.0 to 4.1.1)

Affected polls version

6.0.1

Which browser did you use, when experiencing the bug?

Other browser

No response

Add your browser log here

No response

Additional client environment information

No response

NC version

Other/Don't know

Other Nextcloud version

28.0.0

PHP engine version

Other/Don't know

Other PHP version

8.3

Database engine

PostgreSQL

Database Engine version or other Database

PostgreSQL 15.5

Which user-backends are you using?

Add your nextcloud server log here

2023-12-22 05:05:54.865 CET [14] LOG:  database system is ready to accept connections
2023-12-22 05:27:45.499 CET [2497] ERROR:  duplicate key value violates unique constraint "gf_versions_uniq_index"
2023-12-22 05:27:45.499 CET [2497] DETAIL:  Key (file_id, "timestamp")=(114442, 1684875746) already exists.
2023-12-22 05:27:45.499 CET [2497] STATEMENT:  INSERT INTO "oc_group_folders_versions" ("file_id", "timestamp", "size", "mimetype", "metadata") VALUES($1, $2, $3, $4, $5)
2023-12-22 06:32:43.414 CET [9517] ERROR:  duplicate key value violates unique constraint "gf_versions_uniq_index"
2023-12-22 06:32:43.414 CET [9517] DETAIL:  Key (file_id, "timestamp")=(114442, 1684875746) already exists.
2023-12-22 06:32:43.414 CET [9517] STATEMENT:  INSERT INTO "oc_group_folders_versions" ("file_id", "timestamp", "size", "mimetype", "metadata") VALUES($1, $2, $3, $4, $5)
2023-12-22 07:37:45.780 CET [17844] ERROR:  duplicate key value violates unique constraint "gf_versions_uniq_index"
2023-12-22 07:37:45.780 CET [17844] DETAIL:  Key (file_id, "timestamp")=(114442, 1684875746) already exists.
2023-12-22 07:37:45.780 CET [17844] STATEMENT:  INSERT INTO "oc_group_folders_versions" ("file_id", "timestamp", "size", "mimetype", "metadata") VALUES($1, $2, $3, $4, $5)
2023-12-22 08:38:38.690 CET [31282] ERROR:  duplicate key value violates unique constraint "gf_versions_uniq_index"
2023-12-22 08:38:38.690 CET [31282] DETAIL:  Key (file_id, "timestamp")=(114442, 1684875746) already exists.
2023-12-22 08:38:38.690 CET [31282] STATEMENT:  INSERT INTO "oc_group_folders_versions" ("file_id", "timestamp", "size", "mimetype", "metadata") VALUES($1, $2, $3, $4, $5)
2023-12-22 08:45:31.106 CET [33027] ERROR:  column polls_polls..deleted does not exist at character 332
2023-12-22 08:45:31.106 CET [33027] HINT:  Perhaps you meant to reference the column "polls_polls.deleted".
2023-12-22 08:45:31.106 CET [33027] STATEMENT:  SELECT "polls_polls".*, MIN("shares"."display_name") AS "display_name", MIN("shares"."type") AS "user_type", MIN("shares"."email_address") AS "email_address" FROM "oc_polls_polls" "polls_polls" LEFT JOIN "oc_polls_share" "shares" ON ("polls_polls"."id" = "shares"."poll_id") AND ("polls_polls"."owner" = "shares"."user_id") WHERE ("polls_polls".".deleted" = $1) AND (("polls_polls"."title" ILIKE $2) OR ("polls_polls"."description" ILIKE $3)) GROUP BY "polls_polls"."id"

Additional environment informations

No response

Configuration report

{
    "system": {
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "overwritehost": "redacted",
        "overwriteprotocol": "https",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "redacted"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "28.0.0.11",
        "overwrite.cli.url": "https:\/\/redacted\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "0": "dbpersistent => true",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "loglevel": "1",
        "log_type": "file",
        "logfile": "\/var\/www\/html\/data\/nextcloud.log",
        "log_rotate_size": "10485760",
        "log.condition": {
            "apps": [
                "admin_audit"
            ]
        },
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "enabledPreviewProviders": {
            "1": "OC\\Preview\\Image",
            "2": "OC\\Preview\\MarkDown",
            "3": "OC\\Preview\\MP3",
            "4": "OC\\Preview\\TXT",
            "5": "OC\\Preview\\OpenDocument",
            "6": "OC\\Preview\\Movie",
            "0": "OC\\Preview\\Imaginary"
        },
        "enable_previews": true,
        "upgrade.disable-web": true,
        "mail_smtpmode": "smtp",
        "trashbin_retention_obligation": "auto, 30",
        "versions_retention_obligation": "auto, 30",
        "activity_expire_days": "30",
        "simpleSignUpLink.shown": false,
        "share_folder": "\/Shared",
        "one-click-instance": true,
        "one-click-instance.user-limit": 900,
        "one-click-instance.link": "https:\/\/nextcloud.com\/all-in-one\/",
        "htaccess.RewriteBase": "\/",
        "files_external_allow_create_new_local": false,
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "allow_local_remote_servers": true,
        "preview_imaginary_url": "http:\/\/nextcloud-aio-imaginary:9000",
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "default_language": "pl",
        "default_locale": "pl_PL",
        "default_phone_region": "PL",
        "mail_smtpauth": 1,
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpsecure": "ssl",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "updatedirectory": "\/nc-updater",
        "data-fingerprint": "db9b09d4356b9192db0cee466977e6b7",
        "upgrade.cli-upgrade-link": "https:\/\/github.com\/nextcloud\/all-i\/discussions\/2726",
        "davstorage.request_timeout": 3600,
        "dbpersistent": false,
        "auth.bruteforce.protection.enabled": false,
        "auth.ratelimit.protection.enabled": false,
        "appsallowlist": [],
        "updater.release.channel": "stable",
        "app_install_overwrite": [
            "nextcloud-aio"
        ],
        "defaultapp": ""
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - admin_audit: 1.18.0
  - announcementcenter: 6.7.0
  - app_api: 1.4.4
  - auto_groups: 1.5.2
  - bruteforcesettings: 2.8.0
  - calendar: 4.6.1
  - calendar_resource_management: 0.6.0
  - call_summary_bot: 1.0.1
  - circles: 28.0.0-dev
  - cloud_federation_api: 1.11.0
  - collectives: 2.9.2
  - comments: 1.18.0
  - contacts: 5.5.0
  - contactsinteraction: 1.9.0
  - dashboard: 7.8.0
  - dav: 1.29.1
  - deck: 1.12.0
  - event_update_notification: 2.3.0
  - external: 5.3.1
  - federatedfilesharing: 1.18.0
  - files: 2.0.0
  - files_accesscontrol: 1.18.0
  - files_automatedtagging: 1.18.0
  - files_external: 1.20.0
  - files_fulltextsearch: 28.0.0
  - files_mindmap: 0.0.30
  - files_pdfviewer: 2.9.0
  - files_reminders: 1.1.0
  - files_sharing: 1.20.0
  - files_trashbin: 1.18.0
  - files_versions: 1.21.0
  - fileslibreofficeedit: 1.1.0
  - firstrunwizard: 2.17.0
  - forms: 4.0.0
  - fulltextsearch: 28.0.0
  - fulltextsearch_elasticsearch: 28.0.0
  - group_everyone: 0.1.14
  - groupfolders: 16.0.1
  - impersonate: 1.15.0
  - integration_giphy: 1.0.10
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - mail: 3.5.0
  - nextcloud-aio: 0.4.0
  - nextcloud_announcements: 1.17.0
  - notes: 4.9.1
  - notifications: 2.16.0
  - notify_push: 0.6.6
  - oauth2: 1.16.3
  - password_policy: 1.18.0
  - photos: 2.4.0
  - polls: 6.0.1
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - quota_warning: 1.18.0
  - recommendations: 2.0.0
  - related_resources: 1.3.0
  - richdocuments: 8.3.0
  - serverinfo: 1.18.0
  - settings: 1.10.0
  - sharebymail: 1.18.0
  - sketch_picker: 1.0.1
  - spreed: 18.0.1
  - support: 1.11.0
  - survey_client: 1.16.0
  - systemtags: 1.18.0
  - tables: 0.6.5
  - tasks: 0.15.0
  - text: 3.9.1
  - text_templates: 1.0.4
  - theming: 2.3.0
  - twofactor_backupcodes: 1.17.0
  - twofactor_nextcloud_notification: 3.8.0
  - twofactor_totp: 10.0.0-beta.2
  - updatenotification: 1.18.0
  - user_ldap: 1.19.0
  - user_status: 1.8.1
  - viewer: 2.2.0
  - weather_status: 1.8.0
  - welcome: 1.0.10
  - workflow_pdf_converter: 1.13.0
  - workflowengine: 2.10.0
Disabled:
  - drawio: 2.1.4 (installed 2.1.4)
  - encryption: 2.16.0
  - federation: 1.18.0 (installed 1.16.0)
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - imageconverter: 1.3.5 (installed 1.3.5)
  - quickaccesssorting: 3.0.0 (installed 3.0.0)
  - suspicious_login: 6.0.0 (installed 4.3.0)
  - users_picker: 0.2.2 (installed 0.2.2)

Nextcloud Signing status

Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results
=======
- core
    - INVALID_HASH
        - core/js/mimetypelist.js

Raw output
==========
Array
(
    [core] => Array
        (
            [INVALID_HASH] => Array
                (
                    [core/js/mimetypelist.js] => Array
                        (
                            [expected] => 550ab566d30693bfa24ec4b15d9df87731ae8a3be8f79dabf94757e5b8b20eec6e4b678f17af1718297f2872f6b04519eeb024d1dff11947f29da431c7f11201
                            [current] => 24e6faa4a1361e51ff70027024f41c4b37fdb5f6f347ceb095450ddbde2d0a6b6dd1403be92a912d2889064a9736a9bed89d7dc62470035fc1299d4b977c5f46
                        )

                )

        )

)

Additional Information

No response

dartcafe commented 8 months ago

3203

github-actions[bot] commented 3 months ago

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.