Table locked??

[aas1611]

I tried to UPDATE and INSERT into a table, but it seems like the table is locked or something. When I execute this two commands, it just hang. But it'doing fine on SELECT.

Any idea why does it happen and how to solve this?

 

[nego78]

1. Do you have privileges to write to a table?
2. How big are your indexes? If you have very big index than it take some time to insert or update whole table.
3. Does it happen at single statement or at multiple insert or updates?

Via-Net - web directory

 

[aas1611]

It turns out to be a cumulative of INSERT and/or UPDATES commands that got locked, for some reason. I ended these commands mannually, and now it runs again.

I should work on my script now, that causes the locking (jammed).

Thanks anyway!