[
https://jira.nuxeo.com/browse/NXP-7731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=104239#comment-104239
]
Florent Guillaume commented on NXP-7731:
----------------------------------------
FYI on normal fetch queries look like:
{noformat}
SELECT "id", "name", "grant", "permission", "user", "group" FROM "acls" WHERE
"id" IN (?) ORDER BY "id", "pos"
Thread [main] (Suspended (entry into method getCurrentFromResultSet in
ACLCollectionIO))
ACLCollectionIO.getCurrentFromResultSet(ResultSet, List<Column>, Model,
Serializable[], int[]) line: 37
ACLCollectionIO.getCurrentFromResultSet(ResultSet, List, Model,
Serializable[], int[]) line: 29
JDBCMapper(JDBCRowMapper).readCollectionArrays(String,
Collection<Serializable>) line: 268
JDBCMapper(JDBCRowMapper).read(Collection<RowId>) line: 186
CachingMapper(CachingRowMapper).read(Collection<RowId>) line: 311
PersistenceContext.getFromMapper(Collection<RowId>, boolean) line: 550
PersistenceContext.getMulti(Collection<RowId>, boolean) line: 594
SessionImpl.getNodesByIds(List<Serializable>, boolean) line: 688
SessionImpl.getNodeById(Serializable, boolean) line: 585
SessionImpl.getNodeById(Serializable) line: 597
ConnectionImpl.getNodeById(Serializable) line: 180
SQLSession.getDocumentByUUID(String) line: 213
{noformat}
> VCS: fix Collection refresh
> ---------------------------
>
> Key: NXP-7731
> URL: https://jira.nuxeo.com/browse/NXP-7731
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.4
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
> Priority: Major
> Fix For: 5.4.3
>
>
> CollectionIO fails to properly refetch a collection. This only happens when a
> collection has been evicted by the GC.
> {noformat}
> StorageException: Could not select: SELECT "POS", "NAME", "GRANT",
> "PERMISSION", "USER", "GROUP" FROM "ACLS" WHERE "ID" = ? ORDER BY "POS"
> at
> org.nuxeo.ecm.core.storage.sql.coremodel.SQLCollectionProperty.getValue(SQLCollectionProperty.java:71)
> at
> org.nuxeo.ecm.core.storage.sql.coremodel.SQLSecurityManager.getACP(SQLSecurityManager.java:51)
> ... 37 more
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> org.nuxeo.ecm.core.storage.StorageException.
> message: Could not select: SELECT "POS", "NAME", "GRANT", "PERMISSION",
> "USER", "GROUP" FROM "ACLS" WHERE "ID" = ? ORDER BY "POS"
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.readCollectionRowArray(JDBCRowMapper.java:770)
> at
> org.nuxeo.ecm.core.storage.sql.CachingRowMapper.readCollectionRowArray(CachingRowMapper.java:388)
> at
> org.nuxeo.ecm.core.storage.sql.CollectionFragment.refetch(CollectionFragment.java:78)
> at org.nuxeo.ecm.core.storage.sql.Fragment.accessed(Fragment.java:229)
> at
> org.nuxeo.ecm.core.storage.sql.CollectionFragment.get(CollectionFragment.java:63)
> at
> org.nuxeo.ecm.core.storage.sql.CollectionProperty.getValue(CollectionProperty.java:42)
> at
> org.nuxeo.ecm.core.storage.sql.coremodel.SQLCollectionProperty.getValue(SQLCollectionProperty.java:64)
> ... 38 more
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> java.lang.RuntimeException. message: pos
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.ACLCollectionIO.getCurrentFromResultSet(ACLCollectionIO.java:61)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.ACLCollectionIO.getCurrentFromResultSet(ACLCollectionIO.java:29)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.readCollectionRowArray(JDBCRowMapper.java:755)
> ... 44 more
> {noformat}
--
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
