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

Could not connect to production via TCP after delete from mon$attachments issued on *different* database on the same machine [CORE3935] #4268

Closed
firebird-automations opened this issue Sep 24, 2012 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Relate to CORE3993

Attachments:
gdb_fb_smp.zip

I`ve run some heavy query on auxiliary (NON-production) database that is placed on same machine as our production. This query was running too long and I decided to kill it:
isql production_alias
SQL>delete from mon$attachments; quit;

Immediatelly after it we detected that no more new connections to production can be established via TCP. Connections to production via local protocol were avaliable.
The firebird.log does NOT contains any interesting info - only messages with errno=-104.
I could create backtrace of fb_smp_server process when we could not to connect (see attach #⁠1) and after restart linux and restoring common workload of out users (see attach #⁠2).
Unfortunatelly I could NOT make log of fb_lock_print -d /var/db/firebird/production.fdb -a -m -c >fb_lock_print_dead.txt because log file has been created with zero size.

SQL> show version;
ISQL Version: LI-V2.5.2.26448 Firebird 2.5 // SUPERCLASSIC
Server version:
Firebird/linux AMD64 (access method), version "LI-V2.5.2.26448 Firebird 2.5"
on disk structure version 11.2
SQL> show database;
Database: kuntsevomain
Owner: SYSDBA
PAGE_SIZE 16384
Number of DB pages allocated = 1888000
Sweep interval = 0
Forced Writes are OFF
Transaction - oldest = 218095653
Transaction - oldest active = 218307431
Transaction - oldest snapshot = 218307431
Transaction - Next = 218365577
ODS = 11.2
Default Character set: WIN1251

Commits: 102700e a8f8465 7ee2887 3746843 c7454a4 74938ad FirebirdSQL/fbt-repository@211856e FirebirdSQL/fbt-repository@6fa99aa FirebirdSQL/fbt-repository@0a2a1c4 FirebirdSQL/fbt-repository@41b2529

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: gdb_fb_smp.zip [ 12230 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Link: This issue relate to CORE3993 [ CORE3993 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.3 [ 10461 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test

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

No branches or pull requests

2 participants