DB Access Error with Testlink 1.9 beta4

[sushmajahnavi]

Hi,
Can someone please help me out in resolving the "DBAccess Error" that resulted in failure of updating a new test case to Test Link. Kindly respond as soon as you possible.


==============================================================================
DB Access Error - debug_print_backtrace() OUTPUT START
==============================================================================
#0 database->exec_query(INSERT INTO beta4_events (transaction_id,log_level,description,source,fired_at,object_id,object_type,activity) VALUES (1277,1,'ERROR ON exec_query() - database.class.php 1030 - Got error 134 from storage engine - SELECT * FROM beta4_nodes_hierarchy WHERE parent_id = 3516 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,idTHE MESSAGE : SQL [57] executed [took 0.0022 secs][all took 0.0342 secs]:\n SELECT * FROM beta4_nodes_hierarchy WHERE parent_id = 3516 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,id\nQuery failed: errorcode[1030]\n errormsg:Got error 134 from storage engine ','DATABASE',1277185179,NULL,NULL,NULL)) called at [C:\test\xampp\htdocs\testlink-1.9.beta4\lib\functions\logger.class.php:702]
#1 tlEvent->writeToDB(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink19beta4,[host] => localhost:8306,[user] => root,[password] => root,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #39,[_errorMsg] => Duplicate entry '1859' for key 'PRIMARY',[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink19beta4),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 59,[overallDuration] => 0.0372,[] => 0,[] => 0)) called at [C:\test\xampp\htdocs\testlink-1.9.beta4\lib\functions\logger.class.php:819]
#2 tlDBLogger->writeEvent(tlEvent Object ([logLevel] => 1,[description] => ERROR ON exec_query() - database.class.php 1030 - Got error 134 from storage engine - SELECT * FROM beta4_nodes_hierarchy WHERE parent_id = 3516 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,idTHE MESSAGE : SQL [57] executed [took 0.0022 secs][all took 0.0342 secs]:
SELECT * FROM beta4_nodes_hierarchy WHERE parent_id = 3516 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,id
Query failed: errorcode[1030]
errormsg:Got error 134 from storage engine ,[source] => DATABASE,[timestamp] => 1277185179,[userID] => 1,[sessionID] => qmlbr505go0b6c01vp30vrper2,[transactionID] => 1277,[activityCode] => ,[objectID] => ,[objectType] => ,[transaction] => ,[] => ,[dbID] => ,[] => 4294967295,[] => ,[] => ,[] => ,[] => Array ([assignment_status] => beta4_assignment_status,[assignment_types] => beta4_assignment_types,[attachments] => beta4_attachments,[builds] => beta4_builds,[cfield_design_values] => beta4_cfield_design_values,[cfield_execution_values] => beta4_cfield_execution_values,[cfield_node_types] => beta4_cfield_node_types,[cfield_testplan_design_values] => beta4_cfield_testplan_design_values,[cfield_testprojects] => beta4_cfield_testprojects,[custom_fields] => beta4_custom_fields,[db_version] => beta4_db_version,[events] => beta4_events,[execution_bugs] => beta4_execution_bugs,[executions] => beta4_executions,[inventory] => beta4_inventory,[keywords] => beta4_keywords,[milestones] => beta4_milestones,[node_types] => beta4_node_types,[nodes_hierarchy] => beta4_nodes_hierarchy,[object_keywords] => beta4_object_keywords,[platforms] => beta4_platforms,[req_coverage] => beta4_req_coverage,[req_relations] => beta4_req_relations,[req_specs] => beta4_req_specs,[req_suites] => beta4_req_suites,[requirements] => beta4_requirements,[req_versions] => beta4_req_versions,[rights] => beta4_rights,[risk_assignments] => beta4_risk_assignments,[role_rights] => beta4_role_rights,[roles] => beta4_roles,[tcversions] => beta4_tcversions,[tcsteps] => beta4_tcsteps,[testcase_keywords] => beta4_testcase_keywords,[testplan_platforms] => beta4_testplan_platforms,[testplan_tcversions] => beta4_testplan_tcversions,[testplans] => beta4_testplans,[testprojects] => beta4_testprojects,[testsuites] => beta4_testsuites,[text_templates] => beta4_text_templates,[transactions] => beta4_transactions,[user_assignments] => beta4_user_assignments,[user_group] => beta4_user_group,[user_group_assign] => beta4_user_group_assign,[user_testplan_roles] => beta4_user_testplan_roles,[user_testproject_roles] => beta4_user_testproject_roles,[users] => beta4_users))) called at [C:\test\xampp\htdocs\testlink-1.9.beta4\lib\functions\logger.class.php:419]
#3 tlTransaction->writeEvent(tlEvent Object ([logLevel] => 1,[description] => ERROR ON exec_query() - database.class.php 1030 - Got error 134 from storage engine - SELECT * FROM beta4_nodes_hierarchy WHERE parent_id = 3516 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,idTHE MESSAGE : SQL [57] executed [took 0.0022 secs][all took 0.0342 secs]:
SELECT * FROM beta4_nodes_hierarchy WHERE parent_id = 3516 AND node_type_id NOT IN (5,6,7) ORDER BY node_order,id
Query failed: errorcode[1030]
errormsg:Got error 134 from storage engine ,[source] => DATABASE,[timestamp] => 1277185179,[userID] => 1,[sessionID] => qmlbr505go0b6c01vp30vrper2,[transactionID] => 1277,[activityCode] => ,[objectID] => ,[objectType] => ,[transaction] => ,[] => ,[dbID] => ,[] => 4294967295,[] => ,[] => ,[] => ,[] => Array ([assignment_status] => beta4_assignment_status,[assignment_types] => beta4_assignment_types,[attachments] => beta4_attachments,[builds] => beta4_builds,[cfield_design_values] => beta4_cfield_design_values,[cfield_execution_values] => beta4_cfield_execution_values,[cfield_node_types] => beta4_cfield_node_types,[cfield_testplan_design_values] => beta4_cfield_testplan_design_values,[cfield_testprojects] => beta4_cfield_testprojects,[custom_fields] => beta4_custom_fields,[db_version] => beta4_db_version,[events] => beta4_events,[execution_bugs] => beta4_execution_bugs,[executions] => beta4_executions,[inventory] => beta4_inventory,[keywords] => beta4_keywords,[milestones] => beta4_milestones,[node_types] => beta4_node_types,[nodes_hierarchy] => beta4_nodes_hierarchy,[object_keywords] => beta4_object_keywords,[platforms] => beta4_platforms,[req_coverage] => beta4_req_coverage,[req_relations] => beta4_req_relations,[req_specs] => beta4_req_specs,[req_suites] => beta4_req_suites,[requirements] => beta4_requirements,[req_versions] => beta4_req_versions,[rights] => beta4_rights,[risk_assignments] => beta4_risk_assignments,[role_rights] => beta4_role_rights,[roles] => beta4_roles,[tcversions] => beta4_tcversions,[tcsteps] => beta4_tcsteps,[testcase_keywords] => beta4_testcase_keywords,[testplan_platforms] => beta4_testplan_platforms,[testplan_tcversions] => beta4_testplan_tcversions,[testplans] => beta4_testplans,[testprojects] => beta4_testprojects,[testsuites] => beta4_testsuites,[text_templates] => beta4_text_templates,[transactions] => beta4_transactions,[user_assignments] => beta4_user_assignments,[user_group] => beta4_user_group,[user_group_assign] => beta4_user_group_assign,[user_testplan_roles] => beta4_user_testplan_roles,[user_testproject_roles] => beta4_user_testproject_roles,[users] => beta4_users))) called at [C:\test\xampp\htdocs\testlink-1.9.beta4\lib\functions\logger.class.php:348]

Fatal error: Call to a member function MoveNext() on a non-object in C:\test\xampp\htdocs\testlink-1.9.beta4\lib\functions\database.class.php on line 224


Regards,
Sushma.

[ajardine]

Hi

I saw you raised this issue in June last year. I reviewed the same error message, can you please what you did to fix it?

Regards

Armien

[todnih]

Hey,

Is this problem solved now? If yes how can you possibly get this error out? I really need your help on this one and i can't find any solution on google that works. I'm looking forward for your response.

Regards,

todnih