Skip site navigation (1) Skip section navigation (2)

PosgreSQL is crashing with a signal 11 - Bug?

From: Rafael Martinez Guerrero <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: pgsql-bugs(at)postgresql(dot)org
Cc: r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no
Subject: PosgreSQL is crashing with a signal 11 - Bug?
Date: 2004-09-07 17:27:27
Message-ID: 1094578047.20193.165.camel@bbking.uio.no (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello

We have a problem with one of our central databases and we need your
help to find a solution.

----------------------
* Description: 
----------------------
"PosgreSQL is crashing with a signal 11 and we do not think is a
hardware problem" :(

Since last week, we are having a big problem with one of our postgreSQL
installations. The database is not so big but it is used intensely with
different jobs running parallel transactions.

The first time the database crashed, we had been running 7.3.5 for a
long time without problems. Because the signal 11, we thought it was a
problem with defective memory, we changed RAM in the server and restored
the database from last backup. The memory was defective and we thought
we found the problem to our signal 11.

After some hours the database crashed again with the samme error. We did
not take any chances and moved the database to a new server. This did
not help and we got the samme problem after some hours. We updated to
7.3.7 hoping for the best but it did not help either.

Today it crashed again but this time we have logged more information
from the crash and we hope you can help us to find a solution to this
problem. 

Below, some relevant information about our system. Please do not
hesitate to ask for more information if you need it.

------------------------
* OS/Machine/Filesystem: 
------------------------
- Red Hat Enterprise Linux WS release 3 (Taroon Update 3)
  kernel 2.4.21-15.0.3.ELsmp

- Dell 2650: 
  2 x Intel(R)Xeon(TM)CPU 2.40GHz
  2GB RAM
  PERCRAID Mirror 2 x 73GB

- LVM - ext3

-----------------------------
* Version / compilator / libc
-----------------------------
- PostgreSQL 7.3.7

- Options given to 'configure' script when PostgreSQL was built:
'--prefix=/local/opt/postgresql' '--mandir=/local/share/man'
'--with-openssl=/local' '--with-perl' '--with-java' 'CC=cc-wrapper'
'LDFLAGS=-L/local/lib'

- gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-42)
- glibc-2.3.2-95.27 (RHEL3)

----------------------
* Configuration / DBSize
----------------------

- Relevant parameters that have been changed by us:

postgresql.conf:
max_connections = 600
superuser_reserved_connections = 2

shared_buffers = 8192
max_fsm_relations = 1000
max_fsm_pages = 20000
wal_buffers = 64 

sort_mem = 2048
vacuum_mem = 32768 
fsync = true

effective_cache_size = 131072 
random_page_cost = 2

stats_start_collector = true
stats_command_string = true
stats_row_level = true
stats_block_level = true

autocommit=false


/etc/sysctl.conf:
kernel.shmall = 134217728
kernel.shmmax = 134217728


-bash-2.05b# du -h
4.2M    ./base/1
3.6M    ./base/16975
4.0K    ./base/63684339/pgsql_tmp
2.3G    ./base/63684339
2.3G    ./base
168K    ./global
129M    ./pg_xlog
8.6M    ./pg_clog
2.4G    .

-----------------------------------------------------------
* Information from CORE dump we got without --enable-debug.
-----------------------------------------------------------

This GDB was configured as "i386-redhat-linux-gnu"...(no debugging
symbols found)...Using host libthread_db library
"/lib/tls/libthread_db.so.1".

Program terminated with signal 11, Segmentation fault.

[......]
(gdb) bt
#0  0xb734d07c in memcpy () from /lib/tls/libc.so.6
#1  0x0806bba8 in DataFill ()
#2  0x0806c3ee in heap_formtuple ()
#3  0x080d1af1 in ExecTargetList ()
#4  0x080d1cdb in ExecProject ()
#5  0x080d1d7d in ExecScan ()
#6  0x080d5b5e in ExecIndexScan ()
#7  0x080cfd91 in ExecProcNode ()
#8  0x082fcd08 in ?? ()
#9  0x00000000 in ?? ()
#10 0x082ff120 in ?? ()
#11 0x00000000 in ?? ()
#12 0x082f9a78 in ?? ()
#13 0xbfff8028 in ?? ()
#14 0x080d6e5a in ExecMergeJoin ()
Previous frame inner to this frame (corrupt stack?)
---------------------------------------------------------

