PDA

View Full Version : svn 2256: crash when searching for album "go"



mherger
2005-02-28, 00:55
When I use advanced search to search for the album title or interpret
"go", SlimServer dies (segfault). Song title does work, though :-).

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Dan Sully
2005-02-28, 03:00
* Michael Herger shaped the electrons to say...

>When I use advanced search to search for the album title or interpret
>"go", SlimServer dies (segfault). Song title does work, though :-).

Michael - can you run the server with --d_sql and/or under the perl debugger?

Thanks.

-D
--
<Djall> and I also learned that a meat vortex takes meat away from you.

mherger
2005-02-28, 03:13
> * Michael Herger shaped the electrons to say...
>
>> When I use advanced search to search for the album title or interpret
>> "go", SlimServer dies (segfault). Song title does work, though :-).
>
> Michael - can you run the server with --d_sql and/or under the perl
> debugger?

Debugger? Give me a short "perl debugger for dummies" on three lines and
I'd give it a try :-)


2005-02-28 11:10:31.4115 Generated findKey: [genre::genre:::]
2005-02-28 11:10:31.4151 Backtrace:

frame 0: Slim::DataStores::DBI::DataModel::find
(/home/mh/eclipse/SVN/Slim/DataStores/DBI/DBIStore.pm line 263)
frame 1: Slim::DataStores::DBI::DBIStore::find
(/home/mh/eclipse/SVN/Slim/Web/Pages.pm line 1483)
frame 2: Slim::Web::Pages::advancedSearch
(/home/mh/eclipse/SVN/Slim/Web/HTTP.pm line 750)
frame 3: Slim::Web::HTTP::generateHTTPResponse
(/home/mh/eclipse/SVN/Slim/Web/HTTP.pm line 671)
frame 4: Slim::Web::HTTP::processURL
(/home/mh/eclipse/SVN/Slim/Web/HTTP.pm line 535)
frame 5: Slim::Web::HTTP::processHTTP
(/home/mh/eclipse/SVN/Slim/Networking/Select.pm line 116)
frame 6: Slim::Networking::Select::select (./slimserver.pl line 569)
frame 7: main::idle (./slimserver.pl line 512)
frame 8: main::main (./slimserver.pl line 1051)

2005-02-28 11:10:31.4176 Running SQL query: [SELECT DISTINCT genres.id AS
id,genres.name AS name,genres.namesort AS namesort,genres.moodlogic_id AS
moodlogic_id,genres.moodlogic_mixable AS
moodlogic_mixable,genres.musicmagic_mixable AS musicmagic_mixable FROM
genres ORDER BY genres.namesort]
2005-02-28 11:10:31.4432 Generated findKey: [track:album.title:GO*:*
GO*:title:::]
2005-02-28 11:10:31.4449 Start and End node: [album:default]
2005-02-28 11:10:31.4470 Backtrace:

frame 0: Slim::DataStores::DBI::DataModel::find
(/home/mh/eclipse/SVN/Slim/DataStores/DBI/DBIStore.pm line 263)
frame 1: Slim::DataStores::DBI::DBIStore::find
(/home/mh/eclipse/SVN/Slim/Web/Pages.pm line 1492)
frame 2: Slim::Web::Pages::advancedSearch
(/home/mh/eclipse/SVN/Slim/Web/HTTP.pm line 750)
frame 3: Slim::Web::HTTP::generateHTTPResponse
(/home/mh/eclipse/SVN/Slim/Web/HTTP.pm line 671)
frame 4: Slim::Web::HTTP::processURL
(/home/mh/eclipse/SVN/Slim/Web/HTTP.pm line 535)
frame 5: Slim::Web::HTTP::processHTTP
(/home/mh/eclipse/SVN/Slim/Networking/Select.pm line 116)
frame 6: Slim::Networking::Select::select (./slimserver.pl line 569)
frame 7: main::idle (./slimserver.pl line 512)
frame 8: main::main (./slimserver.pl line 1051)

