Skip site navigation (1) Skip section navigation (2)

Trouble using debugger and profiler

From: Bob <luckyratfoot(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Trouble using debugger and profiler
Date: 2007-11-01 19:23:01
Message-ID: 762e5c0711011223m23c880fdr1bac5d2b6f188400@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hello,

I'm having some issues using the debugger and the profiler.

My setup is as follows.

DB Server setup:
DB server running FreeBSD 6.2 database 8.3 Beta2

Client setup:
Windows Vista
pgAdmin III v1.8.0


Problem #1:
When I have both the debugger and profiler modules setup to load in my
postgresql.conf file I can't get the debugger to work. If I right click on a
function and click debug a parameter window
pops up that allows me to click on it and nothing happens, so I'm not able
to debug and functions. If I remove the profiler module from loading and
restart postgresql the debugger works fine. When I do have both loading the
log message
shows they load fine so it doesn't appear to be a issue with getting them
both to load.

Problem #2:
I can't get the profiler to give me IO stats. It gives me the basic stats as
described in the readme(README.plprofiler) . It says to apply a patch to get
the
IO stats. So I tried this and the profiler works but I get no IO stats. Here
is the output from my patch attempt. As you can see not everything seemed to
patch correctly
which probably is why the IO stats is not working. So my question should
probably be why doesn't the patch work. I downloaded it from
http://pgfoundry.org/projects/edb-debugger .
----START PATCH OUTPUT----
[xyz(at)greatwhite ~/postgresql-8.3beta2]$ patch < profilerPatch83.diff
Hmm...  Looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|Index: src/include/pgstat.h
|===================================================================
|RCS file: /projects/cvsroot/pgsql/src/include/pgstat.h,v
|retrieving revision 1.64
|diff -c -r1.64 pgstat.h
|*** src/include/pgstat.h       8 Jul 2007 22:23:16 -0000       1.64
|--- src/include/pgstat.h       9 Aug 2007 14:33:09 -0000
--------------------------
Patching file src/include/pgstat.h using Plan A...
Hunk #1 failed at 506.
1 out of 1 hunks failed--saving rejects to src/include/pgstat.h.rej
Hmm...  The next patch looks like a new-style context diff to me...
The text leading up to this was:
--------------------------
|Index: src/backend/postmaster/pgstat.c
|===================================================================
|RCS file: /projects/cvsroot/pgsql/src/backend/postmaster/pgstat.c,v
|retrieving revision 1.162
|diff -c -r1.162 pgstat.c
|*** src/backend/postmaster/pgstat.c    2 Aug 2007 23:39:44 -0000
1.162
|--- src/backend/postmaster/pgstat.c    9 Aug 2007 14:33:10 -0000
--------------------------
Patching file src/backend/postmaster/pgstat.c using Plan A...
Hunk #1 succeeded at 157 (offset -2 lines).
Hunk #2 succeeded at 1242 (offset -40 lines).
Hunk #3 failed at 1267.
Hunk #4 succeeded at 1335 (offset 1 line).
1 out of 4 hunks failed--saving rejects to
src/backend/postmaster/pgstat.c.rej
done
---END PATCH OUTPUT---

Here is the contents of pgstat.c.rej if that helps. I'm not a c programmer
so I pretty much just follow the directions for this type of thing
and hope for it to just work.

---START pgstat.c.rej---
***************
*** 1264,1269 ****

                /* t_tuples_updated is nontransactional, so just advance it
*/
                pgstat_info->t_counts.t_tuples_updated++;

                /* We have to log the transactional effect at the proper
level */
                if (pgstat_info->trans == NULL ||
--- 1267,1273 ----

                /* t_tuples_updated is nontransactional, so just advance it
*/
                pgstat_info->t_counts.t_tuples_updated++;
+               pgStatGlobals.t_tuples_updated++;

                /* We have to log the transactional effect at the proper
level */
                if (pgstat_info->trans == NULL ||

---END pgstat.c.rej---
Any ideas of what might be wrong or if I'm doing something wrong?  I
appreciate any help on this.

Thanks,
Bob

pgadmin-support by date

Next:From: Raphaël EnriciDate: 2007-11-02 10:00:44
Subject: Re: Where can I get your public key?
Previous:From: Raphaël EnriciDate: 2007-11-01 18:31:19
Subject: Re: [pgadmin-support] pgAdmin III 1.8.0 for debian etch uploaded.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group