core icon indicating copy to clipboard operation
core copied to clipboard

Upgrade Legacy\RegularJob / Other

Open ho4ho opened this issue 4 years ago • 7 comments

Steps to reproduce

  1. Have upgraded ownCloud 10.2.1 (not knowing old version)
  2. Check oc_jobs table
  3. See OC\BackgroundJob\Legacy\RegularJob
  4. Have new ownCloud 10.2.1
  5. Check oc_jobs table
  6. See no legacy jobs
  7. Compare

Expected behaviour

OC\BackgroundJob\Legacy\RegularJob upgraded and no others differences

Actual behaviour

OC\BackgroundJob\Legacy\RegularJob not upgraded and others differences

Related https://github.com/owncloud/core/issues/25350, https://github.com/owncloud/core/issues/35589, https://github.com/owncloud/core/issues/30745?

Upgraded ownCloud

SELECT * FROM oc_jobs ORDER BY class;

+------+---------------------------------------------------+-------------------------------------------------------+------------+--------------+-------------+--------------------+
| id   | class                                             | argument                                              | last_run   | last_checked | reserved_at | execution_duration |
+------+---------------------------------------------------+-------------------------------------------------------+------------+--------------+-------------+--------------------+
|    3 | OCA\Activity\BackgroundJob\EmailNotification      | null                                                  | 1563781201 |   1563781621 |           0 |                  0 |
|  158 | OCA\Activity\BackgroundJob\ExpireActivities       | null                                                  | 1563728161 |   1563781621 |           0 |                  0 |
| 1007 | OCA\DAV\CardDAV\SyncJob                           | null                                                  | 1563750481 |   1563781621 |           0 |                  0 |
| 1006 | OCA\Federation\SyncJob                            | null                                                  | 1563720301 |   1563781621 |           0 |                  0 |
|  998 | OCA\Files\BackgroundJob\CleanupFileLocks          | null                                                  | 1563781621 |   1563781621 |           0 |                  0 |
| 1004 | OCA\Files\BackgroundJob\DeleteOrphanedItems       | null                                                  | 1563779101 |   1563781621 |           0 |                  0 |
| 1003 | OCA\Files\BackgroundJob\ScanFiles                 | null                                                  | 1563781081 |   1563781621 |           0 |                  0 |
| 1018 | OCA\Files_Sharing\DeleteOrphanedSharesJob         | null                                                  | 1563781561 |   1563781622 |           0 |                  0 |
| 1019 | OCA\Files_Sharing\ExpireSharesJob                 | null                                                  | 1563723481 |   1563781622 |           0 |                  0 |
|  994 | OCA\Files_Trashbin\BackgroundJob\ExpireTrash      | null                                                  | 1563781021 |   1563781621 |           0 |                  0 |
|  995 | OCA\Files_Versions\BackgroundJob\ExpireVersions   | null                                                  | 1563781262 |   1563781621 |           0 |                  0 |
| 1026 | OCA\Market\CheckUpdateBackgroundJob               | null                                                  | 1563699961 |   1563781621 |           0 |                  0 |
| 1016 | OCA\UpdateNotification\Notification\BackgroundJob | null                                                  | 1563705301 |   1563781622 |           0 |                  1 |
| 1013 | OCA\UpdateNotification\ResetTokenBackgroundJob    | null                                                  | 1563781622 |   1563781622 |           0 |                  0 |
|    1 | OC\BackgroundJob\Legacy\RegularJob                | ["\\OC\\Files\\Cache\\BackgroundWatcher","checkNext"] | 1563781621 |   1563781622 |           0 |                  0 |
|  153 | OC\BackgroundJob\Legacy\RegularJob                | [null,"run"]                                          | 1563781621 |   1563781621 |           0 |                  0 |
| 1015 | \OC\Authentication\Token\DefaultTokenCleanupJob   | null                                                  | 1563781622 |   1563781622 |           0 |                  0 |
+------+---------------------------------------------------+-------------------------------------------------------+------------+--------------+-------------+--------------------+
17 rows in set (0.00 sec)

New ownCloud with Activity/LDAP

SELECT * FROM oc_jobs ORDER BY class;

