[
https://jira.nuxeo.com/browse/NXP-6143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=100484#comment-100484
]
Florent Guillaume commented on NXP-6143:
----------------------------------------
Nothing new on our side.
> Errors in fulltext query using SQL Server 2008
> ----------------------------------------------
>
> Key: NXP-6143
> URL: https://jira.nuxeo.com/browse/NXP-6143
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Search / Query
> Affects Versions: 5.4
> Reporter: Florent Guillaume
> Priority: Major
>
> When doing some fulltext queries with SQL Server 2008, the SQL Server may
> crash with:
> {noformat}
> Error: 17310, Severity: 20, State: 1.
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> A user request from the session with SPID 57 generated a fatal exception. SQL
> Server is terminating this session. Contact Product Support Services with the
> dump produced in the log directory.
> {noformat}
> Two types of queries have been found to cause this error:
> 1. a query containing a fulltext match mixed with another field, for instance:
> {noformat}
> SELECT * FROM Document WHERE ecm:fulltext = 'test' AND dc:title = 'doc'
> {noformat}
> 2. a request where the FROM clause contains a non-herited document type mixed
> with a fulltext match, for instance:
> {noformat}
> SELECT * FROM File WHERE ecm:fulltext = 'test'
> {noformat}
> The query:
> {noformat}
> SELECT * FROM Folder WHERE ecm:fulltext = 'test'
> {noformat}
> does not crash, as Folder is inherited by several document types.
> These queries seem to fail because of a bug in SQL Server 2008 due to the
> UNION ALL and a parallel execution plan.
> Adding a:
> {noformat}
> ... AND ecm:isProxy = 0
> {noformat}
> to the queries makes them work as the UNION ALL does not exist in this case.
> Note that when we execute the generated queries directly in the SQL Server
> interface there is no error. This may be due to the fact that Nuxeo uses
> cursors to fetch the results.
> This is a bug in SQL Server 2008 for which we have no fix at this time.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
