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] Projeqtor ...
 
Notifications
Clear all

[SOLVED] Projeqtor randomly freezes at login page

4 Posts
3 Users
0 Reactions
9,455 Views
(@mou7ammed)
Posts: 2
New Member
Topic starter
 
[#7237]

I am randomly experiencing some trouble to load Projeqtor main page...most of the times it freezes after I enter my credentials and it gets stuck there and sometimes it runs smoothly. Did someone experienced the same issue?
Thanks


 
Posted : 26 Jan 2021 13H10
Flou
 Flou
(@flou)
Posts: 253
Active Member
 

Hello,

have you an error on your log or on your consol when this happens ? 


 
Posted : 27 Jan 2021 14H18
(@mou7ammed)
Posts: 2
New Member
Topic starter
 

Hi,
Actually it doesn't show any error....like today everything was working fine.
Looks like there something preventing normal execution (Firewall probably) even though I made sure Antiviruses and all kind of intrusion detection systems are disabled.
I am adding yesterday's error log entries for MySQL and Apache servers.
Thanks

MySQL Error Log
2021-01-26T10:20:30.979351Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-26T10:20:30.979351Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-01-26T10:20:30.979351Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2021-01-26T10:20:30.979351Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-01-26T10:20:30.979351Z 0 [Note] C:Program Files (x86)EasyPHP-Devserver-17eds-binariesdbservermysql5717x86x210106094907bineds-dbserver.exe (mysqld 5.7.17) starting as process 2676 ...
2021-01-26T15:51:35.596052Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-26T15:51:35.596052Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-01-26T15:51:35.596052Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2021-01-26T15:51:35.596052Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-01-26T15:51:35.597050Z 0 [Note] C:Program Files (x86)EasyPHP-Devserver-17eds-binariesdbservermysql5717x86x210106094907bineds-dbserver.exe (mysqld 5.7.17) starting as process 17928 ...
2021-01-26T20:07:57.127949Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-01-26T20:07:57.128969Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2021-01-26T20:07:57.128969Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2021-01-26T20:07:57.128969Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-01-26T20:07:57.128969Z 0 [Note] C:Program Files (x86)EasyPHP-Devserver-17eds-binariesdbservermysql5717x86x210106094907bineds-dbserver.exe (mysqld 5.7.17) starting as process 2096 ...

Apache Log error
[Tue Jan 26 13:52:12.936489 2021] [:error] [pid 2472:tid 1364] [client 127.0.0.1:56903] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\PJQr\model\persistence\Sql.php on line 92, referer: http://127.0.0.1:8080/edsa-Project%20Management/view/index.php
[Tue Jan 26 14:12:20.203763 2021] [:error] [pid 2472:tid 1364] [client 127.0.0.1:57318] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\PJQr\model\persistence\SqlElement.php on line 2686
[Tue Jan 26 15:05:06.842848 2021] [:error] [pid 2472:tid 1324] [client 127.0.0.1:57995] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\PJQr\model\persistence\Sql.php on line 91
[Tue Jan 26 16:51:33.076252 2021] [core:warn] [pid 12728:tid 788] AH00098: pid file C:/Program Files (x86)/EasyPHP-Devserver-17/eds-binaries/httpserver/apache2425vc11x86x210106094907/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
PHP Deprecated: Comments starting with '#' are deprecated in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-binaries\php\php5630vc11x86x210106094907\php.ini on line 886 in Unknown on line 0
[Tue Jan 26 16:51:33.151054 2021] [mpm_winnt:notice] [pid 12728:tid 788] AH00455: Apache/2.4.25 (Win32) PHP/5.6.30 configured -- resuming normal operations
[Tue Jan 26 16:51:33.151054 2021] [mpm_winnt:notice] [pid 12728:tid 788] AH00456: Apache Lounge VC11 Server built: Dec 20 2016 13:02:04
[Tue Jan 26 16:51:33.151054 2021] [core:notice] [pid 12728:tid 788] AH00094: Command line: 'C:\Program Files (x86)\EasyPHP-Devserver-17\eds-binaries\httpserver\apache2425vc11x86x210106094907\bin\eds-httpserver.exe -d C:/Program Files (x86)/EasyPHP-Devserver-17/eds-binaries/httpserver/apache2425vc11x86x210106094907'
[Tue Jan 26 16:51:33.168007 2021] [mpm_winnt:notice] [pid 12728:tid 788] AH00418: Parent: Created child process 2512
PHP Deprecated: Comments starting with '#' are deprecated in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-binaries\php\php5630vc11x86x210106094907\php.ini on line 886 in Unknown on line 0
[Tue Jan 26 16:51:38.142292 2021] [mpm_winnt:notice] [pid 2512:tid 776] AH00354: Child: Starting 64 worker threads.
[Tue Jan 26 21:07:54.438175 2021] [core:warn] [pid 360:tid 844] AH00098: pid file C:/Program Files (x86)/EasyPHP-Devserver-17/eds-binaries/httpserver/apache2425vc11x86x210106094907/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
PHP Deprecated: Comments starting with '#' are deprecated in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-binaries\php\php5630vc11x86x210106094907\php.ini on line 886 in Unknown on line 0
[Tue Jan 26 21:07:54.576790 2021] [mpm_winnt:notice] [pid 360:tid 844] AH00455: Apache/2.4.25 (Win32) PHP/5.6.30 configured -- resuming normal operations
[Tue Jan 26 21:07:54.577790 2021] [mpm_winnt:notice] [pid 360:tid 844] AH00456: Apache Lounge VC11 Server built: Dec 20 2016 13:02:04
[Tue Jan 26 21:07:54.577790 2021] [core:notice] [pid 360:tid 844] AH00094: Command line: 'C:\Program Files (x86)\EasyPHP-Devserver-17\eds-binaries\httpserver\apache2425vc11x86x210106094907\bin\eds-httpserver.exe -d C:/Program Files (x86)/EasyPHP-Devserver-17/eds-binaries/httpserver/apache2425vc11x86x210106094907'
[Tue Jan 26 21:07:54.593786 2021] [mpm_winnt:notice] [pid 360:tid 844] AH00418: Parent: Created child process 1340
PHP Deprecated: Comments starting with '#' are deprecated in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-binaries\php\php5630vc11x86x210106094907\php.ini on line 886 in Unknown on line 0
[Tue Jan 26 21:08:00.380372 2021] [mpm_winnt:notice] [pid 1340:tid 976] AH00354: Child: Starting 64 worker threads.
[Tue Jan 26 21:08:53.600276 2021] [:error] [pid 1340:tid 1376] [client 127.0.0.1:57489] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\PJQr\model\persistence\Sql.php on line 92, referer: http://127.0.0.1:8080/edsa-Project%20Management/view/index.php
[Tue Jan 26 21:10:03.550656 2021] [:error] [pid 1340:tid 1376] [client 127.0.0.1:57516] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\PJQr\model\persistence\Sql.php on line 91

 


 
Posted : 27 Jan 2021 19H06
(@babynus)
Posts: 14952
Member Admin
 

Hi,

It seems you have some Timeouts, always is Sql class, so possibly DB access issues.
If your DB is shared with other application, possibly they over-use it.
Or simpy you do not have enought connections available.
Advisor in phpMyAdmin way help you

Edit : Another solution is to subscribe to our hosting service. It is dimensionned so that you won't have this slowness.


 
Posted : 28 Jan 2021 21H03
Share:

Scroll to Top