Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support] 
Hello,

> We have backed up our databases daily for two years using Firebird 2.52
> Superserver and its associated gbak.  We now need to restore one of the
> databases and gbak fails to do the restore, giving the following error:
>

[snip gbak output]

> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
> gbak: ERROR:table/procedure has non-SQL security class defined
> gbak:Exiting before completion due to errors
>
>
> We have no procedures defined in or for our database.  It appears gbak
> has restored the database except for something at the end.  The database
> is working correctly every day.  Is this copy of the database backup toast?
>
>
> Should we be using a different backup tool like nbackup?  Can we use
> Interbase gbak to recreate the database?
>
>
> We are backing up our databases on Windows 7 using 2.52 Superserver.
> The databases are on a Linux Mint server.

I'm confused. The databases are hosted on Linux (InterBase or Firebird?) 
but you are running a backup from Win7?

You asked something similar > 2 years ago:
http://comments.gmane.org/gmane.comp.db.firebird.user/7145


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.


> However, when we are trying
> to do the restore, we are restoring it to a directory on Windows 7
> because we don't trust restoring it over the currently running
> database.  So, the backup and restore are both on the same Windows 7
> computer using the same 2.52 Superserver.
>
>
> We need some data from the database from yesterday, so we just wanted to
> restore that long enough to pull the data.  The table we want, ON_ORDER,
> appears to have been restored but we cannot open the restored database
> to access it.
>
>
> Help?
>
>
> 
> Posted by: Jack Mason 
> 
>
> ++
>
> 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] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 

Yes, but it did not get resolved then.

Jack

On 6/11/2015 3:36 AM, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:


>>You asked something similar > 2 years ago:

>>http://comments.gmane.org/gmane.comp.db.firebird.user/7145

>>--
>>With regards,
>>Thomas Steinmaurer
>>http://www.upscene.com/

Sorry for off-top but

I'am very interested what jack.mason will say about this :

You have my +1 ;-)

regards,

Karol Bieniaszewski




--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
The databases reside on a Linux Mint server, but we back them up to a 
Windows 7 system.   Both are running the same release of Firebird.  We 
use Linux as the server because Linux is far more reliable than Windows 
for everything, but it is the only Linux computer we use.  Everything 
else is Windows because of other software we run.  So, to back up the 
databases, we put the backups on a Windows 7 computer, blandly assuming 
it is just a file that can be restored by the same program that backed 
it up, gbak on Windows 7.


We had the same problem two years ago, and it never got resolved, it 
just disappeared, so we assumed we had done something wrong and were no 
longer doing whatever that was.


Jack

On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com 
[firebird-support] wrote:


Hello,

> We have backed up our databases daily for two years using Firebird 2.52
> Superserver and its associated gbak. We now need to restore one of the
> databases and gbak fails to do the restore, giving the following error:
>

[snip gbak output]

> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
> gbak: ERROR: table/procedure has non-SQL security class defined
> gbak:Exiting before completion due to errors
>
>
> We have no procedures defined in or for our database. It appears gbak
> has restored the database except for something at the end. The database
> is working correctly every day. Is this copy of the database backup 
toast?

>
>
> Should we be using a different backup tool like nbackup? Can we use
> Interbase gbak to recreate the database?
>
>
> We are backing up our databases on Windows 7 using 2.52 Superserver.
> The databases are on a Linux Mint server.

I'm confused. The databases are hosted on Linux (InterBase or Firebird?)
but you are running a backup from Win7?

You asked something similar > 2 years ago:
http://comments.gmane.org/gmane.comp.db.firebird.user/7145

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

> However, when we are trying
> to do the restore, we are restoring it to a directory on Windows 7
> because we don't trust restoring it over the currently running
> database. So, the backup and restore are both on the same Windows 7
> computer using the same 2.52 Superserver.
>
>
> We need some data from the database from yesterday, so we just wanted to
> restore that long enough to pull the data. The table we want, ON_ORDER,
> appears to have been restored but we cannot open the restored database
> to access it.
>
>
> Help?
>
>
> 
> Posted by: Jack Mason 
> 
>
> ++
>
> 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
>
>
>




--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 

> The databases reside on a Linux Mint server, but we back them up to a 
> Windows 7 system.   Both are running the same release of Firebird.  We 
> use Linux as the server because Linux is far more reliable than Windows 
> for everything, but it is the only Linux computer we use.  Everything 
> else is Windows because of other software we run.  So, to back up the 
> databases, we put the backups on a Windows 7 computer, blandly assuming 
> it is just a file that can be restored by the same program that backed 
> it up, gbak on Windows 7.

You mean a physical file copy from Linux to Windows while the database is in 
use?


> We had the same problem two years ago, and it never got resolved, it 
> just disappeared, so we assumed we had done something wrong and were no 
> longer doing whatever that was.

And you don't call a different gbak version by accident, e.g. due to a set PATH 
environment variable etc.?

Regards,
Thomas


> Jack
> 
> On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com 
> [firebird-support] wrote:
>>
>> Hello,
>>
>> > We have backed up our databases daily for two years using Firebird 2.52
>> > Superserver and its associated gbak. We now need to restore one of the
>> > databases and gbak fails to do the restore, giving the following error:
>> >
>>
>> [snip gbak output]
>>
>> > gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
>> > gbak: ERROR: table/procedure has non-SQL security class defined
>> > gbak:Exiting before completion due to errors
>> >
>> >
>> > We have no procedures defined in or for our database. It appears gbak
>> > has restored the database except for something at the end. The database
>> > is working correctly every day. Is this copy of the database backup 
>> toast?
>> >
>> >
>> > Should we be using a different backup tool like nbackup? Can we use
>> > Interbase gbak to recreate the database?
>> >
>> >
>> > We are backing up our databases on Windows 7 using 2.52 Superserver.
>> > The databases are on a Linux Mint server.
>>
>> I'm confused. The databases are hosted on Linux (InterBase or Firebird?)
>> but you are running a backup from Win7?
>>
>> You asked something similar > 2 years ago:
>> http://comments.gmane.org/gmane.comp.db.firebird.user/7145
>>
>> -- 
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird
>> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>>
>> > However, when we are trying
>> > to do the restore, we are restoring it to a directory on Windows 7
>> > because we don't trust restoring it over the currently running
>> > database. So, the backup and restore are both on the same Windows 7
>> > computer using the same 2.52 Superserver.
>> >
>> >
>> > We need some data from the database from yesterday, so we just wanted to
>> > restore that long enough to pull the data. The table we want, ON_ORDER,
>> > appears to have been restored but we cannot open the restored database
>> > to access it.
>> >
>> >
>> > Help?
>> >
>> >
>> > 
>> > Posted by: Jack Mason 
>> > 
>> >
>> > ++
>> >
>> > 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
>> >
>> >
>> >
>>
>> 
> 
> -- 
> "Our Constitution was made only for a moral and religious people. It is 
> wholly inadequate to the government of any other." -- John Adams, Oct. 
> 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
The databases are backed up between midnight and 6 am when no one is 
using them.  However, the databases are still open in multiple 
programs.  The backup is:


C:\"program files"\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA 
-pas masterkey 192.168.1.252:/bfl/smtbdb/customer 
C:\backups\Buford\Thursday\customer.bak


and the restore is:

C:\"program files"\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA 
-pas masterkey  C:\backups\Buford\Thursday\customer.bak 
localhost:c:\temp\customer




Jack



On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com 
[firebird-support] wrote:



> The databases reside on a Linux Mint server, but we back them up to a
> Windows 7 system. Both are running the same release of Firebird. We
> use Linux as the server because Linux is far more reliable than Windows
> for everything, but it is the only Linux computer we use. Everything
> else is Windows because of other software we run. So, to back up the
> databases, we put the backups on a Windows 7 computer, blandly assuming
> it is just a file that can be restored by the same program that backed
> it up, gbak on Windows 7.

You mean a physical file copy from Linux to Windows while the database 
is in use?


> We had the same problem two years ago, and it never got resolved, it
> just disappeared, so we assumed we had done something wrong and were no
> longer doing whatever that was.

And you don't call a different gbak version by accident, e.g. due to a 
set PATH environment variable etc.?


Regards,
Thomas

> Jack
>
> On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com
> [firebird-support] wrote:
>>
>> Hello,
>>
>> > We have backed up our databases daily for two years using 
Firebird 2.52
>> > Superserver and its associated gbak. We now need to restore one 
of the
>> > databases and gbak fails to do the restore, giving the following 
error:

>> >
>>
>> [snip gbak output]
>>
>> > gbak: ERROR:action cancelled by trigger (3) to preserve data 
integrity

>> > gbak: ERROR: table/procedure has non-SQL security class defined
>> > gbak:Exiting before completion due to errors
>> >
>> >
>> > We have no procedures defined in or for our database. It appears gbak
>> > has restored the database except for something at the end. The 
database

>> > is working correctly every day. Is this copy of the database backup
>> toast?
>> >
>> >
>> > Should we be using a different backup tool like nbackup? Can we use
>> > Interbase gbak to recreate the database?
>> >
>> >
>> > We are backing up our databases on Windows 7 using 2.52 Superserver.
>> > The databases are on a Linux Mint server.
>>
>> I'm confused. The databases are hosted on Linux (InterBase or 
Firebird?)

>> but you are running a backup from Win7?
>>
>> You asked something similar > 2 years ago:
>> http://comments.gmane.org/gmane.comp.db.firebird.user/7145
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird
>> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>>
>> > However, when we are trying
>> > to do the restore, we are restoring it to a directory on Windows 7
>> > because we don't trust restoring it over the currently running
>> > database. So, the backup and restore are both on the same Windows 7
>> > computer using the same 2.52 Superserver.
>> >
>> >
>> > We need some data from the database from yesterday, so we just 
wanted to
>> > restore that long enough to pull the data. The table we want, 
ON_ORDER,
>> > appears to have been restored but we cannot open the restored 
database

>> > to access it.
>> >
>> >
>> > Help?
>> >
>> >
>> > 
>> > Posted by: Jack Mason 
>> > 
>> >
>> > ++
>> >
>> > 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
>> >
>> >
>> >
>>
>>
>
> --
> "Our Constitution was made only for a moral and religious people. It is
> wholly inadequate to the government of any other." -- John Adams, Oct.
> 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>




--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 

> The databases are backed up between midnight and 6 am when no one is 
> using them.  However, the databases are still open in multiple 
> programs.  The backup is:
> 
> C:\"program files"\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA 
> -pas masterkey 192.168.1.252:/bfl/smtbdb/customer 
> C:\backups\Buford\Thursday\customer.bak
> 
> and the restore is:
> 
> C:\"program files"\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA 
> -pas masterkey  C:\backups\Buford\Thursday\customer.bak 
> localhost:c:\temp\customer

What is the result of gstat -h on the production database?


Thomas


> Jack
> 
> 
> 
> On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com 
> [firebird-support] wrote:
>>
>>
>> > The databases reside on a Linux Mint server, but we back them up to a
>> > Windows 7 system. Both are running the same release of Firebird. We
>> > use Linux as the server because Linux is far more reliable than Windows
>> > for everything, but it is the only Linux computer we use. Everything
>> > else is Windows because of other software we run. So, to back up the
>> > databases, we put the backups on a Windows 7 computer, blandly assuming
>> > it is just a file that can be restored by the same program that backed
>> > it up, gbak on Windows 7.
>>
>> You mean a physical file copy from Linux to Windows while the database 
>> is in use?
>>
>> > We had the same problem two years ago, and it never got resolved, it
>> > just disappeared, so we assumed we had done something wrong and were no
>> > longer doing whatever that was.
>>
>> And you don't call a different gbak version by accident, e.g. due to a 
>> set PATH environment variable etc.?
>>
>> Regards,
>> Thomas
>>
>> > Jack
>> >
>> > On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com
>> > [firebird-support] wrote:
>> >>
>> >> Hello,
>> >>
>> >> > We have backed up our databases daily for two years using 
>> Firebird 2.52
>> >> > Superserver and its associated gbak. We now need to restore one 
>> of the
>> >> > databases and gbak fails to do the restore, giving the following 
>> error:
>> >> >
>> >>
>> >> [snip gbak output]
>> >>
>> >> > gbak: ERROR:action cancelled by trigger (3) to preserve data 
>> integrity
>> >> > gbak: ERROR: table/procedure has non-SQL security class defined
>> >> > gbak:Exiting before completion due to errors
>> >> >
>> >> >
>> >> > We have no procedures defined in or for our database. It appears gbak
>> >> > has restored the database except for something at the end. The 
>> database
>> >> > is working correctly every day. Is this copy of the database backup
>> >> toast?
>> >> >
>> >> >
>> >> > Should we be using a different backup tool like nbackup? Can we use
>> >> > Interbase gbak to recreate the database?
>> >> >
>> >> >
>> >> > We are backing up our databases on Windows 7 using 2.52 Superserver.
>> >> > The databases are on a Linux Mint server.
>> >>
>> >> I'm confused. The databases are hosted on Linux (InterBase or 
>> Firebird?)
>> >> but you are running a backup from Win7?
>> >>
>> >> You asked something similar > 2 years ago:
>> >> http://comments.gmane.org/gmane.comp.db.firebird.user/7145
>> >>
>> >> --
>> >> With regards,
>> >> Thomas Steinmaurer
>> >> http://www.upscene.com/
>> >>
>> >> Professional Tools and Services for Firebird
>> >> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>> >>
>> >> > However, when we are trying
>> >> > to do the restore, we are restoring it to a directory on Windows 7
>> >> > because we don't trust restoring it over the currently running
>> >> > database. So, the backup and restore are both on the same Windows 7
>> >> > computer using the same 2.52 Superserver.
>> >> >
>> >> >
>> >> > We need some data from the database from yesterday, so we just 
>> wanted to
>> >> > restore that long enough to pull the data. The table we want, 
>> ON_ORDER,
>> >> > appears to have been restored but we cannot open the restored 
>> database
>> >> > to access it.
>> >> >
>> >> >
>> >> > Help?
>> >> >
>> >> >
>> >> > 
>> >> > Posted by: Jack Mason 
>> >> > 
>> >> >
>> >> > ++
>> >> >
>> >> > 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
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> > --
>> > "Our Constitution was made only for a moral and religious people. It is
>> > wholly inadequate to the government of any other." -- John Adams, Oct.
>> > 11, 1798 "Where there is no vision, the people perish.." Prov 29:18
>> >
>>
>> 
> 
> -- 
> "Our Constitution was made only for a m

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 

gstat is not included in the Firebird release I downloaded:

C:\Firebird>dir
 Volume in drive C has no label.
 Volume Serial Number is FA80-0C12

 Directory of C:\Firebird

09/29/2014  02:25 PM  .
09/29/2014  02:25 PM  ..
09/29/2014  01:16 PM   105,717 Firebird-2.1-ErrorCodes.pdf
09/29/2014  01:06 PM 1,159,676 Firebird-2.5-LangRef-Update.pdf
09/29/2014  01:06 PM   245,583 Firebird-2.5-QuickStart.pdf
09/29/2014  01:00 PM10,467,361 Firebird-2.5.3.26778-0_Win32.zip
09/29/2014  01:01 PM12,259,685 Firebird-2.5.3.26778-0_x64.zip
09/29/2014  01:00 PM 6,973,448 Firebird-2.5.3.26778_0_Win32.exe
09/29/2014  12:58 PM10,282,876 Firebird-2.5.3.26778_0_x64.exe
09/29/2014  01:14 PM85,664 Firebird-fbmgr.pdf
09/29/2014  01:16 PM71,972 Firebird-File-Metadata-Security.pdf
09/29/2014  01:12 PM   133,557 Firebird-gbak.pdf
09/29/2014  01:15 PM90,111 Firebird-Generator-Guide.pdf
09/29/2014  01:13 PM   133,621 Firebird-gfix.pdf
09/29/2014  01:11 PM89,144 Firebird-gsec.pdf
09/29/2014  01:14 PM47,968 Firebird-gsplit.pdf
09/29/2014  01:13 PM90,958 Firebird-gstat.pdf
09/29/2014  01:11 PM   225,636 Firebird-isql.pdf
09/29/2014  01:12 PM   102,220 Firebird-nbackup.pdf
09/29/2014  01:15 PM   309,643 Firebird-Null-Guide.pdf
09/29/2014  01:14 PM39,907 Firebird-on-Ubuntu.pdf
09/29/2014  01:13 PM56,914 Firebird-shell-scripts.pdf
09/29/2014  01:15 PM   109,705 MSSQL-to-Firebird.pdf
09/29/2014  01:16 PM   195,585 Using-Firebird_(wip).pdf
  22 File(s) 43,276,951 bytes
   2 Dir(s)  697,431,232,512 bytes free

C:\Firebird>gstat 192.168.1.252:/bfl/smtbdb/customer
'gstat' is not recognized as an internal or external command,
operable program or batch file.

It has been 20+ years since I have done much with Unix.  If you can tell 
me the directory Firebird is installed in on Linux, I will run the gstat 
on the Linux server.  Otherwise, it will take me a while to locate 
it which I will start now.


Thanks,
Jack


C:\Firebird>

On 6/11/2015 9:13 AM, 'Thomas Steinmaurer' t...@iblogmanager.com 
[firebird-support] wrote:



> The databases are backed up between midnight and 6 am when no one is
> using them. However, the databases are still open in multiple
> programs. The backup is:
>
> C:\"program files"\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA
> -pas masterkey 192.168.1.252:/bfl/smtbdb/customer
> C:\backups\Buford\Thursday\customer.bak
>
> and the restore is:
>
> C:\"program files"\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA
> -pas masterkey C:\backups\Buford\Thursday\customer.bak
> localhost:c:\temp\customer

What is the result of gstat -h on the production database?

Thomas

> Jack
>
>
>
> On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com
> [firebird-support] wrote:
>>
>>
>> > The databases reside on a Linux Mint server, but we back them up to a
>> > Windows 7 system. Both are running the same release of Firebird. We
>> > use Linux as the server because Linux is far more reliable than 
Windows

>> > for everything, but it is the only Linux computer we use. Everything
>> > else is Windows because of other software we run. So, to back up the
>> > databases, we put the backups on a Windows 7 computer, blandly 
assuming
>> > it is just a file that can be restored by the same program that 
backed

>> > it up, gbak on Windows 7.
>>
>> You mean a physical file copy from Linux to Windows while the database
>> is in use?
>>
>> > We had the same problem two years ago, and it never got resolved, it
>> > just disappeared, so we assumed we had done something wrong and 
were no

>> > longer doing whatever that was.
>>
>> And you don't call a different gbak version by accident, e.g. due to a
>> set PATH environment variable etc.?
>>
>> Regards,
>> Thomas
>>
>> > Jack
>> >
>> > On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com
>> > [firebird-support] wrote:
>> >>
>> >> Hello,
>> >>
>> >> > We have backed up our databases daily for two years using
>> Firebird 2.52
>> >> > Superserver and its associated gbak. We now need to restore one
>> of the
>> >> > databases and gbak fails to do the restore, giving the following
>> error:
>> >> >
>> >>
>> >> [snip gbak output]
>> >>
>> >> > gbak: ERROR:action cancelled by trigger (3) to preserve data
>> integrity
>> >> > gbak: ERROR: table/procedure has non-SQL security class defined
>> >> > gbak:Exiting before completion due to errors
>> >> >
>> >> >
>> >> > We have no procedures defined in or for our database. It 
appears gbak

>> >> > has restored the database except for something at the end. The
>> database
>> >> > is working correctly every day. Is this copy of the database 
backup

>> >> toast?
>> >> >
>> >> >
>> >> > Should we be using a different backup tool like nbackup? Can 
we use

>> >> > Interbase gbak to recreat

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 
> gstat is not included in the Firebird release I downloaded:
> 
> C:\Firebird>dir
>  Volume in drive C has no label.
>  Volume Serial Number is FA80-0C12
> 
>  Directory of C:\Firebird
> 
> 09/29/2014  02:25 PM  .
> 09/29/2014  02:25 PM  ..
> 09/29/2014  01:16 PM   105,717 Firebird-2.1-ErrorCodes.pdf
> 09/29/2014  01:06 PM 1,159,676 Firebird-2.5-LangRef-Update.pdf
> 09/29/2014  01:06 PM   245,583 Firebird-2.5-QuickStart.pdf
> 09/29/2014  01:00 PM10,467,361 Firebird-2.5.3.26778-0_Win32.zip
> 09/29/2014  01:01 PM12,259,685 Firebird-2.5.3.26778-0_x64.zip
> 09/29/2014  01:00 PM 6,973,448 Firebird-2.5.3.26778_0_Win32.exe
> 09/29/2014  12:58 PM10,282,876 Firebird-2.5.3.26778_0_x64.exe
> 09/29/2014  01:14 PM85,664 Firebird-fbmgr.pdf
> 09/29/2014  01:16 PM71,972 Firebird-File-Metadata-Security.pdf
> 09/29/2014  01:12 PM   133,557 Firebird-gbak.pdf
> 09/29/2014  01:15 PM90,111 Firebird-Generator-Guide.pdf
> 09/29/2014  01:13 PM   133,621 Firebird-gfix.pdf
> 09/29/2014  01:11 PM89,144 Firebird-gsec.pdf
> 09/29/2014  01:14 PM47,968 Firebird-gsplit.pdf
> 09/29/2014  01:13 PM90,958 Firebird-gstat.pdf
> 09/29/2014  01:11 PM   225,636 Firebird-isql.pdf
> 09/29/2014  01:12 PM   102,220 Firebird-nbackup.pdf
> 09/29/2014  01:15 PM   309,643 Firebird-Null-Guide.pdf
> 09/29/2014  01:14 PM39,907 Firebird-on-Ubuntu.pdf
> 09/29/2014  01:13 PM56,914 Firebird-shell-scripts.pdf
> 09/29/2014  01:15 PM   109,705 MSSQL-to-Firebird.pdf
> 09/29/2014  01:16 PM   195,585 Using-Firebird_(wip).pdf
>   22 File(s) 43,276,951 bytes
>2 Dir(s)  697,431,232,512 bytes free
> 
> C:\Firebird>gstat 192.168.1.252:/bfl/smtbdb/customer
> 'gstat' is not recognized as an internal or external command,
> operable program or batch file.

gstat is not a separate download but included in your Firebird installation, be 
it in the ZIP distribution or the installer. So, check out the Firebird\bin 
directory.

But this won't help you much, because gstat does not work over a regular 
database connection, but access the database at physical level, so you have to 
run that locally from your Linux machine.


> It has been 20+ years since I have done much with Unix.  If you can tell 
> me the directory Firebird is installed in on Linux, I will run the gstat 
> on the Linux server.  Otherwise, it will take me a while to locate 
> it which I will start now.

Don't know, but I guess fbstat as mentioned in your > 2 years old thread ;-): 
http://comments.gmane.org/gmane.comp.db.firebird.user/7145


Regards,
Thomas


> Thanks,
> Jack
> 
> 
> C:\Firebird>
> 
> On 6/11/2015 9:13 AM, 'Thomas Steinmaurer' t...@iblogmanager.com 
> [firebird-support] wrote:
>>
>>
>> > The databases are backed up between midnight and 6 am when no one is
>> > using them. However, the databases are still open in multiple
>> > programs. The backup is:
>> >
>> > C:\"program files"\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA
>> > -pas masterkey 192.168.1.252:/bfl/smtbdb/customer
>> > C:\backups\Buford\Thursday\customer.bak
>> >
>> > and the restore is:
>> >
>> > C:\"program files"\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA
>> > -pas masterkey C:\backups\Buford\Thursday\customer.bak
>> > localhost:c:\temp\customer
>>
>> What is the result of gstat -h on the production database?
>>
>> Thomas
>>
>> > Jack
>> >
>> >
>> >
>> > On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com
>> > [firebird-support] wrote:
>> >>
>> >>
>> >> > The databases reside on a Linux Mint server, but we back them up to a
>> >> > Windows 7 system. Both are running the same release of Firebird. We
>> >> > use Linux as the server because Linux is far more reliable than 
>> Windows
>> >> > for everything, but it is the only Linux computer we use. Everything
>> >> > else is Windows because of other software we run. So, to back up the
>> >> > databases, we put the backups on a Windows 7 computer, blandly 
>> assuming
>> >> > it is just a file that can be restored by the same program that 
>> backed
>> >> > it up, gbak on Windows 7.
>> >>
>> >> You mean a physical file copy from Linux to Windows while the database
>> >> is in use?
>> >>
>> >> > We had the same problem two years ago, and it never got resolved, it
>> >> > just disappeared, so we assumed we had done something wrong and 
>> were no
>> >> > longer doing whatever that was.
>> >>
>> >> And you don't call a different gbak version by accident, e.g. due to a
>> >> set PATH environment variable etc.?
>> >>
>> >> Regards,
>> >> Thomas
>> >>
>> >> > Jack
>> >> >
>> >> > On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com
>> >> > [firebird-support] wrote:
>> >> >>
>> >> >> Hello,
>> >> >>
>> >> >> > We have backed up our databases daily for two years using
>> >> Firebird 2.52
>> >> >> >

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
Here is the gstat - h:

Database "customer"
Database header page information:
 Flags0
 Checksum12345
 Generation1175184
 Page size4096
 ODS version11.2
 Oldest transaction119622
 Oldest active1072065
 Oldest snapshot1072058
 Next transaction1072195
 Bumped transaction1
 Sequence number0
 Next attachment ID275823
 Implementation ID24
 Shadow count0
 Page buffers0
 Next header page0
 Database dialect3
 Creation dateFeb 19, 2013 0:09:08
 Attributesforce write

 Variable header data:
 Sweep interval:2
 *END*

and here is the gstat everything else:

gstat version LI-V2.5.2.26508 Firebird 2.5

Database "customer"
Database header page information:
 Flags0
 Checksum12345
 Generation1175182
 Page size4096
 ODS version11.2
 Oldest transaction119622
 Oldest active1072065
 Oldest snapshot1072058
 Next transaction1072193
 Bumped transaction1
 Sequence number0
 Next attachment ID275822
 Implementation ID24
 Shadow count0
 Page buffers0
 Next header page0
 Database dialect3
 Creation dateFeb 19, 2013 0:09:08
 Attributesforce write

 Variable header data:
 Sweep interval:2
 *END*


Database file sequence:
File customer is the only file
 Firebird/linux AMD64 (access method), version "LI-V2.5.2.26508 
Firebird 2.5"
 Firebird/linux AMD64 (remote server), version "LI-V2.5.2.26508 
Firebird 2.5/tcp (lserver)/P12"
 Firebird/linux AMD64 (remote interface), version "LI-V2.5.2.26508 
Firebird 2.5/tcp (lserver)/P12"
 on disk structure version 11.2

Analyzing database pages ...
CUSTOMERS (128)
 Primary pointer page: 183, Index root page: 184
 Average record length: 340.17, total records: 70105
 Average version length: 26.60, total versions: 5, max versions: 2
 Data pages: 6626, data page slots: 6646, average fill: 94%
 Fill distribution:
  0 - 19% = 1
 20 - 39% = 8
 40 - 59% = 14
 60 - 79% = 16
 80 - 99% = 6587

 Index FNAME (2)
 Depth: 2, leaf buckets: 135, nodes: 70109
 Average data length: 0.51, total dup: 57228, max dup: 584
 Fill distribution:
  0 - 19% = 0
 20 - 39% = 1
 40 - 59% = 54
 60 - 79% = 40
 80 - 99% = 40

 Index FULLNAME (6)
 Depth: 3, leaf buckets: 330, nodes: 70105
 Average data length: 4.83, total dup: 20467, max dup: 18169
 Fill distribution:
  0 - 19% = 0
 20 - 39% = 133
 40 - 59% = 21
 60 - 79% = 173
 80 - 99% = 3

 Index HOME (3)
 Depth: 2, leaf buckets: 226, nodes: 70108
 Average data length: 2.61, total dup: 9196, max dup: 2392
 Fill distribution:
  0 - 19% = 0
 20 - 39% = 2
 40 - 59% = 101
 60 - 79% = 86
 80 - 99% = 37

 Index LNAME (0)
 Depth: 2, leaf buckets: 154, nodes: 70117
 Average data length: 1.08, total dup: 46986, max dup: 758
 Fill distribution:
  0 - 19% = 1
 20 - 39% = 1
 40 - 59% = 74
 60 - 79% = 15
 80 - 99% = 63

 Index NEWID (4)
 Depth: 2, leaf buckets: 121, nodes: 70105
 Average data length: 1.04, total dup: 2, max dup: 1
 Fill distribution:
  0 - 19% = 0
 20 - 39% = 0
 40 - 59% = 30
 60 - 79% = 13
 80 - 99% = 78

 Index OFFICEPHONE (5)
 Depth: 2, leaf buckets: 102, nodes: 70105
 Average data length: 0.20, total dup: 67213, max dup: 38383
 Fill distribution:
  0 - 19% = 0
 20 - 39% = 1
 40 - 59% = 32
 60 - 79% = 17
 80 - 99% = 52

 Index RDB$PRIMARY7 (1)
 Depth: 3, leaf buckets: 346, nodes: 70117
 Average data length: 7.64, total dup: 11, max dup: 3
 Fill distribution:
  0 - 19% = 0
 20 - 39% = 9
 40 - 59% = 171
 60 - 79% = 16
 80 - 99% = 150

INVOICES (132)
 Primary pointer page: 191, Index root page: 192
 Average record length: 27.41, total records: 27
 Average version length: 0.00, total versions: 0, max versions: 0
 Data pages: 2, data page slots: 19, average fill: 16%
 Fill distribution:
  0 - 19% = 1
 20 - 39% = 1
 40 - 59% = 0
 60 - 79% = 0
 80 - 99% = 0

 Index RDB$PRIMARY11 (0)
 Depth: 2, leaf buckets: 1, nodes: 27
 Average data length: 8.56, total dup: 0, max dup: 0
 Fill distribution:
  0 - 19% = 1
 20 - 39% = 0
 40 - 59% = 0
 60 - 79% = 0
 80 - 99% = 0

ON_ORDER (133)
 Primary pointer page: 194, Index root page: 195
 Average record length: 510.49, total records: 503
 Average version le

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread liviusliv...@poczta.onet.pl [firebird-support] 
Hi,

you tried “also” 3.0 or only 3.0?
If only then try 2.5.5 snapshot
but error is about c++ configuration
http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef

but first try different think.
Extract all files to different folder then your Firebird installation not only 
gbak.exe.
Try to run gbak from there. – i suppose that icu or something else is different 
if you only copy gbak.exe

regards,
Karol Bieniaszewski

From: mailto:firebird-support@yahoogroups.com 
Sent: Thursday, June 11, 2015 8:03 PM
To: firebird-support@yahoogroups.com 
Subject: Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - 
error trigger (3)

  
Got it.  Here is what I got when I tried to execute it:

C:\backups\Buford>gbak -b -v -user SYSDBA -pas masterkey 192.168.1.252:/bfl/smtb
db/customer customer.bak
The application has failed to start because its side-by-side configuration is in
correct. Please see the application event log or use the command-line sxstrace.e
xe tool for more detail.

What am I missing?

I tried for 3.0, but it would not even run... likely because it needs the 3.0 
server running.

Jack



On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:


  Hi,

  no i mean go to
  http://www.firebirdsql.org/en/snapshot-builds/
  download e.g. Windows build
  Firebird-2.5.5.26887
  unzip it and get gbak.exe
  and do backup and restore with it

  regards,
  Karol Bieniaszewski

  
Could not find gback file, but attached is a snapshot of the bin 
directory for our download. Is that what you needed?

Jack

On 6/11/2015 11:35 AM, 'liviusliv...@poczta.onet.pl' 
liviusliv...@poczta.onet.pl [firebird-support] wrote:
>
> Hi,
>
> Maybe another wrong direction,
> But download snapshot build of FB2.5
> And extract from there gback file. Do backup with them and try to restore
>
> Regards,
> Karol Bieniaszewski




-- 
"Our Constitution was made only for a moral and religious people. It is wholly 
inadequate to the government of any other." -- John Adams, Oct. 11, 1798 "Where 
there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
I also tried 3.0 and it did not work.   However, using your suggestion 
of unzipping everything, 2.55 did run and backed up the database.  It 
did not restore the database, however, and got the same error 'filter (3)'.


Jack

On 6/11/2015 3:08 PM, liviusliv...@poczta.onet.pl [firebird-support] wrote:


Hi,
you tried “also” 3.0 or only 3.0?
If only then try 2.5.5 snapshot
but error is about c++ configuration
http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef
but first try different think.
Extract all files to different folder then your Firebird installation 
not only gbak.exe.
Try to run gbak from there. – i suppose that icu or something else is 
different if you only copy gbak.exe

regards,
Karol Bieniaszewski
*From:* mailto:firebird-support@yahoogroups.com
*Sent:* Thursday, June 11, 2015 8:03 PM
*To:* firebird-support@yahoogroups.com 

*Subject:* Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do 
a restore - error trigger (3)


Got it.  Here is what I got when I tried to execute it:

C:\backups\Buford>gbak -b -v -user SYSDBA -pas masterkey 
192.168.1.252:/bfl/smtb

db/customer customer.bak
The application has failed to start because its side-by-side 
configuration is in
correct. Please see the application event log or use the command-line 
sxstrace.e

xe tool for more detail.

What am I missing?

I tried for 3.0, but it would not even run... likely because it needs 
the 3.0 server running.


Jack

On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:

Hi,
no i mean go to
http://www.firebirdsql.org/en/snapshot-builds/
download e.g. Windows build
Firebird-2.5.5.26887
unzip it and get gbak.exe
and do backup and restore with it
regards,
Karol Bieniaszewski

Could not find gback file, but attached is a snapshot of the bin
directory for our download. Is that what you needed?

Jack

On 6/11/2015 11:35 AM, 'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support] wrote:
>
> Hi,
>
> Maybe another wrong direction,
> But download snapshot build of FB2.5
> And extract from there gback file. Do backup with them and try
to restore
>
> Regards,
> Karol Bieniaszewski



--
"Our Constitution was made only for a moral and religious people. It 
is wholly inadequate to the government of any other." -- John Adams, 
Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18




--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
Why is everyone else not having this problem?  The databases are 
Firebird databases.  For 15 years we had no corruption from Interbase 
6.  Two years ago, we backed up our databases with Interbase 6 gbak and 
then used Firebird 2.52 to restore them.


Firebird 2.52 will back them up, but will not restore them without 
getting the "trigger (3)" error.  Since we have 5 databases, each built 
by Firebird two years ago from Interbase 6 backups and backed up for two 
years by Firebird 2.52 gbak, and totally different programs accessing 
the databases, it appears the corruption is/has been caused by Firebird.


Yet, no one else has seen this problem?

Jack









On 6/11/2015 3:08 PM, liviusliv...@poczta.onet.pl [firebird-support] wrote:


Hi,
you tried “also” 3.0 or only 3.0?
If only then try 2.5.5 snapshot
but error is about c++ configuration
http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef
but first try different think.
Extract all files to different folder then your Firebird installation 
not only gbak.exe.
Try to run gbak from there. – i suppose that icu or something else is 
different if you only copy gbak.exe

regards,
Karol Bieniaszewski
*From:* mailto:firebird-support@yahoogroups.com
*Sent:* Thursday, June 11, 2015 8:03 PM
*To:* firebird-support@yahoogroups.com 

*Subject:* Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do 
a restore - error trigger (3)


Got it.  Here is what I got when I tried to execute it:

C:\backups\Buford>gbak -b -v -user SYSDBA -pas masterkey 
192.168.1.252:/bfl/smtb

db/customer customer.bak
The application has failed to start because its side-by-side 
configuration is in
correct. Please see the application event log or use the command-line 
sxstrace.e

xe tool for more detail.

What am I missing?

I tried for 3.0, but it would not even run... likely because it needs 
the 3.0 server running.


Jack

On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:

Hi,
no i mean go to
http://www.firebirdsql.org/en/snapshot-builds/
download e.g. Windows build
Firebird-2.5.5.26887
unzip it and get gbak.exe
and do backup and restore with it
regards,
Karol Bieniaszewski

Could not find gback file, but attached is a snapshot of the bin
directory for our download. Is that what you needed?

Jack

On 6/11/2015 11:35 AM, 'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support] wrote:
>
> Hi,
>
> Maybe another wrong direction,
> But download snapshot build of FB2.5
> And extract from there gback file. Do backup with them and try
to restore
>
> Regards,
> Karol Bieniaszewski



--
"Our Constitution was made only for a moral and religious people. It 
is wholly inadequate to the government of any other." -- John Adams, 
Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18




--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] 
IMHO you have a corrupted database. You must use gfix to correct it 
(google it) and then your backup/restore cycle will be completed with no 
errors.


On 11/06/2015 17:33, Jack Mason jackma...@mindspring.com 
[firebird-support] wrote:


Why is everyone else not having this problem?  The databases are 
Firebird databases.  For 15 years we had no corruption from Interbase 
6.  Two years ago, we backed up our databases with Interbase 6 gbak 
and then used Firebird 2.52 to restore them.


Firebird 2.52 will back them up, but will not restore them without 
getting the "trigger (3)" error.  Since we have 5 databases, each 
built by Firebird two years ago from Interbase 6 backups and backed up 
for two years by Firebird 2.52 gbak, and totally different programs 
accessing the databases, it appears the corruption is/has been caused 
by Firebird.


Yet, no one else has seen this problem?

Jack









On 6/11/2015 3:08 PM, liviusliv...@poczta.onet.pl [firebird-support] 
wrote:


Hi,
you tried “also” 3.0 or only 3.0?
If only then try 2.5.5 snapshot
but error is about c++ configuration
http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef
but first try different think.
Extract all files to different folder then your Firebird installation 
not only gbak.exe.
Try to run gbak from there. – i suppose that icu or something else is 
different if you only copy gbak.exe

regards,
Karol Bieniaszewski
*From:* mailto:firebird-support@yahoogroups.com
*Sent:* Thursday, June 11, 2015 8:03 PM
*To:* firebird-support@yahoogroups.com 

*Subject:* Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do 
a restore - error trigger (3)


Got it.  Here is what I got when I tried to execute it:

C:\backups\Buford>gbak -b -v -user SYSDBA -pas masterkey 
192.168.1.252:/bfl/smtb

db/customer customer.bak
The application has failed to start because its side-by-side 
configuration is in
correct. Please see the application event log or use the command-line 
sxstrace.e

xe tool for more detail.

What am I missing?

I tried for 3.0, but it would not even run... likely because it needs 
the 3.0 server running.


Jack

On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support] wrote:

Hi,
no i mean go to
http://www.firebirdsql.org/en/snapshot-builds/
download e.g. Windows build
Firebird-2.5.5.26887
unzip it and get gbak.exe
and do backup and restore with it
regards,
Karol Bieniaszewski

Could not find gback file, but attached is a snapshot of the bin
directory for our download. Is that what you needed?

Jack

On 6/11/2015 11:35 AM, 'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support] wrote:
>
> Hi,
>
> Maybe another wrong direction,
> But download snapshot build of FB2.5
> And extract from there gback file. Do backup with them and try
to restore
>
> Regards,
> Karol Bieniaszewski



--
"Our Constitution was made only for a moral and religious people. It 
is wholly inadequate to the government of any other." -- John Adams, 
Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18


--
"Our Constitution was made only for a moral and religious people. It 
is wholly inadequate to the government of any other." -- John Adams, 
Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support] 

Hello Jack,



Why is everyone else not having this problem?  The databases are 
Firebird databases.  For 15 years we had no corruption from Interbase 
6.  Two years ago, we backed up our databases with Interbase 6 gbak 
and then used Firebird 2.52 to restore them.




It can be an answer - when you perform backup/restore, complied codes of 
stored procedures, triggers, checks, etc are not upgraded to the new BLR 
version, so you still have old BLR (in IB6 format) inside. However, any 
change in source code will lead re-complication of the database object, 
and it can fail (for number of reasons, like ambiguous fields 
references) - and at restore step this will be revealed and various 
problems can occur.




Firebird 2.52 will back them up, but will not restore them without 
getting the "trigger (3)" error.  Since we have 5 databases, each 
built by Firebird two years ago from Interbase 6 backups and backed up 
for two years by Firebird 2.52 gbak, and totally different programs 
accessing the databases, it appears the corruption is/has been caused 
by Firebird.





Well, your problem does not look like something very simple. I think you 
should think about proper migration procedure (to make database 100% 
compatible with Firebird 2.5).


Regards,
Alexey Kovyazin
IBSurgeon

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
We do not have ANY stored procedures, triggers, checks, etc.  We are not 
smart enough to use them and they seemed risky because we would not be 
able to see them when we modified/upgraded our software.  We simply 
read/write/add/subtract records from the databases.


We were told that backing up with Interbase gbak and restoring with 
Firebird gbak was the proper migration procedure, but that is apparently 
not true?


Jack

On 6/11/2015 4:50 PM, Alexey Kovyazin a...@ib-aid.com [firebird-support] 
wrote:


Hello Jack,



Why is everyone else not having this problem?  The databases are 
Firebird databases.  For 15 years we had no corruption from Interbase 
6.  Two years ago, we backed up our databases with Interbase 6 gbak 
and then used Firebird 2.52 to restore them.




It can be an answer - when you perform backup/restore, complied codes 
of stored procedures, triggers, checks, etc are not upgraded to the 
new BLR version, so you still have old BLR (in IB6 format) inside. 
However, any change in source code will lead re-complication of the 
database object, and it can fail (for number of reasons, like 
ambiguous fields references) - and at restore step this will be 
revealed and various problems can occur.




Firebird 2.52 will back them up, but will not restore them without 
getting the "trigger (3)" error.  Since we have 5 databases, each 
built by Firebird two years ago from Interbase 6 backups and backed 
up for two years by Firebird 2.52 gbak, and totally different 
programs accessing the databases, it appears the corruption is/has 
been caused by Firebird.





Well, your problem does not look like something very simple. I think 
you should think about proper migration procedure (to make database 
100% compatible with Firebird 2.5).


Regards,
Alexey Kovyazin
IBSurgeon









--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jesus Garcia jeg...@gmail.com [firebird-support] 
Hello jack, may be you have a problem with the metadata of your database, that 
were compatible with interbase 6 but not with firebird. Firebird is more strict 
than Interbase was. I had problem in the past backing up interbase 5.6 and 
restoring in firebird.

The problem was solved, extracting metadata source and creating the database in 
firebird from metadata source. In that process I found some problems that let 
me correct the source database.

I think that you would try to extract metadata source, create the database in 
firebird from that source, and then pump data from source to destination 
database.

If I were you, I would have done this when moving from Interbase 6 to Firebird. 
I did it and have not had problems.

In the process of database creation in Firebird from metadata, may be you will 
find the problem in your source database.

Good luck

Jesus Angel Garcia Zarco
Cointec

>

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
Thanks.  I appreciate your feedback.  That appears to be what I will 
need to do.


Jack

On 6/11/2015 5:45 PM, Jesus Garcia jeg...@gmail.com [firebird-support] 
wrote:
Hello jack, may be you have a problem with the metadata of your 
database, that were compatible with interbase 6 but not with firebird. 
Firebird is more strict than Interbase was. I had problem in the past 
backing up interbase 5.6 and restoring in firebird.


The problem was solved, extracting metadata source and creating the 
database in firebird from metadata source. In that process I found 
some problems that let me correct the source database.


I think that you would try to extract metadata source, create the 
database in firebird from that source, and then pump data from source 
to destination database.


If I were you, I would have done this when moving from Interbase 6 to 
Firebird. I did it and have not had problems.


In the process of database creation in Firebird from metadata, may be 
you will find the problem in your source database.


Good luck

Jesus Angel Garcia Zarco
Cointec

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Helen Borrie hele...@iinet.net.au [firebird-support] 
At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com 
[firebird-support] wrote:

>We were told that backing up with Interbase gbak and restoring with Firebird 
>gbak was the proper migration procedure, but that is apparently not true?

That was true way back at Firebird 1.0 and (marginally but not advisedly) 
at Firebird 1.5.  We are talking 15 years of Firebird development here, 5 major 
releases and thus, 5 ODS changes, to arrive at 2.5.something.

Helen

RE: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] 
Unlike Vlad, Helen and Thomas, I know next to nothing about problems like yours 
(I'm good at SELECTs, which is way different from corrupted backups). Hence, 
listen more to them than to me.

>gbak:restoring privilege for user SYSDBA
>gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
>gbak: ERROR:table/procedure has non-SQL security class defined
>gbak:Exiting before completion due to errors

I read this as attempting to grant SYSDBA something that is impossible. E.g. it 
wouldn't surprise me if InterBase 6 allowed you to grant EXECUTE to a table 
(EXECUTE only makes sense to grant to a procedure), and that Firebird barks 
since is stricter regarding syntax than IB 6 was. 

Now, I don't know how to restore a database without grants specified to the 
table (others may know), but I'd recommend you to try restoring using the -o 
switch (one table at a time), possibly also using the -i (set indexes inactive) 
and -n (check constraints disabled) switches.

But as I said, this is rambling and guesswork, as opposed to Vlad's, Helen's 
and Thomas' knowhow.

Set

PS! Firebird 2.5 is a considerably better database than InterBase 6.0 was 
(although 2.5.1 had a flaw that almost required backup/restore when upgrading 
to 2.5.2 or higher)

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
Ah...  thanks for that info.   So, export all the data and rebuild 
from scratch is the way to go?


Jack

On 6/12/2015 12:56 AM, Helen Borrie hele...@iinet.net.au 
[firebird-support] wrote:


At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com 
[firebird-support] wrote:


>We were told that backing up with Interbase gbak and restoring with 
Firebird gbak was the proper migration procedure, but that is 
apparently not true?


That was true way back at Firebird 1.0 and (marginally but not 
advisedly) at Firebird 1.5. We are talking 15 years of Firebird 
development here, 5 major releases and thus, 5 ODS changes, to arrive 
at 2.5.something.


Helen




--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] 
No: generate database DML scripts, create new database using these scripts and 
use a database pump utility to copy data from the old to the new. No need to 
start from scratch.
Mark

- Reply message -
Van: "Jack Mason jackma...@mindspring.com [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error 
trigger (3)
Datum: vr, jun. 12, 2015 18:06

Ah...  thanks for that info.   So, export all the data and
rebuild from scratch is the way to go?



Jack



On 6/12/2015 12:56 AM, Helen Borrie
hele...@iinet.net.au [firebird-support] wrote:



 


At 08:57 a.m. 12/06/2015, Jack Mason
jackma...@mindspring.com [firebird-support] wrote:



>We were told that backing up with Interbase gbak and
restoring with Firebird gbak was the proper migration
procedure, but that is apparently not true?



That was true way back at Firebird 1.0 and (marginally
but not advisedly) at Firebird 1.5. We are talking 15
years of Firebird development here, 5 major releases and
thus, 5 ODS changes, to arrive at 2.5.something.



Helen












-- 

"Our Constitution was made only for a moral and religious people.
It is wholly inadequate to the government of any other." -- John
Adams, Oct. 11, 1798
"Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support] 
Thanks.  That sounds much easier and faster than exporting everything, 
which has proven sort of unreliable in the past.  Know where I can find 
a reliable data pump utility?


Jack

On 6/12/2015 12:09 PM, 'Mark Rotteveel' m...@lawinegevaar.nl 
[firebird-support] wrote:


No: generate database DML scripts, create new database using these 
scripts and use a database pump utility to copy data from the old to 
the new. No need to start from scratch.


Mark


- Reply message -
Van: "Jack Mason jackma...@mindspring.com [firebird-support]" 


Aan: 
Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a restore 
- error trigger (3)

Datum: vr, jun. 12, 2015 18:06

Ah...  thanks for that info.   So, export all the data and rebuild 
from scratch is the way to go?


Jack

On 6/12/2015 12:56 AM, Helen Borrie hele...@iinet.net.au 
[firebird-support] wrote:


At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com 
[firebird-support] wrote:


>We were told that backing up with Interbase gbak and restoring with 
Firebird gbak was the proper migration procedure, but that is 
apparently not true?


That was true way back at Firebird 1.0 and (marginally but not 
advisedly) at Firebird 1.5. We are talking 15 years of Firebird 
development here, 5 major releases and thus, 5 ODS changes, to arrive 
at 2.5.something.


Helen



--
"Our Constitution was made only for a moral and religious people. It 
is wholly inadequate to the government of any other." -- John Adams, 
Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18




--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support] 
On 6/11/2015 4:33 PM, Jack Mason jackma...@mindspring.com 
[firebird-support] wrote:


Why is everyone else not having this problem?  The databases are 
Firebird databases.  For 15 years we had no corruption from Interbase 
6.  Two years ago, we backed up our databases with Interbase 6 gbak 
and then used Firebird 2.52 to restore them.


Firebird 2.52 will back them up, but will not restore them without 
getting the "trigger (3)" error.  Since we have 5 databases, each 
built by Firebird two years ago from Interbase 6 backups and backed up 
for two years by Firebird 2.52 gbak, and totally different programs 
accessing the databases, it appears the corruption is/has been caused 
by Firebird.


Yet, no one else has seen this problem?

The problem may be that InterBase 6 and older Firebirds still used some 
non-SQL style grants.  Over time,
Firebird has become fussier about correct syntax and semantics.   If you 
still have an old database, perhaps

you can look at the privileges especially those on system tables.

Good luck,

Ann

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ivan Arabadzhiev intelru...@yahoo.com [firebird-support] 
Last time I used http://fbexport.sourceforge.net/ and it worked like a charm

2015-06-12 19:22 GMT+03:00 Jack Mason jackma...@mindspring.com
[firebird-support] :

>
>
> Thanks.  That sounds much easier and faster than exporting everything,
> which has proven sort of unreliable in the past.  Know where I can find a
> reliable data pump utility?
>
> Jack
>
> On 6/12/2015 12:09 PM, 'Mark Rotteveel' m...@lawinegevaar.nl
> [firebird-support] wrote:
>
>
>
>  No: generate database DML scripts, create new database using these
> scripts and use a database pump utility to copy data from the old to the
> new. No need to start from scratch.
>
>  Mark
>
>
> - Reply message -
> Van: "Jack Mason jackma...@mindspring.com [firebird-support]"
>  
> Aan:  
> Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a restore -
> error trigger (3)
> Datum: vr, jun. 12, 2015 18:06
>
> Ah...  thanks for that info.   So, export all the data and rebuild
> from scratch is the way to go?
>
> Jack
>
> On 6/12/2015 12:56 AM, Helen Borrie hele...@iinet.net.au
> [firebird-support] wrote:
>
>
>
> At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com
> [firebird-support] wrote:
>
> >We were told that backing up with Interbase gbak and restoring with
> Firebird gbak was the proper migration procedure, but that is apparently
> not true?
>
> That was true way back at Firebird 1.0 and (marginally but not
> advisedly) at Firebird 1.5. We are talking 15 years of Firebird development
> here, 5 major releases and thus, 5 ODS changes, to arrive at 2.5.something.
>
> Helen
>
>
> --
> "Our Constitution was made only for a moral and religious people. It is
> wholly inadequate to the government of any other." -- John Adams, Oct. 11,
> 1798 "Where there is no vision, the people perish.." Prov 29:18
>
>
> --
> "Our Constitution was made only for a moral and religious people. It is
> wholly inadequate to the government of any other." -- John Adams, Oct. 11,
> 1798 "Where there is no vision, the people perish.." Prov 29:18
>
>  
>

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support] 

Thanks.  I will try it.

Jack

On 6/12/2015 2:50 PM, Ivan Arabadzhiev intelru...@yahoo.com 
[firebird-support] wrote:
Last time I used http://fbexport.sourceforge.net/ and it worked like a 
charm


2015-06-12 19:22 GMT+03:00 Jack Mason jackma...@mindspring.com 
 [firebird-support] 
>:


Thanks.  That sounds much easier and faster than exporting
everything, which has proven sort of unreliable in the past.  Know
where I can find a reliable data pump utility?

Jack

On 6/12/2015 12:09 PM, 'Mark Rotteveel' m...@lawinegevaar.nl
 [firebird-support] wrote:


No: generate database DML scripts, create new database using
these scripts and use a database pump utility to copy data from
the old to the new. No need to start from scratch.

Mark


- Reply message -
Van: "Jack Mason jackma...@mindspring.com
 [firebird-support]"


Aan: 

Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a
restore - error trigger (3)
Datum: vr, jun. 12, 2015 18:06

Ah...  thanks for that info.   So, export all the data and
rebuild from scratch is the way to go?

Jack

On 6/12/2015 12:56 AM, Helen Borrie hele...@iinet.net.au
 [firebird-support] wrote:


At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com
 [firebird-support] wrote:

>We were told that backing up with Interbase gbak and restoring
with Firebird gbak was the proper migration procedure, but that
is apparently not true?

That was true way back at Firebird 1.0 and (marginally but
not advisedly) at Firebird 1.5. We are talking 15 years of
Firebird development here, 5 major releases and thus, 5 ODS
changes, to arrive at 2.5.something.

Helen



-- 
"Our Constitution was made only for a moral and religious people.

It is wholly inadequate to the government of any other." -- John
Adams, Oct. 11, 1798 "Where there is no vision, the people
perish.." Prov 29:18


-- 
"Our Constitution was made only for a moral and religious people.

It is wholly inadequate to the government of any other." -- John
Adams, Oct. 11, 1798 "Where there is no vision, the people
perish.." Prov 29:18





--
"Our Constitution was made only for a moral and religious people. It is 
wholly inadequate to the government of any other." -- John Adams, Oct. 
11, 1798 "Where there is no vision, the people perish.." Prov 29:18

Re: Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support] 
>>You asked something similar > 2 years ago:
>>http://comments.gmane.org/gmane.comp.db.firebird.user/7145
>>-- 
>>With regards,
>>Thomas Steinmaurer
>>http://www.upscene.com/
 
Sorry for off-top but 
I'am very interested what jack.mason will say about this :
You have my +1 ;-)
 
regards,
Karol Bieniaszewski