Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Can't install or enable app #45410

Closed
4 of 8 tasks
fungos opened this issue May 20, 2024 · 2 comments
Closed
4 of 8 tasks

[Bug]: Can't install or enable app #45410

fungos opened this issue May 20, 2024 · 2 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 29-feedback bug

Comments

@fungos
Copy link

fungos commented May 20, 2024

⚠️ This issue respects the following points: ⚠️

Bug description

Impossible to install or enable an app.
If I try to use occ app:install talk for example, I get a message: Error: Could not download app talk.
If I try to enable talk via the web interface, I get a message: `Error: This app cannot be enabled because it makes the server unstable'.

I've tried everything and I'm not sure what else I can try. Some things I tried:
overwriteprotocol, modifing php to debug, nginx reverse proxy settings, docker settings, database repair, etc.

This is because I can't just get any reliable information on the net about what may be happening, and looking at logs and browser inspection, I get mostly two errors when clicking on enable web interface:

  1. Content-Security-Policy: The page’s settings blocked the loading of a resource (connect-src) at http://my.host.name/apps/files/ because it violates the following directive: “connect-src 'self'”

This is because I have a nginx proxy with ssl/https, and it redirects http connections to https. Nextcloud is in docker listing to http. I tried all kinds of overwrite* arguments in config.php, nothing worked.

  1. In the log I have an absurd amount of exceptions of dirty read.

Not sure how to fix this one.

Steps to reproduce

  1. try to enable an app

Expected behavior

Be able to install or enable apps

Installation method

Docker community image

Nextcloud Server version

29

Operating system

Manjaro

PHP engine version

8.3

Web server

nginx

Database engine version

MySQL

Is this bug present after an update or on a fresh install?

After upgrading from 27 maybe

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

Configuration report

/var/www/html $ php occ config:list system
{
    "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
        },
        "log_type": "file",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "my.host.name"
        ],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "overwritecondaddr": "^172\\.19\\.0\\.",
        "overwritehost": "my.host.name",
        "overwriteprotocol": "https",
        "overwrite.cli.url": "https:\/\/my.host.name\/",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "maintenance": false,
        "installed": true,
        "theme": "",
        "loglevel": 0,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "upgrade.disable-web": true,
        "dbtype": "mysql",
        "version": "29.0.0.19",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "memories.exiftool": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/exiftool-amd64-musl",
        "memories.vod.path": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/go-vod-amd64",
        "enabledPreviewProviders": [
            "OC\\Preview\\Image",
            "OC\\Preview\\TIFF",
            "OC\\Preview\\Movie",
            "OC\\Preview\\HEIC"
        ],
        "app_install_overwrite": [
            "spreed",
            "quicknotes"
        ]
    }
}

List of activated Apps

/var/www/html $ php occ app:list
Enabled:
  - activity: 2.21.1
  - admin_audit: 1.19.0
  - bruteforcesettings: 2.9.0
  - calendar: 4.7.4
  - circles: 29.0.0-dev
  - cloud_federation_api: 1.12.0
  - contacts: 6.0.0
  - contactsinteraction: 1.10.0
  - dashboard: 7.9.0
  - dav: 1.30.1
  - event_update_notification: 2.4.0
  - federatedfilesharing: 1.19.0
  - files: 2.1.0
  - files_downloadlimit: 2.0.0
  - files_pdfviewer: 2.10.0
  - files_reminders: 1.2.0
  - files_sharing: 1.21.0
  - firstrunwizard: 2.18.0
  - integration_google: 2.2.0
  - integration_mastodon: 2.0.5
  - logreader: 2.14.0
  - lookup_server_connector: 1.17.0
  - mail: 3.6.1
  - memories: 7.3.1
  - notifications: 2.17.0
  - oauth2: 1.17.0
  - password_policy: 1.19.0
  - photos: 2.5.0
  - provisioning_api: 1.19.0
  - related_resources: 1.4.0
  - richdocuments: 8.4.2
  - settings: 1.12.0
  - sharebymail: 1.19.0
  - theming: 2.4.0
  - twofactor_backupcodes: 1.18.0
  - updatenotification: 1.19.1
  - viewer: 2.3.0
  - weather_status: 1.9.0
  - workflowengine: 2.11.0
Disabled:
  - comments: 1.19.0 (installed 1.10.0)
  - encryption: 2.17.0
  - federation: 1.19.0 (installed 1.10.1)
  - files_external: 1.21.0
  - files_trashbin: 1.19.0 (installed 1.10.1)
  - files_versions: 1.22.0 (installed 1.13.0)
  - forms: 4.2.3 (installed 4.2.3)
  - fulltextsearch: 28.0.1 (installed 28.0.1)
  - keeweb: 0.6.18 (installed 0.6.18)
  - maps: 1.4.0 (installed 1.4.0)
  - nextcloud_announcements: 1.18.0 (installed 1.9.0)
  - onlyoffice: 9.2.0 (installed 9.2.0)
  - privacy: 1.13.0 (installed 1.4.0)
  - quicknotes: 0.8.22 (installed 0.8.22)
  - recommendations: 2.1.0 (installed 0.8.0)
  - riotchat: 0.17.1 (installed 0.17.1)
  - serverinfo: 1.19.0 (installed 1.10.0)
  - socialsharing_email: 3.1.0 (installed 3.1.0)
  - socialsharing_facebook: 3.1.0 (installed 3.1.0)
  - socialsharing_twitter: 3.1.0 (installed 3.1.0)
  - spreed: 19.0.0 (installed 19.0.0)
  - support: 1.12.0 (installed 1.3.0)
  - survey_client: 1.17.0 (installed 1.8.0)
  - suspicious_login: 7.0.0
  - systemtags: 1.19.0 (installed 1.10.0)
  - text: 3.10.0 (installed 3.10.0)
  - twofactor_totp: 11.0.0-dev (installed 6.4.1)
  - user_ldap: 1.20.0
  - user_status: 1.9.0 (installed 1.9.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\CheckMatterbridges","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\CheckMatterbridges","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\CheckMatterbridges"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\CheckTurnCertificate"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\ExpireChatMessages","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\ExpireChatMessages","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\ExpireChatMessages"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\Reminder","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\Reminder","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\Reminder"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1",["OCA\\Talk\\BackgroundJob\\RetryNotificationsJob","37a6259cc0c1dae299a7866489dff0bd"],[2,2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":166,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/BackgroundJob/JobList.php","line":78,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\RetryNotificationsJob","null"]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->","args":["OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]},{"file":"/var/www/html/lib/private/Installer.php","line":144,"function":"setupBackgroundJobs","class":"OC_App","type":"::","args":[["OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer","OCA\\Talk\\BackgroundJob\\CheckMatterbridges","OCA\\Talk\\BackgroundJob\\CheckReferenceIdColumn","OCA\\Talk\\BackgroundJob\\CheckTurnCertificate","OCA\\Talk\\BackgroundJob\\ExpireChatMessages","OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage","OCA\\Talk\\BackgroundJob\\Reminder","OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms","OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer","OCA\\Talk\\BackgroundJob\\RetryNotificationsJob"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"GKKcRBtCItc7WKFFzYOQ","level":0,"time":"2024-05-20T15:25:33+00:00","remoteAddr":"172.19.0.1","user":"fungos","app":"no app in context","method":"POST","url":"/settings/apps/enable","message":"dirty table reads: SELECT `id`, `class` FROM `*PREFIX*jobs` WHERE `class` LIKE :dcValue1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0","version":"29.0.0.19","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id`, `class` FROM `*PREFIX*jobs` WHERE `class` LIKE :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `id`, `class` FROM `*PREFIX*jobs` WHERE `class` LIKE :dcValue1",["%Spreed%"],[2],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/spreed/lib/Migration/FixNamespaceInDatabaseTables.php","line":54,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/Repair.php","line":124,"function":"run","class":"OCA\\Talk\\Migration\\FixNamespaceInDatabaseTables","type":"->","args":[["OC\\Repair"]]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":838,"function":"run","class":"OC\\Repair","type":"->","args":[]},{"file":"/var/www/html/lib/private/Installer.php","line":149,"function":"executeRepairSteps","class":"OC_App","type":"::","args":["spreed",["OCA\\Talk\\Migration\\CreateHelpCommand"]]},{"file":"/var/www/html/apps/settings/lib/Controller/AppSettingsController.php","line":521,"function":"installApp","class":"OC\\Installer","type":"->","args":["spreed"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->","args":[["spreed"],[]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Settings\\Controller\\AppSettingsController"],"enableApps"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AppSettingsController","enableApps",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["settings.appsettings.enableapps"]]},{"file":"/var/www/html/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/apps/enable"]},{"file":"/var/www/html/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":300,"message":"dirty table reads: SELECT `id`, `class` FROM `*PREFIX*jobs` WHERE `class` LIKE :dcValue1","tables":["oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id`, `class` FROM `*PREFIX*jobs` WHERE `class` LIKE :dcValue1"}}

Additional info

No response

@fungos fungos added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels May 20, 2024
@kesselb
Copy link
Contributor

kesselb commented May 20, 2024

Hi, sounds like #45378.

Please check and close this issue if related.

@fungos
Copy link
Author

fungos commented May 20, 2024

Looks similar, not sure how I missed this one. Will close for now, thanks.

@fungos fungos closed this as completed May 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 29-feedback bug
Projects
None yet
Development

No branches or pull requests

3 participants