2005-02-28 11:10:31.4493 Running SQL query: [SELECT DISTINCT tracks.id AS
id,tracks.thumb AS thumb,tracks.age AS age,tracks.ct AS
ct,tracks.titlesort AS titlesort,tracks.album AS album,tracks.tracknum AS
tracknum,tracks.url AS url,tracks.tag AS tag,tracks.title AS
title,tracks.disc AS disc,tracks.fs AS fs FROM tracks, albums WHERE
albums.id = tracks.album AND ( ( ( albums.titlesort like ? ) OR
( albums.titlesort like ? ) ) ) ORDER BY tracks.titlesort]
2005-02-28 11:10:31.4505 Bind arguments: [GO%, % GO%]

Segmentation fault

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Dan Sully
2005-02-28, 03:15
* Michael Herger shaped the electrons to say...

>>* Michael Herger shaped the electrons to say...
>>
>>>When I use advanced search to search for the album title or interpret
>>>"go", SlimServer dies (segfault). Song title does work, though :-).
>>
>>Michael - can you run the server with --d_sql and/or under the perl
>>debugger?
>
>Debugger? Give me a short "perl debugger for dummies" on three lines and
>I'd give it a try :-)

So the query looks correct.. let's try gdb instead:

gdb perl

(gdb) r slimserver.pl

Then do your search. It'll segfault, then type 'bt' for backtrace at the gdb prompt.

-D
--
<Djall> and I also learned that a meat vortex takes meat away from you.

mherger
2005-02-28, 03:30
>>>> When I use advanced search to search for the album title or
>>>> interpret "go", SlimServer dies (segfault). Song title does work,
>>>> though :-).
>>>
>>> Michael - can you run the server with --d_sql and/or under the perl
>>> debugger?
>>
>> Debugger? Give me a short "perl debugger for dummies" on three lines
>> and I'd give it a try :-)
>
> So the query looks correct.. let's try gdb instead:
>
> gdb perl

bash: gdb: command not found

I'm really not a developper :-)

> (gdb) r slimserver.pl
>
> Then do your search. It'll segfault, then type 'bt' for backtrace at the
> gdb prompt.

