Failures in update testing to 10

[PVince81]

https://drone.owncloud.com/owncloud/update-testing/108

@DeepDiver1975 please fill in details

Assigning you for fixing in this sprint as discussed.

Would be good to get an overview of the actual impact, what update paths work and which are broken now as it used to work.

Thanks.

[PVince81]

setting to p2 as we should examine this before the next release

[ownclouders]

GitMate.io thinks possibly related issues are #22485 (test), #31579 (test), #22492 (test), #16790 (Feedback of failure after sending test email is poor), and #20661 (Update).

[DeepDiver1975]

Error:

+ cd owncloud
+ ls | grep -v data | grep -v config | xargs rm -rf
+ tar -jxf /drone/src/owncloud-daily-stable10-qa.tar.bz2 -C /drone/src
+ php ./occ up
ownCloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
2018-08-13T00:30:41+00:00 Set log level to debug
2018-08-13T00:30:41+00:00 Turned on maintenance mode
2018-08-13T00:30:41+00:00 Repair step: Repair MySQL database engine
2018-08-13T00:30:41+00:00 Repair info: Not a mysql database -> nothing to do
2018-08-13T00:30:41+00:00 Repair step: Repair MySQL collation
2018-08-13T00:30:41+00:00 Repair info: Not a mysql database -> nothing to do
2018-08-13T00:30:41+00:00 Repair step: Repair SQLite autoincrement
2018-08-13T00:30:41+00:00 Repair step: Repair orphaned reshare
2018-08-13T00:30:41+00:00 Repair step: Repair duplicate entries in oc_lucene_status
2018-08-13T00:30:41+00:00 Repair info: lucene_status table does not exist -> nothing to do
2018-08-13T00:30:41+00:00 Repair step: Upgrade app code from the marketplace
2018-08-13T00:30:41+00:00 Repair info: Enabling market app to assist with update
2018-08-13T00:30:41+00:00 Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'INSERT INTO "oc_jobs" ("class", "argument", "last_run", "last_checked") VALUES(?, ?, ?, ?)' with params ["OCA\\Market\\CheckUpdateBackgroundJob", "null", 0, 1534120241]:

SQLSTATE[HY000]: General error: 1 table oc_jobs has no column named last_checked
2018-08-13T00:30:41+00:00 Update failed
2018-08-13T00:30:41+00:00 Maintenance mode is kept active
2018-08-13T00:30:41+00:00 Reset log level 

Investigation result:

• order of upgrade: first execute repair steps - second perform database migrations
• migration Version20170101215145 adds the missing column 'last_checked'
• the repair step OC\Repair\Apps tries to add the job
  -> 💥