vacuum crash

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
vacuum crash
Дата
Msg-id
199810080002.UAA15184@candle.pha.pa.us
Список
Дерево обсуждения
Re: [HACKERS] vacuum crash "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] vacuum crash Oleg Bartunov <oleg@sai.msu.su>
Here is a modified version of the vacuum crash I am studying.

Interesting is that if I do a 'vacuum getting' instead of 'select * from
getting;vacuum;', I see a different error message.  Rather than a crash
due to an Assert(), psql shows:

	NOTICE:  AbortTransaction and not in in-progress state 
	NOTICE:  AbortTransaction and not in in-progress state 

and the postmaster log file shows:

	ERROR:  cannot write block -1 of  [] blind
	AbortCurrentTransaction
	NOTICE:  AbortTransaction and not in in-progress state 

This can be debugged by commenting out the psql command at the end,
running the script, and then running a backend from gdb and doing
'vacuum getting'.

This looks like it may be easier to track down.  Vadim, any chance you
can bail me out here, again.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

#!/bin/sh

DBNAME=ptest

destroydb $DBNAME
createdb $DBNAME
psql -e $DBNAME <
В списке pgsql-hackers по дате отправления
От: Peter T Mount
Дата:
Сообщение: Missing file from JDBC Driver
От: Bruce Momjian
Дата:
FAQ