Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

proxysql crashing on SET commands #1342

Closed
AshwiniAhire opened this issue Jan 19, 2018 · 3 comments
Closed

proxysql crashing on SET commands #1342

AshwiniAhire opened this issue Jan 19, 2018 · 3 comments

Comments

@AshwiniAhire
Copy link
Contributor

ProxySQL version : 1.4.5
OS version Ubuntu : 14.04.5

ProxySQL is crashing when we execute SET command to MySQL through ProxySQL.

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
(gdb) bt
#0  0x00007f1d6262eabc in __strcasestr_sse2 (haystack_start=0x7f1d5fa407e0 "set default_storage_engine = InnoDB",                                                 |
    needle_start=0x100000006 <error: Cannot access memory at address 0x100000006>) at ../string/strcasestr.c:76
#1  0x0000000000612977 in MySQL_Connection::ProcessQueryAndSetStatusFlags (this=0x7f1d5fa492c0, query_digest_text=0x7f1d5fa407e0 "set default_storage_engine = Inn
oDB")
    at mysql_connection.cpp:1551
#2  0x0000000000518d7c in MySQL_Session::handler (this=0x7f1d5fa40780) at MySQL_Session.cpp:2558
#3  0x0000000000505daf in MySQL_Thread::process_all_sessions (this=0x7f1d5fa0d000) at MySQL_Thread.cpp:3217
#4  0x00000000005050c9 in MySQL_Thread::run (this=0x7f1d5fa0d000) at MySQL_Thread.cpp:3008
#5  0x00000000004c141b in mysql_worker_thread_func (arg=0x7f1d620163e0) at main.cpp:243
#6  0x00007f1d63bd4184 in start_thread (arg=0x7f1d617fe700) at pthread_create.c:312
#7  0x00007f1d6269a03d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
(gdb)

#2  0x0000000000518d7c in MySQL_Session::handler (this=0x7f1d5fa40780) at MySQL_Session.cpp:2558
#3  0x0000000000505daf in MySQL_Thread::process_all_sessions (this=0x7f1d5fa0d000) at MySQL_Thread.cpp:3217
#4  0x00000000005050c9 in MySQL_Thread::run (this=0x7f1d5fa0d000) at MySQL_Thread.cpp:3008
#5  0x00000000004c141b in mysql_worker_thread_func (arg=0x7f1d620163e0) at main.cpp:243
#6  0x00007f1d63bd4184 in start_thread (arg=0x7f1d617fe700) at pthread_create.c:312
#7  0x00007f1d6269a03d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
(gdb) frame 1
#1  0x0000000000612977 in MySQL_Connection::ProcessQueryAndSetStatusFlags (this=0x7f1d5fa492c0, query_digest_text=0x7f1d5fa407e0 "set default_storage_engine = Inn
oDB")
    at mysql_connection.cpp:1551
1551                                    if (strcasestr(query_digest_text,session_vars[i])!=NULL)  {
(gdb)

(gdb) p session_vars[6]
$10 = 0x766b50 "/*!\n * Chart.js\n * http://chartjs.org/\n * Version: 2.7.1\n *\n * Copyright 2017 Nick Downie\n * Released under the MIT license\n * https://gith
ub.com/chartjs/Chart.js/blob/master/LICENSE.md\n */\n(function("...
(gdb) p sizeof(session_vars)
$11 = 48
(gdb)
@unknown321
Copy link

This regression was introduced somewhere after v1.4.3. We've compiled 1.4.5 from source and experiencing same bug.

@renecannao
Copy link
Contributor

renecannao commented Jan 26, 2018

It was introduced in 1.4.5 .
Patch is in #1345

Edit: bug was introduced in 1.4.4 , not 1.4.5

@renecannao
Copy link
Contributor

Patch in #1345 applied in 1.4.6 .
Thanks

renecannao added a commit that referenced this issue Feb 2, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants