Re: [WebDNA] Error 500 with SUMM=T
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113838
interpreted = N
texte = 1433 --94eb2c0930621f5ca9056028a6ed Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Donovan what did you meaned with? "Can you post the results of 'free' and 'df -h' from the commandline?" 2017-12-12 19:05 GMT+01:00
: > 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 : >> >> 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]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] [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 : >>>> >>>> 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 one = field - >>>>> =E2=80=9C_email=E2=80=9D, then add 15000 records with _email set to a= value >>>>> like "test6746@example.com [13]=E2=80=9D, where the numeric portion i= s >>>>> 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 > --94eb2c0930621f5ca9056028a6ed Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Donovan what did you meaned with?
"Can you post the results of 'free' and 'df -h' from t= he commandline?"
--------------------------------------------------------- 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 --94eb2c0930621f5ca9056028a6ed-- .
Associated Messages, from the most recent to the oldest:
1433 --94eb2c0930621f5ca9056028a6ed Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Donovan what did you meaned with? "Can you post the results of 'free' and 'df -h' from the commandline?" 2017-12-12 19:05 GMT+01:00 : > 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 : >> >> 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]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] [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 : >>>> >>>> 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 one = field - >>>>> =E2=80=9C_email=E2=80=9D, then add 15000 records with _email set to a= value >>>>> like "test6746@example.com [13]=E2=80=9D, where the numeric portion i= s >>>>> 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 > --94eb2c0930621f5ca9056028a6ed Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Donovan what did you meaned with?
"Can you post the results of 'free' and 'df -h' from t= he commandline?"
--------------------------------------------------------- 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 --94eb2c0930621f5ca9056028a6ed-- .
Lawrence Banahan
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:
[OT] MS IE from H3LL (2008)
WebCat2 - many [carts] on one template page? (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
adding options to form (2004)
price totals (2003)
removing programming logic white space (2003)
Lookup & Form Variables (2000)
Is there a max number of fields? (1998)
Credit Card Number checking (1997)
SQL Madness (2005)
Date Search Problem (1999)
Erotic Sites (1997)
FEW QUESTIONS (1997)
AD Error Msg (1997)
Secure server question (1997)
Many are called but only 6 make it to founditems. (2001)
Big Databases (1997)
installing webcatalog problem. HELP! (1998)
New to WebCat, Help. (1998)
emailer setup (1997)