Page 1 of 1

Connection timing out while creating/editing test cases

Posted: Mon Jan 14, 2013 10:18 pm
by vins_14
I am trying to create/edit a test case that has tables created either in the "Summary" or "Pre conditions" section and when I save the test case, the same fails and a "The connection has timed out" message is displayed on the page.
We had the issue with testlink 1.9 and we upgraded to testlink.1.9.5 and both the versions have the same issue.
We have tried it using different version of the browser (FF 17, Chrome), but it doesn't help.

Here is the URL that timesout: http://<hostname>/testlink/lib/testcases/tcEdit.php

We don't see any errors in the testlink logs.

We have been dealing with this issues for the past 1 month and have tried changing the settings in the php.ini and the my.cnf, but none of the same helped. Has anyone run into this issue? Any suggestions?

regards,
VV

Re: Connection timing out while creating/editing test cases

Posted: Tue Jan 15, 2013 9:55 am
by fman
unfortunately never seen this issue
There is lot of missing info:
how big are this tables ?
are this tables generated using copy & paste from word ?
is you create an empty test case this also happens ?

Re: Connection timing out while creating/editing test cases

Posted: Tue Jan 15, 2013 4:28 pm
by vins_14
Hi,

thanks for the quick response, here are some additional information that was requested:

Table size:
Here are the top 5 tables (based on the row size):
table_name,table_rows,DATA_LENGTH,INDEX_LENGTH,MAX_DATA_LENGTH
events,71603,7947292,2214912,281474976710655
nodes_hierarchy,42945,1433568,1656832,281474976710655
tcsteps,26157,95287504,336896,281474976710655
executions,16930,940764,623616,281474976710655
user_assignments,15053,617173,400384,11540474045136895
cfield_design_values,11793,331892,362496,281474976710655
testplan_tcversions,8966,288052,342016,8725724278030335
tcversions,8957,50221376,121856,281474976710655
transactions,7862,3015276,296960,281474976710655
testcase_keywords,2470,22230,44032,2533274790395903

are this tables generated using copy & paste from word ?
I am able to reproduce the issue using copy/paste from excel and using the table generation functionality that comes with TestLink.

is you create an empty test case this also happens ?
If I create a test case with just test or limited amount of data in those fields, I do not have any issues, the same gets created successfully.

Any help in identifying the cause would be much appreciated.

thanks,
VV

Re: Connection timing out while creating/editing test cases

Posted: Tue Jan 15, 2013 8:56 pm
by fman
do not think I've a solution but the size of TEXT TABLES (not db tables) that you are trying to create on the test case can be in part the reason.
Without anyway to reproduce it is very difficult to find a solution

Re: Connection timing out while creating/editing test cases

Posted: Tue Jan 15, 2013 11:27 pm
by vins_14
Hi,

Narrowed it down to the ampersand character (&) - this is what is causing the issue.
When you create a table and if there are cells with no values, then the same is encoded as "

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>

The "&" is probably causing the same to break.

Here are the steps to reproduce:
- create a new test case
- Add "&" to either the summary or the pre-condition field
- save the test case.

If the test case gets saved, open the test case again and try saving it.
Actual result: The save will fail.

Now, clear the cache and try the same action again, it'll work.

Re: Connection timing out while creating/editing test cases

Posted: Tue Jan 15, 2013 11:49 pm
by vins_14
We upgraded the FCKeditor (2.6.6 to 2.6.9) and that seems to have fixed the issue.