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.
