Thread: Crashes in Query Window - PgAdmin 1.6 Beta SVN Head

Hello,<br /><br />I am using a kindly-by-Dave-provided PgAdmin 1.6 Beta from SVN Head as of 2006-09-19 9:07.<br /><br
/>Withinthe Query Window I am developping a query:<br /><br />select
md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf),* from repofeld   <F5> <br /><br clear="all" />select
md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf||anothercol1),* from repofeld  <F5><br />select
md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf||anothercol1||anothercol2),* from repofeld  <F5> <br
/><br/>[....]<br /><br />and after around 20-30 runs of this query, PgAdmin "hard crashes" (phone home to MS type of
crash)<br/><br />As much as I am able to analyze, it happens after numerous queries containing "no real colums" ->
thatmd5(whatever) is ?column? in output, and everytime a different result - as I am developing this function (learning
whereI have to cast by hand etc...) <br /><br />Can it be that the "caching of column heads" could be responsible in
someway, Dave?<br /><br />If I can do anything more to make it reproducable, please let me know.<br /><br />Harald<br
/><br/><br />-- <br />GHUM Harald Massa <br />persuadere et programmare<br />Harald Armin Massa<br />Reinsburgstraße
202b<br/>70197 Stuttgart<br />0173/9409607<br />-<br />Let's set so double the killer delete select all.  

---

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Harald Armin Massa
Sent: 20 September 2006 10:59
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Crashes in Query Window - PgAdmin 1.6 Beta SVN Head

Hello,

I am using a kindly-by-Dave-provided PgAdmin 1.6 Beta from SVN Head as of 2006-09-19 9:07.

Within the Query Window I am developping a query:

select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf), * from repofeld   <F5>

select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf||anothercol1), * from repofeld  <F5>
select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf||anothercol1||anothercol2), * from repofeld  <F5>

[....]

and after around 20-30 runs of this query, PgAdmin "hard crashes" (phone home to MS type of crash)

As much as I am able to analyze, it happens after numerous queries containing "no real colums" -> that md5(whatever) is ?column? in output, and everytime a different result - as I am developing this function (learning where I have to cast by hand etc...)

Can it be that the "caching of column heads" could be responsible in some way, Dave?
 

I am developing this sort of query since last friday. And only since yesterday (= update Beta 1.6) I am plagued with
thosecrashes within the query window. (it is no complete prove that it worked - but on monday I developed this query
foraround 5 tables, without plague of crashes; and yesterday / today I did it for 2 1/2 tables, and had around 6
crashes)<br /><br />After sending the mail I continued to work on that query; and thistime I named the column, that
is<br/><br />select md5(whatever) as checksum, * from tablename<br /><br />and: no crash (so far)<br /><br />Maybe sth.
elsechanged I do not know of. Will keep on doing this on 3 more tables, <br /><br />Harald<br /><br /><br /><br
clear="all"/><br />-- <br />GHUM Harald Massa<br />persuadere et programmare<br />Harald Armin Massa<br
/>Reinsburgstraße202b<br />70197 Stuttgart<br />0173/9409607<br />-<br />Let's set so double the killer delete select
all. 

---

From: Harald Armin Massa [mailto:haraldarminmassa@gmail.com]
Sent: 20 September 2006 12:16
To: Dave Page
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Crashes in Query Window - PgAdmin 1.6 Beta SVN Head

I am developing this sort of query since last friday. And only since yesterday (= update Beta 1.6) I am plagued with those crashes within the query window. (it is no complete prove that it worked - but on monday I developed this query for around 5 tables, without plague of crashes; and yesterday / today I did it for 2 1/2 tables, and had around 6 crashes)

After sending the mail I continued to work on that query; and thistime I named the column, that is

select md5(whatever) as checksum, * from tablename

and: no crash (so far)

Maybe sth. else changed I do not know of. Will keep on doing this on 3 more tables, 
 

---

From: Harald Armin Massa [mailto:haraldarminmassa@gmail.com]
Sent: 20 September 2006 13:17
To: Dave Page
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Crashes in Query Window - PgAdmin 1.6 Beta SVN Head

The dataset is some 1000 rows; usually while developing I limit to 10. I did it again: developed a query, and just as I was finishing - crash. (this time without "as checksum")

Wil do it again, with "as checksum" ... and it works.

I keep on trying to make it reproducible, with a limit amount of data.