Message-ID: <e641c8f4-7827-0909-c66b-ffaf8277db2b@proventis.net>
Date: Mon, 7 Feb 2022 06:39:15 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: org.postgresql.util.PSQLException: ERROR: value out of range:
 underflow
Content-Language: en-US
To: pgsql-jdbc@lists.postgresql.org
References: <09536b3a-2ec9-64da-8630-caf7d50c758c@proventis.net>
 <720183.1644165943@sss.pgh.pa.us>
From: Thomas Markus <t.markus@proventis.net>
In-Reply-To: <720183.1644165943@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: 
	=?utf-8?B?WFc0eWRXVUQ1OFJqQVhzWVRTRlN2THl2S3FlMjFaRmlYZ0NDVDNUYU9KM3JZ?=
 =?utf-8?B?N3VKdnlQYzVCWURoYTJOdnVMRit6V1NnUmx4T0FYVnhHZE1YOS9NZlEwUk5s?=
 =?utf-8?B?dEVKNzNaNkRyaGhXYjdjMTRITVhZYmd5bG5GQkJmblJmVjIxT0dsNUl0Qndp?=
 =?utf-8?B?N0c1UWNERXJybUQ2bnIzbDRsaFVLRExMK2N0Y0FwTzFyWGdHSTlVRGR2N1dX?=
 =?utf-8?B?dnJQRzlWN2hFQ2JBbENISmcwcTQ3QU1zeFp4SzlVYkhzQUhMY3l1azQxVFcr?=
 =?utf-8?B?ZndqV3FyWFRUMm5vTFNYNURmSng5VlVNM0xzMjB1Tk5SekJVdGxZTFk0MDRk?=
 =?utf-8?B?TzZPbUxZM1IyVTA0ejdNUXNoSkwxempVMFRiNjFYaE5rQXVmaFN4eWttNStv?=
 =?utf-8?B?L0s3QnJBenNuYjMzOWhsL1dwNHhXUGY3ekJpV20vRUIrMENBWmpVNEhYcTlu?=
 =?utf-8?B?azAySjZYNVkrOXE4WUlySjM4YlFkVEpRbVludk90WHg0SWZSYjhvdUxhZnJk?=
 =?utf-8?B?YkJLVFc5MkNaM3BNT1dycDFidllmbE9CalMxN3B1QTNwUlpOWVk2V3UwekNZ?=
 =?utf-8?B?SnU4WUlBanRrQ0JXZ2VBNXNMN2s2OE1vMEVxcXJzZ0FJS1gwWlQwL2hPOWl4?=
 =?utf-8?B?T3JCQlN6d2hJQjR6MkU3cE10NmFXME12Y1F0WVk2TW5VNDloYVpEV1BKbzda?=
 =?utf-8?B?UjA0UkFrV1Fad2VpRUErWTZrelduTzNWNjlEeDRCTVBZN0FBYldMMGl5dHFU?=
 =?utf-8?B?ajFwanl5YzNFaHpvT2JJTkpXSEhYWTJKNCtXcDhLVWNYWFpOSEtzTGdyZk41?=
 =?utf-8?B?TnF0bU00T1BTNm80L1JMWFhXUy9Sd1hic012UTBPSUZLN1BQWDNSZFF5N2l5?=
 =?utf-8?B?M1hqOEhDMnRhWG02U2ZWVGQyS2lPZHpGckpKWW5qVGc1STVvMVBVN1dBejBt?=
 =?utf-8?B?TTR5S1ZHUjA2eURhZW5IVU5hZUsweGhUUEpiaEJ1eE05UTlUM2JmRm45bTQ1?=
 =?utf-8?B?UG55UjQ2VHZEemE3bU9wZzk1OWNCM01HenA5SzRYdCtTNTY1eWgvN2x1cVhw?=
 =?utf-8?B?dzAzQkZOc0p3U2RsZGNzSWlxVFMzaWJJdzhXak92eWFqUG05NVprcmF6VHln?=
 =?utf-8?B?YnNMeWEvajZPV2JEa1BuVjAzVlJ3RFRGRFl4N0JIcXFlbjZqVm0ra1l5TU5t?=
 =?utf-8?B?S0NDN2VjRXRhT0VJRTE0N0VNRzdYUUtKY21yQjM2UG4rdFllcWl0U3Y1c3Rl?=
 =?utf-8?B?TUx0NjFzckFIWTNmaWc5TmxPU2R3d0RYSURqZlJNVTY5T3FJa1R1bTFrbktJ?=
 =?utf-8?B?cnM0Q3BBOTVBejE2K29lV2Y4dkJUWFdqSWN1YkxnUHVBQjZrRWt1NkhzMkpl?=
 =?utf-8?B?bHN6UmhOcmd0WVZBLzdsRHo5L25mL25qMmtQeGxaN3VXVHF5ZmVVT21LeTht?=
 =?utf-8?B?YjFnNFFjTmRkTGdoOFlTMlAxRDRqR0dIekFRaHVrczBRSHcrbjdBTmJ6VzVr?=
 =?utf-8?B?RGFBM1Bra3NyU09DRXpvbGphTG8wUnZIdEN0YVQ0NklEMDR6NFJFcjhTZTNn?=
 =?utf-8?B?RlJ3TkR2L1FXaFkvY3lFTkExYUJrM0xjTHIvaHl0Mlljaks5WlZFS0ZvZDdZ?=
 =?utf-8?B?WXYvL3pjMk9VWnV4b3NlZmw4YytkZUI2ekFBYWpkUDM4d1RTd3BPT3RiSGt6?=
 =?utf-8?B?dnZsSlpVU1ROVmcwQ3lJUlJVS0dlMWFZZ3Mzb3ExanMzQ0duam9LRDI1VnBx?=
 =?utf-8?B?RjBoVXJWVXI4Y0VvRkRsdU5GMEp1R1NkcHF2aVFyQ1hvS3orOFNOR0ducUV1?=
 =?utf-8?B?RVdER3ZPMUU4RmtnZjFjbUVzVUJENWxONHNKd1ZwVTF0OVN3Vy9nRThXZjJN?=
 =?utf-8?B?aHRsN1VQd2hQbEJYYVBBQmo2ZGtGaWZzcUIybWtFbG03UFYreUZjbmZHaWF3?=
 =?utf-8?B?bUkzNEhBTFRCZExWZ2JKWjREdDhFcWczcXNBb1ZkMUJNZnVIS3drc2JxVEFh?=
 =?utf-8?B?SjZwemRCUVZscEVPSWV4Q3B2SzNzZmZPMG1FQXlrVWV6V3Y3VWUwaHJiZnNR?=
 =?utf-8?B?SDlhWWxWSkFrWE5ZZFdCcCthbWg2SE5yQTVkVituSTVHWkRuQ0JKQkZTY05z?=
 =?utf-8?B?UjB1bGxvR2hqRUtJNWE3Sjdvbms1dnVaWW5ZYkdhSkZNRkpUQWRlTVRoYW1m?=
 =?utf-8?B?TzVhZTZhdTdNN2RKT2YrZDRaOTdBQ1JHdXFKaEJKSDRGL2hFMlpYMEpBRDgr?=
 =?utf-8?Q?ncZaMb3ZUWUwIO8eOwQEf4tUTEEqtkHWA0rD69ueoo=3D?=
