[pgpool-general: 844] Re: Could not create shared memory segment
Kouber Saparev
kouber at saparev.com
Fri Aug 3 00:59:44 JST 2012
On 08/02/2012 05:51 PM, Lazáro Rubén García Martínez wrote:
> What about with the property memqcache_oiddir?. Are you defined in this property the path for storing the entries for the query cache by pgpool?
>
> Could you start pgpool in debug mode?
Here's the complete output of '/usr/local/bin/pgpool
--config-file=/etc/pgpool.conf -n -d'
2012-08-02 17:56:59 DEBUG: pid 13126: key: listen_addresses
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'localhost' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: port
2012-08-02 17:56:59 DEBUG: pid 13126: value: 5433 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: socket_dir
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/var/run/pgpool' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: pcp_port
2012-08-02 17:56:59 DEBUG: pid 13126: value: 9898 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: pcp_socket_dir
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/var/run/pgpool' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: enable_pool_hba
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: authentication_timeout
2012-08-02 17:56:59 DEBUG: pid 13126: value: 60 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: ssl
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: num_init_children
2012-08-02 17:56:59 DEBUG: pid 13126: value: 200 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: max_pool
2012-08-02 17:56:59 DEBUG: pid 13126: value: 10 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: child_life_time
2012-08-02 17:56:59 DEBUG: pid 13126: value: 300 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: child_max_connections
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: connection_life_time
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: client_idle_limit
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: log_destination
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'stderr' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: print_timestamp
2012-08-02 17:56:59 DEBUG: pid 13126: value: true kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: log_connections
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: log_hostname
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: log_statement
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: log_per_node_statement
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: log_standby_delay
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'none' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: syslog_facility
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'LOCAL0' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: syslog_ident
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'pgpool' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: debug_level
2012-08-02 17:56:59 DEBUG: pid 13126: value: 1 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: pid_file_name
2012-08-02 17:56:59 DEBUG: pid 13126: value:
'/var/run/pgpool/pgpool.pid' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: logdir
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/var/log/postgresql' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: connection_cache
2012-08-02 17:56:59 DEBUG: pid 13126: value: on kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: reset_query_list
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'SET SESSION AUTHORIZATION
DEFAULT; RESET ALL; SELECT pg_advisory_unlock_all(); DISCARD TEMP;' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token: SET
SESSION AUTHORIZATION DEFAULT
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
RESET ALL
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
SELECT pg_advisory_unlock_all()
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
DISCARD TEMP
2012-08-02 17:56:59 DEBUG: pid 13126: key: replication_mode
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: replicate_select
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: replicate_select: 0
2012-08-02 17:56:59 DEBUG: pid 13126: key: insert_lock
2012-08-02 17:56:59 DEBUG: pid 13126: value: on kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: lobj_lock_table
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: replication_stop_on_mismatch
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: replication_stop_on_mismatch: 0
2012-08-02 17:56:59 DEBUG: pid 13126: key:
failover_if_affected_tuples_mismatch
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126:
failover_if_affected_tuples_mismatch: 0
2012-08-02 17:56:59 DEBUG: pid 13126: key: load_balance_mode
2012-08-02 17:56:59 DEBUG: pid 13126: value: on kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: ignore_leading_white_space
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: white_function_list
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: black_function_list
2012-08-02 17:56:59 DEBUG: pid 13126: value:
'nextval,setval,READ_MESSAGE,PG_ADVISORY_LOCK,PG_ADVISORY_UNLOCK' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token: nextval
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token: setval
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
READ_MESSAGE
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
PG_ADVISORY_LOCK
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
PG_ADVISORY_UNLOCK
2012-08-02 17:56:59 DEBUG: pid 13126: add_to_patterns: regex pattern:
^nextval$
2012-08-02 17:56:59 DEBUG: pid 13126: add_to_patterns: regex pattern:
^setval$
2012-08-02 17:56:59 DEBUG: pid 13126: add_to_patterns: regex pattern:
^READ_MESSAGE$
2012-08-02 17:56:59 DEBUG: pid 13126: add_to_patterns: regex pattern:
^PG_ADVISORY_LOCK$
2012-08-02 17:56:59 DEBUG: pid 13126: add_to_patterns: regex pattern:
^PG_ADVISORY_UNLOCK$
2012-08-02 17:56:59 DEBUG: pid 13126: key: master_slave_mode
2012-08-02 17:56:59 DEBUG: pid 13126: value: on kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: master_slave_sub_mode
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'stream' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: sr_check_period
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: sr_check_user
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'www' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: sr_check_password
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: delay_threshold
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: follow_master_command
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: parallel_mode
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: pgpool2_hostname
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: system_db_hostname
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'localhost' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: system_db_port
2012-08-02 17:56:59 DEBUG: pid 13126: value: 5432 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: system_db_dbname
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'pgpool' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: system_db_schema
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'pgpool_catalog' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: system_db_user
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'pgpool' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: system_db_password
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'jinga' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: health_check_period
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: health_check_timeout
2012-08-02 17:56:59 DEBUG: pid 13126: value: 20 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: health_check_user
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'www' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: health_check_password
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: health_check_max_retries
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: health_check_retry_delay
2012-08-02 17:56:59 DEBUG: pid 13126: value: 1 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: failover_command
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: failback_command
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: fail_over_on_backend_error
2012-08-02 17:56:59 DEBUG: pid 13126: value: on kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: recovery_user
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'postgres' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: recovery_password
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: recovery_1st_stage_command
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: recovery_2nd_stage_command
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: recovery_timeout
2012-08-02 17:56:59 DEBUG: pid 13126: value: 90 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: client_idle_limit_in_recovery
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: use_watchdog
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: trusted_servers
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: delegate_IP
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: wd_hostname
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: wd_port
2012-08-02 17:56:59 DEBUG: pid 13126: value: 9000 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: wd_interval
2012-08-02 17:56:59 DEBUG: pid 13126: value: 10 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: ping_path
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/bin' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: ifconfig_path
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/sbin' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: if_up_cmd
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'ifconfig eth0:0 inet
$_IP_$ netmask 255.255.255.0' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: if_down_cmd
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'ifconfig eth0:0 down' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: arping_path
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/usr/sbin' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: arping_cmd
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'arping -U $_IP_$ -w 1' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: wd_life_point
2012-08-02 17:56:59 DEBUG: pid 13126: value: 3 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: wd_lifecheck_query
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'SELECT 1' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: relcache_expire
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: relcache_size
2012-08-02 17:56:59 DEBUG: pid 13126: value: 256 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: check_temp_table
2012-08-02 17:56:59 DEBUG: pid 13126: value: on kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: memory_cache_enabled
2012-08-02 17:56:59 DEBUG: pid 13126: value: off kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_method
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'shmem' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_memcached_host
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'localhost' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_memcached_port
2012-08-02 17:56:59 DEBUG: pid 13126: value: 11211 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_total_size
2012-08-02 17:56:59 DEBUG: pid 13126: value: 67108864 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_max_num_cache
2012-08-02 17:56:59 DEBUG: pid 13126: value: 1000000 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_expire
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_auto_cache_invalidation
2012-08-02 17:56:59 DEBUG: pid 13126: value: on kind: 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_maxcache
2012-08-02 17:56:59 DEBUG: pid 13126: value: 409600 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_cache_block_size
2012-08-02 17:56:59 DEBUG: pid 13126: value: 1048576 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: memqcache_oiddir
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/var/log/pgpool/oiddir'
kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: white_memqcache_table_list
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: black_memqcache_table_list
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: replication_timeout
2012-08-02 17:56:59 DEBUG: pid 13126: value: 5000 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: key: ssl_key
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: ssl_cert
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: ssl_ca_cert
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: ssl_ca_cert_dir
2012-08-02 17:56:59 DEBUG: pid 13126: value: '' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_hostname0
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'db1' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_port0
2012-08-02 17:56:59 DEBUG: pid 13126: value: 5432 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: port slot number 0
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_weight0
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0.5 kind: 3
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: weight slot number 0
weight: 0.500000
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_data_directory0
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/tmp' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_flag0
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'ALLOW_TO_FAILOVER' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
ALLOW_TO_FAILOVER
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: allow_to_failover on
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: slot number 0 flag: 0000
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_hostname1
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'db2' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_port1
2012-08-02 17:56:59 DEBUG: pid 13126: value: 5432 kind: 2
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: port slot number 1
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_weight1
2012-08-02 17:56:59 DEBUG: pid 13126: value: 0.5 kind: 3
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: weight slot number 1
weight: 0.500000
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_data_directory1
2012-08-02 17:56:59 DEBUG: pid 13126: value: '/tmp' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: key: backend_flag0
2012-08-02 17:56:59 DEBUG: pid 13126: value: 'ALLOW_TO_FAILOVER' kind: 4
2012-08-02 17:56:59 DEBUG: pid 13126: extract_string_tokens: token:
ALLOW_TO_FAILOVER
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: allow_to_failover on
2012-08-02 17:56:59 DEBUG: pid 13126: pool_config: slot number 0 flag: 0000
2012-08-02 17:56:59 DEBUG: pid 13126: num_backends: 2 total_weight: 1.000000
2012-08-02 17:56:59 DEBUG: pid 13126: backend 0 weight: 1073741823.500000
2012-08-02 17:56:59 DEBUG: pid 13126: backend 0 flag: 0000
2012-08-02 17:56:59 DEBUG: pid 13126: backend 1 weight: 1073741823.500000
2012-08-02 17:56:59 DEBUG: pid 13126: backend 1 flag: 0000
2012-08-02 17:56:59 ERROR: pid 13126: could not create shared memory
segment: Invalid argument
2012-08-02 17:56:59 ERROR: pid 13126: failed to allocate connection
informations
2012-08-02 17:56:59 ERROR: pid 13126: unlink() failed: No such file or
directory
2012-08-02 17:56:59 DEBUG: pid 13126: shmem_exit(1)
--
Kouber Saparev
More information about the pgpool-general
mailing list