[firebird-support] Replication of Firebird Databases (meany to one)

[Andrew Gable]

Hi all,

Does anyone know any good free to use replication software.

What i have is as follows

I have 4-20 terminals with a database that holds all the products/ cashier
ids etc in it and I want the system to sync the local database 

to it the server and then delete any data that his has processed

 

can this be done with Replication or do I need to create my own app to
handle this

 

Also does anyone know anyway of checking to see if the server is online
before connection to it in VB6 (via ODBC Driver)

thanks

 

Andy

Re: [firebird-support] RE: I dont know why sweep is not doing clean

[Ann Harrison]

On Fri, Dec 6, 2013 at 2:44 PM,  wrote:

> Hi Vlad, gstat -h result:
>
> Oldest transaction  371932
>
> Oldest active1906983
> Oldest snapshot   1906983
> Next transaction   2696106
>
>
 Only record versions created before transaction three hundred
seventy-one thousand nine hundred and thirty two can be removed.
All versions created by the next two million three hundred twenty
four thousand one hundred and seventy four transactions must be
kept so that your transaction 1906983 can be guaranteed a stable
snapshot of the database.

Find that transaction and kill it!

Good luck,

Ann

> 
>

Re: [firebird-support] RE: I dont know why sweep is not doing clean

[Dmitry Kuzmenko]

Hello, sopranoeli!

Friday, December 6, 2013, 11:44:31 PM, you wrote:

syca>  I do not mind the difference between "Oldest active" and "Next
syca> transaction".

why? you have some transaction (not read only read_committed) running for 2 
days.

Why auto-sweep is not running - this is another story. Have you looked
into firebird.log that auto-sweep is really never run?

-- 
Dmitry Kuzmenko, www.ib-aid.com

[firebird-support] RE: I dont know why sweep is not doing clean

[sopranoeli]

Hi Vlad, gstat -h result:
 

 Database header page information:
Flags   0
Checksum12345
Generation  2834816
Page size   8192
ODS version 11.2
Oldest transaction  371932
Oldest active   1906983
Oldest snapshot 1906983
Next transaction2696106
Bumped transaction  1
Sequence number 0
Next attachment ID  2937493
Implementation ID   24
Shadow count0
Page buffers0
Next header page0
Database dialect3
Creation date   Nov 30, 2013 14:40:42
Attributes

Variable header data:
Database backup GUID:   {4D31C829-9021-4BEE-A0B9-3038174E9C65}
Sweep interval: 2
*END*
 

 I do not mind the difference between "Oldest active" and "Next transaction". 
Only diference between "Oldest transaction" and "Next transaction".
 Thanks in advance,
 

 Vanina

 

RE: [firebird-support] I dont know why sweep is not doing clean

[sopranoeli]

 Hi, thanks for your answer.
I was checking the tables "MON$Attachments" and "MON$Transactions" but do not 
include the transaction id "Oldest Transaction".
I appreciate any other suggestions to find the problem.
Thank you,
Vanina

Re: AW: AW: [firebird-support] difficult question

[Tupy . . . nambá]

Dear mrs.Ann,

Thanks for you remembering, excuse me for losing the focus.

Mr.Olaf is using almost no code in the application, he is working "data-bound". 
If he was using triggers, he could do it more easily yet, with generators. And 
he has almost no control about the lock, because he is using MsAccess to do 
that.

I sugest him learn how to increase the quality of his application, where all 
this points will be better resolved.

Thanks a lot, best regards,
Roberto Camargo.



On Friday, December 6, 2013 1:49 PM, Ann Harrison  
wrote:
 



Since this discussion has wandered off into German, I'm going to put this
as bluntly as possible in English.

Never use "select max (id) + 1 from targetTable" to create unique identifiers. 
It's
the worst kind of bug - one that works when you test your code in single user
mode, and fails unpredictably in production.   It's also very slow.

This warning applies to Firebird and all MVCC databases, and to databases
that use lock-based concurrency control if you use either Read Committed or
Repeatable Read isolation modes.  

