| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | hackers(at)postgreSQL(dot)org (PostgreSQL-development) |
| Subject: | vacuum crash |
| Date: | 1998-10-08 00:02:45 |
| Message-ID: | 199810080002.UAA15184@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-10-08 00:08:37 | Re: [HACKERS] Dumping of views -- done! |
| Previous Message | Peter T Mount | 1998-10-07 21:51:26 | Missing file from JDBC Driver |