Feedback-ID: i76984098:Fastmail
Message-ID: <4790e521-02ee-4d77-bbd3-85a852b280a9@aklaver.com>
Date: Wed, 26 Feb 2025 08:07:05 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Corruption of few tables
To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>,
 Greg Sabino Mullane <htamfids@gmail.com>
Cc: Pgsql-general <pgsql-general@postgresql.org>
References: <611536258.144285.1740484963829.ref@mail.yahoo.com>
 <611536258.144285.1740484963829@mail.yahoo.com>
 <CAKAnmmK84G08eah=U9cjWsDzv8efh=hhpd3zA4rM2J-+tiiUNQ@mail.gmail.com>
 <321523931.3980391.1740551587184@mail.yahoo.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <321523931.3980391.1740551587184@mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/4790e521-02ee-4d77-bbd3-85a852b280a9%40aklaver.com>
Precedence: bulk

On 2/25/25 22:33, sivapostgres@yahoo.com wrote:
> Thanks
> 
> // Following is the PB code to retrieve data
> 
> ls_pack_version = fn_get_product_version()
> ls_pack_build   = fn_get_product_build()
> 
> Select releasenumber, buildnumber
> Into   :ls_db_version, :ls_db_build
> From   public.co_version
> Where  modulename = 'ALL';
> If SQLCA.sqlcode <> 0 Then
>      ls_db_version = ''
>      ls_db_build   = 'base'
> End If
> 
> If ls_pack_version <> ls_db_version Then
>     as_msg   = 'Version do not match.~r~nDB Ver : ' + ls_db_version
>     as_msg += '      Build : ' + ls_db_build
>     as_msg += '~r~nPack.Ver : ' + ls_pack_version
>     as_msg += '      Build : ' + ls_pack_build
>     as_msg += '~r~nPlease upgrade Program or Database'
>     Messagebox('Error' as_msg)
>     Return False
> End If
> 
> We get the above message [ Version do not match .... ], as SQLCA.Sqlcode 
> returned is not ZERO.  [ Successful read will return ZERO ]

Not sure how the two are connected.

The message is generated if:

ls_pack_version <> ls_db_version.

 From what I can see that depends on the results of:

ls_pack_version = fn_get_product_version()

and

Select releasenumber ...

as well as

If SQLCA.sqlcode <> 0

How do you what is actually leading to?:

ls_pack_version <> ls_db_version.


> 
> We tried selecting tables from PGAdmin also, where we got Disconnected 
> from the Server...  error message.
> 
> On Tuesday 25 February, 2025 at 07:02:40 pm IST, Greg Sabino Mullane 
> <htamfids@gmail.com> wrote:
> 
> 
> On Tue, Feb 25, 2025 at 7:03 AM sivapostgres@yahoo.com 
> <mailto:sivapostgres@yahoo.com> <sivapostgres@yahoo.com 
> <mailto:sivapostgres@yahoo.com>> wrote:
> 
>     1.  Why is corruption happening?  How to find out the reason?
> 
> 
> It sounds more like user error than actual corruption, but without more 
> data we cannot determine. Show us the exact commands you ran, along with 
> the results you expected to see, and the results you got. Provide as 
> much detail as possible. A reproducible test case would be ideal.
> 
>     Happiness Always
> 
> 
> That is an excellent valediction, thanks for that.
> 
> Cheers,
> Greg
> 
> --
> Crunchy Data - https://www.crunchydata.com <https://www.crunchydata.com>
> Enterprise Postgres Software Products & Tech Support
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com