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.

Database file empty

3 posts in General Discussion Last posting was on 2005-10-17 17:52:53.0Z
Francisco Quintanilla Posted on 2005-10-17 15:59:07.0Z
From: "Francisco Quintanilla" <franciscoq@jdcard.com.ec>
Newsgroups: ianywhere.public.general
Subject: Database file empty
Lines: 5
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: corp-200-105-230-90-uio.punto.net.ec
X-Original-NNTP-Posting-Host: corp-200-105-230-90-uio.punto.net.ec
Message-ID: <4353ca4b$1@forums-1-dub>
Date: 17 Oct 2005 08:59:07 -0700
X-Trace: forums-1-dub 1129564747 200.105.230.90 (17 Oct 2005 08:59:07 -0700)
X-Original-Trace: 17 Oct 2005 08:59:07 -0700, corp-200-105-230-90-uio.punto.net.ec
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4858
Article PK: 17454

Yesterday, my database file size was 120Mb, but today is 0 bytes.
What happened??, please help me


Greg Fenton Posted on 2005-10-17 17:52:53.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database file empty
References: <4353ca4b$1@forums-1-dub>
In-Reply-To: <4353ca4b$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-t30.sybase.com
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <4353e4f5$2@forums-1-dub>
Date: 17 Oct 2005 10:52:53 -0700
X-Trace: forums-1-dub 1129571573 10.25.98.144 (17 Oct 2005 10:52:53 -0700)
X-Original-Trace: 17 Oct 2005 10:52:53 -0700, gfenton-t30.sybase.com
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4860
Article PK: 8579


Francisco Quintanilla wrote:
> Yesterday, my database file size was 120Mb, but today is 0 bytes.
> What happened??, please help me
>

Along with Chris's response, you have provided very little information
about your setup:

- Which version and build number of ASA?
- Which OS and version?

- Is the database engine still running? Are clients connected to it?
- What has happened between yesterday and today? (e.g. db backup?
filesystem backup? installed other software? etc...)

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Chris Keating (iAnywhere Solutions) Posted on 2005-10-17 16:21:53.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <4353ca4b$1@forums-1-dub>
Subject: Re: Database file empty
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <4353cfa1$1@forums-1-dub>
Date: 17 Oct 2005 09:21:53 -0700
X-Trace: forums-1-dub 1129566113 10.25.98.170 (17 Oct 2005 09:21:53 -0700)
X-Original-Trace: 17 Oct 2005 09:21:53 -0700, keating-dm20.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4859
Article PK: 17449

This has to be a file system problem as the database should never be 0 bytes
and once it grows, never shrinks (with some specific exceptions). Check your
system for logs (i.e., event logs on Windows and /var/message logs on UNIX
platforms) to see if any errors or warnings were reported. Other possible
causes is that the database file was overwritten by an 0 byte file. This
will likely only be possible if the database file was not running at the
time given that the engine places file locks when the file is mounted on an
engine.

You should check the health of the system hosting this database even if
these logs show no issues. If the system health appears OK, engage your
recovery plan for the database file.



--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

*****************************************************************************