[kronolith] last git head update constraint violation
Michael Rubinsky
mrubinsk at horde.org
Thu Feb 24 15:28:40 UTC 2011
Quoting LALOT Dominique <dom.lalot at gmail.com>:
> Hello Mickael,
>
> using the db_migrate --debug
> it produces:
>
> INSERT INTO `rampage_tagged` (user_id, object_id, tag_id, created)
> VALUES (22,4789,13,'2011-02-24T15:34:46')
> 2011-02-24T15:34:46+01:00 DEBUG: SQL
> INSERT INTO `rampage_tagged` (user_id, object_id, tag_id, created)
> VALUES (22,4789,13,'2011-02-24T15:34:46')
> 2011-02-24T15:34:46+01:00 DEBUG: SQL (0.0002s)
> SELECT object_id, object_name FROM `rampage_objects` WHERE
> object_name
> IN ('20070502100506.1y1yia5ws0n4 at webmel.univ.fr') AND type_id = 2
> 2011-02-24T15:34:46+01:00 DEBUG: SQL (0.0001s)
> SELECT user_id, user_name FROM `rampage_users` WHERE user_name IN
> ('bourdin')
> 2011-02-24T15:34:46+01:00 DEBUG: SQL (0.0001s)
> SELECT tag_id, tag_name FROM `rampage_tags` WHERE tag_name IN
> ('Priv▒')
> 2011-02-24T15:34:46+01:00 ERR: SQL QUERY FAILED: SQLSTATE[23000]: Integrity
> constraint violation: 1062 Duplicate entry '14-4790-9' for key 'PRIMARY'
Is 14-4709-9 one of your categories or tag names?
> Is it a problem of a partial update? Then it's hard to continue..It gives me
> 1919 constraint violations now.
> I don't understand the statement about checkTags and which file to open..
>
> Dom
>
>
> 2011/2/24 Michael Rubinsky <mrubinsk at horde.org>
>
>>
>> Quoting LALOT Dominique <dom.lalot at gmail.com>:
>>
>> Hello Mike
>>>
>>> Putting mysql in logging mode:
>>> 91 Query SELECT object_id, object_name FROM
>>> `rampage_objects` WHERE object_name IN ('
>>> 20070502100506.1y1yia5ws0n4 at webmel.univmed.fr') AND type_id = 2
>>> 91 Query SELECT 1
>>> 91 Query SELECT user_id, user_name FROM
>>> `rampage_users` WHERE user_name IN ('bourdin')
>>> 91 Query SELECT 1
>>> 91 Query SELECT tag_id, tag_name FROM `rampage_tags`
>>> WHERE tag_name IN ('Privé')
>>> 91 Query SELECT 1
>>> 91 Query INSERT INTO `rampage_tagged` (user_id,
>>> object_id, tag_id, created)
>>> VALUES
>>> (14,4790,9,'2011-02-24T09:02:47')
>>> 91 Query SELECT 1
>>> 91 Query SELECT object_id, object_name FROM
>>> `rampage_objects` WHERE object_name IN ('
>>> 20070502103754.4yb1afvr9lvk at webmel.univmed.fr') AND type_id = 2
>>> 91 Query SELECT 1
>>> 91 Query SELECT user_id, user_name FROM
>>> `rampage_users` WHERE user_name IN ('xxx')
>>> 91 Query SELECT 1
>>> 91 Query SELECT tag_id, tag_name FROM `rampage_tags`
>>> WHERE tag_name IN ('Évènements')
>>> 91 Query SELECT 1
>>> 91 Query INSERT INTO `rampage_tags` (tag_name)
>>> VALUES
>>> ('Évènements')
>>> 92 Quit
>>>
>>> The last INSERT is aborting in constraint violation
>>>
>>
>> Well, the SELECT right before that should have found the tag entry. Not
>> sure why it's not.
>>
>>
>> I started years ago, so my data are in ISO not in utf8
>>>
>>
>> If you haven't changed anything related to charset, I don't think this
>> makes a difference since both the INSERT and the SELECT would be in the same
>> charset, right?
>>
>>
>>
>>> What else can I do?
>>>
>>
>> You could try debugging a bit around the query in _checkTags() that I
>> pointed to before and see if anything pops up. Other than that, I'm honestly
>> not sure.
>>
>> Maybe another dev on list has an idea?
>>
>>
>> Thanks
>>>
>>> Dom
>>>
>>> 2011/2/23 Michael Rubinsky <mrubinsk at horde.org>
>>>
>>>
>>>> Quoting LALOT Dominique <dom.lalot at gmail.com>:
>>>>
>>>> Hello,
>>>>
>>>>>
>>>>> As Horde 4 told me to migrate the database of kronolith, I did that:
>>>>>
>>>>> root at horde4:/var/horde# horde/bin/db_migrate
>>>>> [ INFO ] Migrating DB up.
>>>>> [ INFO ] Current imp schema version: 2
>>>>> [ INFO ] Ending imp schema version: 2
>>>>> [ INFO ] Current ingo schema version: 5
>>>>> [ INFO ] Ending ingo schema version: 5
>>>>> [ INFO ] Current turba schema version: 5
>>>>> [ INFO ] Ending turba schema version: 5
>>>>> [ INFO ] Current kronolith schema version: 17
>>>>> 2011-02-23T17:57:31+01:00 INFO: Migrating to
>>>>> KronolithUpgradeCategoriesToTags (18)
>>>>> 2011-02-23T17:57:31+01:00 INFO: == 18 KronolithUpgradeCategoriesToTags:
>>>>> migrating =============================
>>>>> 2011-02-23T17:57:31+01:00 INFO: == 18 KronolithUpgradeCategoriesToTags:
>>>>> Migrating event categories. ===========
>>>>> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
>>>>> '▒v▒nements' for key 'rampage_tags_tag_name'
>>>>>
>>>>> What can I do?
>>>>>
>>>>>
>>>> Hm. I am unable to reproduce this no matter how many duplicate categories
>>>> I
>>>> add to the event table. The checks in Content_Tagger should catch this. A
>>>> query is done to see if the tag name exists already in
>>>> Content_Tagger::_checkTags(). You will need to find out why that query is
>>>> not finding the existing entry.
>>>>
>>>>
>>>> mike
>>>>
>>>> The Horde Project (www.horde.org)
>>>> mrubinsk at horde.org
>>>> --
>>>> Kronolith mailing list
>>>> Frequently Asked Questions: http://horde.org/faq/
>>>> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>>>>
>>>>
>>>
>>>
>>> --
>>> Dominique LALOT
>>> Ingénieur Systèmes et Réseaux
>>> http://annuaire.univmed.fr/showuser.php?uid=lalot
>>>
>>
>>
>> mike
>>
>> The Horde Project (www.horde.org)
>> mrubinsk at horde.org
>> --
>> Kronolith mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>>
>
>
>
> --
> Dominique LALOT
> Ingénieur Systèmes et Réseaux
> http://annuaire.univmed.fr/showuser.php?uid=lalot
mike
The Horde Project (www.horde.org)
mrubinsk at horde.org
More information about the kronolith
mailing list