Re: [WebDNA] Spawn bombing out with ".db-oRiGiNaL-"
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113613
interpreted = N
texte = 1208 Is the hard drive full or damaged/corrupted? Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 06/12/2017 12:57 PM, Tom Duke wrote: > Chris, > > Hi - thanks. The database is quite small, but it's dealing with > about six or seven replace/appends a second inside a [listfiles] > context. > > Just scratching my head here. It's been working without issue for > a good while. I'll keep looking thanks. > > - Tom > > > > > > ============================================== > Digital Revolutionaries > 1st Floor, Castleriver House > 14-15 Parliament Street > Temple Bar,Dublin 2 > Ireland > ---------------------------------------------- > [t]: + 353 1 4403907 > [e]:
> > [w]: > ============================================== > > On 12 June 2017 at 18:42, > wrote: > > Hi Tom, auto-commit is global, but you can disable auto-commit > and then use [commitdatabase] individually > If your database is large and you get a lot of [append] in > close succession, it should not trigger any error but there > will be a lot of I/O and will keep WebDNA very busy. > > - chris > > > > > > On Jun 12, 2017, at 20:29, Tom Duke > wrote: > > > > Hi, > > > > Just following up. > > > > I have auto-commit and safe-write enabled on the server. If > the database updates are happening very quickly is it possible > that WebDNA could be trying to write to the database during a > safe write which then triggers the error? > > > > If so can auto-commit be disabled for a single database > and/or replace operation - or can it only be set globally? > > > > - Tom > > > > > > > > > > > > ============================================== > > Digital Revolutionaries > > 1st Floor, Castleriver House > > 14-15 Parliament Street > > Temple Bar,Dublin 2 > > Ireland > > ---------------------------------------------- > > [t]: + 353 1 4403907 > > [e]: > > > [w]: > > > ============================================== > > > > On 12 June 2017 at 18:09, Tom Duke > wrote: > > Hi all, > > > > I have some code running in a [spawn] that has been rock > solid for a long time. > > > > Just recently it has started to occassionally bomb out. The > only error I see is a database that is incremented in the > spawn becomes unavailable as it has been renamed with the > suffixes below: > > > > the_database_name.db-tmp > > the_database_name.db-oRiGiNaL- > > > > I have checked the archives and see that this renaming > happens during a safe write. But clearly the db is not renamed > again to the proper name. > > > > I can't understand why this has started happening though. > There is plenty of RAM available on the server. > > > > Anyone have any pointers where I can look? > > > > - Tom > > > > > > --------------------------------------------------------- > 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=55 > 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=55 > > 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=55 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=55 Bug Reporting: support@webdna.us .
Associated Messages, from the most recent to the oldest:
1208 Is the hard drive full or damaged/corrupted? Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 06/12/2017 12:57 PM, Tom Duke wrote: > Chris, > > Hi - thanks. The database is quite small, but it's dealing with > about six or seven replace/appends a second inside a [listfiles] > context. > > Just scratching my head here. It's been working without issue for > a good while. I'll keep looking thanks. > > - Tom > > > > > > ============================================== > Digital Revolutionaries > 1st Floor, Castleriver House > 14-15 Parliament Street > Temple Bar,Dublin 2 > Ireland > ---------------------------------------------- > [t]: + 353 1 4403907 > [e]: > > [w]: > ============================================== > > On 12 June 2017 at 18:42, > wrote: > > Hi Tom, auto-commit is global, but you can disable auto-commit > and then use [commitdatabase] individually > If your database is large and you get a lot of [append] in > close succession, it should not trigger any error but there > will be a lot of I/O and will keep WebDNA very busy. > > - chris > > > > > > On Jun 12, 2017, at 20:29, Tom Duke > wrote: > > > > Hi, > > > > Just following up. > > > > I have auto-commit and safe-write enabled on the server. If > the database updates are happening very quickly is it possible > that WebDNA could be trying to write to the database during a > safe write which then triggers the error? > > > > If so can auto-commit be disabled for a single database > and/or replace operation - or can it only be set globally? > > > > - Tom > > > > > > > > > > > > ============================================== > > Digital Revolutionaries > > 1st Floor, Castleriver House > > 14-15 Parliament Street > > Temple Bar,Dublin 2 > > Ireland > > ---------------------------------------------- > > [t]: + 353 1 4403907 > > [e]: > > > [w]: > > > ============================================== > > > > On 12 June 2017 at 18:09, Tom Duke > wrote: > > Hi all, > > > > I have some code running in a [spawn] that has been rock > solid for a long time. > > > > Just recently it has started to occassionally bomb out. The > only error I see is a database that is incremented in the > spawn becomes unavailable as it has been renamed with the > suffixes below: > > > > the_database_name.db-tmp > > the_database_name.db-oRiGiNaL- > > > > I have checked the archives and see that this renaming > happens during a safe write. But clearly the db is not renamed > again to the proper name. > > > > I can't understand why this has started happening though. > There is plenty of RAM available on the server. > > > > Anyone have any pointers where I can look? > > > > - Tom > > > > > > --------------------------------------------------------- > 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=55 > 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=55 > > 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=55 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=55 Bug Reporting: support@webdna.us .
Kenneth Grome
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:
Micro-managing External Links (2006)
WebDNA & HTML Problems (2003)
Major Security Hole (1998)
Fun with dates (1997)
Quickie question on the email templates (1997)
Re[3]: Problem with new formvariables (2000)
emailer settings and control questions (1997)
New Installation (1998)
Country & Ship-to address & other fields ? (1997)
Include a big block of text (1997)
QuitFeedback & DBNotOpened errors (1997)
Heads up: WebCatalog 4 drops MacTCP, 68K (2000)
rotating thumbnails (1997)
Dark Horse Comics success story (1997)
Authenticate (2000)
[WebDNA] WebDNA licenses discount from 12/23 to 12/31 (2011)
[WebDNA] How do we tell what's misconfigured? Or which WebDNA 7 version to use? (2011)
HTML encoding in URLs (1997)
version history page for webcat on the SM site? (2000)
Cart Database (1999)