linux c mysql 第二次操作崩溃

eveson

看这次debug的信息

1. (gdb) bt
   
2. #0  mysql_send_query (mysql=0x48608048, query=0x47205c60 "INSERT INTO T_Test (ClientFlag,TimeFlag) VALUES(3, 6)", length=53)
   
3.     at /export/home/pb2/build/sb_0-13191046-1410444393.17/rpm/BUILD/mysql-5.6.21/mysql-5.6.21/sql-common/client.c:4166
   
4. #1  0x00000000004111b1 in mysql_real_query (mysql=0x48608048, query=0x47205c60 "INSERT INTO T_Test (ClientFlag,TimeFlag) VALUES(3, 6)", length=53)
   
5.     at /export/home/pb2/build/sb_0-13191046-1410444393.17/rpm/BUILD/mysql-5.6.21/mysql-5.6.21/sql-common/client.c:4180
   
6. #2  0x000000000040eb4a in DBConPool_ExecuteSql (pConHandle=0x48608048, pSql=0x47205c60 "INSERT INTO T_Test (ClientFlag,TimeFlag) VALUES(3, 6)")
   
7.     at ../../DBConnectionPool/src/DBConPool.c:323
   
8. #3  0x0000000000409c9b in InsertDB_For_Test (pDBConn=0x48608048, pTest=0x163f473c) at ../../../Server/src/AccessDB.c:71
   
9. #4  0x0000000000409d8f in Act_Test (pMsg=0x163f4734) at ../../../Server/src/Action.c:67
   
10. #5  0x000000000040a64c in thread_routine (arg=0x166ea774) at ../../ThreadPool/src/ThreadPool.c:255
    
11. #6  0x0000003445a064a7 in start_thread () from /lib64/libpthread.so.0
    
12. #7  0x0000003444ed3c2d in clone () from /lib64/libc.so.6
    
13. (gdb) c
    
14. Continuing.
    
15. poll_wait:: Interrupted system call
    
16. 
    
17. Program received signal SIGSEGV, Segmentation fault.
    
18. 0x000000000041118e in mysql_send_query (mysql=0x48608048, query=0x47205c60 "INSERT INTO T_Test (ClientFlag,TimeFlag) VALUES(3, 6)", length=53)
    
19.     at /export/home/pb2/build/sb_0-13191046-1410444393.17/rpm/BUILD/mysql-5.6.21/mysql-5.6.21/sql-common/client.c:4168
    
20. 4168    in /export/home/pb2/build/sb_0-13191046-1410444393.17/rpm/BUILD/mysql-5.6.21/mysql-5.6.21/sql-common/client.c
    
21. (gdb) bt
    
22. #0  0x000000000041118e in mysql_send_query (mysql=0x48608048, query=0x47205c60 "INSERT INTO T_Test (ClientFlag,TimeFlag) VALUES(3, 6)", length=53)
    
23.     at /export/home/pb2/build/sb_0-13191046-1410444393.17/rpm/BUILD/mysql-5.6.21/mysql-5.6.21/sql-common/client.c:4168
    
24. #1  0x00000000004111b1 in mysql_real_query (mysql=0x48608048, query=0x3 <Address 0x3 out of bounds>, length=0)
    
25.     at /export/home/pb2/build/sb_0-13191046-1410444393.17/rpm/BUILD/mysql-5.6.21/mysql-5.6.21/sql-common/client.c:4180
    
26. #2  0x000000000040eb4a in DBConPool_ExecuteSql (pConHandle=0x48608048, pSql=0x47205c60 "INSERT INTO T_Test (ClientFlag,TimeFlag) VALUES(3, 6)")
    
27.     at ../../DBConnectionPool/src/DBConPool.c:323
    
28. #3  0x0000000000409c9b in InsertDB_For_Test (pDBConn=0x48608048, pTest=0x163f473c) at ../../../Server/src/AccessDB.c:71
    
29. #4  0x0000000000409d8f in Act_Test (pMsg=0x163f4734) at ../../../Server/src/Action.c:67
    
30. #5  0x000000000040a64c in thread_routine (arg=0x166ea774) at ../../ThreadPool/src/ThreadPool.c:255
    
31. #6  0x0000003445a064a7 in start_thread () from /lib64/libpthread.so.0
    
32. #7  0x0000003444ed3c2d in clone () from /lib64/libc.so.6
    
33. (gdb)

复制代码

eveson

就这么个简单的测试程序，也是第一次操作成功，第二次操作失败

1. #include <stdio.h>
   
2. #include <string.h>
   
3. #include <stdlib.h>
   
4. #include <mysql/mysql.h>
   
5. //gcc -g -o conn conn.c -L/usr/lib64/mysql -lmysqlclient  -lstdc++ -lpthread  -ldl -lrt
   
6. int main(void)
   
7. {
   
8.         MYSQL *DBConn;
   
9.         char psql[1024];
   
10.         DBConn = mysql_init(NULL);
    
11. 
    
12.         if(!mysql_real_connect(DBConn, "127.0.0.1", "root", "root", "mydata", 3306, NULL, 0))
    
13.         {
    
14.                 return -1;
    
15.         }
    
16. 
    
17.         sprintf(psql, "select * from T_Test");
    
18.         while (1)
    
19.         {
    
20.                 if (mysql_real_query(DBConn, psql, strlen(psql)))
    
21.                 {
    
22.                         printf("Query Failed\n");
    
23.                         return -1;
    
24.                 }
    
25.                 printf("Query Success\n");
    
26.                 sleep(1);
    
27.         }
    
28.         mysql_close(DBConn);
    
29.         return 0;
    
30. }

复制代码

eveson

加了这个就行了，实在不好意思，用的不熟啊。呵呵

1.                 res=mysql_store_result(DBConn);
   
2.                 mysql_free_result(res);

复制代码

eveson

这个问题解决了，但是有新的问题：
创建了100个线程，100个数据库连接，每个线程有一个数据库连接，同时操作数据库，这样还是出错，出错信息和位置跟前面一样。这怎么办，mysql应该支持多线程吧？