"Nik" <XLPizza(at)gmail(dot)com> wrote
> I have an application that executes an INSERT statement every second or
> two. In my old design this data was inserted into one table. However, I
> changed the design to have one table with multiple partitions. Now when
> I run the application it runs for some random amount of time (random
> number of INSERTs) and then it gets stuck at the INSERT query and it
> never finishes (at least not in some reasonable time - aka few hours).
> If I restart the application it continues inserting the data normally
> for a while before getting stuck again.
>
Do you do INSERT concurrently? Can you post a self-contained example to
reproduce it?
Regards,
Qingqing