[firebird-support] Firebird Crash - version 2.5.6

2016-08-30 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi We are running firebird 2.5.6 and at uneven intervals the service is crashing with the following log "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295) It typically happens at night, but not directly related to any scheduled task. It does run on a

Re: [firebird-support] Getting INET/inet_error: read errno = 10054

2016-08-27 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Thanks. Very usefull feedback. 27. aug. 2016 8.45 a.m. skrev "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" <firebird-support@yahoogroups.com>: > > > On 26-8-2016 22:27, Jardar Maatje jardar.maa...@nds.nortek.no > [firebird-support] wrote: > > We ar

[firebird-support] Getting INET/inet_error: read errno = 10054

2016-08-26 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi We are running fb 2.5.6 and are getting the INET erorr regularily. The error has been there before as well with earlier versions of fb. Is this something I should be conserned about and what can I do about it? Another issue is that when I list transactions I have a transaction that is

[firebird-support] Trouble with ADO.Net Provider and connection pool

2016-08-19 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
We are using NHibernate and firebird with C# code. We have a server application that run 24/7. Our problem is that sometimes we get an exception from when starting new transaction: FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Error reading data from the connection. We always dispose

Re: [firebird-support] Gbak restore hangs on "activating and creating deferred indexes"

2016-06-22 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi Normally our restored DB will be 40GB. Is there any reason we would need significantly more space than this when restoring? Secondly are there specific bugs in 2.5.4 which could result in this behaviour? If not I would guess the 2.5.5 would not fix this problem? Best regards Jardar On Wed,

[firebird-support] Find rarely used or unused indices

2016-04-08 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi What is the best way to go about to find out about this? I have several projects that are using the FB database and I would like to cleanup and remove all the indices that are just taking up space and thus indirectly reduces performance? Best regards jardar

[firebird-support] Restore with -FIX_FSS_D and -FIX_FSS_D -FIX_FSS_M

2015-11-02 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi We have been running a db with FB 2.5.1 (SDO 11.2) and made a backup and want to restore it for FB 2.5.4. Should I use the -FIX_FSS_M and -FIX_FSS_D options? Is there any reason why I should not use these options (to be on the safe side?) -- Jardar Maatje Nortek Data Services AS C.J.

Re: [firebird-support] High CPU use after restore

2015-10-31 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi First of all thanks for help on the way. After a lot of work (and waiting for restore,backups indexing...) I found out that it actually was as simple as an index that was inactive. The index must have been disabled during my first backup/restore as I am sure I did not do this myself. The index

Re: [firebird-support] High CPU use after restore

2015-10-29 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
regards Jardar 29. okt. 2015 00.00 skrev "setysvar setys...@gmail.com [firebird-support]" < firebird-support@yahoogroups.com>: > > > > Den 28.10.2015 20:56, skrev Jardar Maatje jardar.maa...@nds.nortek.no > [firebird-support]: > > Hi again > > A bi

Re: [firebird-support] High CPU use after restore

2015-10-29 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
hoogroups.com> wrote: > > > On Thu, 29 Oct 2015 07:43:29 +0100, "Jardar Maatje > jardar.maa...@nds.nortek.no [firebird-support]" > <firebird-support@yahoogroups.com> wrote: > > Hi again, > > > > Sounds like a reasonable cause for the problem. So

Re: [firebird-support] High CPU use after restore

2015-10-28 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi again Thanks for the feedback. I will try and investigate further based on your feedback. So far I have updated the index statistics and the seems to make minor improvements. I thought the indexes was recreated (and thus the statistics) when it was restored. Regarding the .GDB i doubt this as

Re: [firebird-support] High CPU use after restore

2015-10-28 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi again A bit more details. I found the query the slows this down and it is a query that includes blob data. If I adjust the query to cast the blob to varchar first the query executes 30 timers faster. I will try to change my queries to fix this. However I still wonder why this suddenly became

[firebird-support] High CPU use after restore

2015-10-27 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
Hi We have DB of about 40GB where transaction counter exceeded max and we had to backup and restore to get the db back up an running. However after doing this we have had trouble where the DB consumes 25% CPU (100% on one core). This typically happens when accessing the DB from IIS web pages