|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2018-01-11 09:24 UTC] terrywongvip at qq dot com
Description: ------------ --- From manual page: http://www.php.net/book.pdo --- When new a PDO instance with php7.1.13 , it will expose a fatal error , with mesage like "PDOException: Packets out of order" , but when I use php5.6.30 or php7.20 , it works and return a resource . Test script: --------------- --- code --- $dbh = new PDO("mysql:host=127.0.0.1;port=3306;dbname=test","demo","demo"); var_dump($dbh); --- error message --- PHP Fatal error: Uncaught PDOException: Packets out of order. Expected 3 received 2. Packet size=22 in /data1/www/xxx/admin/protected/test1.php:3 Stack trace: #0 /data1/www/xxx/admin/protected/test1.php(3): PDO->__construct('mysql:host=10.1...', 'demo', 'demo') #1 {main} Next PDOException: SQLSTATE[HY000] [2006] MySQL server has gone away in /data1/www/xxx/admin/protected/test1.php:3 Actual result: -------------- --- backtrace --- #0 php_error_docref0 (docref=0x0, type=2, format=0xdd975e "%s") at /data1/download/php-7.1.13/main/main.c:970 #1 0x00000000007a4824 in mysqlnd_read_packet_header_and_body (packet_header=0x7ffff4278300, pfc=0x7ffff4270040, vio=0x7ffff4202120, stats=<value optimized out>, error_info=0x7ffff426b120, connection_state=0x7ffff426b348, buf=0x7ffff4277000 "\270q'\364\377\177", buf_size=4095, packet_type_as_text=0x8d0cb2 "OK", packet_type=PROT_OK_PACKET) at /data1/download/php-7.1.13/ext/mysqlnd/mysqlnd_wireprotocol.c:310 #2 0x00000000007a66e5 in php_mysqlnd_auth_response_read (_packet=0x7ffff4278300) at /data1/download/php-7.1.13/ext/mysqlnd/mysqlnd_wireprotocol.c:678 #3 0x00000000007ab1f7 in mysqlnd_auth_handshake (conn=0x7ffff426b000, user=<value optimized out>, passwd=<value optimized out>, passwd_len=<value optimized out>, db=0x7ffff4272028 "test", db_len=4, session_options=0x7ffff426b378, mysql_flags=762509, server_charset_no=8, use_full_blown_auth_packet=1 '\001', auth_protocol=0x7ffff4201440 "mysql_native_password", auth_plugin_data=0x1337fe0 "\252h\aL\350b\031缸\301\326t\374\372M\366\066d\211", auth_plugin_data_len=20, switch_to_auth_protocol=0x7fffffffa408, switch_to_auth_protocol_len=0x7fffffffa400, switch_to_auth_protocol_data=0x7fffffffa3f8, switch_to_auth_protocol_data_len=0x7fffffffa3f0) at /data1/download/php-7.1.13/ext/mysqlnd/mysqlnd_auth.c:314 #4 0x00000000007ab732 in mysqlnd_run_authentication (conn=0x7ffff426b000, user=0x7ffff4272010 "demo", passwd=0x7ffff4272018 "demo", passwd_len=4, db=0x7ffff4272028 "test", db_len=4, auth_plugin_data=..., auth_protocol=0x0, charset_no=8, session_options=0x7ffff426b378, mysql_flags=762509, silent=0 '\000', is_change_user=0 '\000') at /data1/download/php-7.1.13/ext/mysqlnd/mysqlnd_auth.c:119 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 08:00:01 2025 UTC |
Hi, i have the same probleme on Php 8.0.0-dev with PDO : new PDO('mysql:host='.$dsn['hostspec'].';dbname='. $dsn['database'],$dsn['username'],$dsn['password']) give error : Uncaught PDOException: Packets out of order. Expected 3 received 2. Packet size=22 with mysqli_connect : mysqli_connect($dsn['hostspec'],$dsn['username'],$dsn['password'], $dsn['database'],$dsn['port'],$dsn['socket']); give error : Packets out of order. Expected 3 received 2. Packet size=22 ++