Re: Error in Index Reorg in Maintenance Task

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you Tibor.

Yes, I have re-confirmed several times that I am looking at the correct
index as well as that settings are set. I guess it is a bug then.

Thanks.


"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in
message news:u10wpy2GKHA.3736@xxxxxxxxxxxxxxxxxxxxxxx
Hmm... I would very that I'm absolutely 100% certain that I'm looking at
the right index. If that is the case, and the setting really is correct,
then I'd open a case with MS Support as I would consider what you see a
bug.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Dragon" <nospam@xxxxxxxxxxx> wrote in message
news:OspSdeyGKHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
Thank you Tibor.
I have been able to resolve all of the indexing issues like these except
on one index. This index already has the allow page lockes turned on but
I still get the same error. So far I have tried this:

Turned Allow Page Lock on and tried re-org.
Turned Allow Page Lock off and tried re-org.
Dropped and Recreated index and tried re-org.

In all case I am getting the same error.

Thank you for your help.

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote
in message news:e5Nq8EqGKHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
Somebody disabled page level locking for the index, for some reason. You
can query sys.indexes to find out which indexes has page locking
disabled and take it from there. Page locking need to be enables for
ALTER INDEX ... REORGANIZE.

SELECT OBJECT_NAME(object_id), * FROM sys.indexes
WHERE allow_page_locks = 0


--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Dragon" <nospam@xxxxxxxxxxx> wrote in message
news:%2317bO1oGKHA.3888@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have created a maintenance plan which performs the following (in
order, on all databases):

- Check Database Integrity
- Reorganize Index
- Update Statistics
- Cleanup History
- Backup Databases
- Maintenance Cleanup Task

All seems to be working fine except that everyday I have 2-3 index
reorgs that fail. I am listing one of the errors below (they are all
same but for different indexes). Errors show up on either same or
different indexes everyday.

Our system is running Windows 2003 Cluster w/ SQL 2005 Std Cluster
(SP3).

Could someone please give me some pointers as to what might be wrong
here?

Thank you.

Failed:(-1073548784) Executing the query "ALTER INDEX
[idx_Installation_ID] ON [dbo].[ASD_Analysis_Data] REORGANIZE WITH (
LOB_COMPACTION = ON )
" failed with the following error: "The index "idx_Installation_ID"
(partition 1) on table "ASD_Analysis_Data" cannot be reorganized
because page level locking is disabled.". Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.









.

Relevant Pages

  • Re: Xorg.conf, What keeps changing Modes at Bootup
    ... I set the display setting in Aminstration> Display to 1024x768 and in ... lower resolution settings. ... If you want a lower resolution, set it as a user preference (screen ... This bug report has been ignored for 1.5 years and will be closed unless ...
    (Fedora)
  • Re: required LD versus required MC to make it home
    ... Just set your bug factor ... and leave the thermal once the arrival altitude is to your ... different (your settings, for example) should be less complicated. ... glide at the same speed. ...
    (rec.aviation.soaring)
  • Re: PROBLEM: kernel BUG at drivers/media/video/em28xx/em28xx-video.c:891
    ... On Wed, 19 Jan 2011, Patrik Jakobsson wrote: ... Because now the video4linux core does the locking. ... The change in the locking mechanism had nothing to do this particular bug. ...
    (Linux-Kernel)
  • Re: Change default from Lock to Log Off
    ... you could use a group policy to disable locking ... the workstation at all. ... you should probably be locking down a lot of things ... in there (desktop wallpaper, IE settings, etc etc etc). ...
    (microsoft.public.win2000.general)
  • Re: [SLE] firefox interface font woes
    ... Check out the screenshot in this bug: ... > My question is why won't firefox honor the settings in userChrome.css? ... Nevertheless I have to speculate a possible DPI problem in spite of the ... in your original profile directory, and if that doesn't work, *.rdf. ...
    (SuSE)