Re: [firebird-support] FB3.0.2 : Lost one record (update on power off ?)
I suggest you to check and test following: - be extremely sure no client is deleting the record - hard drive corruption with apropriate software like SeaTools - hard drive cache enabled - try install latest Firebird 3.0.3 doing a backup restore On Mon, Mar 19, 2018, 14:17 eric.gueguin...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Hello, > > > We have a strange thing on a firebird 3.0.2 database > One only Machine on Windows (Microsoft Windows Embedded Standard) > > We lost a record in a database > > Circumstances : > > Power off of the computer in activity > After restart our program doesn't work ( Qt Program ) > No problem on validation > Backup and restore ok without problem > and we find that a main record in a table is not exist anymore > We reinject from a previous backup and it's start again > > We are sure that the record was in database just before power off > ( This record is essential to program and we have some dependant record > just before power off ) > > We don't have : > delete code to this table in the program > no delete code in stored procedure to this table > nor in source program and not in the database stored proc > > the only operation is that we update a field very often on this record > So maybe this record just was in update when computer was power off > > No messages in firebird.log > > > We never have such thing with previous releases of firebird (2.5, 2.1, 1.5) > > Usually, the db was corrupted in such situation and we know that a problem > was occured > > > Is somebody have heard something about such problem with FB3 ? > > > Thank you. > > > > > > > > >
Re: [firebird-support] Hello
On 2018-03-19 15:46, titixi eric.gueguin...@gmail.com [firebird-support] wrote: > Hello, > > I want to post bug reports on your group. > When I can do it ? Bugs can be reported on the tracker: http://tracker.firebirdsql.org/ Please make sure to provide all relevant information to reproduce the problem. However if you want to post support questions, you can do that right here in the firebird-support mailing list. Mark
[firebird-support] FB3.0.2 : Lost one record (update on power off ?)
Hello, We have a strange thing on a firebird 3.0.2 database One only Machine on Windows (Microsoft Windows Embedded Standard) We lost a record in a database Circumstances : Power off of the computer in activity After restart our program doesn't work ( Qt Program ) No problem on validation Backup and restore ok without problem and we find that a main record in a table is not exist anymore We reinject from a previous backup and it's start again We are sure that the record was in database just before power off ( This record is essential to program and we have some dependant record just before power off ) We don't have : delete code to this table in the program no delete code in stored procedure to this table nor in source program and not in the database stored proc the only operation is that we update a field very often on this record So maybe this record just was in update when computer was power off No messages in firebird.log We never have such thing with previous releases of firebird (2.5, 2.1, 1.5) Usually, the db was corrupted in such situation and we know that a problem was occured Is somebody have heard something about such problem with FB3 ? Thank you.
[firebird-support] Hello
Hello, I want to post bug reports on your group. When I can do it ? Thanks Eric Guéguiniat
Re: AW: [firebird-support] Re: Trace not working
> Well, I started the trace and the system prompted the message about trace > start its ID. But there was no output. > Now I realized, that there is a difference between the alias and the absolute > database path in config. > > I used the alias name in config and the absolute path in my application. > When I switched the application to the alias > name I was able to get the correct trace outputs. Is there a documentation > about that? I couldn’t find anything about it. Trace, of course, doesn't try to expand value set at the "database" section using the aliases.conf\databases.conf. Documentation at the beginning of the default fbtrace.conf say: # Pattern is either database name without path or "SIMILAR TO"-based regular # expression which is matched against fully qualified database path name. Hope it is clear now :) Regards, Vlad
Re: AW: [firebird-support] Re: Trace not working
>> Hmm... what do you mean ? > >> There should be almost instant message about trace started with trace ID, >> but then messages will appear only when some events happens in database. > > Well, I started the trace and the system prompted the message about trace > start > its ID. But there was no output. Now I realized, that there is a difference > between the alias and the absolute database path in config. > > I used the alias name in config and the absolute path in my application. When > I > switched the application to the alias name I was able to get the correct trace > outputs. Is there a documentation about that? I couldn’t find anything about > it. 'database' in your trace configuration is basically a regex, thus without any wildcards, this results in an exact match being necessary to be picked up then by the database filter in the trace component on the server side. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
AW: [firebird-support] Re: Trace not working
> Hmm... what do you mean ? > There should be almost instant message about trace started with trace ID, > but then messages will appear only when some events happens in database. Well, I started the trace and the system prompted the message about trace start its ID. But there was no output. Now I realized, that there is a difference between the alias and the absolute database path in config. I used the alias name in config and the absolute path in my application. When I switched the application to the alias name I was able to get the correct trace outputs. Is there a documentation about that? I couldn’t find anything about it. Regards, Martin
Re: [firebird-support] Network disconnection
19.03.2018 10:34, atuncce...@duzen.com.tr [firebird-support] wrote: > Sometimes, on some computers the application crashes with this error, which > can be seen in > the event log: > > > Faulting application name: duzen_test.exe, version: 1.5.5.9106, time stamp: > 0x2a425e19 > Faulting module name: KERNELBASE.dll, version: 10.0.16299.309, time stamp: > 0xd3aa915c > Exception code: 0x0eedfade > Fault offset: 0x001008f2 > Faulting process id: 0x1a50 > Faulting application start time: 0x01d3bf53640714a3 > Faulting application path: C:\Program Files\duzenlab\duzen_test.exe > Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll > Report Id: fc986cb6-6732-4a28-94e5-46c05fc04f5f > > I can replicate this error by disconnecting and reconnecting the cat5 network > cable or by > disabling-enabling the network adapter. No Firebird is mentioned anywhere. eedfade is Delphi exception that is raised when accessing already freed memory. Use built-in FastMM debug capacities to debug your application. -- 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: Trace not working
Hi Martin, > the trace works now. Good to know ;) > It just took a long time to start. Hmm... what do you mean ? There should be almost instant message about trace started with trace ID, but then messages will appear only when some events happens in database. Regards, Vlad
AW: AW: [firebird-support] Re: Trace not working
Hi Vlad, the trace works now. It just took a long time to start. Thank you. Martin
[firebird-support] Network disconnection
Hi, I have a desktop application which uses firebird 2.5 as the database. Sometimes, on some computers the application crashes with this error, which can be seen in the event log: Faulting application name: duzen_test.exe, version: 1.5.5.9106, time stamp: 0x2a425e19 Faulting module name: KERNELBASE.dll, version: 10.0.16299.309, time stamp: 0xd3aa915c Exception code: 0x0eedfade Fault offset: 0x001008f2 Faulting process id: 0x1a50 Faulting application start time: 0x01d3bf53640714a3 Faulting application path: C:\Program Files\duzenlab\duzen_test.exe Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll Report Id: fc986cb6-6732-4a28-94e5-46c05fc04f5f I can replicate this error by disconnecting and reconnecting the cat5 network cable or by disabling-enabling the network adapter. --- According to http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Writing_Dynamically_Loaded_Libraries#Exceptions_and_Runtime_Errors_in_Libraries http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Writing_Dynamically_Loaded_Libraries#Exceptions_and_Runtime_Errors_in_Libraries If the calling application or library is itself written in Delphi, the exception can be handled through a normal try...except statement. On Win32, if the calling application or library is written in another language, the exception can be handled as an operating-system exception with the exception code $0EEDFADE. In this case, when a runtime error occurs in the library, the calling application terminates. --- So, I this error can be related with gds32.dll (which I still use) Enabling and disabling the network adapter consecutively and quickly is enough to crash the application. The application connects to the database on start and keeps connected all the time, till it's closed. Is there any ideas? Can anything be done without the need to change the application? Thank you
RE: [firebird-support] update or insert from in-line query
Hi Mark, I meant, if he needs insert and update, it's enough for him. András From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Monday, March 19, 2018 9:04 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] update or insert from in-line query On 19-3-2018 07:51, Omacht András aoma...@mve.hu [firebird-support] wrote: > Hi Hamis, > > > > merge is your friend: > > https://firebirdsql.org/refdocs/langrefupd21-merge.html > > > > In FB 2.5 series only insert and update is supported. What do you mean with this sentence? -- Mark Rotteveel __ Information from ESET Mail Security, version of virus signature database 17079 (20180319) __ The message was checked by ESET Mail Security. http://www.eset.com [Non-text portions of this message have been removed]
Re: [firebird-support] update or insert from in-line query
On 19-3-2018 07:51, Omacht András aoma...@mve.hu [firebird-support] wrote: > Hi Hamis, > > > > merge is your friend: > > https://firebirdsql.org/refdocs/langrefupd21-merge.html > > > > In FB 2.5 series only insert and update is supported. What do you mean with this sentence? -- Mark Rotteveel