[
https://jira.nuxeo.org/browse/NXP-5560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=80578#action_80578
]
Florent Guillaume commented on NXP-5560:
----------------------------------------
For instance PostgreSQL fails if there are more that 65535 documents:
Caused by: org.nuxeo.ecm.core.storage.StorageException: Could not select:
SELECT "id", "parentid", "pos", "name", "isproperty", "primarytype",
"ischeckedin", "baseversionid", "majorversion", "minorversion" FROM "hierarchy"
WHERE "id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ... , ?)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.getSelectRows(JDBCRowMapper.java:342)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.readSimpleRows(JDBCRowMapper.java:142)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.read(JDBCRowMapper.java:109)
at
org.nuxeo.ecm.core.storage.sql.CachingRowMapper.read(CachingRowMapper.java:182)
at
org.nuxeo.ecm.core.storage.sql.PersistenceContext.getFromMapper(PersistenceContext.java:511)
at
org.nuxeo.ecm.core.storage.sql.PersistenceContext.getMulti(PersistenceContext.java:554)
at
org.nuxeo.ecm.core.storage.sql.SessionImpl.getNodesByIds(SessionImpl.java:481)
at
org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.getNodesByIds(ConnectionImpl.java:176)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.getDocumentsById(SQLSession.java:592)
... 43 more
Caused by: org.postgresql.util.PSQLException: Une erreur d'entrée/sortie a eu
lieu lors d'envoi vers le serveur.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:220)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at sun.reflect.GeneratedMethodAccessor159.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:477)
at $Proxy409.executeQuery(Unknown Source)
at
org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.getSelectRows(JDBCRowMapper.java:312)
... 51 more
Caused by: java.io.IOException: Tried to send an out-of-range integer as a
2-byte value: 81558
at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201)
at
org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:786)
at
org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1053)
at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:647)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
... 60 more
> VCS multi-document fetch should have internal batching
> ------------------------------------------------------
>
> Key: NXP-5560
> URL: https://jira.nuxeo.org/browse/NXP-5560
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Affects Versions: 5.3.2
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
> Priority: Major
> Fix For: 5.4
>
>
> When reading multiple documents in one batch, in JDBCRowMapper.getSelectRows
> we should check the batch size and subdivide if it's too big, to avoid
> prepared statements with too many variables.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
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
