Thread: Problem while debugging using PgAdmin

Problem while debugging using PgAdmin

From

"Shanker N Srivastava"

Date:

26 October 2007, 11:43:41

<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy">Hello,</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">I am using PsotgreSQL version 8.2.5, and using pl/pgsql Debugger for debugging my pl/pgsql
functions.My pgAdmin version is also pgAdmin III v1.8.0,  while debugging I am getting below error</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;

font-family:Arial">==========================================================================================================================</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">An error has occurred:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">ERROR:  could not load library "/usr/local/pgsql/lib/pldbgapi.so": /usr/local/pgsql/lib/pldbgapi.so:
undefinedsymbol: BreakpointInsert</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">My database server is on linux, and my pgAdmin is on win</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 

font-family:Arial">==========================================================================================================================</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I am just thinking, is it not working because, My database server is linux machine and pgAdmin is on
windowsXP machine, and are in different machine. </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Waiting for reply.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">Thanks and Regards </span></font><font size="2"><span style="font-size:10.0pt"></span></font><p
class="MsoBodyText"style="margin:0in;margin-bottom:.0001pt"><b><font color="#993300" face="Times New Roman"
size="1"><spanstyle="font-size:9.0pt;color:#993300; 
font-weight:bold">Shanker N Srivastava</span></font></b><font size="1"><span style="font-size:9.0pt">
</span></font><fontface="Arial" size="1"><span style="font-size:7.5pt;font-family:Arial"></span></font><p
class="MsoPlainText"><fontface="Courier New" size="2"><span style="font-size: 
10.0pt"> </span></font><font face="Arial" size="1"><span style="font-size:
7.5pt;font-family:Arial"></span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font></div>

Re: Problem while debugging using PgAdmin

From

Dave Page

Date:

26 October 2007, 12:26:09

Shanker N Srivastava wrote:
> Hello,
> 
> I am using PsotgreSQL version 8.2.5, and using pl/pgsql Debugger for
> debugging my pl/pgsql functions. My pgAdmin version is also pgAdmin III
> v1.8.0,  while debugging I am getting below error
>  
>
==========================================================================================================================
> An error has occurred:
>  
> ERROR:  could not load library "/usr/local/pgsql/lib/pldbgapi.so":
> /usr/local/pgsql/lib/pldbgapi.so: undefined symbol: BreakpointInsert
>
> My database server is on linux, and my pgAdmin is on win
>
==========================================================================================================================
>
> I am just thinking, is it not working because, My database server is
> linux machine and pgAdmin is on windows XP machine, and are in different
> machine.
> 

That should not matter - the client and the server need not be the same
machine, or even the same platform/architecture.

How did you install the debugger plugin - did you find a package from
somewhere or build it yourself from source? Do $PGLIB/pldbgapi.so and
$PGLIB/plugins/plugin_debugger.so both exist, and did you successfully
run the pldbgapi.sql script in your database?

Regards, Dave

Re: Problem while debugging using PgAdmin

From

"Shanker N Srivastava"

Date:

26 October 2007, 13:18:05

Hello Dave,

Thanks for your email. 

We downloaded from http://pgfoundry.org/projects/edb-debugger , and followed
the instructions given README file. Yes, both the files exist as you said.

I manually droped all the objects which was in the pldbgapi.sql, and
re-created them, now I am able to debug.

We will come back to you incase of other problems.

-Regards
Shanker
-----Original Message-----
From: Dave Page [mailto:dpage@postgresql.org] 
Sent: Friday, October 26, 2007 8:56 PM
To: Shanker N Srivastava
Cc: pgadmin-support@postgresql.org; korryd@enterprisedb.com
Subject: Re: [pgadmin-support] Problem while debugging using PgAdmin

Shanker N Srivastava wrote:
> Hello,
> 
> I am using PsotgreSQL version 8.2.5, and using pl/pgsql Debugger for
> debugging my pl/pgsql functions. My pgAdmin version is also pgAdmin III
> v1.8.0,  while debugging I am getting below error
>  
>
============================================================================
==============================================
> An error has occurred:
>  
> ERROR:  could not load library "/usr/local/pgsql/lib/pldbgapi.so":
> /usr/local/pgsql/lib/pldbgapi.so: undefined symbol: BreakpointInsert
>
> My database server is on linux, and my pgAdmin is on win
>
============================================================================
==============================================
>
> I am just thinking, is it not working because, My database server is
> linux machine and pgAdmin is on windows XP machine, and are in different
> machine.
> 

That should not matter - the client and the server need not be the same
machine, or even the same platform/architecture.

How did you install the debugger plugin - did you find a package from
somewhere or build it yourself from source? Do $PGLIB/pldbgapi.so and
$PGLIB/plugins/plugin_debugger.so both exist, and did you successfully
run the pldbgapi.sql script in your database?

Regards, Dave