[WebDNA] Processor Maxing out

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104909
interpreted = N
texte = All,=20 Okay, I was working on a file that would create a CSV file and attach it = to an email so the customer could import it into WorldShip from USP to = handle shipping. I found some code on the archive (Thanks for that. I = was making it way too hard) and it works. Since then, the processor is = pegged. I've seen it do this once before and Donovan just had me restart = the triggers and it stopped. I've read through the talk archive on = processor maxing out and here's what I've tried: checked for large files, made sure all the logging is turned off, = stopped and restarted Webcatalog using webcatalogctl, restarted the = machine, stopped and restarted email and triggers in sandbox admin, = restarted emailer from CGI RestartEmailer.tpl, made sure the safe = database write is on, looked at the orders.db and LineItems.db (the two = databases I am currently working in/on) for bad lines and still the = processor is pegged. The sites are working, but something is wrong and I'm not sure where to = start looking. I'm just starting to work with nested searches and = founditems. Maybe someone with more experience can see something I'm = missing. I am doing a replace in the LineItems.db to mark the exported = records. Should I be doing a commit before I do that replace? I've = edited some of the extraneous fields to shorten the code: = [text]emailserial=3D[random][random][random][random][random][random][/text= ] [text]headline=3DWorldShip File Contents[/text] [text]line_ending=3D%0D%0A[/text] [!]=3D=3D=3D=3D=3D=3D=3D Write results of new files to be exported to = var 'body' =3D=3D=3D=3D=3D[/!] [text]body=3DShipFromComp,,[!] [/!][ListFields db=3DOrders.db][FieldName],[/ListFields][!] [/!]Ref1,ref2,BillOption[UnURL][line_ending][/UnURL][!] [/!][founditems][search = db=3DLineItems.db&eqcartdata=3D[eqcartdatarq]&rank=3Doff][/search][!] [/!][HideIf [Status]!Approved][!] [/!][HideIf [Action]!Sale][!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!] [/!][founditems][!] [/!][HideIf [exported]=3DYes][!] [/!]Sterzing Food Company,1819 Charles = St.,Burlington,IA,52601,[country],CP,5,[!] = [/!][cart],[Date],[Time],[Email],[PayMethod],************[getchars = start=3D1&end=3D4&from=3Dend][AccountNum][/getchars],[!] [/!]More fields here,[!] = [/!][taxExempt],[resellerNumber],[transactionIndex],[relatedTransaction],[= !] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][= !] [/!]Cart:[getchars = start=3D1&end=3D5&from=3Dend][cart][/getchars] [founditems][!] [/!](#[sku]-[textA])[!] [/!][/founditems][!] [/!][/search],,SHP[UnURL][line_ending][/UnURL][!] [/!][/HideIf][!] [/!][/founditems][!] [/!][/search][!] [/!][/HideIf][!] [/!][/HideIf][!] [/!][/founditems][!] [/!][/text] [!]=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DWrite contents of 'body' to a = file called 'WorldShip.txt'=3D=3D=3D=3D=3D=3D=3D=3D=3D[/!] [WriteFile ^/WorldShip.txt][body][/WriteFile] [!]=3D=3D=3D=3D=3D=3D Waits for WorldShip.txt file and reports error if = it doesn't get written =3D=3D=3D=3D=3D=3D=3D[/!] [text]succeeded=3DF[/text] [WaitForFile file=3D^/WorldShip.txt] File was found!

[text]succeeded=3DT[/text] [/WaitForFile] [ShowIf [succeeded]=3DT] The WorldShip.txt file was written so I'll move = along!
[/ShowIf] [ShowIf [succeeded]=3DF] WARNING! File was not found! You may have to = try again.
[/ShowIf] [!]=3D=3D=3D=3D=3D=3D=3D Write listing of contents of WorldShip.txt to = var 'message' for email body =3D=3D=3D=3D=3D[/!] [text]message=3DThe daily list has been processed. File is attached. Here is a report of items in today's manifest: [headline] [founditems][!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!] [/!][founditems][HideIf [exported]=3DYes][HideIf = [Status]!Approved][HideIf [Action]!Sale][!] [/!][getchars start=3D1&end=3D5&from=3Dend][cart][/getchars] - = [ShipToName] [ShipToAddress1] [ShipToCity] [ShipToState] [ShipToZip] = [ShipToEmail] [Header1][!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!] [/!][founditems](#[sku]-[textA]-[!] [/!][search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff][!] [/!][founditems][title] - [weight]-lbs)[/founditems][/search][!] [/!][/founditems][/search][Replace = db=3DLineItems.db&eqCARTdata=3D[cart]]exported=3DYes[/Replace] [/HideIf][/HideIf][/HideIf][/founditems][/search][!] [/!][/founditems][!] [ListFields db=3DLineItems.db][FieldName],[/ListFields] [search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff] [founditems][weight][/founditems][/search] [/!] Your Friendly eCommerce Server[/text] [sendmail = To=3Dme@domain.com,minime@domain.com&From=3Dyou@domain.com&Subject=3DWorld= Ship [date %x] processed at [time %I:%M = %p]&Content-Type=3Dmultipart/mixed; boundary=3D"[emailserial]"&MIME-version=3D1.0]] --[emailserial] Content-type: text/plain; charset=3D"US-ASCII" Content-transfer-encoding: 7bit [convertchars][message][/convertchars] --[emailserial] Content-Type: text/plain; name=3D"WorldShip.txt" Content-Disposition: attachment Content-Transfer-Encoding: base64 [encrypt method=3Dbase64&file=3D^/WorldShip.txt&emailformat=3DT][/encrypt]= --[emailserial]-- [/sendmail] The file was sent.

OS X.4.11 Server Commerce Edition 6.0a Site is a SiteBuilder site running with a sandbox WebDNA server is running as root Thanks in advance Tony Miller Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  2. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  3. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  4. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  5. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  6. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  7. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  8. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  9. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  10. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  11. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  12. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  13. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  14. Re: [WebDNA] Processor Maxing out (Tennis De Jong 2010)
  15. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  16. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  17. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  18. Re: [WebDNA] Processor Maxing out (Tennis De Jong 2010)
  19. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  20. Re: [WebDNA] Processor Maxing out (Paul Willis 2010)
  21. Re: [WebDNA] Processor Maxing out (Paul Willis 2010)
  22. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  23. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  24. Re: [WebDNA] Processor Maxing out (Paul Willis 2010)
  25. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  26. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  27. Re: [WebDNA] Processor Maxing out (Paul Willis 2010)
  28. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  29. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  30. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  31. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  32. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  33. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  34. Re: [WebDNA] Processor Maxing out (Dan Strong 2010)
  35. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  36. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  37. Re: [WebDNA] Processor Maxing out (Tony Miller 2010)
  38. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  39. Re: [WebDNA] Processor Maxing out (Donovan Brooke 2010)
  40. [WebDNA] Processor Maxing out (Tony Miller 2010)
All,=20 Okay, I was working on a file that would create a CSV file and attach it = to an email so the customer could import it into WorldShip from USP to = handle shipping. I found some code on the archive (Thanks for that. I = was making it way too hard) and it works. Since then, the processor is = pegged. I've seen it do this once before and Donovan just had me restart = the triggers and it stopped. I've read through the talk archive on = processor maxing out and here's what I've tried: checked for large files, made sure all the logging is turned off, = stopped and restarted Webcatalog using webcatalogctl, restarted the = machine, stopped and restarted email and triggers in sandbox admin, = restarted emailer from CGI RestartEmailer.tpl, made sure the safe = database write is on, looked at the orders.db and LineItems.db (the two = databases I am currently working in/on) for bad lines and still the = processor is pegged. The sites are working, but something is wrong and I'm not sure where to = start looking. I'm just starting to work with nested searches and = founditems. Maybe someone with more experience can see something I'm = missing. I am doing a replace in the LineItems.db to mark the exported = records. Should I be doing a commit before I do that replace? I've = edited some of the extraneous fields to shorten the code: = [text]emailserial=3D[random][random][random][random][random][random][/text= ] [text]headline=3DWorldShip File Contents[/text] [text]line_ending=3D%0D%0A[/text] [!]=3D=3D=3D=3D=3D=3D=3D Write results of new files to be exported to = var 'body' =3D=3D=3D=3D=3D[/!] [text]body=3DShipFromComp,,[!] [/!][ListFields db=3DOrders.db][FieldName],[/ListFields][!] [/!]Ref1,ref2,BillOption[unurl][line_ending][/UnURL][!] [/!][founditems][search = db=3DLineItems.db&eqcartdata=3D[eqcartdatarq]&rank=3Doff][/search][!] [/!][HideIf [Status]!Approved][!] [/!][HideIf [Action]!Sale][!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!] [/!][founditems][!] [/!][HideIf [exported]=3DYes][!] [/!]Sterzing Food Company,1819 Charles = St.,Burlington,IA,52601,[country],CP,5,[!] = [/!][cart],[date],[time],[Email],[PayMethod],************[getchars = start=3D1&end=3D4&from=3Dend][AccountNum][/getchars],[!] [/!]More fields here,[!] = [/!][taxExempt],[resellerNumber],[transactionIndex],[relatedTransaction],[= !] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][= !] [/!]Cart:[getchars = start=3D1&end=3D5&from=3Dend][cart][/getchars] [founditems][!] [/!](#[sku]-[textA])[!] [/!][/founditems][!] [/!][/search],,SHP[unurl][line_ending][/UnURL][!] [/!][/HideIf][!] [/!][/founditems][!] [/!][/search][!] [/!][/HideIf][!] [/!][/HideIf][!] [/!][/founditems][!] [/!][/text] [!]=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DWrite contents of 'body' to a = file called 'WorldShip.txt'=3D=3D=3D=3D=3D=3D=3D=3D=3D[/!] [WriteFile ^/WorldShip.txt][body][/WriteFile] [!]=3D=3D=3D=3D=3D=3D Waits for WorldShip.txt file and reports error if = it doesn't get written =3D=3D=3D=3D=3D=3D=3D[/!] [text]succeeded=3DF[/text] [WaitForFile file=3D^/WorldShip.txt] File was found!

[text]succeeded=3DT[/text] [/WaitForFile] [ShowIf [succeeded]=3DT] The WorldShip.txt file was written so I'll move = along!
[/ShowIf] [ShowIf [succeeded]=3DF] WARNING! File was not found! You may have to = try again.
[/ShowIf] [!]=3D=3D=3D=3D=3D=3D=3D Write listing of contents of WorldShip.txt to = var 'message' for email body =3D=3D=3D=3D=3D[/!] [text]message=3DThe daily list has been processed. File is attached. Here is a report of items in today's manifest: [headline] [founditems][!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!] [/!][founditems][HideIf [exported]=3DYes][HideIf = [Status]!Approved][HideIf [Action]!Sale][!] [/!][getchars start=3D1&end=3D5&from=3Dend][cart][/getchars] - = [ShipToName] [ShipToAddress1] [ShipToCity] [ShipToState] [ShipToZip] = [ShipToEmail] [Header1][!] [/!][search db=3DLineItems.db&eqcartdata=3D[cart]&rank=3Doff][!] [/!][founditems](#[sku]-[textA]-[!] [/!][search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff][!] [/!][founditems][title] - [weight]-lbs)[/founditems][/search][!] [/!][/founditems][/search][Replace = db=3DLineItems.db&eqCARTdata=3D[cart]]exported=3DYes[/Replace] [/HideIf][/HideIf][/HideIf][/founditems][/search][!] [/!][/founditems][!] [ListFields db=3DLineItems.db][FieldName],[/ListFields] [search db=3D/admin/products.db&eqskudata=3D[sku]&rank=3Doff] [founditems][weight][/founditems][/search] [/!] Your Friendly eCommerce Server[/text] [sendmail = To=3Dme@domain.com,minime@domain.com&From=3Dyou@domain.com&Subject=3DWorld= Ship [date %x] processed at [time %I:%M = %p]&Content-Type=3Dmultipart/mixed; boundary=3D"[emailserial]"&MIME-version=3D1.0]] --[emailserial] Content-type: text/plain; charset=3D"US-ASCII" Content-transfer-encoding: 7bit [convertchars][message][/convertchars] --[emailserial] Content-Type: text/plain; name=3D"WorldShip.txt" Content-Disposition: attachment Content-Transfer-Encoding: base64 [encrypt method=3Dbase64&file=3D^/WorldShip.txt&emailformat=3DT][/encrypt]= --[emailserial]-- [/sendmail] The file was sent.

OS X.4.11 Server Commerce Edition 6.0a Site is a SiteBuilder site running with a sandbox WebDNA server is running as root Thanks in advance Tony Miller Tony Miller

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:

A multi-processor savvy WebCatalog? (1997) Great product and great job ! (1997) Hard Questions ? (1997) A multi-processor savvy WebCatalog? (1997) ANNC:DUH!! The address would be helpful! (2000) MasterCounter Weirdness -Resolved! (1997) Looking for WebSTAR bomb at startup (2000) WebDNA Speed Test (2008) Urgent help needed (2003) WC2.0 Memory Requirements (1997) WebCat2 - [format thousands] (1997) ACGI processing for .html (1997) Limiting user access to .tmpl files (1997) Re:WebCatalog/WebMerchant III (1998) Starting WebCatalog on Linux (2000) [WebDNA] [BULK] WebDNA 7 - Showing every other far DB - Fault! (2011) problems with 2 tags shakur (1997) [date format] w/in sendmail (1997) WebCat Hosting (1998) advise!! (2001)