HomeFlySpeed SQL Query100% Crash after query on 4 views

100% Crash after query on 4 views


Windows Vista or XP.
PostgreSQL 8.3
4 tables (views created at the server), joined.
Crash is 100% repeatable and unavoidable. Just before the crash the junk data is returned. This query at SQL window of PgAdmin works excelent.
zgred | email
November 2 2009, 12:51 AM
Can you send us the query (text)?
Sergey Smagin | email
8 hours, 53 mins since original post
Are these views contain some non-standard data types (geomtric, object, etc.)?
Sergey Smagin | email
8 hours, 57 mins since original post
Views do not contain any nonstandard data types. Types are: date, numeric, character varying, integer.

Views are: SELECT <field list> FROM <table name>

The query is:

Select
Sum(tsp(prav.mod1) * prav.amt * prav.val1_z) As war_z,
btav.post_skr,
ktav.rcv As odb,
ktav.m,
nrav.tr
From
prav Left Join
nrav On prav.dt_log = nrav.dt_log And prav.wsklr = nrav.wsklr And prav.nr_r = nrav.nr_r Left Join
ktav On prav.ktr = ktav.ktr Left Join
btav On prav.ind = btav.ind
Where
prav.dt_log >= '2009.01.01' And
prav.dt_log <= '2009.01.04'
Group By
btav.post_skr, ktav.m, nrav.tr, prav.ind
Order By
nrav.tr
Limit 100

Result is near 20k rows.

(Above Query is pasted, then manually edited ,so some typing errors could hapen.)

Could you please mail me from your email address rather than through web page? I'll appreciate.
zgred | email
11 hours, 55 mins since original post
Thank you for your detailed description. We will investigate the problem and let you know about results.
Sergey Smagin | email
1 week, 2 days since original post
The problem is possibly fixed. Please let me know if you 'll have any problems with the new version of the tool.
Sergey Smagin | email
2 months, 1 week since original post
This topic is closed