Обсуждение: pgadmin 1.8.4 freeze ?
Hi Dave,
I compiled 1.8.4 version on my ubuntu
and have the same issue with either freeze or very very slow startup.
here is the `strace` below.
Could it be caused by the fact that the registered servers are gone offline?
ODBC connection would be interesting since there is no considerable ODBC database admin console on Linux
(or at least GNU version) as far as I am concerned...
Lev
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\24\0\6\0\333\2\240\5l\1\0\0\6\0\0\0\0\0\0\0\377\377\377"..., 24}], 1) = 24
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1 _\10\1\0\0\0\6\0\0\0\0\0\0\0\1\0\0\0\233\4\25\10<c "..., 4096) = 36
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\24\0\6\0\333\2\240\5\"\1\0\0\4\0\0\0\0\0\0\0\377\377\377"..., 24}], 1) = 24
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1 `\10\3\0\0\0\4\0\0\0\0\0\0\0\3\0\0\0\233\4\25\10<c "..., 4096) = 44
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\24\0\6\0\333\2\240\5\"\1\0\0\4\0\0\0\0\0\0\0\377\377\377"..., 24}], 1) = 24
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1 a\10\3\0\0\0\4\0\0\0\0\0\0\0\3\0\0\0\233\4\25\10<c "..., 4096) = 44
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\21\0\2\0~\1\0\0", 8}], 1) = 8
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1sb\10\2\0\0\0\7\0\0\0X\216\251\277\233\4\25\10<c \010"..., 4096) = 40
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\21\0\2\0O\1\0\0", 8}], 1) = 8
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1sc\10\4\0\0\0\r\0\0\0X\216\251\277\233\4\25\10<c \010"..., 4096) = 48
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"5\30\4\0\345\2\240\5\333\2\240\5@\1|\0\233\4\5\0\346\2"..., 4096},
{"\233\4\6\0\353\2\240\5\345\2\240\0058\0\0\0\200\0\0\0\0"...,24}], 2) = 4120
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\233\5\4\0\353\2\240\5@\0\0\0\0\0\0\0005 \4\0\354\2\240"..., 1412}], 1) = 1412
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\2\7\4\0A\0\240\5\0@\0\0\34\0\240\5\2\7\4\0+\0\240\5\0"..., 32}], 1) = 32
read(7, 0x85d5cd4, 4096)
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\24\0\6\0\333\2\240\5l\1\0\0\6\0\0\0\0\0\0\0\377\377\377"..., 24}], 1) = 24
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1 _\10\1\0\0\0\6\0\0\0\0\0\0\0\1\0\0\0\233\4\25\10<c "..., 4096) = 36
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\24\0\6\0\333\2\240\5\"\1\0\0\4\0\0\0\0\0\0\0\377\377\377"..., 24}], 1) = 24
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1 `\10\3\0\0\0\4\0\0\0\0\0\0\0\3\0\0\0\233\4\25\10<c "..., 4096) = 44
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\24\0\6\0\333\2\240\5\"\1\0\0\4\0\0\0\0\0\0\0\377\377\377"..., 24}], 1) = 24
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1 a\10\3\0\0\0\4\0\0\0\0\0\0\0\3\0\0\0\233\4\25\10<c "..., 4096) = 44
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\21\0\2\0~\1\0\0", 8}], 1) = 8
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1sb\10\2\0\0\0\7\0\0\0X\216\251\277\233\4\25\10<c \010"..., 4096) = 40
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\21\0\2\0O\1\0\0", 8}], 1) = 8
select(8, [7], [], NULL, NULL) = 1 (in [7])
read(7, "\1sc\10\4\0\0\0\r\0\0\0X\216\251\277\233\4\25\10<c \010"..., 4096) = 48
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"5\30\4\0\345\2\240\5\333\2\240\5@\1|\0\233\4\5\0\346\2"..., 4096},
{"\233\4\6\0\353\2\240\5\345\2\240\0058\0\0\0\200\0\0\0\0"...,24}], 2) = 4120
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\233\5\4\0\353\2\240\5@\0\0\0\0\0\0\0005 \4\0\354\2\240"..., 1412}], 1) = 1412
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
read(7, 0x85d5cd4, 4096) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=5, events=POLLIN}, {fd=7, events=POLLIN}], 2, 0) = 0
select(8, [7], [7], NULL, NULL) = 1 (out [7])
writev(7, [{"\2\7\4\0A\0\240\5\0@\0\0\34\0\240\5\2\7\4\0+\0\240\5\0"..., 32}], 1) = 32
read(7, 0x85d5cd4, 4096)
--
Blogger of http://fapuma.blogspot.com
Pictures of my life at http://picasaweb.google.com/TorokLev
In addition: http://www.youtube.com/watch?v=0CUDg3NPEXY&fmt=16
On Wed, Mar 11, 2009 at 12:02 PM, Levente Torok <toroklev@gmail.com> wrote: > Hi Dave, > > I compiled 1.8.4 version on my ubuntu > and have the same issue with either freeze or very very slow startup. > here is the `strace` below. > Could it be caused by the fact that the registered servers are gone offline? It can - basically pgAdmin is waiting until the connection attempt times out (the length of which is not controlled by pgAdmin). I just tested on CentOS here, and it took 4 minutes to timeout. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Thu, Mar 12, 2009 at 1:40 PM, Levente Torok <toroklev@gmail.com> wrote: > On Wednesday 11 March 2009, you wrote: > >> It can - basically pgAdmin is waiting until the connection attempt >> times out (the length of which is not controlled by pgAdmin). I just >> tested on CentOS here, and it took 4 minutes to timeout. > > Well, I don't think there could be any any reason for holding splashsceen on for > more than 5 seconds... Or? > :) Splash screen? You suggested it was when connecting to servers - that doesn'r happen until you double click on one. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Wednesday 11 March 2009, you wrote: > It can - basically pgAdmin is waiting until the connection attempt > times out (the length of which is not controlled by pgAdmin). I just > tested on CentOS here, and it took 4 minutes to timeout. Well, I don't think there could be any any reason for holding splashsceen on for more than 5 seconds... Or? :) May I suggest to parallelize the connection testing (one thread for each connection), reduce the timeout for establishing the connection and/or start splashscreen with timeout? Lev -- Blogger of http://fapuma.blogspot.com
On Thu, Mar 12, 2009 at 3:12 PM, Levente Torok <toroklev@gmail.com> wrote: > I was just assuming that pgmin is checking if servers are alive at the startup > but since it didn't start up in reasonable time I haven't use it forawhile so I forget > that it is not likely doing anything since additional click is needed. > > So. yess the splashscreen is on forever. How should I debug the case? Couple of things to try: - Add something like the following to the top of ~/.pgadmin3 (or edit the existing values) LogFile=/home/levente/pgadmin.log LogLevel=4 Then try to start pgAdmin. See if there are any clues in the logfile. - Start a debug build of pgAdmin in your debugger, and break it when it hangs. Get a backtrace that we can then examine. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Thursday 12 March 2009, you wrote: > On Thu, Mar 12, 2009 at 1:40 PM, Levente Torok <toroklev@gmail.com> wrote: > > On Wednesday 11 March 2009, you wrote: > > > >> It can - basically pgAdmin is waiting until the connection attempt > >> times out (the length of which is not controlled by pgAdmin). I just > >> tested on CentOS here, and it took 4 minutes to timeout. > > > > Well, I don't think there could be any any reason for holding splashsceen on for > > more than 5 seconds... Or? > > :) > > Splash screen? You suggested it was when connecting to servers - that > doesn'r happen until you double click on one. I was just assuming that pgmin is checking if servers are alive at the startup but since it didn't start up in reasonable time I haven't use it forawhile so I forget that it is not likely doing anything since additional click is needed. So. yess the splashscreen is on forever. How should I debug the case? -- Blogger of http://fapuma.blogspot.com
On Thu, Mar 12, 2009 at 3:24 PM, Levente Torok <toroklev@gmail.com> wrote: > Hi Dave, > > This is the first step you suggested: > LogLevel=4 helped: > > EDB pg_restore: > 2009-03-12 16:19:56 INFO : Using embedded XRC data. > 2009-03-12 16:19:58 ERROR : can't open file '/home/lev/.local/share/applications/Scilab 5.0.desktop' (error 13: Permissiondenied) > > > -rw------- 1 root root 293 2008-09-30 16:05 Scilab 5.0.desktop > > But is it reasonable that is wanted to open it? > (I changed the owner and solved the problem) > It was just a misconfigured another application installation. > In general I woudl expect pgadmin not depend on it... pgAdmin doesn't try to open .desktop files itself (though it's possible wxWidgets is for some reason I can't even begin to fathom). After it checks the XRC data, it checks the helpfiles. What do you have those set to in .pgadmin3 ? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Hi Dave, This is the first step you suggested: LogLevel=4 helped: EDB pg_restore: 2009-03-12 16:19:56 INFO : Using embedded XRC data. 2009-03-12 16:19:58 ERROR : can't open file '/home/lev/.local/share/applications/Scilab 5.0.desktop' (error 13: Permissiondenied) -rw------- 1 root root 293 2008-09-30 16:05 Scilab 5.0.desktop But is it reasonable that is wanted to open it? (I changed the owner and solved the problem) It was just a misconfigured another application installation. In general I woudl expect pgadmin not depend on it... L > On Thu, Mar 12, 2009 at 3:12 PM, Levente Torok <toroklev@gmail.com> wrote: > > > I was just assuming that pgmin is checking if servers are alive at the startup > > but since it didn't start up in reasonable time I haven't use it forawhile so I forget > > that it is not likely doing anything since additional click is needed. > > > > So. yess the splashscreen is on forever. How should I debug the case? > > Couple of things to try: > > - Add something like the following to the top of ~/.pgadmin3 (or edit > the existing values) > > LogFile=/home/levente/pgadmin.log > LogLevel=4 > > Then try to start pgAdmin. See if there are any clues in the logfile. > > - Start a debug build of pgAdmin in your debugger, and break it when > it hangs. Get a backtrace that we can then examine. > -- Blogger of http://fapuma.blogspot.com