single() returns Invalid media type: expected no more input.

[Mykyta-Chernenko]

Describe the bug
When single() doesn't find anything, I get "Invalid media type: expected no more input."

full error
flutter: Event: MatchError, Properties: {error: Error on line 1, column 32: Invalid media type: expected no more input.
╷
1 │ application/json; charset=utf-8,application/vnd.pgrst.object+json; charset=utf-8
│ ^
╵}
flutter: Error fetching match: Error on line 1, column 32: Invalid media type: expected no more input.
╷
1 │ application/json; charset=utf-8,application/vnd.pgrst.object+json; charset=utf-8
│ ^
╵

To Reproduce
Steps to reproduce the behavior:

1. install supabase_flutter: ^2.5.1
2. try to call do something as
   await supabase
   .from('profile')
   .select()
   .eq('id', 'gibberish')
   .single();
3. See error

Expected behavior
Some ordinary exception as "not found"

Version (please complete the following information):
├── supabase_flutter 2.5.1
│ ├── supabase 2.1.1
│ │ ├── functions_client 2.0.0
│ │ ├── gotrue 2.6.0
│ │ ├── postgrest 2.1.1
│ │ ├── realtime_client 2.0.4
│ │ ├── storage_client 2.0.1

[allipiopereira]

I'm also having the same error.

supabase: 1.11.11
supabase_flutter: 1.10.24

[Vinzent03]

Is that all stacktrace you get? Shouldn't there be some info about in which file and line it occurs?

[Mykyta-Chernenko]

unfortunately and surprisingly, this is the whole stack, I don't get anything else.
UPD

sorry, my bad, forgot to rethrow, here is the whole stack.

[ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: Error on line 1, column 32: Invalid media type: expected no more input.
╷
1 │ application/json; charset=utf-8,application/vnd.pgrst.object+json; charset=utf-8
│ ^
╵
#0 wrapFormatException (package:http_parser/src/utils.dart:15:5)
#1 new MediaType.parse (package:http_parser/src/media_type.dart:46:7)
#2 _contentTypeForHeaders (package:http/src/response.dart:79:45)
#3 _encodingForHeaders (package:http/src/response.dart:72:24)
#4 Response.body (package:http/src/response.dart:28:22)
#5 PostgrestBuilder._parseResponse (package:postgrest/src/postgrest_builder.dart:269:31)
#6 PostgrestBuilder._execute (package:postgrest/src/postgrest_builder.dart:164:14)

#7 PostgrestBuilder.then (package:postgrest/src/postgrest_builder.dart:372:24)

Is that all stacktrace you get? Shouldn't there be some info about in which file and line it occurs?

[Smartiiez]

I think you have to use :
await supabase.from('profile').select().eq('id', 'gibberish').maybeSingle();

[Mykyta-Chernenko]

I think you have to use : await supabase.from('profile').select().eq('id', 'gibberish').maybeSingle();

It's possible temporary solution

but with 30 .single() queries in prod, it was almost impossible to debug the first time where the issue happened at/neither to catch it

[dshukertjr]

@Mykyta-Chernenko @allipiopereira
Hmm, I am unable to reproduce this issue. When I use .single() and query in a way that it returns 0 rows, I get the following error.

PostgrestException(message: JSON object requested, multiple (or no) rows returned, code: PGRST116, details: The result contains 0 rows, hint: null).

Are you using the hosted version of Supabase? Does the same issue happen on a fresh Supabase instance?

[Mykyta-Chernenko]

@Mykyta-Chernenko @allipiopereira Hmm, I am unable to reproduce this issue. When I use .single() and query in a way that it returns 0 rows, I get the following error.

PostgrestException(message: JSON object requested, multiple (or no) rows returned, code: PGRST116, details: The result contains 0 rows, hint: null).

Are you using the hosted version of Supabase? Does the same issue happen on a fresh Supabase instance?

I get the error like this.

   final response = await supabase
        .from('app_settings')
        .select('review_version_ios, review_version_android')
        .single();
    
    id is non-existent
    
    I get 
    
    [ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: Error on line 1, column 32: Invalid media type: expected no more input.
  ╷
1 │ application/json; charset=utf-8,application/vnd.pgrst.object+json; charset=utf-8
  │                                ^
  ╵
#0      wrapFormatException (package:http_parser/src/utils.dart:15:5)
#1      new MediaType.parse (package:http_parser/src/media_type.dart:46:7)
#2      _contentTypeForHeaders (package:http/src/response.dart:79:45)
#3      _encodingForHeaders (package:http/src/response.dart:72:24)
#4      Response.body (package:http/src/response.dart:28:22)
#5      PostgrestBuilder._parseResponse (package:postgrest/src/postgrest_builder.dart:269:31)
#6      PostgrestBuilder._execute (package:postgrest/src/postgrest_builder.dart:164:14)
<asynchronous suspension>
#7      PostgrestBuilder.then (package:postgrest/src/postgrest_builder.dart:372:24)
<asynchronous suspension>

I use supabase hosted version.

I tried to restart the db, the issue is still there

I created a new db with the minimum migration, the issue is still there

here is the migration I applied to the fresh db

-- Migration for the app_settings table
create table if not exists app_settings
(
    id                     serial primary key,
    review_version         text not null,
    review_version_android text not null,
    review_version_ios     text not null,
    version                text not null
);

I use Frankfurt region.

Thanks for you help!

[Dosenbiiir]

I get the same error message, so I can confirm that. Also I get the same message if .single() is used and multiple results are returned. I tested supabase_flutter: ^2.3.4 and ^2.5.3.