I have found a lot of TIB_Connection and TIBODatabase with ForcedWrites =
dpbFalse (now changed to "dpbDefault").Thanks so much for the help!!
Il Venerdì 14 Novembre 2014 10:18, "'Thomas Steinmaurer'
[email protected] [firebird-support]" <[email protected]> ha
scritto:
> I have different software connected to db:
> 1. Delphi + IB_Object/IBO2. Web/WCF + NHibernate + Firebird ADO.NET3. Winforms
> + Firebird ADO.NET 4. DB Access (linked to firebird with external table) +
> ODBC
> It is possible that a data connection change write mode?
Yes. In your IBO application, what is the value of TIB_connection.ForcedWrites?
I vaguely remember a bug there in the connection design editor flipping the
property explicitely to False although "Default" is the default and recommended
value for that.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> Il Giovedì 13 Novembre 2014 17:48, "Thomas Steinmaurer [email protected]
> [firebird-support]" <[email protected]> ha scritto:
>
>
> > *UPDATE*
>> I have changed batch, switch -online before change write mode.
>> Actually the batch is:
>> "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE%
>> "%FB_PATH%\GFIX.EXE" -shut full -force 0 -user SYSDBA -password
>> masterkey %DB1% >> %LOG_FILE%
>> "%FB_PATH%\GFIX.EXE" -online normal -user SYSDBA -password masterkey
>> %DB1% >> %LOG_FILE%
>> "%FB_PATH%\GFIX.EXE" -write sync -user SYSDBA -password masterkey %DB1%
>> >> %LOG_FILE%
>> "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE%
>>
>> From log file it's all ok:
>>
>> ######## 2014_11_13 3.30.50,84
>> [...]
>> Next header page 0
>> Database dialect 3
>> Creation date Aug 19, 2014 21:56:08
>> Attributes
>>
>> Variable header data:
>> Sweep interval: 20000
>> *END*
>>
>> <after gfix -write sync>
>> [...]
>> Page buffers 0
>> Next header page 0
>> Database dialect 3
>> Creation date Aug 19, 2014 21:56:08
>> Attributes force write
>>
>> Variable header data:
>> Sweep interval: 20000
>> *END*
>>
>>
>> But actually force write is off:
>>
>> ######## 2014_11_13 10.45.33,75
>> [...]
>> Implementation ID 16
>> Shadow count 0
>> Page buffers 0
>> Next header page 0
>> Database dialect 3
>> Creation date Aug 19, 2014 21:56:08
>> Attributes <<<<<<<<<<<<<<
>>
>> Variable header data:
>> Sweep interval: 20000
>> *END*
>>
>>
>> How is possible? Any idea? Firebird versione is 2.5.3 on Windows
>> Standard Server 2008.
>
> What data access technology are you using?
>
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird
> FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
#yiv5091572647 #yiv5091572647 -- #yiv5091572647ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5091572647
#yiv5091572647ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5091572647
#yiv5091572647ygrp-mkp #yiv5091572647hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5091572647 #yiv5091572647ygrp-mkp #yiv5091572647ads
{margin-bottom:10px;}#yiv5091572647 #yiv5091572647ygrp-mkp .yiv5091572647ad
{padding:0 0;}#yiv5091572647 #yiv5091572647ygrp-mkp .yiv5091572647ad p
{margin:0;}#yiv5091572647 #yiv5091572647ygrp-mkp .yiv5091572647ad a
{color:#0000ff;text-decoration:none;}#yiv5091572647 #yiv5091572647ygrp-sponsor
#yiv5091572647ygrp-lc {font-family:Arial;}#yiv5091572647
#yiv5091572647ygrp-sponsor #yiv5091572647ygrp-lc #yiv5091572647hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5091572647
#yiv5091572647ygrp-sponsor #yiv5091572647ygrp-lc .yiv5091572647ad
{margin-bottom:10px;padding:0 0;}#yiv5091572647 #yiv5091572647actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5091572647
#yiv5091572647activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5091572647
#yiv5091572647activity span {font-weight:700;}#yiv5091572647
#yiv5091572647activity span:first-child
{text-transform:uppercase;}#yiv5091572647 #yiv5091572647activity span a
{color:#5085b6;text-decoration:none;}#yiv5091572647 #yiv5091572647activity span
span {color:#ff7900;}#yiv5091572647 #yiv5091572647activity span
.yiv5091572647underline {text-decoration:underline;}#yiv5091572647
.yiv5091572647attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5091572647 .yiv5091572647attach div a
{text-decoration:none;}#yiv5091572647 .yiv5091572647attach img
{border:none;padding-right:5px;}#yiv5091572647 .yiv5091572647attach label
{display:block;margin-bottom:5px;}#yiv5091572647 .yiv5091572647attach label a
{text-decoration:none;}#yiv5091572647 blockquote {margin:0 0 0
4px;}#yiv5091572647 .yiv5091572647bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5091572647
.yiv5091572647bold a {text-decoration:none;}#yiv5091572647 dd.yiv5091572647last
p a {font-family:Verdana;font-weight:700;}#yiv5091572647 dd.yiv5091572647last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5091572647
dd.yiv5091572647last p span.yiv5091572647yshortcuts
{margin-right:0;}#yiv5091572647 div.yiv5091572647attach-table div div a
{text-decoration:none;}#yiv5091572647 div.yiv5091572647attach-table
{width:400px;}#yiv5091572647 div.yiv5091572647file-title a, #yiv5091572647
div.yiv5091572647file-title a:active, #yiv5091572647
div.yiv5091572647file-title a:hover, #yiv5091572647 div.yiv5091572647file-title
a:visited {text-decoration:none;}#yiv5091572647 div.yiv5091572647photo-title a,
#yiv5091572647 div.yiv5091572647photo-title a:active, #yiv5091572647
div.yiv5091572647photo-title a:hover, #yiv5091572647
div.yiv5091572647photo-title a:visited {text-decoration:none;}#yiv5091572647
div#yiv5091572647ygrp-mlmsg #yiv5091572647ygrp-msg p a
span.yiv5091572647yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5091572647
.yiv5091572647green {color:#628c2a;}#yiv5091572647 .yiv5091572647MsoNormal
{margin:0 0 0 0;}#yiv5091572647 o {font-size:0;}#yiv5091572647
#yiv5091572647photos div {float:left;width:72px;}#yiv5091572647
#yiv5091572647photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5091572647
#yiv5091572647photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5091572647
#yiv5091572647reco-category {font-size:77%;}#yiv5091572647
#yiv5091572647reco-desc {font-size:77%;}#yiv5091572647 .yiv5091572647replbq
{margin:4px;}#yiv5091572647 #yiv5091572647ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5091572647 #yiv5091572647ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5091572647
#yiv5091572647ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5091572647
#yiv5091572647ygrp-mlmsg select, #yiv5091572647 input, #yiv5091572647 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5091572647
#yiv5091572647ygrp-mlmsg pre, #yiv5091572647 code {font:115%
monospace;}#yiv5091572647 #yiv5091572647ygrp-mlmsg *
{line-height:1.22em;}#yiv5091572647 #yiv5091572647ygrp-mlmsg #yiv5091572647logo
{padding-bottom:10px;}#yiv5091572647 #yiv5091572647ygrp-msg p a
{font-family:Verdana;}#yiv5091572647 #yiv5091572647ygrp-msg
p#yiv5091572647attach-count span {color:#1E66AE;font-weight:700;}#yiv5091572647
#yiv5091572647ygrp-reco #yiv5091572647reco-head
{color:#ff7900;font-weight:700;}#yiv5091572647 #yiv5091572647ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5091572647 #yiv5091572647ygrp-sponsor
#yiv5091572647ov li a {font-size:130%;text-decoration:none;}#yiv5091572647
#yiv5091572647ygrp-sponsor #yiv5091572647ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5091572647
#yiv5091572647ygrp-sponsor #yiv5091572647ov ul {margin:0;padding:0 0 0
8px;}#yiv5091572647 #yiv5091572647ygrp-text
{font-family:Georgia;}#yiv5091572647 #yiv5091572647ygrp-text p {margin:0 0 1em
0;}#yiv5091572647 #yiv5091572647ygrp-text tt {font-size:120%;}#yiv5091572647
#yiv5091572647ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5091572647
