Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0006271TestLinkTest Specificationpublic2014-03-31 09:032016-10-13 14:12
Reportercaptainp 
Assigned Tofman 
PrioritynormalSeveritycrashReproducibilityalways
StatusassignedResolutionopen 
PlatformOSOS Version
Product Version1.9.9 (2013 Q4 - bug fixing) 
Fixed in Version 
Summary0006271: DB Access Error when using large value for estimated execution time
DescriptionExecute steps:
1) Select Test Suite
2) Press Create in Test Case Operations
3) Enter large value in field Estimated exec. duration (min) (E.g. 99999)
3) Press Create button to create the test case => Triggers DB Access Error and corrupts the database (test case added to nodes_hierarchy table only).

Checking the DB table showed that the type for this field is DECIMAL(6,4), so the value does not fit.

History: started with Testlink v1.9.4, which was upgraded to v1.9.9
Steps To ReproduceSee description
Additional InformationLogfile:

[14/Mar/26 10:56:35][ERROR][uljru2939kqfmgfgqdndie84e7][DATABASE]
        ERROR ON exec_query() - database.class.php
1264 - Out of range value for column 'estimated_exec_duration' at row 1 - /* Class:testcase - Method: createVersion */ INSERT INTO tcversions (id,tc_external_id,version,summary,preconditions, author_id,creation_ts,execution_type,importance ,status, estimated_exec_duration ) VALUES(2447,1,1,'

\r\n Execute Batch runner tests 2 nights a week and every weekend

\r\n','
    \r\n
  • \r\n Microscope must be well aligned
  • \r\n
  • \r\n LN2 must be at least 20% for night runs and 70% for weekend runs.
  • \r\n
  • \r\n Sample must be inserted\r\n
      \r\n
    • \r\n Metrocal sample
    • \r\n
    • \r\n Cross grating
    • \r\n
    \r\n
  • \r\n
\r\n

\r\n  

\r\n',8,'2014-03-26 11:56:35', 1,3 ,1,60000 )
THE MESSAGE : /* Class:testcase - Method: createVersion */ INSERT INTO tcversions (id,tc_external_id,version,summary,preconditions, author_id,creation_ts,execution_type,importance ,status, estimated_exec_duration ) VALUES(2447,1,1,'

\r\n Execute Batch runner tests 2 nights a week and every weekend

\r\n','
    \r\n
  • \r\n Microscope must be well aligned
  • \r\n
  • \r\n LN2 must be at least 20% for night runs and 70% for weekend runs.
  • \r\n
  • \r\n Sample must be inserted\r\n
      \r\n
    • \r\n Metrocal sample
    • \r\n
    • \r\n Cross grating
    • \r\n
    \r\n
  • \r\n
\r\n

\r\n  

\r\n',8,'2014-03-26 11:56:35', 1,3 ,1,60000 )
Query failed: errorcode[1264]
    errormsg:Out of range value for column 'estimated_exec_duration' at row 1
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL 5.5
BrowserApache/2.2.19 (Win32)
PHP Version5.4.9
TestCaseID
QA Team - Task Workflow Status
Attached Filesjpg file icon tc_create_db_error.jpg [^] (219,662 bytes) 2014-04-01 07:45


jpg file icon tc_create.jpg [^] (167,780 bytes) 2014-04-01 07:45

- Relationships

-  Notes
(0020649)
fman (administrator)
2014-03-31 20:35
edited on: 2014-03-31 20:35

tested on demo.testlink.org => 999999 => becomes 9999.99 but no crash => unable to reproduce DB MySQL

(0020654)
captainp (reporter)
2014-04-01 07:44

I've just tried it again using an estimated execution duration of '99999'. See attached screenshots and logging:

    [14/Apr/1 07:30:07][ERROR][uv1kmat8ok5hf4nm647hiqnfr5][DATABASE]
        ERROR ON exec_query() - database.class.php
1264 - Out of range value for column 'estimated_exec_duration' at row 1 - /* Class:testcase - Method: createVersion */ INSERT INTO tcversions (id,tc_external_id,version,summary,preconditions, author_id,creation_ts,execution_type,importance ,status, estimated_exec_duration ) VALUES(1740,17,1,'','',2,'2014-04-01 09:30:07', 1,2 ,1,99999 )
THE MESSAGE : /* Class:testcase - Method: createVersion */ INSERT INTO tcversions (id,tc_external_id,version,summary,preconditions, author_id,creation_ts,execution_type,importance ,status, estimated_exec_duration ) VALUES(1740,17,1,'','',2,'2014-04-01 09:30:07', 1,2 ,1,99999 )
Query failed: errorcode[1264]
    errormsg:Out of range value for column 'estimated_exec_duration' at row 1
(0025503)
javerty (reporter)
2016-10-13 14:12

Reproduce in 1.9.14 with postgres

- Issue History
Date Modified Username Field Change
2014-03-31 09:03 captainp New Issue
2014-03-31 20:35 fman Note Added: 0020649
2014-03-31 20:35 fman Note Edited: 0020649 View Revisions
2014-03-31 20:35 fman Assigned To => fman
2014-03-31 20:35 fman Status new => feedback
2014-04-01 07:44 captainp Note Added: 0020654
2014-04-01 07:44 captainp Status feedback => assigned
2014-04-01 07:45 captainp File Added: tc_create_db_error.jpg
2014-04-01 07:45 captainp File Added: tc_create.jpg
2016-10-13 14:12 javerty Note Added: 0025503



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker