×î½üÒ»¸öºÜÌÖÑáµÄÎÊÌâ,mysql×ÜÊÇcoredump,ÐÅÏ¢ÈçÏÂ:
ÿ´ÎÌáʾÐÅÏ¢¶¼²î²»¶àÈçÏÂ:
#0 0xb58897a8 in strcmp () from /lib/libc.so.6
#1 0xb7fcc601 in array_append_string_unique () from/usr/lib/libmysqlclient_r.so.16
#2 0xb7fcebe8 in init_default_directories_unix () from/usr/lib/libmysqlclient_r.so.16
#3 0xb80202f4 in THR_LOCK_heap () from /usr/lib/libmysqlclient_r.so.16
#4 0x00000007 in ?? ()
#5 0xb7ff2354 in ?? () from /usr/lib/libmysqlclient_r.so.16
#6 0x00000200 in ?? ()
#7 0x00000000 in ?? ()
--
¼¸¸öÎʺÅÒ²ÏÔʾ²»³öÀ´¾ßÌåµÄ´úÂëÊÇÔÚÄÄÀï,µ¥²½¸ú×ÙºÜÀ§ÄÑ.
˼û¹ýÀàËÆµÄÎÊÌâ?Çë¸ßÊÖ°ïæ¿´¿´
»¹Óиü¶àµÄÐÅÏ¢ÁËÂð£¬ÕâЩ»¹¿´²»³öÀ´£¬/var/log/Ï¿´Ò»ÏÂmessagesÓÐûÓÐÌáʾ¸ü¶àµÄÐÅÏ¢£¡
°Ñ´íÎóÈÕÖ¾Ò²Êä³öÀ´¿´¿´
´íÎóÈÕÖ¾ÄóöÀ´¿´¿´°Ñ£¬ÕýºÃѧϰһÏÂ
ÔËÐÐconfigure½Å±¾µÄʱºò¼ÓÉÏ --with-debug=fullÑ¡Ïî
´íÎóÈÕÖ¾ÀïÃæÏà¹ØµÄÐÅÏ¢Ö»ÓÐ:
segfault at 0 ip b598f3a8 sp bff969bc error 4 in libc-2.3.6.so[b5927000+116000]
ÆäËüµÄûÓÐÁË.
ÁíÍânetxuning¸çÃÇ˵µÄ'--with-debug=full',¼ÓÉϺó»áÓÐʲôÏÖÏó,»á²»»áÔì³ÉmysqlЧÂÊϽµ?
¿Ï¶¨ÊÇÔâÓö¿ÕÖ¸ÕëÁË,³ÌÐòÀïÃæÓõ½µÄmysqlº¯ÊýÒ²¾ÍÄǼ¸¸ö³£ÓõÄ,Ïñmysql_fetch_row/mysql_real_query/mysql_free_result/mysql_store_result/µÈµÈ.
ÁíÍâmysql_free_resultµÄ´¦ÀíÒ²ÊÇûÓÐÖØ¸´µÄµØ·½.
ʲôº¯Êý»áµ÷ÓÃTHR_LOCK_heap()???
³öÏÖcoredumpµÄʱ¼ä²»¹Ì¶¨,ÓÐʱ¸ÕÆô¶¯×Ô¼ºÐ´µÄ³ÌÐò¾ÍÓÐ,ÓÐʱһÌìÒ»´Î,ÓÐʱ¼¸ÌìÒ»´Î;
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......