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]: Numeric value out of range: 7 ERROR: value "16642059021" is out of range for type integer CONTEXT #7405

Closed
6 of 9 tasks
Tealk opened this issue Oct 10, 2022 · 3 comments
Labels

Comments

@Tealk
Copy link

Tealk commented Oct 10, 2022

⚠️ 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).
  • Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
  • Nextcloud Server is running on 64bit capable CPU, PHP and OS.
  • I agree to follow Nextcloud's Code of Conduct.

Bug description

I get the error below when I try to install an app

Steps to reproduce

  1. Call app page
  2. Select app
  3. Download and enable
  4. Enter password
  5. The confirm button remains disabled

Expected behavior

addon is installed

Installation method

Community Manual installation with Archive

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.1

Web server

Nginx

Database engine version

PostgreSQL

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

Updated to a major version (ex. 22.2.3 to 23.0.1)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

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

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "rollenspiel.cloud",
            "192.168.100.11",
            "localhost"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/rollenspiel.cloud",
        "overwriteprotocol": "https",
        "htaccess.RewriteBase": "\/",
        "dbtype": "pgsql",
        "version": "25.0.0.15",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "mysql.utf8mb4": true,
        "installed": true,
        "maintenance": false,
        "default_language": "de",
        "default_locale": "de",
        "default_phone_region": "DE",
        "allow_user_to_change_display_name": true,
        "knowledgebaseenabled": true,
        "theme": "",
        "defaultapp": "apporder",
        "skeletondirectory": "\/mnt\/hdd\/skeleton",
        "trashbin_retention_obligation": "120, auto",
        "versions_retention_obligation": "120, auto",
        "appcodechecker": true,
        "updatechecker": true,
        "updater.release.channel": "beta",
        "check_for_working_webdav": true,
        "maintenance_window_start": 3,
        "loglevel": 2,
        "logdateformat": "d.m.Y H:i:s",
        "logtimezone": "Europe\/Berlin",
        "log_rotate_size": 10485760,
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "PLAIN",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "ssl",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "enable_previews": true,
        "preview_max_x": 2048,
        "preview_max_y": 2048,
        "preview_max_filesize_image": 50,
        "preview_max_scale_factor": 10,
        "data-fingerprint": "d76fcffe3970dd2910ea5d733e3ed673",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\APCu",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "dbindex": 1,
            "timeout": 1.5
        },
        "filelocking.enabled": "true",
        "twofactor_enforced": false,
        "twofactor_enforced_groups": [
            "admin"
        ],
        "twofactor_enforced_excluded_groups": [],
        "mail_sendmailmode": "smtp",
        "migrate_guest_user_data": true,
        "remove_guest_account_on_conversion": true,
        "keep_users_without_login": "no",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "uppush",
            "gpgmailer"
        ]
    }
}

List of activated Apps

Enabled:
  - activity: 2.17.0
  - admin_audit: 1.15.0
  - approval: 1.0.10
  - calendar: 4.0.0-alpha.1
  - circles: 25.0.0-alpha.0
  - cloud_federation_api: 1.8.0
  - collectives: 2.0.0-beta3
  - comments: 1.15.0
  - contacts: 5.0.0-rc.1
  - dashboard: 7.5.0
  - dav: 1.24.0
  - deck: 1.8.0-beta.2
  - drop_account: 2.1.0
  - federatedfilesharing: 1.15.0
  - federation: 1.15.0
  - files: 1.20.0
  - files_downloadactivity: 1.15.0
  - files_lock: 24.0.1
  - files_pdfviewer: 2.6.0
  - files_rightclick: 1.4.0
  - files_sharing: 1.17.0
  - files_trashbin: 1.15.0
  - files_versions: 1.18.0
  - fileslibreofficeedit: 1.1.0
  - firstrunwizard: 2.14.0
  - forms: 3.0.0-beta.2
  - gpgmailer: 0.0.4
  - groupfolders: 13.0.0
  - guests: 2.3.0
  - logreader: 2.10.0
  - lookup_server_connector: 1.13.0
  - mail: 2.0.0-rc.1
  - maps: 0.2.1
  - nextcloud_announcements: 1.14.0
  - notes: 4.5.1
  - notifications: 2.13.1
  - oauth2: 1.13.0
  - password_policy: 1.15.0
  - photos: 1.7.1
  - polls: 4.0.0-beta3
  - privacy: 1.9.0
  - provisioning_api: 1.15.0
  - recognize: 3.0.0-beta.3
  - related_resources: 1.0.0
  - richdocuments: 7.0.0-beta.2
  - serverinfo: 1.15.0
  - settings: 1.7.0
  - sharebymail: 1.15.0
  - spreed: 15.0.0-rc.3
  - survey_client: 1.13.0
  - systemtags: 1.15.0
  - text: 3.6.0
  - theming: 2.0.0
  - theming_customcss: 1.12.0
  - twofactor_backupcodes: 1.14.0
  - twofactor_email: 2.7.0
  - twofactor_nextcloud_notification: 3.5.0-beta.1
  - twofactor_totp: 7.0.0
  - twofactor_webauthn: 1.0.0-RC.1
  - updatenotification: 1.15.0
  - user_status: 1.5.0
  - viewer: 1.9.0
  - workflowengine: 2.7.0
