Thread

Bug #698: Error haciendo Backup con pg_dump!!

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2002-06-25T18:42:01Z

Christian Gonzalez (christiangda@cantv.net) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Error haciendo Backup con pg_dump!!

Long Description
[avl@bdserver avl]$  nohup pg_dump -R -O leemail2 | gzip -c > /tmp/resp.leemail2_25_6_2002_1_00_pm.sql.gz &
[avl@bdserver avl]$ jobs
[1]+  Running                 nohup pg_dump -R -O leemail2 | gzip -c >/tmp/resp.leemail2_25_6_2002_1_00_pm.sql.gz &
[avl@bdserver avl]$ ERROR:  MemoryContextAlloc: invalid request size 4294967293
PQendcopy: resetting connection
SQL query to dump the contents of Table 'datamailentrada_historico' did not execute correctly.  After we read all the table contents from the backend, PQendcopy() failed.  Explanation from backend: ''.
The query was: 'COPY "datamailentrada_historico" TO stdout;
'.

[1]+  Done                    nohup pg_dump -R -O leemail2 | gzip -c >/tmp/resp.leemail2_25_6_2002_1_00_pm.sql.gz
[avl@bdserver avl]$ 



Sample Code


No file was uploaded with this report

Re: Bug #698: Error haciendo Backup con pg_dump!!

Tom Lane <tgl@sss.pgh.pa.us> — 2002-06-25T22:28:46Z

pgsql-bugs@postgresql.org writes:
> [avl@bdserver avl]$  nohup pg_dump -R -O leemail2 | gzip -c > /tmp/resp.leemail2_25_6_2002_1_00_pm.sql.gz &
> [avl@bdserver avl]$ jobs
> [1]+  Running                 nohup pg_dump -R -O leemail2 | gzip -c >/tmp/resp.leemail2_25_6_2002_1_00_pm.sql.gz &
> [avl@bdserver avl]$ ERROR:  MemoryContextAlloc: invalid request size 4294967293
> PQendcopy: resetting connection
> SQL query to dump the contents of Table 'datamailentrada_historico' did not execute correctly.  After we read all the table contents from the backend, PQendcopy() failed.  Explanation from backend: ''.
> The query was: 'COPY "datamailentrada_historico" TO stdout;

