>>priority....,' you might need to use some native mySQL query modifiers
You might install the excellent webmin tool http://www.webmin.com/ which allows you to test SQL and generally manage mySQL, might help pinpoint if there is a specific issue with CF driver or permissions... cheers Colm -----Original Message----- From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 25 June 2003 09:38 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] MX "Locking Up" + other issues > CFTRANSACTION can be used to group multiple queries that use > CFQUERYinto one business event. Changes to data that is > requested by the queries are not committed to the datasource > until all actions within the transaction block have execute Maybe shooting in the dark but have you read of Du Bois, MySQL, pp195'Scheduling and Locking Issues' about reads and writes 'The HIGH-PRIORITY keyword for SELECT queries is similar. IT allows a SELECT to slip in ahead of a waiting write, even if the write has normal priority....,' you might need to use some native mySQL query modifiers colm -----Original Message----- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 19:46 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] MX "Locking Up" + other issues Right, Looks like it's a JDBC issue. After playing around with stack traces and a bit of googling, it seems as if http://dbforums.com/t528120.html touches on the issue. Threads seem to be permanently blocking by waiting for something back from the JDBC stuff that's not forthcoming: "jrpp-35" prio=1 tid=0x834c968 nid=0x5aee runnable [0xbd5fe000..0xbd5ff8b0] at java.net.SocketInputStream.socketRead(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:85) at java.net.SocketInputStream.read(SocketInputStream.java:107) at org.gjt.mm.mysql.MysqlIO.readPacket(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.Statement.execute(Unknown Source) at org.gjt.mm.mysql.jdbc2.Statement.execute(Unknown Source) ... Other threads are stalling on the JDBCPool.checkOut method: "jrpp-79" prio=1 tid=0x89876f8 nid=0x5d74 waiting for monitor entry [0xb75fe000..0xb75ff8b0] at jrun.sql.pool.JDBCPool.checkOut(JDBCPool.java:437) at jrun.sql.pool.JDBCPool.requestConnection(JDBCPool.java:740) at jrun.sql.pool.JDBCManager.requestConnection(JDBCManager.java:126) at jrun.sql.JRunDataSource.getConnection(JRunDataSource.java:235) at jrun.sql.JRunDataSource.getConnection(JRunDataSource.java:175) ... I'll have another look tomorrow and maybe try updating the JDBC drivers... Might even give MM support a call... Ho hum. Tim. ------------------------------------------------------- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. ------------------------------------------------------- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 24 June 2003 17:55 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] MX "Locking Up" + other issues > > > CFTRANSACTION can be used to group multiple queries that use > CFQUERYinto one business event. Changes to data that is > requested by the queries are not committed to the datasource > until all actions within the transaction block have executed > successfully. > > > > ----- Original Message ----- > From: "Tim Blair" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 24, 2003 5:44 PM > Subject: RE: [ cf-dev ] MX "Locking Up" + other issues > > > > > > > have you tried wrapping a <cftransaction> or <cflock> around them > > > > I don't see how a transaction would help - MySQL doesn't support > > transactions (yet), but I've tried wrapping a <cflock> around the > > apparently dodgy query with a timeout of 5, but again > everything just > > grinds to a halt -- the lock never times out. > > > > Grrrrrr... > > > > > > ------------------------------------------------------- > > RAWNET LTD - Internet, New Media and ebusiness Gurus. > > Visit our new website at http://www.rawnet.com for > > more information about our company, or call us free > > anytime on 0800 294 24 24. > > ------------------------------------------------------- > > Tim Blair > > Web Application Engineer, Rawnet Limited > > Direct Phone : +44 (0) 1344 393 441 > > Switchboard : +44 (0) 1344 393 040 > > ------------------------------------------------------- > > This message may contain information which is legally privileged > > and/or confidential. If you are not the intended > recipient, you are > > hereby notified that any unauthorised disclosure, copying, > > distribution or use of this information is strictly prohibited. Such > > notification notwithstanding, any comments, opinions, > > information or conclusions expressed in this message > > are those of the originator, not of rawnet limited, > > unless otherwise explicitly and independently indicated > > by an authorised representative of rawnet limited. > > ------------------------------------------------------- > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] For > > human help, e-mail: [EMAIL PROTECTED] > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
