Webdav - Uploading multiple files to a New folder shows exception in log: ERROR db.DotConnect: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key" #13309

acurionedotcms · 2018-01-04T18:27:32Z

In Webdav (using Cyberduck client)
1- Create a new Folder
2- Upload multiple images or files (4 or 5 works)
3- Files are uploaded correctly
4- Go to the dotcms Log file:

There's an exception:
[04/01/18 11:47:36:282 CST] ERROR db.DotConnect: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key"
Detail: Key (asset_id)=(2b4cdd0d-e717-402b-8dc8-33737ca07cce) already exists.
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key"
Detail: Key (asset_id)=(2b4cdd0d-e717-402b-8dc8-33737ca07cce) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) ~[postgresql-9.0-801.jdbc3.jar:?]
at com.dotmarketing.common.db.DotConnect.executeUpdate(DotConnect.java:1170) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.common.db.DotConnect.executeUpdate(DotConnect.java:1113) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission_aroundBody0(PermissionBitFactoryImpl.java:2304) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl$AjcClosure1.run(PermissionBitFactoryImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.LocalTransaction.wrapReturnWithListeners(LocalTransaction.java:40) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.WrapInTransactionMethodInterceptor.invoke(WrapInTransactionMethodInterceptor.java:23) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.WrapInTransactionAspect.invoke(WrapInTransactionAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission(PermissionBitFactoryImpl.java:2283) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2270) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:972) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:954) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2259) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getPermissions(PermissionBitFactoryImpl.java:1052) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions_aroundBody18(PermissionBitAPIImpl.java:589) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl$AjcClosure19.run(PermissionBitAPIImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.CloseDBIfOpenedMethodInterceptor.invoke(CloseDBIfOpenedMethodInterceptor.java:29) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.CloseDBIfOpenedAspect.invoke(CloseDBIfOpenedAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions(PermissionBitAPIImpl.java:587) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.loadPermissions(ESMappingAPIImpl.java:344) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.toMap(ESMappingAPIImpl.java:193) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletIndexAPI.indexContentletList(ESContentletIndexAPI.java:355) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletIndexAPI.indexContentList(ESContentletIndexAPI.java:329) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.ReindexRunnable.run(ReindexRunnable.java:51) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.DotRunnableThread.internalRunner(DotRunnableThread.java:77) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.LocalTransaction.wrap(LocalTransaction.java:133) [dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.DotRunnableThread.run(DotRunnableThread.java:41) [dotcms_4.3.0_999999.jar:?]
[04/01/18 11:47:36:290 CST] WARN business.PermissionBitFactoryImpl: Failed to insert Permission Ref. Usually not a problem. Permissionable:2b4cdd0d-e717-402b-8dc8-33737ca07cce Parent : 48190c8c-42c4-46af-8d1a-0cd5db894797 Type: com.dotmarketing.portlets.folders.model.Folder
[04/01/18 11:47:36:291 CST] INFO business.PermissionBitFactoryImpl: LOAD PERM thread: Thread-39, type: com.dotmarketing.portlets.contentlet.model.Contentlet
[04/01/18 11:47:36:291 CST] ERROR business.ESContentletIndexAPI: Can't get a mapping for contentlet with id_lang:a881cba5-4325-41f0-994f-119fc14f6224_1 Content data: {owner=dotcms.org.1, identifier=a881cba5-4325-41f0-994f-119fc14f6224, fileName=kart2.jpg, modDate=Thu Jan 04 11:47:35 CST 2018, languageId=1, description=kart2, title=kart2.jpg, fileAsset=/Users/andrecurione/development/tomcat8/webapps/ROOT/assets/8/3/83c3d9dc-24a3-48eb-abed-56783f87b843/fileAsset/kart2.jpg, inode=83c3d9dc-24a3-48eb-abed-56783f87b843, metaData=~~||%%CACHED_METADATA%%||~~, folder=2b4cdd0d-e717-402b-8dc8-33737ca07cce, disabledWYSIWYG=[], sortOrder=0, modUser=dotcms.org.1, host=48190c8c-42c4-46af-8d1a-0cd5db894797, stInode=33888b6f-7a8e-4069-b1b6-5c1aa9d0a48d}
com.dotcms.content.business.DotMappingException
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.toMap(ESMappingAPIImpl.java:294) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletIndexAPI.indexContentletList(ESContentletIndexAPI.java:355) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESContentletIndexAPI.indexContentList(ESContentletIndexAPI.java:329) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.ReindexRunnable.run(ReindexRunnable.java:51) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.DotRunnableThread.internalRunner(DotRunnableThread.java:77) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.LocalTransaction.wrap(LocalTransaction.java:133) [dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.DotRunnableThread.run(DotRunnableThread.java:41) [dotcms_4.3.0_999999.jar:?]
Caused by: com.dotmarketing.exception.DotDataException: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key"
Detail: Key (asset_id)=(2b4cdd0d-e717-402b-8dc8-33737ca07cce) already exists.
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission_aroundBody0(PermissionBitFactoryImpl.java:2317) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl$AjcClosure1.run(PermissionBitFactoryImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.LocalTransaction.wrapReturnWithListeners(LocalTransaction.java:40) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.WrapInTransactionMethodInterceptor.invoke(WrapInTransactionMethodInterceptor.java:23) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.WrapInTransactionAspect.invoke(WrapInTransactionAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission(PermissionBitFactoryImpl.java:2283) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2270) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:972) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:954) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2259) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getPermissions(PermissionBitFactoryImpl.java:1052) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions_aroundBody18(PermissionBitAPIImpl.java:589) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl$AjcClosure19.run(PermissionBitAPIImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.CloseDBIfOpenedMethodInterceptor.invoke(CloseDBIfOpenedMethodInterceptor.java:29) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.CloseDBIfOpenedAspect.invoke(CloseDBIfOpenedAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions(PermissionBitAPIImpl.java:587) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.loadPermissions(ESMappingAPIImpl.java:344) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.toMap(ESMappingAPIImpl.java:193) ~[dotcms_4.3.0_999999.jar:?]
... 6 more
Caused by: com.dotmarketing.exception.DotDataException: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key"
Detail: Key (asset_id)=(2b4cdd0d-e717-402b-8dc8-33737ca07cce) already exists.
at com.dotmarketing.common.db.DotConnect.executeUpdate(DotConnect.java:1174) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.common.db.DotConnect.executeUpdate(DotConnect.java:1113) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission_aroundBody0(PermissionBitFactoryImpl.java:2304) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl$AjcClosure1.run(PermissionBitFactoryImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.LocalTransaction.wrapReturnWithListeners(LocalTransaction.java:40) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.WrapInTransactionMethodInterceptor.invoke(WrapInTransactionMethodInterceptor.java:23) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.WrapInTransactionAspect.invoke(WrapInTransactionAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission(PermissionBitFactoryImpl.java:2283) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2270) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:972) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:954) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2259) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getPermissions(PermissionBitFactoryImpl.java:1052) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions_aroundBody18(PermissionBitAPIImpl.java:589) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl$AjcClosure19.run(PermissionBitAPIImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.CloseDBIfOpenedMethodInterceptor.invoke(CloseDBIfOpenedMethodInterceptor.java:29) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.CloseDBIfOpenedAspect.invoke(CloseDBIfOpenedAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions(PermissionBitAPIImpl.java:587) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.loadPermissions(ESMappingAPIImpl.java:344) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.toMap(ESMappingAPIImpl.java:193) ~[dotcms_4.3.0_999999.jar:?]
... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key"
Detail: Key (asset_id)=(2b4cdd0d-e717-402b-8dc8-33737ca07cce) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql-9.0-801.jdbc3.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) ~[postgresql-9.0-801.jdbc3.jar:?]
at com.dotmarketing.common.db.DotConnect.executeUpdate(DotConnect.java:1170) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.common.db.DotConnect.executeUpdate(DotConnect.java:1113) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission_aroundBody0(PermissionBitFactoryImpl.java:2304) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl$AjcClosure1.run(PermissionBitFactoryImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.db.LocalTransaction.wrapReturnWithListeners(LocalTransaction.java:40) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.WrapInTransactionMethodInterceptor.invoke(WrapInTransactionMethodInterceptor.java:23) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.WrapInTransactionAspect.invoke(WrapInTransactionAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.deleteInsertPermission(PermissionBitFactoryImpl.java:2283) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2270) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:972) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getInheritablePermissions(PermissionBitFactoryImpl.java:954) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.loadPermissions(PermissionBitFactoryImpl.java:2259) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitFactoryImpl.getPermissions(PermissionBitFactoryImpl.java:1052) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions_aroundBody18(PermissionBitAPIImpl.java:589) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl$AjcClosure19.run(PermissionBitAPIImpl.java:1) ~[dotcms_4.3.0_999999.jar:?]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) ~[aspectjrt-1.8.10.jar:?]
at com.dotcms.aspects.aspectj.AspectJDelegateMethodInvocation.proceed(AspectJDelegateMethodInvocation.java:43) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.interceptors.CloseDBIfOpenedMethodInterceptor.invoke(CloseDBIfOpenedMethodInterceptor.java:29) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.aspects.aspectj.CloseDBIfOpenedAspect.invoke(CloseDBIfOpenedAspect.java:41) ~[dotcms_4.3.0_999999.jar:?]
at com.dotmarketing.business.PermissionBitAPIImpl.getPermissions(PermissionBitAPIImpl.java:587) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.loadPermissions(ESMappingAPIImpl.java:344) ~[dotcms_4.3.0_999999.jar:?]
at com.dotcms.content.elasticsearch.business.ESMappingAPIImpl.toMap(ESMappingAPIImpl.java:193) ~[dotcms_4.3.0_999999.jar:?]
... 6 more

…que constraint exception

…ionBitFactory

* #13309 - Postgres Upsert SQL * #13309 - MySQL Upsert SQL * #13309 - MSSQL Upsert SQL * #13309 - MSSQL Upsert SQL * #13309 - MSSQL Upsert SQL * #13309 - Oracle Upsert SQL * #13309 - Use constants and add documentation * #13309 - H2 Upsert SQL * #13309 - Code review fixes * #13309 - Code review fixes * #13309 - Use UpsertPermissionCommand to simplify code for the PermissionBitFactory * #13309 - Refactor to create a generic UpsertCommand * #13309 - Refactor to create a generic UpsertCommand * #13309 - Refactor to create a generic UpsertCommand * #13309 - Refactor to create a generic UpsertCommand * #13309 - Refactor to create a generic UpsertCommand * #13309 - Create an UpsertCommandFactory object * #13309 - Create an UpsertCommandFactory object * #13309 - Rename UpsertCommandFactory.getInstance to getUpsertCommand

* #13309 - Changes in the Upsert Command for Postgres -9.4 * #13309 - Changes in the Upsert Command for Postgres -9.4

shaydotcms · 2018-01-16T18:04:39Z

Passed QA.
No errrors in logs after creating and uploading different type of assets(img, videos, .txt, pdf, etc).
Tested on master branch / Mac 10.10 / Postgres 9.6 / Chrome v54.0.2840.98 / Tomcat 8 / Java 8

wezell · 2018-01-25T20:12:50Z

Postgres 9.4 is deprecated

* Updating commit reference for src/main/enterprise * #13309 - Changes in the Upsert Command for Postgres -9.4 (#13403) * #13309 - Changes in the Upsert Command for Postgres -9.4 * #13309 - Changes in the Upsert Command for Postgres -9.4 * Can't save new containers in a layout (#13377) * Can't save new containers in a layout * refactoring * refactoring * merge * doing constructor public again * refactoring * refactoring * #13196 (#13405) * Wrong type #13196 (#13406) * Issue 13352 dnd on workflow (#13382) * #13352 adding drag and drop to workflow builder * #13352 cool new hover trick * #13352 we didn't need api changed * #13352 * Add message key (#13412) * #12991 Need to add action of push publish to content types * #13236 Edit contentlets in page (#13400) js changes * bring back download data/assets changes (#13422) * #13395 CopyContentlet done (#13415) * Fix more jenkins tests (#13427) * Updating commit reference for src/main/enterprise * PermissionAPITest: converted from functional to integration RoleAjax: remove unused user. Can now be tested with server down UserAPITest: fix workflow issues FolderAPITest: fix workflow issues LinkFactoryTest: fix workflow issues ContainerFactoryImpl: Reading version info from api instead of only cache. * #13410 MSSQL Task 04315 Upgrade Fix (#13423) * #13410 MSSQL Task 04315 Upgrade Fix * #13410 MSSQL Task 04315 Upgrade Fix * #13321: Clearing cache to force DB search (#13431) * Remove permission tests from alltestsuite (#13434) * Updating commit reference for src/main/enterprise * PermissionAPITest: converted from functional to integration RoleAjax: remove unused user. Can now be tested with server down UserAPITest: fix workflow issues FolderAPITest: fix workflow issues LinkFactoryTest: fix workflow issues ContainerFactoryImpl: Reading version info from api instead of only cache. * Remove ITest from AllTestSuite. * #13424 fixes the mysql lockup issue (#13426) * #13424 fixes the mysql lockup issue * #13424 closes the preparedstatement * #13241 rethrow the original exception (#13416) * Updating commit reference for src/main/enterprise * Fix TreeTransformer for Oracle. (#13439) * #13433 bring back Backup Data/Assets functionality (#13442) * Added new starter * #13321: Avoiding factory method with API find call inside (#13443) * #13429 (#13432) * Updating commit reference for src/main/enterprise * Added new starter * Clean folderapitest rename (#13456) * Fix TreeTransformer for Oracle. * Dont mess with cache in the test. FolderAPITest.rename * #13384 - Delete Template dependencies popup should display Template Title (#13455) * Workflows tests fixes (#13460) * Workflows tests fixes * Workflows tests fixes * Workflows tests - Adding missing condition (#13461) * #13196 fixing ut for oracle (#13463) * #13196 fixes for upgrade task for msssql (#13462) * Issue 12991 need to add actions push publish content types (#13444) * issue #12991 push publish content types message keys * #12991 push publish content types actions message keys * #12991 push publish content types message keys * Issue 13457 (#13465) * #13457: Remove unused logic * #13457: Add copyTemplate integration test * #13419: Prevent NPE by avoiding Layout parsing when Template not drawn (#13458) * #13419: Prevent NPE by avoiding Layout parsing when Template not drawed * #13419: Adding Will's logic from no-code branch * #12999 - Added MultiTree Transformer (#13438) * #12999 - Added MultiTree Transformer * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * Fix condition check for user api test. More Logging. (#13473) * #13474 Include lang properties changes. (#13476) * Workflows tests - Fixing permissions (#13477) * error common label (#13467) * Include working:true in es query for reindexing content after updating user. Use isInodeIndex with live=false. (#13479) * #13390 cherry-pick the email fix (#13484) * Updating commit reference for src/main/enterprise * http://#13295 set sidebar width in edit layout - Message keys (#13480) * Include more logging for FolderAPITest.delete (#13488) * Issue rest multiple binaries (#13472) * #11620 * #11613 * #13466 - Fixes in Update System Folder when System folder has been re… (#13486) * #13466 - Fixes in Update System Folder when System folder has been renamed * #13466 - Fixes in Update System Folder when System folder has been renamed * Folderapitest rename logging (#13491) * Include more logging for FolderAPITest.delete * more logging. * Adding missing validation (#13489) * Adding missing validation * Fixing Typo * Logging for FolderAPITest.delete * UserAPITest.delete:Load Identifiers from db to avoid cache race conditions. * Issue 13336 (#13487) * #13336 remove CMIS * #13336 remove commented code * #13336 changes DBSearch * #13336 revert changes DBSearch * #13336 missing assignment * Updating commit reference for src/main/enterprise * Issue 13429 missing commit tika lowercase (#13501) * #13429 * missing lowercase * ESUtils: include case for text with whitespace (#13499) ESUtilsTest: test for all special chars and whitespace * Updating commit reference for src/main/enterprise * #13375 - Folder API - Incorrect Query causing cartesian product and o… (#13493) * #13375 - Folder API - Incorrect Query causing cartesian product and out of memory or closed resultsets errors * #13375 - Folder API - Incorrect Query causing cartesian product and out of memory or closed resultsets errors * #10604 add hover options for span tags in website browser (#13490) * #12991 push publish content types - Messages keys (#13500) * Issue 13502 npe on deleted bundle (#13503) * #13429 * fixes #13502 * Use new ami (#13511) * ContentResource: Pass value of REST_API_CONTENT_ALLOW_FRONT_END_SAVIN… (#13510) * ContentResource: Pass value of REST_API_CONTENT_ALLOW_FRONT_END_SAVING to methods to find cats by key or name ContentResourceTest: Added two tests for both cases (true/false) for REST_API_CONTENT_ALLOW_FRONT_END_SAVING when saving content via REST API with anonymous user * #12150 Correct test name. * #12150 Code review changes. * Update ami jenkins (#13512) * Use new ami * New AMI for jenkins continuous tests. * Include isInodeIndexed in test. * Issue 13469 workflow multi lang (#13509) * #13469 multi language support for workflow task * #13469 Adding the multi language step/action workflows * #13469 codacy feedback * Issue 11265 create 4 eyes workflow actionlet (#13366) * #11265 : Adding initial version of the 4-Eyes actionlet. * #11265 : Adding initial version of the 4-Eyes actionlet. * #11265 : - Wrapping up changes in the 4-eyes approval actionlet class. - Adding utility class for common-use methods in actionlets. * #11265 : Adding new type of actionlet parameter that includes validation of role keys. * #11265 : Codacy and Sonar code changes. * #11265 : More Codacy and Sonar code changes. * #11265 : First draft of integration test. Fixing exception throws where the original exception was being swallowed. * #11265 : Adding more tests to the four-eye sub-action integration test. * #13333 need to add action of add to bundle to content types - Adding message keus (#13516) * Missing import * Fix TreeTransformer and ContentletTransformer (#13518) TreeTransformer: Use conversion utils instead of a class for Oracle. TransformerLocator: create only TreeTransformer ContentletTransformer: Use conversion utils to avoid classCastException in oracle * #13375 fix starting up oracle, bc join never finds inode column (#13519) * Remove invalid import. * Fixing failing Jenkins tests. (#13517) * changes to build docker image from gradle file - still need to upgrade gradle wrapper version * cosmetic commit to build.gradle * changed docker tags and added blank line at end of file * upgraded gradle wrapper to 4.4.1 * 4.4.1 gradle wrapper * added reference comment * fixes #13527

* fixes #13435 - changed so rename only happens based on ARCHIVE_IMPORTED_LICENSE_PACKS being true. Also logs failure if appropriate. (#13464) * Issue 13527 build docker image from gradle build (#13529) * Updating commit reference for src/main/enterprise * #13309 - Changes in the Upsert Command for Postgres -9.4 (#13403) * #13309 - Changes in the Upsert Command for Postgres -9.4 * #13309 - Changes in the Upsert Command for Postgres -9.4 * Can't save new containers in a layout (#13377) * Can't save new containers in a layout * refactoring * refactoring * merge * doing constructor public again * refactoring * refactoring * #13196 (#13405) * Wrong type #13196 (#13406) * Issue 13352 dnd on workflow (#13382) * #13352 adding drag and drop to workflow builder * #13352 cool new hover trick * #13352 we didn't need api changed * #13352 * Add message key (#13412) * #12991 Need to add action of push publish to content types * #13236 Edit contentlets in page (#13400) js changes * bring back download data/assets changes (#13422) * #13395 CopyContentlet done (#13415) * Fix more jenkins tests (#13427) * Updating commit reference for src/main/enterprise * PermissionAPITest: converted from functional to integration RoleAjax: remove unused user. Can now be tested with server down UserAPITest: fix workflow issues FolderAPITest: fix workflow issues LinkFactoryTest: fix workflow issues ContainerFactoryImpl: Reading version info from api instead of only cache. * #13410 MSSQL Task 04315 Upgrade Fix (#13423) * #13410 MSSQL Task 04315 Upgrade Fix * #13410 MSSQL Task 04315 Upgrade Fix * #13321: Clearing cache to force DB search (#13431) * Remove permission tests from alltestsuite (#13434) * Updating commit reference for src/main/enterprise * PermissionAPITest: converted from functional to integration RoleAjax: remove unused user. Can now be tested with server down UserAPITest: fix workflow issues FolderAPITest: fix workflow issues LinkFactoryTest: fix workflow issues ContainerFactoryImpl: Reading version info from api instead of only cache. * Remove ITest from AllTestSuite. * #13424 fixes the mysql lockup issue (#13426) * #13424 fixes the mysql lockup issue * #13424 closes the preparedstatement * #13241 rethrow the original exception (#13416) * Updating commit reference for src/main/enterprise * Fix TreeTransformer for Oracle. (#13439) * #13433 bring back Backup Data/Assets functionality (#13442) * Added new starter * #13321: Avoiding factory method with API find call inside (#13443) * #13429 (#13432) * Updating commit reference for src/main/enterprise * Added new starter * Clean folderapitest rename (#13456) * Fix TreeTransformer for Oracle. * Dont mess with cache in the test. FolderAPITest.rename * #13384 - Delete Template dependencies popup should display Template Title (#13455) * Workflows tests fixes (#13460) * Workflows tests fixes * Workflows tests fixes * Workflows tests - Adding missing condition (#13461) * #13196 fixing ut for oracle (#13463) * #13196 fixes for upgrade task for msssql (#13462) * Issue 12991 need to add actions push publish content types (#13444) * issue #12991 push publish content types message keys * #12991 push publish content types actions message keys * #12991 push publish content types message keys * Issue 13457 (#13465) * #13457: Remove unused logic * #13457: Add copyTemplate integration test * #13419: Prevent NPE by avoiding Layout parsing when Template not drawn (#13458) * #13419: Prevent NPE by avoiding Layout parsing when Template not drawed * #13419: Adding Will's logic from no-code branch * #12999 - Added MultiTree Transformer (#13438) * #12999 - Added MultiTree Transformer * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * #12999 - MultiTree Transformer test and fixes * Fix condition check for user api test. More Logging. (#13473) * #13474 Include lang properties changes. (#13476) * Workflows tests - Fixing permissions (#13477) * error common label (#13467) * Include working:true in es query for reindexing content after updating user. Use isInodeIndex with live=false. (#13479) * #13390 cherry-pick the email fix (#13484) * Updating commit reference for src/main/enterprise * http://#13295 set sidebar width in edit layout - Message keys (#13480) * Include more logging for FolderAPITest.delete (#13488) * Issue rest multiple binaries (#13472) * #11620 * #11613 * #13466 - Fixes in Update System Folder when System folder has been re… (#13486) * #13466 - Fixes in Update System Folder when System folder has been renamed * #13466 - Fixes in Update System Folder when System folder has been renamed * Folderapitest rename logging (#13491) * Include more logging for FolderAPITest.delete * more logging. * Adding missing validation (#13489) * Adding missing validation * Fixing Typo * Logging for FolderAPITest.delete * UserAPITest.delete:Load Identifiers from db to avoid cache race conditions. * Issue 13336 (#13487) * #13336 remove CMIS * #13336 remove commented code * #13336 changes DBSearch * #13336 revert changes DBSearch * #13336 missing assignment * Updating commit reference for src/main/enterprise * Issue 13429 missing commit tika lowercase (#13501) * #13429 * missing lowercase * ESUtils: include case for text with whitespace (#13499) ESUtilsTest: test for all special chars and whitespace * Updating commit reference for src/main/enterprise * #13375 - Folder API - Incorrect Query causing cartesian product and o… (#13493) * #13375 - Folder API - Incorrect Query causing cartesian product and out of memory or closed resultsets errors * #13375 - Folder API - Incorrect Query causing cartesian product and out of memory or closed resultsets errors * #10604 add hover options for span tags in website browser (#13490) * #12991 push publish content types - Messages keys (#13500) * Issue 13502 npe on deleted bundle (#13503) * #13429 * fixes #13502 * Use new ami (#13511) * ContentResource: Pass value of REST_API_CONTENT_ALLOW_FRONT_END_SAVIN… (#13510) * ContentResource: Pass value of REST_API_CONTENT_ALLOW_FRONT_END_SAVING to methods to find cats by key or name ContentResourceTest: Added two tests for both cases (true/false) for REST_API_CONTENT_ALLOW_FRONT_END_SAVING when saving content via REST API with anonymous user * #12150 Correct test name. * #12150 Code review changes. * Update ami jenkins (#13512) * Use new ami * New AMI for jenkins continuous tests. * Include isInodeIndexed in test. * Issue 13469 workflow multi lang (#13509) * #13469 multi language support for workflow task * #13469 Adding the multi language step/action workflows * #13469 codacy feedback * Issue 11265 create 4 eyes workflow actionlet (#13366) * #11265 : Adding initial version of the 4-Eyes actionlet. * #11265 : Adding initial version of the 4-Eyes actionlet. * #11265 : - Wrapping up changes in the 4-eyes approval actionlet class. - Adding utility class for common-use methods in actionlets. * #11265 : Adding new type of actionlet parameter that includes validation of role keys. * #11265 : Codacy and Sonar code changes. * #11265 : More Codacy and Sonar code changes. * #11265 : First draft of integration test. Fixing exception throws where the original exception was being swallowed. * #11265 : Adding more tests to the four-eye sub-action integration test. * #13333 need to add action of add to bundle to content types - Adding message keus (#13516) * Missing import * Fix TreeTransformer and ContentletTransformer (#13518) TreeTransformer: Use conversion utils instead of a class for Oracle. TransformerLocator: create only TreeTransformer ContentletTransformer: Use conversion utils to avoid classCastException in oracle * #13375 fix starting up oracle, bc join never finds inode column (#13519) * Remove invalid import. * Fixing failing Jenkins tests. (#13517) * changes to build docker image from gradle file - still need to upgrade gradle wrapper version * cosmetic commit to build.gradle * changed docker tags and added blank line at end of file * upgraded gradle wrapper to 4.4.1 * 4.4.1 gradle wrapper * added reference comment * fixes #13527

acurionedotcms self-assigned this Jan 4, 2018

acurionedotcms added this to the Rex Current milestone Jan 4, 2018

acurionedotcms added a commit that referenced this issue Jan 4, 2018

#13309 - Webdav - Uploading multiple files to a new folder throws uni…

74e9f4d

…que constraint exception

acurionedotcms added a commit that referenced this issue Jan 5, 2018

#13309 - Postgres Upsert SQL

f347926

acurionedotcms added a commit that referenced this issue Jan 5, 2018

#13309 - MySQL Upsert SQL

de84e31

acurionedotcms added a commit that referenced this issue Jan 5, 2018

#13309 - MSSQL Upsert SQL

13c33af

acurionedotcms added a commit that referenced this issue Jan 5, 2018

#13309 - MSSQL Upsert SQL

96ba442

acurionedotcms added a commit that referenced this issue Jan 5, 2018

#13309 - MSSQL Upsert SQL

2251024

erickgonzalez mentioned this issue Jan 8, 2018

NPE error in Webdav with languages other than 1 #13134

Closed

acurionedotcms added a commit that referenced this issue Jan 8, 2018

#13309 - Oracle Upsert SQL

1cc3b0c

acurionedotcms added a commit that referenced this issue Jan 8, 2018

#13309 - Use constants and add documentation

afc3d8a

acurionedotcms added a commit that referenced this issue Jan 8, 2018

#13309 - H2 Upsert SQL

dd22c27

acurionedotcms added a commit that referenced this issue Jan 8, 2018

#13309 - Code review fixes

4fdf5e8

acurionedotcms added a commit that referenced this issue Jan 8, 2018

#13309 - Code review fixes

3c1b2ed

acurionedotcms added a commit that referenced this issue Jan 9, 2018

#13309 - Use UpsertPermissionCommand to simplify code for the Permiss…

f137750

…ionBitFactory

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Refactor to create a generic UpsertCommand

7af02e6

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Refactor to create a generic UpsertCommand

73ddded

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Refactor to create a generic UpsertCommand

cb8c251

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Refactor to create a generic UpsertCommand

99e685a

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Refactor to create a generic UpsertCommand

c38e9e1

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Create an UpsertCommandFactory object

c00d1c6

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Create an UpsertCommandFactory object

2c11bfe

acurionedotcms added a commit that referenced this issue Jan 11, 2018

#13309 - Rename UpsertCommandFactory.getInstance to getUpsertCommand

24ba827

dsilvam unassigned acurionedotcms Jan 11, 2018

dsilvam added Release : 5.0.0 WF : Needs QA Merged labels Jan 11, 2018

acurionedotcms added a commit that referenced this issue Jan 16, 2018

#13309 - Changes in the Upsert Command for Postgres -9.4

c5b3a5d

acurionedotcms added a commit that referenced this issue Jan 16, 2018

#13309 - Changes in the Upsert Command for Postgres -9.4

1c46907

dsilvam modified the milestones: Rex Current , Rex Next Jan 16, 2018

dsilvam pushed a commit that referenced this issue Jan 16, 2018

#13309 - Changes in the Upsert Command for Postgres -9.4 (#13403)

02a8bc0

* #13309 - Changes in the Upsert Command for Postgres -9.4 * #13309 - Changes in the Upsert Command for Postgres -9.4

shaydotcms added QA : Approved and removed WF : Needs QA labels Jan 16, 2018

wezell added the Changelog: Needs Doc label Jan 25, 2018

wezell closed this as completed Jan 25, 2018

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Webdav - Uploading multiple files to a New folder shows exception in log: ERROR db.DotConnect: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key" #13309

Webdav - Uploading multiple files to a New folder shows exception in log: ERROR db.DotConnect: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key" #13309

acurionedotcms commented Jan 4, 2018

shaydotcms commented Jan 16, 2018 •

edited

Loading

wezell commented Jan 25, 2018

Webdav - Uploading multiple files to a New folder shows exception in log: ERROR db.DotConnect: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key" #13309

Webdav - Uploading multiple files to a New folder shows exception in log: ERROR db.DotConnect: ERROR: duplicate key value violates unique constraint "permission_reference_asset_id_key" #13309

Comments

acurionedotcms commented Jan 4, 2018

shaydotcms commented Jan 16, 2018 • edited Loading

wezell commented Jan 25, 2018

shaydotcms commented Jan 16, 2018 •

edited

Loading