Bug #656577 “Importing SQL script results in silent failure” : Bugs : Drizzle

Revision history for this message

Patrick Crews (patrick-crews) wrote on 2010-10-07: Re: [Bug 656577] [NEW] Importing SQL script results in silent failure

#1

Download full text (3.1 KiB)

Hmm, I would have thought our randgen testing would have caught something
like this :-/
However, thanks for the bug - and letting me know I need to tweak my test :
)

On Thu, Oct 7, 2010 at 6:50 PM, m00dawg <email address hidden> wrote:

> Public bug reported:
>
> Importing a SQL script produced by drizzledump seems to result in an
> error, but not one that is presented to the user:
>
> root@mcp:~# drizzle -p3307 moocowproductions < out.sql
> root@mcp:~# echo $?
> 141
> root@mcp:~#
>
> The import only gets to about 5 of the 20 or so tables. drizzledump,
> however, does exit with a human readable error:
>
> root@mcp:~# drizzledump -p3306 -uroot -Ppwd mcptest
> --destination-type=database --destination-port=3307
> --destination-database=moocowproductions
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost Database: mcptest
> -- ------------------------------------------------------
> -- Server version 5.1.41-3ubuntu12.6 (MySQL server)
>
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near 'farm'),('5','The Bridge','The Bridge was my first back to
> raytracing project. I ' at line 1
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near '2007-10-26 05:24:19','Paul McCullagh','','
> http://www.blobstreaming.org'),('56','' at line 1
>
> ** Affects: drizzle
> Importance: Undecided
> Status: New
>
> --
> Importing SQL script results in silent failure
> https://bugs.launchpad.net/bugs/656577
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications: New
>
> Bug description:
> Importing a SQL script produced by drizzledump seems to result in an error,
> but not one that is presented to the user:
>
> root@mcp:~# drizzle -p3307 moocowproductions < out.sql
> root@mcp:~# echo $?
> 141
> root@mcp:~#
>
> The import only gets to about 5 of the 20 or so tables. drizzledump,
> however, does exit with a human readable error:
>
> root@mcp:~# drizzledump -p3306 -uroot -Ppwd mcptest
> --destination-type=database --destination-port=3307
> --destination-database=moocowproductions
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost Database: mcptest
> -- ------------------------------------------------------
> -- Server version 5.1.41-3ubuntu12.6 (MySQL server)
>
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near 'farm'),('5','The Bridge','The Bridge was my first back to
> raytracing project. I ' at line 1
> Error executing query: You have an error in your SQL syntax; check the
> manual that corresponds to your Drizzle server version for the right syntax
> to use near '2007-10-26 05:24:19','Paul McCullagh','','
> http://www.blobstreaming.org'),('56','' at line 1
>
>
...

There are some definite issues related to drizzle.cc taking things from
stdin...

On 10/07/2010 04:06 PM, Patrick Crews wrote:
> Hmm, I would have thought our randgen testing would have caught something
> like this :-/
> However, thanks for the bug - and letting me know I need to tweak my test :
> )
> 
> On Thu, Oct 7, 2010 at 6:50 PM, m00dawg <tim@moocowproductions.org>
> wrote:
> 
>> Public bug reported:
>>
>> Importing a SQL script produced by drizzledump seems to result in an
>> error, but not one that is presented to the user:
>>
>> root@mcp:~# drizzle -p3307 moocowproductions < out.sql
>> root@mcp:~# echo $?
>> 141
>> root@mcp:~#
>>
>> The import only gets to about 5 of the 20 or so tables. drizzledump,
>> however, does exit with a human readable error:
>>
>> root@mcp:~#  drizzledump -p3306 -uroot -Ppwd mcptest
>> --destination-type=database --destination-port=3307
>> --destination-database=moocowproductions
>> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
>> --
>> -- Host: localhost    Database: mcptest
>> -- ------------------------------------------------------
>> -- Server version       5.1.41-3ubuntu12.6 (MySQL server)
>>
>> Error executing query: You have an error in your SQL syntax; check the
>> manual that corresponds to your Drizzle server version for the right syntax
>> to use near 'farm'),('5','The Bridge','The Bridge was my first back to
>> raytracing project. I ' at line 1
>> Error executing query: You have an error in your SQL syntax; check the
>> manual that corresponds to your Drizzle server version for the right syntax
>> to use near '2007-10-26 05:24:19','Paul McCullagh','','
>> http://www.blobstreaming.org'),('56','' at line 1
>>
>> ** Affects: drizzle
>>     Importance: Undecided
>>         Status: New
>>
>> --
>> Importing SQL script results in silent failure
>> https://bugs.launchpad.net/bugs/656577
>> You received this bug notification because you are a member of Drizzle-
>> developers, which is subscribed to Drizzle.
>>
>> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
>> Applications: New
>>
>> Bug description:
>> Importing a SQL script produced by drizzledump seems to result in an error,
>> but not one that is presented to the user:
>>
>> root@mcp:~# drizzle -p3307 moocowproductions < out.sql
>> root@mcp:~# echo $?
>> 141
>> root@mcp:~#
>>
>> The import only gets to about 5 of the 20 or so tables. drizzledump,
>> however, does exit with a human readable error:
>>
>> root@mcp:~#  drizzledump -p3306 -uroot -Ppwd mcptest
>> --destination-type=database --destination-port=3307
>> --destination-database=moocowproductions
>> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
>> --
>> -- Host: localhost    Database: mcptest
>> -- ------------------------------------------------------
>> -- Server version       5.1.41-3ubuntu12.6 (MySQL server)
>>
>> Error executing query: You have an error in your SQL syntax; check the
>> manual that corresponds to your Drizzle server version for the right syntax
>> to use near 'farm'),('5','The Bridge','The Bridge was my first back to
>> raytracing project. I ' at line 1
>> Error executing query: You have an error in your SQL syntax; check the
>> manual that corresponds to your Drizzle server version for the right syntax
>> to use near '2007-10-26 05:24:19','Paul McCullagh','','
>> http://www.blobstreaming.org'),('56','' at line 1
>>
>>
>>
>

Andrew Hutchings (linuxjedi) on 2010-10-08

Changed in drizzle:
assignee:	nobody → Andrew Hutchings (linuxjedi)

Andrew Hutchings (linuxjedi) on 2010-10-13

Changed in drizzle:
importance:	Undecided → Medium
milestone:	none → 2010-10-25
status:	New → In Progress

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-13:

#3

Can I please have an example of this (a broken dump file or something)? I've not been able to reproduce it.

Changed in drizzle:
status:	In Progress → Incomplete

Revision history for this message

m00dawg (tim-moocowproductions) wrote on 2010-10-13:

#4

Original problem appears to be resolved in one of the later updates to Drizzle - it is now producing a proper error (though it is for a different part of the import):

root@mcp:~# drizzle mcp < mcptest-drz.sql
ERROR 1064 (42000) at line 4605: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '),(INSERT INTO `BlogPosts` VALUES ('471',NULL,1,1,'2010-01-18 03:39:39','live','' at line 1
root@mcp:~#

The error is still, well, a problem :) Did you want me to open a new bug on that as the original issues appears to have been resolved?

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-13:

#5

Ah, excellent, thanks. I'll close this one. If you could open a new one that would be cool. Please also try the 2010-10-11 release as well (or latest trunk) if you haven't already as I have fixed many related bugs in it which could cause syntax errors.

Changed in drizzle:
milestone:	2010-10-25 → 2010-10-11
status:	Incomplete → Fix Released

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-14:

#6

m00dawg: your second problem in this is bug#660619. I swear I tested this so I guess I broke something whilst fixing something else. I know what is wrong and will fix it ASAP.

Revision history for this message

m00dawg (tim-moocowproductions) wrote on 2010-10-19:

#7

Not sure if this matches the version this was fixed in, but using the latest DEBs still gives me the silent failure:

root@mcp:/usr/lib/drizzle7# drizzle --version
Drizzle client 7 build 2010.10.1848, for pc-linux-gnu (x86_64) using readline 5.2
root@mcp:/usr/lib/drizzle7# drizzledump -p3306 -uroot -PtD2sMQamlWnZZuCd mcptest > mcp-drz.sql
root@mcp:/usr/lib/drizzle7# echo $?
0
root@mcp:/usr/lib/drizzle7# drizzle mcptest < mcp-drz.sql
root@mcp:/usr/lib/drizzle7# echo $?
141

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-20:

#8

Is it possible to provide some kind of dump file which reproduces this?

Changed in drizzle:
status:	Fix Released → Incomplete
milestone:	2010-10-11 → none

Revision history for this message

m00dawg (tim-moocowproductions) wrote on 2010-10-22:

#9

MySQL Dump of test DB Edit (536.1 KiB, application/octet-stream)

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-22:

#10

Thanks, I'll look into this ASAP

Changed in drizzle:
status:	Incomplete → Triaged

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-25:

#11

Download full text (13.9 KiB)

Cause: SIGPIPE

Program received signal SIGPIPE, Broken pipe.
0x00007ffff5d87802 in __libc_send (fd=<value optimised out>,
buf=0x7ffff7ef5f6f, n=890279, flags=<value optimised out>)
at ../sysdeps/unix/sysv/linux/x86_64/send.c:28
28 ../sysdeps/unix/sysv/linux/x86_64/send.c: No such file or directory.
in ../sysdeps/unix/sysv/linux/x86_64/send.c

(gdb) bt full
#0 0x00007ffff5d87802 in __libc_send (fd=<value optimised out>, buf=0x7ffff7ef5f6f, n=890279, flags=<value optimised out>) at ../sysdeps/unix/sysv/linux/x86_64/send.c:28
        oldtype = <value optimised out>
        result = <value optimised out>
#1 0x00007ffff6be8573 in drizzle_state_write (con=0x644680) at libdrizzle/conn.c:1010
        ret = 4294967264
        write_size = -1
#2 0x00007ffff6beef7a in drizzle_state_loop (con=0x644680) at libdrizzle/state.c:24
        ret = <value optimised out>
#3 0x00007ffff6be9625 in drizzle_con_command_write (con=0x644680, result=0x7fffffffbcc0, command=DRIZZLE_COMMAND_QUERY, data=0x7ffff7eca028, size=0, total=0, ret_ptr=0x7fffffffb34c) at libdrizzle/conn.c:492
No locals.
#4 0x00007ffff6beb54b in drizzle_query (con=0x5, result=0x7ffff7ef5f6f, query=<value optimised out>, size=<value optimised out>, ret_ptr=<value optimised out>) at libdrizzle/query.c:22
No locals.
#5 0x000000000041a5ce in drizzleclient_real_query_for_lazy (buf=0x7ffff7eca028 "INSERT INTO `BlogPosts` VALUES ('1',NULL,5,1,NULL,'live','2004-05-05 00:53:46','0','First Post...Ever','Whelp...it\\'s my first post. First ever. None like it before. Blatantly obvious perhaps, but it\\"..., length=<value optimised out>, result=0x7fffffffbcc0, error_code=0x7fffffffb3e8) at client/drizzle.cc:2681
        error = 0
        retry = 0
        ret = 32767
