Error: Received unexpected fetch response FetchResponse[status=0, count=0], ignored

20 views
Skip to first unread message

Tim Schmitt

unread,
Mar 26, 2025, 5:49:32 AMMar 26
to firebird-java
Hello,
when using Jaybird 6.0.0 with java 23 and spring boot I get an error:

2025-03-26T10:34:00.889+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored

Using the same connection string in an odbc or sql studio it works fine.
Firebird is installed on a server and accessed via firebird port and server ip.
The firebird version is 3.0

The firebird.log doesnt show any error message.

The full stacktrace:
2025-03-26T10:33:53.972+01:00  INFO 3612 --- [firebirdapi] [           main] d.e.firebirdapi.FirebirdapiApplication   : No active profile set, falling back to 1 default profile: "default"
2025-03-26T10:33:55.011+01:00  INFO 3612 --- [firebirdapi] [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-03-26T10:33:55.092+01:00  INFO 3612 --- [firebirdapi] [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 60 ms. Found 2 JPA repository interfaces.
2025-03-26T10:33:55.804+01:00  INFO 3612 --- [firebirdapi] [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port 8080 (http)
2025-03-26T10:33:55.824+01:00  INFO 3612 --- [firebirdapi] [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2025-03-26T10:33:55.825+01:00  INFO 3612 --- [firebirdapi] [           main] o.apache.catalina.core.StandardEngine    : Starting Servlet engine: [Apache Tomcat/10.1.39]
2025-03-26T10:33:55.898+01:00  INFO 3612 --- [firebirdapi] [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2025-03-26T10:33:55.900+01:00  INFO 3612 --- [firebirdapi] [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1857 ms
2025-03-26T10:33:56.098+01:00 DEBUG 3612 --- [firebirdapi] [           main] j.LocalContainerEntityManagerFactoryBean : Building JPA container EntityManagerFactory for persistence unit 'default'
2025-03-26T10:33:56.122+01:00  INFO 3612 --- [firebirdapi] [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-03-26T10:33:56.176+01:00  INFO 3612 --- [firebirdapi] [           main] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 6.6.11.Final
2025-03-26T10:33:56.207+01:00  INFO 3612 --- [firebirdapi] [           main] o.h.c.internal.RegionFactoryInitiator    : HHH000026: Second-level cache disabled
2025-03-26T10:33:56.484+01:00  INFO 3612 --- [firebirdapi] [           main] o.s.o.j.p.SpringPersistenceUnitInfo      : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-03-26T10:33:56.529+01:00  INFO 3612 --- [firebirdapi] [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2025-03-26T10:33:56.598+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property encrypt_key
2025-03-26T10:33:56.599+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property online_dump
2025-03-26T10:33:56.600+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property gbak_attach
2025-03-26T10:33:56.601+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property os_user
2025-03-26T10:33:56.602+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property old_file
2025-03-26T10:33:56.602+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property org_filename
2025-03-26T10:33:56.603+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property sys_user_name
2025-03-26T10:33:56.603+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property old_start_page
2025-03-26T10:33:56.604+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property working_directory
2025-03-26T10:33:56.604+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property gstat_attach
2025-03-26T10:33:56.605+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property map_attach
2025-03-26T10:33:56.605+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property quit_log
2025-03-26T10:33:56.605+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property drop_walfile
2025-03-26T10:33:56.606+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property old_start_seqno
2025-03-26T10:33:56.606+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property journal
2025-03-26T10:33:56.606+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property sec_attach
2025-03-26T10:33:56.606+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property old_dump_id
2025-03-26T10:33:56.607+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property wal_chkptlen
2025-03-26T10:33:56.608+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property wal_grp_cmt_wait
2025-03-26T10:33:56.608+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property wal_numbufs
2025-03-26T10:33:56.608+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property remote_protocol
2025-03-26T10:33:56.608+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property allocation
2025-03-26T10:33:56.610+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property enable_journal
2025-03-26T10:33:56.610+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property gfix_attach
2025-03-26T10:33:56.610+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property disable_wal
2025-03-26T10:33:56.610+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property garbage_collect
2025-03-26T10:33:56.610+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property lc_messages
2025-03-26T10:33:56.610+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property trusted_role
2025-03-26T10:33:56.611+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property cache_manager
2025-03-26T10:33:56.611+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property wal_backup_dir
2025-03-26T10:33:56.612+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property address_path
2025-03-26T10:33:56.612+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property old_file_size
2025-03-26T10:33:56.612+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property cdd_pathname
2025-03-26T10:33:56.612+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property license
2025-03-26T10:33:56.613+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property number_of_users
2025-03-26T10:33:56.613+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property sys_user_name_enc
2025-03-26T10:33:56.613+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property disable_journal
2025-03-26T10:33:56.614+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property reserved
2025-03-26T10:33:56.614+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property old_start_file
2025-03-26T10:33:56.614+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property set_db_charset
2025-03-26T10:33:56.614+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property wal_bufsize
2025-03-26T10:33:56.614+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property buffer_length
2025-03-26T10:33:56.615+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property begin_log
2025-03-26T10:33:56.615+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property old_num_files
2025-03-26T10:33:56.615+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property config
2025-03-26T10:33:56.615+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property gsec_attach
2025-03-26T10:33:56.615+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.j.p.internal.UnregisteredDpbDefiner  : Defining unregistered DPB/SPB property host_name
2025-03-26T10:33:56.633+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.firebirdsql.encodings.EncodingFactory  : Processing EncodingSet org.firebirdsql.encodings.DefaultEncodingSet with preference weight 0
2025-03-26T10:33:56.654+01:00  WARN 3612 --- [firebirdapi] [           main] o.f.g.n.w.a.AuthenticationPluginRegistry : Authentication plugin provider for Legacy_Auth already registered. Skipping org.firebirdsql.gds.ng.wire.auth.legacy.LegacyAuthenticationPluginSpi
2025-03-26T10:33:56.654+01:00  WARN 3612 --- [firebirdapi] [           main] o.f.g.n.w.a.AuthenticationPluginRegistry : Authentication plugin provider for Srp already registered. Skipping org.firebirdsql.gds.ng.wire.auth.srp.SrpAuthenticationPluginSpi
2025-03-26T10:33:56.654+01:00  WARN 3612 --- [firebirdapi] [           main] o.f.g.n.w.a.AuthenticationPluginRegistry : Authentication plugin provider for Srp224 already registered. Skipping org.firebirdsql.gds.ng.wire.auth.srp.Srp224AuthenticationPluginSpi
2025-03-26T10:33:56.655+01:00  WARN 3612 --- [firebirdapi] [           main] o.f.g.n.w.a.AuthenticationPluginRegistry : Authentication plugin provider for Srp256 already registered. Skipping org.firebirdsql.gds.ng.wire.auth.srp.Srp256AuthenticationPluginSpi
2025-03-26T10:33:56.655+01:00  WARN 3612 --- [firebirdapi] [           main] o.f.g.n.w.a.AuthenticationPluginRegistry : Authentication plugin provider for Srp384 already registered. Skipping org.firebirdsql.gds.ng.wire.auth.srp.Srp384AuthenticationPluginSpi
2025-03-26T10:33:56.655+01:00  WARN 3612 --- [firebirdapi] [           main] o.f.g.n.w.a.AuthenticationPluginRegistry : Authentication plugin provider for Srp512 already registered. Skipping org.firebirdsql.gds.ng.wire.auth.srp.Srp512AuthenticationPluginSpi
2025-03-26T10:33:56.735+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:33:56.866+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:33:56.872+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:33:56.873+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:33:56.874+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:33:57.166+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:33:57.486+01:00  INFO 3612 --- [firebirdapi] [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Added connection org.firebirdsql.jdbc.FBConnection@368424db
2025-03-26T10:33:57.489+01:00  INFO 3612 --- [firebirdapi] [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2025-03-26T10:33:57.571+01:00  INFO 3612 --- [firebirdapi] [           main] org.hibernate.orm.connections.pooling    : HHH10001005: Database info:
        Database JDBC URL [Connecting through datasource 'HikariDataSource (HikariPool-1)']
        Database driver: undefined/unknown
        Database version: 3.0
        Autocommit mode: undefined/unknown
        Isolation level: undefined/unknown
        Minimum pool size: undefined/unknown
        Maximum pool size: undefined/unknown
2025-03-26T10:33:57.645+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:33:57.837+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:33:57.838+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:33:57.838+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:33:57.839+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:33:57.952+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:33:58.105+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:33:58.221+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:33:58.223+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:33:58.223+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:33:58.224+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:33:58.267+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:33:58.413+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:33:58.445+01:00  INFO 3612 --- [firebirdapi] [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2025-03-26T10:33:58.597+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:33:58.600+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:33:58.601+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:33:58.601+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:33:58.678+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:33:58.962+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:33:59.027+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:33:59.030+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:33:59.031+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:33:59.047+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:33:59.125+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:33:59.399+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:33:59.504+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:33:59.507+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:33:59.507+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:33:59.507+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:33:59.549+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:33:59.656+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:33:59.730+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:33:59.797+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:33:59.797+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:33:59.847+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:33:59.847+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:33:59.849+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:33:59.849+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:33:59.850+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:33:59.911+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:33:59.930+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:33:59.990+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.058+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.128+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.159+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:34:00.195+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.229+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:34:00.230+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:34:00.231+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:34:00.233+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:34:00.252+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.308+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:34:00.339+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.411+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.479+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.543+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.543+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:34:00.590+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:34:00.593+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:34:00.593+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:34:00.594+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:34:00.619+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.689+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)
2025-03-26T10:34:00.689+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.759+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.826+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.889+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:00.889+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp256
2025-03-26T10:34:00.934+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp
2025-03-26T10:34:00.937+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Trying authentication plugin SrpAuthenticationPlugin : Srp is OK
2025-03-26T10:34:00.938+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : first time - added plugName & pluginList
2025-03-26T10:34:00.940+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.gds.ng.wire.auth.ClientAuthBlock     : Added 256 bytes of spec data with tag isc_dpb_specific_auth_data
2025-03-26T10:34:00.964+01:00 DEBUG 3612 --- [firebirdapi] [           main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected fetch response FetchResponse[status=0, count=0], ignored
2025-03-26T10:34:01.042+01:00 DEBUG 3612 --- [firebirdapi] [onnection adder] o.f.g.n.w.version13.V13WireOperations    : receiveResponse: authenticate(Srp)

Mark Rotteveel

unread,
Mar 26, 2025, 6:02:55 AMMar 26
to firebi...@googlegroups.com
On 26/03/2025 10:36, Tim Schmitt wrote:
> when using Jaybird 6.0.0 with java 23 and spring boot I get an error:
>
> 2025-03-26T10:34:00.889+01:00 DEBUG 3612 --- [firebirdapi] [
> main] o.f.gds.ng.wire.version10.V10Statement   : Received unexpected
> fetch response FetchResponse[status=0, count=0], ignored
>
> Using the same connection string in an odbc or sql studio it works fine.
> Firebird is installed on a server and accessed via firebird port and
> server ip.
> The firebird version is 3.0
>
> The firebird.log doesnt show any error message.
>
> The full stacktrace:

None of what you posted is an exception or stacktrace. You're looking at
debug logging, not at errors. You may want to consider raising the log
level for org.firebirdsql to INFO or even WARNING or ERROR, as most of
Jaybird's debug logging is only relevant for development or
investigating issues.

It does seem to indicate a bug in Jaybird though, as we don't consider
the status = FETCH_OK (0) with count = 0 as an expected response, but
because we ignore it, it shouldn't do any harm. I will need to look at
exactly what fetches would trigger it, and maybe if that should affect
beforeFirst/afterLast determination.

If you do get an actual exception, I would be interested in that.

Mark

--
Mark Rotteveel

Mark Rotteveel

unread,
Mar 26, 2025, 6:10:40 AMMar 26
to firebi...@googlegroups.com
On 26/03/2025 11:02, 'Mark Rotteveel' via firebird-java wrote:
> It does seem to indicate a bug in Jaybird though, as we don't consider
> the status = FETCH_OK (0) with count = 0 as an expected response, but
> because we ignore it, it shouldn't do any harm. I will need to look at
> exactly what fetches would trigger it, and maybe if that should affect
> beforeFirst/afterLast determination.

I created https://github.com/FirebirdSQL/jaybird/issues/848 to no longer
consider this an unexpected response. Planned for Jaybird 6.0.1.

Mark
--
Mark Rotteveel

Tim Schmitt

unread,
Mar 26, 2025, 6:17:02 AMMar 26
to firebird-java
Hello Sir,
thanks for the response.
I increased the log level as suggested, but unfortunately, it didn’t provide any additional relevant output. The process halts at the "unexpected fetch response" info and doesn’t proceed to the next step.

Can I provided any additional information or logs to assist in troubleshooting?

Looking forward to your guidance.

Best Regards
Tim

Mark Rotteveel

unread,
Mar 26, 2025, 6:27:31 AMMar 26
to firebi...@googlegroups.com
On 26/03/2025 11:17, Tim Schmitt wrote:
> thanks for the response.
> I increased the log level as suggested, but unfortunately, it didn’t
> provide any additional relevant output. The process halts at the
> "unexpected fetch response" info and doesn’t proceed to the next step.
>
> Can I provided any additional information or logs to assist in
> troubleshooting?

As you only mentioned the unexpected fetch response debug logging, and
did not say there was an actual problem, I had assumed that you were
just tripping over this logging, not that you were investigating an
actual issue.

I suggested raising the log level, so you wouldn't be flooded with debug
logging.

What is the exact version of Firebird 3 you're using? Do you have a
reproducible example that triggers the problem?

Mark
--
Mark Rotteveel

Tim Schmitt

unread,
Mar 26, 2025, 7:10:03 AMMar 26
to firebird-java
Hello Sir,
Unfortunately, it would be challenging to provide a reproducible example of the issue.

However, I was able to resolve the problem that appeared to cause the process to hang without triggering any errors. After letting it run for 20 minutes, it eventually completed.

Changing the spring.jpa.hibernate.ddl-auto setting from update to none allowed it to run immediately without any delays.

Best regards,

Mark Rotteveel

unread,
Mar 26, 2025, 7:17:04 AMMar 26
to firebi...@googlegroups.com
On 26/03/2025 12:10, Tim Schmitt wrote:
> Unfortunately, it would be challenging to provide a reproducible example
> of the issue.
>
> However, I was able to resolve the problem that appeared to cause the
> process to hang without triggering any errors. After letting it run for
> 20 minutes, it eventually completed.
>
> Changing the spring.jpa.hibernate.ddl-auto setting from update to none
> allowed it to run immediately without any delays.

That could suggest that the problem was not actually those fetch
responses, but that your application was attempting to run DDL and was
waiting on a metadata lock.

Although Firebird supports concurrent DDL, there are some problems with
it, because other operations take out a metadata lock on objects
(tables, etc.), and the default transaction settings of Jaybird will
cause an indefinite wait.

However, that is all supposition on my part, and without debugging the
actual application and seeing thread stacktrace when it seems to be
stuck, that is hard to be sure.

In any case, good to hear that you were able to solve your problem. I'll
see if I can find out why and when Firebird sends those fetch response
with status FETCH_OK and count 0, and change Jaybird to no longer log
them as unexpected.

Mark
--
Mark Rotteveel

Mark Rotteveel

unread,
Mar 26, 2025, 9:15:46 AMMar 26
to firebi...@googlegroups.com
On 26/03/2025 12:16, 'Mark Rotteveel' via firebird-java wrote:
> In any case, good to hear that you were able to solve your problem. I'll
> see if I can find out why and when Firebird sends those fetch response
> with status FETCH_OK and count 0, and change Jaybird to no longer log
> them as unexpected.

The unexpected fetch response logging was simply incorrect for this
case. This fetch response signals the end of a batch of fetched rows if
the end of cursor wasn't reached yet, and although it was logged as
unexpected, the way it was handled (ending the fetch loop) was the
proper course of action.

In other words, it cannot have been related to the problem you were
experiencing. In any case, the logging will be fixed in Jaybird 6.0.1
and 5.0.7 (and 7.0.0).

Mark
--
Mark Rotteveel

Tim Schmitt

unread,
Mar 27, 2025, 3:56:11 AMMar 27
to firebird-java
Okay, thanks for the info and the fast help. I appreciate it.
Reply all
Reply to author
Forward
0 new messages