[firebird-support] Transactions for read-only selects
When closing a read-only transaction for a read operation - does it matter if COMMIT vs ROLLBACK is used? -- Daniel
Re: [firebird-support] php transactions
12.07.2016 22:28, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > Could my problem be that I need to use explicit transactions for the selects > as well? Yes. -- 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] php transactions
I have an application I'm developing with PHP & Firebird. While it mostly works fine - I've been having what I believe to be transaction issues. One problem was visibility - committed changes were not visible to selects. I know they were committed - after executing the commit within the scripts, I could see the changes within FlameRobin. Yet the script didn't see them. I also saw the "oldest active transaction" getting old...and it didn't seem to update until I killed some of the longer-running php processes. I use explicit transactions for every insert or update followed by explicit commits. Could my problem be that I need to use explicit transactions for the selects as well? -- Daniel
[firebird-support] Re: Triggers on table MON$ATTACHMENTS
> ---In firebird-support@yahoogroups.com, wrote : > > I can create triggers in the MON$ATTACHMENTS table? No > I use Firebird 2.5.6 with flamerobin > > I want to do something like "After Delete" > delete from table1 where con = old.MON$ATTACHMENT_ID RTFM: Database triggers http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-trgr.html#fblangref25-ddl-trgr-dbtrigger http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-trgr.html#fblangref25-ddl-trgr-dbtrigger
Re: [firebird-support] Triggers on table MON$ATTACHMENTS
12.07.2016 21:17, 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] wrote: > I can create triggers in the MON$ATTACHMENTS table? No, you cannot. -- 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] Triggers on table MON$ATTACHMENTS
I can create triggers in the MON$ATTACHMENTS table? I use Firebird 2.5.6 with flamerobin I want to do something like "After Delete" delete from table1 where con = old.MON$ATTACHMENT_ID Best Regards | ISMAEL |
[firebird-support] Re: Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).
16.06.2016 09:02, Roland Turcan wrote: > > I am trying to deploy Firebird 3.0 to our customers. Only three small > customers are running on FB3, but all of them have the same problem: > > invalid transaction handle (expecting explicit transaction start). > > This exception happens on different places which are not reproducible. > It doesn't even depend if software built on Delphi XE6 IBX or > FirebirdSQL.NET provider. Both drivers are having the same problem. > I have got it on my test machine only once, but I can't get it again. > > The fact is, that I have checked logs of all customers running FB2.5 > and no one has this problem on FB2.5 for years. This appears to be a bug in Firebird 3, being researched right now. I hope to have the fix committed in a day or two. Dmitry ++ 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] Failure to create primary key - 2.5, 64 bit, Linux
... but having restored the database from backup the problem appears to have gone away. On 12/07/2016 12:52, Tim Ward wrote: There was plenty of space on the disk partition containing the database. But there had at some point been a disk full on some other partition. So, having run out of ideas, I've deleted the database and am recreating it from backup, in the hope that just maybe it got corrupted when the other partition filled up. On 12/07/2016 12:50, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: W dniu 2016-07-12 11:54:52 użytkownik Tim Ward t...@telensa.com [firebird-support] napisał: == > CREATE TABLE TBLCSTAGASSETS > ( > ELEMENTID BIGINT NOT NULL, > USERID INTEGER NOT NULL, > CONSTRAINT PK_TBLCSTAGASSETS PRIMARY KEY (ELEMENTID, USERID) > ) > commit < ERROR: unsuccessful metadata update cannot create index PK_TBLCSTAGASSETS > script processed in 0.055 sec == This works when run against a 32 bit 2.1 database but fails when run against a 64 bit 2.5 database. What's going on please? -- Tim Ward What exact version of FB2.5 i tested this on WI-V2.5.3.26738 Firebird 2.5 but on Windows not Linux and no problems. Do you have free disc space? May be db try to expand? regards, Karol Bieniaszewski -- Tim Ward -- Tim Ward
Re: [firebird-support] Failure to create primary key - 2.5, 64 bit, Linux
There was plenty of space on the disk partition containing the database. But there had at some point been a disk full on some other partition. So, having run out of ideas, I've deleted the database and am recreating it from backup, in the hope that just maybe it got corrupted when the other partition filled up. On 12/07/2016 12:50, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: W dniu 2016-07-12 11:54:52 użytkownik Tim Ward t...@telensa.com [firebird-support] napisał: == > CREATE TABLE TBLCSTAGASSETS > ( > ELEMENTID BIGINT NOT NULL, > USERID INTEGER NOT NULL, > CONSTRAINT PK_TBLCSTAGASSETS PRIMARY KEY (ELEMENTID, USERID) > ) > commit < ERROR: unsuccessful metadata update cannot create index PK_TBLCSTAGASSETS > script processed in 0.055 sec == This works when run against a 32 bit 2.1 database but fails when run against a 64 bit 2.5 database. What's going on please? -- Tim Ward What exact version of FB2.5 i tested this on WI-V2.5.3.26738 Firebird 2.5 but on Windows not Linux and no problems. Do you have free disc space? May be db try to expand? regards, Karol Bieniaszewski -- Tim Ward
Re: [firebird-support] Failure to create primary key - 2.5, 64 bit, Linux
W dniu 2016-07-12 11:54:52 użytkownik Tim Ward t...@telensa.com [firebird-support] napisał: == > CREATE TABLE TBLCSTAGASSETS > ( > ELEMENTID BIGINT NOT NULL, > USERID INTEGER NOT NULL, > CONSTRAINT PK_TBLCSTAGASSETS PRIMARY KEY (ELEMENTID, USERID) > ) > commit < ERROR: unsuccessful metadata update cannot create index PK_TBLCSTAGASSETS > script processed in 0.055 sec == This works when run against a 32 bit 2.1 database but fails when run against a 64 bit 2.5 database. What's going on please? -- Tim Ward What exact version of FB2.5 i tested this on WI-V2.5.3.26738 Firebird 2.5 but on Windows not Linux and no problems. Do you have free disc space? May be db try to expand? regards, Karol Bieniaszewski
[firebird-support] Failure to create primary key - 2.5, 64 bit, Linux
== > CREATE TABLE TBLCSTAGASSETS > ( > ELEMENTID BIGINT NOT NULL, > USERID INTEGER NOT NULL, > CONSTRAINT PK_TBLCSTAGASSETS PRIMARY KEY (ELEMENTID, USERID) > ) > commit < ERROR: unsuccessful metadata update cannot create index PK_TBLCSTAGASSETS > script processed in 0.055 sec == This works when run against a 32 bit 2.1 database but fails when run against a 64 bit 2.5 database. What's going on please? -- Tim Ward