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-automations opened this issue Mar 7, 2017 · 9 comments
Closed

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

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

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Commented by: Solcraft Programetajs (programetajs)

Screen shot

@firebird-automations
Copy link
Collaborator Author

Modified by: Solcraft Programetajs (programetajs)

Attachment: ^D265B320DF24F3E9B4BC6F149610845FC7F5724E0F5E341730^pimgpsh_fullsize_distr.png [ 13075 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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