Re: [firebird-support] Re: Server crash when no more space for the database

2018. 11. 07. 8:51 keltezéssel, hv...@users.sourceforge.net [firebird-support] írta: >   There should be no crash. Errors - yes, crash - no. > Attached log is truncated and i see no message about crash there. https://pastebin.com/0iv3FQcy Gabor

Re: [firebird-support] Re: Server crash when no more space for the database

2018. 11. 08. 12:40 keltezéssel, hv...@users.sourceforge.net [firebird-support] írta: >   And I use web-interface for this group, surprise ? Vlad, I can send the attachment privately. Which address? Gabor

Re: [firebird-support] Re: Server crash when no more space for the database

07.11.2018 14:16, hvlad@... mailto:hvlad@... [firebird-support] wrote: >> The last lines i see inyour message is: >After that several bugchecks wer reported. You should have whole message in >your mail box. >> (Message over 64 KB, truncated) >AFAIU it is limitation of web-interface.

Re: [firebird-support] Re: Server crash when no more space for the database

07.11.2018 14:16, hv...@users.sourceforge.net [firebird-support] wrote: > The last lines i see inyour message is: After that several bugchecks wer reported. You should have whole message in your mail box. > (Message over 64 KB, truncated) AFAIU it is limitation of web-interface. --

Re: [firebird-support] Re: Server crash when no more space for the database

2018. 11. 07. 8:51 keltezéssel, hvlad@... mailto:hvlad@... [firebird-support] írta: >> There should be no crash. Errors - yes, crash - no. >> Attached log is truncated and i see no message about crash there. > The firebird.log not exists when started the OLTP. My second message >

Re: [firebird-support] Re: Server crash when no more space for the database

2018. 11. 07. 8:51 keltezéssel, hv...@users.sourceforge.net [firebird-support] írta: >   There should be no crash. Errors - yes, crash - no. > Attached log is truncated and i see no message about crash there. The firebird.log not exists when started the OLTP. My second message contains the

Re: [firebird-support] Re: Server crash when no more space for the database

On 07/11/2018 07:51, hv...@users.sourceforge.net [firebird-support] wrote: > > While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space > > for the database the server crashed. See the attachment. Is it a known > > limitation (not fixed in 2.5 because it's too old) or a bug? >

[firebird-support] Re: Server crash when no more space for the database

> While I executed some OLTP with 2.5(.9.27119 SS Win64) and no more space > for the database the server crashed. See the attachment. Is it a known > limitation (not fixed in 2.5 because it's too old) or a bug? There should be no crash. Errors - yes, crash - no. Attached log is

Re: [firebird-support] Re: server 2.5.8 deadlocked

On 22/02/18 20:17, hv...@users.sourceforge.net [firebird-support] wrote: ---In firebird-support@yahoogroups.com, wrote : On 13/02/18 17:55, Dmitry Yemanov dimitr@... [firebird-support] wrote: > 13.02.2018 05:07, Hamish Moffatt wrote: > >> I

Re: [firebird-support] Re: server 2.5.8 deadlocked

---In firebird-support@yahoogroups.com, wrote : On 13/02/18 17:55, Dmitry Yemanov dimitr@... mailto:dimitr@... [firebird-support] wrote: > 13.02.2018 05:07, Hamish Moffatt wrote: > >> I attached gdb and dumped the state of all threads, which shows every >> one of them is

Re: [firebird-support] Re: server 2.5.8 deadlocked

On 22/02/18 10:10, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > On 13/02/18 17:55, Dmitry Yemanov dim...@users.sourceforge.net > [firebird-support] wrote: >> 13.02.2018 05:07, Hamish Moffatt wrote: >> >>> I attached gdb and dumped the state of all threads, which shows

[firebird-support] Re: server 2.5.8 deadlocked

13.02.2018 05:07, Hamish Moffatt wrote: > I attached gdb and dumped the state of all threads, which shows every > one of them is waiting on a mutex or futex, ie it's dead locked. I've > attached the trace. You need to download the debug symbols (Firebird-debuginfo-* package) and copy them into

[firebird-support] Re: Server crashes sometimes

---In firebird-support@yahoogroups.com, wrote : > my Database isn’t reachable for short times. This happens once in a few > days. The firebird.log shows following messages: > linux-j4zt Wed Aug > 17 10:59:58 2016 > /usr/sbin/fbguard: /usr/sbin/firebird

[firebird-support] RE: Server setup advice

Classic server it might help on robustness : each connection will be isolated (where a crashing server doesn't take down the other connections and it will use more resources ) , but for scaling it uses the same architecture as SuperClassic (no shared cache) so cpus are used the same way

Re: [firebird-support] Re: Server specs

Thanks Milan. On Thu, Jun 27, 2013 at 8:45 AM, mbabuskov mil...@panonnet.net wrote: ** Mags Phangisa wrote: One of my clients has about 6000 locations but between 1000 and 1500 will be connecting at the same time at any given stage. Most transactions will be selects for reports on a

[firebird-support] Re: Server specs

Mags Phangisa wrote: One of my clients has about 6000 locations but between 1000 and 1500 will be connecting at the same time at any given stage. Most transactions will be selects for reports on a daily basis and inserts (with file attachments) will only be happening at month ends for

Re: [firebird-support] Re: server version

On Mon, 4 Feb 2013 17:11:08 -0500, Ann Harrison aharri...@ibphoenix.com wrote: On Sun, Feb 3, 2013 at 7:25 PM, Paul Vinkenoog p...@vinkenoog.nl wrote: That works - if the difference between 1.0 and 1.5.6 doesn't matter to you - but the OP wanted a solution that didn't require opening a

Re: [firebird-support] Re: server version

On Mon, 04 Feb 2013 08:09:44 +0800, Wolfgang Kluge wkl...@kb-labuan.com wrote: Good morning Paul I am using Try Qry.Close; Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version 2

Re: [firebird-support] Re: server version

On Sun, Feb 3, 2013 at 7:25 PM, Paul Vinkenoog p...@vinkenoog.nl wrote: That works - if the difference between 1.0 and 1.5.6 doesn't matter to you - but the OP wanted a solution that didn't require opening a database connection first (and as we now know, he needs it for JDBC). That's a

Re: [firebird-support] Re: server version

Ann Harrison wrote: That works - if the difference between 1.0 and 1.5.6 doesn't matter to you - but the OP wanted a solution that didn't require opening a database connection first (and as we now know, he needs it for JDBC). That's a little like wanting to know the color of your prize

[firebird-support] Re: server version

Hello Paul, Thanks for your answer. What I want to do is to determine server version from pure JDBC. I probably posted this question in the wrong group. Should have posted it in Firebird-Java group. BR, Hugo --- In firebird-support@yahoogroups.com, Paul Vinkenoog wrote: Hello Hugo, Is

[firebird-support] Re: server version

Is there a way to determine which version of Firebird is running before connection to a Database? I'm looking in org.firebirdsql.management but cant find anything fitting. Or using Python and fdb library (python binding): import fdb svc =

Re: [firebird-support] Re: server version

Good morning Paul I am using Try Qry.Close; Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version 2 Qry.ExecQuery; cEngineVer := Qry.FieldByName( 'cVer' ).AsString; Qry.Close;

Re: [firebird-support] Re: server version

Hi Wolfgang, I am using Try Qry.Close; Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version 2 Qry.ExecQuery; cEngineVer := Qry.FieldByName( 'cVer' ).AsString; Qry.Close;

[firebird-support] Re: Server

Using this Firebird version I have a server running windows 2003 32 bits. On this server Firebird 2.1 32 bits is running. I have to find out, what kind of SQL this company is actually doing. Can I implement some logic directly on the DB, so I can log and save the SQL? In an easy way?

[firebird-support] Re: Server

--- In firebird-support@yahoogroups.com, Michael Vilhelmsen wrote: Ah - you are right :) Its the amount of start/commit I was referring to. My bad. Statistics are as of now: Database E:\DB\OCCeasyPos.Fdb Database header page information: Flags 0

[firebird-support] Re: Server

These are the number of connect(Login), disconnect(Logout) and transactions. As you can see they are connecting/disconnection some 1700+ times each minute duing the entire day. No - they're just using a lot of transactions. Login and logout match your comparative data below.

[firebird-support] Re: Server

Ah - you are right :) Its the amount of start/commit I was referring to. My bad. Statistics are as of now: Database E:\DB\OCCeasyPos.Fdb Database header page information: Flags 0 Checksum12345 Generation 55467812

Re: [firebird-support] Re: Server

Michael Vilhelmsen schrieb am 07.06.2012 um 10:45 (-): No - they're just using a lot of transactions. Login and logout match your comparative data below. Autocommit mode would easily account for the higher number of transactions. This might be true, but along this we have had some

RE: [firebird-support] Re: Server

As I said earlier whatever they do, they have on job that makes this go from some 80 (which I find a lot still) to 1700+. And its is 24/7. The system should is supossed to look for some stock changes, and then make som entrys to fill up items in the store. This customer has some 40 shops.