|
Home > Archive > SQL Anywhere Mobile > October 2005 > Problem in transactionsl Log File Deletion
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem in transactionsl Log File Deletion
|
|
|
| Hi,
We are currently using the ASA 9.0.1.1899 version. In that
we are using the Synchonization with Oracle.in the DBMLsync.
-x 3m option is used to create the Log files ( Multiple log
files). We want to delete the log files after sync. we keep
the latest created two log files like
Main.Db,Main.Log and 29092005AA.Log,30092005AA.Log,
remaining files are deleting from that folder. even in this
we got the error like "transactional files are missing" for
the OFFSET values checking. is there any specific files will
be checked for the OFFSET Value on the synchronization or
please tell us which file we can delete since it is keep
accumulating the database folder drastically.
Regards,
Bob
| |
| David Fishburn 2005-10-27, 8:20 am |
| Bob wrote in news:43413aff.6680.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
B> We are currently using the ASA 9.0.1.1899 version. In that
B> we are using the Synchonization with Oracle.in the DBMLsync.
B> -x 3m option is used to create the Log files ( Multiple log
B> files). We want to delete the log files after sync. we keep
B> the latest created two log files like
B> Main.Db,Main.Log and 29092005AA.Log,30092005AA.Log,
B> remaining files are deleting from that folder. even in this
B> we got the error like "transactional files are missing" for
B> the OFFSET values checking. is there any specific files will
B> be checked for the OFFSET Value on the synchronization or
B> please tell us which file we can delete since it is keep
B> accumulating the database folder drastically.
Right, that is the _wrong_ way to do it.
This is the right way to do it:
ASA Database Administration Guide
Replicating Data with Replication Server
Using the LTM
Transaction log and backup management
Using the DELETE_OLD_LOGS option
or
SQL Remote User's Guide
Administering SQL Remote for Adaptive Server Anywhere
Transaction log and backup management
Managing old transaction logs
Despite the fact you are using dbmlsync, the option is the same.
This will delete the logs after a successful upload.
Run it a few times in a row to get an idea of when the logs will be
removed.
For example at the remote:
insert
insert
commit
dbmlsync
insert
insert
commit
dbmlsync
insert
insert
commit
dbmlsync
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Breck Carter [TeamSybase] 2005-10-27, 8:20 am |
| In addition to what Dave said might also want to use -x instead of -x
3M, if you want to keep the total disk space used by log files to a
minimum.
Breck
On 3 Oct 2005 07:06:55 -0700, Bob wrote:
>Hi,
>We are currently using the ASA 9.0.1.1899 version. In that
>we are using the Synchonization with Oracle.in the DBMLsync.
>-x 3m option is used to create the Log files ( Multiple log
>files). We want to delete the log files after sync. we keep
>the latest created two log files like
>Main.Db,Main.Log and 29092005AA.Log,30092005AA.Log,
>remaining files are deleting from that folder. even in this
>we got the error like "transactional files are missing" for
>the OFFSET values checking. is there any specific files will
>be checked for the OFFSET Value on the synchronization or
>please tell us which file we can delete since it is keep
>accumulating the database folder drastically.
>Regards,
>Bob
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| hi,
Thanks for the Response.
Already we set that Delete_Old_Log_File option to ON. But it
is not deleting the log files created during the
synchronization. In the Database folder there is around 14
files exists. Then also it says Transaction File missing
Error. In that error Log file name was also mentioned but we
are ablt to see that log file in the same folder.
Same way we are doing the Backup also. if we take that
Backup database and restore it in the some other system, it
is throwing the same error on synchronization. Kindly tell
us the solution to have both Backup and Sync process.
Regards,
Bob
> In addition to what Dave said might also want to use -x
> instead of -x 3M, if you want to keep the total disk space
> used by log files to a minimum.
>
> Breck
>
> On 3 Oct 2005 07:06:55 -0700, Bob wrote:
>
> that >we are using the Synchonization with Oracle.in the
> DBMLsync. >-x 3m option is used to create the Log files (
> Multiple log >files). We want to delete the log files
> after sync. we keep >the latest created two log files like
> this >we got the error like "transactional files are
> missing" for >the OFFSET values checking. is there any
> specific files will >be checked for the OFFSET Value on
> the synchronization or >please tell us which file we can
> delete since it is keep >accumulating the database folder
> drastically. >Regards,
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-10-27, 8:20 am |
| If the delete_old_logs database option ( not Delete_Old_Log_File as you
stated in your post ) is set to ON, then dbmlsync will delete renamed
transaction logs when it is safe to do so. If dbmlsync is NOT deleting old
logs, then it doesn't think it's safe to do so, and you SHOULD NOT be
deleting them yourself, or dbmlsync will report that there are missing logs.
If you post the contents of the following SQL statements, it will tell us
what the minimum log offset that is safe to delete is :
SELECT db_property ( 'LTMTrunc' );
SELECT db_property ( 'RemoteTrunc' );
SELECT db_property ( 'SyncTrunc' );
select * from SYSREMOTEUSERS;
select * from SYSSYNC;
If you could also run dbmlsync with the -v+ switch, and then post the output
to the forum along with the output from the above commands, we'll also
likely be able to tell you why your log files are not being deleted. YOU
SHOULD NOT BE MANUALLY DELETING TRANSACTION LOGS.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
<Bob> wrote in message news:43429fef.45de.1681692777@sybase.com...[color=darkred]
> hi,
> Thanks for the Response.
> Already we set that Delete_Old_Log_File option to ON. But it
> is not deleting the log files created during the
> synchronization. In the Database folder there is around 14
> files exists. Then also it says Transaction File missing
> Error. In that error Log file name was also mentioned but we
> are ablt to see that log file in the same folder.
> Same way we are doing the Backup also. if we take that
> Backup database and restore it in the some other system, it
> is throwing the same error on synchronization. Kindly tell
> us the solution to have both Backup and Sync process.
> Regards,
> Bob
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
| |
|
| Hi,
Thanks for the Response.
Here is the Result for the Details you asked.
Pls clarify what we can do.
db_property('LTMTrun
c')
'1844674407370955161
5'
db_property('RemoteT
runc')
'1844674407370955161
5'
db_property('SyncTru
nc')
'15637529'
select * from SYSREMOTEUSERS; Nothing
select * from SYSSYNC;
sync_id,type,publica
tion_id,progress,sit
e_name,option,server
_connect
,server_conn_type,la
st_download_time,las
t_upload_time,create
d
,log_sent,generation
_number,extended_sta
te
1,'D',,,'EFBdfe154e8
9a2d445aa57c41f53295
5d35#N192PH',,,'TCPI
P'
,,'1900-01-01 00:00:00.000',,,0,''
2,'D',1,15644597,'EF
Bdfe154e89a2d445aa57
c41f532955d35#N192PH
'
,,,,'2005-10-05 11:18:41.000','2005-10-05
11:18:41. 000',592567,15644597
,1,''
3,'D',2,40918062,'EF
Bdfe154e89a2d445aa57
c41f532955d35#N192PH
'
,,,,'2005-10-05 12:14:57.000','2005-10-05
12:14:57. 000',592704,40918062
,1,''
Regards,
Bob
> If the delete_old_logs database option ( not
> Delete_Old_Log_File as you stated in your post ) is set to
> ON, then dbmlsync will delete renamed transaction logs
> when it is safe to do so. If dbmlsync is NOT deleting old
> logs, then it doesn't think it's safe to do so, and you
> SHOULD NOT be deleting them yourself, or dbmlsync will
> report that there are missing logs.
>
> If you post the contents of the following SQL statements,
> it will tell us what the minimum log offset that is safe
> to delete is :
>
> SELECT db_property ( 'LTMTrunc' );
> SELECT db_property ( 'RemoteTrunc' );
> SELECT db_property ( 'SyncTrunc' );
> select * from SYSREMOTEUSERS;
> select * from SYSSYNC;
>
> If you could also run dbmlsync with the -v+ switch, and
> then post the output to the forum along with the output
> from the above commands, we'll also likely be able to tell
> you why your log files are not being deleted. YOU SHOULD
> NOT BE MANUALLY DELETING TRANSACTION LOGS.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> <Bob> wrote in message
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-10-27, 8:20 am |
| Can you also please post the dbmlsync log generated when you run with
the -v+ switch?
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
<Bob> wrote in message news:4343e643.518e.1681692777@sybase.com...[color=darkred]
> Hi,
> Thanks for the Response.
> Here is the Result for the Details you asked.
> Pls clarify what we can do.
> db_property('LTMTrun
c')
> '1844674407370955161
5'
>
> db_property('RemoteT
runc')
> '1844674407370955161
5'
>
> db_property('SyncTru
nc')
> '15637529'
>
> select * from SYSREMOTEUSERS; Nothing
>
>
> select * from SYSSYNC;
>
> sync_id,type,publica
tion_id,progress,sit
e_name,option,server
_connect
> ,server_conn_type,la
st_download_time,las
t_upload_time,create
d
> ,log_sent,generation
_number,extended_sta
te
> 1,'D',,,'EFBdfe154e8
9a2d445aa57c41f53295
5d35#N192PH',,,'TCPI
P'
> ,,'1900-01-01 00:00:00.000',,,0,''
> 2,'D',1,15644597,'EF
Bdfe154e89a2d445aa57
c41f532955d35#N192PH
'
> ,,,,'2005-10-05 11:18:41.000','2005-10-05
> 11:18:41. 000',592567,15644597
,1,''
> 3,'D',2,40918062,'EF
Bdfe154e89a2d445aa57
c41f532955d35#N192PH
'
> ,,,,'2005-10-05 12:14:57.000','2005-10-05
> 12:14:57. 000',592704,40918062
,1,''
>
>
> Regards,
> Bob
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
| |
| David Fishburn 2005-10-27, 8:20 am |
| "Reg Domaratzki \(iAnywhere Solutions\)" <FirstName.LastName@ianywhere.com>
wrote in news:4343f276@forums
-1-dub
of sybase.public.sqlanywhere.mobilink:
RD> Can you also please post the dbmlsync log generated when you run with
RD> the -v+ switch?
And run dbunload against the remote database using -n (no data).
Then open the reload.sql file and look for the Remote Definitions
section.
Include that entire section, including the command line you used to run
dbmlsync.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
|
| Hi,
Thanks for the Response.
Here is the result of that -v+ option in our sync. process.
Now in our client place we got the error like cannot update
the Primary Key column in the Table included in the
subscription.
Suddenly it is coming there. what might be the problem.
Error is :
SQL statement failed: (-780) Cannot update primary key for
table
'EFB_EfbWpi_waypoint
_info' involved in a publication
For this i ask them to set the option
SET OPTION PUBLIC. PREVENT_ARTICLE_PKEY
_UPDATE='OFF';
apart from this any other option is there to set.
I have attached one part of the file with this post next
part i will post in the next post. Pls look in to it and
tell me the suggestion and solution for both the problem.
Regards,
Bob
| |
| David Fishburn 2005-10-27, 8:21 am |
| Bob wrote in news:434ce58f.4db0.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
B> Here is the result of that -v+ option in our sync. process.
B> Now in our client place we got the error like cannot update
B> the Primary Key column in the Table included in the
B> subscription.
B> Suddenly it is coming there. what might be the problem.
B> Error is :
B> SQL statement failed: (-780) Cannot update primary key for
B> table
B> 'EFB_EfbWpi_waypoint
_info' involved in a publication
B> For this i ask them to set the option
B> SET OPTION PUBLIC. PREVENT_ARTICLE_PKEY
_UPDATE='OFF';
B> apart from this any other option is there to set.
B> I have attached one part of the file with this post next
B> part i will post in the next post. Pls look in to it and
B> tell me the suggestion and solution for both the problem.
You have not provided all the information we have asked for. I was
holding off looking for this until you posted it.
Looking at your dbmlsync logs I see a bunch of errors:
E. 10/12 14:08:02. Publications EFBDOC61fc4287cc7440
2da638313e0e5e2d63
and EFBDATA61fc4287cc744
02da638313e0e5e2d63 have a column subset
mismatch on table EFB_EfbAcDtl_aircraf
t_dtl.
E. 10/12 14:08:02. No synchronization can occur until this mismatch is
resolved.
E. 10/12 14:06:18. Message: Expecting 2 columns in cursor, but found 6.
Table Name: EFB_EfbAcDtl_aircraf
t_dtl
If these issues have been resolved, please post new files. Make sure
the files have 1 and only 1 synchronization in them so we know they are
current.
1. dbmlsrv9 ... -v+ -ot ml.txt
2. dbmlsync ... -v+ -e verbose=on -o rem.txt
3. dbunload ... -n remote_schema.txt
In the remote_schema.txt file, I am only interested in the "Remote
Definitions" section, so you can just paste that directly into your
response, instead of posting an attachment.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
|
|
|
|
|