Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] [v9.2.2] L...
 
Notifications
Clear all

[SOLVED] [v9.2.2] Login takes at least 30 seconds for admins

3 Posts
2 Users
0 Reactions
2,034 Views
(@dr-shadow)
Posts: 6
Active Member
Topic starter
 
[#7708]

Hello,

Since I updated projeqtor to v9.2.2, it takes at least 30 seconds for admins to login.

For normal users, the login is as fast as it was previously.

I don't know if that's related but we are getting this in the logs with mariadb -> 10.5.11 :

2021-08-18 16:59:28.745 ** ERROR ** [V9.2.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by ticket.idResource, workelement.refId, ticket.doneDateTime' at line 6
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2]    For query :  SELECT DISTINCT  ticket.idResource as idresource,
                          workelement.refId as idticket,
                                            workelement.realwork as realwork,
                          workelement.leftWork  as leftwork,
                          workelement.plannedWork as plannedwork,
                          ticket.doneDateTime as date   FROM ticket,workelement   WHERE  ticket.id = workelement.refId and workelement.refType='Ticket' AND ticket.idProject in (0, 1, 3, 4, 5, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 29, 32, 63, 62, 33, 28, 37, 38, 39, 40, 43, 46, 51, 55, 58, 64, 65, 73, 74, 75, 76, 66, 77, 78, 79, 80, 81, 85, 101, 102, 103, 104, 67, 86, 87, 88, 89, 90, 91, 68, 83, 92, 93, 96, 97, 98, 99, 100, 71, 82, 72, 94, 95, 42, 108, 41, 59, 113, 114, 27, 47, 109, 57, 111, 56, 35, 112, 110, 115, 116) AND ticket.idResource =  order by ticket.idResource, workelement.refId, ticket.doneDateTime ;
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2]    Strack trace :
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2]    #0 Sql->query called at [/var/www/html/report/performanceIndicator.php:733]
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2]    #1 ticket called at [/var/www/html/report/performanceIndicator.php:163]


 
Posted : 19 Aug 2021 17H51
(@dr-shadow)
Posts: 6
Active Member
Topic starter
 

Okay it seems to be a network issue, DNS is not reachable from the container.
During login, projeqtor check if a newer version is available for the admins and by doing so it hangs for a few seconds.

The SQL error is unrelated


 
Posted : 19 Aug 2021 18H31
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

You can disable this feature on Global Parameters to avoid this issue


 
Posted : 24 Aug 2021 19H39
Share:

Scroll to Top