Thread: FW: psql error
Please look at below mail and help me on this.
------------------------------
From: Archana.2.Shinde
Sent: 02-04-2013 11:53
To: archii4u@gmail.com
Subject: psql error
Hi postgres team,
Please could you help me to resolve this error which I am getting, I am
using postgres 7.4.5 on solaris 9.
2013-03-28 12:03:05 LOG: could not bind socket for statistics collector:
Cannot assign requested address
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 LOG: database system was interrupted at 2013-03-26
19:44:47 GMT
2013-03-28 12:03:05 LOG: checkpoint record is at 338B/87AC3F68
2013-03-28 12:03:05 LOG: redo record is at 338B/87AC3F68; undo record is
at 0/0; shutdown TRUE
2013-03-28 12:03:05 LOG: next transaction ID: 210567474; next OID:
283025408
2013-03-28 12:03:05 LOG: database system was not properly shut down;
automatic recovery in progress
2013-03-28 12:03:05 LOG: record with zero length at 338B/87AC3FA8
2013-03-28 12:03:05 LOG: redo is not required
2013-03-28 12:03:06 LOG: connection received: host=[local] port=
2013-03-28 12:03:06 FATAL: the database system is starting up
2013-03-28 12:03:06 LOG: connection received: host=[local] port=
2013-03-28 12:03:06 FATAL: the database system is starting up
2013-03-28 12:03:07 LOG: connection received: host=[local] port=
2013-03-28 12:03:07 FATAL: the database system is starting up
2013-03-28 12:03:07 LOG: connection received: host=[local] port=
2013-03-28 12:03:07 FATAL: the database system is starting up
2013-03-28 12:03:07 LOG: connection received: host=[local] port=
2013-03-28 12:03:07 FATAL: the database system is starting up
2013-03-28 12:03:08 LOG: database system is ready
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:16 LOG: connection received: host=[local] port=
2013-03-28 12:03:16 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:16 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:16 LOG: connection received: host=[local] port=
2013-03-28 12:03:16 LOG: connection received: host=[local] port=
2013-03-28 12:03:17 2013-03-28 12:03:17 LOG: connection received:
host=[local] port=
2013-03-28 12:03:17 2013-03-28 12:03:17 2013-03-28 12:03:17 LOG:
connection authorized: user=mcdonner database=template1
LOG: connection authorized: user=mcdonner database=template1
LOG: connection received: host=[local] port=
LOG: connection received: host=[local] port=
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:17 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:17 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:22 LOG: connection received: host=[local] port=
2013-03-28 12:03:22 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 2013-03-28 12:03:23 ERROR: database "backupnetwork"
does not exist
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 LOG: connection authorized: user=mcdonner
database=template1
LOG: connection authorized: user=mcdonner database=template1
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:26 LOG: connection received: host=[local] port=
2013-03-28 12:03:26 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:26 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:36 LOG: connection received: host=[local] port=
2013-03-28 12:03:36 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:36 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 19:59:56 ERROR: database "backupnetwork" does not exist
2013-03-28 19:59:56 LOG: connection received: host=[local] port=
2013-03-28 19:59:56 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 19:59:56 ERROR: database "backupnetwork" does not exist
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:12 2013-03-28 20:00:12 LOG: connection authorized:
user=mcdonner database=template1
LOG: connection authorized: user=mcdonner database=template1
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
TopMemoryContextTopMemoryContext: 24576: total in 245762 total in blocks;
210272 blocks; free (102722 free ( chunks); 2143
04 chunks); used
14304CacheMemoryContext used
: CacheMemoryContext8192: total in 81921 total in blocks; 12864 blocks;
free (28640 free ( chunks); 05328 chunks); used
5328pg_class_oid_index used
: pg_class_oid_index1024: total in 10241 total in blocks; 1640 blocks;
free (6400 free ( chunks); 0384 chunks); used
384MdSmgr used
: MdSmgr8192: total in 81921 total in blocks; 16120 blocks; free (61200
free ( chunks); 02072 chunks); used
2072DynaHash used
: DynaHash8192: total in 81921 total in blocks; 14664 blocks; free
(46640 free ( chunks); 03528 chunks); used
3528DynaHashTable used
: DynaHashTable8192: total in 81921 total in blocks; 15080 blocks; free
(50800 free ( chunks); 03112 chunks); used
3112DynaHashTable used
: DynaHashTable8192: total in 81921 total in blocks; 15080 blocks; free
(50800 free ( chunks); 03112 chunks); used
3112DynaHashTable used
: DynaHashTable8192: total in 81921 total in blocks; 15080 blocks; free
(50800 free ( chunks); 03112 chunks); used
3112DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
(TopMemoryContext0 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
ErrorContextErrorContext: : 81928192 total in total in 11 blocks; blocks;
81768176 free ( free (44 chunks); chunks); 1616
used
used
: 2013-03-28 20:00:12 2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 112.
FATAL: out of memory
DETAIL: Failed on request of size 112.
24576TopMemoryContext total in TopMemoryContext2 blocks; 10272 free (2
chunks); 14304 used
CacheMemoryContext: 8192 total in 1 blocks; 2864 free (0 chunks); 5328 used
pg_class_oid_index: 1024 total in 1 blocks; 640 free (0 chunks); 384 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 4664 free (0 chunks); 3528 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 112.
DETAIL: Failed on request of size 112.
: 24576 total in 2 blocks; 10272 free (2 chunks); 14304 used
CacheMemoryContext: 8192 total in 1 blocks; 2864 free (0 chunks); 5328 used
pg_class_oid_index: 1024 total in 1 blocks; 640 free (0 chunks); 384 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 4664 free (0 chunks); 3528 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 112.
2013-03-28 20:00:12 LOG: connection received: host=[local] port=
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
: 24576 total in 2 blocks; 10680 free (2 chunks); 13896 used
CacheMemoryContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 4952 free (0 chunks); 3240 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 1024.
2013-03-28 20:00:37 LOG: could not fork checkpoint process: Not enough
space
2013-03-28 20:00:40 LOG: server process (PID 224) was terminated by signal
11
2013-03-28 20:00:40 LOG: terminating any other active server processes
2013-03-28 20:00:40 LOG: all server processes terminated; reinitializing
2013-03-28 20:00:41 FATAL: could not create shared memory segment: Not
enough space
DETAIL: Failed system call was shmget(key=5432001, size=118464512, 03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space
. To reduce the request size (currently 118464512 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 14080) and/
or its max_connections parameter (currently 40).
The PostgreSQL documentation contains more information about shared
memory configuration.
============================================================================================================================Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you
may review the policy at http://www.techmahindra.com/Disclaimer.html
externally and http://tim.techmahindra.com/tim/disclaimer.html
internally within Tech
Mahindra.============================================================================================================================
archana shinde wrote: > Please look at below mail and help me on this. > Please could you help me to resolve this error which I am getting, I am using postgres 7.4.5 on > solaris 9. [...] > 2013-03-28 20:00:12 FATAL: out of memory > DETAIL: Failed on request of size 112. [...] > 2013-03-28 20:00:12 FATAL: out of memory > DETAIL: Failed on request of size 1024. > 2013-03-28 20:00:37 LOG: could not fork checkpoint process: Not enough space > 2013-03-28 20:00:40 LOG: server process (PID 224) was terminated by signal 11 > 2013-03-28 20:00:40 LOG: terminating any other active server processes > 2013-03-28 20:00:40 LOG: all server processes terminated; reinitializing > 2013-03-28 20:00:41 FATAL: could not create shared memory segment: Not enough space > DETAIL: Failed system call was shmget(key=5432001, size=118464512, 03600). > HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded > available memory or swap space > . To reduce the request size (currently 118464512 bytes), reduce PostgreSQL's shared_buffers parameter > (currently 14080) and/ > or its max_connections parameter (currently 40). > > The PostgreSQL documentation contains more information about shared memory configuration. 7.4 has been out of support for a while. This looks like you cannot allocate enough shared memory. If there is enough RAM in the machine, consider increasing SHMALL (or maybe SHMMNI). Yours, Laurenz Albe