| From: | archana shinde <archii4u(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | FW: psql error |
| Date: | 2013-04-02 06:25:48 |
| Message-ID: | -1500769024086802266@unknownmsgid |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Please look at below mail and help me on this.
------------------------------
From: Archana.2.Shinde
Sent: 02-04-2013 11:53
To: archii4u(at)gmail(dot)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.============================================================================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Guyot (English) | 2013-04-02 14:29:34 | Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? |
| Previous Message | Armand du Plessis | 2013-04-01 22:09:12 | Problems with pg_locks explosion |