Re: [WebDNA] Error 500 with SUMM=T
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113839
interpreted = N
texte = 1434 --Apple-Mail=_504B02D9-0BA7-4DB8-8B75-1158E8A47CC5 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 This code should get what Donovan is asking for: [platform]
[version]
[freememory]
[shell]df -h[/shell]
- Brian Fries > On Dec 12, 2017, at 10:16 AM, Lawrence Banahan
= wrote: >=20 > Donovan what did you meaned with? > "Can you post the results of 'free' and 'df -h' from the commandline?" >=20 > 2017-12-12 19:05 GMT+01:00 >: > Sorry, I probably missed this in all the emails, but did you state = your server info? >=20 > WebDNA Version > Operating System >=20 > Can you post the results of 'free' and 'df -h' from the commandline? >=20 > Donovan >=20 >=20 >=20 > 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... >=20 > 2017-12-12 18:41 GMT+01:00 Brian Fries [31]>: >=20 > 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 >=20 > So, it looks like an available RAM issue, as you said, with my limit > higher than yours due to different system configuration. >=20 > - Brian Fries >=20 > On Dec 12, 2017, at 9:26 AM, Lawrence Banahan > [18]> wrote: >=20 > Thanks for this test Brian, > I tested it with your code and everything works fine. > http://www.tourismethaifr.com/admin/testdb.tpl = [19] >=20 > 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] >=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] >=20 > Maybe somthing to do with RAM... Server... > I have rebooted it! > The db is 3mb, it shouldnt be an issuu... >=20 > It was already running on the same server... >=20 > 2017-12-12 18:01 GMT+01:00 Brian Fries [22]>: >=20 > Here is a test that should determine whether it is a database > content problem: >=20 > [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] >=20 > 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 is > a random integer from zero to 9999, so there will be duplicates. >=20 > 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. >=20 > 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. >=20 > - Brian Fries >=20 > On Dec 12, 2017, at 7:28 AM, Brian Harrington > [6]> wrote: >=20 > 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! >=20 > So we all need to take notes...? >=20 > On Tue, Dec 12, 2017 at 12:04 PM, Kenneth Grome > [7]> wrote: >=20 > I see two problems with > > > > complex sort example: > > &email*S*sort=3D1&emailsdir=3Das > > (should be &emailsort=3D1&emailsdir=3Das) >=20 > I already corrected this typo in a later post ... :) >=20 > > simple sort example: > > &*as*emailsort=3D1 > > (should be &emailsort=3D1) >=20 > No it should not! >=20 > 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. >=20 > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com [1] > Web Database Systems and Linux Server Administration >=20 > --------------------------------------------------------- > 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] >=20 > --------------------------------------------------------- > 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] >=20 > --------------------------------------------------------- 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] >=20 > --------------------------------------------------------- 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] >=20 > --------------------------------------------------------- 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] >=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 > 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 >=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 --Apple-Mail=_504B02D9-0BA7-4DB8-8B75-1158E8A47CC5 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 This code should get what Donovan = is asking for:
[platform]<br>
[version]<br>
[freememory]<br>
<pre>[shell]df -h[/shell]</pre>
- Brian Fries
= --------------------------------------------------------- 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 --Apple-Mail=_504B02D9-0BA7-4DB8-8B75-1158E8A47CC5-- .
Associated Messages, from the most recent to the oldest:
1434 --Apple-Mail=_504B02D9-0BA7-4DB8-8B75-1158E8A47CC5 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 This code should get what Donovan is asking for: [platform]
[version]
[freememory]
[shell]df -h[/shell]
- Brian Fries > On Dec 12, 2017, at 10:16 AM, Lawrence Banahan = wrote: >=20 > Donovan what did you meaned with? > "Can you post the results of 'free' and 'df -h' from the commandline?" >=20 > 2017-12-12 19:05 GMT+01:00 >: > Sorry, I probably missed this in all the emails, but did you state = your server info? >=20 > WebDNA Version > Operating System >=20 > Can you post the results of 'free' and 'df -h' from the commandline? >=20 > Donovan >=20 >=20 >=20 > 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... >=20 > 2017-12-12 18:41 GMT+01:00 Brian Fries [31]>: >=20 > 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 >=20 > So, it looks like an available RAM issue, as you said, with my limit > higher than yours due to different system configuration. >=20 > - Brian Fries >=20 > On Dec 12, 2017, at 9:26 AM, Lawrence Banahan > [18]> wrote: >=20 > Thanks for this test Brian, > I tested it with your code and everything works fine. > http://www.tourismethaifr.com/admin/testdb.tpl = [19] >=20 > 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] >=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] >=20 > Maybe somthing to do with RAM... Server... > I have rebooted it! > The db is 3mb, it shouldnt be an issuu... >=20 > It was already running on the same server... >=20 > 2017-12-12 18:01 GMT+01:00 Brian Fries [22]>: >=20 > Here is a test that should determine whether it is a database > content problem: >=20 > [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] >=20 > 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 is > a random integer from zero to 9999, so there will be duplicates. >=20 > 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. >=20 > 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. >=20 > - Brian Fries >=20 > On Dec 12, 2017, at 7:28 AM, Brian Harrington > [6]> wrote: >=20 > 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! >=20 > So we all need to take notes...? >=20 > On Tue, Dec 12, 2017 at 12:04 PM, Kenneth Grome > [7]> wrote: >=20 > I see two problems with > > > > complex sort example: > > &email*S*sort=3D1&emailsdir=3Das > > (should be &emailsort=3D1&emailsdir=3Das) >=20 > I already corrected this typo in a later post ... :) >=20 > > simple sort example: > > &*as*emailsort=3D1 > > (should be &emailsort=3D1) >=20 > No it should not! >=20 > 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. >=20 > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com [1] > Web Database Systems and Linux Server Administration >=20 > --------------------------------------------------------- > 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] >=20 > --------------------------------------------------------- > 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] >=20 > --------------------------------------------------------- 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] >=20 > --------------------------------------------------------- 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] >=20 > --------------------------------------------------------- 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] >=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 > 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 >=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 --Apple-Mail=_504B02D9-0BA7-4DB8-8B75-1158E8A47CC5 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 This code should get what Donovan = is asking for:
- Brian Fries
= --------------------------------------------------------- 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 --Apple-Mail=_504B02D9-0BA7-4DB8-8B75-1158E8A47CC5-- .
Brian Fries
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:
WebCatalog can't find database (1997)
No messages for a week? (2000)
File dates in WebCatalog .tmpl/.inc (1997)
Bug Report, maybe (1997)
headers (2004)
Upgrade to WebCat2 from Commerce Lite (1997)
creator code (1997)
Semi-OT SSL IE problem (2005)
Frames and WebCat (1997)
[interpret] inside the db field? (1997)
textA (1998)
Summing fields (1997)
Associative lookup style? (1997)
Virtual Postcards (1998)
[WebDNA] Listfields in an input environment (2018)
[SHOWIF AND/OR] (1997)
This message couldn't reach the list! (1998)
Processing all html files through WebCat or Typhoon (1998)
PSC recommends what date format yr 2000??? (1997)
all records returned. (1997)