Re: BUG #16285: bt_metap fails with value is out of range for type integer

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: BUG #16285: bt_metap fails with value is out of range for type integer
Дата
Msg-id CAGnEbogyKh_UN1n_fGvmb_O5AWHdHvHipmktfvBFzRKw66z33w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16285: bt_metap fails with value is out of range for typeinteger  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: BUG #16285: bt_metap fails with value is out of range for type integer  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-bugs
вт, 3 мар. 2020 г. в 03:39, Alvaro Herrera <alvherre@2ndquadrant.com>:
I understand it's gone now, but you could have used \errverbose to
display the source function name that caused the error, followed by
setting backtrace_functions to that function and repeated the query.
That may have resulted in a more precise location of the problem.

It is not entirely gone, I still have some indexes around that produce this.
This backtracing functionality is available only in the HEAD as far as I can see, so it took me a while
to get to it:

[3760] ERROR:  value "4282444360" is out of range for type integer
[3760] BACKTRACE:
        postgres: postgres postgres [local] SELECT(pg_strtoint32+0xdf) [0x55ab094e4d7f]
        postgres: postgres postgres [local] SELECT(int4in+0xd) [0x55ab094acc5d]
        postgres: postgres postgres [local] SELECT(InputFunctionCall+0x7b) [0x55ab095675ab]
        postgres: postgres postgres [local] SELECT(BuildTupleFromCStrings+0xa7) [0x55ab093066a7]
        /var/lib/postgresql/opt/pg13devel/lib/pageinspect.so(bt_metap+0x199) [0x7f7ec35b7619]
        postgres: postgres postgres [local] SELECT(ExecMakeTableFunctionResult+0x40b) [0x55ab09302f0b]
        postgres: postgres postgres [local] SELECT(+0x27bd11) [0x55ab09311d11]
        postgres: postgres postgres [local] SELECT(ExecScan+0x7b) [0x55ab0930381b]
        postgres: postgres postgres [local] SELECT(standard_ExecutorRun+0x102) [0x55ab092fa3f2]
        postgres: postgres postgres [local] SELECT(+0x3b6d3d) [0x55ab0944cd3d]
        postgres: postgres postgres [local] SELECT(PortalRun+0x2ba) [0x55ab0944e17a]
        postgres: postgres postgres [local] SELECT(+0x3b3d07) [0x55ab09449d07]
        postgres: postgres postgres [local] SELECT(PostgresMain+0x1df6) [0x55ab0944c046]
        postgres: postgres postgres [local] SELECT(+0x33de85) [0x55ab093d3e85]
        postgres: postgres postgres [local] SELECT(PostmasterMain+0xf40) [0x55ab093d5000]
        postgres: postgres postgres [local] SELECT(main+0x4a4) [0x55ab09154964]
        /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7) [0x7f7ecd26eb97]
        postgres: postgres postgres [local] SELECT(_start+0x2a) [0x55ab09154a2a]
[3760] STATEMENT:  select * from bt_metap('table_pkey');


--
Victor Yegorov

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #16285: bt_metap fails with value is out of range for type integer
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan"