Re-loading a v12.0.1.3152 database I get this error message

Could not execute statement. User 'another user' has the row in 'Person' locked SQLCODE=-210, ODBC 3 State="40001" Line 23582, column 1 You can continue executing or stop.

ALTER TABLE "pears"."employment" ADD NOT NULL FOREIGN KEY "person" ("personid") REFERENCES "pears"."Person" ("personid")

This is similar to this question (Dec 2009), relating to 10.0.1 where the issue seemed to be the cleaner process, and work was in progress to resolve this.

I don't see anything in the latest readme about cleaner issues since 3152, and wonder if this problem could have returned. The tables in question have several 100,000 rows each, but are much smaller than other tables that have similar keys and re-loaded without problem.

There are of course no other external users connected to the database.

asked 03 Nov '11, 09:40

Justin%20Willey's gravatar image

Justin Willey
6.8k110142212
accept rate: 20%

edited 03 Nov '11, 09:41

1

What is the page size of the database? Does the target database have the same page size?

(04 Nov '11, 16:32) Breck Carter
Replies hidden

It was 4k to 4k - no change.

(07 Nov '11, 11:36) Justin Willey

As far as I'm aware, we had solved this specific problem in 2009. QTS 605792 renamed all background connections so that, in case this sort of problem was reported, a more useful identifier than "other user" would be reported. That fix went into 12.0.0GA, in addition to 10.0.1 and 11.0.1. QTS 609706 embodies the changes made to prevent DDL statements, such as ALTER TABLE, from reporting an error due to cleaner activity. This also shipped in 12.0.0GA.

Is this problem reproducible, Justin? Will your reload.sql script create this problem reproducibly? If so, I would like to see that script and get it to fail here in the lab.

My apologies for the inconvenience.

permanent link

answered 04 Nov '11, 15:56

Glenn%20Paulley's gravatar image

Glenn Paulley
10.7k571104
accept rate: 43%

edited 05 Nov '11, 18:14

Volker%20Barth's gravatar image

Volker Barth
30.8k308456665

Glen, thanks for taking a look at this.

I'll try running it again and see if the same thing happens.

The reload data itself is pretty big (50 GB odd) and contains data we can't release; the script itself is no problem, but I suspect that won't be enough.

(04 Nov '11, 16:01) Justin Willey
Replies hidden

It didn't happen a re-run, but I'll be doing this a few more times before its finished, so I'll see if it repeats. Thanks.

(07 Nov '11, 11:37) Justin Willey
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:

×412
×14

question asked: 03 Nov '11, 09:40

question was seen: 964 times

last updated: 07 Nov '11, 11:37