Crash on select?

Поиск
Список
Период
Сортировка
От bse@games.global.co.za
Тема Crash on select?
Дата
Msg-id Pine.LNX.4.05.9906110811010.31485-100000@games.global.co.za
обсуждение исходный текст
Список pgsql-hackers
One Beeg Table:

---snip---
/dev/hdc1            6033323 5414189   306672     95%   /var/lib/pgsql
---snip---

---snip---
local-mon:/var/lib/pgsql/data/base/corona # ls -l iptraffic*
-rw-------   1 postgres daemon   2147475456 Jun 11 03:16 iptraffic
-rw-------   1 postgres daemon   2147475456 Jun 11 03:16 iptraffic.1
-rw-------   1 postgres daemon   1225385984 Jun 11 08:09 iptraffic.2
---snip---

One Query:

---snip---
select sum(size) from iptraffic where date = '19990601';
pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
beforeor
 
while processing the request.
We have lost the connection to the backend, so further processing is
impossible.  Terminating.
---snip---

One `tail /var/log/postgres.log`

---snip---
DEBUG:  --Relation pg_indexes--
DEBUG:  Pages 0: Changed 0, Reapped 0, Empty 0, New 0; Tup 0: Vac 0, Crash
0, Un
Used 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0;
EndEmpty/Avail. Pag
es 0/0. Elapsed 0/0 sec.
ERROR:  parser: parse error at or near "*"
ERROR:  parser: parse error at or near "*"
ERROR:  parser: parse error at or near """
ERROR:  parser: parse error at or near "*"
ERROR:  iptraffic: cannot extend
TRAP: Failed Assertion("!((*(&(buf->io_in_progress_lock)) == 0)):", File:
"bufmg
r.c", Line: 656)

!((*(&(buf->io_in_progress_lock)) == 0)) (0)
ERROR:  parser: parse error at or near ";"
---


Why the "-" sign?

---snip---
>select sum(size) from iptraffic where date = '19990601';      sum
----------
-393538142
(1 row)
---snip---

Thanks!
ChrisG



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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Beta4 Available ...
Следующее
От: Goran Thyni
Дата:
Сообщение: locales and MB (was: Postgres 6.5 beta2 and beta3 problem)