thousands of errors in short time since update to NC 30.0.2

[42ske]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• I agree to follow Nextcloud's Code of Conduct.

What went wrong, what did you observe?

Since the Update from NC 29.0.8 to 30.0.2 yesterday everything in Polls seems to work as expected, but in the nextcloud.og I have thousands of errors (up to 14 times in the same second):

[core] Fehler: More than 30 characters for an output column name are not allowed on Oracle.
GET /index.php/apps/polls/poll/21/watch?offset=1731050893
von [IP& von [user] um 08.11.2024, 10:24:36

The poll was added before the update.

would be fine if you could find and solve the problem soon. Thanks in advance!

What did you expect, how polls should behave instead?

no errors in log

What steps does it need to replay this bug?

?

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

7.2.4

Which browser did you use, when experiencing the bug?

• Firefox
• Chrome
• Chromium/Chromium based (i.e. Edge)
• Safari
• Other/Don't know

Other browser

No response

Add your browser log here

No response

Additional client environment information

No response

NC version

Nextcloud 30

Other Nextcloud version

30.0.2

PHP engine version

PHP 8.3

Other PHP version

8.3.13

Database engine

MariaDB

Database Engine version or other Database

10.5.22

Which user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other/Don't know

Add your nextcloud server log here

{"reqId":"Zy3feXYGgNQw4bLqZ-P2DgAAywg","level":3,"time":"2024-11-08T09:52:57+00:00","remoteAddr":"[IP]","user":"[user.name]","app":"core","method":"GET","url":"/index.php/apps/polls/poll/21/subscription","message":"More than 30 characters for an output column name are not allowed on Oracle.","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:132.0) Gecko/20100101 Firefox/132.0","version":"30.0.2.2","exception":{"Exception":"Doctrine\DBAL\Query\QueryException","Message":"More than 30 characters for an output column name are not allowed on Oracle.","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":284,"function":"prepareForExecute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":253,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":359,"function":"findOneQuery","class":"OCP\AppFramework\Db\QBMapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/polls/lib/Db/PollMapper.php","line":65,"function":"findEntity","class":"OCP\AppFramework\Db\QBMapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/polls/lib/Service/SubscriptionService.php","line":32,"function":"find","class":"OCA\Polls\Db\PollMapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/polls/lib/Controller/SubscriptionController.php","line":35,"function":"get","class":"OCA\Polls\Service\SubscriptionService","type":"->"},{"file":"/var/www/html/nextcloud/apps/polls/lib/Controller/BaseController.php","line":39,"function":"OCA\Polls\Controller\{closure}","class":"OCA\Polls\Controller\SubscriptionController","type":"->","args":["*** sensitive parameters replaced **"]},{"file":"/var/www/html/nextcloud/apps/polls/lib/Controller/SubscriptionController.php","line":34,"function":"response","class":"OCA\Polls\Controller\BaseController","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":208,"function":"get","class":"OCA\Polls\Controller\SubscriptionController","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/html/nextcloud/lib/base.php","line":1001,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/html/nextcloud/index.php","line":24,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":217,"message":"More than 30 characters for an output column name are not allowed on Oracle.","query":"SELECT polls_polls., (SELECT COUNT(user_vote_sub.vote_answer) FROM *PREFIX*polls_votes user_vote_sub WHERE (user_vote_sub.poll_id = polls_polls.id) AND (user_vote_sub.user_id = :dcValue1)) AS current_user_count_votes, (SELECT COUNT(user_vote_sub.vote_answer) FROM *PREFIX*polls_votes user_vote_sub WHERE (user_vote_sub.poll_id = polls_polls.id) AND (user_vote_sub.user_id = :dcValue1) AND (user_vote_sub.vote_answer = :dcValue2)) AS current_user_count_votes_yes, (SELECT COUNT(user_vote_sub.vote_answer) FROM *PREFIX*polls_votes user_vote_sub LEFT JOIN *PREFIX*polls_options vote_options_join ON (vote_options_join.poll_id = user_vote_sub.poll_id) AND (vote_options_join.poll_option_text = user_vote_sub.vote_option_text) AND (vote_options_join.deleted = '0') WHERE (user_vote_sub.poll_id = polls_polls.id) AND (user_vote_sub.user_id = :dcValue1) AND (vote_options_join.id IS NULL)) AS current_user_count_orphaned_votes, coalesce(MAX(options.timestamp), :dcValue3) AS max_date, coalesce(MIN(options.timestamp), :dcValue4) AS min_date, COUNT(options.id) AS count_options, coalesce(user_shares.type, '') AS user_role, user_shares.locked AS is_current_user_locked, coalesce(user_shares.token, '') AS share_token, group_concat(distinct group_shares.user_id SEPARATOR ',') AS group_shares FROM *PREFIX*polls_polls polls_polls LEFT JOIN *PREFIX*polls_options options ON (polls_polls.id = options.poll_id) AND (options.deleted = '0') LEFT JOIN *PREFIX*polls_share user_shares ON (polls_polls.id = user_shares.poll_id) AND (user_shares.user_id = :dcValue5) AND (user_shares.deleted = '0') LEFT JOIN *PREFIX*polls_share group_shares ON (polls_polls.id = group_shares.poll_id) AND (group_shares.type = 'group') AND (group_shares.deleted = '0') WHERE polls_polls.id = :dcValue6 GROUP BY polls_polls.id, user_shares.type, user_shares.locked, user_shares.token","columns":["current_user_count_orphaned_votes"],"exception":[],"CustomMessage":"More than 30 characters for an output column name are not allowed on Oracle."},"id":"672de0c0ca10a"}

Additional environment informations

No response

Configuration report

{
"system": {
"instanceid": "REMOVED SENSITIVE VALUE",
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"memcache.local": "\OC\Memcache\APCu",
"memcache.locking": "\OC\Memcache\Redis",
"trusted_domains": [
"nc.irex.uni-tuebingen.de"
],
"datadirectory": "REMOVED SENSITIVE VALUE",
"dbtype": "mysql",
"version": "30.0.2.2",
"overwrite.cli.url": "https://nc.irex.uni-tuebingen.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,
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_smtphost": "REMOVED SENSITIVE VALUE",
"mail_smtpport": "587",
"default_language": "de",
"default_locale": "de_DE",
"default_phone_region": "DE",
"maintenance": false,
"maintenance_window_start": "1",
"updater.release.channel": "stable",
"theme": "",
"loglevel": 2,
"app_install_overwrite": [
"emlviewer",
"extract",
"transmission",
"bbb",
"quickaccesssorting",
"workflow_kitinerary",
"integration_ews"
],
"mail_from_address": "REMOVED SENSITIVE VALUE",
"mail_domain": "REMOVED SENSITIVE VALUE",
"mail_smtpauth": 1,
"skeletondirectory": "",
"auth.webauthn.enabled": "false",
"mail_smtpname": "REMOVED SENSITIVE VALUE",
"mail_smtppassword": "REMOVED SENSITIVE VALUE",
"data-fingerprint": "21b8cb97ed73b8ebc1d6b9820ffd7b8b",
"simpleSignUpLink.shown": false,
"defaultapp": "",
"forbidden_filename_basenames": [
"con",
"prn",
"aux",
"nul",
"com0",
"com1",
"com2",
"com3",
"com4",
"com5",
"com6",
"com7",
"com8",
"com9",
"com\u00b9",
"com\u00b2",
"com\u00b3",
"lpt0",
"lpt1",
"lpt2",
"lpt3",
"lpt4",
"lpt5",
"lpt6",
"lpt7",
"lpt8",
"lpt9",
"lpt\u00b9",
"lpt\u00b2",
"lpt\u00b3"
],
"forbidden_filename_characters": [
"<",
">",
":",
""",
"|",
"?",
"*",
"\",
"/"
],
"forbidden_filename_extensions": [
" ",
".",
".filepart",
".part"
]
}
}

List of activated Apps

Enabled:

• activity: 3.0.0
• admin_audit: 1.20.0
• analytics: 5.0.1
• app_api: 4.0.0
• approval: 2.0.0
• auto_groups: 1.6.0
• bruteforcesettings: 3.0.0
• calendar: 5.0.1
• calendar_resource_management: 0.8.0
• call_summary_bot: 2.0.0
• cfg_share_links: 6.1.1
• circles: 30.0.0
• cloud_federation_api: 1.13.0
• collectives: 2.15.0
• contacts: 6.1.0
• dashboard: 7.10.0
• dav: 1.31.1
• deck: 1.14.1
• emlviewer: 1.0.11
• external: 5.5.2
• federatedfilesharing: 1.20.0
• federation: 1.20.0
• files: 2.2.0
• files_antivirus: 5.6.0
• files_automatedtagging: 1.20.0
• files_downloadlimit: 3.0.0
• files_linkeditor: 1.1.21
• files_lock: 30.0.0
• files_pdfviewer: 3.0.0
• files_reminders: 1.3.0
• files_sharing: 1.22.0
• files_trashbin: 1.20.1
• files_versions: 1.23.0
• files_zip: 2.1.0
• firstrunwizard: 3.0.0
• flow_notifications: 1.10.0
• forms: 4.3.2
• groupfolders: 18.0.3
• impersonate: 1.17.0
• integration_openstreetmap: 2.0.1
• logreader: 3.0.0
• lookup_server_connector: 1.18.0
• mail: 4.0.2
• nextcloud_announcements: 2.0.0
• notifications: 3.0.0
• oauth2: 1.18.1
• password_policy: 2.0.0
• photos: 3.0.2
• polls: 7.2.4
• privacy: 2.0.0
• provisioning_api: 1.20.0
• quickaccesssorting: 3.0.0
• recommendations: 3.0.0
• related_resources: 1.5.0
• richdocuments: 8.5.2
• serverinfo: 2.0.0
• settings: 1.13.0
• sharebymail: 1.20.0
• side_menu: 4.0.1
• sketch_picker: 2.0.0
• spreed: 20.0.2
• support: 2.0.0
• survey_client: 2.0.0
• suspicious_login: 8.0.0
• systemtags: 1.20.0
• tables: 0.8.1
• tasks: 0.16.1
• text: 4.1.0
• theming: 2.5.0
• twofactor_admin: 4.7.1
• twofactor_backupcodes: 1.19.0
• twofactor_nextcloud_notification: 4.0.0
• twofactor_totp: 12.0.0-dev
• updatenotification: 1.20.0
• user_migration: 7.0.1
• user_status: 1.10.0
• users_picker: 1.0.0
• viewer: 3.0.0
• weather_status: 1.10.0
• webhook_listeners: 1.1.0-dev
• welcome: 1.2.0
• workflow_pdf_converter: 1.15.0
• workflowengine: 2.12.0
  Disabled:
• assistant: 2.1.1 (installed 2.1.1)
• comments: 1.20.1 (installed 1.19.0)
• contactsinteraction: 1.11.0 (installed 1.8.0)
• encryption: 2.18.0 (installed 2.15.0)
• extract: 1.3.6 (installed 1.3.6)
• files_external: 1.22.0
• integration_openai: 3.1.2 (installed 3.1.2)
• picker: 1.0.11 (installed 1.0.11)
• twofactor_email: 2.7.4 (installed 2.7.4)
• user_ldap: 1.21.0
• whiteboard: 1.0.4 (installed 1.0.4)

Nextcloud Signing status

No errors have been found.

Additional Information

No response

[dartcafe]

see #3761

[github-actions]

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.