Unable to sync repo (encoding error)

2.2.0 rc3
Katello 3.17
Index of /groups/katello/releases yum /3.17/katello/el7/x86_64/katello-repos-latest.rpm

postgres -V

postgres (PostgreSQL) 12.1

psql pulpcore -c ‘SHOW SERVER_ENCODING’ -U postgres

server_encoding


SQL_ASCII

(1 row)

-bash-4.2$

2.2.0 rc3
Katello 3.17
https://fedorapeople.org/groups/katello/releases/ yum /3.17/katello/el7/x86_64/katello-repos-latest.rpm

postgres -V

postgres (PostgreSQL) 12.1

psql pulpcore -c ‘SHOW SERVER_ENCODING’ -U postgres

server_encoding

SQL_ASCII

(1 row)

-bash-4.2$

Reply

Workaround

#su - postgres

$ pg_dump --encoding=utf8 pulpcore -f pulpcore.sql (verify ls -la that file is there)

$ psql (go into psql , it will not allow to drop db because of active connections)

postgres=# SELECT
pg_terminate_backend (pg_stat_activity.pid)
FROM
pg_stat_activity
WHERE
pg_stat_activity.datname = ‘pulpcore’;

postgres=# DROP DATABASE pulpcore; (Run quickly before it make connections again , use arrow keys)

createdb -E utf8 -l en_US.UTF-8 pulpcore -T template0

Verify :slight_smile:

-bash-4.2$ psql pulpcore -c ‘SHOW SERVER_ENCODING’ -U postgres

server_encoding


UTF8

(1 row)

exit

foreman-maintain services restart

Starting the following service(s):
pulpcore-resource-manager, pulpcore-worker@*
| All services started
\ Try 1/5: checking status of hammer ping
Couldn’t connect to the server: undefined method `to_sym’ for nil:NilClass
\ Waiting 30 seconds before retry.

solution is :slight_smile:

[root@foreman ~]# cat /etc/environment

LANG=en_US.utf-8

LC_ALL=en_US.utf-8

[root@foreman ~]#

Before Installation

1 Like