disk full scenario

Поиск
Список
Период
Сортировка
От surabhi.ahuja
Тема disk full scenario
Дата
Msg-id 8626C1B7EB748940BCDD7596134632BE39867D@jal.iiitb.ac.in
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения
if disk is near to full
 
and i establish a connection with postgres and read a table and then close
the following error logs comes in postgreslog:
 
17:10:47 CDT%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-05 17:10:47 CDT%idle>LOG:  disconnection: session time: 0:00:00.00 user=sdc database=dbexpress host=[local] port=
<2006-04-05 17:10:47 CDT%idle>LOG:  disconnection: session time: 7:41:26.70 user=sdc database=dbexpress host=[local] port=
<2006-04-05 17:10:47 CDT%>ERROR:  could not access status of transaction 0
<2006-04-05 17:10:47 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
<2006-04-05 17:10:48 CDT%>LOG:  could not close temporary statistics file "/export/home1/sdc_image_pool/dbx/global/pgstat.tm
p.24783": No space left on device
<2006-04-05 17:10:49 CDT%>ERROR:  could not access status of transaction 0
<2006-04-05 17:10:49 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
<2006-04-05 17:10:50 CDT%>ERROR:  could not access status of transaction 0
<2006-04-05 17:10:50 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
<2006-04-05 17:10:52 CDT%>ERROR:  could not access status of transaction 0
<2006-04-05 17:10:52 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_clog/0001" at offset 40960:
No space left on device
 
and it keeps logging the same.
 
 
and later in the log i also see these messages:
<2006-04-05 23:46:37 CDT%>LOG:  could not close temporary statistics file "/export/home1/sdc_image_pool/dbx/global/pgstat.tm
p.8207": No space left on device
<2006-04-05 23:46:47 CDT%>LOG:  received fast shutdown request
<2006-04-05 23:46:47 CDT%>LOG:  shutting down
<2006-04-05 23:46:47 CDT%>PANIC:  could not access status of transaction 0
<2006-04-05 23:46:47 CDT%>DETAIL:  could not write to file "/export/home1/sdc_image_pool/dbx/pg_subtrans/0012" at offset 155
648: No space left on device
<2006-04-05 23:46:47 CDT%>LOG:  background writer process (PID 8205) was terminated by signal 6
<2006-04-05 23:46:47 CDT%>LOG:  terminating any other active server processes
<2006-04-05 23:46:47 CDT%>LOG:  all server processes terminated; reinitializing
<2006-04-05 23:46:47 CDT%>LOG:  database system shutdown was interrupted at 2006-04-05 23:46:47 CDT
<2006-04-05 23:46:47 CDT%>LOG:  checkpoint record is at 0/1FE5D4A0
<2006-04-05 23:46:47 CDT%>LOG:  redo record is at 0/1FE5D4A0; undo record is at 0/0; shutdown TRUE
<2006-04-05 23:46:47 CDT%>LOG:  next transaction ID: 1217370; next OID: 612902
<2006-04-05 23:46:47 CDT%>LOG:  database system was not properly shut down; automatic recovery in progress
<2006-04-05 23:46:47 CDT%>LOG:  record with zero length at 0/1FE5D4DC
<2006-04-05 23:46:47 CDT%>LOG:  redo is not required
<2006-04-05 23:46:47 CDT%>LOG:  database system is ready
<2006-04-05 23:46:47 CDT%>LOG:  shutting down
<2006-04-05 23:46:47 CDT%>LOG:  database system is shut down
<2006-04-05 23:46:48 CDT%>LOG:  could not write "/export/home1/sdc_image_pool/dbx/global/pg_fsm.cache": No space left on dev
ice
 
<2006-04-05 23:52:03 CDT%>LOG:  database system was shut down at 2006-04-05 23:46:47 CDT
<2006-04-05 23:52:03 CDT%>LOG:  checkpoint record is at 0/1FE5D518
<2006-04-05 23:52:03 CDT%>LOG:  redo record is at 0/1FE5D518; undo record is at 0/0; shutdown TRUE
<2006-04-05 23:52:03 CDT%>LOG:  next transaction ID: 1217370; next OID: 612902
<2006-04-05 23:52:03 CDT%>LOG:  database system is ready
<2006-04-05 23:52:04 CDT%>LOG:  connection received: host=[local] port=
<2006-04-05 23:52:04 CDT%authentication>LOG:  connection authorized: user=sdc database=template1
<2006-04-05 23:52:04 CDT%idle>LOG:  disconnection: session time: 0:00:00.00 user=sdc database=template1 host=[local] port=
<2006-04-05 23:52:05 CDT%>LOG:  connection received: host=[local] port=
<2006-04-05 23:52:05 CDT%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-05 23:52:05 CDT%idle>LOG:  disconnection: session time: 0:00:00.68 user=sdc database=dbexpress host=[local] port=
<2006-04-05 23:52:22 CDT%>LOG:  connection received: host=localhost.localdomain port=60013
<2006-04-05 23:52:22 CDT%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-05 23:53:29 CDT%>LOG:  connection received: host=[local] port=
<2006-04-05 23:53:29 CDT%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-05 23:53:47 CDT%>LOG:  connection received: host=localhost.localdomain port=60017
<2006-04-05 23:53:47 CDT%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-05 23:53:48 CDT%>LOG:  could not close temporary statistics file "/export/home1/sdc_image_pool/dbx/global/pgstat.tm
p.10771": No space left on device
<2006-04-05 23:54:02 CDT%>LOG:  connection received: host=[local] port=
<2006-04-05 23:54:02 CDT%authentication>LOG:  connection authorized: user=sdc database=dbexpress
<2006-04-05 23:54:04 CDT%>LOG:  could not close temporary statistics file "/export/home1/sdc_image_pool/dbx/global/pgstat.tm
p.10771": No space left on device
 
 
 
how much is the amt of disk space required in that.
 
i want to avoid the above process if the left disk space is some x value.
 
what is the safest value for this x?
 
thanks,
regards
Surabhi

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: postmaster services problem
Следующее
От: "Martin Kuria"
Дата:
Сообщение: Unable to connect to PostgreSQL server