Package: pgpool2 Version: 3.0.3-2~bpo60+1 Severity: important Since the postgresql 9.0.5 version, the PostgreSQL core developers decided to disallow row locking againt the sequence relation. (Source : http://www.postgresql.org/docs/9.0/static/release-9-0-5.html: Disallow SELECT FOR UPDATE/SHARE on sequences (Tom Lane) This operation doesn't work as expected and can lead to failures.)
Without migration of pgpool2 3.0.x to 3.1, you can't do insert in your PostgreSQL database. (Source : http://pgpool.projects.postgresql.org/NEWS.txt Change the lock method of insert_lock. The previous insert_lock uses row locking against the sequence relation, but the current one uses row locking against pgpool_catalog.insert_lock table. The reason is that PostgreSQL core developers decided to disallow row locking against the sequence relation to avoid an internal error which it leads.) PostgreSQL log says : CEST ERROR: cannot lock rows in sequence "table name" I define a important severity to this report because without the possibility to INSERT in table, the production is blocked. I use the squeeze-backports to PostgreSQL and Pgpool2. -- System Information: Debian Release: 6.0.3 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.32-5-xen-686 (SMP w/1 CPU core) Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages pgpool2 depends on: ii libc6 2.11.2-10 Embedded GNU C Library: Shared lib ii libpq5 9.1.1-1~bpo60+1 PostgreSQL C client library ii lsb-base 3.2-23.2squeeze1 Linux Standard Base 3.2 init scrip ii postgresql-common 113 PostgreSQL database-cluster manage pgpool2 recommends no packages. pgpool2 suggests no packages. -- Configuration Files: /etc/pgpool2/pcp.conf changed: postgres:0ee5cb5ec3652eab7cd9ca56bf4e435e /etc/pgpool2/pgpool.conf changed: listen_addresses = '0.0.0.0' port = 5433 pcp_port = 9898 socket_dir = '/var/run/postgresql' pcp_socket_dir = '/var/run/postgresql' backend_socket_dir = '/var/run/postgresql' pcp_timeout = 10 num_init_children = 32 max_pool = 4 child_life_time = 300 connection_life_time = 0 child_max_connections = 0 client_idle_limit = 0 authentication_timeout = 60 logdir = '/var/log/postgresql' pid_file_name = '/var/run/postgresql/pgpool.pid' replication_mode = true load_balance_mode = true replication_stop_on_mismatch = false failover_if_affected_tuples_mismatch = false replicate_select = false reset_query_list = 'ABORT; DISCARD ALL' white_function_list = '' black_function_list = 'nextval,setval' print_timestamp = true master_slave_mode = false master_slave_sub_mode = 'slony' delay_threshold = 0 log_standby_delay = 'none' connection_cache = true health_check_timeout = 20 health_check_period = 0 health_check_user = 'nobody' failover_command = '' failback_command = '' fail_over_on_backend_error = true insert_lock = true ignore_leading_white_space = true log_statement = false log_per_node_statement = false log_connections = false log_hostname = false parallel_mode = false enable_query_cache = false pgpool2_hostname = '' system_db_hostname = 'localhost' system_db_port = 5432 system_db_dbname = 'pgpool' system_db_schema = 'public' system_db_user = 'pgpool' system_db_password = 'xaP0Uraix0Aiv7u' backend_hostname0 = 'localhost' backend_port0 = 5432 backend_weight0 = 2 backend_data_directory0 = '/var/lib/postgresql' backend_hostname1 = '10.0.0.74' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/var/lib/postgresql' enable_pool_hba = false recovery_user = 'nobody' recovery_password = '' recovery_1st_stage_command = '' recovery_2nd_stage_command = '' recovery_timeout = 90 client_idle_limit_in_recovery = 0 lobj_lock_table = '' ssl = false debug_level = 0 /etc/pgpool2/pool_hba.conf changed: local all all trust host all all 127.0.0.1/32 trust host all all 10.0.0.0/24 trust -- no debconf information -- Camille
