Bug #74946 [Fbk->Opn]: Adding BOOLEAN field to table crashes php on select

Edit report at https://bugs.php.net/bug.php?id=74946&edit=1 ID: 74946 User updated by: rudi dot feijo at multidadosti dot com dot br Reported by: rudi dot feijo at multidadosti dot com dot br Summary: Adding BOOLEAN field to table crashes php on select -Status: Feedback +Status: Open Type: Bug Package: InterBase related Operating System: win2012 R2 PHP Version: 7.1.7 Block user comment: N Private report: N New Comment: backtrace Loading control script C:\Program Files\DebugDiag\scripts\CrashRule_Process_php-cgi.exe.vbs DumpPath set to C:\Program Files\DebugDiag\Logs\Crash rule for all instances of php-cgi.exe [7/18/2017 5:46:08 PM] Process created. BaseModule - C:\webserver\php-7.1.7\php-cgi.exe. BaseThread - System ID: 10572 C:\WINDOWS\SYSTEM32\ntdll.dll loaded at 0xf8730000 Thread created. New thread - System ID: 12360 C:\WINDOWS\system32\KERNEL32.DLL loaded at 0xf5e60000 C:\Program Files (x86)\AVG\Antivirus\x64\aswhooka.dll loaded at 0xd2c10000 C:\WINDOWS\system32\KERNELBASE.dll loaded at 0xf5920000 C:\webserver\php-7.1.7\php7.dll loaded at 0xb6670000 C:\WINDOWS\system32\WS2_32.dll loaded at 0xf8330000 C:\WINDOWS\system32\ADVAPI32.dll loaded at 0xf7f50000 C:\WINDOWS\SYSTEM32\VCRUNTIME140.dll loaded at 0xde390000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-stdio-l1-1-0.dll loaded at 0xeb4d0000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-heap-l1-1-0.dll loaded at 0xeaf90000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-string-l1-1-0.dll loaded at 0xde5d0000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-runtime-l1-1-0.dll loaded at 0xde380000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-convert-l1-1-0.dll loaded at 0xde370000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-environment-l1-1-0.dll loaded at 0xde2d0000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-filesystem-l1-1-0.dll loaded at 0xdca90000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-math-l1-1-0.dll loaded at 0xdb810000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-locale-l1-1-0.dll loaded at 0xd8bf0000 C:\WINDOWS\system32\ole32.dll loaded at 0xf7b10000 C:\WINDOWS\system32\USER32.dll loaded at 0xf62a0000 C:\WINDOWS\SYSTEM32\DNSAPI.dll loaded at 0xf4ed0000 C:\WINDOWS\system32\PSAPI.DLL loaded at 0xf6290000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-time-l1-1-0.dll loaded at 0xd5d60000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-utility-l1-1-0.dll loaded at 0xd5570000 C:\WINDOWS\system32\NSI.dll loaded at 0xf8320000 C:\WINDOWS\system32\RPCRT4.dll loaded at 0xf84e0000 C:\WINDOWS\system32\msvcrt.dll loaded at 0xf5db0000 C:\WINDOWS\SYSTEM32\sechost.dll loaded at 0xf6010000 C:\WINDOWS\SYSTEM32\combase.dll loaded at 0xf6070000 C:\WINDOWS\system32\GDI32.dll loaded at 0xf8390000 C:\WINDOWS\system32\SspiCli.dll loaded at 0xf5a40000 C:\WINDOWS\SYSTEM32\ucrtbase.DLL loaded at 0xd40b0000 C:\Program Files\Diebold\Warsaw\wslbscr64.dll loaded at 0xb86c0000 C:\WINDOWS\SYSTEM32\ntmarta.dll loaded at 0xf0740000 C:\Program Files\Diebold\Warsaw\wslbscrwh64.dll loaded at 0xb8470000 c:\webserver\php-7.1.7\ext\php_opcache.dll loaded at 0xcf5c0000 c:\webserver\php-7.1.7\ext\php_com_dotnet.dll loaded at 0xd37a0000 C:\WINDOWS\system32\OLEAUT32.dll loaded at 0x6d550000 c:\webserver\php-7.1.7\ext\php_bz2.dll loaded at 0xcf490000 c:\webserver\php-7.1.7\ext\php_curl.dll loaded at 0xc4e70000 C:\webserver\php-7.1.7\libssh2.dll loaded at 0x80000000 C:\webserver\php-7.1.7\nghttp2.dll loaded at 0xcf450000 C:\webserver\php-7.1.7\LIBEAY32.dll loaded at 0xb6430000 C:\webserver\php-7.1.7\SSLEAY32.dll loaded at 0xc0b20000 C:\WINDOWS\system32\WLDAP32.dll loaded at 0xf5fa0000 C:\WINDOWS\system32\Normaliz.dll loaded at 0xf8250000 C:\WINDOWS\system32\CRYPT32.dll loaded at 0x71a00000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-conio-l1-1-0.dll loaded at 0xd4fd0000 C:\WINDOWS\system32\MSASN1.dll loaded at 0xf5900000 c:\webserver\php-7.1.7\ext\php_fileinfo.dll loaded at 0xb6120000 c:\webserver\php-7.1.7\ext\php_gd2.dll loaded at 0xb5f90000 c:\webserver\php-7.1.7\ext\php_intl.dll loaded at 0xb8640000 C:\webserver\php-7.1.7\icuuc57.dll loaded at 0x72690000 C:\webserver\php-7.1.7\icuin57.dll loaded at 0x72490000 C:\webserver\php-7.1.7\icuio57.dll loaded at 0x72470000 C:\WINDOWS\SYSTEM32\MSVCP140.dll loaded at 0xb8580000 C:\webserver\php-7.1.7\icudt57.dll loaded at 0x708f0000 C:\WINDOWS\SYSTEM32\api-ms-win-crt-multibyte-l1-1-0.dll loaded at 0xd3d60000 c:\webserver\php-7.1.7\ext\php_imap.dll loaded at 0xb5ea0000 C:\WINDOWS\SYSTEM32\WINMM.dll loaded at 0xeca60000 C:\WINDOWS\SYSTEM32\Secur32.dll loaded at 0xe0ad0000 C:\WINDOWS\SYSTEM32\WINMMBASE.dll loaded at 0xeca30000 C:\WINDOWS\SYSTEM32\cfgmgr32.dll loaded at 0xf5cb0000 C:\WINDOWS\SYSTEM32\DEVOBJ.dll loaded at 0xf4670000 c:\webserver\php-7.1.7\ext\php_interbase.dll loaded at 0xcf430000 C:\WINDOWS\SYSTEM32\fbclient.dll loaded at 0xb5ce0000 C:\WINDOWS\system32\SHELL32.dll loaded at 0x71c20000 C:\WINDOWS\SYSTEM32\MSVCR100.dll loaded at 0x77a70000 C:\WINDOWS\SYSTEM32\MPR.dll loaded at 0xeb3a0000 C:\WINDOWS\system32\SHLWAPI.dll loaded at 0x73150000 c:\webserver\php-7.1.7\ext\php_ldap.dll loaded at 0xc0ae0000 C:\webserver\php-7.1.7\libsasl.dll loaded at 0xc4e00000 c:\webserver\php-7.1.7\ext\php_mbstring.dll loaded at 0xb5b80000 c:\webserver\php-7.1.7\ext\php_exif.dll loaded at 0xc4720000 c:\webserver\php-7.1.7\ext\php_mysqli.dll loaded at 0xc0790000 c:\webserver\php-7.1.7\ext\php_openssl.dll loaded at 0xc0590000 c:\webserver\php-7.1.7\ext\php_pdo_mysql.dll loaded at 0xd3740000 c:\webserver\php-7.1.7\ext\php_soap.dll loaded at 0xb8530000 c:\webserver\php-7.1.7\ext\php_sockets.dll loaded at 0xc0ac0000 C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL loaded at 0xeee60000 C:\WINDOWS\SYSTEM32\WINNSI.DLL loaded at 0xeee30000 C:\WINDOWS\system32\mswsock.dll loaded at 0xf50d0000 Thread created. New thread - System ID: 364 Initializing control script Clearing any existing breakpoints Current Breakpoint List(BL) Thread exited. Exiting thread - System ID: 364. Exit code - 0x00000000 [7/18/2017 5:46:13 PM] C:\WINDOWS\SYSTEM32\SHCORE.dll loaded at 0xf3df0000 C:\WINDOWS\SYSTEM32\profapi.dll loaded at 0xf5850000 Exception 0XE06D7363 on thread 10572. DetailID = 1 Thread created. New thread - System ID: 568 C:\WINDOWS\SYSTEM32\CRYPTSP.dll loaded at 0xf5150000 C:\WINDOWS\system32\rsaenh.dll loaded at 0xf4ce0000 C:\WINDOWS\SYSTEM32\bcrypt.dll loaded at 0xf53a0000 C:\WINDOWS\SYSTEM32\CRYPTBASE.dll loaded at 0xf5720000 C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll loaded at 0xf56b0000 C:\WINDOWS\system32\napinsp.dll loaded at 0xeaeb0000 C:\WINDOWS\system32\pnrpnsp.dll loaded at 0xeae60000 C:\WINDOWS\system32\NLAapi.dll loaded at 0xf0480000 C:\WINDOWS\System32\winrnr.dll loaded at 0xeaa00000 C:\WINDOWS\system32\wshbth.dll loaded at 0xea9e0000 C:\Program Files\Bonjour\mdnsNSP.dll loaded at 0x76000000 C:\Windows\System32\rasadhlp.dll loaded at 0xe48e0000 C:\WINDOWS\System32\fwpuclnt.dll loaded at 0xee9a0000 C:\WINDOWS\SYSTEM32\kernel.appcore.dll loaded at 0xf46c0000 Thread exited. Exiting thread - System ID: 568. Exit code - 0x00000001 Thread exited. Exiting thread - System ID: 12360. Exit code - 0x00000001 Process exited. Exit code - 0x00000001 *********************** * EXCEPTION DETAILS * *********************** DetailID = 1 Count: 1 Exception #: 0XE06D7363 Stack: KERNELBASE!RaiseException+0x6c MSVCR100!CxxThrowException+0x81 fbclient!fb_shutdown+0xce4f fbclient!fb_shutdown+0x861c fbclient!fb_shutdown+0x2b726 fbclient!fb_shutdown+0x2ee26 fbclient!fb_shutdown+0xb707 fbclient!fb_shutdown+0xb86d fbclient!fb_shutdown+0xb8e0 fbclient!fb_shutdown+0x32d66 fbclient!isc_start_transaction+0x1125 fbclient!isc_start_transaction+0x1e5e fbclient!isc_attach_database+0x3ab php_interbase!_php_ibase_connect+0x5d9 [c:\php-sdk\php71\vc14\x64\php-7.1.7\ext\interbase\interbase.c @ 982] php7!execute_ex+0x157 [c:\php-sdk\php71\vc14\x64\php-7.1.7\zend\zend_vm_execute.h @ 432] php7!zend_execute+0x159 [c:\php-sdk\php71\vc14\x64\php-7.1.7\zend\zend_vm_execute.h @ 475] php7!zend_execute_scripts+0x119 [c:\php-sdk\php71\vc14\x64\php-7.1.7\zend\zend.c @ 1477] php7!php_execute_script+0x424 [c:\php-sdk\php71\vc14\x64\php-7.1.7\main\main.c @ 2537] php_cgi!main+0x1727 [c:\php-sdk\php71\vc14\x64\php-7.1.7\sapi\cgi\cgi_main.c @ 2654] php_cgi!__scrt_common_main_seh+0x11d [f:\dd\vctools\crt\vcstartup\src\startup\exe_common.inl @ 253] KERNEL32!BaseThreadInitThunk+0x22 ntdll!RtlUserThreadStart+0x34 *********************** * EXCEPTION SUMMARY * *********************** |--------------------| | Count | Exception | |--------------------| | 1 | 0XE06D7363 | |--------------------| Debugging Overhead Cost: Total Elapsed Ticks = 5390 (100%) Total Ticks Spent in Debugger Engine = 62 (1%) Total Ticks Spent in Crash Rule Script = 187 (3%) Previous Comments: ------------------------------------------------------------------------ [2017-07-18 20:18:04] requinix@php.net Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. ------------------------------------------------------------------------ [2017-07-18 20:16:22] rudi dot feijo at multidadosti dot com dot br Firebird version 3.0.2 64bit windows PHP version is also 64bit Crash happens on any environment, command line php or webserver ------------------------------------------------------------------------ [2017-07-18 20:13:54] rudi dot feijo at multidadosti dot com dot br Description: ------------ Adding a BOOLEAN field to a table, then trying any SELECT from that table crashes the server Test script: --------------- <?php /* sql for db : CREATE DATABASE 'c:\test.fdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 16384 DEFAULT CHARACTER SET WIN1252 COLLATION WIN1252; CREATE TABLE ASD ( AA INTEGER ); ALTER TABLE ASD ADD NEW_FIELD BOOLEAN; */ $c = ibase_connect('localhost:C:\\test.fdb','SYSDBA','masterkey'); $q = ibase_query('select * from asd'); $r = ibase_fetch_assoc($q); echo ibase_errmsg(); echo array_keys($r)[0]; Actual result: -------------- php crash (error 500) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=74946&edit=1