Duplicate requests are made when interacting with the search page

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X, 7.2.X, Master
• Fix Version/s: 7.1.10 DXP FP16, 7.1.X, 7.2.10 DXP FP5, 7.2.10.2 DXP SP2, 7.2.X, 7.3.0 CE GA1, 7.3.10 DXP GA1, Master
• Component/s: Fault Tolerance, Performance > Caching Infrastructure, Web Search > Search Widgets
• Labels:
  • QA-AUTOMATION
  • ee-bp
  • liferay-dxp-72-sp2
  • liferay-fixpack-dxp-16-7110
  • liferay-fixpack-dxp-5-7210
• Branch Version/s:
  7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Sprint: Search | S03 Sprint 8
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/80992
• QA Test Name:
  • LocalFile.DocumentsadministrationUsecase#ViewDocumentWithGlobalScope
  • LocalFile.Elasticsearch6#ElasticsearchRemoteClusterSmokeTest
  • LocalFile.PGDocumentsandmedia#SearchContentDocument
  • LocalFile.PGDocumentsandmedia#SearchDocument
  • LocalFile.PGDocumentsandmedia#SearchFolderDocument
  • LocalFile.PGDocumentsandmedia#SearchFolderImage
  • LocalFile.PGDocumentsandmedia#SearchSubFolderDocument
  • LocalFile.Search#ViewSearchResultDetails
  • LocalFile.SolrSearch#ViewSearchResultDetails
  • Manual_Environment_Staging_Local
• QA Test Score: 45

Steps to reproduce:

1. Start up a fresh bundle
2. Search for "test"

Result: Either during startup or when searching the following error will occur. No functional impact.

2018-02-23 00:33:21.489 ERROR [http-nio-8080-exec-3][JDBCExceptionReporter:234] Duplicate entry '20124-3-0-com_liferay_portal_search_web_portlet_SearchPortlet' for key 'IX_C7057FF7'
2018-02-23 00:33:21.489 ERROR [http-nio-8080-exec-12][JDBCExceptionReporter:234] Duplicate entry '20124-3-0-com_liferay_portal_search_web_portlet_SearchPortlet' for key 'IX_C7057FF7'
2018-02-23 00:33:25.415 ERROR [http-nio-8080-exec-3][JDBCExceptionReporter:234] Duplicate entry '20124-3-0-com_liferay_product_navigation_user_personal_bar_web_p' for key 'IX_C7057FF7'
2018-02-23 00:33:25.415 ERROR [http-nio-8080-exec-7][JDBCExceptionReporter:234] Duplicate entry '20124-3-0-com_liferay_product_navigation_user_personal_bar_web_p' for key 'IX_C7057FF7'
2018-02-23 00:33:25.420 ERROR [http-nio-8080-exec-3][JDBCExceptionReporter:234] Duplicate entry '0-3-20127-com_liferay_product_navigation_user_personal_bar_web_p' for key 'IX_C7057FF7'
2018-02-23 00:33:25.421 ERROR [http-nio-8080-exec-7][JDBCExceptionReporter:234] Duplicate entry '0-3-20127-com_liferay_product_navigation_user_personal_bar_web_p' for key 'IX_C7057FF7'
2018-02-23 00:33:25.463 ERROR [http-nio-8080-exec-3][JDBCExceptionReporter:234] Duplicate entry '20124-3-0-com_liferay_site_navigation_menu_web_portlet_SiteNavig' for key 'IX_C7057FF7'
2018-02-23 00:33:25.463 ERROR [http-nio-8080-exec-12][JDBCExceptionReporter:234] Duplicate entry '20124-3-0-com_liferay_site_navigation_menu_web_portlet_SiteNavig' for key 'IX_C7057FF7'
2018-02-23 00:33:25.468 ERROR [http-nio-8080-exec-3][JDBCExceptionReporter:234] Duplicate entry '0-3-20127-com_liferay_site_navigation_menu_web_portlet_SiteNavig' for key 'IX_C7057FF7'
2018-02-23 00:33:25.475 ERROR [http-nio-8080-exec-12][JDBCExceptionReporter:234] Duplicate entry '0-3-20127-com_liferay_site_navigation_menu_web_portlet_SiteNavig' for key 'IX_C7057FF7'

Reproduced on:
Tomcat 8.0.32 + MySQL 5.7.21
Portal Master Git SHA: 14aeacf6b40c10c73b2e35bec61e99bf4bdacdde