Skip site navigation (1) Skip section navigation (2)

psql (frontend) segfaults

From: Piotr Krukowiecki <piotr(at)pingu(dot)ii(dot)uj(dot)edu(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: psql (frontend) segfaults
Date: 2001-06-18 19:59:35
Message-ID: 20010618215935.A16778@pingu.ii.uj.edu.pl (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		: Piotr Krukowiecki	
Your email address	: piotr(at)pingu(dot)ii(dot)uj(dot)edu(dot)pl


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	: Athlon 550

  Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.2.19 (RH)

  PostgreSQL version (example: PostgreSQL-7.1.1):   PostgreSQL-7.1.2

  Compiler used (example:  gcc 2.95.2)		: egcs-2.91.66


Please enter a FULL description of your problem:
------------------------------------------------

Today i upgraded postgres from 7.0.3 to 7.1.2.
First i pg_dump one database, and after installing new postgres i restored
database from dump file.
Then i tried this:
ankiety=> SELECT * from pasjans ;
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Segmentation fault
[piotr(at)pingu pgsql-backup]$

About database:
ankiety=> \d
        List of relations
    Name     |   Type   |  Owner
-------------+----------+---------
 pasjans     | table    | ankiety
 seq_pasjans | sequence | ankiety
(2 rows)

ankiety=> \d pasjans
                          Table "pasjans"
     Attribute     |  Type   |               Modifier
-------------------+---------+--------------------------------------
 klucz             | integer | default nextval('seq_pasjans'::text)
 nr_algorytmu      | integer | not null
 ilosc_ukrytych    | integer | not null
 ilosc_rotacyjnych | integer | not null
 k0                | integer | not null
 k1                | integer | not null
 k2                | integer | not null
[and so on to k61]
Index: ind_pasjans

ankiety=> SELECT count(*) from pasjans ;
 count
--------
 100121
(1 row)


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------

The problem is fully repeatable. I don't have time now to check it more.
Send me mail for more information.




pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-06-19 15:01:19
Subject: Memory leak in 7.0.3 JDBC driver
Previous:From: Stephan SzaboDate: 2001-06-18 18:03:32
Subject: Re: Referential integrity problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group