Drizzle

Segfault when dumping schema with drizzledump

Bug #652990 reported by m00dawg
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
High
Andrew Hutchings
Drizzle 2010-10-11
7.0
Fix Released
High
Andrew Hutchings
Drizzle 2010-10-11

Bug Description

After figuring out my permissions issues (see https://bugs.launchpad.net/drizzle/+bug/652645), I am now getting a segmentation fault when trying to dump out my MySQL schema using 'drizzledump':

root@mcp:~# drizzledump -p3306 -uroot -P<omitted>
-- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
--
-- Host: localhost Database: moocowproductions
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.6 (MySQL server)

Segmentation fault

Here is an strace:

root@mcp:~# strace drizzledump -p3306 -uroot -P<omitted>
execve("/usr/bin/drizzledump", ["drizzledump", "-p3306", "-uroot", "-PtD2sMQamlWnZZuCd", "moocowproductions"], [/* 14 vars */]) = 0
brk(0) = 0x1b27000
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd1000
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=58632, ...}) = 0
mmap(NULL, 58632, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fb76cbc2000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libz.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\"\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=92752, ...}) = 0
mmap(NULL, 2187792, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c79c000
mprotect(0x7fb76c7b2000, 2093056, PROT_NONE) = 0
mmap(0x7fb76c9b1000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fb76c9b1000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libdrizzle.so.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240Q\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=80744, ...}) = 0
mmap(NULL, 2175856, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c588000
mprotect(0x7fb76c59b000, 2093056, PROT_NONE) = 0
mmap(0x7fb76c79a000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x12000) = 0x7fb76c79a000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libboost_program_options.so.1.40.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\v\2\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=319896, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbc1000
mmap(NULL, 2415096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c33a000
mprotect(0x7fb76c385000, 2093056, PROT_NONE) = 0
mmap(0x7fb76c584000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4a000) = 0x7fb76c584000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libboost_thread.so.1.40.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\260\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=88920, ...}) = 0
mmap(NULL, 2184088, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c124000
mprotect(0x7fb76c138000, 2093056, PROT_NONE) = 0
mmap(0x7fb76c337000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x7fb76c337000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libboost_regex.so.1.40.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\272\4\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=992320, ...}) = 0
mmap(NULL, 3087928, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76be32000
mprotect(0x7fb76bf1d000, 2097152, PROT_NONE) = 0
mmap(0x7fb76c11d000, 28672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xeb000) = 0x7fb76c11d000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libboost_date_time.so.1.40.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\231\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=76400, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbc0000
mmap(NULL, 2171488, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76bc1f000
mprotect(0x7fb76bc30000, 2093056, PROT_NONE) = 0
mmap(0x7fb76be2f000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x10000) = 0x7fb76be2f000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libboost_filesystem.so.1.40.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200\227\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=84992, ...}) = 0
mmap(NULL, 2180304, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76ba0a000
mprotect(0x7fb76ba1d000, 2097152, PROT_NONE) = 0
mmap(0x7fb76bc1d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x7fb76bc1d000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libboost_system.so.1.40.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\24\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=14560, ...}) = 0
mmap(NULL, 2109704, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b806000
mprotect(0x7fb76b809000, 2093056, PROT_NONE) = 0
mmap(0x7fb76ba08000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7fb76ba08000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/librt.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220!\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=31744, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbf000
mmap(NULL, 2128848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b5fe000
mprotect(0x7fb76b605000, 2093056, PROT_NONE) = 0
mmap(0x7fb76b804000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6000) = 0x7fb76b804000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libstdc++.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\244\5\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=1044112, ...}) = 0
mmap(NULL, 3223608, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b2ea000
mprotect(0x7fb76b3e0000, 2097152, PROT_NONE) = 0
mmap(0x7fb76b5e0000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf6000) = 0x7fb76b5e0000
mmap(0x7fb76b5e9000, 81976, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76b5e9000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libm.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360>\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=534832, ...}) = 0
mmap(NULL, 2629864, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76b067000
mprotect(0x7fb76b0e9000, 2093056, PROT_NONE) = 0
mmap(0x7fb76b2e8000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x81000) = 0x7fb76b2e8000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libgcc_s.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200-\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=92552, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbe000
mmap(NULL, 2188280, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76ae50000
mprotect(0x7fb76ae66000, 2093056, PROT_NONE) = 0
mmap(0x7fb76b065000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fb76b065000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libc.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\355\1\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1572232, ...}) = 0
mmap(NULL, 3680296, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76aacd000
mprotect(0x7fb76ac47000, 2093056, PROT_NONE) = 0
mmap(0x7fb76ae46000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x179000) = 0x7fb76ae46000
mmap(0x7fb76ae4b000, 18472, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76ae4b000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360Y\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=135745, ...}) = 0
mmap(NULL, 2212736, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76a8b0000
mprotect(0x7fb76a8c8000, 2093056, PROT_NONE) = 0
mmap(0x7fb76aac7000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17000) = 0x7fb76aac7000
mmap(0x7fb76aac9000, 13184, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76aac9000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libicudata.so.42", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\350\2\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=16012096, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbd000
mmap(NULL, 18108416, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76976b000
mprotect(0x7fb76a6b0000, 2093056, PROT_NONE) = 0
mmap(0x7fb76a8af000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf44000) = 0x7fb76a8af000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libicui18n.so.42", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200Y\6\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=1799848, ...}) = 0
mmap(NULL, 3897408, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb7693b3000
mprotect(0x7fb76955d000, 2097152, PROT_NONE) = 0
mmap(0x7fb76975d000, 53248, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1aa000) = 0x7fb76975d000
mmap(0x7fb76976a000, 2112, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb76976a000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/usr/lib/libicuuc.so.42", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200/\4\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=1413488, ...}) = 0
mmap(NULL, 3516704, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb769058000
mprotect(0x7fb7691a0000, 2097152, PROT_NONE) = 0
mmap(0x7fb7693a0000, 69632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x148000) = 0x7fb7693a0000
mmap(0x7fb7693b1000, 6432, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fb7693b1000
close(3) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbc000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbbb000
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbb9000
arch_prctl(ARCH_SET_FS, 0x7fb76cbb9720) = 0
mprotect(0x7fb7693a0000, 57344, PROT_READ) = 0
mprotect(0x7fb76975d000, 40960, PROT_READ) = 0
mprotect(0x7fb76a8af000, 4096, PROT_READ) = 0
mprotect(0x7fb76aac7000, 4096, PROT_READ) = 0
mprotect(0x7fb76ae46000, 16384, PROT_READ) = 0
mprotect(0x7fb76b065000, 4096, PROT_READ) = 0
mprotect(0x7fb76b2e8000, 4096, PROT_READ) = 0
mprotect(0x7fb76b5e0000, 28672, PROT_READ) = 0
mprotect(0x7fb76b804000, 4096, PROT_READ) = 0
mprotect(0x7fb76ba08000, 4096, PROT_READ) = 0
mprotect(0x7fb76bc1d000, 4096, PROT_READ) = 0
mprotect(0x7fb76be2f000, 8192, PROT_READ) = 0
mprotect(0x7fb76c11d000, 20480, PROT_READ) = 0
mprotect(0x7fb76c337000, 8192, PROT_READ) = 0
mprotect(0x7fb76c584000, 12288, PROT_READ) = 0
mprotect(0x7fb76c79a000, 4096, PROT_READ) = 0
mprotect(0x7fb76c9b1000, 4096, PROT_READ) = 0
mprotect(0x653000, 4096, PROT_READ) = 0
mprotect(0x7fb76cbd3000, 4096, PROT_READ) = 0
munmap(0x7fb76cbc2000, 58632) = 0
set_tid_address(0x7fb76cbb99f0) = 18219
set_robust_list(0x7fb76cbb9a00, 0x18) = 0
futex(0x7ffff0de373c, FUTEX_WAKE_PRIVATE, 1) = 0
futex(0x7ffff0de373c, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7fb76cbb9720) = -1 EAGAIN (Resource temporarily unavailable)
rt_sigaction(SIGRTMIN, {0x7fb76a8b5870, [], SA_RESTORER|SA_SIGINFO, 0x7fb76a8bf8f0}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x7fb76a8b5900, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x7fb76a8bf8f0}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0
brk(0) = 0x1b27000
brk(0x1b48000) = 0x1b48000
futex(0x7fb76b5e9b88, FUTEX_WAKE_PRIVATE, 2147483647) = 0
open("~/.config/drizzle/drizzledump.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
open("~/.config/drizzle/client.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/drizzle/drizzledump.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/drizzle/client.cnf", O_RDONLY) = -1 ENOENT (No such file or directory)
socket(PF_NETLINK, SOCK_RAW, 0) = 3
bind(3, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0
getsockname(3, {sa_family=AF_NETLINK, pid=18219, groups=00000000}, [12]) = 0
gettimeofday({1285939136, 123304}, NULL) = 0
sendto(3, "\24\0\0\0\26\0\1\3\300\337\245L\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20
recvmsg(3, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"0\0\0\0\24\0\2\0\300\337\245L+G\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 168
recvmsg(3, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"@\0\0\0\24\0\2\0\300\337\245L+G\0\0\n\200\200\376\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 192
recvmsg(3, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0\300\337\245L+G\0\0\0\0\0\0\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 20
close(3) = 0
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(3) = 0
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(3) = 0
open("/etc/nsswitch.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=475, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
read(3, "# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 475
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7fb76cbd0000, 4096) = 0
open("/etc/host.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=92, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
read(3, "# The \"order\" line is only used "..., 4096) = 92
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7fb76cbd0000, 4096) = 0
futex(0x7fb76ae4e2e4, FUTEX_WAKE_PRIVATE, 2147483647) = 0
open("/etc/resolv.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=47, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
read(3, "nameserver 72.3.128.240\nnameserv"..., 4096) = 47
read(3, "", 4096) = 0
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7fb76cbd0000, 4096) = 0
uname({sys="Linux", node="mcp.moocowproductions.org", ...}) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=58632, ...}) = 0
mmap(NULL, 58632, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fb76cbc2000
close(3) = 0
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
open("/lib/libnss_files.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p!\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0644, st_size=51712, ...}) = 0
mmap(NULL, 2147720, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb768e4b000
mprotect(0x7fb768e57000, 2093056, PROT_NONE) = 0
mmap(0x7fb769056000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xb000) = 0x7fb769056000
close(3) = 0
mprotect(0x7fb769056000, 4096, PROT_READ) = 0
munmap(0x7fb76cbc2000, 58632) = 0
open("/etc/hosts", O_RDONLY|O_CLOEXEC) = 3
fcntl(3, F_GETFD) = 0x1 (flags FD_CLOEXEC)
fstat(3, {st_mode=S_IFREG|0644, st_size=336, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
read(3, "127.0.0.1 localhost localhos"..., 4096) = 336
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7fb76cbd0000, 4096) = 0
open("/etc/gai.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=2987, ...}) = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=2987, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
read(3, "# Configuration for getaddrinfo("..., 4096) = 2987
read(3, "", 4096) = 0
close(3) = 0
munmap(0x7fb76cbd0000, 4096) = 0
futex(0x7fb76ae4ce04, FUTEX_WAKE_PRIVATE, 2147483647) = 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 3
connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
getsockname(3, {sa_family=AF_INET, sin_port=htons(35014), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
close(3) = 0
socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 3
connect(3, {sa_family=AF_INET6, sin6_port=htons(3306), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = 0
getsockname(3, {sa_family=AF_INET6, sin6_port=htons(42320), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, [28]) = 0
close(3) = 0
socket(PF_INET6, SOCK_STREAM, IPPROTO_TCP) = 3
setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
setsockopt(3, SOL_SOCKET, SO_LINGER, {onoff=1, linger=10}, 8) = 0
setsockopt(3, SOL_SOCKET, SO_SNDTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(3, SOL_SOCKET, SO_RCVTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(3, SOL_SOCKET, SO_SNDBUF, [32768], 4) = 0
setsockopt(3, SOL_SOCKET, SO_RCVBUF, [32768], 4) = 0
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_INET6, sin6_port=htons(3306), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = -1 EINPROGRESS (Operation now in progress)
poll([{fd=3, events=POLLOUT}], 1, -1) = 1 ([{fd=3, revents=POLLERR|POLLHUP}])
close(3) = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 3
setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
setsockopt(3, SOL_SOCKET, SO_LINGER, {onoff=1, linger=10}, 8) = 0
setsockopt(3, SOL_SOCKET, SO_SNDTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(3, SOL_SOCKET, SO_RCVTIMEO, "\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(3, SOL_SOCKET, SO_SNDBUF, [32768], 4) = 0
setsockopt(3, SOL_SOCKET, SO_RCVBUF, [32768], 4) = 0
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EINPROGRESS (Operation now in progress)
poll([{fd=3, events=POLLOUT}], 1, -1) = 1 ([{fd=3, revents=POLLOUT}])
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "@\0\0\0\n5.1.41-3ubuntu12.6\0\227\1\0\0QXE/"..., 32768, 0, NULL, NULL) = 68
sendto(3, ";\0\0\1\5\242\0\0\377\377\377\377\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 63, 0, NULL, 0) = 63
recvfrom(3, "\7\0\0\2\0\0\0\2\0\0\0", 32768, 0, NULL, NULL) = 11
sendto(3, "\21\0\0\0\3SET NAMES 'utf8'", 21, 0, NULL, 0) = 21
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 32768, 0, NULL, NULL) = 11
fstat(1, {st_mode=S_IFCHR|0600, st_rdev=makedev(136, 0), ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd0000
write(1, "-- drizzledump 2010.09.1802 libd"..., 68-- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
) = 68
write(1, "--\n", 3--
) = 3
write(1, "-- Host: localhost Database: "..., 50-- Host: localhost Database: moocowproductions
) = 50
write(1, "-- -----------------------------"..., 58-- ------------------------------------------------------
) = 58
write(1, "-- Server version\t5.1.41-3ubuntu"..., 52-- Server version 5.1.41-3ubuntu12.6 (MySQL server)
) = 52
write(1, "\n", 1
) = 1
sendto(3, "\22\0\0\0\2moocowproductions", 22, 0, NULL, 0) = 22
recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 32768, 0, NULL, NULL) = 11
sendto(3, "\225\0\0\0\3SELECT TABLE_NAME, TABLE_CO"..., 153, 0, NULL, 0) = 153
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\0040\0\0\2\3def\0\6TABLES\0\nTABLE_NAM"..., 32768, 0, NULL, NULL) = 1564
brk(0x1b75000) = 0x1b75000
sendto(3, "\6\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 266, 0, NULL, 0) = 266
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 1032
brk(0x1ba4000) = 0x1ba4000
sendto(3, "\26\0\0\0\3SHOW INDEXES FROM Art", 26, 0, NULL, 0) = 26
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 708
brk(0x1bc6000) = 0x1bc6000
brk(0x1bb6000) = 0x1bb6000
sendto(3, "\21\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 277, 0, NULL, 0) = 277
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 726
sendto(3, "!\0\0\0\3SHOW INDEXES FROM BlogCateg"..., 37, 0, NULL, 0) = 37
recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 778
sendto(3, "\17\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 275, 0, NULL, 0) = 275
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 918
sendto(3, "\37\0\0\0\3SHOW INDEXES FROM BlogComme"..., 35, 0, NULL, 0) = 35
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 778
sendto(3, "\f\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 272, 0, NULL, 0) = 272
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 722
sendto(3, "\34\0\0\0\3SHOW INDEXES FROM BlogMoods", 32, 0, NULL, 0) = 32
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 715
sendto(3, "\f\1\0\0\3SELECT COLUMN_NAME, COLUMN_"..., 272, 0, NULL, 0) = 272
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\t3\0\0\2\3def\0\7COLUMNS\0\vCOLUMN_N"..., 32768, 0, NULL, NULL) = 1025
sendto(3, "\34\0\0\0\3SHOW INDEXES FROM BlogPosts", 32, 0, NULL, 0) = 32
recvfrom(3, 0x1b316e0, 32768, 0, 0, 0) = -1 EAGAIN (Resource temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\1\0\0\1\f/\0\0\2\3def\0\nSTATISTICS\0\5Table"..., 32768, 0, NULL, NULL) = 825
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV +++
Segmentation fault

I suspect it may have something to do with stored procedures and triggers and being in my SQL schema. I was hoping drizzledump would just filter them out. I will do more testing to see what may be going on once I have more time, but thought I would send this along.

Related branches

lp:~linuxjedi/drizzle/elliott-bug-652990
Drizzle Merge Team: Pending requested
Diff: 11 lines (+1/-1)
1 file modified
client/drizzledump_mysql.cc (+1/-1)
Andrew Hutchings (linuxjedi)
Changed in drizzle:
assignee: nobody → Andrew Hutchings (linuxjedi)
Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

It is very likely to be some kind of case where it thinks something exists that doesn't. Although it should not be attempting to look at triggers or stored procs.

Is it possible you could run:

shell> gdb --args drizzledump -p3306 -uroot -P<omitted>

Then in the gdb console:

gdb> run

And when it segfaults:

gdb> bt

This should give a stack of where it failed. I suspect it is an unhandled error condition (but I'm kinda hoping its not). Most likely trying to find out about whatever table comes after BlogPosts.

Changed in drizzle:
importance: Undecided → High
Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

A thought occurs, do you have any VIEWS in you DB?

Revision history for this message
m00dawg (tim-moocowproductions) wrote : Re: [Bug 652990] Re: Segfault when dumping schema with drizzledump
Download full text (29.7 KiB)

Yep, sure do:

mysql> show create table BlogPostsView\G
*************************** 1. row ***************************
                View: BlogPostsView
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `BlogPostsView` AS select `BlogPosts`.`postID` AS `postid`,`BlogPosts`.`title` AS `title`,`BlogPosts`.`body` AS `body`,`BlogCategories`.`name` AS `category`,`BlogMoods`.`name` AS `mood`,`BlogPosts`.`postTime` AS `posttime`,`BlogPosts`.`lastModified` AS `lastmodified`,`BlogPosts`.`status` AS `status`,`BlogPosts`.`commentCount` AS `commentcount` from ((`BlogPosts` join `BlogMoods` on((`BlogMoods`.`moodID` = `BlogPosts`.`moodID`))) join `BlogCategories` on((`BlogCategories`.`categoryID` = `BlogPosts`.`categoryID`)))
character_set_client: latin1
collation_connection: latin1_swedish_ci
1 row in set (0.01 sec)

mysql> show create table PhotoDawgPhotoView\G
*************************** 1. row ***************************
                View: PhotoDawgPhotoView
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `PhotoDawgPhotoView` AS select `PhotoDawgPhotos`.`photoID` AS `photoID`,`PhotoDawgLenses`.`lensID` AS `lensID`,`PhotoDawgPhotoDetails`.`title` AS `title`,`PhotoDawgPhotoDetails`.`caption` AS `caption`,`PhotoDawgPhotos`.`filename` AS `filename`,`PhotoDawgPhotos`.`takenOn` AS `takenOn`,`PhotoDawgPhotos`.`ranking` AS `ranking`,`PhotoDawgPhotoDetails`.`cameraMake` AS `cameraMake`,`PhotoDawgPhotoDetails`.`cameraModel` AS `cameraModel`,`PhotoDawgPhotoDetails`.`isoSpeed` AS `isoSpeed`,`PhotoDawgPhotoDetails`.`exposureTime` AS `exposureTime`,`PhotoDawgPhotoDetails`.`exposureValue` AS `exposureValue`,`PhotoDawgPhotoDetails`.`aperture` AS `aperture`,`PhotoDawgPhotoDetails`.`maxAperture` AS `maxAperture`,`PhotoDawgPhotoDetails`.`focalLength` AS `focalLength`,`PhotoDawgPhotoDetails`.`flash` AS `flash`,`PhotoDawgLenses`.`lensName` AS `lensUsed` from ((`PhotoDawgPhotos` left join `PhotoDawgPhotoDetails` on((`PhotoDawgPhotoDetails`.`photoID` = `PhotoDawgPhotos`.`photoID`))) left join `PhotoDawgLenses` on((`PhotoDawgLenses`.`lensID` = `PhotoDawgPhotoDetails`.`lensID`)))
character_set_client: latin1
collation_connection: latin1_swedish_ci
1 row in set (0.00 sec)

I know these won't carry over, though. I assumed drizzledump would just ignore these?

On Oct 1, 2010, at 11:05 AM, Andrew Hutchings wrote:

> A thought occurs, do you have any VIEWS in you DB?
>
> --
> Segfault when dumping schema with drizzledump
> https://bugs.launchpad.net/bugs/652990
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications: New
>
> Bug description:
> After figuring out my permissions issues (see https://bugs.launchpad.net/drizzle/+bug/652645), I am now getting a segmentation fault when trying to dump out my MySQL schema using 'drizzledump':
>
>
> root@mcp:~# drizzledump -p3306 -uroot -P<omitted>
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost Database: moocowproductions
> -- ---------------------------...

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

Drizzledump should ignore these, unfortunately it doesn't. It sees them as a table with a NULL engine, the engine is then tested for conversion which causes the segfault you see. So a big Doh! on my part for not thinking about how MySQL sees views as tables.

I have just created a fix which I'm testing now.

Changed in drizzle:
status: New → In Progress
milestone: none → 2010-10-11
Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

Committed a fix for this. Thanks again for spotting it and I'm apologise for the bumpy ride you are having with this.

Changed in drizzle:
status: In Progress → Fix Committed
Revision history for this message
m00dawg (tim-moocowproductions) wrote :
Download full text (27.8 KiB)

Not a problem! Glad we found the bugs. I'll see about pulling down the changes and giving them a go on my schema.

Thanks for squashing this one quickly!

On Oct 1, 2010, at 11:43 AM, Andrew Hutchings wrote:

> Committed a fix for this. Thanks again for spotting it and I'm
> apologise for the bumpy ride you are having with this.
>
> ** Changed in: drizzle
> Status: In Progress => Fix Committed
>
> ** Changed in: drizzle/elliott
> Status: In Progress => Fix Committed
>
> --
> Segfault when dumping schema with drizzledump
> https://bugs.launchpad.net/bugs/652990
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications: Fix Committed
> Status in Drizzle elliott series: Fix Committed
>
> Bug description:
> After figuring out my permissions issues (see https://bugs.launchpad.net/drizzle/+bug/652645), I am now getting a segmentation fault when trying to dump out my MySQL schema using 'drizzledump':
>
>
> root@mcp:~# drizzledump -p3306 -uroot -P<omitted>
> -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> --
> -- Host: localhost Database: moocowproductions
> -- ------------------------------------------------------
> -- Server version 5.1.41-3ubuntu12.6 (MySQL server)
>
> Segmentation fault
>
>
> Here is an strace:
>
>
> root@mcp:~# strace drizzledump -p3306 -uroot -P<omitted>
> execve("/usr/bin/drizzledump", ["drizzledump", "-p3306", "-uroot", "-PtD2sMQamlWnZZuCd", "moocowproductions"], [/* 14 vars */]) = 0
> brk(0) = 0x1b27000
> access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
> mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fb76cbd1000
> access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
> open("/etc/ld.so.cache", O_RDONLY) = 3
> fstat(3, {st_mode=S_IFREG|0644, st_size=58632, ...}) = 0
> mmap(NULL, 58632, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fb76cbc2000
> close(3) = 0
> access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
> open("/lib/libz.so.1", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\"\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=92752, ...}) = 0
> mmap(NULL, 2187792, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c79c000
> mprotect(0x7fb76c7b2000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76c9b1000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fb76c9b1000
> close(3) = 0
> access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
> open("/usr/lib/libdrizzle.so.0", O_RDONLY) = 3
> read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240Q\0\0\0\0\0\0"..., 832) = 832
> fstat(3, {st_mode=S_IFREG|0644, st_size=80744, ...}) = 0
> mmap(NULL, 2175856, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fb76c588000
> mprotect(0x7fb76c59b000, 2093056, PROT_NONE) = 0
> mmap(0x7fb76c79a000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|...

Revision history for this message
Patrick Crews (patrick-crews) wrote :
Download full text (56.9 KiB)

Thanks for all the great feedback on the tool! It's awesome to get
information on how the tool performs for real users. Fortunately, Andrew is
a superhuman bug-fixing machine so things are pretty much fixed as soon as
the bug is written up : )

On Fri, Oct 1, 2010 at 1:52 PM, m00dawg <email address hidden> wrote:

> Not a problem! Glad we found the bugs. I'll see about pulling down the
> changes and giving them a go on my schema.
>
> Thanks for squashing this one quickly!
>
> On Oct 1, 2010, at 11:43 AM, Andrew Hutchings wrote:
>
> > Committed a fix for this. Thanks again for spotting it and I'm
> > apologise for the bumpy ride you are having with this.
> >
> > ** Changed in: drizzle
> > Status: In Progress => Fix Committed
> >
> > ** Changed in: drizzle/elliott
> > Status: In Progress => Fix Committed
> >
> > --
> > Segfault when dumping schema with drizzledump
> > https://bugs.launchpad.net/bugs/652990
> > You received this bug notification because you are a direct subscriber
> > of the bug.
> >
> > Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications: Fix Committed
> > Status in Drizzle elliott series: Fix Committed
> >
> > Bug description:
> > After figuring out my permissions issues (see
> https://bugs.launchpad.net/drizzle/+bug/652645), I am now getting a
> segmentation fault when trying to dump out my MySQL schema using
> 'drizzledump':
> >
> >
> > root@mcp:~# drizzledump -p3306 -uroot -P<omitted>
> > -- drizzledump 2010.09.1802 libdrizzle 7, for pc-linux-gnu (x86_64)
> > --
> > -- Host: localhost Database: moocowproductions
> > -- ------------------------------------------------------
> > -- Server version 5.1.41-3ubuntu12.6 (MySQL server)
> >
> > Segmentation fault
> >
> >
> > Here is an strace:
> >
> >
> > root@mcp:~# strace drizzledump -p3306 -uroot -P<omitted>
> > execve("/usr/bin/drizzledump", ["drizzledump", "-p3306", "-uroot",
> "-PtD2sMQamlWnZZuCd", "moocowproductions"], [/* 14 vars */]) = 0
> > brk(0) = 0x1b27000
> > access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or
> directory)
> > mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
> = 0x7fb76cbd1000
> > access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or
> directory)
> > open("/etc/ld.so.cache", O_RDONLY) = 3
> > fstat(3, {st_mode=S_IFREG|0644, st_size=58632, ...}) = 0
> > mmap(NULL, 58632, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fb76cbc2000
> > close(3) = 0
> > access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or
> directory)
> > open("/lib/libz.so.1", O_RDONLY) = 3
> > read(3,
> "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\"\0\0\0\0\0\0"..., 832) =
> 832
> > fstat(3, {st_mode=S_IFREG|0644, st_size=92752, ...}) = 0
> > mmap(NULL, 2187792, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0)
> = 0x7fb76c79c000
> > mprotect(0x7fb76c7b2000, 2093056, PROT_NONE) = 0
> > mmap(0x7fb76c9b1000, 8192, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fb76c9b1000
> > close(3) = 0
> > access("/etc/ld.so.nohwcap", F_OK) ...

Lee Bieber (kalebral-deactivatedaccount)
Changed in drizzle:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.