-----------------------------------------------------------
* Information from CORE dump we got with --enable-debug. We have
compiled a new version of postgres and run it through gdb with the core
dump we had/got from postgres without --enable-debug. 
-----------------------------------------------------------

#0  0xb734d07c in memcpy () from /lib/tls/libc.so.6

#1  0x0806bba8 in DataFill (data=0xb7489000 <Address 0xb7489000 out of
bounds>, tupleDesc=0x82fd554, value=0x82fd550, nulls=0xbfff7ec0 "  n  ",
infomask=0x836e904c, bit=0x836e904f "\003\f") at heaptuple.c:139

#2  0x0806c3ee in heap_formtuple (tupleDescriptor=0x82fd620,
value=0x82fd550, nulls=0xbfff7ec0 "  n  ") at heaptuple.c:623

#3  0x080d1af1 in ExecTargetList (targetlist=0x82fa250, nodomains=5,
targettype=0x82fd620, values=0x82fd550, econtext=0x82fd4e0,
isDone=0xbfff7f68) at execQual.c:2230

#4  0x080d1cdb in ExecScan (node=0x82fd528, accessMtd=0xbfff7f68) at
execScan.c:49

#5  0x080d1d7d in ExecScan (node=0x82fa140, accessMtd=0x80d58d4
<IndexNext+24>) at execScan.c:146

#6  0x080d5b5e in ExecIndexReScan (node=0x82fa140, exprCtxt=0xb72117d,
parent=0x0) at nodeIndexscan.c:284

#7  0x080d58d4 in IndexNext (node=0x0) at nodeIndexscan.c:87
Previous frame inner to this frame (corrupt stack?)

--------------------------------
* Relevant errors in the logfile:
--------------------------------
2004-09-07 15:59:08 [8100]   LOG:  statement: FETCH 1 FROM
"PgSQL_08456DE4"
2004-09-07 15:59:39 [7370]   DEBUG:  reaping dead processes
2004-09-07 15:59:39 [7370]   DEBUG:  child process (pid 8100) was
terminated by signal 11
2004-09-07 15:59:39 [7370]   LOG:  server process (pid 8100) was
terminated by signal 11
2004-09-07 15:59:39 [7370]   LOG:  terminating any other active server
processes
2004-09-07 15:59:39 [7370]   DEBUG:  CleanupProc: sending SIGQUIT to
process 7539
2004-09-07 15:59:39 [7370]   DEBUG:  CleanupProc: sending SIGQUIT to
process 7468
2004-09-07 15:59:39 [7370]   DEBUG:  CleanupProc: sending SIGQUIT to
process 7423
2004-09-07 15:59:39 [7468]   WARNING:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend
        died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am
        going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
2004-09-07 15:59:39 [7423]   WARNING:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend
        died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am
        going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
2004-09-07 15:59:39 [7539]   WARNING:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend
        died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am
        going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
2004-09-07 15:59:39 [7370]   DEBUG:  reaping dead processes
2004-09-07 15:59:39 [7370]   DEBUG:  child process (pid 7423) exited
with exit code 1
2004-09-07 15:59:39 [7370]   DEBUG:  reaping dead processes
2004-09-07 15:59:39 [7370]   DEBUG:  child process (pid 7468) exited
with exit code 1
2004-09-07 15:59:39 [7370]   DEBUG:  reaping dead processes
2004-09-07 15:59:39 [7370]   DEBUG:  child process (pid 7539) exited
with exit code 1
2004-09-07 15:59:39 [7370]   LOG:  all server processes terminated;
reinitializing shared memory and semaphores
2004-09-07 15:59:39 [7370]   DEBUG:  shmem_exit(0)
2004-09-07 15:59:39 [7370]   DEBUG:  invoking
IpcMemoryCreate(size=78536704)
------------------------------------------------------------------

-----------------------------------------------------------------------
* The child process (pid 8100) that crashed with signal 11 logged these
statements (We have a complete log for pid 8100, but it has a size of
2MB):
-----------------------------------------------------------------------

