I may have found what I'm looking for... DoPurge = 1 Was set in cf.registry for clientvars, so I changed this value to 0 in the hopes that this controls the built-in client data purge function. Can somebody please confirm? ----- Original Message ----- From: "Rob Patrick" <[EMAIL PROTECTED]> To: "CF-Linux" <[EMAIL PROTECTED]> Sent: Saturday, June 09, 2001 8:45 AM Subject: Re: CF45 Linux scheduled client data purge MySQL errors > Thanks for the link - the template I need to run for clearing out the client > vars is listed there, but I can't find how to disable the current built-in > process of clearing the variables...? Where can I turn this off? > > > -Rob > > > ----- Original Message ----- > From: "Deb Dickerson" <[EMAIL PROTECTED]> > To: "CF-Linux" <[EMAIL PROTECTED]> > Sent: Saturday, June 09, 2001 7:57 AM > Subject: RE: CF45 Linux scheduled client data purge MySQL errors > > > > You're correct that there's a problem expiring mySQL client variables, due > > to limitations of mySQL. There's a template provided, > > /opt/coldfusion/scripts/mysql_expire.cfm, that will take care of it for > you. > > For more details, see this knowledge base article: > > http://www.allaire.com/Handlers/index.cfm?ID=16201&Method=Full > > > > Deb > > > > > -----Original Message----- > > > From: Rob Patrick [mailto:[EMAIL PROTECTED]] > > > Sent: Saturday, June 09, 2001 2:04 AM > > > To: CF-Linux > > > Subject: CF45 Linux scheduled client data purge MySQL errors > > > > > > > > > I'm getting these errors in my logs every so often, and it's causing CF > to > > > hang up pretty hard. > > > > > > In executive.log I'm getting this: > > > "Error","TID=2051","06/09/01","01:37:52"," Error running SQL > > > to expire > > > client data from Data Sourc clientvars: ODBC Error Code = 37000 > > > (Syntax error or access violation)<P>: [MERANT][ODBC MySql > > > driver][MySql]You > > > have an error in your SQL syntax near 'SELECT CGLOBAL.cfid FROM CGLOBAL > > > WHERE CGLOBAL.lvisit < '2001-05-30 01:37:52')' at line 1<P><P>" > > > > > > In mysql.log I'm getting a lot of these: > > > 010609 1:36:47 Aborted connection 57 to db: 'sfa' user: 'root' host: > > > `localhost' (Got an error reading communication packets) > > > > > > Data source "sba" is called from one of my CF web pages on a user's > site. > > > > > > Looks like CF tries to run the scheduled task to clear out old client > data > > > from the data source "clientvars" which I've defined for CF to use as a > > > storage area for client variables. For some reason it's puking on this > > > task, which ends up causing something to hang, and then MySQL starts > > > reporting errors when subsequent CF pages are hit. > > > > > > > > > I think I remember reading somewhere about an issue with CF and MySQL on > > > Linux with this scheduled client data expiration task, but I can't > recall > > > the details. Please help! :) > > > > > > > > > -Rob Patrick > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
