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
