2013-12-10 13:38:09,978 [pool-1-thread-1] ERROR
de.codewave.mytunesrss.webadmin.ContentConfigPanel - Could not rename
genres.
org.h2.jdbc.JdbcSQLException: Çàïèñü íå íàéäåíà ïðè óäàëåíèè èç èíäåêñà
"PUBLIC.IDX_TRACK_LOWER_ALBUM_ARTIST: ( /* key:35419 */
'file_4087a0b736d9866abc220a7736d686b7c7a876b2', 'Just a Lil Bit of
History', 'just a lil bit of history', 'L-Boy-N-Boo Loc', 'l-boy-n-boo
loc', 'L-Boy-N-Boo Loc', 'l-boy-n-boo loc', 'Just A Lil'' Bit of History',
'just a lil'' bit of history', 193, 1,
'H:\MP3\2004\L-Boy-N-Boo_Loc-Just_A_Lil_Bit_of_History-2004-CR\01-l-boy-n-boo_loc-just_a_lil_bit_of_history-cr.mp3',
'mp3', FALSE, 'Audio', 'FileSystem',
'a9aab034-0a8e-472d-8ae3-4cbbacfaa74f', 'Rap', 'rap', 'Rap', NULL, NULL,
1385989685310, 0, 0, NULL, 0, 0, NULL, 2004, NULL, NULL, NULL, 0, 0, NULL,
0)"
Row not found when trying to delete from index
"PUBLIC.IDX_TRACK_LOWER_ALBUM_ARTIST: ( /* key:35419 */
'file_4087a0b736d9866abc220a7736d686b7c7a876b2', 'Just a Lil Bit of
History', 'just a lil bit of history', 'L-Boy-N-Boo Loc', 'l-boy-n-boo
loc', 'L-Boy-N-Boo Loc', 'l-boy-n-boo loc', 'Just A Lil'' Bit of History',
'just a lil'' bit of history', 193, 1,
'H:\MP3\2004\L-Boy-N-Boo_Loc-Just_A_Lil_Bit_of_History-2004-CR\01-l-boy-n-boo_loc-just_a_lil_bit_of_history-cr.mp3',
'mp3', FALSE, 'Audio', 'FileSystem',
'a9aab034-0a8e-472d-8ae3-4cbbacfaa74f', 'Rap', 'rap', 'Rap', NULL, NULL,
1385989685310, 0, 0, NULL, 0, 0, NULL, 2004, NULL, NULL, NULL, 0, 0, NULL,
0)"; SQL statement:
UPDATE track SET genre = original_genre, lower_genre =
LOWER(original_genre) [90112-174]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:230)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:332)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:332)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:332)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:239)
at org.h2.table.RegularTable.removeRow(RegularTable.java:376)
at org.h2.table.Table.updateRows(Table.java:449)
at org.h2.command.dml.Update.update(Update.java:144)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at
org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:193)
What I don't understand at first glance is the reason for deleting anything
from that index. The index is on a single column of the modifed table but
it is not used in the update statement that causes the deletion. What the
update does is copy the original_genre column into two other columns (genre
and lower_genre) of the same table. Background for the use-case, the
original_genre column holds the original value while genre and lower_genre
hold a possibly modified value. This update statement is for the use-case
of resetting the possibly modified values to their original ones.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
