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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
