You know that moment when you didn't have to touch the DB structure for
months and you need to return to it to add one field to one table?

Don't you just hate it when your entire programming flow is disrupted
by this dreaded Error #300 cannot lock table blabla?

The table isn't open anywhere. I'm just executing this one friggin'
SQL, or trying to do it via the "Alter table" option in the EDB
Manager. No go.

Just hate it when a simple like that is fighting me.

Not found the solution yet, but had to vent.

Dominique Willems,

You can try:

select * from configuration.serversessionlocks;

to see who has the table open. If you are using EDBMgr, make sure you have either Closed or Unprepared SQL windows that are referencing that table.

Barry

Thanks, Barry. It magically worked after clicking about in the view
tree. No idea what triggered it. I'm sure in five months I'll go
through the same confusing routine.

Dominique,

That happened to me last year when I had a single EDBMgr with 2 or more sessions open. I had to disconnect the 2nd session in order to eliminate the lock error on the other session. I don't know why it happened, but the problem has gone away if I have only one session open.

Barry

If all else fails, reboot.
If that fails to solve the problem, grab a two-by-four!

Dom,

<< Don't you just hate it when your entire programming flow is disrupted by
this dreaded Error #300 cannot lock table blabla?

The table isn't open anywhere. >>

I beg to differ - the table is indeed open somewhere, otherwise you wouldn't
be seeing the lock error.  EDB doesn't just lock tables at random.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> I beg to differ - the table is indeed open somewhere, otherwise you
> wouldn't be seeing the lock error.  EDB doesn't just lock tables at
> random.

Hmpfh! GTYR!

Dom,

<< Hmpfh! GTYR! >>

 Had to look that one up.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> << Hmpfh! GTYR! >>
>
>  Had to look that one up.

It's documented somewhere?! I have the copyright since 1972!