×î½üÒ»¸öºÜÌÖÑáµÄÎÊÌâ,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µÄʱ¼ä²»¹Ì¶¨,ÓÐʱ¸ÕÆô¶¯×Ô¼ºÐ´µÄ³ÌÐò¾ÍÓÐ,ÓÐʱһÌìÒ»´Î,ÓÐʱ¼¸ÌìÒ»´Î;
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......