Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
Server crashed ?

assert   
  - Statement failed, SQLSTATE = 39000
  + Statement failed, SQLSTATE = 08006
  - function MAKE_DBKEY could not be matched
  + Error reading data from the connection.
  - Statement failed, SQLSTATE = 39000
  + Statement failed, SQLSTATE = 08006
  - function MAKE_DBKEY could not be matched
  + Error writing data to the connection.
  + Statement failed, SQLSTATE = 08006
  + Error writing data to the connection.
  + Statement failed, SQLSTATE = 08006
  + Error writing data to the connection.

LOG DETAILS:

2024-09-01 14:46:59.163
2024-09-01 14:46:59.163 act = <firebird.qa.plugin.Action object at [hex]>
2024-09-01 14:46:59.163
2024-09-01 14:46:59.163     @pytest.mark.version('>=4.0.6')
2024-09-01 14:46:59.163     def test_1(act: Action):
2024-09-01 14:46:59.163
2024-09-01 14:46:59.163         expected_stdout = f"""
2024-09-01 14:46:59.163             Statement failed, SQLSTATE = 39000
2024-09-01 14:46:59.163             function MAKE_DBKEY could not be matched
2024-09-01 14:46:59.163
2024-09-01 14:46:59.163             Statement failed, SQLSTATE = 39000
2024-09-01 14:46:59.163             function MAKE_DBKEY could not be matched
2024-09-01 14:46:59.163         """
2024-09-01 14:46:59.163         act.expected_stdout = expected_stdout
2024-09-01 14:46:59.163         act.execute(combine_output = True)
2024-09-01 14:46:59.163 >       assert act.clean_stdout == act.clean_expected_stdout
2024-09-01 14:46:59.163 E       assert
2024-09-01 14:46:59.164 E         - Statement failed, SQLSTATE = 39000
2024-09-01 14:46:59.164 E         + Statement failed, SQLSTATE = 08006
2024-09-01 14:46:59.164 E         - function MAKE_DBKEY could not be matched
2024-09-01 14:46:59.164 E         + Error reading data from the connection.
2024-09-01 14:46:59.164 E         - Statement failed, SQLSTATE = 39000
2024-09-01 14:46:59.164 E         + Statement failed, SQLSTATE = 08006
2024-09-01 14:46:59.164 E         - function MAKE_DBKEY could not be matched
2024-09-01 14:46:59.164 E         + Error writing data to the connection.
2024-09-01 14:46:59.164 E         + Statement failed, SQLSTATE = 08006
2024-09-01 14:46:59.164 E         + Error writing data to the connection.
2024-09-01 14:46:59.164 E         + Statement failed, SQLSTATE = 08006
2024-09-01 14:46:59.164 E         + Error writing data to the connection.
2024-09-01 14:46:59.164
2024-09-01 14:46:59.164 tests\bugs\gh_8221_test.py:38: AssertionError
2024-09-01 14:46:59.164 ---------------------------- Captured stdout setup ----------------------------
2024-09-01 14:46:59.165 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11581\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>

    @pytest.mark.version('>=4.0.6')
    def test_1(act: Action):
    
        expected_stdout = f"""
            Statement failed, SQLSTATE = 39000
            function MAKE_DBKEY could not be matched
    
            Statement failed, SQLSTATE = 39000
            function MAKE_DBKEY could not be matched
        """
        act.expected_stdout = expected_stdout
        act.execute(combine_output = True)
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E         - Statement failed, SQLSTATE = 39000
E         + Statement failed, SQLSTATE = 08006
E         - function MAKE_DBKEY could not be matched
E         + Error reading data from the connection.
E         - Statement failed, SQLSTATE = 39000
E         + Statement failed, SQLSTATE = 08006
E         - function MAKE_DBKEY could not be matched
E         + Error writing data to the connection.
E         + Statement failed, SQLSTATE = 08006
E         + Error writing data to the connection.
E         + Statement failed, SQLSTATE = 08006
E         + Error writing data to the connection.

tests\bugs\gh_8221_test.py:38: AssertionError
4 #stack
#  00000`0039f000 Unfrozen
 #     Call Site
