[Vtigercrm-developers] Migration blocker

Tony Sandman tonysandman999 at gmail.com
Wed Apr 4 06:02:44 GMT 2018


So I decided to do some migration testing and found issue.
Migration actually never finish and producing giant vtigercrm.log file even
if
logging is switched off in config.performance.php as well as in
config.inc.php.
All extensions has been switched off in module manager, system has no
significant modifications.
Test files are properly chmoded and chowned. Server configuration is in
line with vtiger recommendation.
If I switch logging of migration process the log file shows nothing
(properly set in config.performance.php )
vtigercrm.log file contains ONLY repeating records as follow:

================
Wed Apr  4 05:47:06 2018,566 [2555] DEBUG VT - Prepared sql query
parameters : [HelpDesk,Faq,223094]
Wed Apr  4 05:47:06 2018,569 [2555] DEBUG VT - Prepared sql query being
executed : UPDATE vtiger_modcomments SET is_private = 0 WHERE modcommentsid
IN
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Wed Apr  4 05:47:06 2018,569 [2555] DEBUG VT - Prepared sql query
parameters :
[11965,11966,11967,11968,11969,11970,11971,11972,11973,11974,11975,11976,11977,11978,11979,11980,11981,11982,11983,11984,11985,11986,11987,11988,11989,11990,11991,11992,11993,11994,11995,16538,16539,16540,16541,18925,19194,74440,74756,78177,78178,78779,78892,80832,80839,80887,80938,80939,158705,158775,158986,159085,168799,168800,168825,169062,169100,169104,169114,169178,169257,169258,169280,169325,170548,170780,174565,203431,204681,210203,210686,211867,212093,212616,216264,217504,220276,222747,222993,223094]
Wed Apr  4 05:47:06 2018,575 [2555] DEBUG VT - Prepared sql query being
executed : SELECT vtiger_modcomments.modcommentsid FROM vtiger_modcomments
                                                LEFT JOIN vtiger_crmentity
ON vtiger_crmentity.crmid = vtiger_modcomments.related_to
                                                WHERE
vtiger_crmentity.setype NOT IN (?,?)
                                                OR vtiger_crmentity.setype
IS NULL AND modcommentsid > ? LIMIT 500
=================

Any idea how to bite it?
T.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20180404/ba05389d/attachment.html>


More information about the vtigercrm-developers mailing list