T=he test to upper FcgidIOTimeout to 120 (or whatever value fitting your need=s).Best,Christer==C2=A0************************************=*********************** **
=C2=A0Christer Olsson =C2=A0 PO Box 9160==C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0Phone +46 40 25 85 85
=C2=A0Lj=usa Id=C3=A9er AB =C2=A0 =C2=A0SE-200 39 Malmo=C2=A0 =C2=A0=C2=A0Fax +=46 40 25 85 8913 de=c. 2017 kl. 16:25 skrev Lawrence Banahan <banahan.l@gmail.com>:------------------------------60 sec=onds201=7-12-13 16:07 GMT+01:00 Christer Olsson <christer@ljusaideer.se&g=t;:How long time does it take before your 500 error appear?FcgidIOTimeout is set to 40 seconds as default in Apache 2.5.<=div>Best,Christer=C2=A0=***************************** ****************************** **
==C2=A0Christer Olsson =C2=A0 PO Box 9160=C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0Ph=one +46 40 25 85 85
=C2=A0Ljusa Id=C3=A9er AB =C2=A0 =C2=A0SE-2=00 39 Malmo=C2=A0 =C2=A0=C2=A0Fax +46 40 25 85 89=13 dec. 2017 kl. 15:25 skrev Lawrence Banahan <banahan.l@gmail.com&g=t;:Not sure how to set this u=p...So isn't it in apache that I should set=up a Timeout or KeepAlive On or so one?I realised that this new db =was still getting written after this 500 error and I did get the right data= in my db after all...This morning I wro=te a dirty script to summ the result by making a new DB and searching this =db before adding a new line...And I still add a crash, so memery =problem... Maby not, we all have been thinking of Webdna, Ram etc, but a 50=0 answer isn't it a Apache error?------------------------------201=7-12-13 0:59 GMT+01:00 Brian Harrington <autoglasswny@gmail.com&g=t;:LMAO... maybe= that's why the cable company makes u reboot first thing! my current se=rver 2006 mac pro 32BG 2X 3GHZ dual cores =C2=A00 raid on 4 X2TB HDD's.=...=C2=A0=C2=A0trying to speed load times on my heavy dy=namic site=C2=A0classifieds.today=C2=A0that =does not "mirror" but takes on any domain like it's own like =http://scottscl=assifieds.com/ or the 20 other current domains have pointing that way..=... bought an upgraded 12 core 2.66 w/64 GB ram and turned out not much bett=er and was actually slower to serve my less complicated sites! I thought ma=ybe it was the builder so picked up 12 core 3.46! 128GB ram and 1TB SSD and= 8TB 0 RAID and same slow results! HUH=C2=A0=C2=A0(Both R for sale anyone i=nterested)Don't get this 6GB's they claim=.. When they go on to tell you best read/writes are 500/mb's...???!!!=C2==A0=C2=A0 =C2=A0The so claimed PCIe SSD is now used to drop file=s (backups) on and I really don't see it any faster than the IDE I put =in my CD slot! Takes 10 seconds either one on a drag-n-drop! LOL=Glad you have it fixed... now we can all rest! LOLOn Tue, Dec 12, 2017 at 6:05 PM,= <dbrooke@euca.us> wrote:S=orry, I probably missed this in all the emails, but did you state your serv=er info?
WebDNA Version
Operating System
Can you post the results of 'free' and 'df -h' from the com=mandline?
Donovan
On 2017-12-12 12:02, Lawrence Banahan wrote:I have "only" 16 Gb Ram, I also had that with V6, so it looks lik=e
V8.5 needs more Ram...
2017-12-12 18:41 GMT+01:00 Brian Fries <iphonzie@gmail.com [31]>:I ran with your numbers and it worked fine for me. I bumped them up
to 535000 and 510000, and I got the =E2=80=9C500 Internal Server Error=E2==80=9D
So, it looks like an available RAM issue, as you said, with my limit
higher than yours due to different system configuration.
- Brian FriesOn Dec 12, 2017, at 9:26 AM, Lawrence Banahan <banahan.l@gmail.com
[18]> wrote:
Thanks for this test Brian,
I tested it with your code and everything works fine.
http://www.tourismethaifr.com/admin/testdb=..tpl [19]
I have tested with the same amount of data 135 000 like in my DB
and then it crash...
http://www.tourismethaifr.com/admin/testd=b2.tpl [20]
[closedatabase test.db]
[writefile test.db]_email
[/writefile]
[loop start=3D1&end=3D135000][append
db=3Dtest.db]_email=3Dtest[math]floor([random format=3Dfloat]*110000)[/math]@example.com [21][/append][/loop]
[search db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] The db is 3mb, it shouldnt be an issuu...
raw[/search]<br>
[search db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] [=numfound]
summarized[/search]
Maybe somthing to do with RAM... Server...
I have rebooted it!
It was already running on the same server...
2017-12-12 18:01 GMT+01:00 Brian Fries <iphonzie@gmail.com [22]>:Here is a test that should determine whether it is a database
content problem:
[closedatabase test.db]
[writefile test.db]_email
[/writefile]
[loop start=3D1&end=3D15000][append
db=3Dtest.db]_email=3Dtest[math]floor([random format=3Dfloat]*10000)[/math]@example.com [12][/append][/loop]
[search db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] like "test67=46@example.com [13]=E2=80=9D, where the numeric portion is
raw[/search]<br>
[search db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT][numfound] summarized[/search]
This will create a database named =E2=80=9Ctest.db=E2=80=9D with one field =-
=E2=80=9C_email=E2=80=9D, then add 15000 records with _email set to a value=
a random integer from zero to 9999, so there will be duplicates.
In my test on a linux server running WebDNA 8.5.1, it works
fine, with the raw results returning 15000 records, and the
summarized results varying from one run to the next, usually
around 7800 unique values.
My guess would be that this will work fine for you as well, and
that there is some data in the real database that WebDNA is
choking on when running the SUMM comparisons. I this is the
case, then the next step would be to split the real data into
smaller subsets and run the test on those until you can isolate
what data is causing WebDNA problems. Then Chris will have
something specific to fix.
- Brian FriesOn Dec 12, 2017, at 7:28 AM, Brian Harrington
<autoglasswn=y@gmail.com [6]> wrote:
exactly what Ive been saying... you all keep your little code
a secret and NO resource on the website, =C2=A0same site for 12
years! yelp... just checked "search" on "sort" NO REF T=HERE!
So we all need to take notes...?
On Tue, Dec 12, 2017 at 12:04 PM, Kenneth Grome
<ken@webdna=solutions.com [7]> wrote:I see two problems with>
> complex sort example:
> &email*S*sort=3D1&emailsdir=3Das
> (should be &emailsort=3D1&emailsdir=3Das)
I already corrected this typo in a later post ... :)
> simple sort example:
> &*as*emailsort=3D1
> (should be &emailsort=3D1)
No it should not!
Youre saying this because you do not know how to write
simpler
sort code.=C2=A0 And thats why I posted this example ... so you
and
Lawrence (and anyone else who does not know this) might
learn how
to do it.
Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com [1]
Web Database Systems and Linux Server Administration
--------------------------------------------------------- the mailing list talk@w=ebdna.us [2]
This message is sent to you because you are subscribed to
To unsubscribe, E-mail to: talk-leave@webdna.us [3]
archives: http://www.webdna.us/page.dna?numero=3D55 [4]
Bug Reporting: suppo=rt@webdna.us [5]
--------------------------------------------------------- mailing list talk@webdn=a.us [8] To unsubscribe, E-mail to:
This message is sent to you because you are subscribed to the
talk-leave@webdna=..us [9] archives:
http://www.webdna.us/page.dna?numero=3D55 [10] Bug= Reporting:
support@webdna.us [11]
--------------------------------------------------------- This list talk@webdna.us= [14] To unsubscribe, E-mail to:
message is sent to you because you are subscribed to the mailing
talk-leave@webdna=..us [15] archives:
http://www.webdna.us/page.dna?numero=3D55 [16] Bug= Reporting:
support@webdna.us [17]
--------------------------------------------------------- This list talk@webdna.us= [23] To unsubscribe, E-mail to:
message is sent to you because you are subscribed to the mailing
talk-leave@webdna=..us [24] archives:
http://www.webdna.us/page.dna?numero=3D55 [25] Bug= Reporting:
support@webdna.us [26]
--------------------------------------------------------- This list talk@webdna.us= [27] To unsubscribe, E-mail to:
message is sent to you because you are subscribed to the mailing
talk-leave@webdna=..us [28] archives:
http://www.webdna.us/page.dna?numero=3D55 [29] Bug= Reporting:
support@webdna.us [30]
=C2=A0--------------------------------------------------------- Thismessage is sent to you because you are subscribed to the mailing list Links:
talk@webdna.us To u=nsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting:
support@webdna.us
------
[1] http://www.webdnasolutions.com/
[2] mailto:talk@webdna.=us
[3] mailto:talk-l=eave@webdna.us
[4] http://www.webdna.us/page.dna?numero=3D55
[5] mailto:support@w=ebdna.us
[6] mailto:auto=glasswny@gmail.com
[7] mailto:ken=@webdnasolutions.com
[8] mailto:talk@webdna.=us
[9] mailto:talk-l=eave@webdna.us
[10] http://www.webdna.us/page.dna?numero=3D55
[11] mailto:support@=webdna.us
[12] h=ttp://example.com/
[13] mailto:test6=746@example.com
[14] mailto:talk@webdna=..us
[15] mailto:talk-=leave@webdna.us
[16] http://www.webdna.us/page.dna?numero=3D55
[17] mailto:support@=webdna.us
[18] mailto:banaha=n.l@gmail.com
[19] http://www.tourismethaifr.com/admin/testdb.t=pl
[20] http://www.tourismethaifr.com/admin/testdb2=..tpl
[21] h=ttp://example.com/
[22] mailto:iphonzi=e@gmail.com
[23] mailto:talk@webdna=..us
[24] mailto:talk-=leave@webdna.us
[25] http://www.webdna.us/page.dna?numero=3D55
[26] mailto:support@=webdna.us
[27] mailto:talk@webdna=..us
[28] mailto:talk-=leave@webdna.us
[29] http://www.webdna.us/page.dna?numero=3D55
[30] mailto:support@=webdna.us
[31] mailto:iphonzi=e@gmail.com
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list talk@w=ebdna.us
To unsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting: suppo=rt@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@w=ebdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna? numero=3D55 Bug Reporting: suppo=rt@webdna.us---------------------------This message is sent to you because you are subscribed tothe mailing list talk@w=ebdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna? numero=3D55 Bug Reporting: suppo=rt@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@w=ebdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna? numero=3D55 Bug Reporting: suppo=rt@webdna.us---------------------------This message is sent to you because you are subscribed tothe mailing list talk@w=ebdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna? numero=3D55 Bug Reporting: suppo=rt@webdna.us
DOWNLOAD WEBDNA NOW!
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...