a small problem with current CVS - wondering how to debug

Поиск
Список
Период
Сортировка
От teunis
Тема a small problem with current CVS - wondering how to debug
Дата
Msg-id Pine.LNX.3.96.980115123753.7294A-100000@sigil.computersupportcentre.com
обсуждение исходный текст
Список pgsql-hackers
I keep getting:

Too Large Allocation Request("!(0 < (size) && (size) <=
(0xfffffff)):size=-3 [0xfffffffd]", File: "mcxt.c", Line: 232)
!(0 < (size) && (size) <= (0xfffffff)) (0) [No such file or directory]

from a simple select:

SELECT * from provinces;

incidentally, "SELECT oid from provinces;" works...
(as does any select on one component)... but checking...
Nope - countrycode fails.  Prints out garbage (8bit garbage at that)
As do all fields after that - though they're just bad data.

For comparison, I have another database with "varchar(50), integer,
timestamp, timestamp" - and the only noncorrupted field is the first
varchar() entry.  Perhaps it's in the string-handling?

The contents of the database:
---
CREATE TABLE provinces
  (
  code        char(4),    -- ...
  name        varchar(50),    -- ...
  countrycode    char(2),    -- ...
  country    varchar(50),    -- ...

  -- creation and modification dates of this record...
  creationdate    timestamp default now(),
  modifydate    timestamp default now()
  );

INSERT INTO provinces (code, name, countrycode, country)
    VALUES ('bc','British Columbia','ca','Canada');
INSERT INTO provinces (code, name, countrycode, country)
    VALUES ('ab','Alberta',         'ca','Canada');
INSERT INTO provinces (code, name, countrycode, country)
    VALUES ('alta','Alberta',       'ca','Canada');
-- one gets tired of databases referring to "state"... so time to turn the
-- tables *grin*
INSERT INTO provinces (code, name, countrycode, country)
    VALUES ('wa', 'Washington',    'us','United States');
---

Incidentally, this worked perfectly up 'till christmas-CVS.  I had some
other problems so I upgraded... and now it core-dumps 'psql' and sends
this to the backend.

On debugging psql I found the error in "UP()", but as I don't know how to
use gdb properly I can't look any deeper (I've always preferred logfiles -
especially when working on videodriver code :)
[mayhaps psql needs better recovery code... will have to look at that
sometime]

JDBC also fails FWIW - with these messages:  (same query)
java.sql.SQLException: Error reading from backend: java.io.IOException: EOF
        at postgresql.PG_Stream.ReceiveInteger(PG_Stream.java:184)
        at postgresql.PG_Stream.ReceiveTuple(PG_Stream.java:256)
        at postgresql.Connection.ExecSQL(Connection.java:626)
        at postgresql.Statement.execute(Statement.java:259)
        at postgresql.Statement.executeQuery(Statement.java:46)
        at Mauve.Main.readProvinces(Main.java:234)
        at Mauve.Main.main(Main.java:363)
java.sql.SQLException: I/O Error: java.io.IOException: Broken pipe
        at postgresql.Connection.ExecSQL(Connection.java:583)
        at postgresql.Statement.execute(Statement.java:259)
        at postgresql.Statement.executeQuery(Statement.java:46)
        at Mauve.Main.readPaymentForms(Main.java:252)
        at Mauve.Main.main(Main.java:366)

I suspect a bug somewhere - but don't know how to find it.  Or if my
data's incorrect.... many things have changed in postgres.

Platform:
    linux 2.0.33  (got tired of being flamed for using 2.1 kernels)
    glibc-2.0.5c  (standard!  ref: redhat-5.0)
    gcc 2.7.2.1   (I also have egc-1.0 but I don't trust it yet)
    Cyrix 6x86, 40M ram, ~5G drivespace

Though it's nice to finally see large objects working *grin*.

G'day, eh? :)
    - Teunis


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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Re: [QUESTIONS] Arrays (inserting and removing)
Следующее
От: The Hermit Hacker
Дата:
Сообщение: *Major* Patch for PL