Errors when querying. "ClientException: Failed to execute query: This
connection has been closed."
--------------------------------------------------------------------------------------------------
Key: NXP-7610
URL: https://jira.nuxeo.com/browse/NXP-7610
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Search / Query, WebEngine
Affects Versions: 5.4.1
Environment: Ubuntu Linux 64 bit on VMWare ESX hypervisor (4 GB ram,
2vCPU). Postgres 8.4.
Reporter: M Brown
Priority: Major
When making a query, we sometimes receive,
"org.nuxeo.ecm.core.api.ClientException: Failed to execute query: This
connection has been closed." Once the server starts throwing these exceptions,
it continues to throw them on every call until it is restarted.
We are calling this from a WebEngine method. The relevant part of our code is:
CoreSession session = WebEngine.getActiveContext().getCoreSession();
DocumentModelList documents = session.query(query, null, max, offset, true);
<-- throws exception
The query is: SELECT * FROM Document WHERE ecm:fulltext = 'invoice' AND
ecm:path STARTSWITH '/' AND ecm:mixinType = 'dataserv-searchable' ORDER BY
dsc:last_name ASC
Are there any additional logging or diagnostic options we should turn on?
Stack trace is attached.
--
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
