Forum OpenACS Q&A: Re: Problems with subsite creation after upgrade

The upgrade was from 4.6.1. Here's the entire subsite::after_mount log snippet (creation time). I looks like parent_subsite_query is the problem query at both creation and deletion time (I can unmount the instance fine, I just can't delete it). The transaction in subsite::after_mount bombs at that point.

[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: Invoking callback after-mount with command subsite::after_mount  -package_id 5034 -node_id 4904
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Debug: PLPGSQL: bypassed anon function
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: dbinit: sql(localhost::dev): '
            select application_group__group_id_from_package_id (
                '5034',
                't'
            )
      '
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: dbinit: sql(localhost::dev): '
            select instance_name
            from apm_packages
            where package_id = '5034'
      '
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Debug: PLPGSQL: bypassed anon function
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: dbinit: sql(localhost::dev): '
                select application_group__new (
                    NULL,
                    'application_group',
                    now(),
                    '2610',
                    '172.17.1.105',
                    NULL,
                    NULL,
                    'Untitled Parties',
                    '5034',
                    '5034'
                )
      '
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Debug: PLPGSQL: bypassed anon function

[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: dbinit: sql(localhost::dev): '
        select rel_segment__new(
                null,
                'rel_segment',
                now(),
                '2610',
                '172.17.1.105',
                null,
                null,
                'Untitled Members',
                '5068',
                'membership_rel',
                NULL
)
      '
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: dbinit: sql(localhost::dev): '
         select m.group_id as supersite_group_id, p.instance_name as supersite_name
         from application_groups m, apm_packages p, site_nodes s1, site_nodes s2
         where s1.node_id = '4904'
           and s2.node_id = s1.parent_id
           and p.package_id = s2.object_id
           and m.package_id = s2.object_id
      '
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: Querying 'abort transaction;'
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: Ns_PgExec: Rolling back transaction
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: dbinit: sql(localhost::dev): 'abort transaction'
[14/Jun/2003:20:38:31][20975.1091988784][-conn:dev::3] Notice: Querying 'begin transaction;'

If I walk through the process in nscp, I can create the application group and rel_segment but the query above always returns nothing. This would seem to indicate there is either no supersite group or the query is not working as expected, no?