Search Postgresql Archives

Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



It did create the data directory as well pg_log directory. I ran the initdb again with -d option, but it still printed the same line in the startup log, nothing more.
$SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident' $LOCALESTRING -d" >> "$PGLOG" 2>&1 < /dev/null

I then ran the pg_ctl command as follows
su - postgres
cd /usr/pgsql-9.2/bin
./pg_ctl initdb -D /var/lib/pgsql/data -o '--auth="ident" --locale=en_US.UTF-8 -d'

This command did print a lot of debug messages on CLI -
EBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 1/1/1, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG:  start transaction
DEBUG:  building index "pg_range_rngtypid_index" on table "pg_range"
DEBUG:  building index "pg_extension_name_index" on table "pg_extension"
DEBUG:  building index "pg_extension_oid_index" on table "pg_extension"
DEBUG:  building index "pg_shseclabel_object_index" on table "pg_shseclabel"
DEBUG:  building index "pg_seclabel_object_index" on table "pg_seclabel"
DEBUG:  building index "pg_db_role_setting_databaseid_rol_index" on table "pg_db_role_setting"
DEBUG:  building index "pg_default_acl_oid_index" on table "pg_default_acl"
DEBUG:  building index "pg_default_acl_role_nsp_obj_index" on table "pg_default_acl"
DEBUG:  building index "pg_foreign_table_relid_index" on table "pg_foreign_table"
DEBUG:  building index "pg_user_mapping_user_server_index" on table "pg_user_mapping"
DEBUG:  building index "pg_user_mapping_oid_index" on table "pg_user_mapping"
DEBUG:  building index "pg_foreign_server_name_index" on table "pg_foreign_server"
DEBUG:  building index "pg_foreign_server_oid_index" on table "pg_foreign_server"
DEBUG:  building index "pg_foreign_data_wrapper_name_index" on table "pg_foreign_data_wrapper"
DEBUG:  building index "pg_foreign_data_wrapper_oid_index" on table "pg_foreign_data_wrapper"
DEBUG:  building index "pg_type_typname_nsp_index" on table "pg_type"
DEBUG:  building index "pg_type_oid_index" on table "pg_type"
DEBUG:  building index "pg_ts_template_oid_index" on table "pg_ts_template"
DEBUG:  building index "pg_ts_template_tmplname_index" on table "pg_ts_template"
DEBUG:  building index "pg_ts_parser_oid_index" on table "pg_ts_parser"
DEBUG:  building index "pg_ts_parser_prsname_index" on table "pg_ts_parser"
DEBUG:  building index "pg_ts_dict_oid_index" on table "pg_ts_dict"
DEBUG:  building index "pg_ts_dict_dictname_index" on table "pg_ts_dict"
DEBUG:  building index "pg_ts_config_map_index" on table "pg_ts_config_map"
DEBUG:  building index "pg_ts_config_oid_index" on table "pg_ts_config"
DEBUG:  building index "pg_ts_config_cfgname_index" on table "pg_ts_config"
DEBUG:  building index "pg_trigger_oid_index" on table "pg_trigger"
DEBUG:  building index "pg_trigger_tgrelid_tgname_index" on table "pg_trigger"
DEBUG:  building index "pg_trigger_tgconstraint_index" on table "pg_trigger"
DEBUG:  building index "pg_tablespace_spcname_index" on table "pg_tablespace"
DEBUG:  building index "pg_tablespace_oid_index" on table "pg_tablespace"
DEBUG:  building index "pg_statistic_relid_att_inh_index" on table "pg_statistic"
DEBUG:  building index "pg_shdepend_reference_index" on table "pg_shdepend"
DEBUG:  building index "pg_shdepend_depender_index" on table "pg_shdepend"
DEBUG:  building index "pg_rewrite_rel_rulename_index" on table "pg_rewrite"
DEBUG:  building index "pg_rewrite_oid_index" on table "pg_rewrite"
DEBUG:  building index "pg_proc_proname_args_nsp_index" on table "pg_proc"
DEBUG:  building index "pg_proc_oid_index" on table "pg_proc"
DEBUG:  building index "pg_pltemplate_name_index" on table "pg_pltemplate"
DEBUG:  building index "pg_opfamily_oid_index" on table "pg_opfamily"
DEBUG:  building index "pg_opfamily_am_name_nsp_index" on table "pg_opfamily"
DEBUG:  building index "pg_operator_oprname_l_r_n_index" on table "pg_operator"
DEBUG:  building index "pg_operator_oid_index" on table "pg_operator"
DEBUG:  building index "pg_opclass_oid_index" on table "pg_opclass"
DEBUG:  building index "pg_opclass_am_name_nsp_index" on table "pg_opclass"
DEBUG:  building index "pg_namespace_oid_index" on table "pg_namespace"
DEBUG:  building index "pg_namespace_nspname_index" on table "pg_namespace"
DEBUG:  building index "pg_largeobject_metadata_oid_index" on table "pg_largeobject_metadata"
DEBUG:  building index "pg_largeobject_loid_pn_index" on table "pg_largeobject"
DEBUG:  building index "pg_language_oid_index" on table "pg_language"
DEBUG:  building index "pg_language_name_index" on table "pg_language"
DEBUG:  building index "pg_inherits_parent_index" on table "pg_inherits"
DEBUG:  building index "pg_inherits_relid_seqno_index" on table "pg_inherits"
DEBUG:  building index "pg_index_indexrelid_index" on table "pg_index"
DEBUG:  building index "pg_index_indrelid_index" on table "pg_index"
DEBUG:  building index "pg_enum_typid_sortorder_index" on table "pg_enum"
DEBUG:  building index "pg_enum_typid_label_index" on table "pg_enum"
DEBUG:  building index "pg_enum_oid_index" on table "pg_enum"
DEBUG:  building index "pg_shdescription_o_c_index" on table "pg_shdescription"
DEBUG:  building index "pg_description_o_c_o_index" on table "pg_description"
DEBUG:  building index "pg_depend_reference_index" on table "pg_depend"
DEBUG:  building index "pg_depend_depender_index" on table "pg_depend"
DEBUG:  building index "pg_database_oid_index" on table "pg_database"
DEBUG:  building index "pg_database_datname_index" on table "pg_database"
DEBUG:  building index "pg_conversion_oid_index" on table "pg_conversion"
DEBUG:  building index "pg_conversion_name_nsp_index" on table "pg_conversion"
DEBUG:  building index "pg_conversion_default_index" on table "pg_conversion"
DEBUG:  building index "pg_constraint_oid_index" on table "pg_constraint"
DEBUG:  building index "pg_constraint_contypid_index" on table "pg_constraint"
DEBUG:  building index "pg_constraint_conrelid_index" on table "pg_constraint"
DEBUG:  building index "pg_constraint_conname_nsp_index" on table "pg_constraint"
DEBUG:  building index "pg_collation_oid_index" on table "pg_collation"
DEBUG:  building index "pg_collation_name_enc_nsp_index" on table "pg_collation"
DEBUG:  building index "pg_class_relname_nsp_index" on table "pg_class"
DEBUG:  building index "pg_class_oid_index" on table "pg_class"
DEBUG:  building index "pg_cast_source_target_index" on table "pg_cast"
DEBUG:  building index "pg_cast_oid_index" on table "pg_cast"
DEBUG:  building index "pg_auth_members_member_role_index" on table "pg_auth_members"
DEBUG:  building index "pg_auth_members_role_member_index" on table "pg_auth_members"
DEBUG:  building index "pg_authid_oid_index" on table "pg_authid"
DEBUG:  building index "pg_authid_rolname_index" on table "pg_authid"
DEBUG:  building index "pg_attribute_relid_attnum_index" on table "pg_attribute"
DEBUG:  building index "pg_attribute_relid_attnam_index" on table "pg_attribute"
DEBUG:  building index "pg_attrdef_oid_index" on table "pg_attrdef"
DEBUG:  building index "pg_attrdef_adrelid_adnum_index" on table "pg_attrdef"
DEBUG:  building index "pg_amproc_oid_index" on table "pg_amproc"
DEBUG:  building index "pg_amproc_fam_proc_index" on table "pg_amproc"
DEBUG:  building index "pg_amop_oid_index" on table "pg_amop"
DEBUG:  building index "pg_amop_opr_fam_index" on table "pg_amop"
DEBUG:  building index "pg_amop_fam_strat_index" on table "pg_amop"
DEBUG:  building index "pg_am_oid_index" on table "pg_am"
DEBUG:  building index "pg_am_name_index" on table "pg_am"
DEBUG:  building index "pg_aggregate_fnoid_index" on table "pg_aggregate"
DEBUG:  building index "pg_toast_2964_index" on table "pg_toast_2964"
DEBUG:  building index "pg_toast_2396_index" on table "pg_toast_2396"
DEBUG:  building index "pg_toast_2620_index" on table "pg_toast_2620"
DEBUG:  building index "pg_toast_2619_index" on table "pg_toast_2619"
DEBUG:  building index "pg_toast_3596_index" on table "pg_toast_3596"
DEBUG:  building index "pg_toast_2618_index" on table "pg_toast_2618"
DEBUG:  building index "pg_toast_1255_index" on table "pg_toast_1255"
DEBUG:  building index "pg_toast_2609_index" on table "pg_toast_2609"
DEBUG:  building index "pg_toast_2606_index" on table "pg_toast_2606"
DEBUG:  building index "pg_toast_2604_index" on table "pg_toast_2604"
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/43, nestlvl: 1, children:
DEBUG:  commit transaction
DEBUG:  shmem_exit(0): 10 callbacks to make
LOG:  shutting down
DEBUG:  SlruScanDirectory invoking callback on pg_multixact/offsets/0000
DEBUG:  SlruScanDirectory invoking callback on pg_multixact/members/0000
DEBUG:  attempting to remove WAL segments older than log file 000000010000000000000000
DEBUG:  SlruScanDirectory invoking callback on pg_subtrans/0000
LOG:  database system is shut down
DEBUG:  proc_exit(0): 3 callbacks to make
DEBUG:  exit(0)
DEBUG:  shmem_exit(-1): 0 callbacks to make
DEBUG:  proc_exit(-1): 0 callbacks to make
ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... initdb: locale name has non-ASCII characters, skipped: "bokmål"
initdb: locale name has non-ASCII characters, skipped: "français"
could not determine encoding for locale "hy_AM.armscii8": codeset is "ARMSCII-8"
could not determine encoding for locale "ka_GE": codeset is "GEORGIAN-PS"
could not determine encoding for locale "ka_GE.georgianps": codeset is "GEORGIAN-PS"
could not determine encoding for locale "kk_KZ": codeset is "PT154"
could not determine encoding for locale "kk_KZ.pt154": codeset is "PT154"
could not determine encoding for locale "tg_TJ": codeset is "KOI8-T"
could not determine encoding for locale "tg_TJ.koi8t": codeset is "KOI8-T"
could not determine encoding for locale "thai": codeset is "TIS-620"
could not determine encoding for locale "th_TH": codeset is "TIS-620"
could not determine encoding for locale "th_TH.tis620": codeset is "TIS-620"
could not determine encoding for locale "vi_VN.tcvn": codeset is "TCVN5712-1"
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

