|
Home > Archive > SQL Anywhere Mobile > April 2005 > dbmlsrv9 timeout
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]
|
|
| Breck Carter 2005-04-22, 1:24 pm |
| How do I get the dbmlsrv9.exe 9.0.2.3044 to actually *wait*
for the hour required receive a download acknowledgement
after a long download, rather than "time out" after only 5
minutes?
Note that dbmlsrv9 timed out and rolled back at 12:39:39,
but dbmlsync happily finished the download "successfully" at
13:31:50.
Is there a option I can use, to infuse dbmlsrv9 with
*patience* :)
Breck
=3d=3d=3d=3d=3d dbmlsrv9 9.0.2.3044...
I. 04/22 12:30:22. <thread 1.20>: Working on a request
I. 04/22 12:30:22. <thread 1.20>: ASA synchronization
request from: 4018 (version: UNO340)
I. 04/22 12:30:22. <1.20> [4018]: ODBC isolation set to:
Read Committed
I. 04/22 12:30:22. <1.20> [4018]: COMMIT Transaction:
begin_connection
I. 04/22 12:30:22. <1.20> [4018]: COMMIT Transaction:
begin_synchronizatio
n
I. 04/22 12:30:46. <1.20> [4018]: COMMIT Transaction:
end_upload
I. 04/22 12:30:46. <1.20> [4018]: COMMIT Transaction:
prepare_for_download
I. 04/22 12:30:47. <1.20> [4018]: Sending the download to
the remote database.
W. 04/22 12:30:47. <1.20> [4018]: Warning: [10056] There is
no download data script defined for table:
StationConfiguration
. Synchronization has the risk of
potentially losing download data
W. 04/22 12:30:47. <1.20> [4018]: Warning: [10056] There is
no download data script defined for table:
remote_sync_status. Synchronization has the risk of
potentially losing download data
W. 04/22 12:35:09. <1.20> [4018]: Warning: [10056] There is
no download data script defined for table: OfflineLog.
Synchronization has the risk of potentially losing download
data
W. 04/22 12:35:55. <1.20> [4018]: Warning: [10056] There is
no download data script defined for table:
ordersenderdeposit. Synchronization has the risk of
potentially losing download data
E. 04/22 12:39:39. <1.20> [4018]: Error: Unable to read from
the 'tcpip' network connection. Timed out trying to read 2
bytes.
E. 04/22 12:39:39. <1.20> [4018]: Error: [-10034] No
download confirmation from remote database
I. 04/22 12:39:39. <1.20> [4018]: ROLLBACK Transaction:
end_download
I. 04/22 12:39:39. <1.20> [4018]: ROLLBACK Transaction:
end_synchronization
E. 04/22 12:39:39. <1.20> [4018]: Error: This connection
will be abandoned due to previous errors
I. 04/22 12:39:39. <1.20> [4018]: COMMIT Transaction:
end_connection
I. 04/22 12:39:39. <1.20> [4018]: Disconnected from
consolidated database
I. 04/22 12:39:39. <1.20> [4018]: Synchronization failed
=3d=3d=3d=3d=3d dbmlsync 8.0.2.4424...
I. 04/22 12:30:22. Synchronization Started
I. 04/22 12:30:22. Adaptive Server Anywhere MobiLink
Synchronization
Version 8.0.2.4424
I. 04/22 12:30:22.
I. 04/22 12:30:22. Copyright =a9 1989-2002 Sybase, Inc.
Portions Copyright =a9 2002, iAnywhere Solutions, Inc.
I. 04/22 12:30:22. All rights reserved. All unpublished
rights reserved.
I. 04/22 12:30:22.
I. 04/22 12:30:22. This software contains confidential and
trade secret
information of
I. 04/22 12:30:22. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 04/22 12:30:22. by the U.S. Government is subject to
restrictions set
forth in a license
I. 04/22 12:30:22. agreement between the Government and
iAnywhere
Solutions, Inc. or
I. 04/22 12:30:22. other written agreement specifying the
Government's
rights to use the
I. 04/22 12:30:22. software and any applicable FAR
provisions, for example,
FAR 52.227-19.
I. 04/22 12:30:22.
I. 04/22 12:30:22. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/22 12:30:22.
I. 04/22 12:30:22. Connecting to remote database
I. 04/22 12:30:22. Loading synchronization information
I. 04/22 12:30:22. Begin synchronizing 'Uno' for MobiLink
user '4018'
I. 04/22 12:30:22. Log scan starting at offset 0000692633
I. 04/22 12:30:22. Processing transaction logs from
directory "C:\UNOFTO\"
I. 04/22 12:30:22. Processing transactions from active
transaction log
I. 04/22 12:30:22. Hovering at end of active log
I. 04/22 12:30:22. Connecting to MobiLink server at
'host=3d10.1.1.67;port=3d2439' using 'dbsock8.dll'
I. 04/22 12:30:22. Uploading header
I. 04/22 12:30:22. Begin upload
I. 04/22 12:30:22. Uploading table operations
I. 04/22 12:30:22. Upload ended at offset 0000695303
I. 04/22 12:30:22. Waiting for MobiLink to apply upload
I. 04/22 12:37:39. Download stream: received 250664848 bytes
from MobiLink
server.
I. 04/22 12:37:39. The user authentication value is 1000.
I. 04/22 12:37:39. Processing download stream ...
I. 04/22 12:37:39. Downloading into table:
offline_parameters
I. 04/22 12:37:39. Downloading into table: UPG_Control
I. 04/22 12:37:39. Downloading into table: UPG_File
I. 04/22 12:37:39. Downloading into table:
StationConfiguration
I. 04/22 12:37:39. Downloading into table: report_list
I. 04/22 12:37:39. Downloading into table:
remote_sync_status
I. 04/22 12:37:39. Downloading into table: Language
I. 04/22 12:37:39. Downloading into table: remote_sync_error
I. 04/22 12:37:39. 36 delete operations downloaded for table
"remote_sync_error" were for rows not found in the remote
database.
I. 04/22 12:37:39. Downloading into table: runningbalance
I. 04/22 12:44:06. Downloading into table: remote_users
I. 04/22 12:44:06. Downloading into table: UnoMessages
I. 04/22 12:44:06. Downloading into table: SystemMessages
I. 04/22 12:44:06. Downloading into table: Representative
I. 04/22 12:44:07. Downloading into table: RepSenderCliFees
I. 04/22 12:44:07. Downloading into table: OrderStatus
I. 04/22 12:44:07. Downloading into table:
OrderReceiptLabels
I. 04/22 12:44:07. Downloading into table: OfflineLog
I. 04/22 12:44:07. Downloading into table:
IdentificationType
I. 04/22 12:44:07. Downloading into table: FamilyRelation
I. 04/22 12:44:07. Downloading into table: Currency
I. 04/22 12:44:07. Downloading into table: Country
I. 04/22 12:44:07. Downloading into table: ConfirmPayFlag
I. 04/22 12:44:07. Downloading into table: RepBranch
I. 04/22 12:44:09. Downloading into table: Translation
I. 04/22 12:44:12. Downloading into table: VendOrderNumbPool
I. 04/22 12:44:12. Downloading into table: State
I. 04/22 12:44:12. Downloading into table: RepPayerFees
I. 04/22 12:44:13. Downloading into table: PinNumberPool
I. 04/22 12:44:13. Downloading into table:
LocalConfiguration
I. 04/22 12:44:13. Downloading into table: FolioNumberPool
I. 04/22 12:44:13. Downloading into table: ClientXRep
I. 04/22 12:44:27. Downloading into table: Client
I. 04/22 12:45:14. Downloading into table: City
I. 04/22 12:45:17. Downloading into table: Bank
I. 04/22 12:45:17. Downloading into table:
ordersenderdeposit
I. 04/22 12:45:17. Downloading into table: Orders
I. 04/22 13:28:55. Downloading into table: ClientPhone
I. 04/22 13:29:19. Downloading into table:
ClientIdentification
I. 04/22 13:29:39. Downloading into table: ClientBank
I. 04/22 13:29:57. Downloading into table: BankBranch
I. 04/22 13:30:00. Resolving referential integrity
violations on table
RepPayerFees, role FK_REPPAYER_REFERENC
E_REPRESEN
I. 04/22 13:30:00. delete from "uno"."RepPayerFees" from
"uno"."RepPayerFees" ft where not exists ( select 1 from
"uno"."Representative" pt where ( ft."RepCode" =3d
pt."RepCode" ) ) and
( ft."RepCode" is not null )
I. 04/22 13:30:00. 3 rows deleted.
I. 04/22 13:30:00. Resolving referential integrity
violations on table
Orders, role FK_ORDERS_CLIENT_OR_
CLIENT
I. 04/22 13:30:00. delete from "uno"."Orders" from
"uno"."Orders" ft where
not exists ( select 1 from "uno"."Client" pt where (
ft."BenefClientCode"
=3d pt."ClientCode" ) ) and ( ft."BenefClientCode" is not
null )
I. 04/22 13:30:43. 463 rows deleted.
I. 04/22 13:30:43. Resolving referential integrity
violations on table
Orders, role FK_ORDERS_REFERENCE_
CLIENT
I. 04/22 13:30:43. delete from "uno"."Orders" from
"uno"."Orders" ft where
not exists ( select 1 from "uno"."Client" pt where (
ft."SenderClientCode"
=3d pt."ClientCode" ) ) and ( ft."SenderClientCode" is not
null )
I. 04/22 13:31:21. 413 rows deleted.
I. 04/22 13:31:49. COMMIT
I. 04/22 13:31:49. Completed processing of download stream
I. 04/22 13:31:49. Sending an acknowledgment to the MobiLink
server.
I. 04/22 13:31:50. End synchronizing 'Uno' for MobiLink user
'4018'
I. 04/22 13:31:50. Disconnecting from MobiLink server
I. 04/22 13:31:50. Synchronization completed
I. 04/22 13:31:50. Disconnecting from remote database
| |
| Breck Carter 2005-04-22, 8:24 pm |
| Oops, I didn't realize sa=3doff, that explains why dbmlsrv9
is impatient.
HOWEVER, a rerun of the same synchronization, with no
changes to any settings, does not "time out".
The timeout is a serious problem for a large download: it
means the *next* download will send all the same rows
*again* because the last download timestamp is not updated.
Any ideas? Could this be a steeking liveness_timeout issue?
Breck
> How do I get the dbmlsrv9.exe 9.0.2.3044 to actually
> *wait* for the hour required receive a download
> acknowledgement after a long download, rather than "time
> out" after only 5 minutes?
>
> Note that dbmlsrv9 timed out and rolled back at 12:39:39,
> but dbmlsync happily finished the download "successfully"
> at 13:31:50.
>
> Is there a option I can use, to infuse dbmlsrv9 with
> *patience* :)
>
> Breck
>
>
> =3d=3d=3d=3d=3d dbmlsrv9 9.0.2.3044...
>
> I. 04/22 12:30:22. <thread 1.20>: Working on a request
> I. 04/22 12:30:22. <thread 1.20>: ASA synchronization
> request from: 4018 (version: UNO340)
> I. 04/22 12:30:22. <1.20> [4018]: ODBC isolation set to:
> Read Committed
> I. 04/22 12:30:22. <1.20> [4018]: COMMIT Transaction:
> begin_connection
> I. 04/22 12:30:22. <1.20> [4018]: COMMIT Transaction:
> begin_synchronizatio
n
> I. 04/22 12:30:46. <1.20> [4018]: COMMIT Transaction:
> end_upload
> I. 04/22 12:30:46. <1.20> [4018]: COMMIT Transaction:
> prepare_for_download
> I. 04/22 12:30:47. <1.20> [4018]: Sending the download to
> the remote database.
> W. 04/22 12:30:47. <1.20> [4018]: Warning: [10056] There
> is no download data script defined for table:
> StationConfiguration
. Synchronization has the risk of
> potentially losing download data
> W. 04/22 12:30:47. <1.20> [4018]: Warning: [10056] There
> is no download data script defined for table:
> remote_sync_status. Synchronization has the risk of
> potentially losing download data
> W. 04/22 12:35:09. <1.20> [4018]: Warning: [10056] There
> is no download data script defined for table: OfflineLog.
> Synchronization has the risk of potentially losing
> download data
> W. 04/22 12:35:55. <1.20> [4018]: Warning: [10056] There
> is no download data script defined for table:
> ordersenderdeposit. Synchronization has the risk of
> potentially losing download data
> E. 04/22 12:39:39. <1.20> [4018]: Error: Unable to read
> from the 'tcpip' network connection. Timed out trying to
> read 2 bytes.
> E. 04/22 12:39:39. <1.20> [4018]: Error: [-10034] No
> download confirmation from remote database
> I. 04/22 12:39:39. <1.20> [4018]: ROLLBACK Transaction:
> end_download
> I. 04/22 12:39:39. <1.20> [4018]: ROLLBACK Transaction:
> end_synchronization
> E. 04/22 12:39:39. <1.20> [4018]: Error: This connection
> will be abandoned due to previous errors
> I. 04/22 12:39:39. <1.20> [4018]: COMMIT Transaction:
> end_connection
> I. 04/22 12:39:39. <1.20> [4018]: Disconnected from
> consolidated database
> I. 04/22 12:39:39. <1.20> [4018]: Synchronization failed
>
> =3d=3d=3d=3d=3d dbmlsync 8.0.2.4424...
>
> I. 04/22 12:30:22. Synchronization Started
> I. 04/22 12:30:22. Adaptive Server Anywhere MobiLink
> Synchronization
> Version 8.0.2.4424
> I. 04/22 12:30:22.
> I. 04/22 12:30:22. Copyright =a9 1989-2002 Sybase, Inc.
> Portions Copyright =a9 2002, iAnywhere Solutions, Inc.
> I. 04/22 12:30:22. All rights reserved. All unpublished
> rights reserved.
> I. 04/22 12:30:22.
> I. 04/22 12:30:22. This software contains confidential and
> trade secret
> information of
> I. 04/22 12:30:22. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the software and
> documentation
> I. 04/22 12:30:22. by the U.S. Government is subject to
> restrictions set
> forth in a license
> I. 04/22 12:30:22. agreement between the Government and
> iAnywhere
> Solutions, Inc. or
> I. 04/22 12:30:22. other written agreement specifying the
> Government's
> rights to use the
> I. 04/22 12:30:22. software and any applicable FAR
> provisions, for example,
> FAR 52.227-19.
> I. 04/22 12:30:22.
> I. 04/22 12:30:22. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/22 12:30:22.
> I. 04/22 12:30:22. Connecting to remote database
> I. 04/22 12:30:22. Loading synchronization information
> I. 04/22 12:30:22. Begin synchronizing 'Uno' for MobiLink
> user '4018'
> I. 04/22 12:30:22. Log scan starting at offset 0000692633
> I. 04/22 12:30:22. Processing transaction logs from
> directory "C:\UNOFTO\"
> I. 04/22 12:30:22. Processing transactions from active
> transaction log
> I. 04/22 12:30:22. Hovering at end of active log
> I. 04/22 12:30:22. Connecting to MobiLink server at
> 'host=3d10.1.1.67;port=3d2439' using 'dbsock8.dll'
> I. 04/22 12:30:22. Uploading header
> I. 04/22 12:30:22. Begin upload
> I. 04/22 12:30:22. Uploading table operations
> I. 04/22 12:30:22. Upload ended at offset 0000695303
> I. 04/22 12:30:22. Waiting for MobiLink to apply upload
> I. 04/22 12:37:39. Download stream: received 250664848
> bytes from MobiLink
> server.
> I. 04/22 12:37:39. The user authentication value is 1000.
> I. 04/22 12:37:39. Processing download stream ...
> I. 04/22 12:37:39. Downloading into table:
> offline_parameters
> I. 04/22 12:37:39. Downloading into table: UPG_Control
> I. 04/22 12:37:39. Downloading into table: UPG_File
> I. 04/22 12:37:39. Downloading into table:
> StationConfiguration
> I. 04/22 12:37:39. Downloading into table: report_list
> I. 04/22 12:37:39. Downloading into table:
> remote_sync_status
> I. 04/22 12:37:39. Downloading into table: Language
> I. 04/22 12:37:39. Downloading into table:
> remote_sync_error I. 04/22 12:37:39. 36 delete operations
> downloaded for table "remote_sync_error" were for rows not
> found in the remote database.
> I. 04/22 12:37:39. Downloading into table: runningbalance
> I. 04/22 12:44:06. Downloading into table: remote_users
> I. 04/22 12:44:06. Downloading into table: UnoMessages
> I. 04/22 12:44:06. Downloading into table: SystemMessages
> I. 04/22 12:44:06. Downloading into table: Representative
> I. 04/22 12:44:07. Downloading into table:
> RepSenderCliFees I. 04/22 12:44:07. Downloading into
> table: OrderStatus I. 04/22 12:44:07. Downloading into
> table: OrderReceiptLabels
> I. 04/22 12:44:07. Downloading into table: OfflineLog
> I. 04/22 12:44:07. Downloading into table:
> IdentificationType
> I. 04/22 12:44:07. Downloading into table: FamilyRelation
> I. 04/22 12:44:07. Downloading into table: Currency
> I. 04/22 12:44:07. Downloading into table: Country
> I. 04/22 12:44:07. Downloading into table: ConfirmPayFlag
> I. 04/22 12:44:07. Downloading into table: RepBranch
> I. 04/22 12:44:09. Downloading into table: Translation
> I. 04/22 12:44:12. Downloading into table:
> VendOrderNumbPool I. 04/22 12:44:12. Downloading into
> table: State I. 04/22 12:44:12. Downloading into table:
> RepPayerFees I. 04/22 12:44:13. Downloading into table:
> PinNumberPool I. 04/22 12:44:13. Downloading into table:
> LocalConfiguration
> I. 04/22 12:44:13. Downloading into table: FolioNumberPool
> I. 04/22 12:44:13. Downloading into table: ClientXRep
> I. 04/22 12:44:27. Downloading into table: Client
> I. 04/22 12:45:14. Downloading into table: City
> I. 04/22 12:45:17. Downloading into table: Bank
> I. 04/22 12:45:17. Downloading into table:
> ordersenderdeposit
> I. 04/22 12:45:17. Downloading into table: Orders
> I. 04/22 13:28:55. Downloading into table: ClientPhone
> I. 04/22 13:29:19. Downloading into table:
> ClientIdentification
> I. 04/22 13:29:39. Downloading into table: ClientBank
> I. 04/22 13:29:57. Downloading into table: BankBranch
> I. 04/22 13:30:00. Resolving referential integrity
> violations on table
> RepPayerFees, role FK_REPPAYER_REFERENC
E_REPRESEN
> I. 04/22 13:30:00. delete from "uno"."RepPayerFees" from
> "uno"."RepPayerFees" ft where not exists ( select 1 from
> "uno"."Representative" pt where ( ft."RepCode"
> pt."RepCode" ) ) and ( ft."RepCode" is not null )
> I. 04/22 13:30:00. 3 rows deleted.
> I. 04/22 13:30:00. Resolving referential integrity
> violations on table
> Orders, role FK_ORDERS_CLIENT_OR_
CLIENT
> I. 04/22 13:30:00. delete from "uno"."Orders" from
> "uno"."Orders" ft where
> not exists ( select 1 from "uno"."Client" pt where (
> ft."BenefClientCode"
> =3d pt."ClientCode" ) ) and ( ft."BenefClientCode" is not
> null )
> I. 04/22 13:30:43. 463 rows deleted.
> I. 04/22 13:30:43. Resolving referential integrity
> violations on table
> Orders, role FK_ORDERS_REFERENCE_
CLIENT
> I. 04/22 13:30:43. delete from "uno"."Orders" from
> "uno"."Orders" ft where
> not exists ( select 1 from "uno"."Client" pt where (
> ft."SenderClientCode"
> =3d pt."ClientCode" ) ) and ( ft."SenderClientCode" is not
> null )
> I. 04/22 13:31:21. 413 rows deleted.
> I. 04/22 13:31:49. COMMIT
> I. 04/22 13:31:49. Completed processing of download stream
> I. 04/22 13:31:49. Sending an acknowledgment to the
> MobiLink server.
> I. 04/22 13:31:50. End synchronizing 'Uno' for MobiLink
> user '4018'
> I. 04/22 13:31:50. Disconnecting from MobiLink server
> I. 04/22 13:31:50. Synchronization completed
> I. 04/22 13:31:50. Disconnecting from remote database
| |
| Graham Hurst 2005-04-28, 3:26 am |
| > HOWEVER, a rerun of the same synchronization, with no
> changes to any settings, does not "time out".
>
> The timeout is a serious problem for a large download: it
> means the *next* download will send all the same rows
> *again* because the last download timestamp is not updated.
>
> Any ideas? Could this be a steeking liveness_timeout issue?
That's a poor error message for ML to give when download acks are
disabled, since it implies that there is a download acknowledgment.
That error code only happens if MobiLink gets a read error, which could
be from a liveness_timeout or a socket error (i.e. network problem).
Note that a liveness_timeout error should only happen if the connection
was lost. Either way, it seems like you had a network problem. That's
consistent with it working fine the next time you tried it.
You could try setting liveness_timeout=0 to disable it, but I don't
think that was the problem.
Cheers,
Graham
| |
| Graham Hurst 2005-04-28, 3:26 am |
| Are you sure you had sa=off? Russ checked and that error should only
happen if download acks are enabled. If you enable download acks you
ought to disable liveness_timeout (by setting it to 0).
Cheers,
Graham
| |
| Breck Carter [TeamSybase] 2005-04-28, 7:24 am |
| Yes, positive, sa=off.
On 27 Apr 2005 20:47:32 -0700, Graham Hurst
< spam_guard_hurst@ian
ywhere.com> wrote:
>Are you sure you had sa=off? Russ checked and that error should only
>happen if download acks are enabled. If you enable download acks you
>ought to disable liveness_timeout (by setting it to 0).
>
>Cheers,
>
>Graham
--
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
| |
| Graham Hurst 2005-04-28, 11:24 am |
| Where do you specify sa=off (or have you just not specified sa=on)?
Note that it is possible to specify it in several places: publication,
user, subscription, command line, hook (in that order of precedence).
You can use -vo for dbmlsync to show exactly what options it is using.
It sure looks like you have sa=on since the dbmlsync log your posted has
this at the end:
> I. 04/22 13:31:49. Sending an acknowledgment to the
> MobiLink server.
Cheers,
Graham
Breck Carter [TeamSybase] wrote:
> Yes, positive, sa=off.
| |
| Breck Carter 2005-04-28, 1:26 pm |
| The full command line (see below) is stored in the remote
database and used to launch dbmlsync. The sa=OFF has always
been present, and I know this database field is used to
launch dbmlsync because we have to fiddle with the host=
when we move test machines around.
C:\\Program Files\\Sybase\\SQL Anywhere
8\\WIN32\\dbmlsync.exe -c
ENG=Remotesrv;DBN=Re
motedb;UID=UNOREMOTE
DBA;PWD=UNO -dl -n
-k Uno -ot C:\\UNOFTO\\log_dbml
sync.txt -e
adr=host=10.1.1.67;sa=OFF
Did dbmlsync always tell the truth when it issues "Sending
an acknowledgment to the MobiLink server" or did it once
produce that message no matter what? The server is 9.0.2,
but dbmlsync is 8.0.2.4424.
FWIW the timeout symptom is not persistent.
Breck
[color=darkred]
> Where do you specify sa=off (or have you just not
> specified sa=on)? Note that it is possible to specify it
> in several places: publication, user, subscription,
> command line, hook (in that order of precedence).
>
> You can use -vo for dbmlsync to show exactly what options
> it is using.
>
> It sure looks like you have sa=on since the dbmlsync log
> your posted has this at the end:
>
>
> Cheers,
>
> Graham
>
> Breck Carter [TeamSybase] wrote:
| |
| Graham Hurst 2005-04-28, 1:26 pm |
| Can you please add -vo to the dbmlsync command line and report back that
part of the dbmlsync log?
Cheers,
Graham
| |
| Breck Carter 2005-04-28, 8:26 pm |
| Here is the dbmlsync -vo output. I cannot explain why the
message "Sending an acknowledgment to the MobiLink server"
does NOT appear in this output.
You, of course, will claim that sa=3dON was set for the
previous run, but that's just not the case. That option was
not set either on the command line or in the database.
The only other difference, besides the timeout not happening
this time, is that the previous run (see first posting) did
a bunch of "Resolving referential integrity violations".
I willing to blame the occult, if you are :)
Breck
I. 04/28 15:24:10. Synchronization Started
I. 04/28 15:24:10. 1: -c
I. 04/28 15:24:10. 2:
********************
********************
***********
I. 04/28 15:24:10. 3: -n
I. 04/28 15:24:10. 4: Uno
I. 04/28 15:24:10. 5: -vo
I. 04/28 15:24:10. 6: -e
I. 04/28 15:24:10. 7: adr=3dhost=3d10.1.1.67;sa=3dOFF
I. 04/28 15:24:10. Adaptive Server Anywhere MobiLink
Synchronization Version 8.0.2.4424
I. 04/28 15:24:10.
I. 04/28 15:24:10. Copyright =a9 1989-2002 Sybase, Inc.
Portions Copyright =a9 2002, iAnywhere
Solutions, Inc.
I. 04/28 15:24:10. All rights reserved. All unpublished
rights reserved.
I. 04/28 15:24:10.
I. 04/28 15:24:10. This software contains confidential and
trade secret information of
I. 04/28 15:24:10. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/28 15:24:10. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/28 15:24:10. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/28 15:24:10. other written agreement specifying the
Government's rights to use the
I. 04/28 15:24:10. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/28 15:24:10.
I. 04/28 15:24:10. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/28 15:24:10.
I. 04/28 15:24:11. Connecting to remote database
I. 04/28 15:24:11. Loading synchronization information
I. 04/28 15:24:12. Options in database for subscription to
'Uno' for '4018':
I. 04/28 15:24:12.
FireTriggers=3dOFF;M
emory=3d2m;ScriptVer
sion=3dUNO350;SendTr
iggers=3dON;
I. 04/28 15:24:12. Options in database for subscription to
'Uno' for '4018':
I. 04/28 15:24:12.
FireTriggers=3dOFF;M
emory=3d2m;ScriptVer
sion=3dUNO350;SendTr
iggers=3dON;
I. 04/28 15:24:12. Options in database for subscription to
'Uno' for '4018':
I. 04/28 15:24:12.
FireTriggers=3dOFF;M
emory=3d2m;ScriptVer
sion=3dUNO350;SendTr
iggers=3dON;
I. 04/28 15:24:12. Begin synchronizing 'Uno' for MobiLink
user '4018'
I. 04/28 15:24:12. Options for this synchronization:
I. 04/28 15:24:12.
MEM=3d'2m',FT=3d'NO'
,ST=3d'YES',SV=3d'UN
O350',SA=3d'NO',CTP=
3d'TCPIP'
,ADR=3d'host=3d10.1.1.67'
I. 04/28 15:24:14. Log scan starting at offset 0055293419
I. 04/28 15:24:14. Processing transaction logs from
directory "C:\UNOFTO\"
I. 04/28 15:24:18. Processing transactions from active
transaction log
I. 04/28 15:24:18. Hovering at end of active log
I. 04/28 15:24:18. Connecting to MobiLink server at
'host=3d10.1.1.67' using 'dbsock8.dll'
I. 04/28 15:24:18. Uploading header
I. 04/28 15:24:18. Begin upload
I. 04/28 15:24:18. Uploading table operations
I. 04/28 15:24:18. Upload ended at offset 0055424135
I. 04/28 15:24:18. Waiting for MobiLink to apply upload
I. 04/28 15:26:00. Download stream: received 58445 bytes
from MobiLink server.
I. 04/28 15:26:00. The user authentication value is 1000.
I. 04/28 15:26:00. Processing download stream ...
I. 04/28 15:26:00. Downloading into table: XXX
....
I. 04/28 15:26:01. Downloading into table: YYY
I. 04/28 15:26:01. COMMIT
I. 04/28 15:26:01. Completed processing of download stream
I. 04/28 15:26:01. End synchronizing 'Uno' for MobiLink user
'4018'
I. 04/28 15:26:01. Disconnecting from MobiLink server
I. 04/28 15:26:01. Synchronization completed
I. 04/28 15:26:01. Options in database for subscription to
'Uno' for '4018':
I. 04/28 15:26:01.
FireTriggers=3dOFF;M
emory=3d2m;ScriptVer
sion=3dUNO350;SendTr
iggers=3dON;
I. 04/28 15:26:01. Disconnecting from remote database
> Can you please add -vo to the dbmlsync command line and
> report back that part of the dbmlsync log?
>
> Cheers,
>
> Graham
| |
| Graham Hurst 2005-04-29, 9:25 am |
| Note that before version 9, sa=ON was the default, so perhaps that one
time the sync was started with a different command line (maybe by double
clicking the exe).
Why blame the occult when you could blame a user instead? Oh yeah - they
pay the bills! ;-)
Cheers,
Graham
Breck Carter wrote:
> Here is the dbmlsync -vo output. I cannot explain why the
> message "Sending an acknowledgment to the MobiLink server"
> does NOT appear in this output.
>
> You, of course, will claim that sa=ON was set for the
> previous run, but that's just not the case. That option was
> not set either on the command line or in the database.
>
> The only other difference, besides the timeout not happening
> this time, is that the previous run (see first posting) did
> a bunch of "Resolving referential integrity violations".
>
> I willing to blame the occult, if you are :)
>
> Breck
|
|
|
|
|