SQL Anywhere Mobile - 9.0.2.3044 Savepoint 'it0' not found

Author

9.0.2.3044 Savepoint 'it0' not found

Breck Carter [TeamSybase]

2005-05-16, 11:24 am

This error message does *not* seem to stop MobiLink.

=====
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
savepoint it0
....
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
release savepoint it0
E. 05/16 10:23:34. <1.4> [u1]: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]Savepoint 'it0' not found (ODBC State
= HY000, Native error code = -220)
=====

The full dbmlsrv9 log is below; reproducible scripts available on
request.

Breck

I. 05/16 10:23:07. Adaptive Server Anywhere MobiLink Version
9.0.2.3044
I. 05/16 10:23:07.
I. 05/16 10:23:08. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere
Solutions, Inc.
I. 05/16 10:23:08. All rights reserved. All unpublished rights
reserved.
I. 05/16 10:23:08.
I. 05/16 10:23:08. This software contains confidential and trade
secret information of
I. 05/16 10:23:08. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 05/16 10:23:08. by the U.S. Government is subject to restrictions
set forth in a license
I. 05/16 10:23:08. agreement between the Government and iAnywhere
Solutions, Inc. or
I. 05/16 10:23:08. other written agreement specifying the Government's
rights to use the
I. 05/16 10:23:08. software and any applicable FAR provisions, for
example, FAR 52.227-19.
I. 05/16 10:23:08.
I. 05/16 10:23:08. iAnywhere Solutions, Inc., One Sybase Drive,
Dublin, CA 94568, USA
I. 05/16 10:23:08.
I. 05/16 10:23:08. This product is not licensed.
I. 05/16 10:23:08. <Main>: MobiLink server started
I. 05/16 10:23:08. <Main>: Option 1: -c
I. 05/16 10:23:08. <Main>: Option 2: DSN=cons
I. 05/16 10:23:08. <Main>: Option 3: -v+
I. 05/16 10:23:08. <Main>: Option 4: -zu+
I. 05/16 10:23:08. <Main>: Verbose logging: show row values
I. 05/16 10:23:08. <Main>: Verbose logging: show script names when
invoked
I. 05/16 10:23:08. <Main>: Verbose logging: show script contents when
invoked
I. 05/16 10:23:08. <Main>: Verbose logging: show schema for each table
I. 05/16 10:23:08. <Main>: Verbose logging: show an error when the
first read of a synchronization fails
I. 05/16 10:23:08. <Main>: Verbose logging: show translated SQL for
prepared statements
I. 05/16 10:23:08. <Main>: Verbose logging: show rowcount values
I. 05/16 10:23:08. <Main>: Individual database connections will be
closed after synchronization errors.
I. 05/16 10:23:08. <Main>: BLOB cache size: 524288
I. 05/16 10:23:08. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 05/16 10:23:08. <Main>: Maximum number of database connections: 6
I. 05/16 10:23:08. <Main>: Maximum number of deadlock retries: 10
I. 05/16 10:23:08. <Main>: Timeout for inactive database connections:
60 minutes
I. 05/16 10:23:08. <Main>: Maximum delay between retries after
deadlock: 30 seconds
I. 05/16 10:23:08. <Main>: Rowset size: 10
I. 05/16 10:23:08. <Main>: Upload cache size: 524288 bytes
I. 05/16 10:23:08. <Main>: Download cache memory size: 1048576 bytes
I. 05/16 10:23:08. <Main>: Download cache directory size: 10485760
bytes
I. 05/16 10:23:08. <Main>: Number of worker threads: 5
I. 05/16 10:23:08. <Main>: Maximum number of threads uploading
concurrently: 5
W. 05/16 10:23:08. <Main>: Warning: Unknown users will be added
automatically (when there is no authenticate_user script).
I. 05/16 10:23:08. <Main>: Example scripts will not be automatically
generated for unknown versions.
I. 05/16 10:23:08. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 05/16 10:23:08. <Main>: Stream specifier 1: TCPIP
W. 05/16 10:23:08. <Main>: Warning: [10073] Windows XP Firewall is
enabled, and the MobiLink synchronization server is not in the
exception list. Clients on remote machines may not be able to connect
to this server.
I. 05/16 10:23:08. <Main>: ODBC DBMS Name: Adaptive Server Anywhere
I. 05/16 10:23:08. <Main>: ODBC DBMS Version: 09.00.0002
I. 05/16 10:23:08. <Main>: ODBC DBMS Driver Version: 09.00.0002
I. 05/16 10:23:08. <Main>: ODBC Version supported by the driver: 3.52
I. 05/16 10:23:08. <Main>: Collation sequence of the consolidated
database is 'cp1252'
I. 05/16 10:23:08. <Main>: Translated SQL:
set temporary option chained = 'ON'
I. 05/16 10:23:08. <Main>: ODBC isolation set to: Read Committed
I. 05/16 10:23:08. <Main>: Connected
I. 05/16 10:23:08. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 05/16 10:23:08. <thread 1.1>: Ready to handle requests
I. 05/16 10:23:08. <thread 1.2>: Ready to handle requests
I. 05/16 10:23:08. <thread 1.3>: Ready to handle requests
I. 05/16 10:23:08. <thread 1.5>: Ready to handle requests
I. 05/16 10:23:08. <thread 1.4>: Ready to handle requests
I. 05/16 10:23:13. <thread 1.4>: Working on a request
I. 05/16 10:23:13. <thread 1.4>: Translated SQL:
SELECT last_modified FROM ml_scripts_modified
I. 05/16 10:23:13. <thread 1.4>: ml_scripts_modified last modified at:
2005-05-16 10:22:18.000000
I. 05/16 10:23:13. <thread 1.4>: Translated SQL:
SELECT version_id FROM ml_script_version WHERE name
= ?
I. 05/16 10:23:13. <thread 1.4>: ASA synchronization request from: u1
(version: v1)
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
set temporary option chained = 'ON'
I. 05/16 10:23:13. <1.4> [u1]: ODBC isolation set to: Read Committed
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_connection_script
t1, ml_script t2 WHERE t1.version_id = ? AND
t1.script_id = t2.script_id
I. 05/16 10:23:13. <1.4> [u1]: begin_connection <connection> (no
script)
I. 05/16 10:23:13. <1.4> [u1]: COMMIT Transaction: begin_connection
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 05/16 10:23:13. <1.4> [u1]: User name 'u1' not found in the ml_user
table, inserting a new entry
I. 05/16 10:23:13. <1.4> [u1]: Cached ODBC statement:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT MAX( user_id ) + 1 FROM ml_user
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
INSERT INTO ml_user
(user_id,name,commit
_state,hashed_passwo
rd) VALUES(?,?,?,?)
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT user_id FROM ml_user WHERE name = ?
I. 05/16 10:23:13. <1.4> [u1]: Publication #1: p1, subscription id: 2,
last download time: 1900-01-01 00:00:00.000000
I. 05/16 10:23:13. <1.4> [u1]: Table #1: pku, 3 columns
I. 05/16 10:23:13. <1.4> [u1]: Column #1: integer NOT NULL PRIMARY KEY
I. 05/16 10:23:13. <1.4> [u1]: Column #2: integer NOT NULL PRIMARY KEY
I. 05/16 10:23:13. <1.4> [u1]: Column #3: integer NOT NULL
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT progress FROM ml_subscription WHERE user_id
= ? AND subscription_id = ?
I. 05/16 10:23:13. <1.4> [u1]: Progress offsets for the publications
that are explicitly involved in the current synchronization
I. 05/16 10:23:13. <1.4> [u1]: Subscription id 2: consolidated
progress 0 and remote progress 0
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
INSERT INTO ml_subscription
(user_id,subscriptio
n_id,publication_nam
e,last_download_time
)
VALUES(?,?,?,?)
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT table_id FROM ml_table WHERE name = ?
I. 05/16 10:23:13. <1.4> [u1]: begin_synchronizatio
n <connection>
CALL ml_begin_synchroniza
tion ( ? )
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
CALL ml_begin_synchroniza
tion ( ? )
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_table_script t1, ml_script t2 WHERE t1.table_id = ? AND
t1.version_id = ? AND t1.script_id = t2.script_id
I. 05/16 10:23:13. <1.4> [u1]: begin_synchronizatio
n pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT last_upload_time FROM ml_subscription WHERE
user_id = ? AND subscription_id = ?
I. 05/16 10:23:13. <1.4> [u1]: Last upload time for subscription id 2:
1900-01-01 00:00:00.000000
I. 05/16 10:23:13. <1.4> [u1]: begin_publication <connection> (no
script)
I. 05/16 10:23:13. <1.4> [u1]: COMMIT Transaction:
begin_synchronizatio
n
I. 05/16 10:23:13. <1.4> [u1]: begin_upload <connection> (no script)
I. 05/16 10:23:13. <1.4> [u1]: begin_upload pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: begin_upload_rows pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
savepoint it0
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
release savepoint it0
I. 05/16 10:23:13. <1.4> [u1]: end_upload_rows pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: end_upload pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: end_upload <connection> (no script)
I. 05/16 10:23:13. <1.4> [u1]: # rows uploaded into table pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows inserted into table pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows deleted in table pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows updated into table pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows conflicted in table pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows ignored in table pku : 0
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
UPDATE ml_subscription SET progress = ?,
publication_name = ? WHERE user_id = ? AND subscription_id = ?
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
SELECT NOW(*)
I. 05/16 10:23:13. <1.4> [u1]: Translated SQL:
UPDATE ml_subscription SET last_upload_time = ?
WHERE user_id = ? AND subscription_id = ?
I. 05/16 10:23:13. <1.4> [u1]: COMMIT Transaction: end_upload
I. 05/16 10:23:13. <1.4> [u1]: Cached ODBC statement:
SELECT {FN NOW()}
I. 05/16 10:23:13. <1.4> [u1]: begin_download <connection> (no script)
I. 05/16 10:23:13. <1.4> [u1]: begin_download pku (no script)
W. 05/16 10:23:13. <1.4> [u1]: Warning: [10056] There is no download
data script defined for table: pku. Synchronization has the risk of
potentially losing download data
I. 05/16 10:23:13. <1.4> [u1]: begin_download_delet
es pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: end_download_deletes
pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: begin_download_rows pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: end_download_rows pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: end_download pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: end_download <connection> (no script)
I. 05/16 10:23:13. <1.4> [u1]: # rows downloaded for delete from table
pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows downloaded for insert/update
from table pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows filtered for download from table
pku : 0
I. 05/16 10:23:13. <1.4> [u1]: # rows downloaded to remote from table
pku : 0
I. 05/16 10:23:13. <1.4> [u1]: COMMIT Transaction: end_download
I. 05/16 10:23:13. <1.4> [u1]: Sending the download to the remote
database.
I. 05/16 10:23:13. <1.4> [u1]: Creating download cache file
" C:\DOCUME~1\bcarter\
LOCALS~1\Temp\rd0000
0001"
I. 05/16 10:23:13. <1.4> [u1]: end_publication <connection> (no
script)
I. 05/16 10:23:13. <1.4> [u1]: end_synchronization pku (no script)
I. 05/16 10:23:13. <1.4> [u1]: end_synchronization <connection> (no
script)
I. 05/16 10:23:13. <1.4> [u1]: COMMIT Transaction: end_synchronization
I. 05/16 10:23:13. <1.4> [u1]: Synchronization complete
I. 05/16 10:23:33. <thread 1.4>: Working on a request
I. 05/16 10:23:33. <thread 1.4>: Cached ODBC statement:
SELECT last_modified FROM ml_scripts_modified
I. 05/16 10:23:33. <thread 1.4>: ASA synchronization request from: u1
(version: v1)
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
SELECT user_id FROM ml_user WHERE name = ?
I. 05/16 10:23:34. <1.4> [u1]: Removing download cache file
" C:\DOCUME~1\bcarter\
LOCALS~1\Temp\rd0000
0001"
I. 05/16 10:23:34. <1.4> [u1]: Publication #1: p1, subscription id: 2,
last download time: 2005-05-16 10:23:13.531000
I. 05/16 10:23:34. <1.4> [u1]: Table #1: pku, 3 columns
I. 05/16 10:23:34. <1.4> [u1]: Column #1: integer NOT NULL PRIMARY KEY
I. 05/16 10:23:34. <1.4> [u1]: Column #2: integer NOT NULL PRIMARY KEY
I. 05/16 10:23:34. <1.4> [u1]: Column #3: integer NOT NULL
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
SELECT progress FROM ml_subscription WHERE user_id
= ? AND subscription_id = ?
I. 05/16 10:23:34. <1.4> [u1]: Progress offsets for the publications
that are explicitly involved in the current synchronization
I. 05/16 10:23:34. <1.4> [u1]: Subscription id 2: consolidated
progress 415095 and remote progress 415095
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
UPDATE ml_subscription SET last_download_time = ?,
publication_name = ? WHERE user_id = ? AND subscription_id = ?
I. 05/16 10:23:34. <1.4> [u1]: begin_synchronizatio
n <connection>
CALL ml_begin_synchroniza
tion ( ? )
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
CALL ml_begin_synchroniza
tion ( ? )
I. 05/16 10:23:34. <1.4> [u1]: begin_synchronizatio
n pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
SELECT last_upload_time FROM ml_subscription WHERE
user_id = ? AND subscription_id = ?
I. 05/16 10:23:34. <1.4> [u1]: Last upload time for subscription id 2:
2005-05-16 10:23:13.531000
I. 05/16 10:23:34. <1.4> [u1]: begin_publication <connection> (no
script)
I. 05/16 10:23:34. <1.4> [u1]: COMMIT Transaction:
begin_synchronizatio
n
I. 05/16 10:23:34. <1.4> [u1]: begin_upload <connection> (no script)
I. 05/16 10:23:34. <1.4> [u1]: begin_upload pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: begin_upload_rows pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
savepoint it0
I. 05/16 10:23:34. <1.4> [u1]: The row will be processed as
in-conflict because the consolidated row no longer exists.
I. 05/16 10:23:34. <1.4> [u1]: Updating row (new remote values)
I. 05/16 10:23:34. <1.4> [u1]: 1
I. 05/16 10:23:34. <1.4> [u1]: 1
I. 05/16 10:23:34. <1.4> [u1]: 11
I. 05/16 10:23:34. <1.4> [u1]: upload_new_row_inser
t pku (open for
write):
CALL ml_pku_upload_new_ro
w_insert ( ?, ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
CALL ml_pku_upload_new_ro
w_insert ( ?, ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Updating row (old remote values)
I. 05/16 10:23:34. <1.4> [u1]: 1
I. 05/16 10:23:34. <1.4> [u1]: 1
I. 05/16 10:23:34. <1.4> [u1]: 1
I. 05/16 10:23:34. <1.4> [u1]: upload_old_row_inser
t pku (open for
write):
CALL ml_pku_upload_old_ro
w_insert ( ?, ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
CALL ml_pku_upload_old_ro
w_insert ( ?, ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: resolve_conflict pku
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: The row will be processed as
in-conflict because the consolidated row no longer exists.
I. 05/16 10:23:34. <1.4> [u1]: Updating row (new remote values)
I. 05/16 10:23:34. <1.4> [u1]: 22
I. 05/16 10:23:34. <1.4> [u1]: 22
I. 05/16 10:23:34. <1.4> [u1]: 2
I. 05/16 10:23:34. <1.4> [u1]: Updating row (old remote values)
I. 05/16 10:23:34. <1.4> [u1]: 2
I. 05/16 10:23:34. <1.4> [u1]: 2
I. 05/16 10:23:34. <1.4> [u1]: 2
I. 05/16 10:23:34. <1.4> [u1]: resolve_conflict pku
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: All inserted upload rows for table
'pku' will be processed as in-conflict because there is no
upload_insert script defined for this table.
I. 05/16 10:23:34. <1.4> [u1]: Inserted row:
I. 05/16 10:23:34. <1.4> [u1]: 33
I. 05/16 10:23:34. <1.4> [u1]: 33
I. 05/16 10:23:34. <1.4> [u1]: 3
I. 05/16 10:23:34. <1.4> [u1]: resolve_conflict pku
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Inserted row:
I. 05/16 10:23:34. <1.4> [u1]: 4
I. 05/16 10:23:34. <1.4> [u1]: 4
I. 05/16 10:23:34. <1.4> [u1]: 4
I. 05/16 10:23:34. <1.4> [u1]: resolve_conflict pku
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
CALL ml_pku_resolve_confl
ict ( ?, ? )
I. 05/16 10:23:34. <1.4> [u1]: upload_new_row_inser
t pku (close)
I. 05/16 10:23:34. <1.4> [u1]: upload_old_row_inser
t pku (close)
I. 05/16 10:23:34. <1.4> [u1]: 4 row(s) were processed as in-conflict
in table pku
I. 05/16 10:23:34. <1.4> [u1]: Translated SQL:
release savepoint it0
E. 05/16 10:23:34. <1.4> [u1]: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]Savepoint 'it0' not found (ODBC State
= HY000, Native error code = -220)
I. 05/16 10:23:34. <1.4> [u1]: end_upload_rows pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: end_upload pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: end_upload <connection> (no script)
I. 05/16 10:23:34. <1.4> [u1]: # rows uploaded into table pku : 4
I. 05/16 10:23:34. <1.4> [u1]: # rows inserted into table pku : 0
I. 05/16 10:23:34. <1.4> [u1]: # rows deleted in table pku : 0
I. 05/16 10:23:34. <1.4> [u1]: # rows updated into table pku : 2
I. 05/16 10:23:34. <1.4> [u1]: # rows conflicted in table pku : 4
I. 05/16 10:23:34. <1.4> [u1]: # rows ignored in table pku : 0
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
UPDATE ml_subscription SET progress = ?,
publication_name = ? WHERE user_id = ? AND subscription_id = ?
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
SELECT {FN NOW()}
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
UPDATE ml_subscription SET last_upload_time = ?
WHERE user_id = ? AND subscription_id = ?
I. 05/16 10:23:34. <1.4> [u1]: COMMIT Transaction: end_upload
I. 05/16 10:23:34. <1.4> [u1]: Cached ODBC statement:
SELECT {FN NOW()}
I. 05/16 10:23:34. <1.4> [u1]: begin_download <connection> (no script)
I. 05/16 10:23:34. <1.4> [u1]: begin_download pku (no script)
W. 05/16 10:23:34. <1.4> [u1]: Warning: [10056] There is no download
data script defined for table: pku. Synchronization has the risk of
potentially losing download data
I. 05/16 10:23:34. <1.4> [u1]: begin_download_delet
es pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: end_download_deletes
pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: begin_download_rows pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: end_download_rows pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: end_download pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: end_download <connection> (no script)
I. 05/16 10:23:34. <1.4> [u1]: # rows downloaded for delete from table
pku : 0
I. 05/16 10:23:34. <1.4> [u1]: # rows downloaded for insert/update
from table pku : 0
I. 05/16 10:23:34. <1.4> [u1]: # rows filtered for download from table
pku : 0
I. 05/16 10:23:34. <1.4> [u1]: # rows downloaded to remote from table
pku : 0
I. 05/16 10:23:34. <1.4> [u1]: COMMIT Transaction: end_download
I. 05/16 10:23:34. <1.4> [u1]: Sending the download to the remote
database.
I. 05/16 10:23:34. <1.4> [u1]: Creating download cache file
" C:\DOCUME~1\bcarter\
LOCALS~1\Temp\rd0000
0002"
I. 05/16 10:23:34. <1.4> [u1]: end_publication <connection> (no
script)
I. 05/16 10:23:34. <1.4> [u1]: end_synchronization pku (no script)
I. 05/16 10:23:34. <1.4> [u1]: end_synchronization <connection> (no
script)
I. 05/16 10:23:34. <1.4> [u1]: COMMIT Transaction: end_synchronization
I. 05/16 10:23:34. <1.4> [u1]: Synchronization complete
I. 05/16 10:25:35. <Main>: MobiLink server shutting down
I. 05/16 10:25:35. <Main>: MobiLink server undergoing hard shutdown.
I. 05/16 10:25:35. <Main>: All connections and synchronizations being
terminated.
I. 05/16 10:25:35. <thread 1.5>: Shutting down
I. 05/16 10:25:35. <thread 1.4>: Shutting down
I. 05/16 10:25:35. <thread 1.2>: Shutting down
I. 05/16 10:25:35. <thread 1.3>: Shutting down
I. 05/16 10:25:35. <thread 1.1>: Shutting down
I. 05/16 10:25:36. <Main>: Removing download cache file
" C:\DOCUME~1\bcarter\
LOCALS~1\Temp\rd0000
0002"
I. 05/16 10:25:36. <Main>: end_connection <connection> (no script)
I. 05/16 10:25:36. <Main>: COMMIT Transaction: end_connection
I. 05/16 10:25:36. <Main>: Disconnected from consolidated database
I. 05/16 10:25:36. <Main>: Disconnected
I. 05/16 10:25:36. <Main>: MobiLink server finished

--
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-05-19, 9:23 am

This appears to be a bug. Could you please submit it with the
reproducible steps you mentioned?

Cheers,

Graham

Graham Hurst

2005-05-20, 9:23 am

Hi Breck,

It's not a bug. The stored procedures are doing TRUNCATEs, which
automatically COMMIT, and savepoints are cleared on COMMIT.

Cheers,

Graham

Graham Hurst

2005-05-20, 9:23 am

Oh yeah, if you don't want truncates to commit, then set this database
option:

truncate_with_auto_c
ommit = "off"

Setting that option cleared the error message for the reproducible that
you provided.

Cheers,

Graham

Graham Hurst wrote:

> Hi Breck,
>
> It's not a bug. The stored procedures are doing TRUNCATEs, which
> automatically COMMIT, and savepoints are cleared on COMMIT.
>
> Cheers,
>
> Graham

Breck Carter [TeamSybase]

2005-05-20, 11:24 am

I can't *count* the number of times I've coded "truncate table" in a
MobiLink script only to change it to "delete" later... it's some kind
of personal quirk :)

Thanx!

Breck

On 20 May 2005 06:56:51 -0700, Graham Hurst
< spam_guard_hurst@ian
ywhere.com> wrote:
[color=darkred]
>Oh yeah, if you don't want truncates to commit, then set this database
>option:
>
> truncate_with_auto_
commit = "off"
>
>Setting that option cleared the error message for the reproducible that
>you provided.
>
>Cheers,
>
>Graham
>
>Graham Hurst wrote:
>

--
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

Sponsored Links