Grouper Developers Forum

[Chris Hyzer <>]

> 
>     The instructions say to "carefully review" the script.  It is 3000
> lines long.

OK, we should take out "carefully"... when you get to the parts about 
comments and views you can skim it.  :)


>     The instructions say, "The script shouldn't be dropping or
> truncating any tables."
> 
>     # grep -i 'drop table'
> ddlScripts/grouperDdl_20091116_11_01_09_603.sql
>        DROP TABLE grouper_groups CASCADE;
>        DROP TABLE grouper_groups_ CASCADE;
>        DROP TABLE grouper_memberships CASCADE;
>        DROP TABLE grouper_memberships_ CASCADE;
>        DROP TABLE grouper_groups CASCADE;
>        DROP TABLE grouper_groups_ CASCADE;
>     so it appears some tables are dropped.

You had the latest grouper code with "ant dist", right?  Can you send me the 
sql script mentioned above?  I hope you had a backup of your tables


> 
> 2) # bin/gsh.sh -registry -runsqlfile
> ddlScripts/grouperDdl_20091116_11_01_09_603.sql
> 
>     Hit a bunch of errors, all the same kind, like this:
> 
>     Error running script: constraint "fk_attributes_field_id" for
> relation "grouper_attributes" already exists
>     ...
> 
>     Postgres automatically creates constraints on many key generations.

Hmmm, I didn't get that when I upgraded my quickstart I believe...


> 
> 3) Manually ran the sql script into postgres and ignored the 'already
> exists' errors;
> 
> 4) ran in gsh: AddMissingGroupSets().addAllMissingGroupSets()
> 
> 5) # ./bin/gsh.sh -registry -deep
> 
>     ditto the 'already exists' errors.  Manually fed to sql into
> postgres.
> 
> ----------------------
> 
> At this point the 1.5 database seems OK.  However,
> 
> If I create a root session and do a query for groups by member
> (GroupMemberFilter) I get back the list of groups immediately.
> 
> If I create a user session and do a query for groups by member
> I get back the list of groups in twenty seconds!
> 
> Is this expected?  Or am I missing an index somewhere?
> 

I don't know how to query the information_schema for indexes (does anyone?) 
but when you browse the tables (e.g. in pgadmin) do you see 14 indexes on 
grouper_group_set, 11 indexes on grouper_groups, and 20 indexes on 
grouper_memberships?

Thanks,
Chris