[ZendTo] Re: Duplicate dropoff id

[Artyom Aleksandrov]

I advice to add PK that associated with rowid for dropoff table. Because it
can broke DB after .dump or Vacuum.

http://www.sqlite.org/lang_createtable.html#rowid

As for me I had created new dropoff_tmp table with PK (see above link),
migrated data to it and after that did .dump successfully.


On Thu, Jun 6, 2013 at 1:36 PM, Artyom Aleksandrov
<mailing.list at tem4uk.ru>wrote:

> I found mistake!
>
> I converted sqlite db from 2 to 3 using dump.
> And because dID it's just rowid in dropoff tables, I lost all rows with
> deleted dropoff.
>
>
>
> On Thu, Jun 6, 2013 at 1:21 PM, Artyom Aleksandrov <mailing.list at tem4uk.ru
> > wrote:
>
>> Some debug info.
>>
>> It doesn't use duplicate dID how I thought before.
>> It is remapping dID for previously upload files.
>>
>> For example: I created new dropoff (214) and add one file (887) and after
>> that other files change their dID for new one.
>> sqlite> select rowid,dID from file where dID='214';
>> 727|214
>> 728|214
>> ...
>> 739|214
>> 740|214
>> 741|214
>> 887|214
>>
>>
>> On Thu, Jun 6, 2013 at 12:29 AM, Artyom Aleksandrov <
>> mailing.list at tem4uk.ru> wrote:
>>
>>> Hi, I migrated my zento installation from Ubuntu 8.04 to 12.04 and
>>> caught disgusting bug.
>>>
>>> Time to time when someone create new dropoff his/her files are including
>>> to already exist dropoff. And on dropoff summary page we can see old
>>> dropoff with download statistic  and old/new files.
>>>
>>>  It looks like "Did" (dropoff id) is not unique and there isn't check
>>> for it.
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20130606/017962a0/attachment.html