:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: [ LOG ] :: Check :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: postgresql-server-9.3.5-1.fc20.x86_64 :: [ PASS ] :: Checking for the presence of postgresql-server rpm :: [ 13:12:07 ] :: Package versions: :: [ 13:12:07 ] :: postgresql-server-9.3.5-1.fc20.x86_64 :: [ PASS ] :: service postgresql should be stopped (Assert: 3 should equal 3) :: [ PASS ] :: File /var/lib/pgsql/data/PG_VERSION should not exist :: [ PASS ] :: run under root user (Assert: expected 0, got 0) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: [ LOG ] :: Test :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: --> Performing upgrade: fedora-19 - upgrade downloading 'http://pensioner.lab.eng.brq.redhat.com/root-tests/data/postgresql//fedora/19/x86_64/locale-utf-typo.tar.gz' % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 9789k 0 13482 0 0 11281 0 0:14:48 0:00:01 0:14:47 11282 3 9789k 3 299k 0 0 137k 0 0:01:11 0:00:02 0:01:09 137k 14 9789k 14 1400k 0 0 440k 0 0:00:22 0:00:03 0:00:19 440k 35 9789k 35 3514k 0 0 841k 0 0:00:11 0:00:04 0:00:07 841k 42 9789k 42 4188k 0 0 808k 0 0:00:12 0:00:05 0:00:07 850k 73 9789k 73 7221k 0 0 1168k 0 0:00:08 0:00:06 0:00:02 1446k 99 9789k 99 9721k 0 0 1354k 0 0:00:07 0:00:07 --:--:-- 1884k 100 9789k 100 9789k 0 0 1357k 0 0:00:07 0:00:07 --:--:-- 2081k :: [ BEGIN ] :: Running 'postgresql-setup upgrade' Upgrading database: failed See /var/lib/pgsql/pgupgrade.log for details. :: [ FAIL ] :: Command 'postgresql-setup upgrade' (Expected 0, got 1) ====== reading log /var/lib/pgsql/pgupgrade.log ====== Performing Consistency Checks ----------------------------- Checking cluster versions ok Checking database user is a superuser ok Checking for prepared transactions ok Checking for reg* system OID user data types ok Checking for contrib/isn with bigint-passing mismatch ok Creating dump of global objects ok Creating dump of database schemas pagila postgres template1 ok lc_collate cluster values do not match: old "en_US.utf8", new "en_US.UTF-8" Failure, exiting ====== reading log /var/lib/pgsql/pg_upgrade_dump_1.log ====== command: "/usr/bin/pg_dump" --host "/var/lib/pgsql" --port 5432 --username "postgres" --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file="pg_upgrade_dump_1.custom" "template1" >> "pg_upgrade_dump_1.log" 2>&1 ====== reading log /var/lib/pgsql/pg_upgrade_dump_16384.log ====== command: "/usr/bin/pg_dump" --host "/var/lib/pgsql" --port 5432 --username "postgres" --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file="pg_upgrade_dump_16384.custom" "pagila" >> "pg_upgrade_dump_16384.log" 2>&1 ====== reading log /var/lib/pgsql/pg_upgrade_internal.log ====== ----------------------------------------------------------------- pg_upgrade run on Mon Oct 20 13:12:18 2014 ----------------------------------------------------------------- Performing Consistency Checks ----------------------------- Checking cluster versions ok Checking database user is a superuser ok Checking for prepared transactions ok Checking for reg* system OID user data types ok Checking for contrib/isn with bigint-passing mismatch ok Creating dump of global objects ok Creating dump of database schemas ok lc_collate cluster values do not match: old "en_US.utf8", new "en_US.UTF-8" ====== reading log /var/lib/pgsql/pg_upgrade_dump_12923.log ====== command: "/usr/bin/pg_dump" --host "/var/lib/pgsql" --port 5432 --username "postgres" --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file="pg_upgrade_dump_12923.custom" "postgres" >> "pg_upgrade_dump_12923.log" 2>&1 ====== reading log /var/lib/pgsql/pg_upgrade_server.log ====== ----------------------------------------------------------------- pg_upgrade run on Mon Oct 20 13:12:18 2014 ----------------------------------------------------------------- command: "/usr/lib64/pgsql/postgresql-9.2/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql/data-old" -o "-p 5432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start >> "pg_upgrade_server.log" 2>&1 waiting for server to start.... done server started command: "/usr/lib64/pgsql/postgresql-9.2/bin/pg_ctl" -w -D "/var/lib/pgsql/data-old" -o "" stop >> "pg_upgrade_server.log" 2>&1 waiting for server to shut down.... done server stopped command: "/usr/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql/data" -o "-p 5432 -b -c autovacuum_multixact_freeze_max_age=2000000000 -c synchronous_commit=off -c fsync=off -c full_page_writes=off -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/lib/pgsql'" start >> "pg_upgrade_server.log" 2>&1 waiting for server to start....LOG: redirecting log output to logging collector process HINT: Future log output will appear in directory "pg_log". done server started command: "/usr/bin/pg_ctl" -w -D "/var/lib/pgsql/data" -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1 waiting for server to shut down.... done server stopped ====== reading log /var/lib/pgsql/pg_upgrade_utility.log ====== ----------------------------------------------------------------- pg_upgrade run on Mon Oct 20 13:12:18 2014 ----------------------------------------------------------------- command: "/usr/bin/pg_dumpall" --host "/var/lib/pgsql" --port 5432 --username "postgres" --schema-only --globals-only --quote-all-identifiers --binary-upgrade -f pg_upgrade_dump_globals.sql >> "pg_upgrade_utility.log" 2>&1 ====== reading log /var/lib/pgsql/initdb.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. fixing permissions on existing directory /var/lib/pgsql/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB creating configuration files ... ok creating template1 database in /var/lib/pgsql/data/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating collations ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok creating information schema ... ok loading PL/pgSQL server-side language ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok syncing data to disk ... ok Success. You can now start the database server using: /usr/bin/postgres -D /var/lib/pgsql/data or /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start 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. fixing permissions on existing directory /var/lib/pgsql/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB creating configuration files ... ok creating template1 database in /var/lib/pgsql/data/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating collations ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok creating information schema ... ok loading PL/pgSQL server-side language ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok syncing data to disk ... ok Success. You can now start the database server using: /usr/bin/postgres -D /var/lib/pgsql/data or /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start Redirecting to /bin/systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) Active: inactive (dead) Oct 20 13:12:02 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Starting PostgreSQL database server... Oct 20 13:12:02 57a7eebc499471a2de566d478b623090---dbtests pg_ctl[1114]: LOG: redirecting log output to logging collector process Oct 20 13:12:02 57a7eebc499471a2de566d478b623090---dbtests pg_ctl[1114]: HINT: Future log output will appear in directory "pg_log". Oct 20 13:12:03 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Started PostgreSQL database server. Oct 20 13:12:04 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Stopping PostgreSQL database server... Oct 20 13:12:05 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Stopped PostgreSQL database server. Redirecting to /bin/systemctl start postgresql.service Job for postgresql.service failed. See 'systemctl status postgresql.service' and 'journalctl -xn' for details. :: [ 13:12:24 ] :: [ ERROR ] :: rlServiceStart: Starting service postgresql failed :: [ 13:12:24 ] :: [ ERROR ] :: Status of the failed service: :: [ 13:12:24 ] :: Redirecting to /bin/systemctl status postgresql.service :: [ 13:12:24 ] :: postgresql.service - PostgreSQL database server :: [ 13:12:24 ] :: Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) :: [ 13:12:24 ] :: Active: failed (Result: exit-code) since Mon 2014-10-20 13:12:24 UTC; 248ms ago :: [ 13:12:24 ] :: Process: 1708 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE) :: [ 13:12:24 ] :: :: [ 13:12:25 ] :: Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: An old version of the database format was found. :: [ 13:12:25 ] :: Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: Use "postgresql-setup upgrade" to upgrade to version 9.3. :: [ 13:12:25 ] :: Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: See /usr/share/doc/postgresql/README.rpm-dist for more information. :: [ 13:12:25 ] :: Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: postgresql.service: control process exited, code=exited status=1 :: [ 13:12:25 ] :: Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Failed to start PostgreSQL database server. :: [ 13:12:25 ] :: Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Unit postgresql.service entered failed state. :: [ FAIL ] :: service postgresql should be started (Assert: 3 should equal 0) Redirecting to /bin/systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) Active: failed (Result: exit-code) since Mon 2014-10-20 13:12:24 UTC; 1s ago Process: 1708 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE) Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: An old version of the database format was found. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: Use "postgresql-setup upgrade" to upgrade to version 9.3. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: See /usr/share/doc/postgresql/README.rpm-dist for more information. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: postgresql.service: control process exited, code=exited status=1 Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Failed to start PostgreSQL database server. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Unit postgresql.service entered failed state. :: [ PASS ] :: service postgresql should be stopped (Assert: 3 should equal 3) --> Performing upgrade: fedora-20 - run downloading 'http://pensioner.lab.eng.brq.redhat.com/root-tests/data/postgresql//fedora/20/x86_64/locale-utf-typo.tar.gz' % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 9936k 0 1002 0 0 1584 0 1:47:03 --:--:-- 1:47:03 1582 0 9936k 0 88362 0 0 56251 0 0:03:00 0:00:01 0:02:59 56245 7 9936k 7 713k 0 0 280k 0 0:00:35 0:00:02 0:00:33 280k 26 9936k 26 2621k 0 0 738k 0 0:00:13 0:00:03 0:00:10 738k 47 9936k 47 4695k 0 0 1032k 0 0:00:09 0:00:04 0:00:05 1032k 66 9936k 66 6620k 0 0 1193k 0 0:00:08 0:00:05 0:00:03 1346k 86 9936k 86 8551k 0 0 1305k 0 0:00:07 0:00:06 0:00:01 1700k 100 9936k 100 9936k 0 0 1373k 0 0:00:07 0:00:07 --:--:-- 1967k Redirecting to /bin/systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) Active: failed (Result: exit-code) since Mon 2014-10-20 13:12:24 UTC; 9s ago Process: 1708 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE) Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: An old version of the database format was found. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: Use "postgresql-setup upgrade" to upgrade to version 9.3. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: See /usr/share/doc/postgresql/README.rpm-dist for more information. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: postgresql.service: control process exited, code=exited status=1 Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Failed to start PostgreSQL database server. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Unit postgresql.service entered failed state. Redirecting to /bin/systemctl start postgresql.service :: [ 13:12:34 ] :: rlServiceStart: Service postgresql started successfully :: [ PASS ] :: service postgresql should be started (Assert: 0 should equal 0) Redirecting to /bin/systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) Active: active (running) since Mon 2014-10-20 13:12:34 UTC; 274ms ago Process: 1926 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS) Process: 1921 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS) Main PID: 1931 (postgres) CGroup: /system.slice/postgresql.service ├─1931 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432 ├─1939 postgres: logger process ├─1951 postgres: checkpointer process ├─1952 postgres: writer process ├─1953 postgres: wal writer process ├─1954 postgres: autovacuum launcher process └─1955 postgres: stats collector process Oct 20 13:12:33 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Starting PostgreSQL database server... Oct 20 13:12:33 57a7eebc499471a2de566d478b623090---dbtests pg_ctl[1926]: LOG: redirecting log output to logging collector process Oct 20 13:12:33 57a7eebc499471a2de566d478b623090---dbtests pg_ctl[1926]: HINT: Future log output will appear in directory "pg_log". Oct 20 13:12:34 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Started PostgreSQL database server. Redirecting to /bin/systemctl stop postgresql.service :: [ PASS ] :: service postgresql should be stopped (Assert: 3 should equal 3) :: [ FAIL ] :: test wrapper should finish successfully (Assert: expected 0, got 1) :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: [ LOG ] :: Cleanup :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: Redirecting to /bin/systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled) Active: inactive (dead) Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests postgresql-check-db-dir[1708]: See /usr/share/doc/postgresql/README.rpm-dist for more information. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: postgresql.service: control process exited, code=exited status=1 Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Failed to start PostgreSQL database server. Oct 20 13:12:24 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Unit postgresql.service entered failed state. Oct 20 13:12:33 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Starting PostgreSQL database server... Oct 20 13:12:33 57a7eebc499471a2de566d478b623090---dbtests pg_ctl[1926]: LOG: redirecting log output to logging collector process Oct 20 13:12:33 57a7eebc499471a2de566d478b623090---dbtests pg_ctl[1926]: HINT: Future log output will appear in directory "pg_log". Oct 20 13:12:34 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Started PostgreSQL database server. Oct 20 13:12:34 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Stopping PostgreSQL database server... Oct 20 13:12:35 57a7eebc499471a2de566d478b623090---dbtests systemd[1]: Stopped PostgreSQL database server. :: [ PASS ] :: service postgresql should be stopped (Assert: 3 should equal 3) :: [ BEGIN ] :: Running 'rm -rf /var/lib/pgsql/data' :: [ PASS ] :: Command 'rm -rf /var/lib/pgsql/data' (Expected 0, got 0) :: [ 13:12:37 ] :: JOURNAL XML: /var/tmp/beakerlib-0KddCQE/journal.xml :: [ 13:12:37 ] :: JOURNAL TXT: /var/tmp/beakerlib-0KddCQE/journal.txt