00     ntdll!NtWaitForMultipleObjects+0x14
01     KERNELBASE!WaitForMultipleObjectsEx+0xf0
02     KERNELBASE!WaitForMultipleObjects+0xe
03     kernel32!WerpLaunchAeDebug+0x2cba
04     kernel32!WerpLaunchAeDebug+0x26f6
05     KERNELBASE!UnhandledExceptionFilter+0x3d9
06     ntdll!memset+0x1218
07     ntdll!_C_specific_handler+0x96
08     ntdll!_chkstk+0x11f
09     ntdll!RtlRaiseException+0x484
0a     ntdll!KiUserExceptionDispatcher+0x2e
***for engine13.dll
0b     engine13!`anonymous namespace'::setParamsMakeDbkey(class DataTypeUtilBase * __formal = 0x00000000`0604daf0, class SysFunction * __formal = 0x00000040`00000000, int argsCount = 0n33148200, struct dsc ** args = 0x00000000`0603cb78) [h:\snapshots\hqbird\src\jrd\sysfunction.cpp @ 843]
0c     engine13!Jrd::SysFuncCallNode::dsqlPass(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40)+0x53b [h:\snapshots\hqbird\src\dsql\exprnodes.cpp @ 12272]
0d     engine13!Jrd::Node::doDsqlPass(void)+0x19 [h:\snapshots\hqbird\src\dsql\nodes.h @ 130]
0e     engine13!Jrd::ComparativeBoolNode::dsqlPass(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40)+0x2ad [h:\snapshots\hqbird\src\dsql\boolnodes.cpp @ 403]
0f     engine13!Jrd::Node::doDsqlPass(void)+0x15 [h:\snapshots\hqbird\src\dsql\nodes.h @ 130]
10     engine13!Jrd::Node::doDsqlPass<Jrd::BoolExprNode>(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40, class NestConst<Jrd::BoolExprNode> * node = <Value unavailable error>, bool psql = <Value unavailable error>)+0x44 [h:\snapshots\hqbird\src\dsql\nodes.h @ 148]
11     engine13!pass1_rse_impl(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40, class Jrd::RecordSourceNode * input = 0x00000000`00000000, class Jrd::ValueListNode * order = 0x00000000`00000000, class Jrd::RowsClause * rows = 0x00000000`00000000, bool updateLock = false, unsigned short flags = 0)+0x3a6 [h:\snapshots\hqbird\src\dsql\pass1.cpp @ 1877]
12     engine13!pass1_rse(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40, class Jrd::RecordSourceNode * input = 0x00000000`075ac070, class Jrd::ValueListNode * order = 0x00000000`00000000, class Jrd::RowsClause * rows = 0x00000000`00000000, bool updateLock = false, unsigned short flags = 0)+0x170 [h:\snapshots\hqbird\src\dsql\pass1.cpp @ 1780]
13     engine13!pass1_rse_impl(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40, class Jrd::RecordSourceNode * input = 0x00007ff8`9d7630c3, class Jrd::ValueListNode * order = 0x00000000`00000000, class Jrd::RowsClause * rows = 0x00000000`00000000, bool updateLock = false, unsigned short flags = 0)+0xc6 [h:\snapshots\hqbird\src\dsql\pass1.cpp @ 1807]
14     engine13!pass1_rse(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40, class Jrd::RecordSourceNode * input = 0x00000000`075ac170, class Jrd::ValueListNode * order = 0x00000000`00000000, class Jrd::RowsClause * rows = 0x00000000`00000000, bool updateLock = false, unsigned short flags = 0)+0x170 [h:\snapshots\hqbird\src\dsql\pass1.cpp @ 1780]
15     engine13!PASS1_rse(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40, class Jrd::SelectExprNode * input = <Value unavailable error>, bool updateLock = <Value unavailable error>)+0x27 [h:\snapshots\hqbird\src\dsql\pass1.cpp @ 588]
16     engine13!Jrd::SelectNode::dsqlPass(class Jrd::DsqlCompilerScratch * dsqlScratch = 0x00000000`0604cb40)+0xa9 [h:\snapshots\hqbird\src\dsql\stmtnodes.cpp @ 7835]
17     engine13!Jrd::Node::doDsqlPass(void)+0x1d [h:\snapshots\hqbird\src\dsql\nodes.h @ 130]
18     engine13!Jrd::DsqlDmlRequest::dsqlPass(class Jrd::thread_db * tdbb = 0x00000000`01f9ed20, class Jrd::DsqlCompilerScratch * scratch = 0x00000000`0604cb40, bool * destroyScratchPool = 0x00000000`01f9e5c0, unsigned int * traceResult = 0x00000000`01f9e5d0)+0xb5 [h:\snapshots\hqbird\src\dsql\dsql.cpp @ 729]
19     engine13!prepareStatement(class Jrd::thread_db * tdbb = 0x00000000`01f9ed20, class Jrd::dsql_dbb * database = 0x00000000`05a622f0, class Jrd::jrd_tra * transaction = 0x00000000`05871e00, unsigned long textLength = 0x6ae50, char * text = 0x00000000`009ae9b0 "select 1 from rdb$database where rdb$db_key = make_dbkey()C", unsigned short clientDialect = 3, bool isInternalRequest = false)+0xc7f [h:\snapshots\hqbird\src\dsql\dsql.cpp @ 1783]
1a     engine13!DSQL_prepare(class Jrd::thread_db * tdbb = 0x00000000`01f9ed20, class Jrd::Attachment * attachment = 0x00000000`05871e00, class Jrd::jrd_tra * transaction = 0x00000000`06087640, unsigned long length = 0x3a, char * string = 0x00000000`009ae9b0 "select 1 from rdb$database where rdb$db_key = make_dbkey()C", unsigned short dialect = 3, unsigned int prepareFlags = 0x47, class Firebird::Array<unsigned char,Firebird::EmptyStorage<unsigned char> > * items = 0x00000000`01f9ec00, class Firebird::Array<unsigned char,Firebird::EmptyStorage<unsigned char> > * buffer = 0x00000000`01f9ebe8, bool isInternalRequest = false)+0x93 [h:\snapshots\hqbird\src\dsql\dsql.cpp @ 530]
1b     engine13!Jrd::JAttachment::prepare(class Firebird::CheckStatusWrapper * user_status = 0x00000000`01f9eef8, class Firebird::ITransaction * apiTra = 0x00000000`0000003a, unsigned int stmtLength = 0x3a, char * sqlStmt = 0x00000000`009ae9b0 "select 1 from rdb$database where rdb$db_key = make_dbkey()C", unsigned int dialect = 3, unsigned int flags = 0x47)+0x248 [h:\snapshots\hqbird\src\jrd\jrd.cpp @ 5627]
***for fbclient.dll
1c     engine13!Firebird::IAttachmentBaseImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::IReferenceCountedImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IAttachment> > > > >::cloopprepareDispatcher(class Firebird::IAttachment * self = 0x00000000`03edc028, class Firebird::IStatus * status = 0x00000000`03edc028, class Firebird::ITransaction * tra = 0x00000000`03edccc8, unsigned int stmtLength = 0x3a, char * sqlStmt = 0x00000000`009ae9b0 "select 1 from rdb$database where rdb$db_key = make_dbkey()C", unsigned int dialect = 3, unsigned int flags = 0x47)+0x70 [h:\snapshots\hqbird\src\include\firebird\idlfbinterfaces.h @ 11204]
1d     fbclient!Firebird::IAttachment::prepare(void)+0x4d [h:\snapshots\hqbird\src\include\firebird\idlfbinterfaces.h @ 2532]
1e     fbclient!Why::YAttachment::prepare(class Firebird::CheckStatusWrapper * status = 0x00000000`01f9f018, class Firebird::ITransaction * transaction = 0x00000000`0000003a, unsigned int stmtLength = 0x3a, char * sqlStmt = 0x00000000`009ae9b0 "select 1 from rdb$database where rdb$db_key = make_dbkey()C", unsigned int dialect = 3, unsigned int flags = 0x47)+0xc1 [h:\snapshots\hqbird\src\yvalve\why.cpp @ 5518]
1f     fbclient!Firebird::IAttachmentBaseImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::IReferenceCountedImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IAttachment> > > > >::cloopprepareDispatcher(class Firebird::IAttachment * self = 0x00000000`009c6528, class Firebird::IStatus * status = 0x00000000`00888740, class Firebird::ITransaction * tra = 0x00000000`009c7658, unsigned int stmtLength = 0x3a, char * sqlStmt = 0x00000000`009ae9b0 "select 1 from rdb$database where rdb$db_key = make_dbkey()C", unsigned int dialect = 3, unsigned int flags = 0x47)+0x70 [h:\snapshots\hqbird\src\include\firebird\idlfbinterfaces.h @ 11204]
20     firebird!Firebird::IAttachment::prepare(unsigned int stmtLength = 0x3a, char * sqlStmt = 0x00000000`009ae9b0 "select 1 from rdb$database where rdb$db_key = make_dbkey()C", unsigned int dialect = 3)+0x43 [h:\snapshots\hqbird\src\include\firebird\idlfbinterfaces.h @ 2532]
21     firebird!rem_port::prepare_statement(struct p_sqlst * prepareL = 0x00000000`008b3200, struct packet * sendL = 0x00000000`008b2958)+0x36f [h:\snapshots\hqbird\src\remote\server\server.cpp @ 4739]
22     firebird!process_packet(struct rem_port * port = 0x00000000`00888740, struct packet * sendL = 0x00000000`008b2958, struct packet * receive = 0x00000000`008b2ef8, struct rem_port ** result = 0x00000000`01f9fec8)+0x4fc [h:\snapshots\hqbird\src\remote\server\server.cpp @ 5045]
23     firebird!loopThread(void * __formal = 0x00000000`00000008)+0x1bb [h:\snapshots\hqbird\src\remote\server\server.cpp @ 6596]
24     firebird!`anonymous-namespace'::ThreadArgs::run(void)+0x5 [h:\snapshots\hqbird\src\common\threadstart.cpp @ 78]
25     firebird!threadStart(void * arg = 0x00000000`00874730)+0x65 [h:\snapshots\hqbird\src\common\threadstart.cpp @ 97]
26     ucrtbase!configthreadlocale+0x92
27     kernel32!BaseThreadInitThunk+0x14
28     ntdll!RtlUserThreadStart+0x21

Full history of outcomes and elapsed time, ms:
NN SNAP_INFO CS_outcome SS_outcome CS_run_time SS_run_time CS_run_beg CS_run_end SS_run_beg SS_run_end
1 4.0.6.3189 2025.02.25 1a1a5 P P 599 398 2025.06.28 13:20:01.105 2025.06.28 13:20:01.704 2025.06.28 12:21:22.094 2025.06.28 12:21:22.492
2 4.0.6.3184 2025.02.24 9388c P P 634 401 2025.02.25 10:58:54.179 2025.02.25 10:58:54.813 2025.02.25 09:41:42.526 2025.02.25 09:41:42.927
3 4.0.6.3183 2025.02.17 e4762 P P 626 414 2025.02.24 11:30:59.445 2025.02.24 11:31:00.071 2025.02.24 10:32:05.034 2025.02.24 10:32:05.448
4 4.0.6.3169 2024.12.13 42cc1 P P 599 406 2025.02.14 08:18:47.862 2025.02.14 08:18:48.461 2025.02.14 07:19:54.471 2025.02.14 07:19:54.877
5 4.0.6.3169 2024.12.08 50eb6 P P 610 405 2024.12.11 11:15:21.377 2024.12.11 11:15:21.987 2024.12.11 10:16:51.314 2024.12.11 10:16:51.719
6 4.0.6.3168 2024.12.07 98d69 P P 635 440 2024.12.08 03:58:55.259 2024.12.08 03:58:55.894 2024.12.08 02:58:33.994 2024.12.08 02:58:34.434
7 4.0.6.3168 2024.12.05 cee43 P P 627 419 2024.12.06 04:02:07.738 2024.12.06 04:02:08.365 2024.12.06 03:03:08.462 2024.12.06 03:03:08.881
8 4.0.6.3168 2024.11.28 48149 P P 606 409 2024.12.03 10:55:21.121 2024.12.03 10:55:21.727 2024.12.03 09:57:32.013 2024.12.03 09:57:32.422
9 4.0.6.3163 2024.10.30 832db P P 656 411 2024.11.28 10:54:02.518 2024.11.28 10:54:03.174 2024.11.28 09:56:24.634 2024.11.28 09:56:25.045
10 4.0.6.3163 2024.10.16 2bb10 P P 616 410 2024.10.30 11:03:03.051 2024.10.30 11:03:03.667 2024.10.30 10:05:17.753 2024.10.30 10:05:18.163
11 4.0.6.3147 2024.09.10 a4d11 P P 606 393 2024.10.16 04:10:30.837 2024.10.16 04:10:31.443 2024.10.16 02:53:40.438 2024.10.16 02:53:40.831
12 4.0.6.3147 2024.08.31 4655b P P 661 404 2024.09.10 11:08:29.219 2024.09.10 11:08:29.880 2024.09.10 10:06:39.883 2024.09.10 10:06:40.287
13 4.0.6.3140 2024.08.16 1dd8b F E 2741 5260 2024.09.01 11:30:48.383 2024.09.01 11:30:51.124 2024.09.01 10:11:25.543 2024.09.01 10:11:30.803

Elapsed time, ms. Chart for last 13 runs:

Last commits information (all timestamps in UTC):