Page 1 of 1

Failed to create search index

PostPosted: Wed Nov 01, 2006 4:52 pm
by RAMDrive
I started having problems with the subsonic webpage loading the other day; left and top frames were not loading. I have upgraded to the latest version of subsonic; following the upgrade instructions. I was still having problems I deleted the 'c:\subsonic' folder and all subfolders. Everything started working again. Next I began configuring everything. I added my music folders, which is a 200 gig drive consisting of 392 folders in the root. This ran for about 1-2 minutes when I lost the left and top frames with java.lang errors. Below is everything from the subsonic.log

[2006-11-01 10:25:17,610] INFO DaoHelper - Checking database schema.
[2006-11-01 10:25:18,313] INFO Schema25 - Database table 'version' not found. Creating it.
[2006-11-01 10:25:18,329] INFO Schema25 - Database table 'version' was created successfully.
[2006-11-01 10:25:18,329] INFO Schema25 - Database table 'role' not found. Creating it.
[2006-11-01 10:25:18,329] INFO Schema25 - Database table 'role' was created successfully.
[2006-11-01 10:25:18,329] INFO Schema25 - Database table 'user' not found. Creating it.
[2006-11-01 10:25:18,329] INFO Schema25 - Database table 'user' was created successfully.
[2006-11-01 10:25:18,329] INFO Schema25 - Database table 'user_role' not found. Creating it.
[2006-11-01 10:25:18,344] INFO Schema25 - Database table 'user_role' was created successfully.
[2006-11-01 10:25:18,391] INFO Schema26 - Updating database schema to version 2.
[2006-11-01 10:25:18,391] INFO Schema26 - Database table 'music_folder' not found. Creating it.
[2006-11-01 10:25:18,391] INFO Schema26 - Database table 'music_folder' was created successfully.
[2006-11-01 10:25:18,391] INFO Schema26 - Database table 'music_file_info' not found. Creating it.
[2006-11-01 10:25:18,563] INFO Schema26 - Database table 'music_file_info' was created successfully.
[2006-11-01 10:25:18,563] INFO Schema26 - Database table 'internet_radio' not found. Creating it.
[2006-11-01 10:25:18,563] INFO Schema26 - Database table 'internet_radio' was created successfully.
[2006-11-01 10:25:18,563] INFO Schema26 - Database table 'player' not found. Creating it.
[2006-11-01 10:25:18,563] INFO Schema26 - Database table 'player' was created successfully.
[2006-11-01 10:25:18,563] INFO Schema26 - Database column 'player.dynamic_ip' not found. Creating it.
[2006-11-01 10:25:18,563] INFO Schema26 - Database column 'player.dynamic_ip' was added successfully.
[2006-11-01 10:25:18,563] INFO Schema26 - Role 'comment' not found in database. Creating it.
[2006-11-01 10:25:18,563] INFO Schema26 - Role 'comment' was created successfully.
[2006-11-01 10:25:18,563] INFO Schema27 - Updating database schema to version 3.
[2006-11-01 10:25:18,563] INFO Schema27 - Converting database column 'music_file_info.path' to varchar_ignorecase.
[2006-11-01 10:25:18,563] INFO Schema27 - Database column 'music_file_info.path' was converted successfully.
[2006-11-01 10:25:18,579] INFO Schema27 - Database columns 'user.bytes_streamed/downloaded/uploaded' not found. Creating them.
[2006-11-01 10:25:18,579] INFO Schema27 - Database columns 'user.bytes_streamed/downloaded/uploaded' were added successfully.
[2006-11-01 10:25:18,579] INFO Schema28 - Updating database schema to version 4.
[2006-11-01 10:25:18,579] INFO Schema28 - Database table 'user_settings' not found. Creating it.
[2006-11-01 10:25:18,579] INFO Schema28 - Database table 'user_settings' was created successfully.
[2006-11-01 10:25:18,579] INFO Schema28 - Database table 'transcoding' not found. Creating it.
[2006-11-01 10:25:18,579] INFO Schema28 - Database table 'transcoding' was created successfully.
[2006-11-01 10:25:18,594] INFO Schema28 - Database table 'player_transcoding' not found. Creating it.
[2006-11-01 10:25:18,594] INFO Schema28 - Database table 'player_transcoding' was created successfully.
[2006-11-01 10:25:18,594] INFO DaoHelper - Done checking database schema.
[2006-11-01 10:25:18,688] INFO SearchService - Automatic index creation scheduled to run every 1 day(s), starting at Thu Nov 02 03:00:00 CST 2006
[2006-11-01 10:25:48,719] INFO PlayerDao - Created player 1.
[2006-11-01 10:25:48,751] INFO VersionService - Resolved latest Subsonic final version to: 2.8
[2006-11-01 10:25:48,751] INFO VersionService - Resolved latest Subsonic beta version to: 2.9.beta1
[2006-11-01 10:25:48,751] INFO VersionService - Resolved local Subsonic version to: 2.8
[2006-11-01 10:27:41,422] INFO SecurityService - Created user RAMDrive
[2006-11-01 10:27:41,422] INFO SecurityService - Updated user RAMDrive
[2006-11-01 10:29:05,813] INFO SecurityService - Updated user RAMDrive
[2006-11-01 10:33:19,704] INFO SearchService - Starting to create search index.
[2006-11-01 10:34:07,813] ERROR SearchService - Failed to create search index.
java.lang.NullPointerException
at net.sourceforge.subsonic.domain.MusicFile$MusicFileSorter.compare(MusicFile.java:568)
at net.sourceforge.subsonic.domain.MusicFile$MusicFileSorter.compare(MusicFile.java:553)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.mergeSort(Unknown Source)
at java.util.Arrays.sort(Unknown Source)
at net.sourceforge.subsonic.domain.MusicFile.getChildren(MusicFile.java:252)
at net.sourceforge.subsonic.domain.MusicFile.listMusicRecursively(MusicFile.java:294)
at net.sourceforge.subsonic.domain.MusicFile.getChildren(MusicFile.java:245)
at net.sourceforge.subsonic.service.SearchService$1.run(SearchService.java:77)

Any Ideas?

Thanks in advance for any help.

PostPosted: Wed Nov 01, 2006 9:04 pm
by sindre_mehus
Hi,

Please see this thread: http://forum.subsonic.org/forum/viewtopic.php?t=144

Sindre