Thread: Failed to write to history file

<font face="Times New Roman" size="3"> </font><p class="MsoPlainText" style="margin:0cm 0cm 0pt"><font
face="Calibri"><fontsize="3">Hi,</font></font><font face="Times New Roman" size="3"> </font><p class="MsoPlainText"
style="margin:0cm0cm 0pt"><font face="Calibri" size="3"> </font><font face="Times New Roman" size="3"> </font><p
class="MsoPlainText"style="margin:0cm 0cm 0pt"><font face="Calibri"><font size="3">every time I execute a query using
theQuery Tool in PGAdmin, the message "Failed to write to history file!" appears.</font></font><font face="Times New
Roman"size="3"> </font><p class="MsoPlainText" style="margin:0cm 0cm 0pt"><font face="Calibri"><font size="3">The
queriesdo execute correctly.</font></font><font face="Times New Roman" size="3"> </font><p class="MsoPlainText"
style="margin:0cm0cm 0pt"><font face="Calibri"><font size="3">The history file exists, and I can write in it using a
texteditor.</font></font><font face="Times New Roman" size="3"> </font><p class="MsoPlainText" style="margin:0cm 0cm
0pt"><fontface="Calibri"><font size="3">Changing the path name in pgAdmin's "File|Options|Query tool files | History
filepath" makes pgAdmin hang.</font></font><font face="Times New Roman" size="3"> </font><p class="MsoPlainText"
style="margin:0cm0cm 0pt"><font face="Calibri"><font size="3">I am using Windows 7, PostgreSQL 9.1.2, pgAdmin
1.14.1</font></font><fontface="Times New Roman" size="3"> </font><p class="MsoPlainText" style="margin:0cm 0cm
0pt"><fontface="Calibri" size="3"> </font><font face="Times New Roman" size="3"> </font><p class="MsoPlainText"
style="margin:0cm0cm 0pt"><font face="Calibri"><font size="3">Thanks in advance for your help,</font></font><font
face="TimesNew Roman" size="3"> </font><p class="MsoPlainText" style="margin:0cm 0cm 0pt"><font face="Calibri"
size="3"> </font><fontface="Times New Roman" size="3"> </font><p class="MsoPlainText" style="margin:0cm 0cm 0pt"><font
face="Calibri"><fontsize="3">Michel</font></font><font face="Times New Roman" size="3"> </font> 

On Fri, 2012-02-24 at 14:43 +0100, michel boekestein wrote:
> Hi,
> 
> 
> 
> every time I execute a query using the Query Tool in PGAdmin, the message
> "Failed to write to history file!" appears.
> 
> The queries do execute correctly.
> 
> The history file exists, and I can write in it using a text editor.
> 
> Changing the path name in pgAdmin's "File|Options|Query tool files |
> History file path" makes pgAdmin hang.
> 
> I am using Windows 7, PostgreSQL 9.1.2, pgAdmin 1.14.1
> 

Is there any accent in the file path? pgAdmin tries to use it as a UTF8
string, but it may bring some issues with different encodings, just as
Windows.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

On Mon, 2012-02-27 at 11:34 +0100, michel boekestein wrote:
> No, there's no accent in the file path. It's here:
> 
> C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml
> 

Please, don't top-post.

OK, so, if it cannot write in this file, is the file writable? can you
open it, and change a query for example?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

On Mon, 2012-02-27 at 22:07 +0100, Michel Boekestein wrote:
> 
> 
> 
> Op 27 feb. 2012 om 15:28 heeft Guillaume Lelarge <guillaume@lelarge.info> het volgende geschreven:
> 
> > On Mon, 2012-02-27 at 11:34 +0100, michel boekestein wrote:
> >> No, there's no accent in the file path. It's here:
> >> 
> >> C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml
> >> 
> > 
> > Please, don't top-post.
> > 
> > OK, so, if it cannot write in this file, is the file writable? can you
> > open it, and change a query for example?
> > 
> > 
> > 
> 
> yes.

If I send you a patch to get more informations, can you apply it and
compile pgAdmin?

If you cannot compile it, can you send me your history file and the
query you execute before you get this message?

Oh, and can you check on 1.14.2, see if it still fails?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

Op 27 feb. 2012 om 15:28 heeft Guillaume Lelarge <guillaume@lelarge.info> het volgende geschreven:

> On Mon, 2012-02-27 at 11:34 +0100, michel boekestein wrote:
>> No, there's no accent in the file path. It's here:
>>
>> C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml
>>
>
> Please, don't top-post.
>
> OK, so, if it cannot write in this file, is the file writable? can you
> open it, and change a query for example?
>
>
>

yes.

On Thu, 2012-03-08 at 17:27 +0100, michel boekestein wrote:
> 
> 
> Op 27 februari 2012 22:28 schreef Guillaume Lelarge
> <guillaume@lelarge.info> het volgende:
>         On Mon, 2012-02-27 at 22:07 +0100, Michel Boekestein wrote:
>         >
>         >
>         >
>         > Op 27 feb. 2012 om 15:28 heeft Guillaume Lelarge
>         <guillaume@lelarge.info> het volgende geschreven:
>         >
>         > > On Mon, 2012-02-27 at 11:34 +0100, michel boekestein
>         wrote:
>         > >> No, there's no accent in the file path. It's here:
>         > >>
>         > >> C:\Users\boekestein\AppData\Roaming\postgresql
>         \pgadmin_histoqueries.xml
>         > >>
>         > >
>         > > Please, don't top-post.
>         > >
>         > > OK, so, if it cannot write in this file, is the file
>         writable? can you
>         > > open it, and change a query for example?
>         > >
>         > >
>         > >
>         >
>         > yes.
>         
>         
>         If I send you a patch to get more informations, can you apply
>         it and
>         compile pgAdmin?
>         
>  
> I'm afraid I can't
>  
>         If you cannot compile it, can you send me your history file
>         and the
>         query you execute before you get this message?
>  
> It executes before every query. See attachment for the history file.
>  
>         
>         Oh, and can you check on 1.14.2, see if it still fails?
>  
> Yep, it still fails
>  

Well. I tried with your file, and don't have any issues. I'm unable to
reproduce your issue.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com