treebase-devel

[Treebase-devel] new unit test failure

[youjun g. <you...@gm...>]

Dear All,

There is a new treebase unit test failure appeared recently. It due to
"submissions do not have a related submitter".

Following query result from the treebase-db may give you a  better idea:

select count(*) from submission where user_id is null : 2044

Youjun

[Treebase-devel] new unit test failure

[youjun g. <you...@ya...>]

Please ignore this one if you got my previous message from gmail

Dear All,

There is a new treebase unit test failure appeared recently. It due to
"submissions do not have a related submitter".

Following query result from the treebase-db may give you a  better idea:

select count(*) from submission where user_id is null : 2044

Youjun

Re: [Treebase-devel] new unit test failure

[William P. <wil...@ya...>]

On Mar 5, 2010, at 10:22 AM, youjun guo wrote:

> Dear All,
> 
> There is a new treebase unit test failure appeared recently. It due to "submissions do not have a related submitter".
> 
> Following query result from the treebase-db may give you a  better idea:
> 
> select count(*) from submission where user_id is null : 2044
> 
> Youjun  


I think the renewal of data for stage/production has brought back this user_id IS NULL problem. After we're done with migrations, we can reassign all TB1 studies to a new user_id. 

bp

Re: [Treebase-devel] new unit test failure

[Vladimir G. <vla...@du...>]

On Mar 5, 2010, at 10:29 AM, William Piel wrote:

>
> On Mar 5, 2010, at 10:22 AM, youjun guo wrote:
>
>> Dear All,
>>
>> There is a new treebase unit test failure appeared recently. It due  
>> to "submissions do not have a related submitter".
>>
>> Following query result from the treebase-db may give you a  better  
>> idea:
>>
>> select count(*) from submission where user_id is null : 2044
>>
>> Youjun
>
>
> I think the renewal of data for stage/production has brought back  
> this user_id IS NULL problem. After we're done with migrations, we  
> can reassign all TB1 studies to a new user_id.

This must have been caused by the treebase-dev restore from an older  
backup earlier this week.

I'd suggest to ignore this test on treebase-dev for now; resolve the  
problem on treebase-stage, as part of other data cleaning; and then  
replicate the data to treebase-dev and try the tests again.

--VG 

Re: [Treebase-devel] new unit test failure

[Vladimir G. <vla...@du...>]

On Mar 5, 2010, at 10:22 AM, youjun guo wrote:

> Dear All,
>
> There is a new treebase unit test failure appeared recently. It due  
> to "submissions do not have a related submitter".
>
> Following query result from the treebase-db may give you a  better  
> idea:
>
> select count(*) from submission where user_id is null : 2044
>

There should be no submission.user_id  nulls in treebasedev,  as of  
today.
--vg