+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / sql schema warning on [idx_sf_url_data]

sql schema warning on [idx_sf_url_data]

9 posts, 1 answered
  1. Jochem Bökkers
    Jochem Bökkers avatar
    787 posts
    Registered:
    13 Aug 2007
    02 Oct 2011
    Link to this post
    When exporting data or running a schema script when porting from dev to test/prod SQL Manager keeps giving me a warning. I know it's a warning and not an error, merely pointing it out...

    Warning! The maximum key length is 900 bytes. The index 'idx_sf_url_data' has maximum length of 1275 bytes. For some combination of large values, the insert/update operation will fail.

    But that last sentence always makes me reach for the garlic and keeps my fingers crossed.
    J.
  2. Svetoslav Petsov
    Svetoslav Petsov avatar
    456 posts
    Registered:
    24 Sep 2012
    05 Oct 2011
    Link to this post
    Hello Jochem,

     This is indeed concerning, so I logged it as a bug in our system and the indexes of this table will be reevaluated for our future releases. Thanks for the report and sorry for the inconvenience caused. I updated your Telerik Points. If you have any further problems, don't hesitate to contact us.

    All the best,
    Svetoslav Petsov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
    Answered
  3. Jochem Bökkers
    Jochem Bökkers avatar
    787 posts
    Registered:
    13 Aug 2007
    05 Oct 2011
    Link to this post
    Hey Svetoslav,

    Awesome thanks! 
    And so far no inconvenience, so far it remains a mere warning.

    Jochem
  4. Ken
    Ken avatar
    1 posts
    Registered:
    26 Jul 2011
    13 Nov 2012
    Link to this post
    Any word on if/when this will be fixed? We're still getting this warning on a deployment with Sitefinity v5.0.2800.
  5. Boyan Barnev
    Boyan Barnev avatar
    1429 posts
    Registered:
    09 Dec 2016
    16 Nov 2012
    Link to this post
    Hello Ken,

    Thnak you for letting us know about your concern. Indeed his still remains a known warning, however we've postponed its implementation as it necessitates breaking changes in the product. Generally the warning should be perceived more as a pure warning rather than a p[possible issue indication. let me elaborate on that - a problem might occur only if the size of the data that generates the index exceeds 900bytes. In this case these columns are app_name and url, which we do not expect to reach this combined size in the normal use case scenarios.

    Greetings,
    Boyan Barnev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. Markus
    Markus avatar
    2763 posts
    Registered:
    25 Nov 2005
    06 Mar 2013 in reply to Boyan Barnev
    Link to this post

    Just tried to move some db stuff 5.4 and get 3 warnings:

    Warning! The maximum key length is 900 bytes. The index 'idx_sf_url_type' has maximum length of 1276 bytes. For some combination of large values, the insert/update operation will fail

    I have no clue if this important but it sure is not nice to read.

    Markus

     

     

  7. Boyan Barnev
    Boyan Barnev avatar
    1429 posts
    Registered:
    09 Dec 2016
    11 Mar 2013
    Link to this post
    Hello Markus,

    The warning is displayed by design, since we're indeed went above the default limit for the index size. However in the real case scenario, a problem might occur only if you have data (in this particular case URLs) that is exactly the same up to the limit size (to which it will be truncated),  which is a very low probability.

    All the best,
    Boyan Barnev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  8. Markus
    Markus avatar
    2763 posts
    Registered:
    25 Nov 2005
    11 Mar 2013 in reply to Boyan Barnev
    Link to this post

    @Boyan

    Thank's for the feedback. I assume this is going to stay that way because if you would change it you would run the risk of cutting of some customers URL. But that would be a very low probability :-)

    Thanks

    Markus

  9. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    14 Mar 2013
    Link to this post
    Hi Markus,

    Currently we do not have any plans for changing the functionality but we will keep you posted if any changes are about to occur.

    Regards,
    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
9 posts, 1 answered