[Bug]: Error while running background job `OCA\\DAV\\Migration\\BuildSocialSearchIndexBackgroundJob`

[szaimen]

⚠️ 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 OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

Error logged after upgrading to 29.0.3

Steps to reproduce

1. upgrade to 29.0.3
2. see error in the logs

{
  "reqId": "625OdztVi2fbvKqsf9dR",
  "level": 3,
  "time": "2024-06-25T10:57:17+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "Error while running background job OCA\\DAV\\Migration\\BuildSocialSearchIndexBackgroundJob (id: 976, arguments: {\"offset\":0,\"stopAt\":23})",
  "userAgent": "--",
  "version": "29.0.3.4",
  "exception": {
    "Exception": "TypeError",
    "Message": "OCA\\DAV\\CardDAV\\CardDavBackend::getUID(): Argument #1 ($cardData) must be of type string, resource given, called in /var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php on line 708",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
        "line": 708,
        "function": "getUID",
        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/Migration/BuildSocialSearchIndexBackgroundJob.php",
        "line": 90,
        "function": "updateCard",
        "class": "OCA\\DAV\\CardDAV\\CardDavBackend",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/Migration/BuildSocialSearchIndexBackgroundJob.php",
        "line": 53,
        "function": "buildIndex",
        "class": "OCA\\DAV\\Migration\\BuildSocialSearchIndexBackgroundJob",
        "type": "->",
        "args": [
          23,
          23
        ]
      },
      {
        "file": "/var/www/html/lib/public/BackgroundJob/Job.php",
        "line": 80,
        "function": "run",
        "class": "OCA\\DAV\\Migration\\BuildSocialSearchIndexBackgroundJob",
        "type": "->",
        "args": [
          [
            0,
            23
          ]
        ]
      },
      {
        "file": "/var/www/html/lib/public/BackgroundJob/QueuedJob.php",
        "line": 57,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->",
        "args": [
          [
            "OC\\BackgroundJob\\JobList"
          ]
        ]
      },
      {
        "file": "/var/www/html/lib/public/BackgroundJob/QueuedJob.php",
        "line": 47,
        "function": "start",
        "class": "OCP\\BackgroundJob\\QueuedJob",
        "type": "->",
        "args": [
          [
            "OC\\BackgroundJob\\JobList"
          ]
        ]
      },
      {
        "file": "/var/www/html/cron.php",
        "line": 177,
        "function": "execute",
        "class": "OCP\\BackgroundJob\\QueuedJob",
        "type": "->",
        "args": [
          [
            "OC\\BackgroundJob\\JobList"
          ]
        ]
      }
    ],
    "File": "/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php",
    "Line": 1477,
    "message": "Error while running background job OCA\\DAV\\Migration\\BuildSocialSearchIndexBackgroundJob (id: 976, arguments: {\"offset\":0,\"stopAt\":23})",
    "exception": [],
    "CustomMessage": "Error while running background job OCA\\DAV\\Migration\\BuildSocialSearchIndexBackgroundJob (id: 976, arguments: {\"offset\":0,\"stopAt\":23})"
  },
  "id": "667aa2fd69054"
}

Expected behavior

should not log an error

Installation method

Official All-in-One appliance

Nextcloud Server version

29

Operating system

None

PHP engine version

None

Web server

None

Database engine version

PostgreSQL

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

None

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

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

[ChristophWurst]

This is similar to #21696. The LONGTEXT column is apparently returned as string|resource but we expect it to always be string

[ashe0047]

Is there a fix coming soon for this bug?

[kelke]

I see a check next to nextcloud: increase to 29.0.3 #4886.

Does that mean this issue is solved?

[vladbejenaru]

Does that mean this issue is solved?

This just completed the my collection of errors on a fresh upgrade to 29.0.6... tbh the other errors were on the 29.0.3... this is new ;-)

Running Nextcloud AIO, thinking to nuke it and to install it anew.... :(

[AdamB2023]

I'm also having this issue with recent version:

TypeError
OCA\DAV\CardDAV\CardDavBackend::getUID(): Argument #1 ($cardData) must be of type string, resource given, called in /var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php on line 708
Error while running background job OCA\DAV\Migration\BuildSocialSearchIndexBackgroundJob (id: 1391, arguments: {"offset":0,"stopAt":18})

[wolandtel]

Still actual for 30.0.2:

Background job OC\Core\BackgroundJobs\GenerateMetadataJob (id: 3466, arguments: null) ran for 16934 seconds 2024-11-15T02:09:39+00:00
TypeError: OCA\DAV\CardDAV\CardDavBackend::getUID(): Argument #1 ($cardData) must be of type string, resource given, called in 2024-11-15T06:16:04+00:00
/var/www/s.woland.me/apps/dav/lib/CardDAV/CardDavBackend.php on line 680 at apps/dav/lib/CardDAV/CardDavBackend.php line 1449

[wolandtel]

Looks like this should solve the problem. I'll wait for next cron job start.

--- apps/dav/lib/Migration/BuildSocialSearchIndexBackgroundJob-orig.php 2024-11-15 18:33:06.664205182 +0500
+++ apps/dav/lib/Migration/BuildSocialSearchIndexBackgroundJob.php  2024-11-15 18:35:09.134761969 +0500
@@ -71,7 +71,11 @@
        // refresh identified contacts in order to re-index
        foreach ($social_cards as $contact) {
            $offset = $contact['id'];
-           $this->davBackend->updateCard($contact['addressbookid'], $contact['uri'], $contact['carddata']);
+           $data = $contact['carddata'];
+           if (is_resource($data) && (get_resource_type($data) == 'stream')) {
+               $data = stream_get_contents($data);
+           }   
+           $this->davBackend->updateCard($contact['addressbookid'], $contact['uri'], $data);
 
            // stop after 15sec (to be continued with next chunk)
            if (($this->time->getTime() - $startTime) > 15) {