[FX.php List] I just installed FMSA 11 and WPE on each their machine

Gjermund Gusland Thorsen ggt667 at gmail.com
Mon Jun 28 17:35:50 MDT 2010


as a 2 machine solution

it works nicely at first

$ time curl "http://user:passwd@10.0.0.100:80/fmi/xml/FMPXMLRESULT.xml?-db=Document&-lay=Weblookup&-findany";echo
<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN"
"/fmi/xml/FMPXMLRESULT.dtd"><FMPXMLRESULT
xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE><PRODUCT
BUILD="01/27/2010" NAME="FileMaker Web Publishing Engine"
VERSION="11.0.1.86"/><DATABASE DATEFORMAT="MM/dd/yyyy"
LAYOUT="WebLookup" NAME="Document" RECORDS="500361"
TIMEFORMAT="HH:mm:ss"/><METADATA><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="URL" TYPE="TEXT"/><FIELD EMPTYOK="NO" MAXREPEAT="1"
NAME="webLookup" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="Globals::documentPathProduction" TYPE="TEXT"/><FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="attachmentLocation"
TYPE="TEXT"/></METADATA><RESULTSET FOUND="1"><ROW MODID="13"
RECORDID="59038"><COL><DATA>http://www.appendiks.no/Document/PO/2007/11/OSL-64401/20071107100021252.pdf</DATA></COL><COL><DATA>Ym8EIG2xLiDEuSFBF8o</DATA></COL><COL><DATA>http://www.appendiks.no/</DATA></COL><COL><DATA>PO/2007/11/OSL-64401/20071107100021252.pdf</DATA></COL></ROW></RESULTSET></FMPXMLRESULT>
real	0m0.108s
user	0m0.010s
sys	0m0.010s

But then after 25-50 queries response time is like amazingly 1
MINUTE!!! 24.087s:
$ time curl "http://user:passwd@10.0.0.100:80/fmi/xml/FMPXMLRESULT.xml?-db=Document&-lay=Weblookup&-findany";echo
<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN"
"/fmi/xml/FMPXMLRESULT.dtd"><FMPXMLRESULT
xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE><PRODUCT
BUILD="01/27/2010" NAME="FileMaker Web Publishing Engine"
VERSION="11.0.1.86"/><DATABASE DATEFORMAT="MM/dd/yyyy"
LAYOUT="WebLookup" NAME="Document" RECORDS="500361"
TIMEFORMAT="HH:mm:ss"/><METADATA><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="URL" TYPE="TEXT"/><FIELD EMPTYOK="NO" MAXREPEAT="1"
NAME="webLookup" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="Globals::documentPathProduction" TYPE="TEXT"/><FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="attachmentLocation"
TYPE="TEXT"/></METADATA><RESULTSET FOUND="1"><ROW MODID="18"
RECORDID="32009"><COL><DATA>http://www.appendiks.no/Document/f/2007/06/S33484/unknown.2.html</DATA></COL><COL><DATA>6LpbTEHv2okLPGH7HQD</DATA></COL><COL><DATA>http://www.appendiks.no/</DATA></COL><COL><DATA>f/2007/06/S33484/unknown.2.html</DATA></COL></ROW></RESULTSET></FMPXMLRESULT>
real	1m24.087s
user	0m0.010s
sys	0m0.020s

The setup is a
MacMini with 4GB RAM and 30GB SSD, running ONLY FMSA worker
XServe with 8GB RAM and 3x135GB 15000RPM disks, running FMSA

Gigabit inbetween

queries are the same whether done from a local workstation on the LAN
or the WPE machine itself.

Anyone got a clue to why this happens?

After even longer an Error 503, Service temporarily Unavailable will occur

and after 15 mins there will be 404, Not Found will show up

ggt


More information about the FX.php_List mailing list