We are using SQL/Anywhere 16. We started having trouble with Sybase Central crashing when we clicked "users" or "roles". When I looked at the error message that was being generated, it was reporting an error 'user "BugsBunny" already exists in user map. I did a DROP USER BugsBunny, and it executed OK. Now Sybase Central can load the "Users" and "Roles" lists.

I tried to re-create the user "BugsBunny" in Sybase Central, and it fails with a "User already exists" error. I did "select * from sysusers", and BugsBunny is not there.

I'm stumped on where to look next.

asked 12 Jan, 16:57

Bud%20Durland%20MRP's gravatar image

Bud Durland MRP
1011512
accept rate: 100%

edited 12 Jan, 16:57

I am curious, what if you unload the DB to CSV files. Would you find "BugsBunny" there?

(13 Jan, 15:35) Vlad
Replies hidden

Is it possible you have created two or more databases, and from time to time you click on the wrong entry in Sybase Central?

Or, is it possible you are using Sybase Central for some operations, and ISQL for other operations, and they are connected to different databases?

(14 Jan, 08:39) Breck Carter
Replies hidden

That's actually my plan for today. It's a 50+ GB database, so first I'm going to do a "no data" unload and look at the resulting SQL.

(15 Jan, 10:19) Bud Durland MRP

We do have a copy of this database that we use for testing and training. Because this started as an error in Sybase Central that started happening after a flurry of patches and updates, that was one of the first things we tested -- does it occur in the test database, and it does not.

(15 Jan, 10:21) Bud Durland MRP

No Joy. loading the the .sql file created by a "no data" unload into an editor shows not traces of BugsBunny. I can unload the data files & see if he appears there, but I suspect that will be pointless, since the data is user tables, not system tables.

(17 Jan, 08:09) Bud Durland MRP

What if you create the user via SQL?

(17 Jan, 08:20) Vlad

Same error with different window dressing:

Could not execute statement.

User "BugsBunny" already exists SQLCODE=-1198, ODBC 3 State="HY000" Line 1, column 1

create user BugsBunny IDENTIFIED by WhatsUpDoc

(18 Jan, 14:23) Bud Durland MRP

When you use the reload script to build a new database with the same schema but without data, can you create that particular user there? Does it matter whether you use CREATE USER or GRANT CONNECT?

(18 Jan, 15:57) Volker Barth
1

If I was facing these behaviours, I would tend to start thinking about the possibility of a corruption in the database. Have you run validation on it?

(18 Jan, 16:25) Chris Keating

So a "VALIDATE TABLE sys.isysuser" might show a problem?

(19 Jan, 05:04) Volker Barth
showing 2 of 10 show all flat view

Wanted to follow up on this. The problem was resolved by restarting the database service. I worked with Sybase tech support on it. It was probably a corrupt in-memory table or hash of some sort. I failed to capture a memory dump of the running dbSrv process, which would have been useful to tech support.

permanent link

answered 07 Feb, 08:22

Bud%20Durland%20MRP's gravatar image

Bud Durland MRP
1011512
accept rate: 100%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×107
×19

question asked: 12 Jan, 16:57

question was seen: 293 times

last updated: 07 Feb, 08:22