Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unremovable value assignments to an entity (ghost values) #3849

Closed
FO-nTTaX opened this issue Mar 26, 2019 · 12 comments

Comments

Projects
None yet
4 participants
@FO-nTTaX
Copy link
Contributor

commented Mar 26, 2019

Setup and configuration

  • SMW version: 3.0.1
  • MW version: 1.31.1
  • PHP version: 7.0.33-0+deb9u3
  • DB system (MySQL, Blazegraph, etc.) and version: 10.2.21-MariaDB-10.2.21+maria~stretch

Issue

When I go to this page [1], it does not show certain properties that shouldn't be defined, however searching for a certain property nets me a result from that page [2]. The property does not seem to have a value for the page, but it still has one.

I've tried both using the button "Outdated entities disposal" and a full data rebuild to no avail. Even blanking the page this is observed on [3] entirely does not remove the property value. The same issue is true for all similar pages we have though, not necessarily related to this specific page.

The SMW {{#set:}} in the template [4] that usually sets this property is inside an {{#if:}} of Extension:ParserFunctions, in case that makes any difference.

At this point I'm out of ideas what to try to remove this property value, any suggestions are welcome.

[1] https://liquipedia.net/dota2/Special:Browse/:User:BlueOceanz-2FBlueOceanz
[2] https://liquipedia.net/dota2/index.php?title=Property%3AHas+nationality&limit=100&offset=0&filter=BlueOceanz
[3] https://liquipedia.net/dota2/User:BlueOceanz/BlueOceanz
[4] https://liquipedia.net/dota2/Template:Infobox_player

Steps to reproduce

I have included links to the relevant pages above.

@mwjames

This comment has been minimized.

Copy link
Contributor

commented Mar 26, 2019

@kghbln kghbln added the question label Mar 26, 2019

@trevize23

This comment has been minimized.

Copy link

commented Mar 27, 2019

I don't understand the issue, looking at [0] I see the following properties, so which of them are unremovable?

The issue is not with [0] (or OP's [1]), but the property value will still show up in [2].

@kghbln

This comment has been minimized.

Copy link
Member

commented Mar 27, 2019

It appears to me that the current example properly sets the property values. So we cannot see what is going on in the described situation. What about changing the page to a state where you believe not to set any values but still have a value in [2]?

@FO-nTTaX

This comment has been minimized.

Copy link
Contributor Author

commented Mar 27, 2019

Isn't that exactly what my example up there is? It should not set Property:Has_nationality, yet there is a value in [2].

@mwjames

This comment has been minimized.

Copy link
Contributor

commented Mar 27, 2019

@FO-nTTaX

This comment has been minimized.

Copy link
Contributor Author

commented Mar 28, 2019

Well, then this belongs into the problem statement to clearly state what, when, how. Taken aside the semantics of how to construct a bug report.

That's what I tried to say with

The property does not seem to have a value for the page, but it still has one.

I'll try to use better English next time, it's not my native language, sorry about that.

As for the Questions:

  • Can you confirm that in table wikidota_smw_object_ids there is only one object that matches the User:BlueOceanz/BlueOceanz representation.

For select * from wikidota_smw_object_ids where smw_title = 'BlueOceanz/BlueOceanz' and smw_namespace = 2; I get 5 rows:

+---------+---------------+-----------------------+-------------+----------------------------------------+-------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+---------+
| smw_id  | smw_namespace | smw_title             | smw_iw      | smw_subobject                          | smw_sortkey                                                                         | smw_sort                                                                            | smw_proptable_hash                                                                                                                                                                                                                                         | smw_hash                                 | smw_rev |
+---------+---------------+-----------------------+-------------+----------------------------------------+-------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+---------+
| 1633279 |             2 | BlueOceanz/BlueOceanz |             |                                        | bLink                                                                               | bLink                                                                               | a:4:{s:11:"smw_di_time";s:32:"3faf432da79e7478d6f834a426c8e105";s:11:"smw_fpt_ask";s:32:"82290df43e28e3fab94a4e72c05af2d6";s:14:"smw_fpt_dtitle";s:32:"c948e17b0237167acaab69d49bcf7218";s:12:"smw_fpt_mdat";s:32:"9e71a50e9b2a1c275c896816a9aaaf30";}     | ba3cf643d93dcbeebc54763e382a8c5b99ca06b8 |  737610 |
| 3835688 |             2 | BlueOceanz/BlueOceanz |             | _QUERY021984bfa8925ce7f22f6e6abbea91ae | bLink# QUERY021984bfa8925ce7f22f6e6abbea91ae                                        | bLink# QUERY021984bfa8925ce7f22f6e6abbea91ae                                        | a:4:{s:13:"smw_fpt_askde";s:32:"b812d1b17c3eea815abc148728234f34";s:13:"smw_fpt_asksi";s:32:"bf0736027ea55d7e95ce5d8253a20d88";s:13:"smw_fpt_askfo";s:32:"c169eaec7c2f7b4ff62910274106c08d";s:13:"smw_fpt_askst";s:32:"008c16fdbe68e513284afe1b29f44ed7";} | ac6b6e3847b8ee0759e80893a6b58ca459f15211 |    NULL |
| 3835689 |             2 | BlueOceanz/BlueOceanz |             | _QUERY6eae3dd76c7b50e3b58684ada481be42 | bLink# QUERY6eae3dd76c7b50e3b58684ada481be42                                        | bLink# QUERY6eae3dd76c7b50e3b58684ada481be42                                        | a:4:{s:13:"smw_fpt_askde";s:32:"47a819acdf5d1443691c42d32305806a";s:13:"smw_fpt_asksi";s:32:"3fd9a1061c4604bd7038d9defc4050b8";s:13:"smw_fpt_askfo";s:32:"e67f121ead3a7148ccde7163be3510a8";s:13:"smw_fpt_askst";s:32:"c7910c82d3dd92c35d033cd6ab3cf0c4";} | 5e87a4809817fc12f838616cc4d82410d6b12abf |    NULL |
| 3825610 |             2 | BlueOceanz/BlueOceanz | :smw-delete | _QUERY021984bfa8925ce7f22f6e6abbea91ae | bLink# QUERY021984bfa8925ce7f22f6e6abbea91ae# QUERY021984bfa8925ce7f22f6e6abbea91ae | bLink# QUERY021984bfa8925ce7f22f6e6abbea91ae# QUERY021984bfa8925ce7f22f6e6abbea91ae | a:0:{}                                                                                                                                                                                                                                                     | 44757d23b399ba8d545d93020ff41669e395efca |    NULL |
| 3825611 |             2 | BlueOceanz/BlueOceanz | :smw-delete | _QUERY6eae3dd76c7b50e3b58684ada481be42 | bLink# QUERY6eae3dd76c7b50e3b58684ada481be42# QUERY6eae3dd76c7b50e3b58684ada481be42 | bLink# QUERY6eae3dd76c7b50e3b58684ada481be42# QUERY6eae3dd76c7b50e3b58684ada481be42 | a:0:{}                                                                                                                                                                                                                                                     | 479869f9c1434b592a254762543b0c260b978ab6 |    NULL |
+---------+---------------+-----------------------+-------------+----------------------------------------+-------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------+---------+
  • Does the Duplicate entities lookup contain any entries for User:BlueOceanz/BlueOceanz

Duplicate entities lookup does not contain this page, it has a dozen or so other pages though.

Thank you for your effort in helping me with this one.

@mwjames

This comment has been minimized.

Copy link
Contributor

commented Mar 28, 2019

@FO-nTTaX

This comment has been minimized.

Copy link
Contributor Author

commented Mar 28, 2019

  • Can you confirm that table wikidota_smw_di_blob has a matching entry for s_id=1633279 and p_id=20091 before purging

select * from wikidota_smw_di_blob where s_id = 1633279 and p_id = 20091 ;

+---------+-------+--------+------------+
| s_id    | p_id  | o_blob | o_hash     |
+---------+-------+--------+------------+
| 1633279 | 20091 | NULL   | BlueOceanz |
+---------+-------+--------+------------+
  • Can you confirm that after purging the page those entries are still available in the wikidota_smw_di_blob

After a blank edit and a action=purge purge, the values are still there exactly like that.

@mwjames

This comment has been minimized.

Copy link
Contributor

commented Mar 28, 2019

@FO-nTTaX

This comment has been minimized.

Copy link
Contributor Author

commented Mar 28, 2019

That workaround with setting the property worked just fine, thank you for the hint there. Maybe we should just do a rebuildData.php with the maintenance script if we see issues like this in the future, that might avoid me stealing your time.

Thank you so much for taking the time to help us with our issue here though, it is much appreciated!

@mwjames

This comment has been minimized.

Copy link
Contributor

commented Mar 28, 2019

@mwjames

This comment has been minimized.

Copy link
Contributor

commented Mar 30, 2019

For future reference, the appearance of so called ghosts or remnant entities is now described in [0] with #3866 providing an active counter measure to avoid the manual intervention of "... the easiest way to restore the smw_proptable_hash content hash balance is by adding a simple Has nationality assignment, save it, and removed it which should ensure that all leftovers ...".

[0] https://www.semantic-mediawiki.org/wiki/Help:Remnant_entities

@mwjames mwjames changed the title Unremovable SMW properties Unremovable value assignement to an entity (ghost values) Mar 30, 2019

@mwjames mwjames changed the title Unremovable value assignement to an entity (ghost values) Unremovable value assignments to an entity (ghost values) Mar 30, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.