1.

sqlite3_open 死锁

 

* thread #1, queue = 'com.apple.main-thread', stop reason = signal SIGSTOP

frame #0: 0x0000000116e22c22 libsystem_kernel.dylib`__psynch_mutexwait + 10

frame #1: 0x0000000116e57dfa libsystem_pthread.dylib`_pthread_mutex_lock_wait + 100

* frame #2: 0x000000010d550e3a MLPlayer`sqlite3Malloc [inlined] sqlite3_mutex_enter(p=<unavailable>) at sqlite3.c:21778 [opt]

frame #3: 0x000000010d550e2f MLPlayer`sqlite3Malloc(n=127) at sqlite3.c:23035 [opt]

frame #4: 0x000000010d55a7db MLPlayer`sqlite3DbMallocRaw(db=0x00007f9cf7617ed0, n=<unavailable>) at sqlite3.c:23374 [opt]

frame #5: 0x000000010d559402 MLPlayer`sqlite3DbMallocZero(db=<unavailable>, n=127) at sqlite3.c:23318 [opt]

frame #6: 0x000000010d59c943 MLPlayer`sqlite3FindCollSeq [inlined] findCollSeqEntry at sqlite3.c:92028 [opt]

frame #7: 0x000000010d59c8f7 MLPlayer`sqlite3FindCollSeq(db=<unavailable>, enc=<unavailable>, zName=<unavailable>, create=<unavailable>) at sqlite3.c:92079 [opt]

frame #8: 0x000000010d55ffe5 MLPlayer`createCollation(db=<unavailable>, zName=<unavailable>, enc=<unavailable>, pCtx=<unavailable>, xCompare=<unavailable>, xDel=<unavailable>) at sqlite3.c:124965 [opt]

frame #9: 0x000000010d55f84b MLPlayer`openDatabase(zFilename="/Users/temp/Library/Developer/CoreSimulator/Devices/F31C98A5-1D5C-4053-B6E2-1E622E430721/data/Containers/Data/Application/CCAE5F2D-0E09-4EBE-866A-C89D4E59AD38/Documents/xx.db", ppDb=<unavailable>, flags=<unavailable>, zVfs=0x0000000000000000) at sqlite3.c:125438 [opt]

frame #10: 0x000000010d0f82d8 MLPlayer`-[PAFMDatabase open](self=0x000060000008ece0, _cmd="open") at PAFMDatabase.m:144

 

http://bbs.csdn.net/topics/370165256

 

2. xcode mysql connector

. 编译Connector/C(因为Connector/C++依赖Connector/C)
解压缩源码, 比如释放到F盘, 并改名为mysqlc(纯粹为了方便说明)
打开CMAKE-GUI(在安装目录里找), Source Path选择"F:\mysqlc", Build Path选择"F:\buildc"
Build Path可以和Source Path一样
点Configure, 选择编译器与平台, 点Finish, 出现"Configuring done"后点Generate
出现"Generating done"后, CMAKE部分完事儿
在"F:\buildc"里找项目文件(sln), 打开, 编译(注意Debug与Release), C组件搞定




ulong
cli_safe_read_with_ok(MYSQL *mysql, my_bool parse_ok,
my_bool *is_data_packet)
{
...
if (net->read_pos[0] == 255)
{
/*
After server reprts an error, usually it is ready to accept new commands and
we set stage to READY_FOR_COMMAND. This can be modified by the caller of
cli_safe_read().
*/
MYSQL_TRACE_STAGE(mysql, READY_FOR_COMMAND);

if (len > 3)
{
uchar *pos= net->read_pos+1;
net->last_errno=uint2korr(pos);
pos+=2;
len-=2;
if (protocol_41(mysql) && pos[0] == '#')
{
strmake(net->sqlstate, (char*)pos+1, SQLSTATE_LENGTH);
pos+= SQLSTATE_LENGTH+1;
}
else
{
/*
The SQL state hasn't been received -- it should be reset to HY000
(unknown error sql state).
*/

my_stpcpy(net->sqlstate, unknown_sqlstate);
}

(void) strmake(net->last_error,(char*) pos,
MY_MIN((uint) len,(uint) sizeof(net->last_error)-1));
}
else
set_mysql_error(mysql, CR_UNKNOWN_ERROR, unknown_sqlstate);
/*
Cover a protocol design error: error packet does not
contain the server status. Therefore, the client has no way
to find out whether there are more result sets of
a multiple-result-set statement pending. Luckily, in 5.0 an
error always aborts execution of a statement, wherever it is
a multi-statement or a stored procedure, so it should be
safe to unconditionally turn off the flag here.
*/
mysql->server_status&= ~SERVER_MORE_RESULTS_EXISTS;

DBUG_PRINT("error",("Got error: %d/%s (%s)",
net->last_errno,
net->sqlstate,
net->last_error));
return(packet_error);
}


 

(lldb) p net->buff

(unsigned char *) $0 = 0x0000000101809000 "\377z\x04#42S02Table 'test.address_book_group_00' doesn't exist"

(lldb) p net->buff[0]

(unsigned char) $1 = '\xff'

(lldb) p net->buff[1]

(unsigned char) $2 = 'z'

(lldb) p net->buff[2]

(unsigned char) $3 = '\x04'

(lldb) p net->buff[5]

(unsigned char) $4 = '2'

(lldb) p net->buff[6]

(unsigned char) $5 = 'S'

(lldb) p net->buff[7]

(unsigned char) $6 = '0'

(lldb) p net->buff[8]

(unsigned char) $7 = '2'

(lldb) p net->buff[9]

(unsigned char) $8 = 'T'

(lldb) p net->buff[10]

(unsigned char) $9 = 'a'

(lldb) p net->buff[11]

(unsigned char) $10 = 'b'

(lldb) p net->buff[12]

(unsigned char) $11 = 'l'

(lldb) p net->buff[13]

(unsigned char) $12 = 'e'

(lldb) p pos

(uchar *) $13 = 0x0000000101809003 "#42S02Table 'test.address_book_group_00' doesn't exist"

(lldb) p pos

(uchar *) $14 = 0x0000000101809009 "Table 'test.address_book_group_00' doesn't exist"

cli_read_query_result: error: Got error: 1146/42S02 (Table 'test.address_book_group_00' doesn't exist)

 

1146=0x47a=z\x04  net->last_errno

 

\377=\xff=255     net->read_pos[0] == 255

 

42S02             net->sqlstate

 

https://dev.mysql.com/doc/dev/mysql-server/latest/page_protocol_basic_err_packet.html

The Payload of an ERR ​​Packet​

Type

Name

Description

​int<1>​

header

​0xFF​​ ERR packet header

​int<2>​

error_code

error-code

if capabilities & ​​CLIENT_PROTOCOL_41​​ {

​string[1]​

sql_state_marker

# marker of the SQL state

​string[5]​

sql_state

SQL state

}

​string<EOF>​

error_message

human readable error message

 



MYSQL * STDCALL
CLI_MYSQL_REAL_CONNECT(MYSQL *mysql,const char *host, const char *user,
const char *passwd, const char *db,
uint port, const char *unix_socket,ulong client_flag)
{
...
pkt_end= (char*)net->read_pos + pkt_length;
/* Check if version of protocol matches current one */
mysql->protocol_version= net->read_pos[0];
DBUG_DUMP("packet",(uchar*) net->read_pos,10);
DBUG_PRINT("info",("mysql protocol version %d, server=%d",
PROTOCOL_VERSION, mysql->protocol_version));
if (mysql->protocol_version != PROTOCOL_VERSION)
{
set_mysql_extended_error(mysql, CR_VERSION_ERROR, unknown_sqlstate,
ER(CR_VERSION_ERROR), mysql->protocol_version,
PROTOCOL_VERSION);
goto error;
}
server_version_end= end= strend((char*) net->read_pos+1);
mysql->thread_id=uint4korr((uchar*) end + 1);
end+=5;
/*
Scramble is split into two parts because old clients do not understand
long scrambles; here goes the first part.
*/
scramble_data= end;
scramble_data_len= AUTH_PLUGIN_DATA_PART_1_LENGTH + 1;
scramble_plugin= NULL;
end+= scramble_data_len;

if (pkt_end >= end + 1)
mysql->server_capabilities=uint2korr((uchar*) end);
if (pkt_end >= end + 18)
{
/* New protocol with 16 bytes to describe server characteristics */
mysql->server_language=end[2];
mysql->server_status=uint2korr((uchar*) end + 3);
mysql->server_capabilities|= uint2korr((uchar*) end + 5) << 16;
pkt_scramble_len= end[7];
if (pkt_scramble_len < 0)
{
set_mysql_error(mysql, CR_MALFORMED_PACKET,
unknown_sqlstate); /* purecov: inspected */
goto error;
}
}
...
/*
Part 2: invoke the plugin to send the authentication data to the server
*/

if (run_plugin_auth(mysql, scramble_buffer, scramble_data_len,
scramble_plugin, db))
goto error;


 

(lldb) p net->read_pos

(unsigned char *) $0 = 0x0000000101009e00 "\n5.6.21"

 

'\n'=PROTOCOL_VERSION(10)  mysql->protocol_version

 

 4.



MYSQL_DATA *cli_read_rows(MYSQL *mysql,MYSQL_FIELD *mysql_fields,
unsigned int fields)
...

while (*(cp=net->read_pos) == 0 || is_data_packet)
{
result->rows++;
if (!(cur= (MYSQL_ROWS*) alloc_root(&result->alloc,
sizeof(MYSQL_ROWS))) ||
!(cur->data= ((MYSQL_ROW)
alloc_root(&result->alloc,
(fields+1)*sizeof(char *)+pkt_len))))
{
free_rows(result);
set_mysql_error(mysql, CR_OUT_OF_MEMORY, unknown_sqlstate);
DBUG_RETURN(0);
}
*prev_ptr=cur;
prev_ptr= &cur->next;
to= (char*) (cur->data+fields+1);
end_to=to+pkt_len-1;
for (field=0 ; field < fields ; field++)
{
if ((len=(ulong) net_field_length(&cp)) == NULL_LENGTH)
{ /* null field */
cur->data[field] = 0;
}
else
{
cur->data[field] = to;
if (len > (ulong) (end_to - to))
{
free_rows(result);
set_mysql_error(mysql, CR_MALFORMED_PACKET, unknown_sqlstate);
DBUG_RETURN(0);
}
memcpy(to,(char*) cp,len); to[len]=0;
to+=len+1;
cp+=len;
if (mysql_fields)
{
if (mysql_fields[field].max_length < len)
mysql_fields[field].max_length=len;
}
}
}
cur->data[field]=to; /* End of last field */
if ((pkt_len= cli_safe_read(mysql, &is_data_packet)) == packet_error)
{
free_rows(result);
DBUG_RETURN(0);
}
}


(uchar *) cp = 0x0000000101805800 "\x012\x06aaaaaa"

(char *) to = 0x0000000101802840 "2"

(lldb) p len

(ulong) $0 = 1

(char *) to = 0x0000000101802842 "aaaaaa"

(lldb) p len

(ulong) $1 = 6

(uchar *) cp = 0x000000010280b400 "\x0222\x06aaaaaa"