Re: [firebird-support] Searching for FB3 backup suggestions

['Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]]

Sorry, I just realised I was thinking of an option that had been removed. You 
need to run Firebird as SuperClassic or Classic (or do the backup through 
localhost as suggested earlier.
Mark

- Bericht beantwoorden -
Van: "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] Searching for FB3 backup suggestions
Datum: do, mei 26, 2016 21:23

You need to backup through localhost, or you need to set the database in 
databases.conf (or the Firebird default in Firebird.conf) to Shared.
You should have had the same problem with Firebird 2.5 if you used SuperServer.

Mark



- Bericht beantwoorden -
Van: "dondondonje...@yahoo.com [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] Searching for FB3 backup suggestions
Datum: do, mei 26, 2016 13:50








Hello,
i am currently testing to migrate FB2.5 databases into FB3 databases. Cant tell 
how many hours i recoded SP, triggers and and and... but database is working 
for me now.

Then i came to the point to backup the FB3 databases on a running system. Yes, 
i read the manuals and release notes and searched google. Unfortunately that 
didnt help. People refer to release notes and quick start quide or telling that 
something has changed for security reasons. Fact is database file is locked if 
any user is connected nowadays so i cant do my backups as before. I can 
understand that new feature. Company i work for is a 24/7 business. So i have 
to plan backups on a running system. I cant tell them to stop working for even 
1.5 hours because backup is running.
In the past i used nbackup but i had issues with deadlocks and missing 
transactions. So i used gbak fo
r last two years. Worked perfect for me. I tried different commands, settings 
and configurations for example service manager, IP, localhost, ports, password, 
transportable thrusted auth, SharedDatabase, adding users, dbadmi, new virtual 
machines and other Windows OS. Nothing worked for me as long as one user stays 
connected.
I also tried using a gbak 2.5 version with a FB3 database. That backup started 
after i tried to use default sysdba password even if i changed password before.
Operating system is Windows Server 2012 R2. Firebird 3.0.0.32483 SuperServer. 
Backup routine, database file and backup file should be located on the same 
machine for the moment.

"C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr 
employee e:\xxx.bak -user SYSDBA
works if no one is connected else i always get error "file is used 
by another process".

Hopefully i will find some answers, suggestions or advices.


Regards and thanks
Thomas

Re: [firebird-support] Searching for FB3 backup suggestions

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

26.05.2016 13:50, dondondonje...@yahoo.com [firebird-support] wrote:
> "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr 
> employee
> e:\xxx.bak -user SYSDBA
> works if no one is connected else i always get error "file is used by anot 
> her process".

   Use "-se localhost:service_mgr", Luke!

-- 
   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/

[firebird-support] Re: Searching for FB3 backup suggestions

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

26.05.2016 14:50, dondondonje...@yahoo.com wrote:
>
> "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se
> service_mgr employee e:\xxx.bak -user SYSDBA
> works if no one is connected else i always get error "file is used by
> another process".

gbak.exe -b -v -t -se localhost:service_mgr employee e:\xxx.bak -user SYSDBA

And all other connections should also be through localhost (or host 
name, or IP address).


Dmitry

Re: [firebird-support] Searching for FB3 backup suggestions

['Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]]

You need to backup through localhost, or you need to set the database in 
databases.conf (or the Firebird default in Firebird.conf) to Shared.
You should have had the same problem with Firebird 2.5 if you used SuperServer.

Mark

- Bericht beantwoorden -
Van: "dondondonje...@yahoo.com [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] Searching for FB3 backup suggestions
Datum: do, mei 26, 2016 13:50

Hello,
i am currently testing to migrate FB2.5 databases into FB3 databases. Cant tell 
how many hours i recoded SP, triggers and and and... but database is working 
for me now.

Then i came to the point to backup the FB3 databases on a running system. Yes, 
i read the manuals and release notes and searched google. Unfortunately that 
didnt help. People refer to release notes and quick start quide or telling that 
something has changed for security reasons. Fact is database file is locked if 
any user is connected nowadays so i cant do my backups as before. I can 
understand that new feature. Company i work for is a 24/7 business. So i have 
to plan backups on a running system. I cant tell them to stop working for even 
1.5 hours because backup is running.
In the past i used nbackup but i had issues with deadlocks and missing 
transactions. So i used gbak fo
r last two years. Worked perfect for me. I tried different commands, settings 
and configurations for example service manager, IP, localhost, ports, password, 
transportable thrusted auth, SharedDatabase, adding users, dbadmi, new virtual 
machines and other Windows OS. Nothing worked for me as long as one user stays 
connected.
I also tried using a gbak 2.5 version with a FB3 database. That backup started 
after i tried to use default sysdba password even if i changed password before.
Operating system is Windows Server 2012 R2. Firebird 3.0.0.32483 SuperServer. 
Backup routine, database file and backup file should be located on the same 
machine for the moment.

"C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr 
employee e:\xxx.bak -user SYSDBA
works if no one is connected else i always get error "file is used 
by another process".

Hopefully i will find some answers, suggestions or advices.


Regards and thanks
Thomas

Re: [firebird-support] Re: Is Firebird 3 ready for Production?

[fabia...@itbizolutions.com.au [firebird-support]]

Ann

> I might also have mentioned that sharing caches and other internal structures 
> between simultaneous threads is one challenge. 

So the above mentioned changes have been implemented in FB3. And the was 
referred as true SMP in the white papers about FB3. Correct?


> Distributing queries across processors is another and totally different 
> challenge. The Firebird developers were wise (in my opinion) to take the 
> challenges one at a time. 

And the above mentioned task was not implemented in FB3.0, Correct? Do you know 
if it planned to be implemented in FB 4.0?


Don't take me wrong, I am very happy about Firebird's quality and performance, 
I was just expecting the hole SMP issue to be resolved or enhanced in FB 3.0, 
hence my surprise when I did not see the hole CPUs jumping on a query.


Cheers,
Fabian





  - Original Message - 
  From: Ann Harrison aharri...@ibphoenix.com [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, May 26, 2016 5:41 AM
  Subject: Re: [firebird-support] Re: Is Firebird 3 ready for Production?





  On Wed, May 25, 2016 at 2:53 PM, Ann Harrison  wrote:

On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au 
[firebird-support]  wrote:



   Now on the flip side, the performance sucks, it is worst than with FB 
2.54, and when looking at the task manager on windows it appears only one 
processor it doing the job, as if the code was not SMP enabled very 
strange. 


One possibility is that you're testing V3.0 SuperServer single user.  In 
V3.0, Firebird is multi-threaded at the client statement level.  It does not 
decompose queries and schedule the pieces on different processors.  That means 
that a full-table scan runs on only one processor.  Two simultaneous full-table 
scans will run on two processors.  


  I should have continued to say that two full-table scans probably won't be 
any faster in 3.0 than they were in 2.5 because you're measuring disk transfers 
and adding processors doesn't make the disk go faster.  I might also have 
mentioned that sharing caches and other internal structures between 
simultaneous threads is one challenge.  Distributing queries across processors 
is another and totally different challenge.  The Firebird developers were wise 
(in my opinion) to take the challenges one at a time.  


  Good luck,


  Ann 





  

Re: [firebird-support] Re: Searching for FB3 backup suggestions

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

26.05.2016 21:33, hv...@users.sourceforge.net [firebird-support] wrote:
>Specify remote (network) access explicitly (else it tries to open database 
> using
> embedded engine and fails)

   Shouldn't the next provider to be tried in this case?

-- 
   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/

[firebird-support] Re: Searching for FB3 backup suggestions

[hv...@users.sourceforge.net [firebird-support]]

---In firebird-support@yahoogroups.com,  wrote :
 
 > "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr 
 > employee e:\xxx.bak -user SYSDBA > works if no one is connected else i 
 > always get error "file is used by another process".

  Specify remote (network) access explicitly (else it tries to open database 
using embedded engine and fails):

gbak.exe -b -v -t -se xnet://service_mgr employee e:\xxx.bak -user SYSDBA

or

gbak.exe -b -v -t -se localhost:service_mgr employee e:\xxx.bak -user SYSDBA

  
Regarsd,
Vlad

[firebird-support] Searching for FB3 backup suggestions

[dondondonje...@yahoo.com [firebird-support]]

Hello,
 

 i am currently testing to migrate FB2.5 databases into FB3 databases. Cant 
tell how many hours i recoded SP, triggers and and and... but database is 
working for me now.
 

 Then i came to the point to backup the FB3 databases on a running system. Yes, 
i read the manuals and release notes and searched google. Unfortunately that 
didnt help. People refer to release notes and quick start quide or telling that 
something has changed for security reasons. Fact is database file is locked if 
any user is connected nowadays so i cant do my backups as before. I can 
understand that new feature. Company i work for is a 24/7 business. So i have 
to plan backups on a running system. I cant tell them to stop working for even 
1.5 hours because backup is running.
 In the past i used nbackup but i had issues with deadlocks and missing 
transactions. So i used gbak for last two years. Worked perfect for me. I tried 
different commands, settings and configurations for example service manager, 
IP, localhost, ports, password, transportable thrusted auth, SharedDatabase, 
adding users, dbadmi, new virtual machines and other Windows OS. Nothing worked 
for me as long as one user stays connected.
 I also tried using a gbak 2.5 version with a FB3 database. That backup started 
after i tried to use default sysdba password even if i changed password before.
 Operating system is Windows Server 2012 R2. Firebird 3.0.0.32483 SuperServer. 
Backup routine, database file and backup file should be located on the same 
machine for the moment.
 

 "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr 
employee e:\xxx.bak -user SYSDBA
 works if no one is connected else i always get error "file is used by another 
process".
 

 Hopefully i will find some answers, suggestions or advices.
 

 

 Regards and thanks
 Thomas
 

 

 

Re: [firebird-support] FB 3 - SMP switched off ?

[fabia...@itbizolutions.com.au [firebird-support]]

Thanks Dimitry

Cheers
Fabian

  - Original Message - 
  From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, May 26, 2016 10:44 PM
  Subject: Re: [firebird-support] FB 3 - SMP switched off ?


  26.05.2016 14:42, fabia...@itbizolutions.com.au [firebird-support] wrote:
  > Do you know if it is planned for Firebird to distribute each client request 
across all
  > CPUs? When?

 Parallel execution of a single request is not planned at all yet.

  -- 
 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

Re: [firebird-support] FB 3 - SMP switched off ?

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

26.05.2016 14:42, fabia...@itbizolutions.com.au [firebird-support] wrote:
> Do you know if it is planned for Firebird to distribute each client request 
> across all
> CPUs? When?

   Parallel execution of a single request is not planned at all yet.

-- 
   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] Re: Is Firebird 3 ready for Production?

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

On Thu, May 26, 2016 at 8:30 AM, fabia...@itbizolutions.com.au
[firebird-support]  wrote:

>
> I wrote:
>
>
>   In V3.0, Firebird is multi-threaded at the client statement level.  It
> does not decompose queries and schedule the pieces on different processors.
>
>
>
> I understand, I thought true SMP was referring to assigning each client's
> request to all CPU at once, instead of balancing the clients requests
> across processors. So the current version (FB 3) is probably going to
> outperform the FB 2.54 when there are concurrent requests passed to the
> server engine because each request will go to a different processor,
> correct? The more concurrent requests we have the more we are going to
> notice the difference, right?
>

Right.  The strength of a relational database is its ability to process
multiple client requests simultaneously.  That's the goal of Firebird V3.
If all you want to do is strip data off the disk as fast as possible, there
are better technologies.

Splitting client requests across processors in general is hard.  Well, it's
less hard if you don't care if the result is performance improvement.  In
general, splitting a single requests across processors is beneficial if
there's lots of computing or if the request can be split so different parts
access different disks.  A simple "select count(*) from MyTable" cannot be
improved by splitting it across processors unless the table can also be
split across disks in a deterministic way.   On example that could be
improved by splitting a single request is large sorts, which can be
improved by splitting them so one thread is fetching records while others
sort subsets.  With large memories and 64 bit address spaces, lots of
sorting can happen in memory.

But frankly, if I were the core developers, I'd want to put my efforts into
other areas that will provide more benefits than fast large sorts.

Good luck,

Ann

Re: [firebird-support] Is Firebird 3 ready for Production?

[fabia...@itbizolutions.com.au [firebird-support]]

Re: [firebird-support] Is Firebird 3 ready for Production?I see, will read it

Cheers
Fabian

  - Original Message - 
  From: 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
  To: fabia...@itbizolutions.com.au [firebird-support] 
  Sent: Thursday, May 26, 2016 6:01 AM
  Subject: Re: [firebird-support] Is Firebird 3 ready for Production?




  Fabian

  I suggest you to read the release notes carefully. FB 3 can use different 
user authentication plugins. This means that you can have different users with 
the same name, in different plugins.

  There are many other conceptual changes in FB 3 that needs caution. That's 
why I decided to write a Migration Guide to Firebird 3.

  Carlos
  Migration Guide to Firebird 3 eBook - 
http://www.firebirdnews.org/migration-guide-to-firebird-3/ 
  www.firebirdnews.org - www.FireBase.com.br


   


Hi Alexey

Thank you for the comments. So far everything has gone ok, I fixed all 
the fields with ASCII charset at the FB 2.54 DB (changed the domain to charset 
NONE), and now the backup and restore workes fine, with no errors.

I've noticed the new FB3 DB has now two SYSDBA users, one seems to be 
disabled, and the other has the masterkey password even though the install 
asked me for the password, but it appears it ignored my answer, or it used the 
password I entered for the disabled SYSDBA users... no big deal.

Other than that I have not encountered any other issues so far, I will 
recompile all stored procedures and views and triggers shortly, but I don't 
expect any issues there because the DB is operational with the Application and 
no errors have appeared on the APP side using the FB3 DB.

Cheers,
Fabian 




  

Re: [firebird-support] FB 3 - SMP switched off ?

[fabia...@itbizolutions.com.au [firebird-support]]

Dimitry 

I see, I will shut the FB server many requests at once from different instances 
of client APP and see how it performs, I guess this test will show many CPUs 
going high.



Do you know if it is planned for Firebird to distribute each client request 
across all CPUs? When?



Cheers,

Fabian





- Original Message - 

  From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, May 26, 2016 6:01 PM
  Subject: Re: [firebird-support] FB 3 - SMP switched off ?


  25.05.2016 19:34, fabia...@itbizolutions.com.au [firebird-support] wrote:
  > Any ideas why the SMP is not activated?

 Single connection uses only one execution thread.

  -- 
 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

Re: [firebird-support] Re: Is Firebird 3 ready for Production?

[fabia...@itbizolutions.com.au [firebird-support]]

Ann

I understand, I thought true SMP was referring to assigning each client's 
request to all CPU at once, instead of balacing the clients requests across 
processors. So the current version (FB 3) is probably going to outperform the 
FB 2.54 when there are concurrent requests passed to the server engine because 
each request will go to a different processor, correct? The more concurrent 
requests we have the more we are going to notice the difference, right?

Cheers
Fabian



- Original Message - 
  From: Ann Harrison aharri...@ibphoenix.com [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, May 26, 2016 4:53 AM
  Subject: Re: [firebird-support] Re: Is Firebird 3 ready for Production?





  On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au 
[firebird-support]  wrote:



 Now on the flip side, the performance sucks, it is worst than with FB 
2.54, and when looking at the task manager on windows it appears only one 
processor it doing the job, as if the code was not SMP enabled very 
strange. 


  One possibility is that you're testing V3.0 SuperServer single user.  In 
V3.0, Firebird is multi-threaded at the client statement level.  It does not 
decompose queries and schedule the pieces on different processors.  That means 
that a full-table scan runs on only one processor.  Two simultaneous full-table 
scans will run on two processors.  


  Good luck,


  Ann








  

Re: [firebird-support] Finding a single row

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

26.05.2016 12:48, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr 
[firebird-support] wrote:
> Below didn't work for me because complete card number is longer, and I do
> lack SQL knowledge:
> select * from FIYATKODLARI where Kodu like 'SB1%'

   select * from FIYATKODLARI where 'FullCardNumber' starting with Kodu

-- 
   WBR, SD.

[firebird-support] Finding a single row

[Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]]

Hi,

I have a table where I keep some part from the beginning of a discount card
number. Length of beginning is variable. User provides a complete card
number at runtime, I need to find a single row in my table which begins as
the complete card number, or I need to know no match exists in my table.

I might do it coding in my application, but that would be way too slow
compared to an SQL statement I assume.

Table is as follows.
CREATE TABLE FIYATKODLARI(
 Kodu   Varchar(30) NOT NULL PRIMARY KEY
);

It contains something like:
Kodu

SA
SB
SSC
SAA
SBDE
8694
125

Complete card number may be something like:
SB1
SA25
SA325
SB1054
SAA23
86941005
12504

Below didn't work for me because complete card number is longer, and I do
lack SQL knowledge:
select * from FIYATKODLARI where Kodu like 'SB1%'

Any help is appreciated.

Thanks.
Ertan Küçükoğlu









++

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] FB 3 - SMP switched off ?

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

25.05.2016 19:34, fabia...@itbizolutions.com.au [firebird-support] wrote:
> Any ideas why the SMP is not activated?

   Single connection uses only one execution thread.

-- 
   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/