[p4dti-discussion] Problem upgrading database schema from P4DTI2.3.5 -> 2.4.0

[Nick Barnes]

At 2007-07-31 01:26:05+0000, n.herring at atlantiscyberspace.com writes:
> I still couldn't get this to work, but I found out that my
> old_schema_version was 4.
> 
> So I just executed the commands here from the schema_upgrade array:
> 
> '4': ('5', ['alter table p4dti_replications'
>                     'add completed int not null default 0',
>                     'update p4dti_replications set completed=1'
>                     'where end >= start']),
> 
> Executed these in phpmyadmin and then changed my schema_version in the
> p4dti_config table to 5.
> 
> Things seems to be working. I get updates from out test P4 server and
> comments seem to work out.
> 
> One unknown is that all the rows in the table 'p4dti_replications'
> column 'completed' should be set to '1'? Currently I have the first 10
> at 0 and the rest (around 40) are '1'. Just wanted to make sure it is ok
> to change those to '1'.
> 
> I know this isn't what an end user is supposed to do, but please let me
> know if this was a completely wrong thing to do.
> 
> Thanks!
> 
> -Nick

Rows with completed set to 0 should be records of replication polls
which fail.  They sometimes come in handy when diagnosing and fixing
problems with replication.  If replication is running correctly, these
old rows are of no other use and can be safely deleted (or completed
set to 1, which will then cause them to be aged out of the database in
due course).  What are the datestamps like on them (the start and end
columns)?

Nick Barnes
Ravenbrook Limited