Re: [WebDNA] Re: WebDNA7 site randomly dropping tags

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107634
interpreted = N
texte = OK, maybe you are running several copies of WebDNA and they all try to = access the same db, with conflicts. try to add this in your config: DefaultMaxClassProcessCount 1 This states that only one engine can run per web server instance.=20 Without this, you could have corruption to db files, since they are = stored within memory of the FastDNA engine. WebDNA spawns its own threads, and maintains the db within memory. If = you have more than one process of FastDNA accessing the same DB files, = they will collide, since they don't share the db in the same memory. This could explain what you are seeing now. - chris On Nov 2, 2011, at 16:48, aaronmichaelmusic@gmail.com wrote: > wow, I just ran this test again with another variation. When I = refresh the found items page, I am seeing the results bounce between 3 = different sets of records now. > Its like multiple instances of the db are being cached and the search = doesn't know which one to get, so it picks one at random. =20 >=20 > On Nov 2, 2011, at 2:24 PM, christophe.billiottet@webdna.us wrote: >=20 >> Just setup a small test: this adds 10,000 records to a small database = and immediately read them in the same file: it is instantaneous on my = WebDNA 7 test server. >>=20 >> >>=20 >> - chris >>=20 >> On Nov 2, 2011, at 13:38, aaronmichaelmusic@gmail.com wrote: >>=20 >>> After spending a lot of time with apache configurations, I'm = convinced it is WebDNA and not my configuration. >>>=20 >>> I am down to just one site running now with a clean configuration. = I still get the 'bouncing' database behavior between the actual and = previously cached versions throughout refreshes. >>>=20 >>> To illustrate whats going on=85. >>>=20 >>> Say I have a screen listing database records and I have a GUI to add = new ones, and I quickly add 3 new ones >>>=20 >>> records >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> old1 >>> old2 >>> old3 >>> new1 >>> new2 >>> new3 >>>=20 >>>=20 >>> after a couple refreshes, I get this >>>=20 >>> records >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> old1 >>> old2 >>> old3 >>>=20 >>>=20 >>> and even more peculiar, I might get this >>>=20 >>> records >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> old1 >>> old2 >>> old3 >>> new2 >>>=20 >>>=20 >>> I've been able to reproduce this behavior over and over again and = with deleting or modifying records as well. >>>=20 >>> If I leave it alone for a few minutes and come back, it seems like = it corrected itself and displays the correct records consistently. = Also, manually flushing the databases works too. >>>=20 >>> This is really bizarre, and quite frustrating as well. =20 >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> On Nov 1, 2011, at 5:23 PM, christophe.billiottet@webdna.us wrote: >>>=20 >>>>=20 >>>> On Nov 1, 2011, at 19:08, aaronmichaelmusic@gmail.com wrote: >>>>=20 >>>>>>=20 >>>>>> note this configuration is already out of the WebDNA scope: you = should add one WebDNA.fcgi copy per website. >>>>> I'm using one copy per site, but I copied and pasted the entire = directory (with .fcgi file and all) to another. =20 >>>>=20 >>>> and did you setup httpd.conf accordingly? for instance (just an = example) for an OSX server >>>> you would just have to add one line for each new site to the main = httpd.conf block: >>>>=20 >>>> >>>> FastCGIServer = /Library/WebServer/Documents/testosx1.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >>>> Action webdna-fastcgi /WebDNA/WebDNA.fcgi >>>> AddHandler webdna-fastcgi .dna >>>> FastCGIServer = /Library/WebServer/Documents/testosx2.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >>>> >>>>=20 >>>>=20 >>>> And if you had a 3rd one, you'd add: >>>> FastCGIServer = /Library/WebServer/Documents/testosx3.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >>>> and so forth. >>>>=20 >>>> Otherwise, a single copy of WebDNA.fcgi is handling all your = websites... >>>>=20 >>>>=20 >>>> - chris--------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> Bug Reporting: support@webdna.us >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
OK, maybe you are running several copies of WebDNA and they all try to = access the same db, with conflicts. try to add this in your config: DefaultMaxClassProcessCount 1 This states that only one engine can run per web server instance.=20 Without this, you could have corruption to db files, since they are = stored within memory of the FastDNA engine. WebDNA spawns its own threads, and maintains the db within memory. If = you have more than one process of FastDNA accessing the same DB files, = they will collide, since they don't share the db in the same memory. This could explain what you are seeing now. - chris On Nov 2, 2011, at 16:48, aaronmichaelmusic@gmail.com wrote: > wow, I just ran this test again with another variation. When I = refresh the found items page, I am seeing the results bounce between 3 = different sets of records now. > Its like multiple instances of the db are being cached and the search = doesn't know which one to get, so it picks one at random. =20 >=20 > On Nov 2, 2011, at 2:24 PM, christophe.billiottet@webdna.us wrote: >=20 >> Just setup a small test: this adds 10,000 records to a small database = and immediately read them in the same file: it is instantaneous on my = WebDNA 7 test server. >>=20 >> >>=20 >> - chris >>=20 >> On Nov 2, 2011, at 13:38, aaronmichaelmusic@gmail.com wrote: >>=20 >>> After spending a lot of time with apache configurations, I'm = convinced it is WebDNA and not my configuration. >>>=20 >>> I am down to just one site running now with a clean configuration. = I still get the 'bouncing' database behavior between the actual and = previously cached versions throughout refreshes. >>>=20 >>> To illustrate whats going on=85. >>>=20 >>> Say I have a screen listing database records and I have a GUI to add = new ones, and I quickly add 3 new ones >>>=20 >>> records >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> old1 >>> old2 >>> old3 >>> new1 >>> new2 >>> new3 >>>=20 >>>=20 >>> after a couple refreshes, I get this >>>=20 >>> records >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> old1 >>> old2 >>> old3 >>>=20 >>>=20 >>> and even more peculiar, I might get this >>>=20 >>> records >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> old1 >>> old2 >>> old3 >>> new2 >>>=20 >>>=20 >>> I've been able to reproduce this behavior over and over again and = with deleting or modifying records as well. >>>=20 >>> If I leave it alone for a few minutes and come back, it seems like = it corrected itself and displays the correct records consistently. = Also, manually flushing the databases works too. >>>=20 >>> This is really bizarre, and quite frustrating as well. =20 >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> On Nov 1, 2011, at 5:23 PM, christophe.billiottet@webdna.us wrote: >>>=20 >>>>=20 >>>> On Nov 1, 2011, at 19:08, aaronmichaelmusic@gmail.com wrote: >>>>=20 >>>>>>=20 >>>>>> note this configuration is already out of the WebDNA scope: you = should add one WebDNA.fcgi copy per website. >>>>> I'm using one copy per site, but I copied and pasted the entire = directory (with .fcgi file and all) to another. =20 >>>>=20 >>>> and did you setup httpd.conf accordingly? for instance (just an = example) for an OSX server >>>> you would just have to add one line for each new site to the main = httpd.conf block: >>>>=20 >>>> >>>> FastCGIServer = /Library/WebServer/Documents/testosx1.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >>>> Action webdna-fastcgi /WebDNA/WebDNA.fcgi >>>> AddHandler webdna-fastcgi .dna >>>> FastCGIServer = /Library/WebServer/Documents/testosx2.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >>>> >>>>=20 >>>>=20 >>>> And if you had a 3rd one, you'd add: >>>> FastCGIServer = /Library/WebServer/Documents/testosx3.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >>>> and so forth. >>>>=20 >>>> Otherwise, a single copy of WebDNA.fcgi is handling all your = websites... >>>>=20 >>>>=20 >>>> - chris--------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>> Bug Reporting: support@webdna.us >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us christophe.billiottet@webdna.us

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:

Checkboxes (1998) autocommit problem (1998) Error handling for accountNum (1997) Number searching/formats (1998) ODBC problems between webcat and filemaker pro (2001) Merging databases (1997) calculating tax rates, mail order solutions and version 2 (1997) Nesting format tags (1997) WebCatalog 2.0 b 15 mac (1997) Extended [ConvertChars] (1997) WebCat2: multiple currency support (1997) AutoCommit Preference? (1998) [WebDNA] sum in a search (2009) Custom Convertchars Database (2004) Follow-up to listfiles bug report ... (2003) Fun with Dates - finally resolved but.... (1997) WebCat2b12 - New features for 1.6 users ... (1997) WC1.6 to WC2 date formatting (1997) Trigger Validation Text Broken (2003) Our Webcat site launched (1997)