X-OriginatorOrg: proventis.net
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 f8de3104-9550-420d-c904-08d9e9fc2ea4
X-MS-Exchange-CrossTenant-AuthSource: AM9PR02MB6850.eurprd02.prod.outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 07 Feb 2022 05:39:17.7604
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 0e59f2ee-7c21-4d61-980f-e7d935278c0f
X-MS-Exchange-CrossTenant-MailboxType: HOSTED
X-MS-Exchange-CrossTenant-UserPrincipalName: 
 UF0REMgA2bcU5lDFfwY0LA7D1QNg0E0o+mcYWCLl5mxzFWx3K8SBXztuoI52P5sH67xSLy1FMeF/kFNTjVbqUg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS8PR02MB6887
List-Id: <pgsql-jdbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-jdbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-jdbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-jdbc>
Archived-At: 
 <https://www.postgresql.org/message-id/e641c8f4-7827-0909-c66b-ffaf8277db2b%40proventis.net>
Precedence: bulk


Am 06.02.22 um 17:45 schrieb Tom Lane:
> Thomas Markus <t.markus@proventis.net> writes:
>> a customer got the exception "org.postgresql.util.PSQLException: ERROR:
>> value out of range: underflow" without any stacktrace etc.
> I'd venture that the cause is some server-side double precision
> arithmetic that underflowed.  It's not that hard to hit, eg
>
> postgres=# select 1e-200::float8 * 1e-200::float8;
> ERROR:  value out of range: underflow
>
> 			regards, tom lane
>
>
Dave answered private here:

A double in java cant hold such big numbers. In fits fine in float8
Here one of our developers added a float4 column manually instead of 
float8. With float4 its easy to force that error.

regards
Thomas