Re: BUG #12812: invalid attribute number <number> for <table_name>

Hi Michal,

It is record tables. Thousands of record inserted in that tables per day.
Till yesterday noon there is no problem. When I take a backup at yesterday
night the I found 0 kb dump file. Then I taken backup all three schema
separately.
Problem found in "AD" schema.

Then I try to select that particular table, I got following error.
(Screenshot attached). Re indexing for that table also failed due to that
error.

ERROR: invalid attribute number 24932 for transaction_set
LINE 1: SELECT * FROM AD_GSS_DMS_P.TRANSACTION_SET
^
********** Error **********

ERROR: invalid attribute number 24932 for transaction_set
SQL state: XX000
Character: 15

[image: Inline images 2]

*​--*
*​**Regards,*
*Iyappan,*
*Global Software Solutions (TVL) Pvt. Ltd.,*
*+91 97152 30226*

On 28 February 2015 at 12:33, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:

> On Sat, Feb 28, 2015 at 3:29 PM, <ipnb87(at)gmail(dot)com> wrote:
> > When selecting particular table or schema , views having that table shows
> > this error.
> > I also can't take backup this database or schema.
>
> Could you send a test case that helps to reproduce the problem you are
> seeing and the error message you are seeing? I am afraid that with so
> little information there is not much we can do..
> --
> Michael
>