URGENT - Keep getting errors when trying to access TC specs

[yoshikawa]

Hi,

We've been using TestLink for a while now. Last week, we upgraded from version 1.7.5 to 1.8.3. Everything seemed to work fine, the only issue we had was with the 'Graphs' report (it won't load the images), but that wasn't a top priority for us and our TI guy was in charge of researching that.

So, in the last week, we've been using TL a lot: some of us were executing a TP, others reviewing TC specs and some working with updating/uploading requirements. Yesterday, I created 20 new Test Cases, associated them with requirements and keywords, and added them to a new Test Plan. At the end of the day, I even managed to generate the Word doc ('Generate Test Specification document'). So, everything was OK.

Today, when I try to view the details of any TC (both for the ones I created yesterday and the older ones), I keep getting error messages on the right frame:

ERROR ON exec_query() - database.class.php
1 - Can't create/write to file '/tmp/#sql_80c_0.MYD' (Errcode: 28) - SELECT keyword_id,keywords.keyword,keywords.notes,testcase_id FROM testcase_keywords,keywords WHERE keyword_id = keywords.id AND testcase_id IN (426) ORDER BY keyword ASC

THE MESSAGE :: SQL [19] executed [took 0.0007 secs][all took 0.0159 secs]: SELECT keyword_id,keywords.keyword,keywords.notes,testcase_id FROM testcase_keywords,keywords WHERE keyword_id = keywords.id AND testcase_id IN (426) ORDER BY keyword ASC Query failed: errorcode[1] errormsg:Can't create/write to file '/tmp/#sql_80c_0.MYD' (Errcode: 28)
ERROR ON exec_query() - database.class.php
1 - Can't create/write to file '/tmp/#sql_80c_0.MYD' (Errcode: 28) - SELECT U.login AS updater_login,users.login as author_login, NHB.name,NHB.node_order,NHA.parent_id AS testcase_id, tcversions.*, users.first AS author_first_name, users.last AS author_last_name, U.first AS updater_first_name, U.last AS updater_last_name FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN tcversions ON NHA.id = tcversions.id LEFT OUTER JOIN users ON tcversions.author_id = users.id LEFT OUTER JOIN users U ON tcversions.updater_id = U.id WHERE NHA.parent_id = 426 ORDER BY tcversions.version DESC

THE MESSAGE :: SQL [21] executed [took 0.0008 secs][all took 0.0184 secs]: SELECT U.login AS updater_login,users.login as author_login, NHB.name,NHB.node_order,NHA.parent_id AS testcase_id, tcversions.*, users.first AS author_first_name, users.last AS author_last_name, U.first AS updater_first_name, U.last AS updater_last_name FROM nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id JOIN tcversions ON NHA.id = tcversions.id LEFT OUTER JOIN users ON tcversions.author_id = users.id LEFT OUTER JOIN users U ON tcversions.updater_id = U.id WHERE NHA.parent_id = 426 ORDER BY tcversions.version DESC Query failed: errorcode[1] errormsg:Can't create/write to file '/tmp/#sql_80c_0.MYD' (Errcode: 28)

I keep getting these errors on the specification view, when I try to 'Generate Test Specification document' and also when I click on the links to the TCs in the reports view. NOTE: when I navigate in the specification tree, the details for the suites are OK. It's just when I select a specific TC that I get the error.

After the initial panic, I managed to observe that the results for my older executions seem to be intact (I don't have problems when I generate the reports in 'Test Reports and Metrics' page).

I'm guessing this isn't a TL problem, but something in our environment.

So, does anybody know what is going on here? Has anybody seen this behavior before?

Any help/tips will be much appreciated.

Thanks,

Ana Sousa.

[TurboPT]

Are you running out of drive space?

Check this link about what MySQL says about error code 28:
http://www.mysql.com/news-and-events/ne ... 00249.html

[yoshikawa]

Hi, thanks for the prompt response.

Yep, that did the trick.

Life is back to normal now.

Thanks a lot.