Error: Database error when running migration 4004Date20230414163505 for app calendar #5304

solracsf · 2023-06-09T20:11:33Z

Steps to reproduce

occ app:update --all
Error: Database error when running migration 4004Date20230414163505 for app calendar", "Migration step 'OCA\Calendar\Migration\Version4004Date20230414163505' is unknown
occ upgrade fixes the instance
Same error on 2 different instances

Expected behavior

Migration is fine

Actual behaviour

Error.

Calendar app version

4.4.1

CalDAV-clients used

No response

Browser

No response

Client operating system

No response

Server operating system

No response

Web server

Apache

Database engine version

MariaDB

PHP engine version

PHP 8.1

Nextcloud version

25.0.7

Updated from an older installed version or fresh install

Updated from an older version

List of activated apps

No response

Nextcloud configuration

No response

Web server error log

No response

Log file

Error: Database error when running migration 4004Date20230414163505 for app calendar", "Migration step 'OCA\\Calendar\\Migration\\Version4004Date20230414163505' is unknown

Browser log

No response

Additional info

No response

The text was updated successfully, but these errors were encountered:

melroy89 · 2023-06-09T23:39:22Z

Duplicate: #5191

The new release 4.4.1 should fix this issue again.. Correct?

ChristophWurst · 2023-06-10T06:14:18Z

Yes

solracsf · 2023-06-10T06:38:21Z

The new release 4.4.1 should fix this issue again.. Correct?

But...this is the 4.4.1 release I'm trying to install 😞

drhirn · 2023-06-10T09:42:54Z

The new release 4.4.1 should fix this issue again.. Correct?

Unfortunately not. Had the same error than @solracsf. And after that I'm getting:

The files of the app files_trashbin (files_trashbin), files_versions (files_versions) were not replaced correctly. Make sure it is a version compatible with the server.

NC 26
Tried to update from Calendar 4.3.4 to 4.4.1

ChristophWurst · 2023-06-10T13:19:04Z

The calendar release does not fix upgrade errors with files version or files trashbin. What we fixed is the missing class error.

Struppie · 2023-06-10T13:46:06Z

maybe also worth to take a look into this related issue? 2727

heisenbol · 2023-06-10T18:30:08Z

same here. From 4.3.5 to 4.4.1 on latest nextcloud 25 series.
After the error, when trying to view another page on nextcloud, I was presented with the maintenance screen, telling me that an update was pending. I confirmed to proceed with the update, and everything was resolved

Struppie · 2023-06-10T18:50:56Z

@flozz @sksksksk Solution mentioned in above link to issue https://github.com/nextcloud/all-in-one/issues/2727

NuclearPhoenixx · 2023-06-11T13:14:33Z

same here. From 4.3.5 to 4.4.1 on latest nextcloud 25 series.
After the error, when trying to view another page on nextcloud, I was presented with the maintenance screen, telling me that an update was pending. I confirmed to proceed with the update, and everything was resolved

Same here.

Only that after clicking on that "proceed update" button, I got another error, telling me to refresh the website. After doing so, the server is now completely crashed Error 503. Great.

ChristophWurst · 2023-06-11T15:35:25Z

#5191 (comment) as a counter example

ChristophWurst · 2023-06-11T15:38:55Z

What PHP version do you all use and what are your opcache settings? I could imagine that the old (and faulty) autoloader was still active because opcache didn't clear early enough.

ChristophWurst · 2023-06-11T15:41:01Z

The 4.4.1 release does contain an autoloader mapping for

'OCA\\Calendar\\Migration\\Version4004Date20230414163505' => $baseDir . '/lib/Migration/Version4004Date20230414163505.php',

in vendor/composer/autoload_classmap.php.

solracsf · 2023-06-11T15:41:57Z

@ChristophWurst opcache.cli is disabled, and app update has been performed on CLI by occ app:update --all.
Using PHP v8.1. Not using apcu either (not even installed).