(gdb) r slimserver.pl
Starting program: /usr/bin/perl slimserver.pl
(no debugging symbols found)...(no debugging symbols found)...(no
debugging symbols found)...(no debugging symbols found)...(no debugging
symbols found)...(no debugging symbols found)...(no debugging symbols
found)...[Thread debugging using libthread_db enabled]
[New Thread 1076781824 (LWP 14469)]
(no debugging symbols found)...Detaching after fork from child process
14472.
Detaching after fork from child process 14473.
Detaching after fork from child process 14474.

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1076781824 (LWP 14469)]
0x400babd6 in Perl_sv_pos_b2u () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
(gdb) bt
#0 0x400babd6 in Perl_sv_pos_b2u () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#1 0x0a1e46a8 in ?? ()
#2 0x401399f8 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#3 0x04840304 in ?? ()
#4 0x400b8cef in Perl_sv_setsv_flags () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#5 0x0a1e0108 in ?? ()
#6 0x08a68a68 in ?? ()
#7 0x00000000 in ?? ()
#8 0x401399f8 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#9 0x097c5978 in ?? ()
#10 0x09a8ecec in ?? ()
#11 0x0804c008 in ?? ()
#12 0x400bdcdd in Perl_pp_pos () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#13 0x0804c008 in ?? ()
#14 0x09a8ecec in ?? ()
#15 0xbffff318 in ?? ()
#16 0x400a5a3f in Perl_pp_padsv () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#17 0x401399f8 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#18 0x0804c008 in ?? ()
#19 0x0804c008 in ?? ()
#20 0x400a19b7 in Perl_pp_enter () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#21 0x0804c008 in ?? ()
#22 0x08a6821c in ?? ()
#23 0x0000000f in ?? ()
#24 0x401399f8 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#25 0x0804c008 in ?? ()
#26 0x09717ce0 in ?? ()
#27 0xbffff458 in ?? ()
#28 0x4009c919 in Perl_runops_standard () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#29 0x0804c008 in ?? ()
#30 0x4003d824 in perl_run () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#31 0x00000000 in ?? ()
#32 0x00000000 in ?? ()
#33 0x00000001 in ?? ()
#34 0x40014998 in ?? ()
#35 0x401399f8 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#36 0xbffff384 in ?? ()
#37 0x00000001 in ?? ()
#38 0x0804c19c in ?? ()
#39 0x401399f8 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#40 0x00000001 in ?? ()
#41 0xbffff470 in ?? ()
#42 0xbffff458 in ?? ()
#43 0xbffff340 in ?? ()
#44 0x4003d535 in perl_run () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#45 0x402e3b20 in __after_morecore_hook () from /lib/tls/libc.so.6
#46 0x4001edc0 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#47 0x400151f8 in ?? ()
#48 0x400a6d22 in Perl_report_uninit () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#49 0x0804c008 in ?? ()
#50 0x401399f8 in ?? () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
---Type <return> to continue, or q <return> to quit---
#51 0x00000000 in ?? ()
#52 0x400146bc in ?? () from /lib/ld-linux.so.2
#53 0x400151f8 in ?? ()
#54 0x40015398 in ?? ()
#55 0xbffff3e0 in ?? ()
#56 0x4000a9c4 in fixup (l=0x804c008, reloc_offset=134512639) at
dl-runtime.c:98
Previous frame inner to this frame (corrupt stack?)
(gdb)

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Dan Sully
2005-02-28, 11:17
* Michael Herger shaped the electrons to say...

>>>When I use advanced search to search for the album title or interpret
>>>"go", SlimServer dies (segfault). Song title does work, though :-).
>>
>>Michael - can you run the server with --d_sql and/or under the perl debugger?

So I just took a look at your db, nothing wrong that I can see - and was able
to do a successful search using "Go" as the album query against it.

Have you upgraded anything on your machine recently?

-D
--
"You can usually recover from production flaws...but you can never recover from a bad design".

mherger
2005-02-28, 12:20
>>>> When I use advanced search to search for the album title or
>>>> interpret "go", SlimServer dies (segfault). Song title does work,
>>>> though :-).
>>>
>>> Michael - can you run the server with --d_sql and/or under the perl
>>> debugger?
>
> So I just took a look at your db, nothing wrong that I can see - and was
> able
> to do a successful search using "Go" as the album query against it.
>
> Have you upgraded anything on your machine recently?

Recently? I swapped some RAM with another machine 2-3 weeks ago. I might
have installed some security fixes. But no big changes.

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

mherger
2005-02-28, 14:05
>>>> When I use advanced search to search for the album title or
>>>> interpret "go", SlimServer dies (segfault). Song title does work,
>>>> though :-).
>>>
>>> Michael - can you run the server with --d_sql and/or under the perl
>>> debugger?
>
> So I just took a look at your db, nothing wrong that I can see - and was
> able
> to do a successful search using "Go" as the album query against it.
>
> Have you upgraded anything on your machine recently?

I'm not sure when exactly I did it, but I installed (at least tried to)
unixODBC for sqlite about 2-3 weeks ago. Recent enough?

--

Michael

-----------------------------------------------------------
Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

Dan Sully
2005-02-28, 14:06
* Michael Herger shaped the electrons to say...

>>Have you upgraded anything on your machine recently?
>
>I'm not sure when exactly I did it, but I installed (at least tried to)
>unixODBC for sqlite about 2-3 weeks ago. Recent enough?

Shouldn't have any effect. DBD::SQLite is self-contained, and doesn't rely on any external libraries.

-D
--
Minds are like parachutes... they work best when open.