problem sybase autogenerated ids

Posted by daedlus on Stack Overflow See other posts from Stack Overflow or by daedlus
Published on 2010-03-06T18:18:04Z Indexed on 2010/04/11 9:23 UTC
Read the original article Hit count: 357

Filed under:

sybase

|

sybase-ase

|

database

Hi , I have a table in which the PK column Id of type bigint and it is populated automatically increasing order of 1,2,3...so on i notice that some times all of a sudden the ids that are generated are having very big value . for example the ids are like 1,2,3,4,5,500000000000001,500000000000002 there is a huge jump after 5...ids 6 , 7 were not used at all

i do perform delete operations on this table but i am absolutely sure that missing ids were not used before.

why does this occur and how can i fix this?

many thanks for looking in to this.

my env: sybase ase 15.0.3 , linux

© Stack Overflow or respective owner

Related posts about sybase

"Oracle", "Sybase", "SQL Server" vs just "SQL/JDBC" in the CV

as seen on Programmers - Search for 'Programmers'
How would you define a testable measure of the expertise that, if you're honest with yourself, lets you write in your CV words "Oracle", "Sybase", or "SQL Server" and not just "Relational Databases, SQL, JDBC" in your software developer's CV? What every XXX-developer (XXX - a vendor name) should know… >>> More
Limiting Sybase ASE 15 CPU usage on VM

as seen on Server Fault - Search for 'Server Fault'
I've set up a single CPU Sybase ASE 15.7 test/hobby/experimentation system on a Debian Squeeze x64 KVM VM. I notice the CPU load goes to 100% and stays there. Definitely not a Sybase guru, only interested to see if some programs I'm running work on the database. Looking at Sybase docs it seems ASE… >>> More
Php pdo_dblib - cannot find/unable to load freetds

as seen on Server Fault - Search for 'Server Fault'
Self-hosted box, RHEL 6 PHP 5.3.3 PDO installed freetds installed pdo_dblib - so far no luck installing My goal is to use PDO with sybase. Attempting to install pdo_dblib from the appropriate version php source code. I have tried a variety of methods and searched quite a bit for help on this topic… >>> More
Any alternative to Sybase Sql Advantage?

as seen on Stack Overflow - Search for 'Stack Overflow'
Sybase Sql Advantage is the default editor for the Sybase database. But it has lots of shortcomings, because it basically is what Notepad is for Windows users: Can't do multiple undo's Monochrome, text is black and background is white Can't see what character did you exactly paste from clipboard… >>> More
Constructing dynamic columns from parameters in Sybase

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to write a stored proc (SP) in Sybase. The SP takes 5 varchar parameters. Based on the parameters passed, I want to construct the column names to be selected from a particular table. The below works: DECLARE @TEST VARCHAR(50) SELECT @TEST = "country" … >>> More

Related posts about sybase-ase

Sybase ASE

as seen on SQL Blog - Search for 'SQL Blog'
I sat in a Sybase ASE class last week for five days. Although it didn't cover the more advanced features introduced in the more recent versions of Sybase ASE, the class did touch all the basics of administering Sybase ASE. While I was successful in suppressing any urge to openly compare Sybase ASE… >>> More
Overview of Sybase ASE In-Memory Database Feature

as seen on Internet.com - Search for 'Internet.com'
Sybase's In-Memory database feature is fully integrated within the base product Adaptive Server Enterprise. >>> More
Overview of Sybase ASE In-Memory Database Feature

as seen on Internet.com - Search for 'Internet.com'
Sybase's In-Memory database feature is fully integrated within the base product Adaptive Server Enterprise. >>> More
sybase ase 15.0.3 64 bit install error

as seen on Server Fault - Search for 'Server Fault'
Hi , I have a 32bit machine installed with 64 bit suse10 linux. I then tried installing a 64bit sybase on it but the sybase installation fails the moment i launch ./setup with below error: Unhandled error...try running with is:debug system property. the install shield wizard fails to launch.. I… >>> More
Good books on Sybase ASE 15?

as seen on Stack Overflow - Search for 'Stack Overflow'
We need to get some good books on Sybase ASE 15 for our developers. The people in the team have previous experience with different SQL flavors (MS SQL, MySQL, Informix and Oracle) but no one worked with Sybase before. Therefore I am looking for two kinds of books: Book for developers on how to… >>> More