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

вт, 3 мар. 2020 г. в 03:39, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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