Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sebastian Dammark 547 posts 1287 karma points
    Jan 08, 2016 @ 12:23
    Sebastian Dammark
    0

    SQL Timeout

    For some reason I get an SQL timeout when I try to enter the interface. In the log files it says:

    Error executing query SELECT Id FROM icUrlTracker WHERE OldUrl IS NULL AND OldRegex IS NULL System.Data.SqlClient.SqlException (0x80131904): Timeout expired.

    But when I try to execute this directly on the server it gives me big round 0 (ZERO)

    SELECT COUNT([Id]) FROM [dbo].[icUrlTracker] WHERE [OldUrl] IS NULL AND [OldRegex] IS NULL

    There are 4.300.000 records in total in the table. What should I do ?

    I'm using Umbraco 7.2.6

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Jan 11, 2016 @ 08:06
    Stefan Kip
    100

    There are 4.300.000 records in total in the table. What should I do ?

    Wow... That's a lot! I'd remove all 404 entries I guess.
    If the result of this query is high:

    SELECT COUNT(*) FROM icUrlTracker WHERE is404 = 1

    You can remove them with this query:

    DELETE FROM icUrlTracker WHERE is404 = 1

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies