Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

DBCC CHECKSTORAGE

74 views

Skip to first unread message

Jaideep Chatterjee

unread,

Mar 11, 2003, 5:03:45 PM3/11/03

Hi,
Wile running dbcc checkstorage on linux 7.3 sybase 11.9.2 i got the
following error.

01:00000:00010:2003/03/08 23:01:12.67 server Error: 622, Severity: 20,
State: 1
01:00000:00010:2003/03/08 23:01:12.67 server Opentable was passed a varno
of 1. Object 'temp worktable' already has that session descriptor in use.
01:00000:00010:2003/03/08 23:01:12.72 server Error: 8206, Severity: 20,
State: 5
01:00000:00010:2003/03/08 23:01:12.72 server Object -1245200 was not found
in WorkTabList.
00:00000:00009:2003/03/08 23:01:12.76 server Error: 622, Severity: 20,
State: 1
00:00000:00009:2003/03/08 23:01:12.76 server Opentable was passed a varno
of 1. Object 'temp worktable' already has that session descriptor in use.
00:00000:00013:2003/03/08 23:01:12.76 server Error: 622, Severity: 20,
State: 1
00:00000:00013:2003/03/08 23:01:12.76 server Opentable was passed a varno
of 1. Object 'temp worktable' already has that session descriptor in use.
00:00000:00014:2003/03/08 23:01:12.76 server Error: 622, Severity: 20,
State: 1
00:00000:00014:2003/03/08 23:01:12.76 server Opentable was passed a varno
of 1. Object 'temp worktable' already has that session descriptor in use.
01:00000:00001:2003/03/08 23:01:12.83 server Error: 9959, Severity: 20,
State: 1
01:00000:00001:2003/03/08 23:01:12.83 server The CHECKSTORAGE operation has
aborted.

I thought I would drop the dbccdb and recreate it again but the drop
database does not work as the database is still in use. The drop database
command was issued from master not from dbccdb. Ran sp_who but could'nt find
any user connected to dbccdb. Checked master..syslogshold but could'nt find
anything over there. How do I drop the database from the system tables????
or solve the problem. Please help!!!!

Regards

Jaideep

Bret Halford

unread,

Mar 11, 2003, 5:11:43 PM3/11/03

Sounds like the database's "keepcount", i.e. the counter of the number
of users, didn't get decremented when a client was killed.

If you reboot ASE, you should be able to drop the database, as a reboot
will clear the memory structure that holds the keepcount.

-bret

0 new messages