原 pgbouncer启动报错evdns_base_new failed Segmentation fault (core dumped)

2025年1月8日  

0    121    1

Tags： 原创故障处理GreenPlum

👉 本文共约194个字，系统预计阅读时间或需1分钟。

显示/隐藏全文目录

目录

• 现象
• 原因
• 解决
• 参考

现象

[gpadmin@mdw pgbouncer]$ pgbouncer pgbouncer.ini -v 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: [databases] 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: '*' = 'host=127.0.0.1 port=5432' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: '*' = 'host=127.0.0.1 port=5432' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: [pgbouncer] 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pool_mode' = 'session' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pool_mode' = 'session' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_port' = '6432' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_port' = '6432' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_addr' = '*' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_addr' = '*' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_type' = 'md5' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_type' = 'md5' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_user' = 'pgbouncer' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_user' = 'pgbouncer' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_file' = '/usr/local/greenplum-db/pgbouncer/users.txt' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_file' = '/usr/local/greenplum-db/pgbouncer/users.txt' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'logfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.log' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'logfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.log' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pidfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.pid' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pidfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.pid' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'admin_users' = 'pgbouncer' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'admin_users' = 'pgbouncer' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'default_pool_size' = '1000' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'default_pool_size' = '1000' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'max_client_conn' = '4000' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'max_client_conn' = '4000' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'ignore_startup_parameters' = 'extra_float_digits,search_path' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'ignore_startup_parameters' = 'extra_float_digits,search_path' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'so_reuseport' = '1' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'so_reuseport' = '1' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'application_name_add_host' = '1' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'application_name_add_host' = '1' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'query_wait_timeout' = '0' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'query_wait_timeout' = '0' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_connections' = '0' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_connections' = '0' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_disconnections' = '0' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_disconnections' = '0' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG loading auth_file: "/usr/local/greenplum-db/pgbouncer/users.txt" 2025-01-08 15:44:31.518 CST [180197] DEBUG pktbuf_dynamic(128): 0x14a7370 2025-01-08 15:44:31.518 CST [180197] DEBUG make_room(0x14a7370, 9): realloc newlen=256 2025-01-08 15:44:31.518 CST [180197] DEBUG pktbuf_dynamic(128): 0x14a7550 2025-01-08 15:44:31.518 CST [180197] LOG kernel file descriptor limit: 655350 (hard: 655350); max_client_conn: 4000, max expected fd use: 4012 2025-01-08 15:44:31.518 CST [180197] DEBUG adns_create_context: evdns2 2025-01-08 15:44:31.518 CST [180197] ERROR evdns_base_new failed Segmentation fault (core dumped)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

[gpadmin@mdw pgbouncer]$ pgbouncer pgbouncer.ini -v 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: [databases] 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: '*' = 'host=127.0.0.1 port=5432' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: '*' = 'host=127.0.0.1 port=5432' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: [pgbouncer] 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pool_mode' = 'session' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pool_mode' = 'session' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_port' = '6432' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_port' = '6432' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_addr' = '*' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'listen_addr' = '*' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_type' = 'md5' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_type' = 'md5' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_user' = 'pgbouncer' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_user' = 'pgbouncer' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_file' = '/usr/local/greenplum-db/pgbouncer/users.txt' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'auth_file' = '/usr/local/greenplum-db/pgbouncer/users.txt' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'logfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.log' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'logfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.log' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pidfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.pid' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'pidfile' = '/usr/local/greenplum-db/pgbouncer/pgbouncer.pid' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'admin_users' = 'pgbouncer' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'admin_users' = 'pgbouncer' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'default_pool_size' = '1000' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'default_pool_size' = '1000' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'max_client_conn' = '4000' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'max_client_conn' = '4000' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'ignore_startup_parameters' = 'extra_float_digits,search_path' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'ignore_startup_parameters' = 'extra_float_digits,search_path' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'so_reuseport' = '1' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'so_reuseport' = '1' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'application_name_add_host' = '1' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'application_name_add_host' = '1' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'query_wait_timeout' = '0' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'query_wait_timeout' = '0' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_connections' = '0' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_connections' = '0' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_disconnections' = '0' 2025-01-08 15:44:31.518 CST [180197] DEBUG parse_ini_file: 'log_disconnections' = '0' ok:1 2025-01-08 15:44:31.518 CST [180197] DEBUG loading auth_file: "/usr/local/greenplum-db/pgbouncer/users.txt" 2025-01-08 15:44:31.518 CST [180197] DEBUG pktbuf_dynamic(128): 0x14a7370 2025-01-08 15:44:31.518 CST [180197] DEBUG make_room(0x14a7370, 9): realloc newlen=256 2025-01-08 15:44:31.518 CST [180197] DEBUG pktbuf_dynamic(128): 0x14a7550 2025-01-08 15:44:31.518 CST [180197] LOG kernel file descriptor limit: 655350 (hard: 655350); max_client_conn: 4000, max expected fd use: 4012 2025-01-08 15:44:31.518 CST [180197] DEBUG adns_create_context: evdns2 2025-01-08 15:44:31.518 CST [180197] ERROR evdns_base_new failed Segmentation fault (core dumped)