2004-09-07 15:58:50 [8100]   LOG:  statement: begin; select
getdatabaseencoding(); commit
2004-09-07 15:58:50 [8100]   LOG:  statement: begin; select
getdatabaseencoding(); commit
2004-09-07 15:58:50 [8100]   LOG:  statement: begin; select
getdatabaseencoding(); commit
2004-09-07 15:58:50 [8100]   LOG:  statement: begin; select
getdatabaseencoding(); commit
2004-09-07 15:58:50 [8100]   LOG:  statement: begin; select
getdatabaseencoding(); commit
2004-09-07 15:58:50 [8100]   LOG:  statement: begin; select
getdatabaseencoding(); commit
2004-09-07 15:58:50 [8100]   LOG:  statement: begin; select
getdatabaseencoding(); commit
2004-09-07 15:58:50 [8100]   LOG:  statement: select version()
2004-09-07 15:58:50 [8100]   LOG:  statement: select version()
2004-09-07 15:58:50 [8100]   LOG:  statement: select version()
2004-09-07 15:58:50 [8100]   LOG:  statement: BEGIN WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: BEGIN WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: BEGIN WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: BEGIN WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: SET CLIENT_ENCODING TO
'ISO_8859_1'
2004-09-07 15:58:50 [8100]   LOG:  statement: SET CLIENT_ENCODING TO
'ISO_8859_1'
2004-09-07 15:58:50 [8100]   LOG:  statement: SET CLIENT_ENCODING TO
'ISO_8859_1'
2004-09-07 15:58:50 [8100]   LOG:  statement: COMMIT WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: COMMIT WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: COMMIT WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: BEGIN WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: BEGIN WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: BEGIN WORK
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM spread_code WHERE code_str = 'NIS_user(at)ifi'
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM spread_code WHERE code_str = 'NIS_user(at)ifi'
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM spread_code WHERE code_str = 'NIS_user(at)ifi'
2004-09-07 15:58:50 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1700
2004-09-07 15:58:50 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1700
2004-09-07 15:58:50 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1700
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM spread_code WHERE code_str = 'NIS_fg(at)ifi'
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM spread_code WHERE code_str = 'NIS_fg(at)ifi'
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM spread_code WHERE code_str = 'NIS_fg(at)ifi'
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code , shell FROM posix_shell_code
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code , shell FROM posix_shell_code
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code , shell FROM posix_shell_code
2004-09-07 15:58:50 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1043
2004-09-07 15:58:50 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1043
2004-09-07 15:58:50 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1043
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT count ( ah . account_id ) , ah . spread , di . disk_id
, di . host_id , di . path FROM disk_info di LEFT JOIN account_home ah
ON di . disk_id = ah . disk_id AND ah . spread = 105 LEFT JOIN
account_info ai ON ah . account_id = ai . account_id GROUP BY di .
disk_id , di . host_id , di . path , ah . spread
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT count ( ah . account_id ) , ah . spread , di . disk_id
, di . host_id , di . path FROM disk_info di LEFT JOIN account_home ah
ON di . disk_id = ah . disk_id AND ah . spread = 105 LEFT JOIN
account_info ai ON ah . account_id = ai . account_id GROUP BY di .
disk_id , di . host_id , di . path , ah . spread
2004-09-07 15:58:50 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT count ( ah . account_id ) , ah . spread , di . disk_id
, di . host_id , di . path FROM disk_info di LEFT JOIN account_home ah
ON di . disk_id = ah . disk_id AND ah . spread = 105 LEFT JOIN
account_info ai ON ah . account_id = ai . account_id GROUP BY di .
disk_id , di . host_id , di . path , ah . spread
2004-09-07 15:58:53 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 20
2004-09-07 15:58:53 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 20
2004-09-07 15:58:53 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 20
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM value_domain_code WHERE code_str =
'account_names'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM value_domain_code WHERE code_str =
'account_names'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM value_domain_code WHERE code_str =
'account_names'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM authentication_code WHERE code_str =
'crypt3-DES'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM authentication_code WHERE code_str =
'crypt3-DES'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM authentication_code WHERE code_str =
'crypt3-DES'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM authoritative_system_code WHERE code_str =
'Cached'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM authoritative_system_code WHERE code_str =
'Cached'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM authoritative_system_code WHERE code_str =
'Cached'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM person_name_code WHERE code_str = 'FULL'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM person_name_code WHERE code_str = 'FULL'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM person_name_code WHERE code_str = 'FULL'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_08456DE4"
CURSOR FOR SELECT ai . account_id , posix_uid , shell , gecos ,
entity_name , aa . auth_data , pg . posix_gid , pn . name , eq .
quarantine_type , eq . start_date , eq . disable_until , eq . end_date ,
ah . home , ah . disk_id FROM posix_user pu LEFT JOIN entity_quarantine
eq ON pu . account_id = eq . entity_id JOIN entity_spread es ON pu .
account_id = es . entity_id AND ( es . spread = 105 ) JOIN account_home
ah ON es . entity_id = ah . account_id JOIN account_info ai ON ai .
account_id = pu . account_id LEFT JOIN person_name pn ON pn . person_id
= ai . owner_id AND pn . source_system = 92 AND pn . name_variant = 117
JOIN posix_group pg ON pu . gid = pg . group_id LEFT JOIN
account_authentication aa ON aa . account_id = pu . account_id AND aa .
method = 12 JOIN entity_name en ON en . entity_id = pu . account_id AND
en . value_domain = 14 ORDER BY ai . account_id
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_08456DE4"
CURSOR FOR SELECT ai . account_id , posix_uid , shell , gecos ,
entity_name , aa . auth_data , pg . posix_gid , pn . name , eq .
quarantine_type , eq . start_date , eq . disable_until , eq . end_date ,
ah . home , ah . disk_id FROM posix_user pu LEFT JOIN entity_quarantine
eq ON pu . account_id = eq . entity_id JOIN entity_spread es ON pu .
account_id = es . entity_id AND ( es . spread = 105 ) JOIN account_home
ah ON es . entity_id = ah . account_id JOIN account_info ai ON ai .
account_id = pu . account_id LEFT JOIN person_name pn ON pn . person_id
= ai . owner_id AND pn . source_system = 92 AND pn . name_variant = 117
JOIN posix_group pg ON pu . gid = pg . group_id LEFT JOIN
account_authentication aa ON aa . account_id = pu . account_id AND aa .
method = 12 JOIN entity_name en ON en . entity_id = pu . account_id AND
en . value_domain = 14 ORDER BY ai . account_id
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_08456DE4"
CURSOR FOR SELECT ai . account_id , posix_uid , shell , gecos ,
entity_name , aa . auth_data , pg . posix_gid , pn . name , eq .
quarantine_type , eq . start_date , eq . disable_until , eq . end_date ,
ah . home , ah . disk_id FROM posix_user pu LEFT JOIN entity_quarantine
eq ON pu . account_id = eq . entity_id JOIN entity_spread es ON pu .
account_id = es . entity_id AND ( es . spread = 105 ) JOIN account_home
ah ON es . entity_id = ah . account_id JOIN account_info ai ON ai .
account_id = pu . account_id LEFT JOIN person_name pn ON pn . person_id
= ai . owner_id AND pn . source_system = 92 AND pn . name_variant = 117
JOIN posix_group pg ON pu . gid = pg . group_id LEFT JOIN
account_authentication aa ON aa . account_id = pu . account_id AND aa .
method = 12 JOIN entity_name en ON en . entity_id = pu . account_id AND
en . value_domain = 14 ORDER BY ai . account_id
2004-09-07 15:58:54 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1082
2004-09-07 15:58:54 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1082
2004-09-07 15:58:54 [8100]   LOG:  statement: SELECT typname, -1 ,
typelem FROM pg_type WHERE oid = 1082
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_brk'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_brk'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_brk'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'permisjon'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'permisjon'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'permisjon'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autointsomm'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autointsomm'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autointsomm'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_sh'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_sh'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_sh'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_nystuden'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_nystuden'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_nystuden'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autoekstern'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autoekstern'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autoekstern'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'autostud'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'autostud'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'autostud'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'system'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'system'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'system'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_ftpuser'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_ftpuser'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_ftpuser'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autopassord'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autopassord'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'autopassord'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'teppe'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'teppe'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'teppe'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'generell'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'generell'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'generell'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'slutta'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'slutta'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'slutta'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_stengt'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_stengt'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'nologin_stengt'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'svakt_passord'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'svakt_passord'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str =
'svakt_passord'
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: CLOSE "PgSQL_083326D4"
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'nologin'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'nologin'
2004-09-07 15:58:54 [8100]   LOG:  statement: DECLARE "PgSQL_083326D4"
CURSOR FOR SELECT code FROM quarantine_code WHERE code_str = 'nologin'
------------------------------------------------------

Thanks in advance, any help will be appreciated.

-- 
 Rafael Martinez, <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
 Center for Information Technology Services
 University of Oslo, Norway

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-09-07 17:58:25
Subject: Re: PosgreSQL is crashing with a signal 11 - Bug?
Previous:From: Gaetano MendolaDate: 2004-09-07 17:00:16
Subject: Re: BUG #1244: Postgres doesn't work on FAT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group