Success. You can now start the database server using:

    /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/data
or
    /usr/pgsql-9.2/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start


And also seemed to be successful. But when I quit the postgres shell, tried to restart the service as root user, it has failed with the following message on CLI -
Stopping postgresql service:                               [  OK  ]
Starting postgresql service:                              [FAILED]

pgstartup log has the same line  -
Segmentation fault (core dumped)

Where is this core dump file generated? How do we proceed further from here?

Thanks
Bhushan Pathak




On Wed, Jun 4, 2014 at 7:04 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 06/04/2014 05:20 AM, Bhushan Pathak wrote:
Hello,

I have installed the following RPM on CentOS 6.5 64 bit -
uuid-1.5.1-4.rhel5.x86_64
postgresql92-contrib-9.2.4-1PGDG.rhel5.x86_64
postgresql92-9.2.4-1PGDG.rhel5.x86_64
postgresql92-server-9.2.4-1PGDG.rhel5.x86_64
postgresql92-libs-9.2.4-1PGDG.rhel5.x86_64

Kernel version is -
kernel-2.6.32-431.17.1.el6.x86_64
kernel-firmware-2.6.32-431.17.1.el6.noarch

The CentOS server is a VM running on top of VMware with 4CPUs [2.4GHz
each] & 9GB of RAM. No other application runs on this server.

The RPM get installed successfully, but when I issue the "service
postgresql-9.2 initdb" command, it gets stuck for 5-10 minutes & then
says failed. The pgstartup.log file has only 1 line -
Segmentation fault (core dumped)

Is the data directory created?



Any idea what is going wrong? How to fix it? I'm open to try multiple
installation attempts [as it is a VM & I can re-install as needed]

What happens if you use pg_ctl to initdb the cluster?


Thanks
Bhushan Pathak


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux