#34623 [Opn]: Segfault when selecting 'longtext' field with pdo/mysql

ID: 34623 User updated by: stewey at ambitious dot ca -Summary: Segfault when selecting 'text' field with pdo/mysql Reported By: stewey at ambitious dot ca Status: Open Bug Type: PDO related Operating System: Mac OS X 10.4.2 PHP Version: 5CVS-2005-09-27 (snap) New Comment: Changing summary to read 'longtext'. Previous Comments: ------------------------------------------------------------------------ [2005-09-28 23:11:46] stewey at ambitious dot ca It's actually a 'longtext'. I'm very sorry for the misinformation. To the obvious question: yes, this makes the difference. If it's 'text', no problem, longtext = segfault. Again, I'm sorry. Yes, I can repro via the CLI. Would you like a backtrace of that? CREATE TABLE article ( articleId int(10) unsigned NOT NULL auto_increment, parentId int(10) unsigned NOT NULL default '0', templateId int(10) unsigned NOT NULL default '0', title varchar(100) NOT NULL default '', subTitle varchar(255) default NULL, text longtext NOT NULL, creationTime timestamp NULL default NULL, modificationTime timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, state enum('Online','Offline') NOT NULL default 'Online', audience enum('Private','Public') NOT NULL default 'Private', childSortOrder enum ('Title','Date','Popularity','Arbitrary') NOT NULL default 'Title', sortWeight int(11) NOT NULL default '0', PRIMARY KEY (articleId), KEY parentId (parentId,templateId), FULLTEXT KEY title (title,subTitle,text) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ------------------------------------------------------------------------ [2005-09-28 22:03:52] tony2001@php.net Can't reproduce. Please show your CREATE TABLE command. Also, are you able to replicate it using PHP CLI ? ------------------------------------------------------------------------ [2005-09-28 17:20:35] stewey at ambitious dot ca $ ./configure --with-apxs2=/usr/local/apache2/bin/apxs -- with-mysql=/usr/local/mysql --enable-pdo --prefix=/usr/ local/php5 --with-xmlrpc --with-pdo-mysql --enable-debug $ make $ make install Hope that helps! ------------------------------------------------------------------------ [2005-09-28 13:03:04] sniper@php.net How did you compile/configure PHP? ------------------------------------------------------------------------ [2005-09-28 00:20:29] stewey at ambitious dot ca Bug has resurfaced. Tested with php5-200509271430. Reproduce code is the same as before. [Tue Sep 27 15:15:31 2005] [notice] child pid 15934 exit signal Segmentation fault (11) Here is the backtrace: (gdb) run -X Starting program: /usr/local/apache2/bin/httpd -X Reading symbols for shared libraries .+++ done Reading symbols for shared libraries .... done Program received signal EXC_BAD_ACCESS, Could not access memory. Reason: KERN_INVALID_ADDRESS at address: 0x7269748d 0x020a1504 in dispatch_param_event (stmt=0x49ac08, event_type=PDO_PARAM_EVT_FETCH_POST) at /Users/stewey/ Desktop/php5-200509271430/ext/pdo/pdo_stmt.c:133 133 if (!stmt->methods->param_hook) { (gdb) bt #0 0x020a1504 in dispatch_param_event (stmt=0x49ac08, event_type=PDO_PARAM_EVT_FETCH_POST) at /Users/stewey/ Desktop/php5-200509271430/ext/pdo/pdo_stmt.c:133 #1 0x020a26b4 in do_fetch_common (stmt=0x49ac08, ori=PDO_FETCH_ORI_NEXT, offset=0, do_bind=1) at /Users/ stewey/Desktop/php5-200509271430/ext/pdo/pdo_stmt.c:542 #2 0x020a36d8 in do_fetch (stmt=0x49ac08, do_bind=1, return_value=0x49fb78, how=PDO_FETCH_ASSOC, ori=PDO_FETCH_ORI_NEXT, offset=0, return_all=0x0) at /Users/ stewey/Desktop/php5-200509271430/ext/pdo/pdo_stmt.c:754 #3 0x020a56e8 in zif_PDOStatement_fetchAll (ht=1, return_value=0x49bba8, return_value_ptr=0x0, this_ptr=0x49a7e8, return_value_used=1) at /Users/stewey/ Desktop/php5-200509271430/ext/pdo/pdo_stmt.c:1348 #4 0x0232daac in zend_do_fcall_common_helper_SPEC (execute_data=0xbfffe578) at /Users/stewey/Desktop/ php5-200509271430/Zend/zend_vm_execute.h:187 #5 0x0232eca4 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0xbfffe578) at /Users/stewey/Desktop/ php5-200509271430/Zend/zend_vm_execute.h:310 #6 0x0232d4e8 in execute (op_array=0x499678) at /Users/ stewey/Desktop/php5-200509271430/Zend/zend_vm_execute.h:88 #7 0x022ed6b0 in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /Users/stewey/Desktop/php5-200509271430/ Zend/zend.c:1087 #8 0x02282420 in php_execute_script (primary_file=0xbfffef44) at /Users/stewey/Desktop/ php5-200509271430/main/main.c:1677 #9 0x023a2840 in php_handler (r=0x18bde50) at /Users/ stewey/Desktop/php5-200509271430/sapi/apache2handler/ sapi_apache2.c:568 #10 0x0003daf4 in ap_run_handler (r=0x18bde50) at config.c: 152 #11 0x0003e0bc in ap_invoke_handler (r=0x18bde50) at config.c:364 #12 0x0001203c in ap_process_request (r=0x18bde50) at http_request.c:249 #13 0x0000cc14 in ap_process_http_connection (c=0x18b7f28) at http_core.c:251 #14 0x00044898 in ap_run_process_connection (c=0x18b7f28) at connection.c:43 #15 0x000298f8 in child_main (child_num_arg=4828168) at prefork.c:610 #16 0x000299dc in make_child (s=0x180ad58, slot=0) at prefork.c:650 #17 0x00029b14 in startup_children (number_to_start=5) at prefork.c:722 #18 0x00029fe0 in ap_mpm_run (_pconf=0x1806418, plog=0x5, s=0x180ad58) at prefork.c:941 #19 0x0002baf4 in main (argc=2, argv=0xbffffb20) at main.c: 618 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/34623 -- Edit this bug report at http://bugs.php.net/?id=34623&edit=1