Re: Too very slow pages on ic 5.10.0

Il 10/03/2018 17:46, Gert van der Spoel ha scritto:
>> -----Original Message-----
>> From: [email protected] [mailto:interchange-users-
>> [email protected]] On Behalf Of marco
>> Sent: Saturday, March 10, 2018 14:45
>> To: [email protected]
>> Subject: [ic] Too very slow pages on ic 5.10.0
>>
>> ---- (1) -----
>> after 3 months of installation and light use my old production catalogue
>> with:
>> - interchange 5.10.0
>> - debian 9
>> - perl 5.24.1
>> - mysqld 10.1.26-MariaDB-0+deb9u1
>> - hypervisor (vmware player 12, 4GB ram 1 cpu 4 cores) I notice that for
> the
>> pages with heavy query became very slow and sometimes bring to "Gateway
>> Timeout"
>> "top" utility display cpu to 100% during page wait sometimes for mysql and
>> sometimes for interchange
>>
>> I test the same catalogue in the same pages with the same db on the old
>> server:
>> - interchange 5.6.3
>> - debian 6
>> - perl 5.10.1
>> - mysqld 5.1.73-1-log
>> - hypervisor (virtualbox 4GB ram 1 cpu)
>>
>> the pages in the old server are quicker from 4 to 14 times !
>>
>> ---- (2) -----
>> This now is a serious problem for me and my client and in the attempt to
>> quickly solve it I try to install (develop server) interchange 5.6.3 on
> the new
>> server debian 9 but there is a problem on make:
>>
>> root /usr/local/src/interchange-5.6.3 # make "/usr/bin/perl" "-Iblib/arch"
> "-
>> Iblib/lib" relocate.pl scripts/ic_mod_perl Can't locate scripts/initp.pl
> in @INC
>> (@INC contains: blib/arch blib/lib /etc/perl /usr/local/lib/x86_64-linux-
>> gnu/perl/5.24.1
>> /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24
>> /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24
>> /usr/share/perl/5.24 /usr/local/lib/site_perl
>> /usr/lib/x86_64-linux-gnu/perl-base) at relocate.pl line 26.
>> Makefile:898: recipe for target 'scripts/ic_mod_perl' failed
>> make: *** [scripts/ic_mod_perl] Error 2
>>
>> Any suggestion ?
>
> I have a bit of difficulty understanding what the install sequence is that
> you are trying to do ... This is what I believe the most basic installation
> commands:
> tar xvzf interchange-X.Y.Z.tar.gz
> cd interchange-X.Y.Z
> perl Makefile.PL
> make
> make test
> make install
>
>>From what I understand from the installation code the perl Makefile.PL
> command would create the scripts/initp.pl file .. If this did not happen I'd
> assume there is an earlier error that you encountered in your installation.
>
> If this is a completely 'fresh' install you might want to just remove the
> /usr/local/src/interchange-5.6.3 folder and go into /usr/local/src/ and get
> your interchange tar.gz there and follow the above steps ..
>
> Unless you of course have a different approach for installation which maybe
> you could share for us to understand what you usually do.
>
My way to install is as you suggest:
perl -MCPAN -e 'install Bundle::Interchange'
tar xvzf interchange-X.Y.Z.tar.gz
cd interchange-X.Y.Z
perl Makefile.PL
make
make test
make install

BUT when I had installed ic 5.10.0 I had the same make "Error 2" and so, 
from mailing list suggestion, I download this version from github
https://github.com/interchange/interchange/archive/master.zip
and followed that instructions with success.

"Fresh" ? The ic 5.6.3 installation tried now is from an alternative dir 
but in the same server debian 9 where run slow ic 5.10.0. I had tried 
this method of more ic versions on the same server more times in the 
past. With a soft link dir 'interchange' pointing to the installed 
testing version for example /usr/local/interchange-5.6.3 or 
/usr/local/interchange-5.10.0 I can test and try different version on 
the same catalogue.

As your suggestion I tried to move interchange-5.6.3.tar.gz to 
/usr/src/interchange-5.6.3 rather than /usr/local/src/interchange-5.6.3 
and follow same way to compile but I obtain the same error.

Catching the output of install sequence I do not find any hints:
-------------------------------------------------------------
root /usr/src/interchange-5.6.3 # perl Makefile.PL
Checking if your kit is complete...
Looks good
 
 
 
                          Interchange cannot be run as root. Which user 
should run Interchange? interch

  Interchange V5.6.3

  Copyright (C) 2002-2010 Interchange Development Group.
  Copyright (C) 1996-2002 Red Hat, Inc.
  Interchange is free under the terms of the GNU General Public License.

  http://www.icdevgroup.org/

 
 
 
                          Where is your Interchange to be installed? 
/usr/local/interchange-5.6.3

Generating a Unix-style Makefile
Writing Makefile for Interchange
Writing MYMETA.yml and MYMETA.json

root /usr/src/interchange-5.6.3 # make
cp lib/Vend/Payment/EFSNet.pm blib/lib/Vend/Payment/EFSNet.pm
cp lib/Vend/Email.pm blib/lib/Vend/Email.pm
cp lib/Vend/Payment/PSiGate.pm blib/lib/Vend/Payment/PSiGate.pm
cp lib/Vend/Payment/PRI.pm blib/lib/Vend/Payment/PRI.pm
cp lib/Vend/Payment/BusinessOnlinePayment.pm 
blib/lib/Vend/Payment/BusinessOnlinePayment.pm
cp lib/Vend/Cron.pm blib/lib/Vend/Cron.pm
cp lib/Vend/Payment.pm blib/lib/Vend/Payment.pm
cp lib/Vend/Data.pm blib/lib/Vend/Data.pm
cp lib/Vend/MakeCat.pm blib/lib/Vend/MakeCat.pm
cp lib/Vend/Payment/ICS.pm blib/lib/Vend/Payment/ICS.pm
cp lib/Vend/Payment/ECHO.pm blib/lib/Vend/Payment/ECHO.pm
cp lib/Vend/Options/Simple.pm blib/lib/Vend/Options/Simple.pm
cp lib/Vend/Page.pm blib/lib/Vend/Page.pm
cp lib/Vend/Glimpse.pm blib/lib/Vend/Glimpse.pm
cp lib/Vend/Payment/Protx2.pm blib/lib/Vend/Payment/Protx2.pm
cp lib/Vend/Options/Old48.pm blib/lib/Vend/Options/Old48.pm
cp lib/Vend/Menu.pm blib/lib/Vend/Menu.pm
cp lib/Vend/CounterFile.pm blib/lib/Vend/CounterFile.pm
cp lib/Vend/Order.pm blib/lib/Vend/Order.pm
cp lib/Vend/Payment/Sage.pm blib/lib/Vend/Payment/Sage.pm
cp lib/Vend/External.pm blib/lib/Vend/External.pm
cp lib/Vend/Error.pm blib/lib/Vend/Error.pm
cp hints.pl blib/lib/hints.pl
cp lib/Vend/Payment/BoA.pm blib/lib/Vend/Payment/BoA.pm
cp lib/Vend/File.pm blib/lib/Vend/File.pm
cp lib/Vend/Config.pm blib/lib/Vend/Config.pm
cp lib/Vend/Document.pm blib/lib/Vend/Document.pm
cp lib/Vend/Dispatch.pm blib/lib/Vend/Dispatch.pm
cp lib/Vend/Payment/CyberCash.pm blib/lib/Vend/Payment/CyberCash.pm
cp lib/Vend/Interpolate.pm blib/lib/Vend/Interpolate.pm
cp lib/Vend/Payment/MCVE.pm blib/lib/Vend/Payment/MCVE.pm
cp install_lsb.pl blib/lib/install_lsb.pl
cp lib/Vend/Cart.pm blib/lib/Vend/Cart.pm
cp lib/Vend/Parser.pm blib/lib/Vend/Parser.pm
cp lib/Vend/Accounting.pm blib/lib/Vend/Accounting.pm
cp lib/Vend/Parse.pm blib/lib/Vend/Parse.pm
cp lib/Vend/Options.pm blib/lib/Vend/Options.pm
cp lib/Vend/Form.pm blib/lib/Vend/Form.pm
cp lib/Vend/DbSearch.pm blib/lib/Vend/DbSearch.pm
cp lib/Vend/Payment/Linkpoint.pm blib/lib/Vend/Payment/Linkpoint.pm
cp lib/Vend/Payment/NetBilling.pm blib/lib/Vend/Payment/NetBilling.pm
cp lib/Vend/Imagemap.pm blib/lib/Vend/Imagemap.pm
cp lib/Vend/Options/Matrix.pm blib/lib/Vend/Options/Matrix.pm
cp lib/Vend/ModPerl.pm blib/lib/Vend/ModPerl.pm
cp lib/Vend/Payment/AuthorizeNet.pm blib/lib/Vend/Payment/AuthorizeNet.pm
cp lib/Vend/Payment/Getitcard.pm blib/lib/Vend/Payment/Getitcard.pm
cp lib/Vend/Accounting/SQL_Ledger.pm blib/lib/Vend/Accounting/SQL_Ledger.pm
cp lib/Vend/CharSet.pm blib/lib/Vend/CharSet.pm
cp lib/Vend/Control.pm blib/lib/Vend/Control.pm
cp lib/Vend/Payment/Ezic.pm blib/lib/Vend/Payment/Ezic.pm
cp lib/Vend/Table/DB_File.pm blib/lib/Vend/Table/DB_File.pm
cp lib/Vend/SessionDB.pm blib/lib/Vend/SessionDB.pm
cp lib/Vend/Tags.pm blib/lib/Vend/Tags.pm
AutoSplitting blib/lib/Vend/Tags.pm (blib/lib/auto/Vend/Tags)
cp lib/Vend/SOAP.pm blib/lib/Vend/SOAP.pm
AutoSplitting blib/lib/Vend/SOAP.pm (blib/lib/auto/Vend/SOAP)
cp lib/Vend/SQL_Parser.pm blib/lib/Vend/SQL_Parser.pm
cp lib/Vend/Table/DBI_CompositeKey.pm 
blib/lib/Vend/Table/DBI_CompositeKey.pm
cp relocate.pl blib/lib/relocate.pl
cp lib/Vend/Track.pm blib/lib/Vend/Track.pm
cp lib/Vend/Table/DBI.pm blib/lib/Vend/Table/DBI.pm
cp lib/Vend/Scan.pm blib/lib/Vend/Scan.pm
cp lib/Vend/Payment/TCLink.pm blib/lib/Vend/Payment/TCLink.pm
cp lib/Vend/Table/Shadow.pm blib/lib/Vend/Table/Shadow.pm
cp lib/Vend/Table/LDAP.pm blib/lib/Vend/Table/LDAP.pm
cp lib/Vend/TextSearch.pm blib/lib/Vend/TextSearch.pm
cp lib/Vend/Subs.pm blib/lib/Vend/Subs.pm
cp lib/Vend/Ship.pm blib/lib/Vend/Ship.pm
cp lib/Vend/SOAP/Transport.pm blib/lib/Vend/SOAP/Transport.pm
cp lib/Vend/Payment/Skipjack.pm blib/lib/Vend/Payment/Skipjack.pm
cp lib/Vend/UserControl.pm blib/lib/Vend/UserControl.pm
cp lib/Vend/Table/Editor.pm blib/lib/Vend/Table/Editor.pm
cp lib/Vend/Session.pm blib/lib/Vend/Session.pm
cp lib/Vend/Util.pm blib/lib/Vend/Util.pm
cp lib/Vend/Table/Common.pm blib/lib/Vend/Table/Common.pm
cp lib/Vend/UserDB.pm blib/lib/Vend/UserDB.pm
cp lib/Vend/Search.pm blib/lib/Vend/Search.pm
cp lib/Vend/Table/SDBM.pm blib/lib/Vend/Table/SDBM.pm
cp lib/Vend/Ship/QueryUPS.pm blib/lib/Vend/Ship/QueryUPS.pm
cp lib/Vend/Payment/TestPayment.pm blib/lib/Vend/Payment/TestPayment.pm
cp lib/Vend/Table/InMemory.pm blib/lib/Vend/Table/InMemory.pm
cp lib/Vend/Table/GDBM.pm blib/lib/Vend/Table/GDBM.pm
cp lib/Vend/Payment/Signio.pm blib/lib/Vend/Payment/Signio.pm
cp lib/Vend/Server.pm blib/lib/Vend/Server.pm
cp lib/Vend/Swish.pm blib/lib/Vend/Swish.pm
cp lib/Vend/Ship/Postal.pm blib/lib/Vend/Ship/Postal.pm
cp lib/Vend/RefSearch.pm blib/lib/Vend/RefSearch.pm
cp lib/Vend/SessionFile.pm blib/lib/Vend/SessionFile.pm
cp lib/Vend/Payment/iTransact.pm blib/lib/Vend/Payment/iTransact.pm
"/usr/bin/perl" "-Iblib/arch" "-Iblib/lib" relocate.pl scripts/makecat
Can't locate scripts/initp.pl in @INC (@INC contains: blib/arch blib/lib 
/etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 
/usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 
/usr/share/perl/5.24 /usr/local/lib/site_perl 
/usr/lib/x86_64-linux-gnu/perl-base) at relocate.pl line 26.
Makefile:916: recipe for target 'scripts/makecat' failed
make: *** [scripts/makecat] Error 2


-- 
"Fino alla bara sinpara"
"Up to demise we rize"