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 back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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 15:01:36 2025 UTC