Thread: Crash (maybe related to temp tables)

Crash (maybe related to temp tables)

From
Daniele Orlandi
Date:
Hi,

Using PostgreSQL 6.5.2 just compiled on a RedHat 6.0 box.

------------------------
BEGIN;

SELECT username,count(*) AS nsessions INTO TEMP TABLE active_nsessions FROM
active GROUP BY username

SELECT username,count(*) AS nlinks INTO TEMP TABLE active_nlinks FROM active
GROUP BY username,port,server

SELECT * FROM active,counters,users,active_nsessions,active_nlinks WHERE
active.username=users.username AND active.username=counters.username AND
active.username=active_nsessions.username AND
active.username=active_nlinks.username

pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
  before or while processing the request.
 
------------------------

Active table is empty with this structure:

CREATE TABLE active
(username               varchar(32),server                 varchar(35),pop                    varchar(20),remAddr
        varchar(30),port                   varchar(15),service                varchar(10),addr
inet,privilege             int2,authenmethod           int2,authentype             int2,authenservice
int2,starttime             datetime,taskid                 int4,callerid               varchar(21),callednumber
 varchar(21),rxrate                 int4,txrate                 int4,
 
bytesin                int8,bytesout               int8,paksin                 int8,paksout                int8,
watchdog_timeout       timespan,watchdog_lastreset     datetime,
logout_requested       bool,logout_request_time    datetime
);

Bye!

-- Daniele

-------------------------------------------------------------------------------Daniele Orlandi - Utility Line Italia -
http://www.orlandi.comViaMezzera 29/A - 20030 - Seveso (MI) - Italy
 
-------------------------------------------------------------------------------