Generators (aka sequences) were created for a reason.  Use them.


Luck doesn't enter into it.

Cheers,

Ann



 

Re: AW: AW: [firebird-support] difficult question

[Ann Harrison]

Since this discussion has wandered off into German, I'm going to put this
as bluntly as possible in English.

Never use "select max (id) + 1 from targetTable" to create unique
identifiers. It's
the worst kind of bug - one that works when you test your code in single
user
mode, and fails unpredictably in production.   It's also very slow.

This warning applies to Firebird and all MVCC databases, and to databases
that use lock-based concurrency control if you use either Read Committed or
Repeatable Read isolation modes.

Generators (aka sequences) were created for a reason.  Use them.


Luck doesn't enter into it.

Cheers,

Ann

Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012

[Ann Harrison]

On Fri, Dec 6, 2013 at 10:59 AM, Softtech Support  wrote:

>
>
> I do not have time to upgrade to V2.0 or v2.5 before the new server would
> be in.  I fully intend to when time permits.  Thus, the reason I'm asking
> if it could be done to allow them to continue while I do the conversion.
>
>

I guess what Konstantin was saying is "'Unsupported' means that version
isn't tested on
new operating system versions."  So the best you'll get here is someone's
experience
which may not reflect yours.  On the other hand, Firebird 1.5 doesn't
depend on a lot of
other systems (e.g. ICU came later) and Microsoft is pretty good about
upward
compatibility, so the chances are pretty good that the application will
work - to the
extent that any 10 year old software with no new patches works.

Good luck,

Ann

Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012

[Softtech Support]

I do not have time to upgrade to V2.0 or v2.5 before the new server would be 
in.  I fully intend to when time permits.  Thus, the reason I'm asking if it 
could be done to allow them to continue while I do the conversion.

Thanks,

  - Original Message - 
  From: Konstantin Khomoutov 
  To: firebird-support@yahoogroups.com 
  Cc: Softtech Support 
  Sent: Friday, December 06, 2013 8:52 AM
  Subject: Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012



  On Fri, 6 Dec 2013 08:33:25 -0600
  "Softtech Support"  wrote:

  > Can anyone tell be if Firebird v 1.5.3 will install and run
  > effectively on Windows Server 2012?
  > 
  > It is currently being ran on a Windows 2003 Server and they are
  > wanting to upgrade to a new server and I just wanted to see if there
  > would be any issues.
  > 
  > Thanks to any who can shed some light.

  Versions of Firebird below 2.5 are discontinued, so is there really any
  reason to ask? I mean, if it breaks those "they" will have to hold both
  pieces. So I'd they they should better look at upgrading their app to
  support 2.5 (extensive release notes with possible compatibility
  issues are available for both 2.0 and 2.5 series).


  

---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

Re: AW: AW: [firebird-support] difficult question

[Tupy . . . nambá]

Olaf,

I glaube ich have  eine Ahnhung von was passiert.

Wenn man Access brauch, wenn du bewegst von eine Linie (record) zu eine andere, 
Access macht sofort commit. Das heisst, wenn du clickst an eine Linie, die 
letze wo der Focus früher war wir sofort commited. Dan, man verliert der 
Kontrol der Sequenz wie die Id´s generiert werden. Dan, wen der haupt Form 
wieder geladen wird, der Data in der Subform werden geladet als sie commited 
wurden.

Mach ein paar Versuchen mit Insert, wo du in der Subform clicks geben wird, und 
versuch zu alles schliessen (als du normalerweise machst). Und dann ladet die 
letzten eingefügten Daten, und sag mir wie die Daten in der Subform geordnet 
sind, ob als du wünscht oder als du früher clicks gegeben hast.

Viel erfolgt,
Roberto.
(entschuldigung dass Ich ein paar Fehler auf Deutsch mache...)



On Friday, December 6, 2013 8:44 AM, checkmail  wrote:
 



..sorry, Roberto of course
 
One thing again, firebird realized in every case the ID-Generation, main-table 
at the time select max(nr) – will I change – and in detail-table with a 
generator.
  
Hello Robert,
 
yes, I use Microsoft Access and I have test it with different versions of it. 
The tables are linked over odbc (Firebird ODBC 32 Bit, only select dialect 3, 
quoted identifiers and safe thread) and some commands (not used in this case 
/forms) realized with ado-db. 
 
I have separately forms, a main and a subform. In both there is a standard 
recordsource to the linked tables. I don’t start the transactions manually, 
odbc is my friend.
 
Thanks.
 
In German Language:
 
Hallo Robert,
 
ich verwende ebenfalls Microsoft Access und habe von 2002 bis 2013 alle 
Versionen getestet, in allen Versionen konnte ich das Problem beobachten. 
Leider lässt es sich nicht dingfest machen, nur so viel weiß ich, dass es vor 
allem dann auftritt, wenn im vorherigen Datensatz der selbe Kunde ausgewählt 
wurde. Dann passiert es, dass die soeben eingetragenen Detaildatensätze auf 
einmal Zuwachs bekommen von eben dem vorherigen Vorgang. Schließt man das 
Formular und öffnet es erneut, findet man im letzten Datensatz keine 
Detaildatensätze im Unterformular mehr vor, statt dessen sind alle im 
vorherigen Vorgang abgelegt, die original eingetragenen und auch die vom 
letzten Vorgang. Das nervt natürlich die Angestellten, auch wenn es nur einige 
Male in der Woche vorkommt. Formular und Unterformular sind ganz normal 
angebunden, einfache Datenquelle, Tabellenabfrage. Die Tabellen sind alle 
verknüpft – zu Firebird. Auch dort versuchte ich schon diverse
 Versionen, das brachte jedoch auch nichts. Selbst den Treiber tauschte ich 
schon, keine Veränderung. 
Die genaue Vorgehensweise:
Im Hauptformular wird ein Kunde ausgewählt, einige andere Parameter ebenfalls. 
Zu dem Zeitpunkt steht die Vergabe der fortlaufenden Nummer noch aus. Sobald 
man z. B. in das Unterformular reinklickt, wird die Nummer übertragen und im 
Formular angezeigt. Derzeitig eben noch in Firebird über einen Trigger 
vergeben, select max(nr).. Das kann ich noch mit einem Generator realisieren, 
kein Problem.
Im Unterformular wählt man dann einige Artikel aus, Mengen usw. Und nun öffnet 
der Bearbeiter meist den Bericht um ihn auszudrucken. Sobald die Daten refresht 
werden, sieht man das Theater dass eben Positionen im UFO vorhanden sind die 
dort gar nicht ausgewählt waren. Löscht man diese jetzt beispielsweise heraus, 
verschwinden sie auch aus dem vorherigen Vorgang. Wie schon erwähnt, auch wenn 
nach dem Datensatz von Kunde A ein anderer eingefügt wurde, dennoch wird ein 
Vorgang in den neuen verschmolzen in welchem der Kunde übereinstimmt.
 
Danke für deine Hilfe, viele Grüße nach Brasilien.
 
Von:firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Im Auftrag von Tupy... nambá
Gesendet: Freitag, 6. Dezember 2013 12:05
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] difficult question
 
  
Olaf,
 
Du sagst, I habe ein Form und ein SubForm !!!
 
May I ask you wich development enviroment are you using for the front-end 
application ? I see this kind of application building as having been built with 
MsAccess !!! Because I work with VB, C# and Delphi, and I found this only with 
the Office family !
 
If you have separated forms (sub forms included) for both - parent and child 
table -, I see that you probably don´t have a only one transaction for both sql 
commands do you use explicit transaction in your application ?
 
After you comment so:
>>2. Have you the same transaction for master detail 
>Both tables are linked to the firebird database over the firebird odbc driver. 
>After I insert the master 
>record and klick into the detail-form, I get the generated Nr back from 
>firebird (before I insert a detail 
>data set). I’m sorry, I don’t know how the driver works in detail. 
... you don´t talk explicitly something about this. Making this sequence of 
operations doesn´t mean you have a common transaction. If y

Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012

[Konstantin Khomoutov]

On Fri, 6 Dec 2013 08:33:25 -0600
"Softtech Support"  wrote:

> Can anyone tell be if Firebird v 1.5.3 will install and run
> effectively on Windows Server 2012?
> 
> It is currently being ran on a Windows 2003 Server and they are
> wanting to upgrade to a new server and I just wanted to see if there
> would be any issues.
> 
> Thanks to any who can shed some light.

Versions of Firebird below 2.5 are discontinued, so is there really any
reason to ask?  I mean, if it breaks those "they" will have to hold both
pieces.  So I'd they they should better look at upgrading their app to
support 2.5 (extensive release notes with possible compatibility
issues are available for both 2.0 and 2.5 series).

[firebird-support] Firebird v1.5.3 on Windows Server 2012

[Softtech Support]

Greetings All,

Can anyone tell be if Firebird v 1.5.3 will install and run effectively on 
Windows Server 2012?

It is currently being ran on a Windows 2003 Server and they are wanting to 
upgrade to a new server and I just wanted to see if there would be any issues.

Thanks to any who can shed some light.

Mike

---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

[firebird-support] Re: mon$call_stack, FK cascade

[Dmitry Yemanov]

05.12.2013 23:38, unordained wrote:

> I'm using an autonomous transaction from inside my trigger to check 
> mon$call_stack
> to see how deeply-nested my current statement is (active statement of current
> transaction).

Very bad idea performance wise.

> Am I crazy? Do the implied triggers that handle cascades not show up in
> mon$call_stack? Only user-defined triggers and procedures?

IIRC, system triggers are not reported there.


Dmitry

AW: AW: [firebird-support] difficult question

[checkmail]

..sorry, Roberto of course

 

One thing again, firebird realized in every case the ID-Generation, main-table 
at the time select max(nr) – will I change – and in detail-table with a 
generator.

  

Hello Robert,

 

yes, I use Microsoft Access and I have test it with different versions of it. 
The tables are linked over odbc (Firebird ODBC 32 Bit, only select dialect 3, 
quoted identifiers and safe thread) and some commands (not used in this case 
/forms) realized with ado-db. 

 

I have separately forms, a main and a subform. In both there is a standard 
recordsource to the linked tables. I don’t start the transactions manually, 
odbc is my friend.

 

Thanks.

 

In German Language:

 

Hallo Robert,

 

ich verwende ebenfalls Microsoft Access und habe von 2002 bis 2013 alle 
Versionen getestet, in allen Versionen konnte ich das Problem beobachten. 
Leider lässt es sich nicht dingfest machen, nur so viel weiß ich, dass es vor 
allem dann auftritt, wenn im vorherigen Datensatz der selbe Kunde ausgewählt 
wurde. Dann passiert es, dass die soeben eingetragenen Detaildatensätze auf 
einmal Zuwachs bekommen von eben dem vorherigen Vorgang. Schließt man das 
Formular und öffnet es erneut, findet man im letzten Datensatz keine 
Detaildatensätze im Unterformular mehr vor, statt dessen sind alle im 
vorherigen Vorgang abgelegt, die original eingetragenen und auch die vom 
letzten Vorgang. Das nervt natürlich die Angestellten, auch wenn es nur einige 
Male in der Woche vorkommt. Formular und Unterformular sind ganz normal 
angebunden, einfache Datenquelle, Tabellenabfrage. Die Tabellen sind alle 
verknüpft – zu Firebird. Auch dort versuchte ich schon diverse Versionen, das 
brachte jedoch auch nichts. Selbst den Treiber tauschte ich schon, keine 
Veränderung. 

Die genaue Vorgehensweise:

Im Hauptformular wird ein Kunde ausgewählt, einige andere Parameter ebenfalls. 
Zu dem Zeitpunkt steht die Vergabe der fortlaufenden Nummer noch aus. Sobald 
man z. B. in das Unterformular reinklickt, wird die Nummer übertragen und im 
Formular angezeigt. Derzeitig eben noch in Firebird über einen Trigger 
vergeben, select max(nr).. Das kann ich noch mit einem Generator realisieren, 
kein Problem.

Im Unterformular wählt man dann einige Artikel aus, Mengen usw. Und nun öffnet 
der Bearbeiter meist den Bericht um ihn auszudrucken. Sobald die Daten refresht 
werden, sieht man das Theater dass eben Positionen im UFO vorhanden sind die 
dort gar nicht ausgewählt waren. Löscht man diese jetzt beispielsweise heraus, 
verschwinden sie auch aus dem vorherigen Vorgang. Wie schon erwähnt, auch wenn 
nach dem Datensatz von Kunde A ein anderer eingefügt wurde, dennoch wird ein 
Vorgang in den neuen verschmolzen in welchem der Kunde übereinstimmt.

 

Danke für deine Hilfe, viele Grüße nach Brasilien.

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Im Auftrag von Tupy... nambá
Gesendet: Freitag, 6. Dezember 2013 12:05
An:   firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] difficult question

 

  

Olaf,

 

Du sagst, I habe ein Form und ein SubForm !!!

 

May I ask you wich development enviroment are you using for the front-end 
application ? I see this kind of application building as having been built with 
MsAccess !!! Because I work with VB, C# and Delphi, and I found this only with 
the Office family !

 

If you have separated forms (sub forms included) for both - parent and child 
table -, I see that you probably don´t have a only one transaction for both sql 
commands do you use explicit transaction in your application ?

 

After you comment so:

>>2. Have you the same transaction for master detail 
>Both tables are linked to the firebird database over the firebird odbc driver. 
>After I insert the master 
>record and klick into the detail-form, I get the generated Nr back from 
>firebird (before I insert a detail 
>data set). I’m sorry, I don’t know how the driver works in detail. 

... you don´t talk explicitly something about this. Making this sequence of 
operations doesn´t mean you have a common transaction. If you don´t explicitly 
start a transaction, you will not have a transaction for both commands.

 

Roberto Camargo,

aus Brasilien

 

On Friday, December 6, 2013 7:45 AM, checkmail <  
check_m...@satron.de> wrote:

 

Hello @ll,

 

Today, I still could not reproduce the error again. What I can say, that I’m 
the only one in my test environment who creates records and the error also 
occurred there.

 

I can try to create a generator instead of the max-statement and I will see.

 

Of course, several people work at the same time (customer) in the database, but 
locally I’m the only one and the problem already exists. I don’t know what 
exactly the error provoked. Currently I have create 100 records and every 
works. I’m confused.

 

Thanks a lot.

 

Best regards

 

Olaf

 

Von:  <

AW: AW: [firebird-support] difficult question

[checkmail]

Hello Robert,

 

yes, I use Microsoft Access and I have test it with different versions of it. 
The tables are linked over odbc (Firebird ODBC 32 Bit, only select dialect 3, 
quoted identifiers and safe thread) and some commands (not used in this case 
/forms) realized with ado-db. 

 

I have separately forms, a main and a subform. In both there is a standard 
recordsource to the linked tables. I don’t start the transactions manually, 
odbc is my friend.

 

Thanks.

 

In German Language:

 

Hallo Robert,

 

ich verwende ebenfalls Microsoft Access und habe von 2002 bis 2013 alle 
Versionen getestet, in allen Versionen konnte ich das Problem beobachten. 
Leider lässt es sich nicht dingfest machen, nur so viel weiß ich, dass es vor 
allem dann auftritt, wenn im vorherigen Datensatz der selbe Kunde ausgewählt 
wurde. Dann passiert es, dass die soeben eingetragenen Detaildatensätze auf 
einmal Zuwachs bekommen von eben dem vorherigen Vorgang. Schließt man das 
Formular und öffnet es erneut, findet man im letzten Datensatz keine 
Detaildatensätze im Unterformular mehr vor, statt dessen sind alle im 
vorherigen Vorgang abgelegt, die original eingetragenen und auch die vom 
letzten Vorgang. Das nervt natürlich die Angestellten, auch wenn es nur einige 
Male in der Woche vorkommt. Formular und Unterformular sind ganz normal 
angebunden, einfache Datenquelle, Tabellenabfrage. Die Tabellen sind alle 
verknüpft – zu Firebird. Auch dort versuchte ich schon diverse Versionen, das 
brachte jedoch auch nichts. Selbst den Treiber tauschte ich schon, keine 
Veränderung. 

Die genaue Vorgehensweise:

Im Hauptformular wird ein Kunde ausgewählt, einige andere Parameter ebenfalls. 
Zu dem Zeitpunkt steht die Vergabe der fortlaufenden Nummer noch aus. Sobald 
man z. B. in das Unterformular reinklickt, wird die Nummer übertragen und im 
Formular angezeigt. Derzeitig eben noch in Firebird über einen Trigger 
vergeben, select max(nr).. Das kann ich noch mit einem Generator realisieren, 
kein Problem.

Im Unterformular wählt man dann einige Artikel aus, Mengen usw. Und nun öffnet 
der Bearbeiter meist den Bericht um ihn auszudrucken. Sobald die Daten refresht 
werden, sieht man das Theater dass eben Positionen im UFO vorhanden sind die 
dort gar nicht ausgewählt waren. Löscht man diese jetzt beispielsweise heraus, 
verschwinden sie auch aus dem vorherigen Vorgang. Wie schon erwähnt, auch wenn 
nach dem Datensatz von Kunde A ein anderer eingefügt wurde, dennoch wird ein 
Vorgang in den neuen verschmolzen in welchem der Kunde übereinstimmt.

 

Danke für deine Hilfe, viele Grüße nach Brasilien.

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Im Auftrag von Tupy... nambá
Gesendet: Freitag, 6. Dezember 2013 12:05
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] difficult question

 

  

Olaf,

 

Du sagst, I habe ein Form und ein SubForm !!!

 

May I ask you wich development enviroment are you using for the front-end 
application ? I see this kind of application building as having been built with 
MsAccess !!! Because I work with VB, C# and Delphi, and I found this only with 
the Office family !

 

If you have separated forms (sub forms included) for both - parent and child 
table -, I see that you probably don´t have a only one transaction for both sql 
commands do you use explicit transaction in your application ?

 

After you comment so:

>>2. Have you the same transaction for master detail 
>Both tables are linked to the firebird database over the firebird odbc driver. 
>After I insert the master 
>record and klick into the detail-form, I get the generated Nr back from 
>firebird (before I insert a detail 
>data set). I’m sorry, I don’t know how the driver works in detail. 

... you don´t talk explicitly something about this. Making this sequence of 
operations doesn´t mean you have a common transaction. If you don´t explicitly 
start a transaction, you will not have a transaction for both commands.

 

Roberto Camargo,

aus Brasilien

 

On Friday, December 6, 2013 7:45 AM, checkmail <  
check_m...@satron.de> wrote:

 

Hello @ll,

 

Today, I still could not reproduce the error again. What I can say, that I’m 
the only one in my test environment who creates records and the error also 
occurred there.

 

I can try to create a generator instead of the max-statement and I will see.

 

Of course, several people work at the same time (customer) in the database, but 
locally I’m the only one and the problem already exists. I don’t know what 
exactly the error provoked. Currently I have create 100 records and every 
works. I’m confused.

 

Thanks a lot.

 

Best regards

 

Olaf

 

Von:   
firebird-support@yahoogroups.com [  
mailto:firebird-support@yahoogroups.com] Im Auftrag von Svein Erling Tysvær
Gesendet: Donnerstag, 5. Dezember 2013 11:42
An

Re: AW: [firebird-support] difficult question

[Tupy . . . nambá]

Olaf,

Du sagst, I habe ein Form und ein SubForm !!!

May I ask you wich development enviroment are you using for the front-end 
application ? I see this kind of application building as having been built with 
MsAccess !!! Because I work with VB, C# and Delphi, and I found this only with 
the Office family !

If you have separated forms (sub forms included) for both - parent and child 
table -, I see that you probably don´t have a only one transaction for both sql 
commands do you use explicit transaction in your application ?

After you comment so:
>>2. Have you the same transaction for master detail 
>Both tables are linked to the firebird database over the firebird odbc driver. 
>After I insert the master 
>record and klick into the detail-form, I get the generated Nr back from 
>firebird (before I insert a detail 
>data set). I’m sorry, I don’t know how the driver works in detail. 

... you don´t talk explicitly something about this. Making this sequence of 
operations doesn´t mean you have a common transaction. If you don´t explicitly 
start a transaction, you will not have a transaction for both commands.

Roberto Camargo,
aus Brasilien



On Friday, December 6, 2013 7:45 AM, checkmail  wrote:
 



Hello @ll,
 
Today,I still could notreproducetheerroragain. What I can say, that I’m the 
only one in my test environment who creates records and the error also occurred 
there.
 
I can try to create a generator instead of the max-statement and I will see.
 
Of course, severalpeople work at the same time (customer) in the database, but 
locally I’m the only one and the problem already exists. I don’t know what 
exactly the error provoked. Currently I have create 100 records and every 
works. I’m confused.
 
Thanks a lot.
 
Best regards
 
Olaf
 
Von:firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Im Auftrag von Svein Erling Tysvær
Gesendet:Donnerstag, 5. Dezember 2013 11:42
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] difficult question
 
  
>>>I have a table with orders and a second table with orderpositions. The 
>>>composite primary key from orders 
>>>consists of jahr and nr, the orderpositions references with a foreign key to 
>>>this table and its primary 
>>>key is a continual ID. 
> 
>>>In my Frontend there is a form with the orders and a sub-form with the 
>>>positions – the data-side of both 
>>>forms is connected over jahr and nr. Now I can create a order, in main-form 
>>>I select a supplier and 
>>>select some articles in my sub-form. Ideally – it works fine. But in some 
>>>case (notably if in the order 
>>>before it is the same supplier) I select one or more parts to order and If 
>>>the form will refresh, the 
>>>order-positions from the order before are in the actually order! If I close 
>>>the form and reopen it again, 
>>>the last orderpositions and in the order before there are the from the last 
>>>order. The same situation I 
>>>have with a different odbc-driver and some other versions of Access. I’m 
>>>confused and the problem exists 
>>>for some years! One from 50 orders goes wrong in this way, the same problem 
>>>exists in some other areas 
> 
>>1. How you generate pk keys 
>Master: In this case I generate it with select max(nr)+1 from xxx where 
>new.jahr… I know, not the best way. 
>Detail: NEW.ID = GEN_ID(TBESTPOS_ID_GEN, 1); (generator) 
> 
>>2. Have you the same transaction for master detail 
>Both tables are linked to the firebird database over the firebird odbc driver. 
>After I insert the master 
>record and klick into the detail-form, I get the generated Nr back from 
>firebird (before I insert a detail 
>data set). I’m sorry, I don’t know how the driver works in detail. 

Transactions are vital in Firebird, I don't use ODBC with Firebird and don't 
know how to control transactions in your environment. What I think can be a 
possible cause, is if the master and detail query are in separate transactions. 
Then I can imagine one user inserting a new master with, say, ID 51, and a few 
detail records (say ID 101, 102, 103). Then another user (before the 
transaction of the other master is committed) tries to insert another master, 
but since the other master isn't committed yet, this ID also is 51. This user 
also insert detail records (say ID 104, 105). Upon committing, the first user 
will succeed with his inserts, whereas the other user will get a lock conflict 
for the transaction for the master and succeed for the transaction with the 
detail records. Normally, this second user should get an error message, but it 
is of course possible to suppress that in your program. Hence you may end up 
with one master with ID 51 and detail 101,
 102, 103, 104 and 105, whereas the other master isn't inserted at all. 

If this is the reason, the simple way to fix things would be to start using one 
or more generators for the master (you may have a separate generator for each 
jahr, or reset the generator each jahr if jahr is

AW: AW: [firebird-support] difficult question

[checkmail]

Hello,

 

I'm sorry, I don't know exactly how the odbd driver works. Actually I work
alone on the database, no other user creates records. Microsoft Access gets
the record-ID after I change the focus.

 

Thank you.

 

Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von Iwan Cahyadi Sugeng
Gesendet: Donnerstag, 5. Dezember 2013 10:26
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] difficult question

 

  

Hi,
Are you having this problem when there are more than one user in transaction
at the same time
i'm guessing the problem is the child table have different parent key.

Check in the child table wether the parent key is correct.

The problem maybe because the child get a different parent key because you
might get the parent key using get last id of the parent

Can you tell me how you get the parent key

AW: [firebird-support] difficult question

[checkmail]

Hello @ll,

 

Today, I still could not reproduce the error again. What I can say, that I’m 
the only one in my test environment who creates records and the error also 
occurred there.

 

I can try to create a generator instead of the max-statement and I will see.

 

Of course, several people work at the same time (customer) in the database, but 
locally I’m the only one and the problem already exists. I don’t know what 
exactly the error provoked. Currently I have create 100 records and every 
works. I’m confused.

 

Thanks a lot.

 

Best regards

 

Olaf

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Im Auftrag von Svein Erling Tysvær
Gesendet: Donnerstag, 5. Dezember 2013 11:42
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] difficult question

 

  

>>>I have a table with orders and a second table with orderpositions. The 
>>>composite primary key from orders 
>>>consists of jahr and nr, the orderpositions references with a foreign key to 
>>>this table and its primary 
>>>key is a continual ID. 
> 
>>>In my Frontend there is a form with the orders and a sub-form with the 
>>>positions – the data-side of both 
>>>forms is connected over jahr and nr. Now I can create a order, in main-form 
>>>I select a supplier and 
>>>select some articles in my sub-form. Ideally – it works fine. But in some 
>>>case (notably if in the order 
>>>before it is the same supplier) I select one or more parts to order and If 
>>>the form will refresh, the 
>>>order-positions from the order before are in the actually order! If I close 
>>>the form and reopen it again, 
>>>the last orderpositions and in the order before there are the from the last 
>>>order. The same situation I 
>>>have with a different odbc-driver and some other versions of Access. I’m 
>>>confused and the problem exists 
>>>for some years! One from 50 orders goes wrong in this way, the same problem 
>>>exists in some other areas 
> 
>>1. How you generate pk keys 
>Master: In this case I generate it with select max(nr)+1 from xxx where 
>new.jahr… I know, not the best way. 
>Detail: NEW.ID = GEN_ID(TBESTPOS_ID_GEN, 1); (generator) 
> 
>>2. Have you the same transaction for master detail 
>Both tables are linked to the firebird database over the firebird odbc driver. 
>After I insert the master 
>record and klick into the detail-form, I get the generated Nr back from 
>firebird (before I insert a detail 
>data set). I’m sorry, I don’t know how the driver works in detail. 

Transactions are vital in Firebird, I don't use ODBC with Firebird and don't 
know how to control transactions in your environment. What I think can be a 
possible cause, is if the master and detail query are in separate transactions. 
Then I can imagine one user inserting a new master with, say, ID 51, and a few 
detail records (say ID 101, 102, 103). Then another user (before the 
transaction of the other master is committed) tries to insert another master, 
but since the other master isn't committed yet, this ID also is 51. This user 
also insert detail records (say ID 104, 105). Upon committing, the first user 
will succeed with his inserts, whereas the other user will get a lock conflict 
for the transaction for the master and succeed for the transaction with the 
detail records. Normally, this second user should get an error message, but it 
is of course possible to suppress that in your program. Hence you may end up 
with one master with ID 51 and detail 101, 102, 103, 104 and 105, whereas the 
other master isn't inserted at all. 

If this is the reason, the simple way to fix things would be to start using one 
or more generators for the master (you may have a separate generator for each 
jahr, or reset the generator each jahr if jahr is always the current year). 

HTH, 
Set