This looks like you have some corrupted data in
datamailentrada_historico :-(.

There is not much you can do about this except try to identify and
remove the damaged row(s).  You can look in the mailing list archives
for previous discussions about systematic ways to identify the location
of the damage, but basically you want to home in on which row(s) can't
be selected without provoking the error.

Once you've removed the damaged rows, you may be fortunate enough to be
able to restore them from a recent backup.  Good luck!

			regards, tom lane

"Field is too small"

Webb Sprague <wsprague100@yahoo.com> — 2002-06-25T23:50:38Z

I am getting a "field is too small" error in an Access
DB running over ODBC.  The field in question is
varchar(32).  

Here is the weird thing:  I am inserting into a table
with a rule that sends the result to a different
table.  However, when I insert into the table without
a rule, it works fine.  It also works fine both ways
from psql and isql at the command line (why oh why am
I messing around with stupid Microsoft products?!)

This is also NOT a problem with booleans--neither of
the fields are boolean.

Let me know how I might be able to help.  I have logs
from my local machine and I could get logs from the
server.  

Should I just use Triggers...

Thanks

W

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Re: "Field is too small"

Neil Conway <nconway@klamath.dyndns.org> — 2002-06-26T01:52:38Z

On Tue, 25 Jun 2002 16:50:38 -0700 (PDT)
"Webb Sprague" <wsprague100@yahoo.com> wrote:
> I am getting a "field is too small" error in an Access
> DB running over ODBC.  The field in question is
> varchar(32).
> 
> Here is the weird thing:  I am inserting into a table
> with a rule that sends the result to a different
> table.  However, when I insert into the table without
> a rule, it works fine.

Can you give us a reproducible example, preferrably one that
does not involve Access?

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

Re: "Field is too small"

Webb Sprague <wsprague100@yahoo.com> — 2002-06-26T17:38:32Z

> "Webb Sprague" <wsprague100@yahoo.com> wrote:
> > I am getting a "field is too small" error in an
> Access
> > DB running over ODBC.  The field in question is
> > varchar(32).
> > 
> > Here is the weird thing:  I am inserting into a
> table
> > with a rule that sends the result to a different
> > table.  However, when I insert into the table
> without
> > a rule, it works fine.
> 
> Can you give us a reproducible example, preferrably
> one that
> does not involve Access?

I also sent this to the ODBC list, as it *only* breaks
in Access.  Should I have not bothered BUGS with it?  

Thanks
W

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Re: [ODBC] "Field is too small"

Hiroshi Inoue <inoue@tpf.co.jp> — 2002-06-28T05:40:12Z

Webb Sprague wrote:
> 
> I am getting a "field is too small" error in an Access
> DB running over ODBC.  The field in question is
> varchar(32).
> 
> Here is the weird thing:  I am inserting into a table
> with a rule that sends the result to a different
> table. 

Are you using a DO INSTEAD rule ?
Could you send me the Mylog output ?

regards,
Hiroshi Inoue
	http://w2422.nsk.ne.jp/~inoue/

Pass through query help (please ...:)

Webb Sprague <wsprague100@yahoo.com> — 2002-06-28T21:38:51Z

Hi all,

I would like to do a pass through query in a form as
part of a button-click event.  I just want to fire off
a PL/PGSQL function on the Postgres server. 

Is this possible?  Is it easy?  I just want to insert
it below where the comment says:

Private Sub foobar_Click()
On Error GoTo Err_foobar_Click

    'FIRE OFF SERVER FUNCTION HERE
    'SELECT server_func()

    DoCmd.GoToRecord , , acNewRec

Exit_foobar_Click:
    Exit Sub

Err_foobar_Click:
    MsgBox Err.Description
    Resume Exit_foobar_Click
    
End Sub

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Re: Pass through query help (please ...:)

Cedar Cox <cedarc@visionforisrael.com> — 2002-06-29T11:19:03Z

Hi.  Yes, I do still lurk here.  Yes, it is possible to do what you
want.  Have a look in the list archives at some of my ODBC VB
function stuff.  It has to do with using passthrough queries for the
datasource of list and combo boxes (maybe you wanted this??).  
You'll see how I did it in there and it should help you out.  One
thin you'll want to change is a parameter that means "query does not
return a data set".  I won't tell you details here because I
probably don't remember them correctly.  If you want an answer 
right now then go search, or else maybe someone else will reply
too.  The 'Building Applications with MS Access' book is of 
value too.

-Cedar

On Fri, 28 Jun 2002, Webb Sprague wrote:

> Hi all,
> 
> I would like to do a pass through query in a form as
> part of a button-click event.  I just want to fire off
> a PL/PGSQL function on the Postgres server. 
> 
> Is this possible?  Is it easy?  I just want to insert
> it below where the comment says:
> 
> Private Sub foobar_Click()
> On Error GoTo Err_foobar_Click
> 
>     'FIRE OFF SERVER FUNCTION HERE
>     'SELECT server_func()
> 
>     DoCmd.GoToRecord , , acNewRec
> 
> Exit_foobar_Click:
>     Exit Sub
> 
> Err_foobar_Click:
>     MsgBox Err.Description
>     Resume Exit_foobar_Click
>     
> End Sub
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
> 
>

Re: Pass through query help (please ...:)

Webb Sprague <wsprague100@yahoo.com> — 2002-07-01T20:09:22Z

Hi Cedar,

I have searched google postgres.odbc for your name,
and I can't find anything that works (I just want to
cut and paste something in).  Can you or anyone else
point me to an example or a tutorial?

Thx
W
--- Cedar Cox <cedarc@visionforisrael.com> wrote:
> 
> Hi.  Yes, I do still lurk here.  Yes, it is possible
> to do what you
> want.  Have a look in the list archives at some of
> my ODBC VB
> function stuff.  It has to do with using passthrough
> queries for the
> datasource of list and combo boxes (maybe you wanted
> this??).  
> You'll see how I did it in there and it should help
> you out.  One
> thin you'll want to change is a parameter that means
> "query does not
> return a data set".  I won't tell you details here
> because I
> probably don't remember them correctly.  If you want
> an answer 
> right now then go search, or else maybe someone else
> will reply
> too.  The 'Building Applications with MS Access'
> book is of 
> value too.
> 
> -Cedar
> 
> On Fri, 28 Jun 2002, Webb Sprague wrote:
> 
> > Hi all,
> > 
> > I would like to do a pass through query in a form
> as
> > part of a button-click event.  I just want to fire
> off
> > a PL/PGSQL function on the Postgres server. 
> > 
> > Is this possible?  Is it easy?  I just want to
> insert
> > it below where the comment says:
> > 
> > Private Sub foobar_Click()
> > On Error GoTo Err_foobar_Click
> > 
> >     'FIRE OFF SERVER FUNCTION HERE
> >     'SELECT server_func()
> > 
> >     DoCmd.GoToRecord , , acNewRec
> > 
> > Exit_foobar_Click:
> >     Exit Sub
> > 
> > Err_foobar_Click:
> >     MsgBox Err.Description
> >     Resume Exit_foobar_Click
> >     
> > End Sub
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> > 
> > 
> > 
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> > 
> > http://archives.postgresql.org
> > 
> > 
> > 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com