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

Jump to bottom

Firebird Freeze - INET/inet_error: read errno = 9 on local connection. [CORE2110] #2544

Closed
firebird-automations opened this issue Oct 8, 2008 · 9 comments
Closed

Firebird Freeze - INET/inet_error: read errno = 9 on local connection. [CORE2110] #2544

firebird-automations opened this issue Oct 8, 2008 · 9 comments
Assignees
@AlexPeshkoff
Labels
affect-version: 1.5.5 priority: major resolution: wontfix type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Lucas Fernando Vasconcelos de Arruda Amorim (lucas)

INET/inet_error: read errno = 9 (frequently)
INET/inet_error: select in packet_receive errno = 9 (frequently)
INET/inet_error: connect errno = 111 (freeze on this message)

I own seven databases witch aprox. 10gb, I have this messages on firebird.log.
The connections to database freeze and they don't send me any error message.

I user Firebird 1.5.5 Super Server
And I open only local connections, whitch PHP5 native functions. (ibase_connect)
@firebird-automations
Copy link
Collaborator Author

Modified by: Lucas Fernando Vasconcelos de Arruda Amorim (lucas)

summary: Firebird Freeze - INET/inet_error: read errno = 9 => Firebird Freeze - INET/inet_error: read errno = 9 on local connection.

@firebird-automations
Copy link
Collaborator Author

Modified by: Lucas Fernando Vasconcelos de Arruda Amorim (lucas)

environment: Linux Debian 4
Debian 4
Linux http://www.infoplusdobrasil.com.br 2.6.18-6-686-bigmem #⁠1 SMP Mon Aug 18 09:58:16 UTC 2008 i686 GNU/Linux
Mem: 6GB
Proc: 4 x Intel(R) Xeon(TM) CPU 3.00GHz

getconf GNU_LIBPTHREAD_VERSION -> NPTL 2.7

=>

Linux Debian 4
Linux http://www.infoplusdobrasil.com.br 2.6.18-6-686-bigmem #⁠1 SMP Mon Aug 18 09:58:16 UTC 2008 i686 GNU/Linux
Mem: 6GB
Proc: 4 x Intel(R) Xeon(TM) CPU 3.00GHz

getconf GNU_LIBPTHREAD_VERSION -> NPTL 2.7

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

This seems to be a known bug in SS - it was fixed in FB 2.0. The only thing that makes me surpised here - please explain what do you mean under local connections with superserver?

To try to minimize effect in 1.5 try to set TCP's keepalive to small value (about 1 minute, default is 2 hours). After this time SS should become alive again.

@firebird-automations
Copy link
Collaborator Author

Commented by: Lucas Fernando Vasconcelos de Arruda Amorim (lucas)

Only there are connections by PHP that are on the same machine, so I use ibase_pconnect ( 'localhost: / mygdb.gdb');

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Aah - using localhost:
That are anyway TCP connections :)

You should upgrade FB version - this fix is not supposed to be backported in 1.5 branch.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Franz J Fortuny (frafor49)

My firebird version is 2.5.2 and my php is 5.3, and yet I'm see in a log file with lots of errno = 9. And seldom it stops responding until I terminate the task and the Guardian starts it again. Any ideas?

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

@AlexPeshkoff AlexPeshkoff

Labels
affect-version: 1.5.5 priority: major resolution: wontfix type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@AlexPeshkoff @firebird-automations