From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: t.larionov@postgrespro.ru
Subject: BUG #16953: OOB access while converting "interval" to char
Date: Wed, 07 Apr 2021 09:09:25 +0000
Message-ID: <16953-f255a18f8c51f1d5@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16953
Logged by: Theodor Arsenij Larionov-Trichkin
Email address: t.larionov@postgrespro.ru
PostgreSQL version: 13.2
Operating system: Ubuntu 20.04.2 LTS
Description:
Hello!
How to reproduce:
1. mkdir -p ./installation/databases
2. git clone --single-branch --depth=1 --branch=REL_13_2
https://github.com/postgres/postgres postgres_src
3. cd postgres_src
4. ./configure --prefix=`pwd`/../installation/pgbuild
5. make -j20 && make install && cd ..
6. ./installation/pgbuild/bin/initdb -U username -D
./installation/databases/db_clean
7. ./installation/pgbuild/bin/postgres -D
./installation/databases/db_clean/
8. ./installation/pgbuild/bin/psql -h 127.0.0.1 -p 5432 -U username
postgres
9. Performing this query will result in OOB access of rm_months_lower array
and as a result crash: SELECT * from TO_CHAR(interval '-1Mon', 'rm');
Output:
2021-04-07 12:07:27.060 MSK [33887] LOG: starting PostgreSQL 13.2 on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0,
64-bit
2021-04-07 12:07:27.060 MSK [33887] LOG: listening on IPv4 address
"127.0.0.1", port 5432
2021-04-07 12:07:27.065 MSK [33887] LOG: listening on Unix socket
"/tmp/.s.PGSQL.5432"
2021-04-07 12:07:27.069 MSK [33888] LOG: database system was shut down at
2021-04-07 12:07:22 MSK
2021-04-07 12:07:27.071 MSK [33887] LOG: database system is ready to accept
connections
2021-04-07 12:08:01.013 MSK [33887] LOG: server process (PID 34113) was
terminated by signal 11: Segmentation fault
2021-04-07 12:08:01.013 MSK [33887] DETAIL: Failed process was running:
SELECT * from TO_CHAR(interval '-1Mon', 'rm');
2021-04-07 12:08:01.013 MSK [33887] LOG: terminating any other active
server processes
2021-04-07 12:08:01.013 MSK [33892] WARNING: terminating connection because
of crash of another server process
2021-04-07 12:08:01.013 MSK [33892] DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2021-04-07 12:08:01.013 MSK [33892] HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2021-04-07 12:08:01.013 MSK [35036] FATAL: the database system is in
recovery mode
2021-04-07 12:08:01.014 MSK [33887] LOG: all server processes terminated;
reinitializing
2021-04-07 12:08:01.027 MSK [35038] LOG: database system was interrupted;
last known up at 2021-04-07 12:07:27 MSK
2021-04-07 12:08:01.248 MSK [35038] LOG: database system was not properly
shut down; automatic recovery in progress
2021-04-07 12:08:01.249 MSK [35038] LOG: redo starts at 0/1559798
2021-04-07 12:08:01.249 MSK [35038] LOG: invalid record length at
0/15597D0: wanted 24, got 0
2021-04-07 12:08:01.249 MSK [35038] LOG: redo done at 0/1559798
2021-04-07 12:08:01.256 MSK [33887] LOG: database system is ready to accept
connections
Postgres version:
PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, t.larionov@postgrespro.ru
Subject: Re: BUG #16953: OOB access while converting "interval" to char
In-Reply-To: <16953-f255a18f8c51f1d5@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox