-
Type:
Bug
-
Status: Closed
-
Resolution: No Longer Reproducible
-
Affects Version/s: 5.2.3
-
Fix Version/s: 6.0.6 GA
-
Component/s: Environments > Databases
-
Labels:None
For example below in a sample of our production data, the leftOrganizationId and rightOrganizationId column values are so large I believe they are throwing an exception in the getLastRightOrganizationId method of the com.liferay.portal.service.persistence.OrganizationPersistenceImpl class:
7492237,10121,11717,1990,1991,01769000,regular-organization,1,0,0,12017,
7492245,10121,7492237,1.29385074514233E19,8.93731168670628E16,01769000-YL-7,regular-organization,1,0,0,12017,
7492254,10121,7492237,1.3091341456612E19,8.93731168670628E16,01769000-YL-8,regular-organization,1,0,0,12017,
7492266,10121,7492237,1.29385074514233E19,8.93731168670628E16,01769000-YL-9,regular-organization,1,0,0,12017,
First problem, how did the leftOrganizationId and rightOrganizationId column values get so large when the parent organization id 7492237 leftOrganizationId and rightOrganizationId column values are only 1990 and 1991.
Second problem, the numeric overflow exception might possibly be caused in the getLastRightOrganizationId method of the com.liferay.portal.service.persistence.OrganizationPersistenceImpl class when converting a value 8.93731168670628E16 to a long?