Aloha!
I encountered a serious problem involving pgAdmin3 1.10.3 today. But I
am not entirely sure, what is to blame. Maybe one of you can make
anything of it?
I gave a application-developer access to one of our databases (postgres
8.4.3 on Debian Lenny) so we could discuss the design of a new
application in light of the existing data. Naturally I suggested pgAdmin
1.10.3 for viewing data and structure.
He downloaded and installed the Mac edition (German version) and
connected via TCP/IP to standard port 5432, with "SSL require". He tried
a couple of things, the last thing he did was to experiment with the
"Graphical Query Builder". He mentioned that he stopped a few queries
that took too long. I saw fitting error messages in the log. But nothing
unusual. Then he carelessly left his notebook running over night,
leaving pgAdmin open, or at least, that's what he swears is all he did.
It appears, that by a glitch in the SSL-handshake a loop was triggered
that led to millions of error messages in the database log. The day
after I had to deal with 60 GB (!) of log. I am not sure about the role
of pgAdmin, the GQB or the SSL protocol (including possible quirks of
the server?) Fact is, it almost stalled our productive database server
by eating up all available disk space. This is the most serious incident
involving pgAdmin I have ever experienced, yet. (Yeah, I need a strategy
to prevent that from happening in general, I have learned that lesson.)
I attached a snippet of the log. Maybe it tells one of you guys anything?
Locale is German, I added some English translations.
Regards
Erwin
2010-05-18 19:33:20 CEST iphone LOG: konnte Daten vom Client nicht empfangen:
Die Wartezeit für die Verbindung ist abgelaufen
-- translation: could not receive data from client: connection timed out
2010-05-18 19:33:20 CEST iphone LOG: unerwartetes EOF auf Client-Verbindung
-- translation: unexpected EOF of client-connection
(...)
2010-05-18 20:36:13 CEST iphone LOG: Fehler bei SSL-Neuverhandlung
-- translation: Error
2010-05-18 20:36:13 CEST iphone ANWEISUNG: SELECT
kat.kat_id,
kat.kat,
kat.kat_e,
kat.ktyp_id,
kat.autoatt_id,
kat.log_up
FROM
ef.adratt,
ef.adr,
ef.adrkat,
ef.att,
ef.firma,
ef.karte,
ef.kat,
ef.kontakt;
2010-05-18 20:36:13 CEST iphone LOG: SSL-Fehler: ssl handshake failure
-- note how this message is half English (?)
2010-05-18 20:36:13 CEST iphone ANWEISUNG: SELECT
kat.kat_id,
kat.kat,
kat.kat_e,
kat.ktyp_id,
kat.autoatt_id,
kat.log_up
FROM
ef.adratt,
ef.adr,
ef.adrkat,
ef.att,
ef.firma,
ef.karte,
ef.kat,
ef.kontakt;
2010-05-18 20:36:13 CEST iphone LOG: konnte Daten nicht an den Client senden:
Die Verbindung wurde vom Kommunikationspartner zurückgesetzt
-- translation: could not send data to client: connection reset by peer
2010-05-18 20:36:13 CEST iphone ANWEISUNG: SELECT
kat.kat_id,
kat.kat,
kat.kat_e,
kat.ktyp_id,
kat.autoatt_id,
kat.log_up
FROM
ef.adratt,
ef.adr,
ef.adrkat,
ef.att,
ef.firma,
ef.karte,
ef.kat,
ef.kontakt;
2010-05-18 20:36:13 CEST iphone LOG: SSL-Fehler: ssl handshake failure
-- translation: SSL-Error: ssl handshake failure
2010-05-18 20:36:13 CEST iphone ANWEISUNG: SELECT
kat.kat_id,
kat.kat,
kat.kat_e,
kat.ktyp_id,
kat.autoatt_id,
kat.log_up
FROM
ef.adratt,
ef.adr,
ef.adrkat,
ef.att,
ef.firma,
ef.karte,
ef.kat,
ef.kontakt;
2010-05-18 20:36:13 CEST iphone LOG: SSL-Fehler: ssl handshake failure
2010-05-18 20:36:13 CEST iphone ANWEISUNG: SELECT
kat.kat_id,
kat.kat,
kat.kat_e,
kat.ktyp_id,
kat.autoatt_id,
kat.log_up
FROM
ef.adratt,
ef.adr,
ef.adrkat,
ef.att,
ef.firma,
ef.karte,
ef.kat,
ef.kontakt;
... millions more of the same ...
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
