Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problems with database start Sybase 8.03 ( EBF 5444 )

7 posts in General Discussion Last posting was on 2008-11-24 15:37:44.0Z
Dr. Traugott Ziegler Posted on 2008-09-24 15:30:37.0Z
From: "Dr. Traugott Ziegler" <dialyse-heidelberg@t-online.de>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Problems with database start Sybase 8.03 ( EBF 5444 )
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48da5d1d@forums-1-dub>
Date: 24 Sep 2008 08:30:37 -0700
X-Trace: forums-1-dub 1222270237 10.22.241.152 (24 Sep 2008 08:30:37 -0700)
X-Original-Trace: 24 Sep 2008 08:30:37 -0700, vip152.sybase.com
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7096
Article PK: 5316

Our Sybase-database-server ( SQL-Anywhere 8.03-EBF 5444, running under
netware 5.0 and 5.1 ) is prompting a "note" during startup of the
database since a few days just like that: "note, the size of the
database ( path-name ) is larger than expected". The database is running
without problems. There was no server-crash.
We could not find any volume-errors or problems in the database using
dbvalidate. The size of the database is shortly above 2 GB.
What is the cause of the error message?
regards


Dr. Traugott Ziegler


Jeff Albion (Sybase iAnywhere) Posted on 2008-09-24 17:21:11.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Problems with database start Sybase 8.03 ( EBF 5444 )
References: <48da5d1d@forums-1-dub>
In-Reply-To: <48da5d1d@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48da7707$1@forums-1-dub>
Date: 24 Sep 2008 10:21:11 -0700
X-Trace: forums-1-dub 1222276871 10.22.241.152 (24 Sep 2008 10:21:11 -0700)
X-Original-Trace: 24 Sep 2008 10:21:11 -0700, vip152.sybase.com
Lines: 56
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7099
Article PK: 5318

Dr. Ziegler,

Do you know which build of our software the database was initially
created on? I'm guessing it was SQL Anywhere 5.x?

---

** Note: SQL Anywhere 5.x information below **

The error indicates that the size reported by the operating system does
not match our internal calculation of what the file size should be.
(More specifically, the offset of the rollback log doesn't match how far
into the file we expect it to be based on the operating system's
information).