+----+----------------------------------------------------+-------------------------------------------------------------------------------+------------+--------------+-------------+--------------------+
| id | class                                              | argument                                                                      | last_run   | last_checked | reserved_at | execution_duration |
+----+----------------------------------------------------+-------------------------------------------------------------------------------+------------+--------------+-------------+--------------------+
| 17 | OCA\Activity\BackgroundJob\EmailNotification       | null                                                                          | 1563815342 |   1563815882 |           0 |                  0 |
| 18 | OCA\Activity\BackgroundJob\ExpireActivities        | null                                                                          | 1563783301 |   1563815882 |           0 |                  0 |
|  6 | OCA\DAV\BackgroundJob\CleanProperties              | null                                                                          | 1563782462 |   1563815882 |           0 |                  0 |
|  5 | OCA\DAV\CardDAV\SyncJob                            | null                                                                          | 1563782462 |   1563815882 |           0 |                  0 |
|  7 | OCA\Federation\SyncJob                             | null                                                                          | 1563782462 |   1563815882 |           0 |                  0 |
|  3 | OCA\Files\BackgroundJob\CleanupFileLocks           | null                                                                          | 1563815882 |   1563815882 |           0 |                  0 |
|  4 | OCA\Files\BackgroundJob\CleanupPersistentFileLocks | null                                                                          | 1563815281 |   1563815882 |           0 |                  0 |
|  2 | OCA\Files\BackgroundJob\DeleteOrphanedItems        | null                                                                          | 1563813421 |   1563815882 |           0 |                  0 |
|  1 | OCA\Files\BackgroundJob\ScanFiles                  | null                                                                          | 1563815342 |   1563815882 |           0 |                  0 |
|  8 | OCA\Files_Sharing\DeleteOrphanedSharesJob          | null                                                                          | 1563815342 |   1563815882 |           0 |                  0 |
|  9 | OCA\Files_Sharing\ExpireSharesJob                  | null                                                                          | 1563782462 |   1563815882 |           0 |                  0 |
| 10 | OCA\Files_Trashbin\BackgroundJob\ExpireTrash       | null                                                                          | 1563815281 |   1563815882 |           0 |                  0 |
| 11 | OCA\Files_Versions\BackgroundJob\ExpireVersions    | null                                                                          | 1563815281 |   1563815882 |           0 |                  0 |
| 12 | OCA\Market\CheckUpdateBackgroundJob                | null                                                                          | 1563782462 |   1563815882 |           0 |                  1 |
| 13 | OCA\UpdateNotification\Notification\BackgroundJob  | null                                                                          | 1563782463 |   1563815882 |           0 |                  0 |
| 15 | OCA\User_LDAP\Jobs\UpdateGroups                    | null                                                                          |          0 |   1563782463 |  1563782463 |                 -1 |
| 16 | OC\Log\Rotate                                      | "\/var\/lib\/univention-appcenter\/apps\/owncloud\/data\/files\/owncloud.log" | 1563815882 |   1563815882 |           0 |                  0 |
| 14 | \OC\Authentication\Token\DefaultTokenCleanupJob    | null                                                                          | 1563815882 |   1563815882 |           0 |                  0 |
+----+----------------------------------------------------+-------------------------------------------------------------------------------+------------+--------------+-------------+--------------------+
18 rows in set (0.00 sec)

Server configuration

ownCloud version: 10.2.1

Updated from an older ownCloud or fresh install: Updated

ho4ho avatar Jul 21 '19 16:07 ho4ho

In old but not in new:

| 1013 | OCA\UpdateNotification\ResetTokenBackgroundJob    | null                                                  | 1563781622 |   1563781622 |           0 |                  0 |

In old and mybe new:

|    1 | OC\BackgroundJob\Legacy\RegularJob                | ["\\OC\\Files\\Cache\\BackgroundWatcher","checkNext"] | 1563781621 |   1563781622 |           0 |                  0 |
|  153 | OC\BackgroundJob\Legacy\RegularJob                | [null,"run"]                                          | 1563781621 |   1563781621 |           0 |                  0 |

In new and mybe old:

|  6 | OCA\DAV\BackgroundJob\CleanProperties              | null                                                                          | 1563782462
|  4 | OCA\Files\BackgroundJob\CleanupPersistentFileLocks | null                                                                          | 1563815281 |   1563815882 |           0 |                  0 |

Not in old because no LDAP:

| 15 | OCA\User_LDAP\Jobs\UpdateGroups                    | null                                                                          |          0 |   1563782463 |  1563782463 |                 -1 |

Not in old because no Logrotate:

| 16 | OC\Log\Rotate                                      | "\/var\/lib\/univention-appcenter\/apps\/owncloud\/data\/files\/owncloud.log" | 1563815882 |   1563815882 |           0 |                  0 |

ho4ho avatar Jul 22 '19 17:07 ho4ho

This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 10 days if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Sep 19 '21 22:09 stale[bot]

@JanAckermann Still problem by older installations. Please open.

ho4ho avatar Sep 21 '21 19:09 ho4ho

This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 10 days if no further activity occurs. Thank you for your contributions.

github-actions[bot] avatar Mar 21 '22 01:03 github-actions[bot]

Not close pls

ho4ho avatar Mar 21 '22 21:03 ho4ho

This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 10 days if no further activity occurs. Thank you for your contributions.

github-actions[bot] avatar Sep 18 '22 01:09 github-actions[bot]

Not close pls

ho4ho avatar Sep 18 '22 15:09 ho4ho