Re: [WebDNA] Error 500 with SUMM=T
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113852
interpreted = N
texte = 1447 --001a114e51903ba27b05603abfc5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 > > ************************************************************* > Christer Olsson PO Box 9160 Phone +46 40 25 85 85 > <+46%2040%2025%2085%2085> > Ljusa Id=C3=A9er AB SE-200 39 Malmo Fax +46 40 25 85 89 > <+46%2040%2025%2085%2089> > > > > 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 >> >> ************************************************************* >> Christer Olsson PO Box 9160 Phone +46 40 25 85 85 >> <+46%2040%2025%2085%2085> >> Ljusa Id=C3=A9er AB SE-200 39 Malmo Fax +46 40 25 85 89 >> <+46%2040%2025%2085%2089> >> >> >> >> 13 dec. 2017 kl. 15:25 skrev Lawrence Banahan : >> >> This morning I wrote a dirty script to summ the result by making a new D= B >> 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 s= o >> 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 0 raid on 4 X2T= B >>> HDD's... >>> >>> trying to speed load times on my heavy dynamic site classifieds.today = that >>> 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 c= ore >>> 3.46! 128GB ram and 1TB SSD and 8TB 0 RAID and same slow results! >>> HUH (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...???!!! >>> The 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 you= r >>>> 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 : >>>>> >>>>> 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 Err= or=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]floor([random >>>>>>> format=3Dfloat]*110000)[/math]@example.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] [numfo= und] >>>>>>> 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 : >>>>>>> >>>>>>> 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] >>>>>>>> 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 o= ne field - >>>>>>>> =E2=80=9C_email=E2=80=9D, then add 15000 records with _email set t= o a value >>>>>>>> like "test6746@example.com [13]=E2=80=9D, where the numeric portio= n 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 >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>> exactly what Ive been saying... you all keep your little code >>>>>>>>> a secret and NO resource on the website, same 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 >>>>>>>>> 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. 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 >>>>>>>>>> >>>>>>>>>> --------------------------------------------------------- >>>>>>>>>> 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/page.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.dna?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?numero=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=3D55 [29] Bug Reporting: >>>>>> support@webdna.us [30] >>>>>> >>>>> >>>>> --------------------------------------------------------- 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.tpl >>>>> [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.u= s > > > --------------------------------------------------------- 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.u= s > --001a114e51903ba27b05603abfc5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I don't see any value for fcgi in the httpd.conf...