Bug #27172 | crash with 100+ connections | ||
---|---|---|---|
Submitted: | 15 Mar 2007 13:13 | Modified: | 9 Oct 2008 10:55 |
Reporter: | Brian Aker | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Falcon storage engine | Severity: | S1 (Critical) |
Version: | bk-current | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | F_TRANSACTION |
[15 Mar 2007 13:13]
Brian Aker
[14 Apr 2007 0:49]
Hakan Küçükyılmaz
Hit's following assertion: Program received signal SIGILL, Illegal instruction. [Switching to Thread 1166453088 (LWP 31953)] 0x00002af1509c02ac in raise () from /lib/libpthread.so.0 (gdb) bt #0 0x00002af1509c02ac in raise () from /lib/libpthread.so.0 #1 0x00000000007c23f2 in Error::debugBreak () at Error.cpp:93 #2 0x00000000007c24ed in Error::error (string=<value optimized out>) at Error.cpp:70 #3 0x00000000007c254c in Error::assertionFailed (fileName=0x4 <Address 0x4 out of bounds>, line=31953) at Error.cpp:77 #4 0x0000000000797f4b in Table::checkAncestor (this=<value optimized out>, current=0x2aaab8f3f950, oldRecord=0x2aaab8f3f9b0) at Table.cpp:2770 #5 0x000000000079c718 in Table::update (this=0x2aaaab0878e8, transaction=0x2aaaba250c28, orgRecord=0x2aaab8f3f9b0, stream=0x2aaaaafb0c30) at Table.cpp:2434 #6 0x0000000000790296 in StorageDatabase::updateRow (this=<value optimized out>, storageConnection=<value optimized out>, table=0x2aaaab0878e8, oldRecord=0x2aaab8f3f9b0, stream=0x2aaaaafb0c30) at StorageDatabase.cpp:535 #7 0x000000000079363b in StorageTable::updateRow (this=0x2aaaaafb00b8, recordNumber=<value optimized out>) at StorageTable.cpp:107 #8 0x000000000078e43e in NfsStorageTable::update_row (this=0xf96728, oldData=<value optimized out>, newData=0x10232b8 "��[\001") at ha_falcon.cpp:888
[14 Apr 2007 0:55]
Hakan Küçükyılmaz
Sometimes we also hit: ./mysqlslap --concurrency=50,100,150,200,250,300 --iterations=2 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=10000 --auto-generate-sql-unique-write-number=10 --auto-generate-sql-write-number=100000 --csv=/tmp/falcon-auto.csv --engine=falcon /home/hakan/work/mysql/mysql-5.1-arch/client/.libs/lt-mysqlslap: Cannot run query UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH5PySQ2dejfcCd5Lv0HOxA2uFnyHYYJhdcf52ZbYGE9KkEifErw31qx8dnH1KSax4DvzmWXvcY7KmhssOowIWlQzZc0l4',charcol2 = 'Qi9fT8HrX4S4CoilYbACNSi0mhPMZARzlcWEcg6zkQ3o6eafDcrS4QSq7u5Z4YYh0vwSbuRBKN0QtQ562pQyFmgEYlnT9CA176Ta0plC4dfxvkvpZDngzKvY5it7m3',charcol3 = '8t2WJuJx7FamCMMzBoCrSBBFb8ySFkYGWQmhKxeRC55ORSNWGbLceYsEhiaoIy4gOiMlfs4rxA7GeMnmp0ESZ6a6g8mz7jXNPt85mDwbN4ktIXf8XlcwkAuOAZF9Gn' WHERE id = '97583' ERROR : Record has changed since last read in table 't1'
[19 Apr 2007 7:40]
Hakan Küçükyılmaz
Runs now at least up to 150 but hits assertions after long time: (gdb) f 4 #4 0x000000000084b19c in Transaction::writeComplete (this=0x2aa956e520) at Transaction.cpp:655 655 ASSERT(writePending == true); (gdb) p writePending $1 = false (gdb) Full backtrace: Program received signal SIGILL, Illegal instruction. [Switching to Thread 1088981344 (LWP 13554)] 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 (gdb) bt #0 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 #1 0x000000000087b2de in Error::debugBreak () at Error.cpp:93 #2 0x000000000087b265 in Error::error (string=0xbd5970 "assertion failed at line %d in file %s\n") at Error.cpp:70 #3 0x000000000087b2c3 in Error::assertionFailed (fileName=0xbcd13c "Transaction.cpp", line=655) at Error.cpp:77 #4 0x000000000084b19c in Transaction::writeComplete (this=0x2aa956e520) at Transaction.cpp:655 #5 0x00000000008d437b in SerialLogTransaction::commit (this=0x2a9e4eabd0) at SerialLogTransaction.cpp:78 #6 0x00000000008d460f in SerialLogTransaction::doAction (this=0x2a9e4eabd0) at SerialLogTransaction.cpp:132 #7 0x00000000008cfc9a in SerialLog::gopherThread (this=0x2a9e38a378) at SerialLog.cpp:145 #8 0x00000000008cfb6f in SerialLog::gopherThread (arg=0x2a9e38a378) at SerialLog.cpp:124
[26 Jun 2007 19:57]
Jim Starkey
Works like a charm. Runs to completion.
[27 Jun 2007 10:33]
Hakan Küçükyılmaz
I tested: hakan@lu0009:~> mysqlslap --concurrency=1,50,100,150,200,250,300 --iterations=10 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=10000 --auto-generate-sql-unique-write-number=10 --auto-generate-sql-write-number=100000 --csv=/tmp/innodb-auto.csv --engine=falcon,blackhole,innodb and it crashes on iteration with 100 connections: Program received signal SIGILL, Illegal instruction. [Switching to Thread 1124247904 (LWP 6523)] 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 (gdb) (gdb) (gdb) bt #0 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 #1 0x0000000000842c24 in Error::error (string=<value optimized out>) at Error.cpp:92 #2 0x00000000008143d4 in Transaction::releaseDependency (this=0x2b74a3ecd0) at Transaction.cpp:1087 #3 0x00000000008159cf in Transaction::commit (this=0x2b79ff79e0) at Transaction.cpp:662 #4 0x000000000082bdfc in Connection::commit (this=0x2b5ebee508) at Connection.cpp:269 #5 0x00000000007fe18b in StorageConnection::commit (this=0x2b7e1918b8) at StorageConnection.cpp:153 #6 0x0000000000800f0d in StorageHandler::commit (this=<value optimized out>, mySqlThread=0x2b565ddd60) at StorageHandler.cpp:210 #7 0x00000000007f9288 in StorageInterface::commit (hton=<value optimized out>, thd=0x2b565ddd60, all=4) at ha_falcon.cpp:965 #8 0x0000000000736088 in ha_commit_trans (thd=0x2b565ddd60, all=false) at handler.cc:779 #9 0x00000000007362a6 in ha_autocommit_or_rollback (thd=0x2b565ddd60, error=0) at handler.cc:887 #10 0x00000000006db5f9 in mysql_update (thd=0x2b565ddd60, table_list=<value optimized out>, fields=@0x2b565df808, values=@0x2b565dfbe0, conds=<value optimized out>, order_num=<value optimized out>, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:720 #11 0x0000000000662943 in mysql_execute_command (thd=0x2b565ddd60) at sql_parse.cc:2585 #12 0x00000000006654e1 in mysql_parse (thd=0x2b565ddd60, inBuf=0x308f020 "UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR806QNRrtC7BT7KmYQxm7k3hmxvojyBB649YRcFChFOAMkxu2mZ9Wcj9Qex9c8KaCWyXy5kfK0ijcfTXH2gfXFoxtlyLmBvq',charc"..., length=493, found_semicolon=0x43029598) at sql_parse.cc:5381 #13 0x000000000066619d in dispatch_command (command=COM_QUERY, thd=0x2b565ddd60, packet=0x2b565e0691 "UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR806QNRrtC7BT7KmYQxm7k3hmxvojyBB649YRcFChFOAMkxu2mZ9Wcj9Qex9c8KaCWyXy5kfK0ijcfTXH2gfXFoxtlyLmBvq',charc"..., packet_length=494) at sql_parse.cc:907 #14 0x0000000000666ad2 in do_command (thd=0x2b565ddd60) at sql_parse.cc:669 #15 0x0000000000657eab in handle_one_connection (arg=<value optimized out>) at sql_connect.cc:1091 #16 0x0000002a95ef2b8f in start_thread () from /lib64/tls/libpthread.so.0 #17 0x0000002a95c7c4b3 in clone () from /lib64/tls/libc.so.6
[27 Jun 2007 12:36]
Hakan Küçükyılmaz
Also crashes when run with 1 iteration only, like mysqlslap --concurrency=1,50,100,150,200,250,300 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=10000 --auto-generate-sql-unique-write-number=10 --auto-generate-sql-write-number=100000 --csv=/tmp/innodb-auto.csv --engine=falcon,blackhole,innodb #0 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 #1 0x0000000000842c24 in Error::error (string=<value optimized out>) at Error.cpp:92 #2 0x00000000008143d4 in Transaction::releaseDependency (this=0x2ba58ad598) at Transaction.cpp:1087 #3 0x00000000008159cf in Transaction::commit (this=0x2ba58aa598) at Transaction.cpp:662
[27 Jun 2007 16:15]
Brian Aker
Just running this on Falcon: ./bin/mysqlslap --concurrency=100,150,200,250,300 --iterations=10 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=10000 --auto-generate-sql-unique-write-number=10 --auto-generate-sql-write-number=100000 --csv=/tmp/innodb-auto.csv --engine=falcon At 24 hours it still has not completed the first run (Innodb is significantly faster).
[1 Jul 2007 19:35]
Hakan Küçükyılmaz
Just tried with latest bk. Still hitting assertion at 150 connections mysqlslap --concurrency=1,50,100,150,200,250,300 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=10000 --auto-generate-sql-unique-write-number=10 --auto-generate-sql-write-number=100000 --csv=/tmp/innodb-auto.csv --engine=falcon,blackhole,innodb Program received signal SIGILL, Illegal instruction. [Switching to Thread 1085045088 (LWP 12529)] 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 (gdb) bt #0 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 #1 0x0000000000842d14 in Error::error (string=<value optimized out>) at Error.cpp:92 #2 0x00000000008144f4 in Transaction::releaseDependency (this=0x2afbd12518) at Transaction.cpp:1091 #3 0x0000000000815aff in Transaction::commit (this=0x2afbd04268) at Transaction.cpp:666 #4 0x000000000082bf2c in Connection::commit (this=0x2b2ba90430) at Connection.cpp:269 #5 0x00000000007fe23b in StorageConnection::commit (this=0x2ae21c9c00) at StorageConnection.cpp:153 #6 0x0000000000800f9d in StorageHandler::commit (this=<value optimized out>, mySqlThread=0x2ae5024b40) at StorageHandler.cpp:210 #7 0x00000000007f9338 in StorageInterface::commit (hton=<value optimized out>, thd=0x2ae5024b40, all=<value optimized out>) at ha_falcon.cpp:965 #8 0x0000000000736138 in ha_commit_trans (thd=0x2ae5024b40, all=false) at handler.cc:779 #9 0x0000000000736356 in ha_autocommit_or_rollback (thd=0x2ae5024b40, error=0) at handler.cc:887 #10 0x00000000006db6a9 in mysql_update (thd=0x2ae5024b40, table_list=<value optimized out>, fields=@0x2ae50265e8, values=@0x2ae50269c0, conds=<value optimized out>, order_num=<value optimized out>, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:720 #11 0x00000000006629f3 in mysql_execute_command (thd=0x2ae5024b40) at sql_parse.cc:2585 #12 0x0000000000665591 in mysql_parse (thd=0x2ae5024b40, inBuf=0x2ae5043710 "UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charco"..., length=493, found_semicolon=0x40ac6598) at sql_parse.cc:5381 #13 0x000000000066624d in dispatch_command (command=COM_QUERY, thd=0x2ae5024b40, packet=0x2ae580cb91 "UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charco"..., packet_length=494) at sql_parse.cc:907 #14 0x0000000000666b82 in do_command (thd=0x2ae5024b40) at sql_parse.cc:669 #15 0x0000000000657f5b in handle_one_connection (arg=<value optimized out>) at sql_connect.cc:1091 #16 0x0000002a95ef2aff in start_thread () from /lib64/tls/libpthread.so.0 #17 0x0000002a95c7c4b3 in clone () from /lib64/tls/libc.so.6
[1 Jul 2007 19:36]
Hakan Küçükyılmaz
For my tests I used mysqlslap contained in the 5.1-falcon tree.
[2 Jul 2007 14:29]
Hakan Küçükyılmaz
Assertion is hit faster when starting with 50 connections hakan@lu0010:~> mysqlslap --concurrency=50,100,150,200,250,300 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=10000 --auto-generate-sql-unique-write-number=10 --auto-generate-sql-write-number=100000 --csv=/tmp/innodb-auto.csv --engine=falcon,blackhole,innodb Program received signal SIGILL, Illegal instruction. [Switching to Thread 1097558368 (LWP 30599)] 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 (gdb) bt #0 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 #1 0x0000000000842d74 in Error::error (string=<value optimized out>) at Error.cpp:92 #2 0x0000000000814544 in Transaction::releaseDependency (this=0x2aeb3ac0a8) at Transaction.cpp:1091 #3 0x0000000000815b4f in Transaction::commit (this=0x2aee212038) at Transaction.cpp:666 #4 0x000000000082bf7c in Connection::commit (this=0x2ae980f6e8) at Connection.cpp:269 #5 0x00000000007fe23b in StorageConnection::commit (this=0x2aea825168) at StorageConnection.cpp:153 #6 0x0000000000800fed in StorageHandler::commit (this=<value optimized out>, mySqlThread=0x2ae5949a70) at StorageHandler.cpp:210 #7 0x00000000007f9338 in StorageInterface::commit (hton=<value optimized out>, thd=0x2ae5949a70, all=<value optimized out>) at ha_falcon.cpp:965 #8 0x0000000000736138 in ha_commit_trans (thd=0x2ae5949a70, all=false) at handler.cc:779 #9 0x0000000000736356 in ha_autocommit_or_rollback (thd=0x2ae5949a70, error=0) at handler.cc:887 #10 0x00000000006db6a9 in mysql_update (thd=0x2ae5949a70, table_list=<value optimized out>, fields=@0x2ae594b518, values=@0x2ae594b8f0, conds=<value optimized out>, order_num=<value optimized out>, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:720 #11 0x00000000006629f3 in mysql_execute_command (thd=0x2ae5949a70) at sql_parse.cc:2585 #12 0x0000000000665591 in mysql_parse (thd=0x2ae5949a70, inBuf=0x2ae503b840 "UPDATE t1 SET intcol1 = 1471079933,intcol2 = 266531426,charcol1 = 'a1vMmjn2ZKuaFxe9yR02BJeO5IKMg5o67bKlI7gjJQHbNokD7lGIwmjt4vFc1vb0Xvdh3HPEbipzMQCT3Koz7Ns3I0gJv7JQ2x8x6P4i7tZMBlrEyXDxuysDqOOlXc',charc"..., length=494, found_semicolon=0x416b5598) at sql_parse.cc:5381 #13 0x000000000066624d in dispatch_command (command=COM_QUERY, thd=0x2ae5949a70, packet=0x2ae594c4c1 "UPDATE t1 SET intcol1 = 1471079933,intcol2 = 266531426,charcol1 = 'a1vMmjn2ZKuaFxe9yR02BJeO5IKMg5o67bKlI7gjJQHbNokD7lGIwmjt4vFc1vb0Xvdh3HPEbipzMQCT3Koz7Ns3I0gJv7JQ2x8x6P4i7tZMBlrEyXDxuysDqOOlXc',charc"..., packet_length=495) at sql_parse.cc:907 #14 0x0000000000666b82 in do_command (thd=0x2ae5949a70) at sql_parse.cc:669 #15 0x0000000000657f5b in handle_one_connection (arg=<value optimized out>) at sql_connect.cc:1091 #16 0x0000002a95ef2aff in start_thread () from /lib64/tls/libpthread.so.0 #17 0x0000002a95c7c4b3 in clone () from /lib64/tls/libc.so.6
[5 Jul 2007 16:13]
Hakan Küçükyılmaz
Still failing with the latest push after ~30 minutes. hakan@ls3235:~> mysqlslap --concurrency=50,100,150,200,250,300 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=10000 --auto-generate-sql-unique-write-number=10 --auto-generate-sql-write-number=100000 --csv=/tmp/innodb-auto.csv --engine=falcon,blackhole,innodb Backtrace is: Program received signal SIGILL, Illegal instruction. [Switching to Thread 1103305056 (LWP 12061)] 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 (gdb) bt #0 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 #1 0x00000000008430f4 in Error::error (string=<value optimized out>) at Error.cpp:92 #2 0x0000000000814894 in Transaction::releaseDependency (this=0x2aea866ec8) at Transaction.cpp:1091 #3 0x0000000000815e9f in Transaction::commit (this=0x2aea8479e8) at Transaction.cpp:666 #4 0x000000000082c2dc in Connection::commit (this=0x2aeaa85d78) at Connection.cpp:269 #5 0x00000000007fe48b in StorageConnection::commit (this=0x2aebc614c8) at StorageConnection.cpp:153 #6 0x000000000080123d in StorageHandler::commit (this=<value optimized out>, mySqlThread=0x2ae5c47160) at StorageHandler.cpp:210 #7 0x00000000007f9588 in StorageInterface::commit (hton=<value optimized out>, thd=0x2ae5c47160, all=4) at ha_falcon.cpp:966 #8 0x0000000000736338 in ha_commit_trans (thd=0x2ae5c47160, all=false) at handler.cc:779 #9 0x0000000000736556 in ha_autocommit_or_rollback (thd=0x2ae5c47160, error=0) at handler.cc:887 #10 0x00000000006db8a9 in mysql_update (thd=0x2ae5c47160, table_list=<value optimized out>, fields=@0x2ae5c48c08, values=@0x2ae5c48fe0, conds=<value optimized out>, order_num=<value optimized out>, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:720 #11 0x0000000000662bf3 in mysql_execute_command (thd=0x2ae5c47160) at sql_parse.cc:2585 #12 0x0000000000665791 in mysql_parse (thd=0x2ae5c47160, inBuf=0x128cca0 "UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwuvLhKms6Hm9OhOlwHXG5k19nW0hrBtn6h8ntnXz4A8KrOxnZTve5onsIfQ9rBopkxSdkzTg9T0tuyYRJK6G8l0JHQK8W9pE',char"..., length=495, found_semicolon=0x41c30598) at sql_parse.cc:5381 #13 0x000000000066644d in dispatch_command (command=COM_QUERY, thd=0x2ae5c47160, packet=0x2ae5c49571 "UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwuvLhKms6Hm9OhOlwHXG5k19nW0hrBtn6h8ntnXz4A8KrOxnZTve5onsIfQ9rBopkxSdkzTg9T0tuyYRJK6G8l0JHQK8W9pE',char"..., packet_length=496) at sql_parse.cc:907 #14 0x0000000000666d82 in do_command (thd=0x2ae5c47160) at sql_parse.cc:669 #15 0x000000000065815b in handle_one_connection (arg=<value optimized out>) at sql_connect.cc:1091 #16 0x0000002a95ef2aff in start_thread () from /lib64/tls/libpthread.so.0 #17 0x0000002a95c7c4b3 in clone () from /lib64/tls/libc.so.6 #18 0x0000000000000000 in ?? ()
[5 Jul 2007 20:31]
Jim Starkey
mysqlslap runs to completion with falcon_max_transaction_backlog defaulting to 10,000 transactions.
[6 Jul 2007 11:55]
Hakan Küçükyılmaz
Runs fine up too 200 connections on dual core Intel. After 12 hours I stopped mysqlslap. However, on a 8-way it hits an assertion at 150 connections: Program received signal SIGILL, Illegal instruction. [Switching to Thread 1138624864 (LWP 17240)] 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 (gdb) bt #0 0x0000002a95bf0479 in raise () from /lib64/tls/libc.so.6 #1 0x0000000000843104 in Error::error (string=<value optimized out>) at Error.cpp:92 #2 0x00000000008147e6 in Transaction::releaseDependency (this=0x2b76247658) at Transaction.cpp:1093 #3 0x0000000000815e9f in Transaction::commit (this=0x2b7603c690) at Transaction.cpp:667 #4 0x000000000082c2ec in Connection::commit (this=0x2b77d552a0) at Connection.cpp:269 #5 0x00000000007fe4cb in StorageConnection::commit (this=0x2b78198408) at StorageConnection.cpp:153 #6 0x000000000080127b in StorageHandler::commit (this=<value optimized out>, mySqlThread=0x2b72e4f1c0) at StorageHandler.cpp:211 #7 0x00000000007f95c8 in StorageInterface::commit (hton=<value optimized out>, thd=0x2b72e4f1c0, all=<value optimized out>) at ha_falcon.cpp:966 #8 0x0000000000736378 in ha_commit_trans (thd=0x2b72e4f1c0, all=false) at handler.cc:779 #9 0x0000000000736596 in ha_autocommit_or_rollback (thd=0x2b72e4f1c0, error=0) at handler.cc:887 #10 0x00000000006db8e9 in mysql_update (thd=0x2b72e4f1c0, table_list=<value optimized out>, fields=@0x2b72e50c68, values=@0x2b72e51040, conds=<value optimized out>, order_num=<value optimized out>, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:720 #11 0x0000000000662c33 in mysql_execute_command (thd=0x2b72e4f1c0) at sql_parse.cc:2585 #12 0x00000000006657d1 in mysql_parse (thd=0x2b72e4f1c0, inBuf=0x1184c00 "UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charc"..., length=494, found_semicolon=0x43ddf598) at sql_parse.cc:5381 #13 0x000000000066648d in dispatch_command (command=COM_QUERY, thd=0x2b72e4f1c0, packet=0x2b72e515d1 "UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charc"..., packet_length=495) at sql_parse.cc:907 #14 0x0000000000666dc2 in do_command (thd=0x2b72e4f1c0) at sql_parse.cc:669 #15 0x000000000065819b in handle_one_connection (arg=<value optimized out>) at sql_connect.cc:1091 #16 0x0000002a95ef2aff in start_thread () from /lib64/tls/libpthread.so.0 #17 0x0000002a95c7c4b3 in clone () from /lib64/tls/libc.so.6
[6 Aug 2007 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[9 Oct 2008 10:55]
Hakan Küçükyılmaz
Can't repeat anymore. Successfully ran mysqlslap with --concurrency=1,50,100,150,200,250,300 for Falcon.