SQL Anywhere database - THe following INSERT into a proxy table brings down the ASA9.02.3124

Author

THe following INSERT into a proxy table brings down the ASA9.02.3124

Edgard L. Riba

2005-10-28, 1:23 pm

Hi,

The following INSERT crashes the database server (ASA9 version 9.02.3124):

INSERT INTO kTrans_A
ON EXISTING UPDATE
SELECT * from iTrans where idLoc=3 and Fecha='2005-10-21';

kTrans_A is a proxy table physically located at the consolidated server
(also ASA 9.02.3124) and iTrans is the local table (exact same structure) in
the remote server where I'm executing the above statement.

In addition, when I restarted the crashed database I got the following
error:

Note: The size of the database "D:\invmp\data\invmp.db" is larger than
expected

After recovery, I shut it down again, and restarted, and now the message
does not appear. Is my database ok?

Edgard

Breck Carter [TeamSybase]

2005-10-28, 8:23 pm

On 28 Oct 2005 09:59:06 -0700, "Edgard L. Riba" <elriba at rimith dot
com> wrote:

>Note: The size of the database "D:\invmp\data\invmp.db" is larger than
>expected

That is not an error; if it had said "smaller", well, that would have
been another story :)

Breck

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

Joshua Savill

2005-10-28, 8:23 pm

Edgard,

Can you consistently reproduce the database server crash using the INSERT
into the proxy table? If so, please submit a bug case and provide all of the
details necessary to reproduce this problem. To submit a case:
http://www.ianywhere.com/support/sql_anywhere.html and click on 'Report a
Bug'.

There have been some changes to INSERT into proxy tables in later EBFs for
ASA 9.0.2. I would rule out this problem hasn't already been resolved by
applying EBF 3198 and retesting the problem. If the problem still exists in
EBF 3198, then submit a case please.

As Breck mentioned, file 'larger than expected' is not a problem. File
'smaller than expected' is a problem.

Cheers,
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Edgard L. Riba" <elriba at rimith dot com> wrote in message
news:436258da@forums
-1-dub...
> Hi,
>
> The following INSERT crashes the database server (ASA9 version 9.02.3124):
>
> INSERT INTO kTrans_A
> ON EXISTING UPDATE
> SELECT * from iTrans where idLoc=3 and Fecha='2005-10-21';
>
>
> kTrans_A is a proxy table physically located at the consolidated server
> (also ASA 9.02.3124) and iTrans is the local table (exact same structure)
> in the remote server where I'm executing the above statement.
>
> In addition, when I restarted the crashed database I got the following
> error:
>
> Note: The size of the database "D:\invmp\data\invmp.db" is larger than
> expected
>
>
> After recovery, I shut it down again, and restarted, and now the message
> does not appear. Is my database ok?
>
> Edgard
>
>

Sponsored Links