Re: [WebDNA] Error 500 with SUMM=T
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113859
interpreted = N
texte = 1454 The "/etc/apache2/apache2.conf" file on one of my 2.4.25 servers has these values. If your values are different you might want to try these: Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 5 Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 12/13/2017 10:41 AM, Lawrence Banahan wrote: > 2.4 >=20 > Le=C2=A013 d=C3=A9c. 2017 5:12 PM, "Christer Olsson"
> a =C3=A9crit=C2=A0: >=20 > Which version of Apache are you running? >=20 > Best, > Christer >=20 > =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=A0Ljusa Id=C3=A9er AB =C2=A0 =C2=A0SE-200 39 Malmo=C2=A0 =C2=A0= =C2=A0Fax +46 40 25 85 89 > >=20 >=20 >=20 >> 13 dec. 2017 kl. 16:51 skrev Lawrence Banahan >> >: >> >> I don't see any value for fcgi in the httpd.conf... >> >> 2017-12-13 16:28 GMT+01:00 Christer Olsson >> >: >> >> The test to upper FcgidIOTimeout to 120 (or whatever >> value fitting your needs). >> >> 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=A0Ljusa Id=C3=A9er AB =C2=A0 =C2=A0SE-200 39 Malmo=C2=A0 =C2= =A0=C2=A0Fax +46 40 25 85 >> 89 >> >> >> >>> 13 dec. 2017 kl. 16:25 skrev Lawrence Banahan >>> >: >>> >>> 60 seconds >>> >>> 2017-12-13 16:07 GMT+01:00 Christer Olsson >>> >: >>> >>> How long time does it take before your 500 error >>> appear? >>> >>> FcgidIOTimeout is set to 40 seconds as default 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=A0Ljusa Id=C3=A9er AB =C2=A0 =C2=A0SE-200 39 Malmo=C2= =A0 =C2=A0=C2=A0Fax +46 40 25 >>> 85 89 >>> >>> >>> >>>> 13 dec. 2017 kl. 15:25 skrev Lawrence Banahan >>>> >: >>>> >>>> This morning I wrote 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 500 answer isn't it a Apache error? >>>> 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... >>>> So isn't it in apache that I should setup a >>>> Timeout or KeepAlive On or so one? >>>> Not sure how to set this up... >>>> >>>> 2017-12-13 0:59 GMT+01:00 Brian Harrington >>>> >>> >: >>>> >>>> LMAO... maybe that's why the cable company >>>> makes u reboot 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 to speed load times on my heavy >>>> dynamic site=C2=A0classifieds.today >>>> =C2=A0that does not >>>> "mirror" but takes on any 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 less complicated >>>> sites! I thought maybe 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 interested) >>>> >>>> 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 >>>> 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 one on a drag-n-drop! LOL >>>> >>>> Glad you have it fixed... now we can all rest! LOL >>>> >>>> On Tue, Dec 12, 2017 at 6:05 PM, >>>> > 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 commandline? >>>> >>>> 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 like >>>> V8.5 needs more Ram... >>>> >>>> 2017-12-12 18:41 GMT+01:00 Brian Fries >>>> >>> [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 Fries >>>> >>>> On Dec 12, 2017, at 9:26 AM, >>>> Lawrence Banahan >>>> >>> >>>> [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/= testdb2.tpl >>>> >>>> [20] >>>> >>>> [closedatabase test.db] >>>> [writefile test.db]_email >>>> [/writefile] >>>> [loop start=3D1&end=3D135000][append >>>> db=3Dtest.db]_email=3Dtest[math]floo= r([random >>>> format=3Dfloat]*110000)[/math]@examp= le.com >>>> >>>> [21][/append][/loop] >>>> [search >>>> db=3Dtest.db&ne_emaildata=3DFIND_ALL= ] >>>> [numfound] >>>> raw[/search]
>>>> [search >>>> db=3Dtest.db&ne_emaildata=3DFIND_ALL= &_emailSUMM=3DT] >>>> [numfound] >>>> summarized[/search] >>>> >>>> Maybe somthing to do with >>>> RAM... Server... >>>> I have rebooted it! >>>> The db is 3mb, it shouldnt be >>>> an issuu... >>>> >>>> It was already running on the >>>> same server... >>>> >>>> 2017-12-12 18:01 GMT+01:00 >>>> Brian Fries >>>> >>> [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]@ex= ample.com >>>> >>>> [12][/append][/loop] >>>> [search >>>> db=3Dtest.db&ne_emaildata=3DFIND= _ALL] >>>> [numfound] >>>> raw[/search]
>>>> [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 a= dd 15000 >>>> records with _email set to >>>> a value >>>> like "test6746@example.com >>>> >>>> [13]=E2=80=9D, where the numeric >>>> portion is >>>> 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 Fries >>>> >>>> On Dec 12, 2017, at >>>> 7:28 AM, Brian Harrington >>>> >>>> [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 THERE! >>>> >>>> So we all need to take >>>> notes...? >>>> >>>> On Tue, Dec 12, 2017 >>>> at 12:04 PM, Kenneth Grome >>>> >>> >>>> [7]> wrote: >>>> >>>> I see two >>>> problems with >>>> >>>> > >>>> > complex sort example: >>>> > &email*S*sort=3D1&emai= lsdir=3Das >>>> > (should be &emailsort=3D= 1&emailsdir=3Das) >>>> >>>> I already >>>> corrected this >>>> typo in a later >>>> post ... :) >>>> >>>> > simple sort example: >>>> > &*as*emailsort=3D1 >>>> > (should be &emailsort=3D= 1) >>>> >>>> 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.webdnasolutio= ns.com >>>> >>>> [1] >>>> Web Database >>>> Systems and Linux >>>> Server Administration >>>> >>>> ------------------------= --------------------------------- >>>> This message is >>>> sent to you >>>> because you are >>>> subscribed to >>>> the mailing list >>>> talk@webdna.us >>>> >>>> [2] >>>> To unsubscribe, >>>> E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [3] >>>> archives: >>>> http://www.webdna.us/pag= e.dna?numero=3D55 >>>> >>>> [4] >>>> Bug Reporting: >>>> support@webdna.us >>>> >>>> [5] >>>> >>>> >>>> ----------------------------= ----------------------------- >>>> This message is sent >>>> to you because you are >>>> subscribed to the >>>> mailing list >>>> talk@webdna.us >>>> [8] >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [9] archives: >>>> http://www.webdna.us/page.dn= a?numero=3D55 >>>> >>>> [10] Bug Reporting: >>>> support@webdna.us >>>> >>>> [11] >>>> >>>> >>>> --------------------------------= ------------------------- >>>> This >>>> message is sent to you >>>> because you are subscribed >>>> to the mailing >>>> list talk@webdna.us >>>> >>>> [14] To unsubscribe, >>>> E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [15] archives: >>>> http://www.webdna.us/page.dna?nu= mero=3D55 >>>> >>>> [16] Bug Reporting: >>>> support@webdna.us >>>> >>>> [17] >>>> >>>> >>>> ------------------------------------= --------------------- >>>> This >>>> message is sent to you because >>>> you are subscribed to the mailing >>>> list talk@webdna.us >>>> [23] >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [24] archives: >>>> http://www.webdna.us/page.dna?numero= =3D55 >>>> >>>> [25] Bug Reporting: >>>> support@webdna.us >>>> [26] >>>> >>>> >>>> ----------------------------------------= ----------------- >>>> This >>>> message is sent to you because you >>>> are subscribed to the mailing >>>> list talk@webdna.us >>>> [27] To >>>> unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> [28] >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D5= 5 >>>> >>>> [29] Bug Reporting: >>>> support@webdna.us >>>> [30] >>>> >>>> >>>> =C2=A0--------------------------------------= ------------------- >>>> This >>>> message is sent to you because you are >>>> subscribed to the mailing list >>>> talk@webdna.us >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> Bug Reporting: >>>> support@webdna.us >>>> >>>> >>>> Links: >>>> ------ >>>> [1] http://www.webdnasolutions.com/ >>>> >>>> [2] mailto:talk@webdna.us >>>> >>>> [3] mailto:talk-leave@webdna.us >>>> >>>> [4] >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> [5] mailto:support@webdna.us >>>> >>>> [6] mailto:autoglasswny@gmail.com >>>> >>>> [7] mailto:ken@webdnasolutions.com >>>> >>>> [8] mailto:talk@webdna.us >>>> >>>> [9] mailto:talk-leave@webdna.us >>>> >>>> [10] >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> [11] mailto:support@webdna.us >>>> >>>> [12] http://example.com/ >>>> [13] mailto:test6746@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:banahan.l@gmail.com >>>> >>>> [19] >>>> http://www.tourismethaifr.com/admin/testdb.t= pl >>>> >>>> [20] >>>> http://www.tourismethaifr.com/admin/testdb2.= tpl >>>> >>>> [21] http://example.com/ >>>> [22] mailto:iphonzie@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:iphonzie@gmail.com >>>> >>>> >>>> >>>> ------------------------------------------------= --------- >>>> This message is sent to you because you >>>> are subscribed to >>>> the mailing list talk@webdna.us >>>> >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> >>>> Bug Reporting: support@webdna.us >>>> >>>> >>>> >>>> ----------------------------------------------------= ----- >>>> This message is sent to you because you are >>>> subscribed to the mailing list talk@webdna.us >>>> To unsubscribe, E-mail >>>> to: talk-leave@webdna.us >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> Bug >>>> Reporting: support@webdna.us >>>> >>>> >>>> >>>> --------------------------------------------------------= - >>>> This message is sent to you because you are >>>> subscribed to the mailing list talk@webdna.us >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> archives: http://www.webdna.us/page.dna?numero=3D55 >>>> Bug >>>> Reporting: support@webdna.us >>>> >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are >>> subscribed to the mailing list talk@webdna.us >>> To unsubscribe, E-mail to: >>> talk-leave@webdna.us >>> archives: http://www.webdna.us/page.dna?numero=3D55 >>> Bug >>> Reporting: support@webdna.us >>> >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed >>> to the mailing list talk@webdna.us >>> To unsubscribe, E-mail to: >>> talk-leave@webdna.us >>> archives: http://www.webdna.us/page.dna?numero=3D55 >>> Bug >>> Reporting: support@webdna.us >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the >> mailing list talk@webdna.us To >> unsubscribe, E-mail to: talk-leave@webdna.us >> archives: >> http://www.webdna.us/page.dna?numero=3D55 >> Bug Reporting: >> support@webdna.us >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list talk@webdna.us To >> unsubscribe, E-mail to: talk-leave@webdna.us >> archives: >> http://www.webdna.us/page.dna?numero=3D55 >> Bug Reporting: >> support@webdna.us >=20 > --------------------------------------------------------- This > message is sent to you because you are subscribed to the > mailing list talk@webdna.us To > unsubscribe, E-mail to: talk-leave@webdna.us > archives: > http://www.webdna.us/page.dna?numero=3D55 > Bug Reporting: > support@webdna.us >=20 > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list talk@webdna.us To unsubscribe, E-mail to: > talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
Associated Messages, from the most recent to the oldest:
1454 The "/etc/apache2/apache2.conf" file on one of my 2.4.25 servers has these values. If your values are different you might want to try these: Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 5 Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 12/13/2017 10:41 AM, Lawrence Banahan wrote: > 2.4 >=20 > Le=C2=A013 d=C3=A9c. 2017 5:12 PM, "Christer Olsson" > a =C3=A9crit=C2=A0: >=20 > Which version of Apache are you running? >=20 > Best, > Christer >=20 > =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=A0Ljusa Id=C3=A9er AB =C2=A0 =C2=A0SE-200 39 Malmo=C2=A0 =C2=A0= =C2=A0Fax +46 40 25 85 89 > >=20 >=20 >=20 >> 13 dec. 2017 kl. 16:51 skrev Lawrence Banahan >> >: >> >> I don't see any value for fcgi in the httpd.conf... >> >> 2017-12-13 16:28 GMT+01:00 Christer Olsson >> >: >> >> The test to upper FcgidIOTimeout to 120 (or whatever >> value fitting your needs). >> >> 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=A0Ljusa Id=C3=A9er AB =C2=A0 =C2=A0SE-200 39 Malmo=C2=A0 =C2= =A0=C2=A0Fax +46 40 25 85 >> 89 >> >> >> >>> 13 dec. 2017 kl. 16:25 skrev Lawrence Banahan >>> >: >>> >>> 60 seconds >>> >>> 2017-12-13 16:07 GMT+01:00 Christer Olsson >>> >: >>> >>> How long time does it take before your 500 error >>> appear? >>> >>> FcgidIOTimeout is set to 40 seconds as default 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=A0Ljusa Id=C3=A9er AB =C2=A0 =C2=A0SE-200 39 Malmo=C2= =A0 =C2=A0=C2=A0Fax +46 40 25 >>> 85 89 >>> >>> >>> >>>> 13 dec. 2017 kl. 15:25 skrev Lawrence Banahan >>>> >: >>>> >>>> This morning I wrote 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 500 answer isn't it a Apache error? >>>> 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... >>>> So isn't it in apache that I should setup a >>>> Timeout or KeepAlive On or so one? >>>> Not sure how to set this up... >>>> >>>> 2017-12-13 0:59 GMT+01:00 Brian Harrington >>>> >>> >: >>>> >>>> LMAO... maybe that's why the cable company >>>> makes u reboot 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 to speed load times on my heavy >>>> dynamic site=C2=A0classifieds.today >>>> =C2=A0that does not >>>> "mirror" but takes on any 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 less complicated >>>> sites! I thought maybe 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 interested) >>>> >>>> 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 >>>> 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 one on a drag-n-drop! LOL >>>> >>>> Glad you have it fixed... now we can all rest! LOL >>>> >>>> On Tue, Dec 12, 2017 at 6:05 PM, >>>> > 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 commandline? >>>> >>>> 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 like >>>> V8.5 needs more Ram... >>>> >>>> 2017-12-12 18:41 GMT+01:00 Brian Fries >>>> >>> [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 Fries >>>> >>>> On Dec 12, 2017, at 9:26 AM, >>>> Lawrence Banahan >>>> >>> >>>> [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/= testdb2.tpl >>>> >>>> [20] >>>> >>>> [closedatabase test.db] >>>> [writefile test.db]_email >>>> [/writefile] >>>> [loop start=3D1&end=3D135000][append >>>> db=3Dtest.db]_email=3Dtest[math]floo= r([random >>>> format=3Dfloat]*110000)[/math]@examp= le.com >>>> >>>> [21][/append][/loop] >>>> [search >>>> db=3Dtest.db&ne_emaildata=3DFIND_ALL= ] >>>> [numfound] >>>> raw[/search]
>>>> [search >>>> db=3Dtest.db&ne_emaildata=3DFIND_ALL= &_emailSUMM=3DT] >>>> [numfound] >>>> summarized[/search] >>>> >>>> Maybe somthing to do with >>>> RAM... Server... >>>> I have rebooted it! >>>> The db is 3mb, it shouldnt be >>>> an issuu... >>>> >>>> It was already running on the >>>> same server... >>>> >>>> 2017-12-12 18:01 GMT+01:00 >>>> Brian Fries >>>> >>> [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]@ex= ample.com >>>> >>>> [12][/append][/loop] >>>> [search >>>> db=3Dtest.db&ne_emaildata=3DFIND= _ALL] >>>> [numfound] >>>> raw[/search]
>>>> [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 a= dd 15000 >>>> records with _email set to >>>> a value >>>> like "test6746@example.com >>>> >>>> [13]=E2=80=9D, where the numeric >>>> portion is >>>> 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 Fries >>>> >>>> On Dec 12, 2017, at >>>> 7:28 AM, Brian Harrington >>>> >>>> [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 THERE! >>>> >>>> So we all need to take >>>> notes...? >>>> >>>> On Tue, Dec 12, 2017 >>>> at 12:04 PM, Kenneth Grome >>>> >>> >>>> [7]> wrote: >>>> >>>> I see two >>>> problems with >>>> >>>> > >>>> > complex sort example: >>>> > &email*S*sort=3D1&emai= lsdir=3Das >>>> > (should be &emailsort=3D= 1&emailsdir=3Das) >>>> >>>> I already >>>> corrected this >>>> typo in a later >>>> post ... :) >>>> >>>> > simple sort example: >>>> > &*as*emailsort=3D1 >>>> > (should be &emailsort=3D= 1) >>>> >>>> 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.webdnasolutio= ns.com >>>> >>>> [1] >>>> Web Database >>>> Systems and Linux >>>> Server Administration >>>> >>>> ------------------------= --------------------------------- >>>> This message is >>>> sent to you >>>> because you are >>>> subscribed to >>>> the mailing list >>>> talk@webdna.us >>>> >>>> [2] >>>> To unsubscribe, >>>> E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [3] >>>> archives: >>>> http://www.webdna.us/pag= e.dna?numero=3D55 >>>> >>>> [4] >>>> Bug Reporting: >>>> support@webdna.us >>>> >>>> [5] >>>> >>>> >>>> ----------------------------= ----------------------------- >>>> This message is sent >>>> to you because you are >>>> subscribed to the >>>> mailing list >>>> talk@webdna.us >>>> [8] >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [9] archives: >>>> http://www.webdna.us/page.dn= a?numero=3D55 >>>> >>>> [10] Bug Reporting: >>>> support@webdna.us >>>> >>>> [11] >>>> >>>> >>>> --------------------------------= ------------------------- >>>> This >>>> message is sent to you >>>> because you are subscribed >>>> to the mailing >>>> list talk@webdna.us >>>> >>>> [14] To unsubscribe, >>>> E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [15] archives: >>>> http://www.webdna.us/page.dna?nu= mero=3D55 >>>> >>>> [16] Bug Reporting: >>>> support@webdna.us >>>> >>>> [17] >>>> >>>> >>>> ------------------------------------= --------------------- >>>> This >>>> message is sent to you because >>>> you are subscribed to the mailing >>>> list talk@webdna.us >>>> [23] >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> [24] archives: >>>> http://www.webdna.us/page.dna?numero= =3D55 >>>> >>>> [25] Bug Reporting: >>>> support@webdna.us >>>> [26] >>>> >>>> >>>> ----------------------------------------= ----------------- >>>> This >>>> message is sent to you because you >>>> are subscribed to the mailing >>>> list talk@webdna.us >>>> [27] To >>>> unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> [28] >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D5= 5 >>>> >>>> [29] Bug Reporting: >>>> support@webdna.us >>>> [30] >>>> >>>> >>>> =C2=A0--------------------------------------= ------------------- >>>> This >>>> message is sent to you because you are >>>> subscribed to the mailing list >>>> talk@webdna.us >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> Bug Reporting: >>>> support@webdna.us >>>> >>>> >>>> Links: >>>> ------ >>>> [1] http://www.webdnasolutions.com/ >>>> >>>> [2] mailto:talk@webdna.us >>>> >>>> [3] mailto:talk-leave@webdna.us >>>> >>>> [4] >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> [5] mailto:support@webdna.us >>>> >>>> [6] mailto:autoglasswny@gmail.com >>>> >>>> [7] mailto:ken@webdnasolutions.com >>>> >>>> [8] mailto:talk@webdna.us >>>> >>>> [9] mailto:talk-leave@webdna.us >>>> >>>> [10] >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> [11] mailto:support@webdna.us >>>> >>>> [12] http://example.com/ >>>> [13] mailto:test6746@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:banahan.l@gmail.com >>>> >>>> [19] >>>> http://www.tourismethaifr.com/admin/testdb.t= pl >>>> >>>> [20] >>>> http://www.tourismethaifr.com/admin/testdb2.= tpl >>>> >>>> [21] http://example.com/ >>>> [22] mailto:iphonzie@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:iphonzie@gmail.com >>>> >>>> >>>> >>>> ------------------------------------------------= --------- >>>> This message is sent to you because you >>>> are subscribed to >>>> the mailing list talk@webdna.us >>>> >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> >>>> Bug Reporting: support@webdna.us >>>> >>>> >>>> >>>> ----------------------------------------------------= ----- >>>> This message is sent to you because you are >>>> subscribed to the mailing list talk@webdna.us >>>> To unsubscribe, E-mail >>>> to: talk-leave@webdna.us >>>> archives: >>>> http://www.webdna.us/page.dna?numero=3D55 >>>> Bug >>>> Reporting: support@webdna.us >>>> >>>> >>>> >>>> --------------------------------------------------------= - >>>> This message is sent to you because you are >>>> subscribed to the mailing list talk@webdna.us >>>> To unsubscribe, E-mail to: >>>> talk-leave@webdna.us >>>> archives: http://www.webdna.us/page.dna?numero=3D55 >>>> Bug >>>> Reporting: support@webdna.us >>>> >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are >>> subscribed to the mailing list talk@webdna.us >>> To unsubscribe, E-mail to: >>> talk-leave@webdna.us >>> archives: http://www.webdna.us/page.dna?numero=3D55 >>> Bug >>> Reporting: support@webdna.us >>> >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed >>> to the mailing list talk@webdna.us >>> To unsubscribe, E-mail to: >>> talk-leave@webdna.us >>> archives: http://www.webdna.us/page.dna?numero=3D55 >>> Bug >>> Reporting: support@webdna.us >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the >> mailing list talk@webdna.us To >> unsubscribe, E-mail to: talk-leave@webdna.us >> archives: >> http://www.webdna.us/page.dna?numero=3D55 >> Bug Reporting: >> support@webdna.us >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list talk@webdna.us To >> unsubscribe, E-mail to: talk-leave@webdna.us >> archives: >> http://www.webdna.us/page.dna?numero=3D55 >> Bug Reporting: >> support@webdna.us >=20 > --------------------------------------------------------- This > message is sent to you because you are subscribed to the > mailing list talk@webdna.us To > unsubscribe, E-mail to: talk-leave@webdna.us > archives: > http://www.webdna.us/page.dna?numero=3D55 > Bug Reporting: > support@webdna.us >=20 > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list talk@webdna.us To unsubscribe, E-mail to: > talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
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...
Related Readings:
WebCat2 beta 11 - new prefs ... (1997)
The IBC root beer has arrived! (1997)
PCS Frames (1997)
How do I access a shopping cart once it had been moved into (2000)
Cookies and domains (2006)
Triggers In Sandboxes (2006)
Public beta 2 for WebCatalog 4.0 is now available. (2000)
WebDNA license logging (2003)
New [math] variable not working... (2001)
Formvariable won't update (1999)
SiteGuard Admin Feature ? (1997)
Runtime version ... (2003)
Return records from another (1997)
RE: Formulas.db + Users.db (1997)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
[isfile] ? (1997)
attachment (2000)
Ampersand (1997)
CC Processing (2001)
passing user info on each page (2000)