Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot create connection for DB Events. [CORE5498] #5767

Closed
firebird-issue-importer opened this issue Mar 7, 2017 · 9 comments
Closed

Cannot create connection for DB Events. [CORE5498] #5767

firebird-issue-importer opened this issue Mar 7, 2017 · 9 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Mar 7, 2017

Submitted by: Solcraft Programetajs (programetajs)

Attachments:
^D265B320DF24F3E9B4BC6F149610845FC7F5724E0F5E341730^pimgpsh_fullsize_distr.png

Error message:
'Unable to complete network request to host "192.168.1.234".
Failed to establish a secondary connection for event processing.
The requested address is not valid in its context. '.

Client 2.5 fbclient.dll, server linux 3.0.2 - OK
Client 3.0.2 fbclient.dll, server windows 8.1 Pro - OK
Client 3.0.2 fbclient.dll, server linux 3.0.2 - Error

Commits: 55df9ac d9e1ab6 6780df6

====== Test Details ======

" if client and server OS have different definitions of AF_INET6 constant." - n/a for current test evrironment

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 10, 2017

Commented by: @AlexPeshkoff

I've rechecked events with fresh 3.0.2 client and server. I've used execute block to post event:

localhost bin #⁠ ./isql -z -user sysdba -pas masterkey localhost:employee
ISQL Version: LI-V3.0.2.32691 Firebird 3.0
Server version:
LI-V3.0.2.32692-dev Firebird 3.0
LI-V3.0.2.32692-dev Firebird 3.0/tcp (localhost)/P14:C
LI-V3.0.2.32691 Firebird 3.0/tcp (localhost)/P14:C
Database: localhost:employee, User: SYSDBA
SQL> set term ^;
SQL> execute block as begin post_event 'ABC'; end^
SQL> commit^
SQL>

I've used flamerobin to monitor events:
17:50:00 Monitoring started
17:50:52 ABC (1)

If you want us to check something else please provide full reproducible test case.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 13, 2017

Commented by: Solcraft Programetajs (programetajs)

Server: CentOS Linux;
Client : Windows 7, 64 bit.

I tried your test and there was not error but when i copied fbclient.dll (32.bit) in flamerobin folder i have got an error.

[Window Title]
Unhandled Error in FlameRobin

[Content]
*** IBPP::SQLException ***
Context: EventsImpl::Queue
Message: isc_que_events failed

SQL Message : -902
can't format message 13:98 -- message file C:\Program Files (x86)\FlameRobin\firebird.msg not found

Engine Code : 335544721
Engine Message :
Unable to complete network request to host "192.168.1.33".
Failed to establish a secondary connection for event processing.
The requested address is not valid in its context.

[OK]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 13, 2017

Commented by: Solcraft Programetajs (programetajs)

Screen shot

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 13, 2017

Modified by: Solcraft Programetajs (programetajs)

Attachment: ^D265B320DF24F3E9B4BC6F149610845FC7F5724E0F5E341730^pimgpsh_fullsize_distr.png [ 13075 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 13, 2017

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 13, 2017

Commented by: @hvlad

The problem is very specific, it happens only if client and server uses ipv6 and if client and server OS have different definitions of AF_INET6 constant.
On Linux it is defined as 10 while on Windows it have value of 23.
Fix is committed into master branch, will be backported after review.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 15, 2017

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.2 [ 10785 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 15, 2017

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Cannot be tested

Test Details: " if client and server OS have different definitions of AF_INET6 constant." - n/a for current test evrironment

Test Specifics: [Platform (Windows/Linux) specific]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 15, 2017

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment