Hi, Could you tell me what database URL you are using?
Currently, when a row is updated, I believe all indexes are modified. I understand this is not needed here, and changing it would improve performance. Regards, Thomas On Wed, Dec 11, 2013 at 1:03 PM, Michael Descher <[email protected]>wrote: > 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. > -- 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.
