Bug#765310: marked as done (sqlitebrowser: Executing SQL statements produced by dump makes program crash)

Thu, 15 Jan 2015 22:39:37 -0800 

Your message dated Fri, 16 Jan 2015 08:27:31 +0200
with message-id <[email protected]>
and subject line Fixed in the new upstream version
has caused the Debian Bug report #765310,
regarding sqlitebrowser: Executing SQL statements produced by dump makes 
program crash
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
765310: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=765310
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message --- 
Package: sqlitebrowser
Version: 2.0.0~beta1+ds.1-3
Severity: normal



-- System Information:
Debian Release: 7.6
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.2.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=fi_FI.UTF-8, LC_CTYPE=fi_FI.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages sqlitebrowser depends on:
ii  libc6              2.13-38+deb7u4
ii  libgcc1            1:4.7.2-5
ii  libqt4-qt3support  4:4.8.2+dfsg-11
ii  libqtcore4         4:4.8.2+dfsg-11
ii  libqtgui4          4:4.8.2+dfsg-11
ii  libsqlite3-0       3.7.13-1+deb7u1
ii  libstdc++6         4.7.2-5

sqlitebrowser recommends no packages.

sqlitebrowser suggests no packages.

-- no debconf information

I created a database with sqlitebrower "New Database" menu item. Made
a dump with menu item "Export" | "Database to SQL file". Exited
sqlitebrowser. 

Started it again, pasted the dump in Execute SQL window. Crashes every
time. 

The dump file:

$ cat lapasqlite.dump

$ cat lapasqlite.sql 
BEGIN TRANSACTION;
CREATE TABLE palkanmaksut (Avain INTEGER PRIMARY KEY, inumber NUMERIC,
payday TEXT);
INSERT INTO palkanmaksut VALUES(1,NULL,NULL);
COMMIT;


Running with LANG=C strace sqlitebrowser, last umpteen lines of output:

recvfrom(8,
"\332\334\336\0\344\345\347\0\222\224\226\0\373\373\373\0\377\377\377\0\377\377\377\0\377\377\377\0\377\377\377\0"...,
9948, 0, NULL, NULL) = 9948
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
poll([{fd=8, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=8,
revents=POLLOUT}])
writev(8,
[{"F\30\5\0\361\0\0\6\10\0\0\6\0\0\0\0q\0\37\0\230\4\6\0\365\0\0\6\361\0\0\6"...,
6032}, {NULL, 0}, {"", 0}], 3) = 6032
poll([{fd=8, events=POLLIN}], 1, -1)    = 1 ([{fd=8, revents=POLLIN}])
recvfrom(8,
"\1\30y\4\257\r\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
4096, 0, NULL, NULL) = 4096
recvfrom(8,
"\333\335\337\0\344\345\347\0\222\224\226\0\373\373\373\0\377\377\377\0\377\377\377\0\377\377\377\0\377\377\377\0"...,
9948, 0, NULL, NULL) = 9948
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
poll([{fd=8, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=8,
revents=POLLOUT}])
writev(8,
[{"6\30\2\0\361\0\0\0065\30\4\0\367\0\0\6\3\0\0\6k\0\31\0F\0\5\0\367\0\0\6"...,
252}, {NULL, 0}, {"", 0}], 3) = 252
poll([{fd=8, events=POLLIN}], 1, -1)    = 1 ([{fd=8, revents=POLLIN}])
recvfrom(8,
"\1\30\204\4s\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
4096, 0, NULL, NULL) = 4096
recvfrom(8,
"\32\25\21\0\32\25\21\0\32\25\21\0\32\25\21\0\32\25\21\0\32\25\21\0\32\25\21\0\32\25\21\0"...,
6636, 0, NULL, NULL) = 6636
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
poll([{fd=8, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=8,
revents=POLLOUT}])
writev(8,
[{"F\30\5\0\367\0\0\6\10\0\0\6\0\0\0\0k\0\31\0\230\"\23\0\372\0\0\6\0\0\0\0"...,
228}, {NULL, 0}, {"", 0}], 3) = 228
poll([{fd=8, events=POLLIN}], 1, -1)    = 1 ([{fd=8, revents=POLLIN}])
recvfrom(8,
"\1\30\215\4s\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
4096, 0, NULL, NULL) = 4096
recvfrom(8,
"\373\366\362\0\373\366\362\0\373\366\362\0\373\366\362\0\373\366\362\0\373\366\362\0\373\366\362\0\373\366\362\0"...,
6636, 0, NULL, NULL) = 6636
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
recvfrom(8, 0xce18e4, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
poll([{fd=6, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=6,
revents=POLLOUT}])
writev(6,
[{"\216\3\n\0\f\0\340\5\16\0\340\5\276\2(\2\r\0+\1q\0\37\0\r\0+\1\30\2\0\0"...,
40}, {NULL, 0}, {"", 0}], 3) = 40
recvfrom(6, 0xc76594, 4096, 0, 0, 0)    = -1 EAGAIN (Resource
temporarily unavailable)
write(3, "\1\0\0\0\0\0\0\0", 8)         = 8
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV +++
Muistialueen ylitys

-- 
Tapio Lehtonen
[email protected]
http://www.iki.fi/tapio.lehtonen

--- End Message ---
--- Begin Message --- 
Version: 3.2.0-1

I followed the steps provided to reproduce this against the current
version in jessie, and can't reproduce the bug. Thus I assume it has
been fixed upstream at some point. Please reopen the bug if you can
reproduce it with the current version.

-- 
Arto Jantunen

--- End Message ---

Reply via email to