Re: Insert query hangs

On 07/09/2014 03:34 AM, M Tarkeshwar Rao wrote:

Please do not top post.

>
> Actually problem is in customer site in their production environment.
> They have their database MDB. In that db they have insert issue with one table.
>
> They shared the data folder with us.

So you are just copying a directory from one machine to another?

Was the production machine running while they copied the directory?

>
> We past the same data folder in our local DB which has the same name MDB and reproduced the issue.

So you then put the copied folder into an existing data directory on
your machine?

Are the production machine and your machine the same OS and
architecture(32/64 bit)?

Are the Postgres versions the same?

>
> After reproducing the issue we run pg_dump(with data) on corrupted table and restore it on another local db.
> After restoring in another db we tested the insert operation and found it is working fine.

So what happens if you do a pg_dump directly from the production machine
or is that what you are talking about above?

>
> We analysed one more thing when we removed the unique index from the table it is working fine.
> Is there any issue in indexing?
>
> Is there any option to repair the table or its indexing?
>
> Regards
> Tarkeshwar
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of M Tarkeshwar Rao
> Sent: 09 July 2014 14:49
> To: pgsql-hackers-owner(at)postgresql(dot)org; pgsql-hackers(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Insert query hangs
>
> Hi all,
>
> We have a table in a database DB1 with name Test. We imported this database from another machine.
> When I fire insert statement it is going in the hang state.
>
> Then I created another table with same structure and with same data within it as in table Test.
> Then I fired the insert statement. It is working fine.
>
> I am not able find the reason for this. Can you please help me out on this. This scenario easily reproducible.
>
> I have a standalone system and postgresql 9.1 installed on it.
>
> Regards
> Tarkeshwar
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com