Rabso Posted September 30, 2020 Report Share Posted September 30, 2020 (edited) Hi, Our VA was online for some good years but past 2 weeks I started suffering a lot of problems and slow. System is running with PHP7.2 and MySQL 5.5, we have IPS integrated too . phpVMS Version 5.5.2 what issue am suffering now is sometimes database connection will not establish for while even I got several time max connection reach while checking my tables in phpmyadmin. am not sure really what is casing problem. We have cron for IPS every minute and will download data from IVAO every 3 minutes but I can see that from time to time it will skip the 3 min and don't update up to 20 minutes sometimes. while this happening everything seems stuck and slow. so current flight keep getting duplicated and not accurate. what I should look for first? regards Edited September 30, 2020 by Rabso Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted September 30, 2020 Moderators Report Share Posted September 30, 2020 Have you tried getting in touch with your web hosting provider? Quote Link to comment Share on other sites More sharing options...
Rabso Posted September 30, 2020 Author Report Share Posted September 30, 2020 no, could be host issue? I have several light websites and they are ok I start thinking maybe our VA database became large but not sure Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted October 1, 2020 Administrators Report Share Posted October 1, 2020 You may have issues using phpVMS 5.5.2 on php 7.2 - can you downgrade the php version to 5.6? Have you changed/added anything in the past few weeks? Has your host changed anything in the past few weeks? Quote Link to comment Share on other sites More sharing options...
Rabso Posted October 1, 2020 Author Report Share Posted October 1, 2020 around 2 months ago I upgraded from 7.2 to 7.3 and then things were ok. Nothing after that has been changed and host nothing informed me about any changes. only from 9 days ago issues started. I returned PHP to 7.2 but still same. our host is forcing me to upgrade to 7.3 by end of this year. I was thinking to go for vmsPHP 7 but it's still Beta and smartACARS not ready Now I noticed that when I run IPS script through SSH (sure under PHP5), it will take hell of time. The cron of this sometimes update smoothly every 3 mint and sometimes stuck for 20. my PIREPs ID reached almost 60K, will that be reason of slow? Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted October 1, 2020 Administrators Report Share Posted October 1, 2020 Is error reporting turned on? Any errors showing in error_log or in the console? Did you edit any files to get phpVMS 5.5.2 to work correctly in PHP 7.2 or 7.3? There will be errors in phpVMS 5.5.2 when using PHP 7.2 or 7.3 (possibly 7.0 and 7.1 too). Many will reference the count parameter. I have no idea of IPS will work correctly with PHP 7.2 or 7.3 as I don't use it. 60k PIREPS may slow some things down a little, but only by a few seconds. Quote Link to comment Share on other sites More sharing options...
Rabso Posted October 2, 2020 Author Report Share Posted October 2, 2020 (edited) so I turned on error reporting and this what error_log shows: [02-Oct-2020 11:03:36 UTC] PHP Deprecated: Non-static method SimpleNews::NewsList() should not be called statically in /homepages/24/d391698823/htdocs/Virtual/Saudia/lib/skins/saudia/frontpage_main.php on line 86 and this its code: <?php SimpleNews::NewsList(3); ?> I believe this is nothing as only happen when someone open main page. I also turned on DEBUG_MODE in local.config.php and got following: errors.txt file: Update: No errors, I fixed it now there was another file log.txt, it was showing some error when I use smartCARS: Time: 10.01.20 19:15:00 ===== Time: 10.01.20 19:15:00 Backtrace: DB::write_debug > DB::query > ACARSData::updateFlightData > smartCARS::positionreport Query: INSERT INTO phpvms_acarsdata (`0`,`1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`,`10`,`11`,`12`,`13`,`14`,`15`,`16`,`17`,`18`,`19`,`20`,`21`,`22`,`23`,`24`,`25`,`26`,`27`,`28`,`29`,`30`,`31`,`32`,`33`,`34`,`35`,`36`,`37`,`38`,`39`,`40`,`41`,`42`,`43`,`44`,`45`,`46`,`47`,`48`,`pilotid`,`pilotname`,`heading`,`lastupdate`) VALUES ('ZX48','449045','449045','PILOT','','54.3762','-130.528','1500','80','1/C172/L-SDFGY/S','N0180','CZST','VFR','CYPR','SHARD3','B','4','1200','0','50','0','V','1830','1830','0','50','5','0','CYZP','DOF/201001 / PFPX / XP11 / ENG EASY / RMK/WORLDTOUR','55N130W DCT 54N130W DCT PR','','','','','','','20201001181213','Altitude/win','1.10.0b','2','4','CZMT','G','1','152','0','16','','6','Jehad Hamdan','0',NOW()) Error: (1054) - Unknown column '0' in 'field list' it seems somthing not right with table am trying to figure it Edited October 2, 2020 by Rabso Quote Link to comment Share on other sites More sharing options...
Rabso Posted October 2, 2020 Author Report Share Posted October 2, 2020 (edited) I upgraded IPS to work with PHP 7.2, tested and works ok (no error) I need to test when it's working with cron I checked all error nothing (other than above), small changes I made based on this update: https://github.com/ProAviaAZ/phpvms_5.5.2.72 UPDATE: so it seems IPS code in getting data from IVAO is really bad, with cron after several time, everything is slow and stuck, is like codes are running without stop. I will change full way of that and give update Edited October 2, 2020 by Rabso Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.