#6 0x000000000041a7e2 in com_go (buffer=0x6577d0) at client/drizzle.cc:2810
        time_buff = "\320we\000\000\000\000\000(\240\354\367\377\177\000\000I\000\000\000\000\000\000\000\377\064~\362\377\177", '\000' <repeats 25 times>
        ret = <value optimised out>
        timer = 4085872
        error_code = 0
        buff = "Query OK, 0 rows affecte@\356\001\366\377\177\000\000\340_\020\000\000\000\000\000\340_\020", '\000' <repeats 21 times>"\320, we\000\000\000\000\000\216\303\321\365\377\177\000\000@\306\377\377\377\177\000\000(\000\341\367\377\177\000\000\307\377\017\000\000\000\000\000\327\337}\362\377\177\000\000(\340M\362\377\177\000\000\307_\020\000\000\000\000\000\340_\020\000\000\000\000\000@\356\001\366\377\177\000\000\356T\020\000\000\000\000\000\020\340m\362\377\177\000\000\000\000\000\000\000\000\000\000\263\215\334\365\377\177\000\000;", '\000' <repeats 15 times>, ";\000\000\000\000\000\000"
        result = {con = 0x644680, next = 0x0, prev = 0x0, options = DRIZZLE_RESULT_NONE, info = '\000' <repeats 2047 times>, error_code = 0, sqlstate = "\000\000\000\000\000", insert_id = 0, warning_count = 0, affected_rows = 0, column_count = 0, column_current = 0, column_list = 0x0, column = 0x0, column_buffer = 0x0, row_count = 0, row_current = 0, field_current = 0, field_total = 0, field_offset = 0, field_size = 0, field = 0x0, field_buffer = 0x0, row_list_size = 0, row = 0x0, row_list = 0x0, field_sizes = 0x0, field_size...

Cause: SIGPIPE

Program received signal SIGPIPE, Broken pipe.
0x00007ffff5d87802 in __libc_send (fd=<value optimised out>, 
    buf=0x7ffff7ef5f6f, n=890279, flags=<value optimised out>)
    at ../sysdeps/unix/sysv/linux/x86_64/send.c:28
28	../sysdeps/unix/sysv/linux/x86_64/send.c: No such file or directory.
	in ../sysdeps/unix/sysv/linux/x86_64/send.c

(gdb) bt full
#0  0x00007ffff5d87802 in __libc_send (fd=<value optimised out>, buf=0x7ffff7ef5f6f, n=890279, flags=<value optimised out>) at ../sysdeps/unix/sysv/linux/x86_64/send.c:28
        oldtype = <value optimised out>
        result = <value optimised out>
#1  0x00007ffff6be8573 in drizzle_state_write (con=0x644680) at libdrizzle/conn.c:1010
        ret = 4294967264
        write_size = -1
#2  0x00007ffff6beef7a in drizzle_state_loop (con=0x644680) at libdrizzle/state.c:24
        ret = <value optimised out>
#3  0x00007ffff6be9625 in drizzle_con_command_write (con=0x644680, result=0x7fffffffbcc0, command=DRIZZLE_COMMAND_QUERY, data=0x7ffff7eca028, size=0, total=0, ret_ptr=0x7fffffffb34c) at libdrizzle/conn.c:492
No locals.
#4  0x00007ffff6beb54b in drizzle_query (con=0x5, result=0x7ffff7ef5f6f, query=<value optimised out>, size=<value optimised out>, ret_ptr=<value optimised out>) at libdrizzle/query.c:22
No locals.
#5  0x000000000041a5ce in drizzleclient_real_query_for_lazy (buf=0x7ffff7eca028 "INSERT INTO `BlogPosts` VALUES ('1',NULL,5,1,NULL,'live','2004-05-05 00:53:46','0','First Post...Ever','Whelp...it\\'s my first post. First ever. None like it before. Blatantly obvious perhaps, but it\\"..., length=<value optimised out>, result=0x7fffffffbcc0, error_code=0x7fffffffb3e8) at client/drizzle.cc:2681
        error = 0
        retry = 0
        ret = 32767
#6  0x000000000041a7e2 in com_go (buffer=0x6577d0) at client/drizzle.cc:2810
        time_buff = "\320we\000\000\000\000\000(\240\354\367\377\177\000\000I\000\000\000\000\000\000\000\377\064~\362\377\177", '\000' <repeats 25 times>
        ret = <value optimised out>
        timer = 4085872
        error_code = 0
        buff = "Query OK, 0 rows affecte@\356\001\366\377\177\000\000\340_\020\000\000\000\000\000\340_\020", '\000' <repeats 21 times>"\320, we\000\000\000\000\000\216\303\321\365\377\177\000\000@\306\377\377\377\177\000\000(\000\341\367\377\177\000\000\307\377\017\000\000\000\000\000\327\337}\362\377\177\000\000(\340M\362\377\177\000\000\307_\020\000\000\000\000\000\340_\020\000\000\000\000\000@\356\001\366\377\177\000\000\356T\020\000\000\000\000\000\020\340m\362\377\177\000\000\000\000\000\000\000\000\000\000\263\215\334\365\377\177\000\000;", '\000' <repeats 15 times>, ";\000\000\000\000\000\000"
        result = {con = 0x644680, next = 0x0, prev = 0x0, options = DRIZZLE_RESULT_NONE, info = '\000' <repeats 2047 times>, error_code = 0, sqlstate = "\000\000\000\000\000", insert_id = 0, warning_count = 0, affected_rows = 0, column_count = 0, column_current = 0, column_list = 0x0, column = 0x0, column_buffer = 0x0, row_count = 0, row_current = 0, field_current = 0, field_total = 0, field_offset = 0, field_size = 0, field = 0x0, field_buffer = 0x0, row_list_size = 0, row = 0x0, row_list = 0x0, field_sizes = 0x0, field_sizes_list = 0x0}
        warnings = <value optimised out>
        error = <value optimised out>
#7  0x000000000041c88c in add_line (buffer=0x6577d0, line=<value optimised out>, in_string=<value optimised out>, ml_comment=<value optimised out>) at client/drizzle.cc:2238
        com = 0xffffffffffffffe0
        ss_comment = false
        inchar = <value optimised out>
        pos = 0x7ffff27e34ff ""
        out = 0x7ffff26de010 "INSERT INTO `BlogPosts` VALUES ('1',NULL,5,1,NULL,'live','2004-05-05 00:53:46','0','First Post...Ever','Whelp...it\\'s my first post. First ever. None like it before. Blatantly obvious perhaps, but it\\"...
        need_space = false
        end_of_line = 0x7ffff27e34ff ""
#8  0x000000000041cb51 in read_and_execute (interactive=false) at client/drizzle.cc:1993
        line = 0x7ffff26de010 "INSERT INTO `BlogPosts` VALUES ('1',NULL,5,1,NULL,'live','2004-05-05 00:53:46','0','First Post...Ever','Whelp...it\\'s my first post. First ever. None like it before. Blatantly obvious perhaps, but it\\"...
        in_string = 0 '\000'
        com = 0xffffffffffffffe0
        line_number = 92
        ml_comment = false
#9  0x0000000000422407 in main (argc=<value optimised out>, argv=<value optimised out>) at client/drizzle.cc:1774
        client_options = {static m_default_line_length = 80, m_caption = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x6548a8 "Options specific to the client"}}, m_line_length = 80, m_min_description_length = 40, m_options = {<std::_Vector_base<boost::shared_ptr<boost::program_options::option_description>, std::allocator<boost::shared_ptr<boost::program_options::option_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x655380, _M_finish = 0x6553d0, _M_end_of_storage = 0x655400}}, <No data fields>}, belong_to_group = {<std::_Bvector_base<std::allocator<bool> >> = {_M_impl = {<std::allocator<unsigned long>> = {<__gnu_cxx::new_allocator<unsigned long>> = {<No data fields>}, <No data fields>}, _M_start = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x654e50, _M_offset = 0}, <No data fields>}, _M_finish = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x654e50, _M_offset = 5}, <No data fields>}, _M_end_of_storage = 0x654e58}}, <No data fields>}, groups = {<std::_Vector_base<boost::shared_ptr<boost::program_options::options_description>, std::allocator<boost::shared_ptr<boost::program_options::options_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x0, _M_finish = 0x0, _M_end_of_storage = 0x0}}, <No data fields>}}
        p = {m_names = {<std::_Vector_base<std::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::basic_string<char, std::char_traits<char>, std::allocator<char> > > >> = {_M_impl = {<std::allocator<std::basic_string<char, std::char_traits<char>, std::allocator<char> > >> = {<__gnu_cxx::new_allocator<std::basic_string<char, std::char_traits<char>, std::allocator<char> > >> = {<No data fields>}, <No data fields>}, _M_start = 0x6559f0, _M_finish = 0x6559f8, _M_end_of_storage = 0x6559f8}}, <No data fields>}, m_trailing = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x63d8f8 ""}}}
        output_buff = {<std::_Vector_base<char, std::allocator<char> >> = {_M_impl = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_start = 0x658880 "Your Drizzle connection id is 4\nConnection protocol: mysql\nServer version: 2010.10.1874 Source distribution (trunk)\n", _M_finish = 0x658a80 "0", _M_end_of_storage = 0x658a80 "0"}}, <No data fields>}
        drizzle_options = {static m_default_line_length = 80, m_caption = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x651b58 "Options specific to the drizzle client"}}, m_line_length = 80, m_min_description_length = 40, m_options = {<std::_Vector_base<boost::shared_ptr<boost::program_options::option_description>, std::allocator<boost::shared_ptr<boost::program_options::option_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x653fc0, _M_finish = 0x654140, _M_end_of_storage = 0x6541c0}}, <No data fields>}, belong_to_group = {<std::_Bvector_base<std::allocator<bool> >> = {_M_impl = {<std::allocator<unsigned long>> = {<__gnu_cxx::new_allocator<unsigned long>> = {<No data fields>}, <No data fields>}, _M_start = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x652bf0, _M_offset = 0}, <No data fields>}, _M_finish = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x652bf0, _M_offset = 24}, <No data fields>}, _M_end_of_storage = 0x652bf8}}, <No data fields>}, groups = {<std::_Vector_base<boost::shared_ptr<boost::program_options::options_description>, std::allocator<boost::shared_ptr<boost::program_options::options_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x0, _M_finish = 0x0, _M_end_of_storage = 0x0}}, <No data fields>}}
        long_options = {static m_default_line_length = 80, m_caption = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x6550f8 "Allowed Options"}}, m_line_length = 80, m_min_description_length = 40, m_options = {<std::_Vector_base<boost::shared_ptr<boost::program_options::option_description>, std::allocator<boost::shared_ptr<boost::program_options::option_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x655c00, _M_finish = 0x655f30, _M_end_of_storage = 0x656000}}, <No data fields>}, belong_to_group = {<std::_Bvector_base<std::allocator<bool> >> = {_M_impl = {<std::allocator<unsigned long>> = {<__gnu_cxx::new_allocator<unsigned long>> = {<No data fields>}, <No data fields>}, _M_start = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x655670, _M_offset = 0}, <No data fields>}, _M_finish = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x655670, _M_offset = 51}, <No data fields>}, _M_end_of_storage = 0x655678}}, <No data fields>}, groups = {<std::_Vector_base<boost::shared_ptr<boost::program_options::options_description>, std::allocator<boost::shared_ptr<boost::program_options::options_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x655160, _M_finish = 0x655190, _M_end_of_storage = 0x6551a0}}, <No data fields>}}
        system_config_dir_client = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x655948 "/home/linuxjedi/Programming/Builds/drizzle-trunk/etc/drizzle/client.cnf"}}
        user_config_dir = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x6556a8 "~/.config"}}
        vm = <incomplete type>
        commandline_options = {static m_default_line_length = 80, m_caption = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x64f1b8 "Options used only in command line"}}, m_line_length = 80, m_min_description_length = 40, m_options = {<std::_Vector_base<boost::shared_ptr<boost::program_options::option_description>, std::allocator<boost::shared_ptr<boost::program_options::option_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::option_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x651550, _M_finish = 0x6516b0, _M_end_of_storage = 0x651750}}, <No data fields>}, belong_to_group = {<std::_Bvector_base<std::allocator<bool> >> = {_M_impl = {<std::allocator<unsigned long>> = {<__gnu_cxx::new_allocator<unsigned long>> = {<No data fields>}, <No data fields>}, _M_start = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x64ff30, _M_offset = 0}, <No data fields>}, _M_finish = {<std::_Bit_iterator_base> = {<std::iterator<std::random_access_iterator_tag, bool, long, bool*, bool&>> = {<No data fields>}, _M_p = 0x64ff30, _M_offset = 22}, <No data fields>}, _M_end_of_storage = 0x64ff38}}, <No data fields>}, groups = {<std::_Vector_base<boost::shared_ptr<boost::program_options::options_description>, std::allocator<boost::shared_ptr<boost::program_options::options_description> > >> = {_M_impl = {<std::allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<__gnu_cxx::new_allocator<boost::shared_ptr<boost::program_options::options_description> >> = {<No data fields>}, <No data fields>}, _M_start = 0x0, _M_finish = 0x0, _M_end_of_storage = 0x0}}, <No data fields>}}
        system_config_dir_drizzle = {static npos = <optimized out>, _M_dataplus = {<std::allocator<char>> = {<__gnu_cxx::new_allocator<char>> = {<No data fields>}, <No data fields>}, _M_p = 0x6558b8 "/home/linuxjedi/Programming/Builds/drizzle-trunk/etc/drizzle/drizzle.cnf"}}
        command_error = <value optimised out>

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-25:

#12

OK, so, rundown of what is happening:

1. Client sends just over 1MB of data
2. Drizzle server drizzleclient_net_read() returns ER_NET_PACKET_TOO_LARGE
3. Drizzle server forces disconnect due to error
4. send() function SIGPIPE as connection just died

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-25:

#13

How to fix:

1. Don't SIGPIPE here, error instead (done in branch attached to bug)
2. Investigate drizzledump's large output
3. Investigate packet size issues

Changed in drizzle:
status:	Triaged → In Progress

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-25:

#14

4. Make this error about max packet size instead of lost server

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-26:

#15

Whilst testing the fixes for this also found bug#666997 using your data.

Revision history for this message

m00dawg (tim-moocowproductions) wrote on 2010-10-26:

#16

Hah, I guess glad my schema is particularly problematic? :) More bugs squashed at least :) Thanks for looking into these Andrew! I'm excited to try the new fixes!

Revision history for this message

Andrew Hutchings (linuxjedi) wrote on 2010-10-26:

#17

Hehe, its good these things are tested, thanks for the data, it has proved very useful. This particular bug actually wasn't anything really to do with drizzledump migration, it appears to be a long standing bug affecting all drizzle client connections.
As for the new one, a nice new edge case, should be much easier to fix :)

Drizzle

Importing SQL script results in silent failure

Bug Description

Related branches

Other bug subscribers

Bug attachments

Remote bug watches

Affects		Status	Importance	Assigned to	Milestone
	Drizzle	Fix Released	High	Andrew Hutchings	Drizzle 2010-11-08
	7.0	Fix Released	High	Andrew Hutchings	Drizzle 2010-11-08