Re: Related To Hash Partition

Hi Jeff,

Today when i am running the updates on a sharding table i.e updating the
sharding column with other values.

Data has been unsync i.e data should be in the fourth partition according
to the explain method but the data is in the first partition.

How can I overcome this problem?

plz help me with this issue as this is a production issue.

Regards
Rohit Sachdeva

On Fri, Apr 28, 2023 at 9:52 PM ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
wrote:

> Hi Jeff,
>
> Thanks for the reply.
>
> Below are the replies to your queries regarding my issue.
>
> Are you using a custom hashing function or a built-in one?
> Answer: I am not using a custom hash function
> What is the datatype of the partition key?
> Answer: The datatype is bigint.
> Has this system been through any pg_upgrade cycles?
> Answer: No
> Have you tried to reproduce it on your own system?
> Answer: Yes, in the system, and all things are fine.
> What is your version, hardware, and OS?
> Answer: It's the 14 version, and it's an RDS service of AWS, which has a
> configuration of db.r6g.16xlarge.
> Do you have error correcting code RAM?
> Answer: It is hosted on the AWS cloud.
>
> Just add up the indexing.
> Answer : I was meant to say that the only change i did in table strutute
> was creation of index.
>
> On Fri, Apr 28, 2023 at 4:26 AM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
>> On Sun, Apr 23, 2023 at 3:04 AM ROHIT SACHDEVA <
>> sachdeva(dot)rohit648(at)gmail(dot)com> wrote:
>>
>>> Hi Team,
>>>
>>> While using hash partition i am facing the problem that the data is not
>>> going into the proper partition table .
>>> Due to this, records are not visible in the main table when I am
>>> searching for a particular record, as it searches only that partition.
>>> Any suggestions on how to overcome this problem and why this happened.
>>>
>> This seems like a bug, or some kind of corruption. But there isn't
>> enough info here to identify what the bug might be. Are you using a custom
>> hashing function, or a built-in one? What is the datatype of the
>> partition key? Has this system been through any pg_upgrade cycles? Have
>> you tried to reproduce it on your own system? What is your version and
>> hardware and OS? Do you have error correcting code RAM?
>>
>>> And in the future, if i truncate the records from the main table and
>>> insert them back again, will the shuffling of records happen or not.
>>> Any ideas regarding why this happened?
>>>
>> I don't think there is a way to answer that without first identifying
>> what went wrong in the first place.
>>
>>
>>> Just add up the indexing.
>>>
>>
>> I don't know what that means.
>>
>> Cheers,
>>
>> Jeff
>>
>>>
>
> --
> Have a Good day !!!
>
> Regards
> Rohit Sachdeva
>

--
Have a Good day !!!

Regards
Rohit Sachdeva