Trying to delete a build is erroring out
Posted: Wed Jun 06, 2012 9:56 am
----------------------
For a Project, we manually created few builds and ran regression against those build-ids. When we tried to delete few builds which are manually created, one of the builds deletion failed with the following error message:
*************************************************************************************************************
DB Access Error - debug_print_backtrace() OUTPUT START
#0 database->exec_query( DELETE FROM executions WHERE build_id=11) called at [C:\BitNamiWAPPStack\apache2\htdocs\testlink\lib\functions\testplan.class.php:4489]
#1 build_mgr->delete(11) called at [C:\BitNamiWAPPStack\apache2\htdocs\testlink\lib\plan\buildEdit.php:243]
#2 doDelete(stdClass Object ([notes] => ,[do_action] => do_delete,[build_name] => ,[build_id] => 11,[source_build_id] => 0,[is_active] => 0,[is_open] => 0,[copy_to_all_tplans] => 0,[copy_tester_assignments] => 0,[release_date] => ,[release_date_original] => ,[closed_on_date] => ,[tplan_id] => 249,[tplan_name] => sync_reg_test,[testprojectID] => 26,[testprojectName] => Sync,[userID] => 10), build_mgr Object ([db] => database Object ([db] => ADODB_postgres7 Object ([databaseType] => postgres7,[hasLimit] => 1,[ansiOuter] => 1,[charSet] => 1,[dataProvider] => postgres,[hasInsertID] => 1,[_resultid] => Resource id #69,[concat_operator] => ||,[metaDatabasesSQL] => select datname from pg_database where datname not in ('template0','template1') order by 1,[metaTablesSQL] => select tablename,'T' from pg_tables where tablename not like 'pg\_%'
and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
union
select viewname,'V' from pg_views where viewname not like 'pg\_%',[isoDates] => 1,[sysDate] => CURRENT_DATE,[sysTimeStamp] => CURRENT_TIMESTAMP,[blobEncodeType] => C,[metaColumnsSQL] => SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
FROM pg_class c, pg_attribute a,pg_type t
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaColumnsSQL1] => SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
and c.relnamespace=n.oid and n.nspname='%s'
and a.attname not like '....%%' AND a.attnum > 0
AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaKeySQL] => SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key
FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s',[hasAffectedRows] => 1,[true] => TRUE,[false] => FALSE,[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasMoveFirst] => 1,[hasGenID] => 1,[_genIDSQL] => SELECT NEXTVAL('%s'),[_genSeqSQL] => CREATE SEQUENCE %s START %s,[_dropSeqSQL] => DROP SEQUENCE %s,[metaDefaultsSQL] => SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum,[random] => random(),[autoRollback] => 1,[uniqueIisR] => 1,[_bindInputArray] => 1,[disableBlobs] => ,[database] => testlink,[host] => localhost,[user] => testlink,[password] => yu4pang,[debug] => ,[maxblobsize] => 262144,[substr] => substr,[length] => length,[upperCase] => upper,[replaceQuote] => \',[nameQuote] => ",[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[poorAffectedRows] => ,[fnExecute] => ,[fnCacheExecute] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #42,[_errorMsg] => ,[_errorCode] => ,[_queryID] => Resource id #70,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[version] => Array ([description] => PostgreSQL 9.1.1, compiled by Visual C++ build 1500, 32-bit,[version] => 9.1.1),[pgVersion] => 9.1,[_nestedSQL] => 1),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 15,[overallDuration] => 0.3792,[dbType] => postgres,[] => 0,[] => 0),[] => 4fcf260a49fe4293186537,[] => ,[] => ,[] => ,[] => Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[executions] => executions,[inventory] => inventory,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_suites] => req_suites,[requirements] => requirements,[req_versions] => req_versions,[req_revisions] => req_revisions,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users))) called at [C:\BitNamiWAPPStack\apache2\htdocs\testlink\lib\plan\buildEdit.php:67]
************************************************************************************************************************
Can anyone please let us know the reason behind this failure.
Thanks
----------------------
For a Project, we manually created few builds and ran regression against those build-ids. When we tried to delete few builds which are manually created, one of the builds deletion failed with the following error message:
*************************************************************************************************************
DB Access Error - debug_print_backtrace() OUTPUT START
#0 database->exec_query( DELETE FROM executions WHERE build_id=11) called at [C:\BitNamiWAPPStack\apache2\htdocs\testlink\lib\functions\testplan.class.php:4489]
#1 build_mgr->delete(11) called at [C:\BitNamiWAPPStack\apache2\htdocs\testlink\lib\plan\buildEdit.php:243]
#2 doDelete(stdClass Object ([notes] => ,[do_action] => do_delete,[build_name] => ,[build_id] => 11,[source_build_id] => 0,[is_active] => 0,[is_open] => 0,[copy_to_all_tplans] => 0,[copy_tester_assignments] => 0,[release_date] => ,[release_date_original] => ,[closed_on_date] => ,[tplan_id] => 249,[tplan_name] => sync_reg_test,[testprojectID] => 26,[testprojectName] => Sync,[userID] => 10), build_mgr Object ([db] => database Object ([db] => ADODB_postgres7 Object ([databaseType] => postgres7,[hasLimit] => 1,[ansiOuter] => 1,[charSet] => 1,[dataProvider] => postgres,[hasInsertID] => 1,[_resultid] => Resource id #69,[concat_operator] => ||,[metaDatabasesSQL] => select datname from pg_database where datname not in ('template0','template1') order by 1,[metaTablesSQL] => select tablename,'T' from pg_tables where tablename not like 'pg\_%'
and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
union
select viewname,'V' from pg_views where viewname not like 'pg\_%',[isoDates] => 1,[sysDate] => CURRENT_DATE,[sysTimeStamp] => CURRENT_TIMESTAMP,[blobEncodeType] => C,[metaColumnsSQL] => SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
FROM pg_class c, pg_attribute a,pg_type t
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaColumnsSQL1] => SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
and c.relnamespace=n.oid and n.nspname='%s'
and a.attname not like '....%%' AND a.attnum > 0
AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaKeySQL] => SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key
FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s',[hasAffectedRows] => 1,[true] => TRUE,[false] => FALSE,[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasMoveFirst] => 1,[hasGenID] => 1,[_genIDSQL] => SELECT NEXTVAL('%s'),[_genSeqSQL] => CREATE SEQUENCE %s START %s,[_dropSeqSQL] => DROP SEQUENCE %s,[metaDefaultsSQL] => SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum,[random] => random(),[autoRollback] => 1,[uniqueIisR] => 1,[_bindInputArray] => 1,[disableBlobs] => ,[database] => testlink,[host] => localhost,[user] => testlink,[password] => yu4pang,[debug] => ,[maxblobsize] => 262144,[substr] => substr,[length] => length,[upperCase] => upper,[replaceQuote] => \',[nameQuote] => ",[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[poorAffectedRows] => ,[fnExecute] => ,[fnCacheExecute] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #42,[_errorMsg] => ,[_errorCode] => ,[_queryID] => Resource id #70,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[version] => Array ([description] => PostgreSQL 9.1.1, compiled by Visual C++ build 1500, 32-bit,[version] => 9.1.1),[pgVersion] => 9.1,[_nestedSQL] => 1),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 15,[overallDuration] => 0.3792,[dbType] => postgres,[] => 0,[] => 0),[] => 4fcf260a49fe4293186537,[] => ,[] => ,[] => ,[] => Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[executions] => executions,[inventory] => inventory,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_suites] => req_suites,[requirements] => requirements,[req_versions] => req_versions,[req_revisions] => req_revisions,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users))) called at [C:\BitNamiWAPPStack\apache2\htdocs\testlink\lib\plan\buildEdit.php:67]
************************************************************************************************************************
Can anyone please let us know the reason behind this failure.
Thanks
----------------------