U4-9456 - Log Warning - multiple property sets for document definition - returning multiple versions of the same content item doesn't work

Created by Lee Kelleher 31 Jan 2017, 14:56:06 Updated by Mark Bowser 24 Apr 2017, 21:41:08

Tags: Unscheduled Regression

Relates to: U4-9536

Subtask of: U4-9548

Some changes made to the query to build up a content item has affected how returning multiple versions for a single content item works. This will affect viewing the rollback dialog. This issue also causes false positive warnings to pollute the log.

Original Report:

After checking my tracelog (for an unrelated issue), I noticed many warning entries like this...

2017-01-31 06:40:26,852 [P46572/D28/T14] WARN
Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6233.15010, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 11052, Language Landing Page

When I say many, it appears about 180 times (consecutively, in bulk), typically at app start-up.

The node ID (and doctype alias) does alter at different points in the log. From looking in the CMS, those nodes appear fine.

We've recently upgraded to Umbraco v7.5.8 (''our complete upgrade path was: 7.4.3 > 7.5.4 > 7.5.5 > 7.5.6 > 7.5.7 > 7.5.8, all on Umbraco Cloud''). We hadn't noticed this specific warning previously.

Please let us know if you require any further details.

2 Attachments

Comments

Dan Booth 31 Jan 2017, 15:15:27

Like Lee I've started seeing this after an upgrade to 7.5.8 - but it still appears in the same site after "downgrading" back to 7.5.6.

For instance, in the site I created a new Document Type called "Timeline" - nothing particular special about it. When a page using this document type was publish the log was flooded with this error. The log timeline looks something like this (also see screenshot):

11:59:25.176 INFO Umbraco.Core.Publishing.PublishingStrategy Content 'Our History' with Id '2557' has been published.

11:41:25.233 WARN Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6185.24083, Culture=neutral, PublicKeyToken=null]] The query returned multiple property sets for document definition 2557, Timeline

11:41:25.233 WARN Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6185.24083, Culture=neutral, PublicKeyToken=null]] The query returned multiple property sets for document definition 2557, Timeline ....

The warning appears about 20 times consecutively for every publish.

Apart from this, the page works as expected and there aren't any obvious issues. But it's a little worrying and perhaps is indicative of an underlying more serious issue?


Steve Borg 09 Feb 2017, 07:59:18

I've also started seeing this a lot in the log file. It was worse in our case as a preview on our home page caused lots of these to start appearing in the log. Then we found that the home page could never be loaded in the back-office even after an app pool recycle and after deleting the umbraco xml file. It just kept showing the loading image whilst the log file filled up with about 10 of these every second. I have had to revert the node manually in the database and instructed the content editors to not use preview on this node for the time being. Does anyone know why this is happening?


Nicholas Westby 14 Feb 2017, 22:47:27

Just started noticing this myself on a site that was upgraded to Umbraco 7.5.9. A bunch of entries in the log that look like this:

2017-02-14 14:33:50,466 [P4128/D2/T12] WARN Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6249.19432, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 3824, Product Category Listing

The upgrade path was something like 7.4.3 > 7.5.4 > 7.5.6 > 7.5.9.


Shannon Deminick 20 Feb 2017, 10:09:33

Is anyone using Courier with regards to this error?

This is due to an database issue where there is more than one 'newest' and 'published' cmsDocument row per nodeId. In these later versions the querying has been improved, but if there was corrupted data in the db, you'd get this warning. That said, you can 'fix' this issue for any node Id causing this warning by navigating to the item in the back office (though if you have this problem you may see duplicate tree nodes for it in the back office), then change a property value and SaveAndPublish (you can obviously change the value back and re SaveAndPublish), this will fix the data issue in cmsDocument.

You can tell which node ids are corrupted with this query:

SELECT cmsDocument.nodeId, MAX(p.publishedCount) publishedCount, MAX(n.newestCount) newestCount FROM cmsDocument
LEFT JOIN (SELECT nodeId, COUNT(*) as publishedCount FROM cmsDocument WHERE published = 1 GROUP BY nodeId) p ON p.nodeId = cmsDocument.nodeId
LEFT JOIN (SELECT nodeId, COUNT(*) as newestCount FROM cmsDocument WHERE newest = 1 GROUP BY nodeId) n  ON n.nodeId = cmsDocument.nodeId
WHERE publishedCount > 1 OR newestCount > 1
GROUP BY cmsDocument.nodeId

We're doing some investigation work: http://issues.umbraco.org/issue/U4-9536, http://issues.umbraco.org/issue/COU-519

The duplicate flags just shouldn't happen, but if they were already in there then the new query structures don't deal with it, however, if the data corruption is new then we need to figure out how that's happening. Nothing in core has changed in that regard and we cannot replicate the problem with core or courier, but there's a chance it's a sequence of events that causes this.


Shannon Deminick 20 Feb 2017, 10:12:44

I would highly recommend using the latest 7.5.9 (which is right now 7.5.9 but 7.5.10 will be out tomorrow) because these queries have been tweaked over the last few versions and some regression issues from 7.5.7 and 7.5.8 have been fixed like: http://issues.umbraco.org/issue/U4-9438


Dan Booth 20 Feb 2017, 12:56:35

@Shandem Nope, we don't use Courier. The issue has arisen on a DB that was upgraded, though.

I should point out that the issue I saw occurred after a brand new document type was added after the upgrade and then a new page instance created with that document type. I'm also randomly seeing it for other document types, too. Seems fairly frequent now. I'm not at work ATM but will check the queries to see if there is any DB corruption.

I'd love to Upgrade to latest version but this issue with Archetype not working with Image Cropper in 7.5.9 is a show-stopper for any upgrade, as it will break the site - http://issues.umbraco.org/issue/U4-9446 (I realise this may not be an Umbraco issue, but it still prevents upgrade).


Shannon Deminick 20 Feb 2017, 23:19:35

I have commented there - that could very well be due to the issue I mentioned above.


Nicholas Westby 21 Feb 2017, 16:50:33

@Shandem FYI, I'm not using Courier.

Also, I ran that SQL query and it returns zero results. I suppose it's possible that every affected content node was since republished (which is the fix you indicated).


Steve Borg 22 Feb 2017, 12:22:22

I'm not getting any results when running the SQL query either. But now, when I go to a particular node in the back-office that has child items shown in a list I am getting a load of these errors. Could this be caused by failed previews? 82 of the same error on a node with 18 children.


Shannon Deminick 22 Feb 2017, 12:33:07

Ok well this is 'good' news, having the corrupt data would be much worse than these warnings. Perhaps there is something with preview and this logging a warning incorrectly, I'll have to investigate.

Can everyone confirm in this issue then that you haven't actually seen corrupt data? (you would have seen duplicate nodes in the tree too) and that its just the warning you are seeing?


Steve Borg 22 Feb 2017, 12:46:24

This may be significant or may be coincidental. I just looked at the audit trail on the node in question. The last item is a save on the 7th of February rather than a publish. I just went to various log files going back from today to 7th Feb. In each one (that wasn't a weekend - therefore no back-office access) I found the same errors for that node. When I went to the log file of 6th Feb and a few earlier I don't find the error.


Steve Borg 22 Feb 2017, 12:57:40

As a test I just published the node and all of the errors have stopped.


Shannon Deminick 22 Feb 2017, 13:14:08

This is good stuff! Sounds like we have non error and just a prob with warning about something that is not wrong, gives me something to test. Let me know if it comes back if you just resave again (you'll prob need to change a val of something for it to create a new version)

The real data corruption issue i think is related to something odd with Courier, still investigating that.


Dan Booth 22 Feb 2017, 13:46:10

@Shandem In our case I have not seen any corrupted data or duplicate nodes and the SQL query doesn't return any nodes. It does seem to crop up a lot, but the document type in question varies. Note that it appears against a document type definition, not a node instance (or at least the logged error doesn't mention the node instance). So when you have a lot of instances of a node, it's hard to know which one is being referenced or which one to republish.


Nicholas Westby 22 Feb 2017, 21:36:32

Same here, it applies to multiple document types.


Nicholas Westby 23 Feb 2017, 23:19:31

Came across something interesting. In the process of dealing with an unrelated issue, I deleted my Examine indexes and restarted the website. Each time I did that, my Umbraco log text file filled up with over 4MB of entries. Most of them look like this:

 2017-02-23 15:07:25,639 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4936, Product Listing
 2017-02-23 15:07:25,771 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4936, Product Listing
 2017-02-23 15:07:25,771 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4936, Product Listing
 2017-02-23 15:07:25,836 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4936, Product Listing
 2017-02-23 15:07:25,836 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4936, Product Listing
 2017-02-23 15:07:25,883 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4936, Product Listing
 2017-02-23 15:07:25,883 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4936, Product Listing
 2017-02-23 15:07:26,020 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,020 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,120 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,120 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,199 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,199 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,267 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,267 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4937, Typical
 2017-02-23 15:07:26,404 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:26,404 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:26,567 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:26,567 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:26,891 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:26,891 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:26,942 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:26,942 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4938, Typical
 2017-02-23 15:07:27,041 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,041 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,141 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,141 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,226 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,226 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,510 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,510 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4939, Typical
 2017-02-23 15:07:27,626 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:27,626 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:27,904 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:27,904 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:28,007 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:28,007 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:28,113 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:28,113 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4940, Typical
 2017-02-23 15:07:28,294 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,294 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,435 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,435 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,495 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,495 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,542 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,542 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4941, Typical
 2017-02-23 15:07:28,642 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:28,642 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:28,793 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:28,793 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:28,827 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:28,827 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:29,136 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:29,136 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4942, Typical
 2017-02-23 15:07:29,230 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,230 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,299 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,299 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,352 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,352 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,435 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,435 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4943, Product Listing
 2017-02-23 15:07:29,568 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4944, Product Listing
 2017-02-23 15:07:29,568 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4944, Product Listing
 2017-02-23 15:07:29,684 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4944, Product Listing
 2017-02-23 15:07:29,684 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4944, Product Listing
 2017-02-23 15:07:29,768 [P6228/D2/T6] WARN  Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[Umbraco.Core.Models.IContent, Umbraco.Core, Version=1.0.6261.14290, Culture=neutral, PublicKeyToken=null]] - The query returned multiple property sets for document definition 4944, Product Listing

The interesting thing to note is that different numbers are returned for the same document type definition. I assumed this number was referring to the document type definition itself (based on the wording of the error message), but it seems like these numbers are content node ID's.

Also, the volume of these messages leads me to believe this is not particular to specific content nodes. Rather, it seems to apply to every content node (or quite a lot of them, anyway).


Shannon Deminick 23 Feb 2017, 23:58:48

Yup, pretty sure the issue is 'just' how it's dealing with newest vs published rows in the SQL result, we'll have it fixed so it stops logging all of this


Shannon Deminick 24 Feb 2017, 02:54:45

Fixed in rev: 28f0ab1001e0b2f7b4d5ee0f1fe390cadf7498c0

Will be part of the PR and fix for http://issues.umbraco.org/issue/U4-9536


Shannon Deminick 27 Feb 2017, 12:45:47

Although this warning is a false positive, there is another underlying issue here where the ContentService.GetAllVersions isn't returning the correct data which will mean that the values displayed in the rollback screen will not be accurate.


Stephan 02 Mar 2017, 10:38:36

fixed as part of U4-9536


Mark Bowser 24 Apr 2017, 21:35:56

I'm running into this problem on one of our sites that was recently upgrade from 7.4.3 to 7.5.9. We are using Courier to deploy from an authoring to a production version of the site. I ran your query and found some results. I included a screenshot of the query and those results. Our english home page is node 1141 and there are 12 duplicates in addition to the original (13 of them total). All of them share the same node id.


Mark Bowser 24 Apr 2017, 21:41:08

I just redeployed the node via courier and it is solving my problem. Thanks for the workaround, Shannon. Turns out that this problem looks a lot more alarming than it actually is. I haven't had it affect our frontend yet.


Priority: Normal

Type: Bug

State: Fixed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.5.6, 7.5.7, 7.5.8, 7.5.9

Due in version: 7.5.11

Sprint: Sprint 53

Story Points:

Cycle: