RE: [firebird-support] Firebird database executing DML queries very slowly.

['Joje' j...@codework-solutions.com [firebird-support]]

Hi , 

 

This issue was replicated only on client end while I copied the DB on our end 
it was working with any slowness. 

I took the remote of client DB , performed validation check on DB & backup - 
restore operation on DB. 

After doing this its working normally now. 

 

Thanks for help. :)

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com] 
Sent: Tuesday, January 29, 2019 17:21
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Firebird database executing DML queries very 
slowly.

 

  

Hi

 

Is this from problematic time with connected clients?

If yes than i do no see problems. 

You must provide more details about issue.

What exact comand is slow? What are the query plan and query sats?

Did you tested HDD isues?

…

 

Regards,

Karol Bieniaszewski

RE: [firebird-support] Firebird database executing DML queries very slowly.

['Joje' j...@codework-solutions.com [firebird-support]]

Ran the command and got the header information from the client. Below is 
database header page information of the affected database :  



Flags  0  

Checksum   12345  

Generation 9101445  

Page size 4096  

ODS version   11.2  

Oldest transaction   8991282  

Oldest active  9100701  

Oldest snapshot   9100701  

Next transaction  9100702  

Bumped transaction   1  

Sequence number  0  

Next attachment ID24698  

Implementation ID  26  

Shadow count   0  

Page buffers  0  

Next header page   0  

Database dialect   3  

Attributes   force write  

Variable header data:  

Sweep interval:2  

*END*  

 

The difference between the oldest transaction and newest transaction is large.  

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com] 
Sent: Friday, January 25, 2019 20:32
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Firebird database executing DML queries very 
slowly.

 

  

Hi.

 

When you gain slowdows 

Run

gstat -h

 

and put here results.

Problem probably is because of some long running transaction.

 

Regards,

Karol Bieniaszewski

RE: [firebird-support] Firebird database executing DML queries very slowly.

['Joje' j...@codework-solutions.com [firebird-support]]

Thanks, I will try this command on customer end will upload the results.

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com] 
Sent: Friday, January 25, 2019 20:32
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Firebird database executing DML queries very 
slowly.

 

  

Hi.

 

When you gain slowdows 

Run

gstat -h

 

and put here results.

Problem probably is because of some long running transaction.

 

Regards,

Karol Bieniaszewski

RE: [firebird-support] Firebird database corrupt with wrong page type error on table

['Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]]

http://www.ibphoenix.com/resources/documents/how_to/doc_5

Regards
Paul

  -Original Message-
  From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
  Sent: 21 December 2017 13:14
  To: firebird-support@yahoogroups.com
  Subject: [firebird-support] Firebird database corrupt with wrong page type
error on table




  Hello everyone,



  During inserting data to a table I received an error on my application log
"database file appears corrupt (DB Path) wrong page type page 232333 is of
wrong type (expected 5, found 7)".



  On looking in FB log I got following  :



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB

  Data page 232331 (sequence 168514) is confuse d in table
TABLENAME (159)



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB

  Page 232333 wrong type (expected 5 encountered 7)



  DEVMACHINE (Server)  Thu Dec 21 16:45:23 2017

  Database: DB< /p>

  Data page 232333 (sequence 168515) is confused in table
TABLENAME (159)



  DEVMACHINE (Server)  Thu Dec 21 16:45:24 2017

  Database: DB

  Page 232317 is an orphan





  This is the first time I am seeing this error and don't know what has
caused it. Is there any precaution to avoid such kind of errors..?



  This database is around 3 years old and database maintenance activity is
not done on it.  Also, the said table has 5.4 million records in it.





  Thank you in advance J


  

Re: [firebird-support] Firebird Database to MYSQL Database conversion

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

28.08.2017 12:43, vamsi sagiraju vamsi...@gmail.com [firebird-support] wrote:
> I am alien to Firebird database, having no idea about it, But we have to 
> migrate it to 
> MySQL database(Have good idea about it). So could any one please let me know 
> how to 
> convert the Firebird database to MY SQL with more light on the steps and 
> process needs to 
> follow/do this.

1. Create MySQL database with the same tables.
2. Export Firebird data into CVS files using FBExport.
3. Import data into MySQL.

   That's all.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

[Leandro Melo de Sales leandromsa...@gmail.com [firebird-support]]

Dimitry,

Thanks for your reply. The problem of backing up using gbak is that it is
not possible to run incremental backups, right?

By the way, i'm using nbackup 0-level per month and 1-level everyday,
replacing the 1-level everyday by the new one. In this approach, if I run
nbackup recover using the 0-level and the 1-level backup should I get the
latest version of the database?

2017-01-10 12:34 GMT-03:00 Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] :

> 10.01.2017 16:30, Leandro Melo de Sales leandromsa...@gmail.com
> [firebird-support] wrote:
> > The database file size is huge as 56Gb. Is there any limitation of
> Firebird as the size of
> > the database increase?
>
>No limitations at this level. 56Gb is quite small database.
>
> > any suggestion for improve this scenario?
>
>Backup by gbak can be much smaller.
>
>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/
> resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>


-- 
PhD. Leandro Melo de Sales
Institute of Computing (IC) at Federal University of Alagoas (UFAL), Brazil
Pervasive and Mobile Computing Laboratory (COMPELab.org / IC)





"The warrior is strong in loyalty, intensity, determination, initiative,
persistence, courage and willpower. The warrior is light in the soul,
self-trust and compassion. The warrior is often called to take the front
when other cowardly make a step backwards. There are warriors on the
battlefields and in everyday life."

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.01.2017 16:30, Leandro Melo de Sales leandromsa...@gmail.com 
[firebird-support] wrote:
> The database file size is huge as 56Gb. Is there any limitation of Firebird 
> as the size of
> the database increase?

   No limitations at this level. 56Gb is quite small database.

> any suggestion for improve this scenario?

   Backup by gbak can be much smaller.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird database keeps randomly locking up.

[Michael Weissenbacher m...@dermichi.com [firebird-support]]

On 24.03.2016 12:36, Richard Cooke rich...@alcoeng.co.uk
[firebird-support] wrote:
> 
> 
> 
> I have a problem with a Firebird database randomly locking up completely
> for a period of time sometimes only a 30 seconds, sometimes 10 or 15
> minutes.
I would suspect either a virus scanner or the Windows System Protect
"Feature". Which file extension are you using for the datebase?
See: http://www.firebirdfaq.org/faq353/


> Version is 2.1.7
> Server is new running Windows Server 2012 R2.
> Only a smallish database with about 6 users.
> 
> We never had any problems when running on an old windows 2000 server.
> 
> firebird log file shows various errors, see below:
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> INET/inet_error: send errno = 10054
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> INET/inet_error: send errno = 10054
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> INET/inet_error: send errno = 10054
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> SERVER/process_packet: broken port, server exiting
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> SERVER/process_packet: broken port, server exiting
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> SERVER/process_packet: broken port, server exiting
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> INET/inet_error: send errno = 10054
> 
> 
> ALCOSERVERThu Mar 24 11:14:17 2016
> SERVER/process_packet: broken port, server exiting
> 
> 
> ALCOSERVERThu Mar 24 11:14:36 2016
> INET/inet_error: read errno = 10054
> 
> Hope someone can help.
> thanks,
> Richard.
> 
> 
> 
> 

Re: [firebird-support] Firebird database seems to influence multi user ability

[marcus mar...@antiphasis.net [firebird-support]]

On 08.12.2014 14:28, Benny Schaich-Lebek bscha...@gmx.de
[firebird-support] wrote:
  
 
 Hi,
 
 I have been an interbase guy about fifteen years ago and loved to see it
 go open source. I used to work with Paul Beach (Hello, if you're here,Paul)
 
 Now I ran across a problem with firebird and tried to solve it.
 unfortunately half of the stuff is in the dark because the original
 software running here is an accounting product (BUHL/Deltra office
 Software/Germany if you have heard about it).
 
 The weird thing is that the software does not connect to the server from
 a client if there is a specific .fdb file loaded (local access works). I
 now asked them to run a backup and that had a couple of messages:
  (gbak:cannot commit index MOV_CALITEMS_ORDERID
 gbak: ERROR:violation of FOREIGN KEY constraint MOV_CALITEMS_ORDERID
 on table MOV_CALENDARITEMS
 gbak: ERROR:Foreign key reference target does not exist
 gbak: ERROR:Problematic key value is (ORDERID = 4127)
 gbak:Database is not online due to failure to activate one or more indices.
 gbak:Run gfix -online to bring database online without active indices.)
 
 Specifically the last one makes me suspicious. How come that local
 access works then? I thought even local access always goes through the
 server?
Hej,
some questions:
- by local connections you're talking about drive letter:\path\to\fdb?
Or 127.0.0.1:., which would be a network connection, regardless of
which host the connection comes from.

- which version of Firebird?

- which user? SYSDBA is allowed to connect an 'offline' database. He has
to, else a database would only become a big jumbled piece of
bits'n'bytes if one pulls the trigger gfix -shut ...

Do you have the output of gstat -h database.fdb? What does the row
Attributes say?

marcus
 
 Any hints anybody? I know this is hard to determine as we do not know
 much about the program itself, but it seems the guys from the software
 shop have trouble to understand firebird...
 
 Regards,
 Benny Schaich
 Ex-Borland...
 
 



[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird database seems to influence multi user ability

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi Benny,

Look here
http://ib-aid.com/en/articles/cannot-commit-index-or-how-to-pump-data-from-partially-restored-inconsistent-database/

I suggest to insert fake record with ORDERID = 4127, and then try to 
activate index.


Regards,
Alexey Kovyazin
IBSurgeon


Hi,

I have been an interbase guy about fifteen years ago and loved to see 
it go open source. I used to work with Paul Beach (Hello, if you're 
here,Paul)


Now I ran across a problem with firebird and tried to solve it. 
unfortunately half of the stuff is in the dark because the original 
software running here is an accounting product (BUHL/Deltra office 
Software/Germany if you have heard about it).


The weird thing is that the software does not connect to the server 
from a client if there is a specific .fdb file loaded (local access 
works). I now asked them to run a backup and that had a couple of 
messages:

 (gbak:cannot commit index MOV_CALITEMS_ORDERID
gbak: ERROR:violation of FOREIGN KEY constraint MOV_CALITEMS_ORDERID 
on table MOV_CALENDARITEMS

gbak: ERROR:Foreign key reference target does not exist
gbak: ERROR:Problematic key value is (ORDERID = 4127)
gbak:Database is not online due to failure to activate one or more 
indices.

gbak:Run gfix -online to bring database online without active indices.)

Re: [firebird-support] Firebird database

[Alexey Kovyazin]

Hi,

So you found 640Gb of information.
Is it related with recent leaks of account form BVI offshore companies? :)

Regarding your questions - see gbak manual here 
http://www.firebirdsql.org/en/reference-manuals/

Regards,
Alexey Kovyazin
IBSurgeon


 I found a database that weighs 640G,
 this basis consists of seven files. fdb ie

 datos_1.fdb
 datos_2.fdb
 datos_3.fdb
 datos_4.fdb
 datos_5.fdb
 datos_6.fdb
 datos_7.fdb

 as I can generate a backup of the database and how I can perform
 restore, thanks.

 [Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird Database Backup 1.0 - versions supported

[Norman Dunbar]

Morning Jorge,

  We have a Windows 2008 R2 64 bit server running Fb 1.5.6 32 bits
  classic, the database is around 2Gb.

 Would like to know if the Database Backup Software featured at
  IBPHOenix.com would be suitable to automate the database backup taks
  on this server.
  Link: http://www.ibphoenix.com/products/software/yamacobackup

I have to admit that I've not used this product, however, there is a 14 
day free trial offered so you could give it a try and see if it meets 
your needs. Possible trialling against a copy database as opposed to 
your production one!

One thing I notice though is the supported versions of Firebird:

Windows 2000, XP, Vista, 7 (both 32 and 64 bit versions) FireBird 2.1 
and 2.5 (with guaranteed support for upcoming FireBird versions, for 
example 3.0).

It appears that your particular version of Firebird (or Windows) is not 
supported. From work, I know that there are a few differences between 
Windows 2000 and 2008 which affects some of the products I have to use 
(Oracle for example).

HTH


Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767

Re: [firebird-support] Firebird Database Woekbench Lite on Fedora Linux

[Helen Borrie]

At 12:10 AM 23/01/2012, you wrote:
I installed Firebird on Fedora Linux. It installed FlameRobin GUI admin tool 
but it is quite limited. I want to install Database Workbench Lite from 
Upscene. Is it available for Linux and how to install it on Fedora? I am new 
to linux and firebird both.

Off-topic here.  Please post tool-related questions to firebird-tools.  If you 
haven't yet found the list of available help forums (with subscribe 
instructions) please visit http://www.firebirdsql.org/en/mailing-lists/

^ heLen ^

Re: [firebird-support] Firebird Database Woekbench Lite on Fedora Linux

[Martijn Tonies]

Hello Rohit,

I installed Firebird on Fedora Linux. It installed FlameRobin GUI admin 
tool but it is quite limited. I want to install Database Workbench Lite 
from Upscene. Is it available for Linux and how to install it on Fedora? I 
am new to linux and firebird both.


Database Workbench is not available for Linux, it's Windows only.

However, you can connect from Windows to Linux Firebird just fine,
we've heard of succesful attemps to run it under Wine on Linux.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!