原因

缺失/etc/resolv.conf 文件，且该文件必须有内容。

解决

echo 'nameserver 127.0.0.1' >> /etc/resolv.conf

1	echo 'nameserver 127.0.0.1' >> /etc/resolv.conf

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。

相关文章

• could not load library "/usr/local/greenplum-cc-6.10.0/lib/gp_browser.so": libpq.so.5: cannot open shared object file: No such file or directory (seg19 12.17.163.53:6019 pid=3773909)
• GreenPlum查询报错 interconnect error Could not set up udp listener socket bind Address already in use
• GreenPlum中的pg_cron报错connection failed
• gpcc监控不显示内存、cpu等资源
• GreenPlum查询报错could not open file "base/231962/24824104": No such file or directory (seg44 slice2 192.168.163.54:6014 pid=1499766)
• GreenPlum数据库不定时报错interconnect error connection closed prematurely、timed out waiting for response from motion receiver during TCP interconnect teardown
• GreenPlum查询表有数据，但是drop表报错does not exist，vacuumdb也报错
• gpload加载数据报错 ProgrammingError: ERROR: column "relstorage" does not exist（GP7中的pg_class没有relstorage字段）
• gpload加载数据报错 UnboundLocalError: local variable 'has_seq_bool' referenced before assignment
• GreenPlum启动报错ModuleNotFoundError: No module named 'gppylib'
• GreenPlum查询参数报错schema gp_toolkit does not exist
• GreenPlum启动报错could not load library /usr/local/greenplum-db-6.27.0/lib/postgresql/pg_cron.so的故障处理
• GreenPlum严重故障导致不能启库的解决办法（pg_resetxlog重置日志）
• 初始化GreenPlum数据库实例时报错ssh_exchange_identification: connection reset by peer
• GreenPlum查询状态报错 [WARNING]:-could not query segment
• 使用gpmon登陆gpcc报错Error: User gpmon is not allowed to login Command Center.
• GreenPlum启动数据库报错pre-existing shared memory block
• GreenPlum数据库SQL查询卡慢，报错或告警 Interconnect encountered a network error, please check your network
• GreenPlum初始化或启动时，一直卡住，psql命令也一直卡住，警告Timeout expired connecting to template1 、Failed to connect to template1
• gprecoverseg恢复GreenPlum的时候报错“gprecoverseg failed(Reason ''ascii' codec can't encode character u'\u2018' in positition 229: ordinal not in range(128)'）exiting”

打赏赞(1)分享

标签： 原创故障处理GreenPlum

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

• 下一篇 GreenPlum 7中的资源组
• 上一篇 GreenPlum启用资源组后，gpcc不能展示界面，报错 Error: pq: column "memory_quota" does not exist

您可能还喜欢...

• 1

  PG和GreenPlum中的临时表（TEMPORARY TABLE）

  2021年7月15日

   由 小麦苗 · Published 2021年7月15日 · Last modified 2024年6月4日

  · 已更新 2024年6月4日  

  1    1362    7
• 0

  MinIO_S3的简介和安装使用

  2024年8月29日

   由 小麦苗 · Published 2024年8月29日 · Last modified 2024年10月30日

  · 已更新 2024年10月30日  

  0    227    1
• 0

  使用gpbackup在欧拉openEuler 22.03上备份GP6时报错open no such file or directory 其实内部报错 rsync symbol lookup error rsync undefined symbol ZSTD_compressStream2

  2024年10月30日

   由 小麦苗 · Published 2024年10月30日 · Last modified 2024年10月31日

  · 已更新 2024年10月31日  

  0    276    1