[Cursor : 커서] java.lang.IllegalArgumentException: Invalid token LOCALIZED 오류 해결하기

2020-11-20 19:47:30.300 23340-23340/sample.test.musicplayer E/TAG: HI
2020-11-20 19:47:30.311 23340-23340/sample.test.musicplayer E/AndroidRuntime: FATAL EXCEPTION: main
    Process: sample.test.musicplayer, PID: 23340
    java.lang.RuntimeException: Unable to start activity ComponentInfo{sample.test.musicplayer/sample.test.musicplayer.MainActivity}: java.lang.IllegalArgumentException: Invalid token LOCALIZED
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3449)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3601)
        at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:85)
        at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:135)
        at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:95)
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2066)
        at android.os.Handler.dispatchMessage(Handler.java:106)
        at android.os.Looper.loop(Looper.java:223)
        at android.app.ActivityThread.main(ActivityThread.java:7656)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592)
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)
     Caused by: java.lang.IllegalArgumentException: Invalid token LOCALIZED
        at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:172)
        at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:142)
        at android.content.ContentProviderProxy.query(ContentProviderNative.java:472)
        at android.content.ContentResolver.query(ContentResolver.java:1183)
        at android.content.ContentResolver.query(ContentResolver.java:1115)
        at android.content.ContentResolver.query(ContentResolver.java:1071)
        at sample.test.musicplayer.common.SongLib$Companion.getMediaSongList(SongLib.kt:147)
        at sample.test.musicplayer.common.SongLib.<init>(SongLib.kt:17)
        at sample.test.musicplayer.MainActivity.onCreate(MainActivity.kt:124)
        at android.app.Activity.performCreate(Activity.java:8000)
        at android.app.Activity.performCreate(Activity.java:7984)
        at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1309)
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3422)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3601) 
        at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:85) 
        at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:135) 
        at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:95) 
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2066) 
        at android.os.Handler.dispatchMessage(Handler.java:106) 
        at android.os.Looper.loop(Looper.java:223) 
        at android.app.ActivityThread.main(ActivityThread.java:7656) 
        at java.lang.reflect.Method.invoke(Native Method) 
        at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592) 
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947) 

[오류가 발생한 코드 스니펫] 오류 원인은 COLLATE LOCALIZED ASC가 문제이다.

            val selection = MediaStore.Audio.Media.IS_MUSIC + " = 1"
            val sortOrder = MediaStore.Audio.Media.TITLE + " COLLATE LOCALIZED ASC"
            
            var cur =  context.contentResolver.query(
                MediaStore.Audio.Media.EXTERNAL_CONTENT_URI,
                mCursorCols,
                selection,
                null,
                sortOrder
            )

fun getMediaSongList(context: Context) : ArrayList<MusicViewModel> {

            val mCursorCols = arrayOf(
                MediaStore.Audio.Media._ID,
                MediaStore.Audio.Media.ARTIST,
                MediaStore.Audio.Media.TITLE,
                MediaStore.Audio.Media.ALBUM,
                MediaStore.Audio.Media.DATA,
                MediaStore.Audio.Media.ALBUM_ID,
                MediaStore.Audio.Media.DURATION,
                MediaStore.Audio.Media.TRACK
            )

            val selection = MediaStore.Audio.Media.IS_MUSIC + " = 1"
            val sortOrder = MediaStore.Audio.Media.TITLE + " COLLATE LOCALIZED ASC"

            var cur =  context.contentResolver.query(
                MediaStore.Audio.Media.EXTERNAL_CONTENT_URI,
                mCursorCols,
                selection,
                null,
                sortOrder
            )

            //cursor = context.contentResolver.query(MediaStore.Audio.Media.EXTERNAL_CONTENT_URI, null, null, null, "title")



            if (cur != null && cur.moveToFirst()) {
                lateinit var title: String
                lateinit var artist: String
                lateinit var album: String
                var idTruck: Int
    //            - MediaStore.Audio.Albums
    //                    - MediaStore.Audio.Artists
    //                    - MediaStore.Audio.Genres
    //                    - MediaStore.Audio.Playlists
    //                    - MediaStore.Audio.Media
    //
    //                    * Nested Inteface
    //                    - MediaStore.Audio.AlbumColumns      : 앨범을 나타내는 컬럼
    //                    - MediaStore.Audio.ArtistColumns        : 연주자를 나타내는 컬럼
    //                    - MediaStore.Audio.GenresColumns     : 쟝르를 나타내는 컬럼
    //                    - MediaStore.Audio.PlaylistsColumns   : 곡목록을 나타내는 컬럼
    //                    - MediaStore.Audio.AudioColumns       : 여러개의 테이블에서 나타나는 audio file을 위한 컬럼

                idTruck = cur.getColumnIndex(MediaStore.Audio.Media.TRACK)

                // val yearColumn = cursor.getColumnIndex(MediaStore.Audio.Media.YEAR)
                try {
                    do {
                        title = cur.getString(cur.getColumnIndex(MediaStore.Audio.AudioColumns.TITLE))
                        artist = cur.getString(cur.getColumnIndex(MediaStore.Audio.AudioColumns.ARTIST))
                        album = cur.getString(cur.getColumnIndex(MediaStore.Audio.AudioColumns.ALBUM));
                        val albumIds = cur.getLong(cur.getColumnIndex(MediaStore.Audio.AudioColumns.ALBUM_ID))
                        //Log.e("TAG", "title = $title albumIds=$albumIds]    duration: $duration")
                        val audioId = cur.getLong( cur.getColumnIndex(MediaStore.Audio.AudioColumns._ID) )

                        val sArtworkUri = Uri.parse("content://media/external/audio/albumart")
                        val sAlbumArtUri = ContentUris.withAppendedId(sArtworkUri, albumIds)
                        //android.util.Log.i("TAG", "sAlbumArtUri = " + sAlbumArtUri + "]");
                        val externalUri = MediaStore.Audio.Media.EXTERNAL_CONTENT_URI
                        val contentUri = ContentUris.withAppendedId(externalUri, audioId)
                        val duration = cur.getLong(cur.getColumnIndex(MediaStore.Audio.AudioColumns.DURATION))


                        val musicVo = MusicViewModel(
                            audioId,
                            title,
                            "서브타이틀",
                            artist,
                            sAlbumArtUri,
                            contentUri,
                            album,
                            duration
                        )
                        musicList.add(musicVo)

                    } while (cur.moveToNext())
                } catch (ee: IllegalStateException) {
                    ee.printStackTrace()
                } catch (se: SecurityException) {
                    se.printStackTrace()
                    //songsList = java.util.ArrayList<MusicVo>()
                } catch (e: Exception) {
                    e.printStackTrace()
                } finally {
                    cur?.close()
                }
            }
            return musicList
        }

[해결방법] 안드로이드 11이 설치된 휴대폰에서 발생하는 오류이다. 안드로이드 10에서는 발생하지 않았다. ” COLLATE LOCALIZED”를 제거하거나 SDK버전를 체크하는 분기문을 작성하면 된다.

            val selection = MediaStore.Audio.Media.IS_MUSIC + " = 1"
            val sortOrder = MediaStore.Audio.Media.TITLE + " ASC"

            var cur =  context.contentResolver.query(
                MediaStore.Audio.Media.EXTERNAL_CONTENT_URI,
                mCursorCols,
                selection,
                null,
                sortOrder
            )

            var sortOrder: String? = null
            sortOrder = if (Build.VERSION.SDK_INT > Build.VERSION_CODES.Q) {
                MediaStore.Audio.Media.TITLE + " ASC"
            }else{
                MediaStore.Audio.Media.TITLE + " COLLATE LOCALIZED ASC"
            }