Forum

[SOLVED] Error upda...
 
Notifications
Retirer tout

[SOLVED] Error updating from 10.2.2 to 10.3.4

2 Posts
2 Utilisateurs
0 Reactions
1,838 Vu
Fathi Ben Nasr
(@fathibn)
Posts: 59
Active Member
Début du sujet
 
[#8902]

Hi,
I have just updated today from 10.2.2 (postgresql backend) to 10.3.4 and had the following errors in the logs:
2023-05-18 12:51:54.106 ===== TRACE ===== =====================================
2023-05-18 12:51:54.106 ===== TRACE =====
2023-05-18 12:51:54.106 ===== TRACE ===== DataBase actual Version = V10.2.2
2023-05-18 12:51:54.106 ===== TRACE ===== ProjeQtOr actual Version = V10.3.4
2023-05-18 12:51:54.106 ===== TRACE =====
2023-05-18 12:51:54.107 ===== TRACE ===== =====================================
2023-05-18 12:51:54.107 ===== TRACE =====
2023-05-18 12:51:54.107 ===== TRACE ===== VERSION V10.2.3
2023-05-18 12:51:54.107 ===== TRACE =====
2023-05-18 12:51:54.181 ===== TRACE =====  1 lines updated into table "reportparameter".
2023-05-18 12:51:54.181 ===== TRACE =====
2023-05-18 12:51:54.182 ===== TRACE ===== DATABASE UPDATED
2023-05-18 12:51:54.182 ===== TRACE =====  WITH NO ERROR
2023-05-18 12:51:54.182 ===== TRACE =====
2023-05-18 12:51:54.182 ===== TRACE ===== =====================================
2023-05-18 12:51:54.182 ===== TRACE =====
2023-05-18 12:51:54.182 ===== TRACE ===== VERSION V10.3.0
2023-05-18 12:51:54.182 ===== TRACE =====
2023-05-18 12:51:54.184 ===== TRACE =====  0 lines deleted from table "reportparameter".
2023-05-18 12:51:54.225 ===== TRACE =====  0 lines deleted from table "report".
2023-05-18 12:51:54.249 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.252 ===== TRACE =====  1 lines inserted into table "reportparameter".
2023-05-18 12:51:54.292 ===== TRACE =====  2 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.306 ===== TRACE =====  1 lines inserted into table "cronexecution".
2023-05-18 12:51:54.309 ===== TRACE =====  1 lines inserted into table "reportparameter".
2023-05-18 12:51:54.337 ===== TRACE =====  4 lines inserted into table "indicator".
2023-05-18 12:51:54.372 ===== TRACE =====  4 lines inserted into table "indicatorableindicator".
2023-05-18 12:51:54.503 ===== TRACE =====  Table "consolidationvalidation" altered.
2023-05-18 12:51:54.521 ===== TRACE =====  1 lines inserted into table "menu(id,name,".
2023-05-18 12:51:54.540 ** ERROR ** [V10.2.2] Exception-[42601] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ")"
LINE 1: ...menu(id,name,_id_seq', (SELECT MAX(id) FROM menu(id,name,));
                                                                    ^
2023-05-18 12:51:54.541 ** ERROR ** [V10.2.2]    For query : SELECT setval('menu(id,name,_id_seq', (SELECT MAX(id) FROM menu(id,name,));
2023-05-18 12:51:54.541 ** ERROR ** [V10.2.2]    Strack trace :
2023-05-18 12:51:54.541 ** ERROR ** [V10.2.2]    #0 Sql->query called at [/projeqtor/htdocs/model/persistence/Sql.php:381]
2023-05-18 12:51:54.541 ** ERROR ** [V10.2.2]    #1 Sql->updatePgSeq called at [/projeqtor/htdocs/db/maintenanceFunctions.php:166]
2023-05-18 12:51:54.541 ** ERROR ** [V10.2.2]    #2 runScript called at [/projeqtor/htdocs/db/maintenance.php:177]
2023-05-18 12:51:54.541 ** ERROR ** [V10.2.2]    #3 include called at [/projeqtor/htdocs/tool/loginCheck.php:144]
2023-05-18 12:51:54.596 ===== TRACE =====  2 lines inserted into table "habilitation".
2023-05-18 12:51:54.625 ===== TRACE =====  2 lines inserted into table "accessright".
2023-05-18 12:51:54.658 ===== TRACE =====  1 lines inserted into table "navigation".
2023-05-18 12:51:54.670 ===== TRACE =====  2 lines inserted into table "importable".
2023-05-18 12:51:54.683 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.686 ===== TRACE =====  4 lines inserted into table "reportparameter".
2023-05-18 12:51:54.688 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.710 ===== TRACE =====  2 lines inserted into table "planningmode".
2023-05-18 12:51:54.722 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.724 ===== TRACE =====  3 lines inserted into table "reportparameter".
2023-05-18 12:51:54.727 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.729 ===== TRACE =====  1 lines inserted into table "report".
2023-05-18 12:51:54.732 ===== TRACE =====  6 lines inserted into table "reportparameter".
2023-05-18 12:51:54.734 ===== TRACE =====  1 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.737 ===== TRACE =====  2 lines inserted into table "report".
2023-05-18 12:51:54.739 ===== TRACE =====  6 lines inserted into table "reportparameter".
2023-05-18 12:51:54.742 ===== TRACE =====  2 lines inserted into table "habilitationreport".
2023-05-18 12:51:54.756 ===== TRACE =====  7 lines inserted into table "habilitationother".
2023-05-18 12:51:54.760 ===== TRACE =====  1 lines updated into table "report".
2023-05-18 12:51:54.804 ===== TRACE =====  0 lines deleted from table "votingitem".
2023-05-18 12:51:54.821 ===== TRACE =====  0 lines deleted from table "voting".
2023-05-18 12:51:54.835 ===== TRACE =====  Table "votingattribution" altered.
2023-05-18 12:51:54.837 ===== TRACE =====  1 lines updated into table "menu".
2023-05-18 12:51:54.837 ===== TRACE =====
2023-05-18 12:51:54.837 ===== TRACE ===== DATABASE UPDATED
2023-05-18 12:51:54.837 ===== TRACE =====  WITH NO ERROR
2023-05-18 12:51:54.837 ===== TRACE =====
2023-05-18 12:52:02.325 ===== TRACE ===== Cron normally stopped at 18/05/2023 12:52:02
2023-05-18 12:52:05.290 ===== TRACE ===== =====================================
2023-05-18 12:52:05.290 ===== TRACE =====
2023-05-18 12:52:05.290 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V10.3.4
2023-05-18 12:52:05.290 ===== TRACE =====
2023-05-18 12:52:05.290 ===== TRACE ===== =====================================
2023-05-18 12:52:05.290 ===== TRACE =====

Didin't encounter errors when using projeQtor till now. Just in case this could flash ou a hidden bug.


 
Posté : 18 Mai PM 15:055
(@babynus)
Posts: 14952
Membre Admin
 

This is a minor issue (update oif sequence).
This does not impact reliability of migration.


 
Posté : 18 Mai PM 17:055
Share:
Retour en haut