BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue

From: peter(dot)barzakov(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: peter(dot)barzakov(at)gmail(dot)com
Subject: BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue
Date: 2017-12-08 12:58:55
Message-ID: 20171208125855.21691.22528@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14955
Logged by: Petar Barzakov
Email address: peter(dot)barzakov(at)gmail(dot)com
PostgreSQL version: 10.1
Operating system: COS6
Description:

How to reproduce:
rpm -qa |grep postgres
ls -alh /var/lib/pgsql*
yum -q -y install postgresql10 postgresql10-contrib postgresql10-devel
postgresql10-libs postgresql10-server; echo $?
rpm -qa |grep postgres
ls -alh /var/lib/pgsql*
rpm -qf /var/lib/pgsql/10/data/
ls -alh /var/lib/pgsql/10/*/
/etc/init.d/postgresql-10 initdb
ls -alh /var/lib/pgsql/10/*/
ls -alh /var/lib/pgsql/10/
cat /var/lib/pgsql/10/pgstartup.log
rm -rf /var/lib/pgsql/10/data
ls -alh /var/lib/pgsql/10/*/
ls -alh /var/lib/pgsql/10/

Issue:
[root(at)localhost ~]# rpm -qa |grep postgres
[root(at)localhost ~]# ls -alh /var/lib/pgsql*
ls: cannot access /var/lib/pgsql*: No such file or directory
[root(at)localhost ~]# yum -q -y install postgresql10 postgresql10-contrib
postgresql10-devel postgresql10-libs postgresql10-server; echo $?
0
[root(at)localhost ~]# rpm -qa |grep postgres
postgresql10-10.1-3PGDG.rhel6.x86_64
postgresql10-server-10.1-3PGDG.rhel6.x86_64
postgresql10-libs-10.1-3PGDG.rhel6.x86_64
postgresql10-devel-10.1-3PGDG.rhel6.x86_64
postgresql10-contrib-10.1-3PGDG.rhel6.x86_64
[root(at)localhost ~]# ls -alh /var/lib/pgsql*
total 16K
drwx------ 3 postgres postgres 4.0K Dec 8 07:53 .
drwxr-xr-x 13 root root 4.0K Dec 8 07:53 ..
drwx------ 4 postgres postgres 4.0K Dec 8 07:53 10
-rwx------ 1 postgres postgres 266 Dec 8 07:53 .bash_profile
[root(at)localhost ~]# rpm -qf /var/lib/pgsql/10/data/
postgresql10-server-10.1-3PGDG.rhel6.x86_64
[root(at)localhost ~]# ls -alh /var/lib/pgsql/10/*/
/var/lib/pgsql/10/backups/:
total 8.0K
drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..

/var/lib/pgsql/10/data/:
total 8.0K
drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..
[root(at)localhost ~]# /etc/init.d/postgresql-10 initdb
Initializing database: [FAILED]
[root(at)localhost ~]# ls -alh /var/lib/pgsql/10/*/
/var/lib/pgsql/10/backups/:
total 8.0K
drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..

/var/lib/pgsql/10/data/:
total 12K
drwx------ 3 postgres postgres 4.0K Dec 8 07:53 .
drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..
drwx------ 2 postgres postgres 4.0K Dec 8 07:53 log
[root(at)localhost ~]# ls -alh /var/lib/pgsql/10/
total 16K
drwx------ 4 postgres postgres 4.0K Dec 8 07:53 .
drwx------ 3 postgres postgres 4.0K Dec 8 07:53 ..
drwx------ 2 postgres postgres 4.0K Dec 7 14:37 backups
drwx------ 3 postgres postgres 4.0K Dec 8 07:53 data
-rw------- 1 postgres postgres 0 Dec 8 07:53 pgstartup.log
[root(at)localhost ~]# cat /var/lib/pgsql/10/pgstartup.log
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

initdb: directory "/var/lib/pgsql/10/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/var/lib/pgsql/10/data" or run initdb
with an argument other than "/var/lib/pgsql/10/data".
[root(at)localhost ~]# rm -rf /var/lib/pgsql/10/data
[root(at)localhost ~]# ls -alh /var/lib/pgsql/10/*/
total 8.0K
drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
drwx------ 3 postgres postgres 4.0K Dec 8 07:53 ..
[root(at)localhost ~]# ls -alh /var/lib/pgsql/10/
total 16K
drwx------ 3 postgres postgres 4.0K Dec 8 07:53 .
drwx------ 3 postgres postgres 4.0K Dec 8 07:53 ..
drwx------ 2 postgres postgres 4.0K Dec 7 14:37 backups
-rw------- 1 postgres postgres 599 Dec 8 07:53 pgstartup.log

[root(at)localhost ~]# rm -rf /var/lib/pgsql/10/
[root(at)localhost ~]# /etc/init.d/postgresql-10 initdb
Initializing database: [FAILED]
[root(at)localhost ~]# cat /var/lib/pgsql/10/pgstartup.log
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

initdb: directory "/var/lib/pgsql/10/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/var/lib/pgsql/10/data" or run initdb
with an argument other than "/var/lib/pgsql/10/data".
[root(at)localhost ~]#

What is the issue:
---
etc-postgresql10-server-10.1-2PGDG.rhel6.x86_64.rpm/rc.d/init.d/postgresql-10 2017-11-30
06:05:20.000000000 -0500
+++
etc-postgresql10-server-10.1-3PGDG.rhel6.x86_64.rpm/rc.d/init.d/postgresql-10 2017-12-07
14:37:26.000000000 -0500
@@ -250,7 +250,7 @@
initdbcmd="$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'
$LOCALESTRING"
initdbcmd+=" $PGSETUP_INITDB_OPTIONS"

- $SU -l postgres -c "$initdbcmd" >> "\$PGLOG\" 2>&1 &"
+ $SU -l postgres -c "$initdbcmd >> \"$PGLOG\" 2>&1 &"

# Create directory for postmaster log
mkdir "$PGDATA/log"
@@ -340,7 +340,7 @@
su -l postgres -c "$PGENGINE/pg_upgrade \
-b /usr/pgsql-$PGPREVMAJORVERSION/bin/ -B $PGENGINE/ \
-d $OLDPGDATA -D $NEWPGDATA \
- -p $OLDPGPORT -P $NEWPGPORT" >> "$PGUPLOG" 2>&1 &
+ -p $OLDPGPORT -P $NEWPGPORT >> \"$PGUPLOG\" 2>&1 &"
else
echo "Cluster check failed. Please see the output above."
exit 1
[root(at)localhost ~]#

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2017-12-08 14:44:48 Re: BUG #14952: COPY fails to fill in IDENTITY column default value
Previous Message Alexander Korotkov 2017-12-08 11:50:20 Re: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug