Thread: Connection & Crash Problem From Domain Users
Ok. now I have a new problem! I can use pgadmin without any problem under the local W2K accounts POSTGRES and TESTUSER. But if I run pgadmin under the domain W2K account MYDOMAIN/CAGILS it connects (and is very slowly) and then when I try toreach the public database object which is created default, it crashes (stops responding, the log runs in a loop like crazy). I can reach to postmaster using psql under MYDOMAIN/CAGILS Some info about my system conf: postgres@CAGILS /usr/share/postgresql/data $ tail -n 2 pg_hba.conf local all md5 host all 127.0.0.1 255.255.255.255 md5 postgres@CAGILS /usr/share/postgresql/data $ whoami postgres postgres@CAGILS /usr/share/postgresql/data $ psql template1 Password: Welcome to psql, the PostgreSQL interactive terminal. template1=# select * from pg_users; ERROR: Relation "pg_users" does not exist template1=# select * from pg_user; usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd | passwd | valuntil ----------+----------+-------------+----------+----------+-----------+----------+---------- postgres | 1 | t | t | t | t | ******** | infinity (1 row) Administrator@CAGILS ~ $ whoami Administrator Administrator@CAGILS ~ $ psql -U postgres template1 Password: Welcome to psql, the PostgreSQL interactive terminal. What can be the reason for this ??? tnx in advance. ------------- Çağıl ŞEKER ----------------- "Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86(Hacker's Manifesto) -----------------
> -----Original Message----- > From: Çagil Seker [mailto:cagils@biznet.com.tr] > Sent: 21 November 2002 17:27 > To: PGAdmin-Support-List (E-mail) > Subject: [pgadmin-support] Connection & Crash Problem From > Domain Users > > > Ok. now I have a new problem! > I can use pgadmin without any problem under the local W2K > accounts POSTGRES and TESTUSER. But if I run pgadmin under > the domain W2K account MYDOMAIN/CAGILS it connects (and is > very slowly) and then when I try to reach the public database > object which is created default, it crashes (stops > responding, the log runs in a loop like crazy). I can reach > to postmaster using psql under MYDOMAIN/CAGILS Hmm, interesting. It's certainly not directly related to the fact it's a domain uid - it was 100% developed using one! Canyou produce a full debug log (under Tools->Options) from connect to crash for me please? Also, what caused the change in UID 2/3 of the way through your original email? Initially you were postgres, then administrator- did you change login, or is there something going cuckoo with your Cygwin environment? Regards, Dave.
> -----Original Message----- > From: Çagil Seker [mailto:cagils@biznet.com.tr] > Sent: 23 November 2002 11:12 > To: Dave Page > Cc: PGAdmin-Support-List (E-mail) > Subject: RE: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > I am sending the full debug log of a session. From connection > setup to the crash when I click to the public object. The log > is within the attachment. Did you send the wrong log? The one you sent looks perfectly normal to me. > And thanks for your help. No problem. Regards, Dave.
As far as I can see there is nothing wrong here either. Bear in mind that with full Debug turned on, things will be *significantly*slower because not only is pgAdmin producing a full log, psqlodbc is logging things flat out as well. 1 minuteis not an unreasonable time to view aggregates (which also loads all functions) in this mode. What bandwidth to the server do you have? What spec are the client and server machines, and how loaded are they? How long does it take with logging turned off if you just let it finish? Regards, Dave. > -----Original Message----- > From: Çagil Seker [mailto:cagils@biznet.com.tr] > Sent: 25 November 2002 10:49 > To: Dave Page > Cc: PGAdmin-Support-List (E-mail) > Subject: RE: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > I opened the pgAdmin2. Change the log file to > ...CRASH...something. Then connected to postmaster. > Double-clicked the EDYS db. dc'ed the schema. dc'ed the > public object. And it stopped responding. Waited a minute. > Then closed it by CTRL-ALT-DEL. I don't know if this log file > is any different form the prev. one. Here it is.. > > Çagil SEKER > ----------------- > > -----Original Message----- > > From: Çaðýl Þeker > > Sent: 23 Kasim 2002 Cumartesi 13:12 > > To: 'Dave Page' > > Cc: PGAdmin-Support-List (E-mail) > > Subject: RE: [pgadmin-support] Connection & Crash Problem > > From Domain Users > > > > > > > -----Original Message----- > > > From: Dave Page [mailto:dpage@vale-housing.co.uk] > > > Sent: 21 Kasim 2002 Persembe 22:57 > > > To: Çaðýl Þeker; PGAdmin-Support-List (E-mail) > > > Subject: RE: [pgadmin-support] Connection & Crash Problem > > > From Domain Users > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Çagil Seker [mailto:cagils@biznet.com.tr] > > > > Sent: 21 November 2002 17:27 > > > > To: PGAdmin-Support-List (E-mail) > > > > Subject: [pgadmin-support] Connection & Crash Problem From > > > > Domain Users > > > > > > > > > > > > Ok. now I have a new problem! > > > > I can use pgadmin without any problem under the local W2K > > > > accounts POSTGRES and TESTUSER. But if I run pgadmin under > > > > the domain W2K account MYDOMAIN/CAGILS it connects (and is > > > > very slowly) and then when I try to reach the public database > > > > object which is created default, it crashes (stops > > > > responding, the log runs in a loop like crazy). I can reach > > > > to postmaster using psql under MYDOMAIN/CAGILS > > > > > > Hmm, interesting. It's certainly not directly related to the > > > fact it's a domain uid - it was 100% developed using one! Can > > > you produce a full debug log (under Tools->Options) from > > > connect to crash for me please? > > > > > > Also, what caused the change in UID 2/3 of the way through > > > your original email? Initially you were postgres, then > > > administrator - did you change login, or is there something > > > going cuckoo with your Cygwin environment? > > > > > > Regards, Dave. > > > > > > > I am sending the full debug log of a session. From connection > > setup to the crash when I click to the public object. The log > > is within the attachment. > > > > I log on to cygwin with Administrator. Then I "ssh > > postgres@localhost". The first part was with ssh. The second > > Admin. part is after I typed an "exit". Sorry, I'd snip it. > > > > And thanks for your help. > > > > Çagil SEKER > > ----------------- > > "Yes, I am a criminal. My crime is that of outsmarting you. > > Something that you'll never forgive me for!" - The Mentor'86 > > (Hacker's Manifesto) > > ----------------- > > >
the server is on the 'localhost' :) The machine is a high-end desktop system. If I wait for about 15 minutes nothing happens, just it crashes.... If I turn off the logging, oh wait! then it runs! I'd turned on it after the installation :) I think there is a problem with the full debugging option. It is not the load on the machine. This seems to be a bug. But now I have a running pgAdmin. Thanks for your help. Cagil Seker > -----Original Message----- > From: Dave Page [mailto:dpage@vale-housing.co.uk] > Sent: 25 Kasim 2002 Pazartesi 13:11 > To: Çaðýl Þeker > Cc: PGAdmin-Support-List (E-mail) > Subject: Re: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > As far as I can see there is nothing wrong here either. Bear > in mind that with full Debug turned on, things will be > *significantly* slower because not only is pgAdmin producing > a full log, psqlodbc is logging things flat out as well. 1 > minute is not an unreasonable time to view aggregates (which > also loads all functions) in this mode. > > What bandwidth to the server do you have? What spec are the > client and server machines, and how loaded are they? > > How long does it take with logging turned off if you just let > it finish? > > Regards, Dave. > > > -----Original Message----- > > From: Çagil Seker [mailto:cagils@biznet.com.tr] > > Sent: 25 November 2002 10:49 > > To: Dave Page > > Cc: PGAdmin-Support-List (E-mail) > > Subject: RE: [pgadmin-support] Connection & Crash Problem > > From Domain Users > > > > > > I opened the pgAdmin2. Change the log file to > > ...CRASH...something. Then connected to postmaster. > > Double-clicked the EDYS db. dc'ed the schema. dc'ed the > > public object. And it stopped responding. Waited a minute. > > Then closed it by CTRL-ALT-DEL. I don't know if this log file > > is any different form the prev. one. Here it is.. > > > > Çagil SEKER > > ----------------- > > > -----Original Message----- > > > From: Çaðýl Þeker > > > Sent: 23 Kasim 2002 Cumartesi 13:12 > > > To: 'Dave Page' > > > Cc: PGAdmin-Support-List (E-mail) > > > Subject: RE: [pgadmin-support] Connection & Crash Problem > > > From Domain Users > > > > > > > > > > -----Original Message----- > > > > From: Dave Page [mailto:dpage@vale-housing.co.uk] > > > > Sent: 21 Kasim 2002 Persembe 22:57 > > > > To: Çaðýl Þeker; PGAdmin-Support-List (E-mail) > > > > Subject: RE: [pgadmin-support] Connection & Crash Problem > > > > From Domain Users > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Çagil Seker [mailto:cagils@biznet.com.tr] > > > > > Sent: 21 November 2002 17:27 > > > > > To: PGAdmin-Support-List (E-mail) > > > > > Subject: [pgadmin-support] Connection & Crash Problem From > > > > > Domain Users > > > > > > > > > > > > > > > Ok. now I have a new problem! > > > > > I can use pgadmin without any problem under the local W2K > > > > > accounts POSTGRES and TESTUSER. But if I run pgadmin under > > > > > the domain W2K account MYDOMAIN/CAGILS it connects (and is > > > > > very slowly) and then when I try to reach the public database > > > > > object which is created default, it crashes (stops > > > > > responding, the log runs in a loop like crazy). I can reach > > > > > to postmaster using psql under MYDOMAIN/CAGILS > > > > > > > > Hmm, interesting. It's certainly not directly related to the > > > > fact it's a domain uid - it was 100% developed using one! Can > > > > you produce a full debug log (under Tools->Options) from > > > > connect to crash for me please? > > > > > > > > Also, what caused the change in UID 2/3 of the way through > > > > your original email? Initially you were postgres, then > > > > administrator - did you change login, or is there something > > > > going cuckoo with your Cygwin environment? > > > > > > > > Regards, Dave. > > > > > > > > > > I am sending the full debug log of a session. From connection > > > setup to the crash when I click to the public object. The log > > > is within the attachment. > > > > > > I log on to cygwin with Administrator. Then I "ssh > > > postgres@localhost". The first part was with ssh. The second > > > Admin. part is after I typed an "exit". Sorry, I'd snip it. > > > > > > And thanks for your help. > > > > > > Çagil SEKER > > > ----------------- > > > "Yes, I am a criminal. My crime is that of outsmarting you. > > > Something that you'll never forgive me for!" - The Mentor'86 > > > (Hacker's Manifesto) > > > ----------------- > > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
> -----Original Message----- > From: Çagil Seker [mailto:cagils@biznet.com.tr] > Sent: 25 November 2002 12:28 > To: Dave Page > Cc: PGAdmin-Support-List (E-mail) > Subject: RE: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > the server is on the 'localhost' :) > The machine is a high-end desktop system. > If I wait for about 15 minutes nothing happens, just it > crashes.... If I turn off the logging, oh wait! then it runs! > I'd turned on it after the installation :) I think there is a > problem with the full debugging option. It is not the load on > the machine. This seems to be a bug. But now I have a running pgAdmin. Good, glad it's working. Regards, Dave.