Thread: Infinite loop occurs sometimes when exporting query to a file, 1.6.1
Hello, I had pgadmin logging set to debug which hopefully will help. I have attached the log. I initially had opened up a query window, wrote a query, ran it, exported it, opened up the output file in Excel, and then realized that I needed an additional column. I then closed the spreadsheet but I did not completely close Excel. I modified the query which required adding another join to get the column. I then ran the query and then attempted to export the results to a file. Pgadmin went into an infinite loop. The first query was "SELECT DISTINCT * FROM TABLE" The second query was "SELECT DISTINCT a.*, b.missing FROM TABLE A INNER JOIN TABLE2 B ON B.col = A.col" I have had to force pgadmin to shutdown to kill the race. I reopened pgadmin, did the above again, and pgadmin again went into a loop. Perhaps rebooting will fix the issue but the detail in the log file makes me think it won't. pgadmin 1.6.1, XP SP2, postgres 8.2 -- Open WebMail Project (http://openwebmail.org)
Attachment
Mike G wrote: > Hello, Hi Mike, > I had pgadmin logging set to debug which hopefully will help. I have attached the log. > I initially had opened up a query window, wrote a query, ran it, exported it, opened > up the output file in Excel, and then realized that I needed an additional column. > > I then closed the spreadsheet but I did not completely close Excel. I modified the query > which required adding another join to get the column. I then ran the query and then > attempted to export the results to a file. Pgadmin went into an infinite loop. > > The first query was "SELECT DISTINCT * FROM TABLE" > > The second query was "SELECT DISTINCT a.*, b.missing FROM TABLE A INNER JOIN TABLE2 B ON > B.col = A.col" > > I have had to force pgadmin to shutdown to kill the race. > > I reopened pgadmin, did the above again, and pgadmin again went into a loop. > > Perhaps rebooting will fix the issue but the detail in the log file makes me think it won't. Yes, agreed. > pgadmin 1.6.1, XP SP2, postgres 8.2 Much as I've tried, I just cannot reproduce this. Can you create a self contained test case that I can play with? (tables, data etc.) Thanks, Dave.
Hi Dave, Rebooting did not help. I will send you something directly. Mike On Fri, 05 Jan 2007 09:22:23 +0000, Dave Page wrote > Mike G wrote: > > Hello, > > Hi Mike, > > > I had pgadmin logging set to debug which hopefully will help. I have attached the log. > > I initially had opened up a query window, wrote a query, ran it, exported it, opened > > up the output file in Excel, and then realized that I needed an additional column. > > > > I then closed the spreadsheet but I did not completely close Excel. I modified the query > > which required adding another join to get the column. I then ran the query and then > > attempted to export the results to a file. Pgadmin went into an infinite loop. > > > > The first query was "SELECT DISTINCT * FROM TABLE" > > > > The second query was "SELECT DISTINCT a.*, b.missing FROM TABLE A INNER JOIN TABLE2 B ON > > B.col = A.col" > > > > I have had to force pgadmin to shutdown to kill the race. > > > > I reopened pgadmin, did the above again, and pgadmin again went into a loop. > > > > Perhaps rebooting will fix the issue but the detail in the log file makes me think it won't. > > Yes, agreed. > > > pgadmin 1.6.1, XP SP2, postgres 8.2 > > Much as I've tried, I just cannot reproduce this. Can you create a self > contained test case that I can play with? (tables, data etc.) > > Thanks, Dave. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Open WebMail Project (http://openwebmail.org)