Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Cannot drop or modify partition descriptor database, Sybase

Posted on 2009-02-20
7
Medium Priority
?
1,753 Views
Last Modified: 2012-05-06
Hi Experts,

I wanted to know why this error is coming. We have a daily process which updates the data from one database to another.  I don't see any any process which use the database table at the time when error occured. It happens intermittently as our process runs daily. The error is coming up on the line where we are creating the index.


Cannot drop or modify partition descriptor database 'databasename' (10), object 'name' (1040006736), index 'name' (0), partition 'name_1040006736' (1040006736) as it is in use. Please retry your command later. Total reference count '4'. Task reference count '2'.
<<< FAILED CREATING INDEX dbo.name.index >>>

Thanks
0
Comment
Question by:rbhargaw
  • 4
  • 3
7 Comments
 
LVL 19

Expert Comment

by:grant300
ID: 23693890
Let's start with which Sybase database product, ASE, ASA, ASIQ, the version, and the platform.

Also, you say you are moving data from one database to another.  In ASE, you have multiple databases on one Sybase server.  This is significantly different that moving data between two servers.

In the error message you included, it appears not to be a standard Sybase formatted error.  Can you tell us what tool you are using to run the script(s) and what the command, and maybe the two before it look like?  Finally, did you sanitize the error message, exchanging "databasename' for the real name?

Regards,
Bill
0
 

Author Comment

by:rbhargaw
ID: 23694371
It is Sybase ASE 15.0 on Unix. The two databases are in same server.

There is an cronjobs on Unix box which executes daily. If there is an error, it will put them in the log files on unix box.

I have put the sybase erros under the "Code Snippet"
Yes, I sanitized the message for "databasename".

Command lines are:

CREATE UNIQUE CLUSTERED INDEX index
    ON dbo.name(col1,col2,col3)
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.name') AND name='index')
    PRINT '<<< CREATED INDEX dbo.name.index >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.name.index >>>'
go

>>>> SYBASE ERRORS FOUND <<<<        
==========================================================================
BEGIN Truncate databasename tables:  02-20-2009 01:30:00 END Truncate databasename tables:  02-20-2009 01:30:26 BEGIN Dropping Indexes on databasename tables:  02-20-2009 01:30:26 END Dropping Indexes on databasename tables:  02-20-2009 01:30:28 BEGIN Migrate databasename tables 02-20-2009 01:30:28 END Migrate databasename tables 02-20-2009 01:40:21 BEGIN Create Indexes on databasename tables 02-20-2009 01:40:31 Msg 14127, Level 16, State 1:
Server 'servername', Line 3:
Cannot drop or modify partition descriptor database 'databasename' (10), END Creating Indexes on databasename tables 02-20-2009 01:51:07 BEGIN Update Statistics on databasename tables 02-20-2009 01:51:07 END Update Statistics on databasename tables 02-20-2009 01:52:40 

Open in new window

0
 

Author Comment

by:rbhargaw
ID: 23694482
Sybase Server Version:
Adaptive Server Enterprise/15.0.1/EBF 14201 ESD#2/P/Sun_svr4/OS 5.8/ase1501/2400/32-bit/FBO/
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
LVL 19

Expert Comment

by:grant300
ID: 23694776
First, and your not going to like this, I would not try to use 15.0.1 in production.  It just wasn't stable enough.  I consider 15.0.2 a good, solid production release and would plan on patching up to that level ASAP.

So is the table partitioned?  What kind of partitioning are you using, round robin or semantic?

Are you running out of either disk space, transaction log, or some other resource during the index build?  You are running 32 bit on Solaris (what version), SPARC I presume, which is kind of weird.  All that stuff has been 64 bit for a long time.  With 32 bit ASE, you are going to be rather memory constrained by todays standards.

Is it setup as DOL (Data Only Locking) or APL (All Pages Locking)?  I ask because the storage of tables and clustered indexes is different depending on the locking scheme.

CR 429295 on ASE 15.0.1 states:Stack trace associated with error 14127 "Cannot drop or modify partition descriptor ... as it is in use. Please retry your command later. Total reference count ... Task reference count ..." May be seen rarely when create placement index command is rolled back for resources reason.

You are not getting a stack trace put it adds another data point.

Regards,
Bill
0
 

Author Comment

by:rbhargaw
ID: 23695444
The table is partitioned  round robin and the setup is ALL Page locking. I will ask the  DBAs for disk space issue.
0
 
LVL 19

Accepted Solution

by:
grant300 earned 2000 total points
ID: 23697072
You need something like double the space the table normally takes up in order to build a clustered index so that could be part of the problem.  Also, check to make sure your transaction log is not filling up.  It could also be a problem on the MASTER db as well.

Regards,
Bill
0
 

Author Comment

by:rbhargaw
ID: 23703381
Our DBA will be looking on to the issue as I (as an developer) can't go much ahead.  

Thanks Bill, I have communicated the area of concerns as given by you to them.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this step by step method when setting up QuickBooks Online. They will allow you to explore the various features of the advanced settings available to you.
If you need to complete a Physical to Virtual (P2V), Virtual to Virtual (V2V) conversion to a VMware product (VMware Workstation, Player or VMware vSphere (ESXi) ) for FREE, then there is some good news...
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month10 days, 14 hours left to enroll

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question