Re: Windows 10 - pg4 Query Initialization Issue

Hi Michael,

Thanks for sharing the proper logs.
The similar issue has been reported earlier. Reference:
https://redmine.postgresql.org/issues/3433

After checking your logs, it is confirmed that the issue is with version
loader on windows and that has been fixed as part of RM #3324 : the
https://redmine.postgresql.org/issues/3324.

This fix will be available in the next release of pgAdmin 4.

Thanks,
Khushboo

On Thu, Jun 21, 2018 at 12:05 AM, Michael Zsolt <michael(dot)zsolt(at)gmail(dot)com>
wrote:

> Thanks Kushboo. Just wanted to double check where this stands - is this
> something you guys are looking into? I think I can still access and query
> my DB using R, but wanted to see if this was 'on the shelf' somewhere or if
> its still on your radar.
>
> Thanks again for your help,
>
> Mike
>
> On Fri, Jun 15, 2018 at 1:10 AM Khushboo Vashi <
> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>> Adding pgAdmin Support....
>>
>> On Thu, Jun 14, 2018 at 9:32 PM, Michael Zsolt <michael(dot)zsolt(at)gmail(dot)com>
>> wrote:
>>
>>> Hi Khushboo,
>>>
>>> Thanks for the quick follow up. I have attached a new log which appears
>>> to relate to pgAdmin 4. Your link was helpful though I have not yet been
>>> able to* "create a file called config_local.py"*. I apologize for my
>>> naive-ness with pgAdmin and Postgres - some of these issues I have run into
>>> on my very first interactions with the software. Is this file attached what
>>> you need? If you need me to proceed with creating 'config_local.py', I have
>>> a question or two below:
>>>
>>> 1) For some reason, my pgAdmin folder is under Program Files (where I
>>> installed it) and the attached log file was under my 'user' folder
>>> - C:\Users\micha. I am guessing this is because I may not be technically
>>> the administrator on my computer, but I am not sure
>>>
>>> 2) It may be due to the the reason above, but I was not able to find a
>>> 'config.py' file in general.
>>>
>>> Let me know what you need and I will continue trying to provide.
>>>
>>> Thanks again,
>>>
>>> Mike
>>>
>>> PS - Ultimately I plan to interact with the database predominately via
>>> R. If you know any tutorials focused on 'creating your first PostgreSQL
>>> database and connect using R', please pass them along! This Query
>>> Initialization issue may no longer be a problem if I could connect in R....
>>>
>>>
>>>
>>> On Thu, Jun 14, 2018 at 6:27 AM Khushboo Vashi <
>>> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>
>>>> I was talking about pgAdmin4 log not postgres logs.
>>>> Please refer how to enable logginf.
>>>> https://www.pgadmin.org/faq/#8
>>>>
>>>> On Thu, Jun 14, 2018 at 12:28 PM, Michael Zsolt <
>>>> michael(dot)zsolt(at)gmail(dot)com> wrote:
>>>>
>>>>> Hi there
>>>>>
>>>>> Happy to help. Unfortunately I am quite new to SQL and postgres. Can
>>>>> you walk me through how to turn on debug mode and identify the log files?
>>>>> Within my postgres folder I found 3 files under 'data' and 'log'
>>>>> subfolders, which I have attached. Mostly these seem to contain info about
>>>>> me setting up users/a new table and struggling somewhat. None of them
>>>>> explicitly relate to the query initialization error, from what I can tell -
>>>>> and that is consistent from what I have read on forums from other people
>>>>> who have had this problem (i.e. even with debug mode on, nothing shows up
>>>>> in logs apparently). You will see that a few moments ago (in 2018-06-10) I
>>>>> was able to open the query tool for one of the demo schemas I have created
>>>>> (only one worked). That said, overall the problem still persists.
>>>>>
>>>>> Thanks in advance
>>>>>
>>>>> Mike
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Jun 14, 2018 at 2:14 AM Khushboo Vashi <
>>>>> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, Jun 11, 2018 at 7:32 PM, Michael Zsolt <
>>>>>> michael(dot)zsolt(at)gmail(dot)com> wrote:
>>>>>>
>>>>>>> Hi there
>>>>>>>
>>>>>>> Please see forwarded email and attachments below. Dave Page passed
>>>>>>> along this address after I reached out to him.
>>>>>>>
>>>>>>> Thank you in advance
>>>>>>>
>>>>>>> Mike
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> ---------- Forwarded message ---------
>>>>>>> From: Michael Zsolt <michael(dot)zsolt(at)gmail(dot)com>
>>>>>>> Date: Sun, Jun 10, 2018 at 9:25 AM
>>>>>>> Subject: Windows 10 - pg4 Query Initialization Issue
>>>>>>> To: <dpage(at)pgadmin(dot)org>
>>>>>>>
>>>>>>>
>>>>>>> Hi Dave,
>>>>>>>
>>>>>>> Hope you are well. I found your information online that you are the
>>>>>>> 'maintainer' for pgAdmin. I ran into an issue (which seems to be a bug?) so
>>>>>>> wanted to just flag it to you and provide any helpful info I can about the
>>>>>>> product. I am quite new to PostgreSQL (I have R experience but very limited
>>>>>>> in SQL), so I apologize if my email lacks important details - happy to
>>>>>>> provide more upon request.
>>>>>>>
>>>>>>> The issue is simple - the majority of the time I try to use the
>>>>>>> Query Tool in pgAdmin 4 (via web browser), it gives the error message
>>>>>>> attached. This happens when I am using the UI or the shortcut keys. Once or
>>>>>>> twice I managed to use the Query Tool successfully, but it is not clear
>>>>>>> what was unique in those circumstances. I tried uninstalling and
>>>>>>> reinstalling, and I think the successful Query Tools happened as the *first
>>>>>>> couple* tries after I reinstalled - thereafter it has not worked
>>>>>>> since.
>>>>>>>
>>>>>>> The issue seems to have come up on some help forums, so I will try
>>>>>>> to answer some of the questions posed there in advance:
>>>>>>>
>>>>>>> - I am using version 10.4 that I downloaded from this link:
>>>>>>> https://www.enterprisedb.com/downloads/
>>>>>>> postgres-postgresql-downloads
>>>>>>> <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads>
>>>>>>> - I installed with the auto-install wizard from that link
>>>>>>> - Previously I was learning from version 9.X (not sure) which
>>>>>>> had a desktop-based client, rather than web-based, and it did not have this
>>>>>>> issue
>>>>>>> - I am on 64 bit Windows 10 - system specs also attached in a
>>>>>>> screenshot
>>>>>>> - I have not attached a log file with debug mode on, but others
>>>>>>> seem to have tried that and said 'the log file provides limited information
>>>>>>> to help'
>>>>>>>
>>>>>>> Log file would be helpful here. Please attach the log file with
>>>>>> debug mode on.
>>>>>>
>>>>>>> I work for an ice hockey team and plan to use postgres to manage our
>>>>>>> data next season (starting by the end of the summer) - and am hoping to
>>>>>>> keep learning more from now to then. Any guesses when you might have this
>>>>>>> fixed? Or workarounds you would propose in the mean time? I appreciate your
>>>>>>> help and let me know if there is anything else I can do.
>>>>>>>
>>>>>>> Thanks in advance
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Mike
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> *Michael Zsolt*
>>>>>>> Director of Analytics, Kitchener Rangers
>>>>>>> E: michael(dot)zsolt(at)gmail(dot)com <MZsolt(dot)HBA2012(at)ivey(dot)ca>
>>>>>>> --
>>>>>>>
>>>>>>> Michael Zsolt, HBA 2012
>>>>>>> Director of Analytics, Kitchener Rangers
>>>>>>> T: (416)-721-5927
>>>>>>> E: michael(dot)zsolt(at)gmail(dot)com
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> *Michael Zsolt*, HBA 2012
>>>>> Director of Analytics, Kitchener Rangers
>>>>> T: (416) 721-5927
>>>>> E: michael(dot)zsolt(at)gmail(dot)com <MZsolt(dot)HBA2012(at)ivey(dot)ca>
>>>>>
>>>>
>>>>
>>>
>>> --
>>>
>>> *Michael Zsolt*, HBA 2012
>>> Director of Analytics, Kitchener Rangers
>>> T: (416) 721-5927
>>> E: michael(dot)zsolt(at)gmail(dot)com <MZsolt(dot)HBA2012(at)ivey(dot)ca>
>>>
>>
>>
>
> --
>
> *Michael Zsolt*, HBA 2012
> Director of Analytics, Kitchener Rangers
> T: (416) 721-5927
> E: michael(dot)zsolt(at)gmail(dot)com <MZsolt(dot)HBA2012(at)ivey(dot)ca>
>