{
  "reqId": "xivzUkHEkn4kLH2esu1D",
  "level": 3,
  "time": "2023-06-09T22:06:41+02:00",
  "remoteAddr": "",
  "user": "--",
  "app": "app:update",
  "method": "",
  "url": "--",
  "message": "Failure during update of app \"calendar\"",
  "userAgent": "--",
  "version": "25.0.7.1",
  "exception": {
    "Exception": "Exception",
    "Message": "Database error when running migration 4004Date20230414163505 for app calendar\nMigration step 'OCA\\Calendar\\Migration\\Version4004Date20230414163505' is unknown",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/nextcloud/lib/private/legacy/OC_App.php",
        "line": 1008,
        "function": "migrate",
        "class": "OC\\DB\\MigrationService",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/Installer.php",
        "line": 200,
        "function": "updateApp",
        "class": "OC_App",
        "type": "::",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/nextcloud/core/Command/App/Update.php",
        "line": 107,
        "function": "updateAppstoreApp",
        "class": "OC\\Installer",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
        "line": 255,
        "function": "execute",
        "class": "OC\\Core\\Command\\App\\Update",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 1009,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Command\\Command",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 273,
        "function": "doRunCommand",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 149,
        "function": "doRun",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/Console/Application.php",
        "line": 214,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/console.php",
        "line": 100,
        "function": "run",
        "class": "OC\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/occ",
        "line": 11,
        "args": [
          "/var/www/nextcloud/console.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/nextcloud/lib/private/DB/MigrationService.php",
    "Line": 420,
    "Previous": {
      "Exception": "InvalidArgumentException",
      "Message": "Migration step 'OCA\\Calendar\\Migration\\Version4004Date20230414163505' is unknown",
      "Code": 0,
      "Trace": [
        {
          "file": "/var/www/nextcloud/lib/private/DB/MigrationService.php",
          "line": 513,
          "function": "createInstance",
          "class": "OC\\DB\\MigrationService",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/MigrationService.php",
          "line": 416,
          "function": "executeStep",
          "class": "OC\\DB\\MigrationService",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/legacy/OC_App.php",
          "line": 1008,
          "function": "migrate",
          "class": "OC\\DB\\MigrationService",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/Installer.php",
          "line": 200,
          "function": "updateApp",
          "class": "OC_App",
          "type": "::",
          "args": [
            "*** sensitive parameters replaced ***"
          ]
        },
        {
          "file": "/var/www/nextcloud/core/Command/App/Update.php",
          "line": 107,
          "function": "updateAppstoreApp",
          "class": "OC\\Installer",
          "type": "->",
          "args": [
            "*** sensitive parameters replaced ***"
          ]
        },
        {
          "file": "/var/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
          "line": 255,
          "function": "execute",
          "class": "OC\\Core\\Command\\App\\Update",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
          "line": 1009,
          "function": "run",
          "class": "Symfony\\Component\\Console\\Command\\Command",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
          "line": 273,
          "function": "doRunCommand",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
          "line": 149,
          "function": "doRun",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/Console/Application.php",
          "line": 214,
          "function": "run",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/console.php",
          "line": 100,
          "function": "run",
          "class": "OC\\Console\\Application",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/occ",
          "line": 11,
          "args": [
            "/var/www/nextcloud/console.php"
          ],
          "function": "require_once"
        }
      ],
      "File": "/var/www/nextcloud/lib/private/DB/MigrationService.php",
      "Line": 498
    },
    "message": "Failure during update of app \"calendar\"",
    "exception": [],
    "CustomMessage": "Failure during update of app \"calendar\""
  },
  "id": "6485eb2000ae9"
}

{
  "reqId": "xivzUkHEkn4kLH2esu1D",
  "level": 3,
  "time": "2023-06-09T22:06:41+02:00",
  "remoteAddr": "",
  "user": "--",
  "app": "PHP",
  "method": "",
  "url": "--",
  "message": "Undefined variable $result at /var/www/nextcloud/core/Command/App/Update.php#117",
  "userAgent": "--",
  "version": "25.0.7.1",
  "exception": {
    "Exception": "Error",
    "Message": "Undefined variable $result at /var/www/nextcloud/core/Command/App/Update.php#117",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/nextcloud/core/Command/App/Update.php",
        "line": 117,
        "function": "onError",
        "class": "OC\\Log\\ErrorHandler",
        "type": "::"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
        "line": 255,
        "function": "execute",
        "class": "OC\\Core\\Command\\App\\Update",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 1009,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Command\\Command",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 273,
        "function": "doRunCommand",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 149,
        "function": "doRun",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/Console/Application.php",
        "line": 214,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/console.php",
        "line": 100,
        "function": "run",
        "class": "OC\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/occ",
        "line": 11,
        "args": [
          "/var/www/nextcloud/console.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/nextcloud/lib/private/Log/ErrorHandler.php",
    "Line": 92,
    "CustomMessage": "--"
  },
  "id": "6485eb20009df"
}

{
  "reqId": "xivzUkHEkn4kLH2esu1D",
  "level": 3,
  "time": "2023-06-09T22:06:41+02:00",
  "remoteAddr": "",
  "user": "--",
  "app": "PHP",
  "method": "",
  "url": "--",
  "message": "Undefined variable $result at /var/www/nextcloud/core/Command/App/Update.php#120",
  "userAgent": "--",
  "version": "25.0.7.1",
  "exception": {
    "Exception": "Error",
    "Message": "Undefined variable $result at /var/www/nextcloud/core/Command/App/Update.php#120",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/nextcloud/core/Command/App/Update.php",
        "line": 120,
        "function": "onError",
        "class": "OC\\Log\\ErrorHandler",
        "type": "::"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
        "line": 255,
        "function": "execute",
        "class": "OC\\Core\\Command\\App\\Update",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 1009,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Command\\Command",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 273,
        "function": "doRunCommand",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/symfony/console/Application.php",
        "line": 149,
        "function": "doRun",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/Console/Application.php",
        "line": 214,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/console.php",
        "line": 100,
        "function": "run",
        "class": "OC\\Console\\Application",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/occ",
        "line": 11,
        "args": [
          "/var/www/nextcloud/console.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/nextcloud/lib/private/Log/ErrorHandler.php",
    "Line": 92,
    "CustomMessage": "--"
  },
  "id": "6485eb20009bc"
}

ChristophWurst · 2023-06-11T15:54:05Z

I was able to trigger it myself with an upgrade from 4.3.0 to 4.4.1

The issue is that #5295 fixes the autoloader but the autoloader fix for an upgrade only takes affect for future upgrades. So 4.4.2 or 4.5.0 will be fine only :s

ChristophWurst · 2023-06-11T15:59:07Z

ChristophWurst · 2023-06-12T07:25:20Z

The plan to get instances unstuck is as follows

Installations of Calendar <=4.3.4 update to v4.3.5, get a fixed autoloader and smooth upgrade in the future
Installations of Calendar 4.4.0 should wait for v4.4.2
Installations of Calendar v4.4.1 do not need any more fixing can go to v4.4.2
The Talk room for appointments feature will return shortly in v4.5, by which I hope instances are on either v4.3.5 or v4.4.2. Unfortunately I can't prevent the bumpy upgrade for instances going from <=4.3.4 to v4.4.x.

Progress is tracked in #5304 (comment).

flozz · 2023-06-12T09:43:08Z

I just updated 4.3.4 to 4.3.5 without any issue :)

ChristophWurst · 2023-06-12T17:02:15Z

https://github.com/nextcloud-releases/calendar/releases/tag/v4.4.2 tagged. Release will be built in a few minutes.

I did a prerelease earlier to test the update in a production-like environment with the real app store:

4.3.4->4.4.0	4.3.4->4.4.2

I hope this gives everyone a smooth upgrade.

ChristophWurst · 2023-06-12T18:09:01Z

A verbose summary of what went wrong: https://help.nextcloud.com/t/post-mortem-analysis-composer-authoritative-classloader/163969

Thanks for the reports and system infos, everyone.

flozz · 2023-06-13T12:48:29Z

4.3.5 updated to 4.4.2 flawlessly 👌

ChristophWurst · 2023-08-17T18:11:48Z

This is done. The reverted feature will revive with v4.5.

solracsf added bug 0. to triage Pending approval or rejection labels Jun 9, 2023

solracsf closed this as completed Jun 10, 2023

solracsf reopened this Jun 10, 2023

This comment was marked as outdated.

Sign in to view

This comment was marked as duplicate.

Sign in to view

This comment was marked as resolved.

Sign in to view

solracsf added 2. developing Work in progress and removed 0. to triage Pending approval or rejection labels Jun 11, 2023

ChristophWurst self-assigned this Jun 11, 2023

ChristophWurst added this to 💌 📅 👥 Groupware team Jun 11, 2023

ChristophWurst moved this to 🏗️ In progress in 💌 📅 👥 Groupware team Jun 11, 2023

ChristophWurst mentioned this issue Jun 12, 2023

Revert "Create Talk rooms for appointments" #5306

Merged

ChristophWurst added this to the v4.5.0 milestone Jun 12, 2023

ChristophWurst mentioned this issue Jun 15, 2023

Reorder server and apps class loaders cleverly nextcloud/server#38835

Open

ChristophWurst added 4. to release Ready to be released and/or waiting for tests to finish and removed 2. developing Work in progress labels Aug 17, 2023

ChristophWurst closed this as completed Aug 17, 2023

github-project-automation bot moved this from 🏗️ In progress to ☑️ Done in 💌 📅 👥 Groupware team Aug 17, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error: Database error when running migration 4004Date20230414163505 for app calendar #5304

Error: Database error when running migration 4004Date20230414163505 for app calendar #5304

solracsf commented Jun 9, 2023 •

edited

Loading

melroy89 commented Jun 9, 2023 •

edited

Loading

ChristophWurst commented Jun 10, 2023

solracsf commented Jun 10, 2023 •

edited

Loading

drhirn commented Jun 10, 2023

ChristophWurst commented Jun 10, 2023

This comment was marked as outdated.

Struppie commented Jun 10, 2023

This comment was marked as duplicate.

heisenbol commented Jun 10, 2023

Struppie commented Jun 10, 2023

NuclearPhoenixx commented Jun 11, 2023

This comment was marked as resolved.

This comment was marked as resolved.

ChristophWurst commented Jun 11, 2023

ChristophWurst commented Jun 11, 2023

ChristophWurst commented Jun 11, 2023

solracsf commented Jun 11, 2023 •

edited

Loading

ChristophWurst commented Jun 11, 2023

ChristophWurst commented Jun 11, 2023 •

edited by miaulalala

Loading

ChristophWurst commented Jun 12, 2023

flozz commented Jun 12, 2023

ChristophWurst commented Jun 12, 2023 •

edited

Loading

ChristophWurst commented Jun 12, 2023

flozz commented Jun 13, 2023

ChristophWurst commented Aug 17, 2023

Error: Database error when running migration 4004Date20230414163505 for app calendar #5304

Error: Database error when running migration 4004Date20230414163505 for app calendar #5304

Comments

solracsf commented Jun 9, 2023 • edited Loading

Steps to reproduce

Expected behavior

Actual behaviour

Calendar app version

CalDAV-clients used

Browser

Client operating system

Server operating system

Web server

Database engine version

PHP engine version

Nextcloud version

Updated from an older installed version or fresh install

List of activated apps

Nextcloud configuration

Web server error log

Log file

Browser log

Additional info

melroy89 commented Jun 9, 2023 • edited Loading

ChristophWurst commented Jun 10, 2023

solracsf commented Jun 10, 2023 • edited Loading

drhirn commented Jun 10, 2023

ChristophWurst commented Jun 10, 2023

This comment was marked as outdated.

Struppie commented Jun 10, 2023

This comment was marked as duplicate.

heisenbol commented Jun 10, 2023

Struppie commented Jun 10, 2023

NuclearPhoenixx commented Jun 11, 2023

This comment was marked as resolved.

This comment was marked as resolved.

ChristophWurst commented Jun 11, 2023

ChristophWurst commented Jun 11, 2023

ChristophWurst commented Jun 11, 2023

solracsf commented Jun 11, 2023 • edited Loading

ChristophWurst commented Jun 11, 2023

ChristophWurst commented Jun 11, 2023 • edited by miaulalala Loading

ChristophWurst commented Jun 12, 2023

flozz commented Jun 12, 2023

ChristophWurst commented Jun 12, 2023 • edited Loading

ChristophWurst commented Jun 12, 2023

flozz commented Jun 13, 2023

ChristophWurst commented Aug 17, 2023

solracsf commented Jun 9, 2023 •

edited

Loading

melroy89 commented Jun 9, 2023 •

edited

Loading

solracsf commented Jun 10, 2023 •

edited

Loading

solracsf commented Jun 11, 2023 •

edited

Loading

ChristophWurst commented Jun 11, 2023 •

edited by miaulalala

Loading

ChristophWurst commented Jun 12, 2023 •

edited

Loading