Re: New Weird Behavior (bug report)
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36050
interpreted = N
texte = Again, thanks for the reply. I did as you asked and created a VERY basic query on the database in question.But first, before testing, I deleted all files called products.db on the server, cleared the cache, and rebooted the server.Once the server came back up, I uploaded the good database, and ran the following script on a page with nothing else:[search db=products.db&geSKUdata=0] [foundItems] [SKU] [Title]
[/foundItems] [/search]It brought back the correct results, however, the server crashed. When it came back up, it had corrupted the database in the same manner.Any thoughts what could be in that specific file which could cause the server to crash? Keep in mind that this site was designed in WebCatalog 3 StoreBuilder and uses two files products.hdr and products.db as the database table.> From: John Peacock
> Reply-To: > Date: Thu, 10 Aug 2000 16:09:54 > To: > Subject: Re: New Weird Behavior (bug report) > > I have read the thread. If the file is corrupted the first time it is > hit, and only that file has that problem, then there is either something > wrong with that file or there is something wrong with the template > calling that file. If there is something wrong with the template and, > for example, you have a spider walking your site, you will not have time > to copy the file before WebCat reloads the corrupted version. > > If you reboot the computer, make sure that nothing can call that file, > delete that file and replace with a backup copy, then hit a template, > you will be able to confirm or deny that it is a bug in WebCat. There > must be no copy of that corrupted database in RAM when you copy the > backup over, because WebCat will simply overwrite the new copy. > > I would also suggest making a simple template which just does a trivial > search and returns some records. You should also be doing this on a > non-production server, unconnected from the public network. You should > also make sure there are no triggers active. > > HTH > > John Peacock > > TC wrote: >> >> Thanks for your reply, but I think the problem is much more involved than >> that. Whenever the products.db file is uploaded to the server it is >> corrupted the first time it is hit. >> >> Since we upgraded to 4.2b5 the server crashes everything the file is called. >> >> We had to that the site down to keep from crashing the server since we have >> other clients on the server. >> >> If you need to the review the problem as discussed through the archive >> please read this thread as well as the Corrupt Database Problem... thread. >> >> Thanks. >> >>> From: John Peacock >>> Reply-To: >>> Date: Thu, 10 Aug 2000 15:42:17 >>> To: >>> Subject: Re: New Weird Behavior (bug report) >>> >>> If you have tried [flushdatabase] and you still see databases, you need >>> to reboot your server and disconnect it from the network. While it is >>> disconnected (so no one can hit your templates), do the flush/copy and >>> see if that does it. I have had one instance where I couldn't flush >>> all the databases and that is what it took to fix it. >>> >>> John Peacock >>> >>> TC wrote: >>>> >>>> This is regarding the database corruption problem from earlier today. >>>> >>>> We installed 2beta5 on the server. It didn't seem to help. Do we need to >>>> do a clean install of WebCatalog? >>>> >>>> Flushing databases doesn't seem to work either by the way. If you flush >>>> the >>>> databases then show databases, there are several databases still open. >>>> Uploading the database seems to crash the server. >>>> >>>> To remind you of the problem. The server seems to corrupt the database as >>>> soon as we upload it to the server. >>>> >>>>> From: Paul Uttermohlen >>>>> Reply-To: >>>>> Date: Thu, 10 Aug 2000 12:07:35 >>>>> To: >>>>> Subject: Re: New Weird Behavior (bug report) >>>>> >>>>>>> Though this has already been submitted directly to Sam at SM Tech >>>>>>> Support I thought others here might want to hear about this. >>>>>>> >>>>>>> Using 4.02b5 at about 700,000 hits WebStar/WebCat (all html goes >>>>>>> throught WebCat) started serving pages up randomly for one page in a >>>>>>> site. >>>>>>> >>>>>>> The site was a real estate site. The link was to a page that >>>>>>> explained more about the broker. The result was that the URL was >>>>>>> correct in the browser location window but different pages from >>>>>>> different sites on the server were served up randomly in the browser. >>>>>>> I didn't think it was possible. I thought someone was playing a joke >>>>>>> on me. >>>>>> ......... >>>>>> >>>>>>> Any one else run into these problems? >>>>>>> >>>>>>> Thanks, Paul >>>>>> >>>>>> >>>>>> Actually I am glad to hear that I am not crazy. While working on a store >>>>>> the other day I was treated to a conversation out of my WebCat chat room. >>>>>> We >>>>>> do not use Vhost, and we were not seeing those type of numbers at the >>>>>> time. >>>>>> Reloading my page made it go away, but since I couldn't repeat it I >>>>>> couldn't >>>>>> pursue it. >>>>>> >>>>>> We are still seeing the crash on every attempt to restart webstar. That >>>>>> was introduced in 4.x for us, and then removed (it seemed) for b4 and now >>>>>> back for B5. Are you seeing any crashing Paul while trying to restart >>>>>> WebStar (4.2)? >>>>>> >>>>>> Alex >>>>>> >>>>> >>>>> No crashing here Alex (neither random or on restart - WebStar 4.2). >>>>> And we also have not yet seen a repeat of the random page serving, >>>>> but it was real. We had several people here witness it, including the >>>>> client who was not impressed or pleased to see his competitors pages >>>>> and many pages that are not in any way related pop up in his sites >>>>> frame set. >>>>> >>>>> Paul >>>>> >>>>> _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ >>>>> _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ >>>>> _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ >>>>> _/_/_/ Business - _\_\_\_\_\_\_ >>>>> _/_/_/ Real Estate - _\_\_\_\_ >>>>> _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ >>>>> >>>>> ############################################################# >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> To switch to the DIGEST mode, E-mail to >>>>> >>>>> To switch to the INDEX mode, E-mail to >>>>> >>>>> Send administrative queries to >>>>> >>>>> >>>>> >>>> >>>> ############################################################# >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> To switch to the INDEX mode, E-mail to >>>> >>>> Send administrative queries to >>>> >>> >>> ############################################################# >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> To switch to the INDEX mode, E-mail to >>> >>> Send administrative queries to >>> >>> >>> >> >> ############################################################# >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> To switch to the INDEX mode, E-mail to >> >> Send administrative queries to > > ############################################################# > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > To switch to the INDEX mode, E-mail to > > Send administrative queries to > > ############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to
Associated Messages, from the most recent to the oldest:
Again, thanks for the reply. I did as you asked and created a VERY basic query on the database in question.But first, before testing, I deleted all files called products.db on the server, cleared the cache, and rebooted the server.Once the server came back up, I uploaded the good database, and ran the following script on a page with nothing else:[search db=products.db&geSKUdata=0] [founditems] [SKU] [Title]
[/foundItems] [/search]It brought back the correct results, however, the server crashed. When it came back up, it had corrupted the database in the same manner.Any thoughts what could be in that specific file which could cause the server to crash? Keep in mind that this site was designed in WebCatalog 3 StoreBuilder and uses two files products.hdr and products.db as the database table.> From: John Peacock > Reply-To: > Date: Thu, 10 Aug 2000 16:09:54 > To: > Subject: Re: New Weird Behavior (bug report) > > I have read the thread. If the file is corrupted the first time it is > hit, and only that file has that problem, then there is either something > wrong with that file or there is something wrong with the template > calling that file. If there is something wrong with the template and, > for example, you have a spider walking your site, you will not have time > to copy the file before WebCat reloads the corrupted version. > > If you reboot the computer, make sure that nothing can call that file, > delete that file and replace with a backup copy, then hit a template, > you will be able to confirm or deny that it is a bug in WebCat. There > must be no copy of that corrupted database in RAM when you copy the > backup over, because WebCat will simply overwrite the new copy. > > I would also suggest making a simple template which just does a trivial > search and returns some records. You should also be doing this on a > non-production server, unconnected from the public network. You should > also make sure there are no triggers active. > > HTH > > John Peacock > > TC wrote: >> >> Thanks for your reply, but I think the problem is much more involved than >> that. Whenever the products.db file is uploaded to the server it is >> corrupted the first time it is hit. >> >> Since we upgraded to 4.2b5 the server crashes everything the file is called. >> >> We had to that the site down to keep from crashing the server since we have >> other clients on the server. >> >> If you need to the review the problem as discussed through the archive >> please read this thread as well as the Corrupt Database Problem... thread. >> >> Thanks. >> >>> From: John Peacock >>> Reply-To: >>> Date: Thu, 10 Aug 2000 15:42:17 >>> To: >>> Subject: Re: New Weird Behavior (bug report) >>> >>> If you have tried [flushdatabase] and you still see databases, you need >>> to reboot your server and disconnect it from the network. While it is >>> disconnected (so no one can hit your templates), do the flush/copy and >>> see if that does it. I have had one instance where I couldn't flush >>> all the databases and that is what it took to fix it. >>> >>> John Peacock >>> >>> TC wrote: >>>> >>>> This is regarding the database corruption problem from earlier today. >>>> >>>> We installed 2beta5 on the server. It didn't seem to help. Do we need to >>>> do a clean install of WebCatalog? >>>> >>>> Flushing databases doesn't seem to work either by the way. If you flush >>>> the >>>> databases then show databases, there are several databases still open. >>>> Uploading the database seems to crash the server. >>>> >>>> To remind you of the problem. The server seems to corrupt the database as >>>> soon as we upload it to the server. >>>> >>>>> From: Paul Uttermohlen >>>>> Reply-To: >>>>> Date: Thu, 10 Aug 2000 12:07:35 >>>>> To: >>>>> Subject: Re: New Weird Behavior (bug report) >>>>> >>>>>>> Though this has already been submitted directly to Sam at SM Tech >>>>>>> Support I thought others here might want to hear about this. >>>>>>> >>>>>>> Using 4.02b5 at about 700,000 hits WebStar/WebCat (all html goes >>>>>>> throught WebCat) started serving pages up randomly for one page in a >>>>>>> site. >>>>>>> >>>>>>> The site was a real estate site. The link was to a page that >>>>>>> explained more about the broker. The result was that the URL was >>>>>>> correct in the browser location window but different pages from >>>>>>> different sites on the server were served up randomly in the browser. >>>>>>> I didn't think it was possible. I thought someone was playing a joke >>>>>>> on me. >>>>>> ......... >>>>>> >>>>>>> Any one else run into these problems? >>>>>>> >>>>>>> Thanks, Paul >>>>>> >>>>>> >>>>>> Actually I am glad to hear that I am not crazy. While working on a store >>>>>> the other day I was treated to a conversation out of my WebCat chat room. >>>>>> We >>>>>> do not use Vhost, and we were not seeing those type of numbers at the >>>>>> time. >>>>>> Reloading my page made it go away, but since I couldn't repeat it I >>>>>> couldn't >>>>>> pursue it. >>>>>> >>>>>> We are still seeing the crash on every attempt to restart webstar. That >>>>>> was introduced in 4.x for us, and then removed (it seemed) for b4 and now >>>>>> back for B5. Are you seeing any crashing Paul while trying to restart >>>>>> WebStar (4.2)? >>>>>> >>>>>> Alex >>>>>> >>>>> >>>>> No crashing here Alex (neither random or on restart - WebStar 4.2). >>>>> And we also have not yet seen a repeat of the random page serving, >>>>> but it was real. We had several people here witness it, including the >>>>> client who was not impressed or pleased to see his competitors pages >>>>> and many pages that are not in any way related pop up in his sites >>>>> frame set. >>>>> >>>>> Paul >>>>> >>>>> _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ >>>>> _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ >>>>> _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ >>>>> _/_/_/ Business - _\_\_\_\_\_\_ >>>>> _/_/_/ Real Estate - _\_\_\_\_ >>>>> _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ >>>>> >>>>> ############################################################# >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> To switch to the DIGEST mode, E-mail to >>>>> >>>>> To switch to the INDEX mode, E-mail to >>>>> >>>>> Send administrative queries to >>>>> >>>>> >>>>> >>>> >>>> ############################################################# >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> To switch to the INDEX mode, E-mail to >>>> >>>> Send administrative queries to >>>> >>> >>> ############################################################# >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> To switch to the INDEX mode, E-mail to >>> >>> Send administrative queries to >>> >>> >>> >> >> ############################################################# >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> To switch to the INDEX mode, E-mail to >> >> Send administrative queries to > > ############################################################# > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > To switch to the INDEX mode, E-mail to > > Send administrative queries to > > ############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to
TC
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:
Sorting by date (1997)
[WebDNA] Successful, working WebDNA7/CentOS install? (2013)
Help getting [shownext] to increment (2003)
Accounting System and WebCatalog/WebMerchant (2000)
Any WebCatalog Server providers in Seattle? (1998)
Re2: frames & carts (1997)
Emailer help....! (1997)
Don't know if this is a sily question... (2003)
Change 2.0 to 2.1: Carts files not written to disk automatically (1998)
pop up menu's (1998)
[ConvertChars] problem (1997)
Radius-Based Zip Locator (2005)
Re:listfiles-looking for slick solution (1997)
Version 2.1.3 changes ... (1998)
WebCat editing, SiteGuard & SiteEdit (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Updating a database once per day - An example (1998)
Searching Relational Databases (2004)
Country & Ship-to address & other fields ? (1997)
[showif] with ! (2000)