View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] [v9.2.2] Login takes at least 30 seconds for admins - ProjeQtOr
 
 

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

More
19 Aug 2021 15:51 #1 by Dr-Shadow
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]

Please Log in or Create an account to join the conversation.

More
19 Aug 2021 16:31 #2 by Dr-Shadow
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

Please Log in or Create an account to join the conversation.

More
24 Aug 2021 17:39 #3 by babynus
You can disable this feature on Global Parameters to avoid this issue

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.035 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.