2 @message |
firebird.driver.types.InterfaceError: Result code does not match request code
LOG DETAILS:
2025-06-28 15:34:00.259
2025-06-28 15:34:00.267 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-28 15:34:00.276 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-28 15:34:00.285
2025-06-28 15:34:00.295 @pytest.mark.encryption
2025-06-28 15:34:00.304 @pytest.mark.version('>=3.0.2')
2025-06-28 15:34:00.312 def test_1(act: Action, capsys):
2025-06-28 15:34:00.319 map_dbo = {}
2025-06-28 15:34:00.325
2025-06-28 15:34:00.330 # Query to find first generators page number:
2025-06-28 15:34:00.337 first_gens_page_sql = f"""
2025-06-28 15:34:00.344 select p.rdb$page_number
2025-06-28 15:34:00.353 from rdb$pages p
2025-06-28 15:34:00.360 where p.rdb$page_type = {GENS_PAGE}
2025-06-28 15:34:00.367 order by p.rdb$page_number desc
2025-06-28 15:34:00.374 rows 1
2025-06-28 15:34:00.382 """
2025-06-28 15:34:00.393
2025-06-28 15:34:00.404 # Query to find relation_id and first PP for 'TEST' table:
2025-06-28 15:34:00.413 first_pp_sql = f"""
2025-06-28 15:34:00.423 select p.rdb$relation_id, p.rdb$page_number
2025-06-28 15:34:00.436 from rdb$pages p
2025-06-28 15:34:00.448 join rdb$relations r on p.rdb$relation_id = r.rdb$relation_id
2025-06-28 15:34:00.460 where r.rdb$relation_name=upper('TEST') and p.rdb$page_type = {POINTER_PAGE}
2025-06-28 15:34:00.472 order by p.rdb$page_number
2025-06-28 15:34:00.483 rows 1
2025-06-28 15:34:00.496 """
2025-06-28 15:34:00.507
2025-06-28 15:34:00.519 broken_pages_map = { POINTER_PAGE : [], DATA_PAGE : [], IDX_ROOT_PAGE : [], IDX_B_TREE : [], BLOB_PAGE : [], GENS_PAGE : [] }
2025-06-28 15:34:00.532 with act.db.connect() as con:
2025-06-28 15:34:00.540 fill_dbo(con, map_dbo)
2025-06-28 15:34:00.548 c = con.cursor()
2025-06-28 15:34:00.554
2025-06-28 15:34:00.565 broken_pages_map[GENS_PAGE] = [c.execute(first_gens_page_sql).fetchone()[0],]
2025-06-28 15:34:00.575
2025-06-28 15:34:00.583 test_rel_id, test_rel_first_pp = c.execute(first_pp_sql).fetchone()
2025-06-28 15:34:00.592
2025-06-28 15:34:00.604 # Found first page for each of three types: Data, Index and Blob
2025-06-28 15:34:00.613 # (loop starts from first PointerPage of table 'TEST')
2025-06-28 15:34:00.620 brk_datapage = brk_indxpage = brk_blobpage = -1
2025-06-28 15:34:00.627
2025-06-28 15:34:00.635 for page_no in range(test_rel_first_pp, con.info.pages_allocated):
2025-06-28 15:34:00.644 > page_type, relation_id, page_info = parse_page_header(con, page_no, map_dbo)
2025-06-28 15:34:00.652
2025-06-28 15:34:00.659 tests/bugs/core_5501_test.py:423:
2025-06-28 15:34:00.665 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
2025-06-28 15:34:00.671
2025-06-28 15:34:00.678 con = Connection[2997], page_number = 406
2025-06-28 15:34:00.688 map_dbo = {(128, -1): ('TEST', ''), (128, 0): ('TEST', 'TEST_S_UNQ')}
2025-06-28 15:34:00.697
2025-06-28 15:34:00.704 def parse_page_header(con: Connection, page_number: int, map_dbo: Dict):
2025-06-28 15:34:00.710 > page_buffer = con.info.get_page_content(page_number)
2025-06-28 15:34:00.720
2025-06-28 15:34:00.729 tests/bugs/core_5501_test.py:263:
2025-06-28 15:34:00.737 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
2025-06-28 15:34:00.743
2025-06-28 15:34:00.752 self = <firebird.driver.core.DatabaseInfoProvider object at [hex]>
2025-06-28 15:34:00.765 page_number = 406
2025-06-28 15:34:00.774
2025-06-28 15:34:00.782 def get_page_content(self, page_number: int) -> bytes:
2025-06-28 15:34:00.789 """Returns content of single database page.
2025-06-28 15:34:00.795
2025-06-28 15:34:00.801 Arguments:
2025-06-28 15:34:00.807 page_number: Sequence number of database page to be fetched from server.
2025-06-28 15:34:00.813 """
2025-06-28 15:34:00.824 > return self.get_info(DbInfoCode.PAGE_CONTENTS, page_number)
2025-06-28 15:34:00.833
2025-06-28 15:34:00.840 ../lib/python3.11/site-packages/firebird/driver/core.py:1338:
2025-06-28 15:34:00.847 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
2025-06-28 15:34:00.853
2025-06-28 15:34:00.862 self = <firebird.driver.core.DatabaseInfoProvider object at [hex]>
2025-06-28 15:34:00.870 info_code = <DbInfoCode.PAGE_CONTENTS: 113>, page_number = 406
2025-06-28 15:34:00.876
2025-06-28 15:34:00.881 def get_info(self, info_code: DbInfoCode, page_number: int=None) -> Any:
2025-06-28 15:34:00.887 """Returns requested information from associated attachment.
2025-06-28 15:34:00.894
2025-06-28 15:34:00.905 Arguments:
2025-06-28 15:34:00.913 info_code: A code specifying the required information.
2025-06-28 15:34:00.919 page_number: A page number for `DbInfoCode.PAGE_CONTENTS` request. Ignored for other requests.
2025-06-28 15:34:00.925
2025-06-28 15:34:00.929 Returns:
2025-06-28 15:34:00.934 The data type of returned value depends on information required.
2025-06-28 15:34:00.939 """
2025-06-28 15:34:00.946 if info_code in self._cache:
2025-06-28 15:34:00.954 return self._cache[info_code]
2025-06-28 15:34:00.960 if info_code not in self._handlers:
2025-06-28 15:34:00.967 raise NotSupportedError(f"Info code {info_code} not supported by engine version {self.__engine_version}")
2025-06-28 15:34:00.973 self.response.clear()
2025-06-28 15:34:00.978 request = bytes([info_code])
2025-06-28 15:34:00.988 if info_code == DbInfoCode.PAGE_CONTENTS:
2025-06-28 15:34:00.999 request += (4).to_bytes(2, 'little')
2025-06-28 15:34:01.007 request += page_number.to_bytes(4, 'little')
2025-06-28 15:34:01.014 if len(self.response.raw) < self.page_size + 10:
2025-06-28 15:34:01.025 self.response.resize(self.page_size + 10)
2025-06-28 15:34:01.034 self._get_data(request)
2025-06-28 15:34:01.042 tag = self.response.get_tag()
2025-06-28 15:34:01.052 if request[0] != tag:
2025-06-28 15:34:01.063 if info_code in (DbInfoCode.ACTIVE_TRANSACTIONS, DbInfoCode.LIMBO):
2025-06-28 15:34:01.072 # isc_info_active_transactions and isc_info_limbo with no transactions to
2025-06-28 15:34:01.080 # report returns empty buffer and does not follow this rule
2025-06-28 15:34:01.086 pass
2025-06-28 15:34:01.096 elif tag == isc_info_error: # pragma: no cover
2025-06-28 15:34:01.106 raise InterfaceError("An error response was received")
2025-06-28 15:34:01.114 else: # pragma: no cover
2025-06-28 15:34:01.120 > raise InterfaceError("Result code does not match request code")
2025-06-28 15:34:01.127 E firebird.driver.types.InterfaceError: Result code does not match request code
2025-06-28 15:34:01.136
2025-06-28 15:34:01.146 ../lib/python3.11/site-packages/firebird/driver/core.py:1316: InterfaceError
2025-06-28 15:34:01.154 ---------------------------- Captured stdout setup -----------------------------
2025-06-28 15:34:01.163 Creating db: localhost:/var/tmp/qa_2024/test_11115/test.fdb [page_size=8192, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
|
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>
@pytest.mark.encryption
@pytest.mark.version('>=3.0.2')
def test_1(act: Action, capsys):
map_dbo = {}
# Query to find first generators page number:
first_gens_page_sql = f"""
select p.rdb$page_number
from rdb$pages p
where p.rdb$page_type = {GENS_PAGE}
order by p.rdb$page_number desc
rows 1
"""
# Query to find relation_id and first PP for 'TEST' table:
first_pp_sql = f"""
select p.rdb$relation_id, p.rdb$page_number
from rdb$pages p
join rdb$relations r on p.rdb$relation_id = r.rdb$relation_id
where r.rdb$relation_name=upper('TEST') and p.rdb$page_type = {POINTER_PAGE}
order by p.rdb$page_number
rows 1
"""
broken_pages_map = { POINTER_PAGE : [], DATA_PAGE : [], IDX_ROOT_PAGE : [], IDX_B_TREE : [], BLOB_PAGE : [], GENS_PAGE : [] }
with act.db.connect() as con:
fill_dbo(con, map_dbo)
c = con.cursor()
broken_pages_map[GENS_PAGE] = [c.execute(first_gens_page_sql).fetchone()[0],]
test_rel_id, test_rel_first_pp = c.execute(first_pp_sql).fetchone()
# Found first page for each of three types: Data, Index and Blob
# (loop starts from first PointerPage of table 'TEST')
brk_datapage = brk_indxpage = brk_blobpage = -1
for page_no in range(test_rel_first_pp, con.info.pages_allocated):
> page_type, relation_id, page_info = parse_page_header(con, page_no, map_dbo)
tests/bugs/core_5501_test.py:423:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
con = Connection[2997], page_number = 406
map_dbo = {(128, -1): ('TEST', ''), (128, 0): ('TEST', 'TEST_S_UNQ')}
def parse_page_header(con: Connection, page_number: int, map_dbo: Dict):
> page_buffer = con.info.get_page_content(page_number)
tests/bugs/core_5501_test.py:263:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
self = <firebird.driver.core.DatabaseInfoProvider pytest object at [hex]>
page_number = 406
def get_page_content(self, page_number: int) -> bytes:
"""Returns content of single database page.
Arguments:
page_number: Sequence number of database page to be fetched from server.
"""
> return self.get_info(DbInfoCode.PAGE_CONTENTS, page_number)
../lib/python3.11/site-packages/firebird/driver/core.py:1338:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
self = <firebird.driver.core.DatabaseInfoProvider pytest object at [hex]>
info_code = <DbInfoCode.PAGE_CONTENTS: 113>, page_number = 406
def get_info(self, info_code: DbInfoCode, page_number: int=None) -> Any:
"""Returns requested information from associated attachment.
Arguments:
info_code: A code specifying the required information.
page_number: A page number for `DbInfoCode.PAGE_CONTENTS` request. Ignored for other requests.
Returns:
The data type of returned value depends on information required.
"""
if info_code in self._cache:
return self._cache[info_code]
if info_code not in self._handlers:
raise NotSupportedError(f"Info code {info_code} not supported by engine version {self.__engine_version}")
self.response.clear()
request = bytes([info_code])
if info_code == DbInfoCode.PAGE_CONTENTS:
request += (4).to_bytes(2, 'little')
request += page_number.to_bytes(4, 'little')
if len(self.response.raw) < self.page_size + 10:
self.response.resize(self.page_size + 10)
self._get_data(request)
tag = self.response.get_tag()
if request[0] != tag:
if info_code in (DbInfoCode.ACTIVE_TRANSACTIONS, DbInfoCode.LIMBO):
# isc_info_active_transactions and isc_info_limbo with no transactions to
# report returns empty buffer and does not follow this rule
pass
elif tag == isc_info_error: # pragma: no cover
raise InterfaceError("An error response was received")
else: # pragma: no cover
> raise InterfaceError("Result code does not match request code")
E firebird.driver.types.InterfaceError: Result code does not match request code
../lib/python3.11/site-packages/firebird/driver/core.py:1316: InterfaceError
|