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.
