Bug 113585
Summary: | Persistence error creating an Article type after perm denorm land. | ||
---|---|---|---|
Product: | [Retired] Red Hat Enterprise CMS | Reporter: | Jon Orris <jorris> |
Component: | other | Assignee: | Aram Kananov <akananov> |
Status: | CLOSED RAWHIDE | QA Contact: | Jon Orris <jorris> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | nightly | ||
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2004-01-26 21:56:43 UTC | Type: | --- |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Jon Orris
2004-01-15 16:23:44 UTC
To clarify, this isn't creating an article. This is authoring an article and adding Body Text. Developer support sql log: -- ID: #1 -- Duration: 1ms select u.user_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, p.primary_email as c_5, p.uri as c_6, u.screen_name as c_7 from users u join acs_objects ao on ao.object_id = u.user_id join parties p on p.party_id = u.user_id where u.user_id = '2003'; -- ID: #2 -- Duration: 3ms select a.application_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, a.title as c_5, a.description as c_6, a.timestamp as c_7, a.application_type_id as c_8, resourceType__at_.workspace_application_p as c_9, resourceType__at_.has_full_page_view_p as c_10, resourceType__at_.has_embedded_view_p as c_11, resourceType__at_.singleton_p as c_12, resourceType__at_.title as c_13, a.parent_application_id as c_14, parentResource__ao.object_type as c_15, parentResource__ao.default_domain_class as c_16, parentResource__a.title as c_17, a.primary_url as c_18 from applications a join acs_objects ao on ao.object_id = a.application_id join application_types resourceType__at_ on resourceType__at_.application_type_id = a.application_type_id left join acs_objects parentResource__ao on parentResource__ao.object_id = a.parent_application_id left join applications parentResource__a on parentResource__a.application_id = a.parent_application_id where (a.primary_url = '/articles/admin/'); -- ID: #3 -- Duration: 3ms select a.application_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, a.title as c_5, a.description as c_6, a.timestamp as c_7, a.application_type_id as c_8, resourceType__at_.workspace_application_p as c_9, resourceType__at_.has_full_page_view_p as c_10, resourceType__at_.has_embedded_view_p as c_11, resourceType__at_.singleton_p as c_12, resourceType__at_.title as c_13, a.parent_application_id as c_14, parentResource__ao.object_type as c_15, parentResource__ao.default_domain_class as c_16, parentResource__a.title as c_17, a.primary_url as c_18 from applications a join acs_objects ao on ao.object_id = a.application_id join application_types resourceType__at_ on resourceType__at_.application_type_id = a.application_type_id left join acs_objects parentResource__ao on parentResource__ao.object_id = a.parent_application_id left join applications parentResource__a on parentResource__a.application_id = a.parent_application_id where a.application_id = '64'; -- ID: #4 -- Duration: 5ms select cf.folder_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, vo.is_deleted as c_5, ci.version as c_6, ci.name as c_7, ci.language as c_8, ci.ancestors as c_9, cf.label as c_10 from cms_folders cf join acs_objects ao on ao.object_id = cf.folder_id join vc_objects vo on vo.object_id = cf.folder_id join cms_items ci on ci.item_id = cf.folder_id join content_sections start____cs on start____cs.section_id = '64' where start____cs.root_folder_id = cf.folder_id; -- ID: #5 -- Duration: 4ms select ci.item_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, vo.is_deleted as c_5, ci.version as c_6, ci.name as c_7, ci.language as c_8, ci.ancestors as c_9 from cms_items ci join acs_objects ao on ao.object_id = ci.item_id join vc_objects vo on vo.object_id = ci.item_id where ci.master_id = '60' and ci.item_id = ci.item_id and (ci.version = 'live'); -- ID: #6 -- Duration: 3ms select st_.permission_p as c_1 from ( select 1 as permission_p from dual) st_ where ( exists ( select 1 as permission_p from dnm_object_1_granted_context dogc, dnm_granted_context dgc, dnm_permissions dp, dnm_group_membership dgm where dogc.pd_object_id = '64' and dogc.pd_context_id = dgc.pd_object_id and dgc.pd_context_id = dp.pd_object_id and dgm.pd_member_id = '2003' and dp.pd_grantee_id = dgm.pd_group_id and pd_priv_01 = 1 )); -- ID: #7 -- Duration: 2ms select ci.item_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, vo.is_deleted as c_5, ci.version as c_6, ci.name as c_7, ci.language as c_8, ci.ancestors as c_9 from cms_items ci join acs_objects ao on ao.object_id = ci.item_id join vc_objects vo on vo.object_id = ci.item_id where ci.item_id = '2011'; -- ID: #8 -- Duration: 4ms select st_.permission_p as c_1 from ( select 1 as permission_p from dual) st_ where ( exists ( select 1 as permission_p from dnm_object_1_granted_context dogc, dnm_granted_context dgc, dnm_permissions dp, dnm_group_membership dgm where dogc.pd_object_id = '2011' and dogc.pd_context_id = dgc.pd_object_id and dgc.pd_context_id = dp.pd_object_id and dgm.pd_member_id = '2003' and dp.pd_grantee_id = dgm.pd_group_id and pd_priv_11 = 1 )); -- ID: #9 -- Duration: 1ms select st_.object_type as c_1, st_.object_id as c_2, st_.process_def_id as c_3, st_.process_id as c_4 from ( select cw_processes.process_id , acs_objects.object_type , cw_processes.object_id as object_id , cw_processes.process_def_id from cw_processes , acs_objects where cw_processes.object_id = acs_objects.object_id) st_ where (st_.object_id = '2011'); -- ID: #10 -- Duration: 3ms select cp.process_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, ct.label as c_5, ct.description as c_6, ct.is_active as c_7, ct.parent_task_id as c_8, ct.task_state as c_9, cp.process_def_id as c_10, cp.process_state as c_11 from cw_processes cp join acs_objects ao on ao.object_id = cp.process_id join cw_tasks ct on ct.task_id = cp.process_id where cp.process_id = '2013'; -- ID: #11 -- Duration: 1ms select st_.object_id as c_1 from ( select object_id from acs_auditing) st_ where (st_.object_id='2013'); -- ID: #12 -- Duration: 1ms select aa.object_id as c_1, aa.creation_date as c_2, aa.creation_ip as c_3, aa.last_modified as c_4, aa.modifying_ip as c_5 from acs_auditing aa where aa.object_id = '2013'; -- ID: #13 -- Duration: 2ms select ao.object_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4 from acs_objects ao join cw_processes start____cp on start____cp.process_id = '2013' where start____cp.object_id = ao.object_id; -- ID: #14 -- Duration: 2ms select st_.task_id as c_1, st_.due_date as c_2, st_.is_active as c_3, st_.task_state as c_4, st_.user_id as c_5, st_.parent_task_id as c_6, st_.is_locked as c_7, st_.start_date as c_8 from ( select cw_task_user_assignees.user_id , cw_user_tasks.task_id , cw_user_tasks.due_date , cw_user_tasks.start_date , cw_user_tasks.is_locked , cw_tasks.task_state , cw_tasks.is_active , cw_tasks.parent_task_id from cw_task_user_assignees , cw_user_tasks , cw_tasks where cw_user_tasks.task_id = cw_task_user_assignees.task_id and cw_tasks.task_id = cw_user_tasks.task_id) st_ where (st_.user_id = '2003') and (st_.parent_task_id = '2013') and (st_.task_state = 'enabled') and (st_.is_active = '1'); -- ID: #15 -- Duration: 2ms select st_.task_id as c_1, st_.due_date as c_2, st_.is_active as c_3, st_.task_state as c_4, st_.parent_task_id as c_5, st_.group_id as c_6, st_.start_date as c_7 from ( select cw_task_group_assignees.group_id , cw_tasks.task_id , cw_tasks.is_active , cw_tasks.task_state , cw_user_tasks.due_date , cw_user_tasks.start_date , cw_tasks.parent_task_id from cw_task_group_assignees , cw_tasks , cw_user_tasks where cw_task_group_assignees.task_id = cw_tasks.task_id and cw_user_tasks.task_id = cw_tasks.task_id) st_ where (st_.parent_task_id = '2013') and (st_.is_active = '1') and (st_.task_state = 'enabled'); -- ID: #16 -- Duration: 2ms select g_.group_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, p.primary_email as c_5, p.uri as c_6, g_.name as c_7 from groups g_ join acs_objects ao on ao.object_id = g_.group_id join parties p on p.party_id = g_.group_id where g_.group_id = '104'; -- ID: #17 -- Duration: 2ms select count(*) from ( select 1 from ( select member_id from group_member_trans_map where group_id = '104') st_ where (st_.member_id = '2003') ) count__; -- ID: #18 -- Duration: 1ms select ct.task_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, ct.label as c_5, ct.description as c_6, ct.is_active as c_7, ct.parent_task_id as c_8, ct.task_state as c_9 from cw_tasks ct join acs_objects ao on ao.object_id = ct.task_id where ct.task_id = '2016'; -- ID: #19 -- Duration: 1ms select st_.object_id as c_1 from ( select object_id from acs_auditing) st_ where (st_.object_id='2016'); -- ID: #20 -- Duration: 1ms select aa.object_id as c_1, aa.creation_date as c_2, aa.creation_ip as c_3, aa.last_modified as c_4, aa.modifying_ip as c_5 from acs_auditing aa where aa.object_id = '2016'; -- ID: #21 -- Duration: 1ms select ct.task_id as c_1, cut.locking_user_id as c_2, cut.is_locked as c_3, cut.start_date as c_4, cut.due_date as c_5, cut.duration_minutes as c_6, cut.notification_sender_id as c_7 from cms_tasks ct join cw_user_tasks cut on cut.task_id = ct.task_id where '2016' = ct.task_id; -- ID: #22 -- Duration: 19ms select ct.text_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, vo.is_deleted as c_5, ci.version as c_6, ci.name as c_7, ci.language as c_8, ci.ancestors as c_9, ca.description as c_10, ct.content as c_11 from cms_text ct join acs_objects ao on ao.object_id = ct.text_id join vc_objects vo on vo.object_id = ct.text_id join cms_items ci on ci.item_id = ct.text_id join cms_assets ca on ca.asset_id = ct.text_id join cms_text_pages start____ctp on start____ctp.item_id = '2011' where start____ctp.text_id = ct.text_id; -- ID: #23 -- Duration: 1ms select ca.item_id as c_1, cp.title as c_2, cp.launch_date as c_3 from ct_articles ca join cms_pages cp on cp.item_id = ca.item_id where '2011' = ca.item_id; -- ID: #24 -- Duration: 9ms insert into acs_objects (display_name, object_id, default_domain_class, object_type) values ('testarticle_text_2011', '3002', 'com.arsdigita.cms.TextAsset', 'com.arsdigita.cms.TextAsset'); -- ID: #25 -- Duration: 2ms insert into vc_objects (is_deleted, object_id) values ('false', '3002'); -- ID: #26 -- Duration: 33ms insert into cms_items (item_id, ancestors, name, version) values ('3002', '2012/2011/3002/', 'testarticle_text_2011', 'draft'); -- ID: #27 -- Duration: 2ms insert into cms_assets (asset_id) values ('3002'); -- ID: #28 -- Duration: 2ms insert into cms_text (text_id) values ('3002'); -- ID: #29 -- Duration: 1ms update vc_objects set master_id = null where vc_objects.object_id = '3002'; -- ID: #30 -- Duration: 2ms update cms_items set parent_id = '2011' where cms_items.item_id = '3002'; -- ID: #31 -- Duration: 1ms insert into vcx_txns (id, modifying_ip, timestamp) values ('18', '172.16.64.171', 'Thu Jan 15 11:33:44 EST 2004'); -- ID: #32 -- Duration: 1ms update vcx_txns set modifying_user = '2003' where vcx_txns.id = '18'; -- ID: #33 -- Duration: 1ms insert into vcx_obj_changes (obj_id, txn_id, id) values ('com.arsdigita.cms.TextAsset;id:1:3002', '18', '501'); -- ID: #34 -- Duration: 3ms insert into vcx_operations (id, event_type_id, change_id, class_id, subtype, attribute) values ('502', '1', '501', '12', '1', 'com.arsdigita.cms.TextAsset'); -- ID: #35 -- Duration: 7ms insert into vcx_generic_operations (value, id) values ('com.arsdigita.cms.TextAsset;id:1:3002', '502'); -- ID: #36 -- Duration: 1ms update vcx_operations set change_id = '501' where vcx_operations.id = '502'; -- ID: #37 -- Duration: 1ms insert into vcx_obj_changes (obj_id, txn_id, id) values ('com.arsdigita.cms.contenttypes.Article;id:1:2011', '18', '503'); -- ID: #38 -- Duration: 1ms insert into vcx_operations (id, event_type_id, change_id, class_id, subtype, attribute) values ('504', '3', '503', '12', '1', 'contentChildren'); -- ID: #39 -- Duration: 2ms insert into vcx_generic_operations (value, id) values ('com.arsdigita.cms.TextAsset;id:1:3002', '504'); -- ID: #40 -- Duration: 1ms update vcx_operations set change_id = '503' where vcx_operations.id = '504'; -- ID: #41 -- Duration: 2ms select ci.item_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, vo.is_deleted as c_5, ci.version as c_6, ci.name as c_7, ci.language as c_8, ci.ancestors as c_9 from cms_items ci join acs_objects ao on ao.object_id = ci.item_id join vc_objects vo on vo.object_id = ci.item_id where ci.master_id = '2011' and ci.item_id = ci.item_id and (ci.version = 'live'); -- ID: #42 -- Duration: 1ms select ct.type_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, ct.object_type as c_5, ct.label as c_6, ct.description as c_7, ct.classname as c_8, ct.is_internal as c_9, ct.item_form_id as c_10 from content_types ct join acs_objects ao on ao.object_id = ct.type_id where (ct.object_type = 'com.arsdigita.cms.TextAsset'); -- ID: #43 -- Duration: 7ms select cs.section_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, a.title as c_5, a.description as c_6, a.timestamp as c_7, a.application_type_id as c_8, resourceType__at_.workspace_application_p as c_9, resourceType__at_.has_full_page_view_p as c_10, resourceType__at_.has_embedded_view_p as c_11, resourceType__at_.singleton_p as c_12, resourceType__at_.title as c_13, a.parent_application_id as c_14, parentResource__ao.object_type as c_15, parentResource__ao.default_domain_class as c_16, parentResource__a.title as c_17, a.primary_url as c_18, cs.pretty_name as c_19, cs.page_resolver_class as c_20, cs.item_resolver_class as c_21, cs.template_resolver_class as c_22, cs.xml_generator_class as c_23 from content_sections cs join acs_objects ao on ao.object_id = cs.section_id join applications a on a.application_id = cs.section_id join application_types resourceType__at_ on resourceType__at_.application_type_id = a.application_type_id left join acs_objects parentResource__ao on parentResource__ao.object_id = a.parent_application_id left join applications parentResource__a on parentResource__a.application_id = a.parent_application_id join cms_items start____ci on start____ci.item_id = '3002' where start____ci.section_id = cs.section_id; -- ID: #44 -- Duration: 1ms select oc.object_id as c_1 from object_context oc where oc.object_id = '3002'; -- ID: #45 -- Duration: 1ms select ao.object_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4 from acs_objects ao join object_context start____oc on start____oc.object_id = '3002' where start____oc.context_id = ao.object_id; -- ID: #46 -- Duration: 22ms update object_context set context_id = '2011' where object_context.object_id = '3002'; -- ID: #47 -- Duration: 2ms select ci.item_id as c_1, ao.object_type as c_2, ao.display_name as c_3, ao.default_domain_class as c_4, vo.is_deleted as c_5, ci.version as c_6, ci.name as c_7, ci.language as c_8, ci.ancestors as c_9 from cms_items ci join acs_objects ao on ao.object_id = ci.item_id join vc_objects vo on vo.object_id = ci.item_id where ci.master_id = '3002' and ci.item_id = ci.item_id and (ci.version = 'live'); -- ID: #48 -- Duration: 1ms select oc.object_id as c_1 from object_context oc where oc.object_id = '3002'; -- ID: #49 -- Duration: 39ms update object_context set context_id = '2011' where object_context.object_id = '3002'; -- ID: #50 -- Duration: 0ms select pn.name_id as c_1, pn.given_name as c_2, pn.middle_names as c_3, pn.family_name as c_4 from person_names pn join users start____u on start____u.user_id = '2003' where start____u.name_id = pn.name_id; |