RE: Unusual SQL error
Sounds to me like when SQL created it's execution plan it is running several parts of the query simultaneously. For some reason when this happens it causes a conflict within your query. What SQL is asking you to do is give it a hint about how to process the query to avoid this problem. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 1:17 PM To: CF-Talk Subject: Unusual SQL error I never have received this error before. [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused your server command (process ID #52) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). Can anyone give some insite? -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unusual SQL error
Thanks, I added the option (maxdop 1) to the end of the query to set the max degree of parallism to 1 -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 9:30 AM To: CF-Talk Subject: RE: Unusual SQL error Sounds to me like when SQL created it's execution plan it is running several parts of the query simultaneously. For some reason when this happens it causes a conflict within your query. What SQL is asking you to do is give it a hint about how to process the query to avoid this problem. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 1:17 PM To: CF-Talk Subject: Unusual SQL error I never have received this error before. [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused your server command (process ID #52) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). Can anyone give some insite? -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unusual SQL error
That should fix it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:34 AM To: CF-Talk Subject: RE: Unusual SQL error Thanks, I added the option (maxdop 1) to the end of the query to set the max degree of parallism to 1 -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 9:30 AM To: CF-Talk Subject: RE: Unusual SQL error Sounds to me like when SQL created it's execution plan it is running several parts of the query simultaneously. For some reason when this happens it causes a conflict within your query. What SQL is asking you to do is give it a hint about how to process the query to avoid this problem. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 1:17 PM To: CF-Talk Subject: Unusual SQL error I never have received this error before. [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused your server command (process ID #52) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). Can anyone give some insite? -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unusual SQL error
Bill, This just got me thinking about a problem I had a while back. I had a sql7 query like this: select * from myTable where isDate(myDateField) = 1 and month(myDateField) 2 Everything worked fine until I moved to SQL 2000. Then it would return an error because myDateField could not be converted to datetime. The myDateField column can have a date, NR, INC. (Not my choice, doing this was dictated to us by another group in our company). The explanation I got from another DBA said that SQL server 7 processed each item of the where sequentially, but SQL 2000 processes all of the where items at the same time. If that is true, do you think that setting the maxdop 1 would prevent the error? No rush for an answer, we already changed all of our code, this is more just for my own piece of mind. Steve -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:36 AM To: CF-Talk Subject: RE: Unusual SQL error That should fix it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:34 AM To: CF-Talk Subject: RE: Unusual SQL error Thanks, I added the option (maxdop 1) to the end of the query to set the max degree of parallism to 1 -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 9:30 AM To: CF-Talk Subject: RE: Unusual SQL error Sounds to me like when SQL created it's execution plan it is running several parts of the query simultaneously. For some reason when this happens it causes a conflict within your query. What SQL is asking you to do is give it a hint about how to process the query to avoid this problem. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 1:17 PM To: CF-Talk Subject: Unusual SQL error I never have received this error before. [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused your server command (process ID #52) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). Can anyone give some insite? -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unusual SQL error
Maybe but not necessarily. It is possible that SQL thinks the most efficient way to retrieve the data is to process the 2nd part of the where before the 1st part. If you have data in your fields that are not dates then your select will fail because of this data. MAXDOP goes beyond just the where clauses. If you are joining tables together SQL will actually do selects on each individual table simultaneously then link the results together before doing the final filtering. The MAXDOP setting controls how many of these selects will take place simultaneously. I hope that answered your question. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:47 AM To: CF-Talk Subject: RE: Unusual SQL error Bill, This just got me thinking about a problem I had a while back. I had a sql7 query like this: select * from myTable where isDate(myDateField) = 1 and month(myDateField) 2 Everything worked fine until I moved to SQL 2000. Then it would return an error because myDateField could not be converted to datetime. The myDateField column can have a date, NR, INC. (Not my choice, doing this was dictated to us by another group in our company). The explanation I got from another DBA said that SQL server 7 processed each item of the where sequentially, but SQL 2000 processes all of the where items at the same time. If that is true, do you think that setting the maxdop 1 would prevent the error? No rush for an answer, we already changed all of our code, this is more just for my own piece of mind. Steve -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:36 AM To: CF-Talk Subject: RE: Unusual SQL error That should fix it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:34 AM To: CF-Talk Subject: RE: Unusual SQL error Thanks, I added the option (maxdop 1) to the end of the query to set the max degree of parallism to 1 -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 9:30 AM To: CF-Talk Subject: RE: Unusual SQL error Sounds to me like when SQL created it's execution plan it is running several parts of the query simultaneously. For some reason when this happens it causes a conflict within your query. What SQL is asking you to do is give it a hint about how to process the query to avoid this problem. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 1:17 PM To: CF-Talk Subject: Unusual SQL error I never have received this error before. [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused your server command (process ID #52) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). Can anyone give some insite? -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method
Unusual SQL error
I never have received this error before. [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused your server command (process ID #52) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). Can anyone give some insite? -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4