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.

Allocated page marked as free

3 posts in General Discussion Last posting was on 2009-09-22 06:01:19.0Z
Robin Posted on 2009-05-18 06:16:12.0Z
From: "robin" <.@iol.it>
Newsgroups: ianywhere.public.general
Subject: Allocated page marked as free
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a10fd2c$1@forums-1-dub>
Date: 17 May 2009 23:16:12 -0700
X-Trace: forums-1-dub 1242627372 10.22.241.152 (17 May 2009 23:16:12 -0700)
X-Original-Trace: 17 May 2009 23:16:12 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7562
Article PK: 5968

I get this error validating a DB in SQL Anywhere 10.0.1.3784:

Validating database pages
Allocated page marked as free (000004d0) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d1) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d2) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d3) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d4) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d5) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d6) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d7) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d8) in database file
"F:\DB\CUST6\MAIN.db"
Allocated page marked as free (000004d9) in database file
"F:\DB\CUST6\MAIN.db"
java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Run time SQL
error -- Database validation failed for database file "F:\DB\CUST6\MAIN.db"
The database 'MAIN' could not be validated.

Can anyone suggest me how to solve this problem?

Thanks,
robin


Josh Savill [Sybase] Posted on 2009-05-19 17:21:17.0Z
From: "Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Allocated page marked as free
References: <4a10fd2c$1@forums-1-dub>
In-Reply-To: <4a10fd2c$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a12ea8d$1@forums-1-dub>
Date: 19 May 2009 10:21:17 -0700
X-Trace: forums-1-dub 1242753677 10.22.241.152 (19 May 2009 10:21:17 -0700)
X-Original-Trace: 19 May 2009 10:21:17 -0700, vip152.sybase.com
Lines: 43
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7566
Article PK: 5971

How are you validating the database?

Is there any messages in the database server console?

--
Joshua Savill
Sybase Inc. - Product Manager

robin wrote:
> I get this error validating a DB in SQL Anywhere 10.0.1.3784:
>
> Validating database pages
> Allocated page marked as free (000004d0) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d1) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d2) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d3) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d4) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d5) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d6) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d7) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d8) in database file
> "F:\DB\CUST6\MAIN.db"
> Allocated page marked as free (000004d9) in database file
> "F:\DB\CUST6\MAIN.db"
> java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Run time SQL
> error -- Database validation failed for database file "F:\DB\CUST6\MAIN.db"
> The database 'MAIN' could not be validated.
>
> Can anyone suggest me how to solve this problem?
>
> Thanks,
> robin
>
>


Robin Posted on 2009-09-22 06:01:19.0Z
From: "robin" <.@iol.it>
Newsgroups: ianywhere.public.general
References: <4a10fd2c$1@forums-1-dub> <4a12ea8d$1@forums-1-dub>
Subject: Re: Allocated page marked as free
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ab8682f$1@forums-1-dub>
Date: 21 Sep 2009 23:01:19 -0700
X-Trace: forums-1-dub 1253599279 10.22.241.152 (21 Sep 2009 23:01:19 -0700)
X-Original-Trace: 21 Sep 2009 23:01:19 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7737
Article PK: 6775

Sorry, I am no more able to reproduce the problem.

Thanks and regards,
Robin

"Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com> ha scritto nel
messaggio news:4a12ea8d$1@forums-1-dub...

> How are you validating the database?
>
> Is there any messages in the database server console?
>
> --
> Joshua Savill
> Sybase Inc. - Product Manager
>
>
> robin wrote:
>> I get this error validating a DB in SQL Anywhere 10.0.1.3784:
>>
>> Validating database pages
>> Allocated page marked as free (000004d0) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d1) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d2) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d3) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d4) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d5) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d6) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d7) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d8) in database file
>> "F:\DB\CUST6\MAIN.db"
>> Allocated page marked as free (000004d9) in database file
>> "F:\DB\CUST6\MAIN.db"
>> java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Run time SQL
>> error -- Database validation failed for database file
>> "F:\DB\CUST6\MAIN.db"
>> The database 'MAIN' could not be validated.
>>
>> Can anyone suggest me how to solve this problem?
>>
>> Thanks,
>> robin