Firebird 3.0.9 crashing in multi processors

[Mauricio Silva]

  Hello,
 Settings:
 *Firebird 3.0.9.
 *Windows Server 2012 R2 Standard server.
 *Intel(R) Xeon Processor CPU E-2620 v3 @240GHz - RAM 16GB

 Let's get to the problem:

 We have around 70 Users;
 Our application is multi-Company, that is, the same application can
 work at Headquarters or Branch respectively (1-0) -(1-1) .

 Users work like this:
 They open an application in the Matrix (1-0) and
 another in the Branch (1-1).
 but not all 70 users, only about 20 users do this.

 We migrated from version 2.5 to version 3.0.9.
 and since then our system crashes only on the second connection,
 only at Branch (1-1).

 The server worked uninterrupted for 3 weeks, but out of nowhere, it crashed!!
 The branch connection freezes, but the matrix is normal...

 Firebird version 3.0.9 has some problem with caching jobs from
 servermode=super

 Could someone give me some help?

ServerMode = Super
 CpuAffinityMask = 63    # 6 Núcleos
 DefaultDbCachePages = 50K      # default cache pages for all databases
 FileSystemCacheThreshold = 999M # file cache always on
 TempCacheLimit  =2048M
 LockHashSlots = 49999          # optimal value for lock table
 TempBlockSize = 2M           # optimimal value to grow TempCacheLimit
 MaxUnflushedWrites = -1 # ideal para bancos de dados com intencional
 MaxUnflushedWriteTime = -1 # ideal para bancos de dados com intencional

[Ashley]

Mauricio hi there

what is your connection string?
are you connecting via network stack, or direct to file?

Best regards
Ashley

 

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/b01e611c-0a76-476a-98ea-b0e4df3a2a3cn%40googlegroups.com.

[Mauricio Silva]

Hi, I'm connecting directly
10.x.x.x/3050:F:\directory\File.fdb

thanks

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/b47a6bf8-3b75-d387-f39e-462230e18bba%40softwareshack.co.za.

[Ashley]

Mauricio hi there

Try check what all is connecting?
If anything connects directly to the .fdb it will lock the file. (so like "F:\directory\File.fdb")
So the 2nd connection will be denied.
All your connections must use the "10.x.x.x" in their connection string.

Best regards
Ashley

 

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAHy4k%2BWwqEZxgPL7dpkL-4SS-PVHZOBcpNB%2BeLDzkPgx0Gopcg%40mail.gmail.com.

[Mauricio Silva]

Yes, all connections use the same string defined in an .ini in the installation's local driver.

It worked perfectly, for 3 weeks with no problems.
But for some reason on Monday, it showed the glitches.

We reinstalled FB3.0.9. and returned to normal.
This has happened 4 times in the last 2 months.
It only goes back to normal after uninstalling FB3.0.9 on the server and restarting and installing it again.

Thanks

You received this message because you are subscribed to a topic in the Google Groups "firebird-support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/firebird-support/oOQRo4t495E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/654e84c6-1ea4-571e-6d02-5528b152e27a%40softwareshack.co.za.

[Karol Bieniaszewski]

Hi

 

Can you explain it more. It crashed or firized? As you wrote both words.

And if crashed how do you recognize it? Server proces changed PID in proces manager? Any log from crash?

 

Regards,

Karol Bieniaszewski

--

[Mauricio Silva]

the logs only show this:
SERVER3 Mon May 09 15:32:10 2022
   INET/inet_error: read errno = 10054, client host = vendas-7, address = 10.x.x.x/59133, user = elensilva

SERVER3 Mon May 09 15:33:03 2022
   INET/inet_error: read errno = 10054, client host = roders-2, address = 10.x.x.x/50424, user = roders


At first users can connect, but after some instability, the system freezes.
It doesn't open anything else, the screen stays static
Only in the matrix, but in the branch that is the same base, normal connection.

Sorry for my english, I'm using google translator.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4LDZNl6FPmz1tFh%40smtp.poczta.onet.pl.

[Karol Bieniaszewski]

Error 10054 occurs when the connection is reset by the peer application, usually due to an incorrect firewall configuration..

 

>>> At first users can connect, but after some instability, the system freezes.

 

Which system freezes, client application? Or Firebird server proces?

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAHy4k%2BUgDtHWL-5R9zaVRGM9PFGaHBA71H8feRpWZsg%3DoNoLqg%40mail.gmail.com.

 

[Mauricio Silva]

Initially I thought the same thing.
But that would always happen if it was firewall.
But the error occurs after few days.
And when it happens we have to uninstall and install firebird to get it back to normal.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4LDZs91cxNzlgD9w%40smtp.poczta.onet.pl.

[Rafik Berzi]

Look into your Widows firewall, insure to remove any 3050 open port and add the application (firebird.exe) TCP.

[Mathias Pannier (unitel)]

Hello,

 

maybe some connections are not disconnecting correctly? And then a new connection cannot be established because of TCP/IP Limit. http://www.firebirdfaq.org/faq292/

I had a similar problem and if there are too much connections it seems that the server “freezes”: https://mathiaspannier.wordpress.com/2016/04/24/maximale-anzahl-an-socketfirebird-verbindungen/

 

Regards

Mathias

 

Von: firebird...@googlegroups.com [mailto:firebird...@googlegroups.com] Im Auftrag von Mauricio Silva
Gesendet: Donnerstag, 2. Juni 2022 21:22
An: firebird...@googlegroups.com
Betreff: Re: [firebird-support] Firebird 3.0.9 crashing in multi processors

 

ACHTUNG: Diese E-Mail stammt von einem externen Absender. Bitte vermeiden Sie es, Anhänge oder externe Links zu öffnen.

 

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAHy4k%2BUfwtE4Y%2BUfrGCAOCorgUyYbNiA0Wb-yV4rgKgDK1Vb-A%40mail.gmail.com.

ub.unitel GmbH, Schulstraße 16, 06792 Sandersdorf-Brehna
Geschaeftsfuehrung Klaus Richter, Olaf Meyer
Amtsgericht Stendal
HRB 26389 FA Bitterfeld Steuernr. 116/107/08597 Ust.identNr. DE815796778
Deutsche Bank IBAN DE53 86070024 0 6143234 00
Kreissparkasse Anhalt-Bitterfeld IBAN DE69 80053722 0 3050326 82
_____________________________________________________________________
Dieses E-Mail ist nur für den Empfänger bestimmt, an den es gerichtet
ist und kann vertrauliches bzw. unter das Berufsgeheimnis fallendes
Material enthalten. Jegliche darin enthaltene Ansicht oder Meinungs-
äußerung ist die des Autors und stellt nicht notwendigerweise die
Ansicht oder Meinung von ub.unitel GmbH dar.
Sind Sie nicht der Empfänger, so haben Sie diese E-Mail irrtümlich
erhalten und jegliche Verwendung, Veröffentlichung, Weiterleitung,
Abschrift oder jeglicher Druck dieser E-Mail ist strengstens untersagt.
_____________________________________________________________________