How long time does it take before your 500 err=or appear?FcgidIOTimeout is set to 40 seconds as defaul=t in Apache 2.5.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. 15:25 skrev Lawrence Banahan <banahan.l@gmail.com>:------------------------------ So isn't= it in apache that I should setup a Timeout or KeepAlive On or so one?This morning I wrote a dirty script to summ the result by maki=ng 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 thinki=ng of Webdna, Ram etc, but a 500 answer isn't it a Apache error?
I realised that this new db was still getting written after this 500 err=or and I did get the right data in my db after all...
<=/div>Not sure how to set this up...2017-12-13 0:59 GMT+01:00 Brian Harrington<autoglasswny@gmail.com>: LMAO... maybe that's why the cable company makes u re=boot first thing! my current server 2006 mac pro 32BG 2X 3GHZ dual cores ==C2=A00 raid on 4 X2TB HDD's...=C2=A0=C2=A0trying t=o speed load times on my heavy dynamic site=C2=A0classifieds.today=C2=A0that does not "mirror" but takes on a=ny domain like it's own like http://scottsclassifieds.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 better and was actually slower to serve my les=s complicated sites! I thought maybe it was the builder so picked up 12 cor=e 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 interested)Don=39;t get this 6GB's they claim. When they go on to tell you best read/w=rites are 500/mb's...???!!!=C2=A0=C2=A0 =C2=A0The so claimed= PCIe SSD is now used to drop files (backups) on and I really don't see= it any faster than the IDE I put in my CD slot! Takes 10 seconds either on=e on a drag-n-drop! LOLGlad you have it fixed... =now we can all rest! LOL On Tue, Dec 12, 201=7 at 6:05 PM, <dbrooke@euca.us> wrote:Sorry, I probably missed this in all the emails, but did you =state your server 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
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...