Problem with establishing connect using client 3.0.2.32708 to server 4.0.0.572 ------------------------------------------------------------------------------
Key: CORE-5508 URL: http://tracker.firebirdsql.org/browse/CORE-5508 Project: Firebird Core Issue Type: Bug Components: API / Client Library, Engine Environment: Windows XP Reporter: Pavel Zotov Steps: 0) create empty database using WI-T4.0.0.572 (using port = 3400) 1) attempt to use client 3.0.2.32643 (06-dec-2016) ==> SUCCESSFUL: === C:\MIX\firebird\QA\fbt-repo>C:\MIX\firebird\fb30Cs\isql localhost/3400:C:\MIX\firebird\QA\fbt-repo\tmp\e40.fdb -z ISQL Version: WI-V3.0.2.32643 Firebird 3.0 Server version: WI-T4.0.0.572 Firebird 4.0 Unstable WI-T4.0.0.572 Firebird 4.0 Unstable/tcp (csprog)/P14 WI-V3.0.2.32643 Firebird 3.0/tcp (csprog)/P14 Database: localhost/3400:C:\MIX\firebird\QA\fbt-repo\tmp\e40.fdb, User: SYSDBA SQL> set list on; select * from mon$attachments where mon$attachment_id=current_connection; MON$ATTACHMENT_ID 18 MON$SERVER_PID 2556 MON$STATE 1 MON$ATTACHMENT_NAME C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\E40.FDB MON$USER SYSDBA MON$ROLE NONE MON$REMOTE_PROTOCOL TCPv4 MON$REMOTE_ADDRESS 127.0.0.1/1310 MON$REMOTE_PID 2792 MON$CHARACTER_SET_ID 0 MON$TIMESTAMP 2017-03-24 09:15:19.2810 MON$GARBAGE_COLLECTION 1 MON$REMOTE_PROCESS C:\MIX\firebird\fb30Cs\isql.exe MON$STAT_ID 14 MON$CLIENT_VERSION WI-V3.0.2.32643 Firebird 3.0 MON$REMOTE_VERSION P14 MON$REMOTE_HOST csprog MON$REMOTE_OS_USER zotov MON$AUTH_METHOD Legacy_Auth MON$SYSTEM_FLAG 0 MON$IDLE_TIMEOUT 0 MON$IDLE_TIMER <null> MON$STATEMENT_TIMEOUT 0 === 2a) attempt to use client 3.0.2.32708 (its folder: "C:\MIX\firebird\fb30\") === C:\MIX\firebird\QA\fbt-repo>C:\MIX\firebird\fb30\isql localhost/3400:C:\MIX\firebird\QA\fbt-repo\tmp\e40.fdb -z ISQL Version: WI-V3.0.2.32708 Firebird 3.0 Server version: WI-T4.0.0.572 Firebird 4.0 Unstable WI-T4.0.0.572 Firebird 4.0 Unstable/tcp (csprog)/P15 WI-V3.0.2.32708 Firebird 3.0/tcp (csprog)/P15 --- hangs here infinitely --- === 2b) the same but using PIPE mechanism to pass SQL commands iinside ISQL: === C:\MIX\firebird\QA\fbt-repo> echo set list on; select * from mon$attachments where mon$attachment_id=current_connection; | C:\MIX\firebird\fb30\isql localhost/3400:C:\MIX\firebird\QA\fbt-repo\tmp\e40.fdb -z ISQL Version: WI-V3.0.2.32708 Firebird 3.0 Server version: WI-T4.0.0.572 Firebird 4.0 Unstable WI-T4.0.0.572 Firebird 4.0 Unstable/tcp (csprog)/P15 WI-V3.0.2.32708 Firebird 3.0/tcp (csprog)/P15 Statement failed, SQLSTATE = 08006 Error reading data from the connection. Statement failed, SQLSTATE = 08006 Error writing data to the connection. Statement failed, SQLSTATE = 08006 Error writing data to the connection. === firebird.log in the folder "C:\MIX\firebird\fb30\" (i.e. folder of CLIENT, no server) will contain: === CSPROG Fri Mar 24 09:29:42 2017 REMOTE INTERFACE/gds__detach: Unsuccesful detach from database. Uncommitted work may have been lost. Error writing data to the connection. === PS. Server is OK, no restarts. Command: wmic process where "name='firebird.exe'" get ProcessId,ExecutablePath | findstr /i C:\MIX\firebird\fb40\ -- returns always the same PID of working FB40 instance ("C:\MIX\firebird\fb40\" = folder of server 4.0.0.572 which listens port 3400). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel