13 dec. 2017 kl. 15:25 skrev Lawrence Banahan <banahan.l@gmail.com>:Not =sure how to set this up...So isn't it in apache that I =should setup a Timeout or KeepAlive On or so one?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...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?---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us2017-12-13= 0:59 GMT+01:00 Brian Harrington <autoglasswny@gmail.com>: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 X2TB 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 core 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! LOLGlad you have it fixed... now we can =all rest! LOLOn Tue, =Dec 12, 2017 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 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 <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/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] 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 "test6746@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
<autoglasswny@gmail.com [6]> 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
<ken@webdnasolutions.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. 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@webdna.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: support@webdna.us [5]
--------------------------------------------------------- mailing list talk@webdna.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]
--------------------------------------------------------- This Links:
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
------
[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 tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna? numero=3D55 Bug Reporting: support@webdna.us
13 dec. 2017 kl. 15:25 skrev Lawrence Banahan <banahan.l@gmail.com>:Not =sure how to set this up...So isn't it in apache that I =should setup a Timeout or KeepAlive On or so one?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...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?---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us2017-12-13= 0:59 GMT+01:00 Brian Harrington <autoglasswny@gmail.com>: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 X2TB 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 core 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! LOLGlad you have it fixed... now we can =all rest! LOLOn Tue, =Dec 12, 2017 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 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 <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/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] 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 "test6746@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
<autoglasswny@gmail.com [6]> 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
<ken@webdnasolutions.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. 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@webdna.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: support@webdna.us [5]
--------------------------------------------------------- mailing list talk@webdna.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]
--------------------------------------------------------- This Links:
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
------
[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 tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna? numero=3D55 Bug Reporting: support@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...