Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    33

    Unanswered: Intra-query parallelism ?????

    Hi,
    Iím using SQL 7.0 with FrontPage sending code to the dB.
    Iím getting the following error and donít understand what it means.
    ----------------
    Database Results Error
    Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Intra-query parallelism caused your server command (process ID #13) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
    Number: -2147217900 (0x80040E14)
    Source: Microsoft OLE DB Provider for ODBC Drivers
    --------------
    The code is long and has several sub-queries.
    All are looking to the same rows in the dB.
    Iím passing a parameter from FP. If I remove the parameter and hardcode the value I donít get this error.
    Is this problem SQL or FP? If SQL what am I looking at?

    Thanks for you help

    Motty

  2. #2
    Join Date
    May 2002
    Posts
    299

    Re: Intra-query parallelism ?????

    This does happen if you're on a multi-processor server. The query is being splitted up for parallel processing. Unfortunately, they happen to block each other.

    As the error suggests, you either rerun or use option hint (maxdop 1) to limit the processing to one processor.
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •