|
Home > Archive > SQL Anywhere Mobile > August 2005 > <Background Thread>: Disconnected from consolidated database
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 |
<Background Thread>: Disconnected from consolidated database
|
|
| Breck Carter [TeamSybase] 2005-08-11, 8:25 pm |
| What does this message mean? What does it indicate?
<Background Thread>: Disconnected from consolidated database
Here are two examples, plus by a "normal" server shutdown for
comparison.
Breck
===== Example 1: Apparent server termination and restart; note the
long delay after synch complete.
I. 08/02 15:14:25. <1.4> [19]: Synchronization complete
I. 08/02 15:28:45. <Background Thread>: end_connection <connection>
(no script)
I. 08/02 15:28:45. <Background Thread>: COMMIT Transaction:
end_connection
I. 08/02 15:28:45. <Background Thread>: Disconnected from consolidated
database
I. 08/02 16:14:45. <Background Thread>: end_connection <connection>
(no script)
I. 08/02 16:14:45. <Background Thread>: COMMIT Transaction:
end_connection
I. 08/02 16:14:45. <Background Thread>: Disconnected from consolidated
database
I. 08/03 10:03:46. Adaptive Server Anywhere MobiLink Version
9.0.2.3124
=====
===== Example 2: In the middle of things; note the long delay in
processing on thread 1.4.
I. 08/03 11:00:55. <1.4> [43]: Cached ODBC statement:
SELECT user_id FROM ml_user WHERE name = ?
I. 08/03 11:08:47. <Background Thread>: end_connection <connection>
(no script)
I. 08/03 11:08:47. <Background Thread>: COMMIT Transaction:
end_connection
I. 08/03 11:08:47. <Background Thread>: Disconnected from consolidated
database
I. 08/03 11:09:33. <1.4> [43]: modify_user <connection>
=====
===== A "normal" MobiLink server shutdown.
I. 07/25 13:52:24. <1.5> [2]: Synchronization complete
I. 07/25 14:02:28. <Main>: MobiLink server shutting down
I. 07/25 14:02:28. <Main>: MobiLink server undergoing hard shutdown.
I. 07/25 14:02:28. <Main>: All connections and synchronizations being
terminated.
I. 07/25 14:02:28. <thread 1.5>: Shutting down
I. 07/25 14:02:28. <thread 1.1>: Shutting down
I. 07/25 14:02:28. <thread 1.3>: Shutting down
I. 07/25 14:02:28. <thread 1.4>: Shutting down
I. 07/25 14:02:28. <thread 1.2>: Shutting down
I. 07/25 14:02:29. <Main>: Removing download cache file
" C:\DOCUME~1\bcarter\
LOCALS~1\Temp\rd0000
0002"
I. 07/25 14:02:29. <Main>: end_connection <connection> (no script)
I. 07/25 14:02:29. <Main>: COMMIT Transaction: end_connection
I. 07/25 14:02:29. <Main>: Disconnected from consolidated database
I. 07/25 14:02:29. <Main>: Disconnected
I. 07/25 14:02:29. <Main>: MobiLink server finished
I. 07/27 14:03:27. Adaptive Server Anywhere MobiLink Version
9.0.2.3124
=====
--
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
| |
| Nick Elson 2005-08-12, 9:30 am |
| > What does this message mean? What does it indicate?
The -ct switch is working.
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:jc8nf1pip7r5a7m
h32r06jvg3aikelbffn@
4ax.com...
> What does this message mean? What does it indicate?
>
> <Background Thread>: Disconnected from consolidated database
>
> Here are two examples, plus by a "normal" server shutdown for
> comparison.
>
> Breck
>
> ===== Example 1: Apparent server termination and restart; note the
> long delay after synch complete.
> I. 08/02 15:14:25. <1.4> [19]: Synchronization complete
> I. 08/02 15:28:45. <Background Thread>: end_connection <connection>
> (no script)
> I. 08/02 15:28:45. <Background Thread>: COMMIT Transaction:
> end_connection
> I. 08/02 15:28:45. <Background Thread>: Disconnected from consolidated
> database
> I. 08/02 16:14:45. <Background Thread>: end_connection <connection>
> (no script)
> I. 08/02 16:14:45. <Background Thread>: COMMIT Transaction:
> end_connection
> I. 08/02 16:14:45. <Background Thread>: Disconnected from consolidated
> database
> I. 08/03 10:03:46. Adaptive Server Anywhere MobiLink Version
> 9.0.2.3124
> =====
>
> ===== Example 2: In the middle of things; note the long delay in
> processing on thread 1.4.
> I. 08/03 11:00:55. <1.4> [43]: Cached ODBC statement:
> SELECT user_id FROM ml_user WHERE name = ?
> I. 08/03 11:08:47. <Background Thread>: end_connection <connection>
> (no script)
> I. 08/03 11:08:47. <Background Thread>: COMMIT Transaction:
> end_connection
> I. 08/03 11:08:47. <Background Thread>: Disconnected from consolidated
> database
> I. 08/03 11:09:33. <1.4> [43]: modify_user <connection>
> =====
>
> ===== A "normal" MobiLink server shutdown.
> I. 07/25 13:52:24. <1.5> [2]: Synchronization complete
> I. 07/25 14:02:28. <Main>: MobiLink server shutting down
> I. 07/25 14:02:28. <Main>: MobiLink server undergoing hard shutdown.
> I. 07/25 14:02:28. <Main>: All connections and synchronizations being
> terminated.
> I. 07/25 14:02:28. <thread 1.5>: Shutting down
> I. 07/25 14:02:28. <thread 1.1>: Shutting down
> I. 07/25 14:02:28. <thread 1.3>: Shutting down
> I. 07/25 14:02:28. <thread 1.4>: Shutting down
> I. 07/25 14:02:28. <thread 1.2>: Shutting down
> I. 07/25 14:02:29. <Main>: Removing download cache file
> " C:\DOCUME~1\bcarter\
LOCALS~1\Temp\rd0000
0002"
> I. 07/25 14:02:29. <Main>: end_connection <connection> (no script)
> I. 07/25 14:02:29. <Main>: COMMIT Transaction: end_connection
> I. 07/25 14:02:29. <Main>: Disconnected from consolidated database
> I. 07/25 14:02:29. <Main>: Disconnected
> I. 07/25 14:02:29. <Main>: MobiLink server finished
> I. 07/27 14:03:27. Adaptive Server Anywhere MobiLink Version
> 9.0.2.3124
> =====
>
> --
> 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
| |
| Breck Carter [TeamSybase] 2005-08-12, 11:25 am |
| OK, thanks. The default is in effect here (60 minutes)
Are those connections automatically re-established if a sync is
performed?
The Help is silent on the implications of -ct. The client is trying to
determine why dbmlsrv9 is terminating unexpectedly, and is asking if
these "background thread" messages are benign or not.
Breck
On 12 Aug 2005 06:39:03 -0700, "Nick Elson"
< no_spam_nicelson@syb
ase.com> wrote:
>
>The -ct switch is working.
>
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
>message news:jc8nf1pip7r5a7m
h32r06jvg3aikelbffn@
4ax.com...
>
--
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
| |
| Nick Elson 2005-08-15, 9:24 am |
| > Are those connections automatically re-established if a sync is
> performed?
Yes, as needed.
> The Help is silent on the implications of -ct.
It seemed a little odd to me at first but the text
of the message
"Disconnected from consolidated database"
maps directly to the help file definition
"MobiLink database connections that go unused for
a specified amount of time are freed by the server"
It is absolutely and completely, albeit tersely, described in
that one sentence (alone).
The terseness aside, the problem I always have is identifying
which connection it is/was that is being disconnected. Since
it is a pooled phenomena and not always mappable to the
ML thread, that part is often subtle.
I can, all but, guarantee you that it is never the one that is
associated with messages immediately before and/or after
this one. In your case, it is not going to be associated with
thread <1.4>'s end_connection event, but something that
ended 1 minute (or one -ct interval) earlier.
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:qkhpf19nehoto07
7vrehhidd3ug963pb21@
4ax.com...
> OK, thanks. The default is in effect here (60 minutes)
>
> Are those connections automatically re-established if a sync is
> performed?
>
> The Help is silent on the implications of -ct. The client is trying to
> determine why dbmlsrv9 is terminating unexpectedly, and is asking if
> these "background thread" messages are benign or not.
>
> Breck
>
>
>
>
> On 12 Aug 2005 06:39:03 -0700, "Nick Elson"
> < no_spam_nicelson@syb
ase.com> 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
|
|
|
|
|