php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #79539 mysqli_insert_packet_overflow.phpt spuriously fails on Appveyor CI
Submitted: 2020-04-29 12:34 UTC Modified: 2020-05-02 12:57 UTC
From: lear at ofcourseimright dot com Assigned: cmb (profile)
Status: Closed Package: MySQLi related
PHP Version: master-Git-2020-04-29 (Git) OS: Windows
Private report: No CVE-ID: None
 [2020-04-29 12:34 UTC] lear at ofcourseimright dot com
Description:
------------
CI testing for mysqli_insert_packet_overflow.phpt is failing because the test table exists, meaning it is not being properly dropped by another test.  This can occur if a test is not skipped but php exits abnormally on an XFAIL.


Test script:
---------------
See mysqli_insert_packet_overflow.phpt


Expected result:
----------------
Never see a CI warning about table existing.

Actual result:
--------------
001+ [012] [1050] Table 'test' already exists
001- done!
002+ [013] max_allowed_packet = 67108864, strlen(query) = 16777214, [1054] Unknown column 'col_blob' in 'field list'
003+ [014] [1054] Unknown column 'col_blob' in 'field list'
004+ 
005+ Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($mysql_result) must be of type mysqli_result, bool given in C:\projects\php-src\ext\mysqli\tests\mysqli_insert_packet_overflow.php:70
006+ Stack trace:
007+ #0 C:\projects\php-src\ext\mysqli\tests\mysqli_insert_packet_overflow.php(70): mysqli_fetch_assoc(false)
008+ #1 {main}
009+   thrown in C:\projects\php-src\ext\mysqli\tests\mysqli_insert_packet_overflow.php on line 70

Patches

Drop_Test_Table_first (last revision 2020-04-29 12:34 UTC by lear at ofcourseimright dot com)

Add a Patch

Pull Requests

Pull requests:

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2020-04-29 14:05 UTC] lear at ofcourseimright dot com
The following pull request has been associated:

Patch Name: Fix #79539: during CI, drop table if it exists
On GitHub:  https://github.com/php/php-src/pull/5493
Patch:      https://github.com/php/php-src/pull/5493.patch
 [2020-04-29 14:18 UTC] cmb@php.net
-Status: Open +Status: Verified -Assigned To: +Assigned To: cmb
 [2020-04-29 14:18 UTC] cmb@php.net
We're already working on that (see the discussion in PR 5447[1]).

[1] <https://github.com/php/php-src/pull/5447>
 [2020-05-02 12:57 UTC] cmb@php.net
-Status: Verified +Status: Closed
 [2020-05-02 12:57 UTC] cmb@php.net
The issue has been fixed with commit 9a98569[1].

[1] <http://git.php.net/?p=php-src.git;a=commit;h=9a98569efea4e02ee2e52b168610da8f7a3e9a0c>
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 26 11:01:31 2024 UTC