It should be recorded in the console log as a warning and can be ignored
provided that the database file validates. The warning could be a direct
result of the database file surpassing the 2GB range on the OS and the
OS file size value / file size checking code is incorrect. We would need
an engineering investigation to determine that. (Although note that
8.0.3 is no longer in engineering support:
http://www.sybase.com/detail?id=1050017 ).

To clear the warning, I'd actually recommend rebuilding the database on
version 8.0.3 - the database format that this error is returned in is
from the 5.x era. The warning should go away once the database is in the
new format. You may want to consult the 8.0.3 documentation for the
"dbunload -an" command:

http://manuals.sybase.com/onlinebooks/group-sas/awg0802e/dbdaen8/@Generic__BookTextView/52952;pt=52952#X

Cheers,

Dr. Traugott Ziegler wrote:
> Our Sybase-database-server ( SQL-Anywhere 8.03-EBF 5444, running under
> netware 5.0 and 5.1 ) is prompting a "note" during startup of the
> database since a few days just like that: "note, the size of the
> database ( path-name ) is larger than expected". The database is running
> without problems. There was no server-crash.
> We could not find any volume-errors or problems in the database using
> dbvalidate. The size of the database is shortly above 2 GB.
> What is the cause of the error message?
> regards
>
>
> Dr. Traugott Ziegler

--
Jeff Albion, Engineering
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


John Smirnios Posted on 2008-09-25 14:44:03.0Z
From: John Smirnios <smirnios_at_sybase.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Problems with database start Sybase 8.03 ( EBF 5444 )
References: <48da5d1d@forums-1-dub>
In-Reply-To: <48da5d1d@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48dba3b3$1@forums-1-dub>
Date: 25 Sep 2008 07:44:03 -0700
X-Trace: forums-1-dub 1222353843 10.22.241.152 (25 Sep 2008 07:44:03 -0700)
X-Original-Trace: 25 Sep 2008 07:44:03 -0700, vip152.sybase.com
Lines: 32
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7100
Article PK: 5319

That startup message normally only appears if the previous invocation of
the database server terminated abnormally (the process died or the
machine crashed) and it usually indicates that the file was growing when
the crash happened. You say there was no crash so that's a bit
suspicious. Perhaps the previous shutdown was not as normal as it
appeared. Did the server go through recovery when you started it? Do you
have a copy of all of the startup messages from that particular time you
started the server to look for recovery messages?

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Dr. Traugott Ziegler wrote:
> Our Sybase-database-server ( SQL-Anywhere 8.03-EBF 5444, running under
> netware 5.0 and 5.1 ) is prompting a "note" during startup of the
> database since a few days just like that: "note, the size of the
> database ( path-name ) is larger than expected". The database is running
> without problems. There was no server-crash.
> We could not find any volume-errors or problems in the database using
> dbvalidate. The size of the database is shortly above 2 GB.
> What is the cause of the error message?
> regards
>
>
> Dr. Traugott Ziegler


Dr. Traugott Ziegler Posted on 2008-09-25 16:35:47.0Z
From: "Dr. Traugott Ziegler" <traugott.ziegler@t-online.de>
User-Agent: Thunderbird 2.0.0.16 (X11/20080707)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Problems with database start Sybase 8.03 ( EBF 5444 )
References: <48da5d1d@forums-1-dub> <48dba3b3$1@forums-1-dub>
In-Reply-To: <48dba3b3$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48dbbde3@forums-1-dub>
Date: 25 Sep 2008 09:35:47 -0700
X-Trace: forums-1-dub 1222360547 10.22.241.152 (25 Sep 2008 09:35:47 -0700)
X-Original-Trace: 25 Sep 2008 09:35:47 -0700, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7101
Article PK: 5321

John Smirnios schrieb:

> That startup message normally only appears if the previous invocation of
> the database server terminated abnormally (the process died or the
> machine crashed) and it usually indicates that the file was growing when
> the crash happened. You say there was no crash so that's a bit
> suspicious. Perhaps the previous shutdown was not as normal as it
> appeared. Did the server go through recovery when you started it? Do you
> have a copy of all of the startup messages from that particular time you
> started the server to look for recovery messages?
>
> -john.
>

Dear,
Im did not notice any signs of recovery during startup of the server (
I`ll check if I can find a copy of the startup-messages ).
The note concerning the size of the database file is shown now ( without
any signs of recovery ) during each startup of the database after
shutdown without any problems.
Regards
Dr. Traugott Ziegler


John Smirnios Posted on 2008-09-26 13:49:52.0Z
From: John Smirnios <smirnios_at_sybase.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Problems with database start Sybase 8.03 ( EBF 5444 )
References: <48da5d1d@forums-1-dub> <48dba3b3$1@forums-1-dub> <48dbbde3@forums-1-dub>
In-Reply-To: <48dbbde3@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48dce880$1@forums-1-dub>
Date: 26 Sep 2008 06:49:52 -0700
X-Trace: forums-1-dub 1222436992 10.22.241.152 (26 Sep 2008 06:49:52 -0700)
X-Original-Trace: 26 Sep 2008 06:49:52 -0700, vip152.sybase.com
Lines: 45
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7102
Article PK: 5322

It sounds a little suspicious to me but I'm not worried yet :).
After a successful startup, the server will always truncate the files to
the size they "should". Afterwards, the expected file size is always
updated whenever the file grows. That's why it's strange to see the
message again the next time you start up after a clean shutdown.

Did the message only start appearing once the file exceeded 2GB in size?
Long ago, I seem to recall that Netware itself had issues dealing with
files >2GB in size but Novell improved that and the ASA8.0.3 doc shows
that the limit should be 4GB. You could try reporting it to tech support
but 8.0.3 is out of engineering support (not sure if that means it's out
of "tech" support). You could also try using 9.0.2 -- it supports very
large files on Netware NSS volumes (still only 4GB on traditional volumes).


-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Dr. Traugott Ziegler wrote:
> John Smirnios schrieb:
>> That startup message normally only appears if the previous invocation
>> of the database server terminated abnormally (the process died or the
>> machine crashed) and it usually indicates that the file was growing
>> when the crash happened. You say there was no crash so that's a bit
>> suspicious. Perhaps the previous shutdown was not as normal as it
>> appeared. Did the server go through recovery when you started it? Do
>> you have a copy of all of the startup messages from that particular
>> time you started the server to look for recovery messages?
>>
>> -john.
>>
> Dear,
> Im did not notice any signs of recovery during startup of the server (
> I`ll check if I can find a copy of the startup-messages ).
> The note concerning the size of the database file is shown now ( without
> any signs of recovery ) during each startup of the database after
> shutdown without any problems.
> Regards
> Dr. Traugott Ziegler


Dr. Traugott Ziegler Posted on 2008-11-23 09:28:01.0Z
From: "Dr. Traugott Ziegler" <traugott.ziegler@t-online.de>
User-Agent: Thunderbird 2.0.0.18 (X11/20081105)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Problems with database start Sybase 8.03 ( EBF 5444 )
References: <48da5d1d@forums-1-dub> <48dba3b3$1@forums-1-dub> <48dbbde3@forums-1-dub> <48dce880$1@forums-1-dub>
In-Reply-To: <48dce880$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49292221@forums-1-dub>
Date: 23 Nov 2008 01:28:01 -0800
X-Trace: forums-1-dub 1227432481 10.22.241.152 (23 Nov 2008 01:28:01 -0800)
X-Original-Trace: 23 Nov 2008 01:28:01 -0800, vip152.sybase.com
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7207
Article PK: 5427

John Smirnios schrieb:

> It sounds a little suspicious to me but I'm not worried yet :).
> After a successful startup, the server will always truncate the files to
> the size they "should". Afterwards, the expected file size is always
> updated whenever the file grows. That's why it's strange to see the
> message again the next time you start up after a clean shutdown.
>
> Did the message only start appearing once the file exceeded 2GB in size?
> Long ago, I seem to recall that Netware itself had issues dealing with
> files >2GB in size but Novell improved that and the ASA8.0.3 doc shows
> that the limit should be 4GB. You could try reporting it to tech support
> but 8.0.3 is out of engineering support (not sure if that means it's out
> of "tech" support). You could also try using 9.0.2 -- it supports very
> large files on Netware NSS volumes (still only 4GB on traditional volumes).
>
>
> -john.

Looks now to be a severe bug in the ASA-8.03-Module for Netware. After
rebuilding the database (with the correct tools ) the problem
disappeared ( the size of the databse fell below 2 GB! ) and reoccured
after the size has grown above 2 GB, so that we had to switch acute to
windows-server.
Regards


Dr. Traugott Ziegler


John Smirnios Posted on 2008-11-24 15:37:44.0Z
From: John Smirnios <smirnios_at_sybase.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Problems with database start Sybase 8.03 ( EBF 5444 )
References: <48da5d1d@forums-1-dub> <48dba3b3$1@forums-1-dub> <48dbbde3@forums-1-dub> <48dce880$1@forums-1-dub> <49292221@forums-1-dub>
In-Reply-To: <49292221@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <492aca48$1@forums-1-dub>
Date: 24 Nov 2008 07:37:44 -0800
X-Trace: forums-1-dub 1227541064 10.22.241.152 (24 Nov 2008 07:37:44 -0800)
X-Original-Trace: 24 Nov 2008 07:37:44 -0800, vip152.sybase.com
Lines: 45
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7216
Article PK: 5434

Could be an ASA bug or a Netware bug. Netware doesn't handle large files
very well (and the problems you run into depend on which of the various
Netware IO APIs an application uses). Newer versions of ASA may have
worked (we changed which APIs we used twice somewhere along the line --
not sure at which versions) but you should definitely be fine on the
Windows server.

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Dr. Traugott Ziegler wrote:
> John Smirnios schrieb:
>> It sounds a little suspicious to me but I'm not worried yet :).
>> After a successful startup, the server will always truncate the files
>> to the size they "should". Afterwards, the expected file size is
>> always updated whenever the file grows. That's why it's strange to see
>> the message again the next time you start up after a clean shutdown.
>>
>> Did the message only start appearing once the file exceeded 2GB in
>> size? Long ago, I seem to recall that Netware itself had issues
>> dealing with files >2GB in size but Novell improved that and the
>> ASA8.0.3 doc shows that the limit should be 4GB. You could try
>> reporting it to tech support but 8.0.3 is out of engineering support
>> (not sure if that means it's out of "tech" support). You could also
>> try using 9.0.2 -- it supports very large files on Netware NSS volumes
>> (still only 4GB on traditional volumes).
>>
>>
>> -john.
> Looks now to be a severe bug in the ASA-8.03-Module for Netware. After
> rebuilding the database (with the correct tools ) the problem
> disappeared ( the size of the databse fell below 2 GB! ) and reoccured
> after the size has grown above 2 GB, so that we had to switch acute to
> windows-server.
> Regards
>
>
> Dr. Traugott Ziegler