Disabled:
  - appointments: 1.12.8
  - apporder: 0.15.0
  - breezedark: 24.0.2
  - bruteforcesettings: 1.3.0
  - contactsinteraction: 1.3.0
  - drawio: 1.0.3
  - encryption
  - event_update_notification: 1.5.0
  - files_external
  - files_linkeditor: 1.1.11
  - files_markdown: 2.3.6
  - jitsi: 0.15.0
  - metadata: 0.16.0
  - quota_warning: 1.14.0
  - recommendations: 1.3.0
  - registration: 1.5.0
  - side_menu: 2.5.1
  - socialsharing_email: 2.5.0
  - support: 1.5.0
  - suspicious_login
  - tasks: 0.14.4
  - uppush: 1.1.1
  - user_ldap
  - user_migration: 1.1.0
  - user_retention: 1.7.0
  - weather_status: 1.0.0

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{
  "reqId": "IjJYra6oPxWriQFGaKnM",
  "level": 3,
  "time": "2022-10-10T17:25:02+02:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job (class: OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob, arguments: Array\n(\n    [accountId] => 3\n)\n)",
  "userAgent": "--",
  "version": "25.0.0.15",
  "exception": {
    "Exception": "OC\\DB\\Exceptions\\DbalException",
    "Message": "An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \"16642059021\" is out of range for type integer\nCONTEXT:  unnamed portal parameter $1 = '...'",
    "Code": 7,
    "Trace": [
      {
        "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 296,
        "function": "wrap",
        "class": "OC\\DB\\Exceptions\\DbalException",
        "type": "::"
      },
      {
        "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
        "line": 336,
        "function": "executeQuery",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/mail/lib/Db/MessageMapper.php",
        "line": 1321,
        "function": "findEntities",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/mail/lib/Service/PreprocessingService.php",
        "line": 66,
        "function": "getUnanalyzed",
        "class": "OCA\\Mail\\Db\\MessageMapper",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/mail/lib/BackgroundJob/PreviewEnhancementProcessingJob.php",
        "line": 94,
        "function": "process",
        "class": "OCA\\Mail\\Service\\PreprocessingService",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/public/BackgroundJob/Job.php",
        "line": 78,
        "function": "run",
        "class": "OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
        "line": 103,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
        "line": 93,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/cron.php",
        "line": 152,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      }
    ],
    "File": "/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php",
    "Line": 71,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
      "Message": "An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \"16642059021\" is out of range for type integer\nCONTEXT:  unnamed portal parameter $1 = '...'",
      "Code": 7,
      "Trace": [
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1780,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1719,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1067,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
          "line": 261,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
          "line": 345,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 281,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 294,
          "function": "execute",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
          "line": 336,
          "function": "executeQuery",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/apps/mail/lib/Db/MessageMapper.php",
          "line": 1321,
          "function": "findEntities",
          "class": "OCP\\AppFramework\\Db\\QBMapper",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/apps/mail/lib/Service/PreprocessingService.php",
          "line": 66,
          "function": "getUnanalyzed",
          "class": "OCA\\Mail\\Db\\MessageMapper",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/apps/mail/lib/BackgroundJob/PreviewEnhancementProcessingJob.php",
          "line": 94,
          "function": "process",
          "class": "OCA\\Mail\\Service\\PreprocessingService",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/public/BackgroundJob/Job.php",
          "line": 78,
          "function": "run",
          "class": "OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
          "line": 103,
          "function": "start",
          "class": "OCP\\BackgroundJob\\Job",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
          "line": 93,
          "function": "start",
          "class": "OCP\\BackgroundJob\\TimedJob",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/cron.php",
          "line": 152,
          "function": "execute",
          "class": "OCP\\BackgroundJob\\TimedJob",
          "type": "->"
        }
      ],
      "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",
      "Line": 83,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \"16642059021\" is out of range for type integer\nCONTEXT:  unnamed portal parameter $1 = '...'",
        "Code": 7,
        "Trace": [
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
            "line": 94,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::"
          },
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1057,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
            "line": 261,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
            "line": 345,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 281,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 294,
            "function": "execute",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
            "line": 336,
            "function": "executeQuery",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/apps/mail/lib/Db/MessageMapper.php",
            "line": 1321,
            "function": "findEntities",
            "class": "OCP\\AppFramework\\Db\\QBMapper",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/apps/mail/lib/Service/PreprocessingService.php",
            "line": 66,
            "function": "getUnanalyzed",
            "class": "OCA\\Mail\\Db\\MessageMapper",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/apps/mail/lib/BackgroundJob/PreviewEnhancementProcessingJob.php",
            "line": 94,
            "function": "process",
            "class": "OCA\\Mail\\Service\\PreprocessingService",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/public/BackgroundJob/Job.php",
            "line": 78,
            "function": "run",
            "class": "OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
            "line": 103,
            "function": "start",
            "class": "OCP\\BackgroundJob\\Job",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
            "line": 93,
            "function": "start",
            "class": "OCP\\BackgroundJob\\TimedJob",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/cron.php",
            "line": 152,
            "function": "execute",
            "class": "OCP\\BackgroundJob\\TimedJob",
            "type": "->"
          }
        ],
        "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 26,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \"16642059021\" is out of range for type integer\nCONTEXT:  unnamed portal parameter $1 = '...'",
          "Code": "22003",
          "Trace": [
            {
              "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
              "line": 92,
              "function": "execute",
              "class": "PDOStatement",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1057,
              "function": "execute",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
              "line": 261,
              "function": "executeQuery",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
              "line": 345,
              "function": "executeQuery",
              "class": "OC\\DB\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
              "line": 281,
              "function": "execute",
              "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
              "line": 294,
              "function": "execute",
              "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
              "line": 336,
              "function": "executeQuery",
              "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/apps/mail/lib/Db/MessageMapper.php",
              "line": 1321,
              "function": "findEntities",
              "class": "OCP\\AppFramework\\Db\\QBMapper",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/apps/mail/lib/Service/PreprocessingService.php",
              "line": 66,
              "function": "getUnanalyzed",
              "class": "OCA\\Mail\\Db\\MessageMapper",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/apps/mail/lib/BackgroundJob/PreviewEnhancementProcessingJob.php",
              "line": 94,
              "function": "process",
              "class": "OCA\\Mail\\Service\\PreprocessingService",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/public/BackgroundJob/Job.php",
              "line": 78,
              "function": "run",
              "class": "OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
              "line": 103,
              "function": "start",
              "class": "OCP\\BackgroundJob\\Job",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
              "line": 93,
              "function": "start",
              "class": "OCP\\BackgroundJob\\TimedJob",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/cron.php",
              "line": 152,
              "function": "execute",
              "class": "OCP\\BackgroundJob\\TimedJob",
              "type": "->"
            }
          ],
          "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
          "Line": 92
        }
      }
    },
    "message": "Error while running background job (class: OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob, arguments: Array\n(\n    [accountId] => 3\n)\n)",
    "exception": [],
    "CustomMessage": "Error while running background job (class: OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob, arguments: Array\n(\n    [accountId] => 3\n)\n)"
  },
  "id": "634439dd4ba36"
}

Additional info

the installation via the cli works

@kesselb
Copy link
Contributor

kesselb commented Oct 10, 2022

cc @ChristophWurst @miaulalala

@szaimen szaimen transferred this issue from nextcloud/server Oct 10, 2022
@ChristophWurst
Copy link
Member

@miaulalala you talked about this the other day. Was this fixed?

@miaulalala
Copy link
Contributor

@miaulalala you talked about this the other day. Was this fixed?

yes that is #7312

It will be shipped in the next release.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants