ProjeQtOr free project management software - Update from 8.0.6 to 8.1.5 never ends - ProjeQtOr
 

Update from 8.0.6 to 8.1.5 never ends

More
23 Aoû 2019 12:32 #1 by karl.binet
Hi,

I started the update about 15 minutes ago, log files says

2019-08-23 06:14:00.397 ===== TRACE ===== DataBase actual Version = V8.0.6
2019-08-23 06:14:00.397 ===== TRACE ===== ProjeQtOr actual Version = V8.1.5
2019-08-23 06:14:00.397 ===== TRACE =====
2019-08-23 06:14:00.397 ===== TRACE ===== =====================================
2019-08-23 06:14:00.397 ===== TRACE =====
2019-08-23 06:14:00.397 ===== TRACE ===== VERSION V8.1.0
2019-08-23 06:14:00.397 ===== TRACE =====
2019-08-23 06:14:00.399 ===== TRACE ===== Table "statusmail" altered.
2019-08-23 06:14:00.402 ===== TRACE ===== Table "event" renamed to "eventformail`"
2019-08-23 06:14:00.430 ===== TRACE ===== 9 lines updated into table "columnselector".
2019-08-23 06:14:01.290 ===== TRACE ===== 3 lines updated into table "history".
2019-08-23 06:14:01.294 ===== TRACE ===== Table "resourcesurbooking" created.
2019-08-23 06:14:01.298 ===== TRACE ===== Index "resourcevariablesurbooking" created.
2019-08-23 06:14:01.621 ===== TRACE ===== Table "planningelement" altered.
2019-08-23 06:14:01.683 ===== TRACE ===== Table "planningelementbaseline" altered.
2019-08-23 06:14:01.981 ===== TRACE ===== Table "plannedwork" altered.
2019-08-23 06:14:02.276 ===== TRACE ===== Table "plannedwork" altered.
2019-08-23 06:14:02.437 ===== TRACE ===== Table "plannedworkbaseline" altered.
2019-08-23 06:14:02.599 ===== TRACE ===== Table "plannedworkbaseline" altered.
2019-08-23 06:14:02.803 ===== TRACE ===== Table "assignment" altered.
2019-08-23 06:14:02.805 ===== TRACE ===== 1 lines inserted into table "originable".
2019-08-23 06:14:02.855 ===== TRACE ===== Table "message" altered.
2019-08-23 06:14:02.860 ===== TRACE ===== Table "resource" altered.
2019-08-23 06:14:02.865 ===== TRACE ===== Table "resource" altered.
2019-08-23 06:14:02.868 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2019-08-23 06:14:02.885 ===== TRACE ===== 240 lines inserted into table "tempupdate".
2019-08-23 06:14:03.061 ===== TRACE ===== 240 lines deleted from table "workflowstatus".
2019-08-23 06:14:03.062 ===== TRACE ===== 240 lines deleted from table "tempupdate".
2019-08-23 06:14:03.064 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2019-08-23 06:14:03.081 ===== TRACE ===== 0 lines deleted from table "workflowstatus".
2019-08-23 06:14:03.082 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2019-08-23 06:14:03.083 ===== TRACE ===== 0 lines inserted into table "tempupdate".
2019-08-23 06:14:03.085 ===== TRACE ===== 0 lines deleted from table "workflowstatus".
2019-08-23 06:14:03.085 ===== TRACE ===== 0 lines deleted from table "tempupdate".
2019-08-23 06:14:03.095 ===== TRACE ===== Index "workflowstatusReference" created.
2019-08-23 06:14:03.097 ===== TRACE ===== 1 lines inserted into table "reportcategory".
2019-08-23 06:14:03.098 ===== TRACE ===== 3 lines inserted into table "report".
2019-08-23 06:14:03.101 ===== TRACE ===== 13 lines inserted into table "reportparameter".
2019-08-23 06:14:03.105 ===== TRACE ===== 3 lines inserted into table "habilitationreport".
2019-08-23 06:14:03.171 ===== TRACE ===== Table "resource" altered.
2019-08-23 06:14:03.214 ===== TRACE ===== Table "filter" altered.
2019-08-23 06:14:03.217 ===== TRACE ===== 38 lines updated into table "filter".
2019-08-23 06:14:03.222 ===== TRACE ===== Table "resource" altered.
2019-08-23 06:14:03.225 ===== TRACE ===== 4 lines inserted into table "parameter".
2019-08-23 06:14:03.225 ===== TRACE =====
2019-08-23 06:14:03.225 ===== TRACE ===== DATABASE UPDATED
2019-08-23 06:14:03.225 ===== TRACE ===== WITH NO ERROR
2019-08-23 06:14:03.225 ===== TRACE =====

15 mninutes later, still running, I can't login, it says update running please wait until the end of the update.

Any solutions for me ?

Regards

Please Connexion or Create an account to join the conversation.

More
23 Aoû 2019 12:42 - 23 Aoû 2019 12:42 #2 by babynus
Migration ended and took 3 seconds.
It seems last step (remove flag) failed.
Strange there is no error.
Or possibly migration is still in a specific fix loop. In that case you should have log :
"Fix incorrectly reset validatedCost and validatedWork"
In that case, allow some time.

If nothing new in log after 1 hour, just remove flag
projeqtor/files/cron/MIGRATION

Babynus
Administrator of ProjeQtOr web site
Last edit: 23 Aoû 2019 12:42 by babynus.
The following user(s) said Thank You: karl.binet

Please Connexion or Create an account to join the conversation.

More
23 Aoû 2019 13:09 #3 by karl.binet
Hi, finally got true the update by itfself, it was the validated script patch that took so long, update ended at

2019-08-23 06:37:15.197 ===== TRACE ===== Fix incorrectly reset validatedCost and validatedWork

So about 25 in total for the update.

Thanks

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.056 seconds