php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: lear at ofcourseimright dot com
New email:
PHP Version: OS:

 

 [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)

Pull Requests

Pull requests:

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-2025 The PHP Group
All rights reserved. 		Last updated: Fri Jul 04 14:01:35 2025 UTC