Subject Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version
Author Sofija Blazevski
This affected entire database (all generators actively in use), mostly
generators are used for Integer columns, some are used for varchar
columns in case like document number that has string prefix, the prefix
can vary within a table.

I'm not sure how could type of column produce a problem like this?


Thanks,

- Sofija


On 10.8.2012 5:33, W O wrote:
> Which is the type of your column?
>
> It is Integer, Smallint, BigInt?
>
> Maybe that's the problem.
>
> Greetings.
>
> Walter.
>
>
>
>
> On Thu, Aug 9, 2012 at 5:50 AM, Sofija Blazevski <
> sofija.blazevski@...> wrote:
>
>> **
>>
>>
>>
>> On 8.8.2012 12:06, Mark Rotteveel wrote:
>>> On Wed, 08 Aug 2012 11:02:52 +0200, Sofija Blazevski
>>> <sofija.blazevski@...
>>> <mailto:sofija.blazevski%40grappologroup.com>> wrote:
>>>> I did check user profiles, but didn't find any database copies there.
>>>>
>>>> Also, we don't administer this server, but currently we have access. So
>>>> I noticed in system log a message for corrupt and unusable disk
>>>> structure, though the message is from this morning(there was a power
>>>> loss this morning) and problem has occurred on Monday, might this kind
>>>> of problem be due to some kind of hardware failure?
>>> I was browsing my Firebird-support archive yesterday, and I did see
>>> somebody mentioning that depending on the (disk)cache configuration of
>>> Windows, changes might actually never be written out to disk, unless the
>>> file is actually closed by the application. If there was some kind of
>>> crash, this could mean that the changes were never actually written to
>>> disk.
>>>
>> That is very interesting to know about, thought I never had such case.
>>
>> Thank you for trying to help, it seems there are a lot of problems with
>> either system or hardware, as one of our application files, out of
>> nowhere came to filesize 0 and had to be replaced.
>>
>> - Sofija
>>
>>
>>> I am not sure what setting that would be though, and I do think it is
>>> highly unlikely that this would still happen in Windows.
>>>
>>> Mark
>>>
>>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>



[Non-text portions of this message have been removed]