the stacktrace is attached

On Wed, Jan 9, 2013 at 2:13 PM, Noel Grandin <[email protected]> wrote:

>  Can you please post the entire stacktrace?
>
>
> On 2013-01-09 15:03, kais haddadin wrote:
>
> Hello,
>
>  I try to open the H2 database version (1.3.168) and am getting this
> error:
>
>  "Sequenz "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" nicht
> gefunden
> Sequence "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" not found;
> SQL statement:
> CREATE CACHED TABLE FCM.LAGERBESTÄNDE(
>     "#id" INTEGER DEFAULT (NEXT VALUE FOR
> FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F) NOT NULL
> NULL_TO_DEFAULT SEQUENCE
> FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F SELECTIVITY 100,
>     SCENARIO VARCHAR(32672) SELECTIVITY 1,
>     JAHR VARCHAR(32672) SELECTIVITY 1,
>     MONAT VARCHAR(32672) SELECTIVITY 1,
>     ARTIKEL VARCHAR(32672) SELECTIVITY 97,
>     LAGERORT VARCHAR(32672) SELECTIVITY 1,
>     EINHEIT VARCHAR(32672) SELECTIVITY 1,
>     "#VALUE" DOUBLE SELECTIVITY 6
> )<http://192.168.2.52:8082/login.do?jsessionid=e60f6ed39eaa5eb82e5e62554c7147e1#>
> "
>
>  but I did not create this, I created a table with Autoincrement column,
> the query should look like this :
>
>  CREATE TABLE 
> FCM.LAGERBESTÄNDE<http://192.168.2.52:8082/login.do?jsessionid=e60f6ed39eaa5eb82e5e62554c7147e1#>
>
> ("#id" INTEGER PRIMARY KEY AUTO_INCREMENT,...
>
>  Is this a known bug? I can not reproduce the problem, but It seems to
> happen sometimes.
> I can attach the database but it is 30MB after compression.
>
>  Regards,
>
>  Kais
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/iDm121_u8oUJ.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

01-09 15:06:54 database: opening C:/Users/khaddadin/Desktop/etl_drillthrough/dri
ll (build 169)
01-09 15:06:54 fileLock: load {}
01-09 15:06:54 fileLock: save {id=13c1fa2961403153e1af0535ffe5d22fd2f986c9098, m
ethod=file}
01-09 15:06:54 fileLock: load {method=file, id=13c1fa2961403153e1af0535ffe5d22fd
2f986c9098}
01-09 15:06:54 pageStore: log recover
01-09 15:06:54 pageStore: log recover stage: 0
01-09 15:06:54 pageStore: pageIn.readPage 7
01-09 15:06:54 pageStore: pageIn.readPage 8
01-09 15:06:54 pageStore: log recovery completed
01-09 15:06:54 pageStore: log recover stage: 1
01-09 15:06:54 index: PAGE_INDEX_DATA opened rows: 25
01-09 15:06:54 pageStore: addMeta id=0 type=0 root=514 parent=0 columns=0,1,2,3
01-09 15:06:54 index: T0_DATA opened rows: 43
01-09 15:06:54 pageStore: addMeta id=2 type=0 root=515 parent=2 columns=0,1,2
01-09 15:06:54 index: T2_DATA opened rows: 0
01-09 15:06:54 pageStore: addMeta id=6 type=0 root=517 parent=6 columns=0,1,2,3,
4
01-09 15:06:54 index: T6_DATA opened rows: 0
01-09 15:06:54 pageStore: addMeta id=10 type=0 root=520 parent=10 columns=0,1,2
01-09 15:06:54 index: T10_DATA opened rows: 0
01-09 15:06:54 pageStore: addMeta id=17 type=0 root=521 parent=17 columns=0,1,2,
3,4,5,6,7,8,9,10,11,12
01-09 15:06:54 index: T17_DATA opened rows: 120
01-09 15:06:54 pageStore: addMeta id=21 type=0 root=536 parent=21 columns=0,1,2,
3,4,5,6
01-09 15:06:54 index: T21_DATA opened rows: 66.768
01-09 15:06:54 pageStore: addMeta id=25 type=0 root=1929 parent=25 columns=0,1,2
,3,4,5,6,7,8,9
01-09 15:06:54 index: T25_DATA opened rows: 10.929
01-09 15:06:54 pageStore: addMeta id=29 type=0 root=2511 parent=29 columns=0,1,2
,3,4,5,6,7,8,9,10,11,12,13
01-09 15:06:54 index: T29_DATA opened rows: 2.190.138
01-09 15:06:54 pageStore: addMeta id=33 type=0 root=117769 parent=33 columns=0,1
,2,3,4,5,6,7,8,9,10,11
01-09 15:06:54 index: T33_DATA opened rows: 285.480
01-09 15:06:54 pageStore: addMeta id=37 type=0 root=117771 parent=37 columns=0,1
,2,3,4,5,6
01-09 15:06:54 index: T37_DATA opened rows: 8.356
01-09 15:06:54 pageStore: addMeta id=41 type=0 root=117773 parent=41 columns=0,1
,2,3,4,5,6,7
01-09 15:06:54 index: T41_DATA opened rows: 14.629
01-09 15:06:54 pageStore: addMeta id=45 type=0 root=118477 parent=45 columns=0,1
,2,3,4,5,6,7,8,9
01-09 15:06:54 index: T45_DATA opened rows: 42.198
01-09 15:06:54 pageStore: addMeta id=3 type=1 root=0 parent=2 columns=0
01-09 15:06:54 pageStore: addMeta id=5 type=1 root=516 parent=2 columns=2
01-09 15:06:54 index: opened I5 rows: 0
01-09 15:06:54 pageStore: addMeta id=7 type=1 root=518 parent=6 columns=0,1
01-09 15:06:54 index: opened I7 rows: 0
01-09 15:06:54 pageStore: addMeta id=9 type=1 root=519 parent=6 columns=4,0
01-09 15:06:54 index: opened I9 rows: 0
01-09 15:06:54 pageStore: addMeta id=11 type=1 root=0 parent=10 columns=0
01-09 15:06:54 pageStore: addMeta id=19 type=1 root=0 parent=17 columns=0
01-09 15:06:54 pageStore: addMeta id=23 type=1 root=0 parent=21 columns=0
01-09 15:06:54 pageStore: addMeta id=27 type=1 root=0 parent=25 columns=0
01-09 15:06:54 pageStore: addMeta id=31 type=1 root=0 parent=29 columns=0
01-09 15:06:54 pageStore: addMeta id=35 type=1 root=0 parent=33 columns=0
01-09 15:06:54 pageStore: addMeta id=39 type=1 root=0 parent=37 columns=0
01-09 15:06:54 pageStore: addMeta id=43 type=1 root=0 parent=41 columns=0
01-09 15:06:54 pageStore: addMeta id=47 type=1 root=0 parent=45 columns=0
01-09 15:06:54 pageStore: log recover stage: 2
01-09 15:06:54 pageStore: pageIn.readPage 7
01-09 15:06:54 pageStore: pageIn.readPage 8
01-09 15:06:54 pageStore: log recovery completed
01-09 15:06:54 pageStore: getFirstUncommittedSection
01-09 15:06:54 index: T0_DATA close
01-09 15:06:54 index: T2_DATA close
01-09 15:06:54 index: close
01-09 15:06:54 index: T6_DATA close
01-09 15:06:54 index: close
01-09 15:06:54 index: close
01-09 15:06:54 index: T10_DATA close
01-09 15:06:54 index: T17_DATA close
01-09 15:06:54 index: T21_DATA close
01-09 15:06:54 index: T25_DATA close
01-09 15:06:54 index: T29_DATA close
01-09 15:06:54 index: PAGE_INDEX_DATA close
01-09 15:06:54 index: T33_DATA close
01-09 15:06:54 index: T37_DATA close
01-09 15:06:54 index: T41_DATA close
01-09 15:06:54 index: T45_DATA close
01-09 15:06:54 pageStore: log recover done
01-09 15:06:54 pageStore: log free
01-09 15:06:54 pageStore: updateRecord page [3] freeList
01-09 15:06:54 pageStore: log openForWriting firstPage: 5
01-09 15:06:54 pageStore: setLogFirstPage key: 30 trunk: 5 data: 6
01-09 15:06:54 pageStore: writeVariableHeader
01-09 15:06:54 pageStore: checkpoint
01-09 15:06:54 pageStore: pageOut.storePage [6] stream data key:30 pos:12 remain
ing:2036
01-09 15:06:54 pageStore: pageOut.storePage fill 6
01-09 15:06:54 pageStore: writeBack page [3] freeList
01-09 15:06:54 pageStore: getFirstUncommittedSection
01-09 15:06:54 pageStore: log.removeUntil 5 7
01-09 15:06:54 pageStore: setLogFirstPage key: 30 trunk: 5 data: 7
01-09 15:06:54 pageStore: writeVariableHeader
01-09 15:06:54 pageStore: pageOut.storePage [7] stream data key:30 pos:12 remain
ing:2036
01-09 15:06:54 pageStore: pageOut.storePage fill 7
01-09 15:06:54 pageStore: writeFree
01-09 15:06:54 index: SYS_DATA opened rows: 43
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 index: LOBS_DATA opened rows: 0
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 index: LOB_MAP_DATA opened rows: 0
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 index: LOB_DATA_DATA opened rows: 0
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 index: AUFTRAGSBESTAND_DATA opened rows: 120
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 index: LIEFERTREUE_DATA opened rows: 10.929
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 index: LINIENBEST-NDE_DATA opened rows: 2.190.138
01-09 15:06:54 lock: 1 exclusive write lock unlock SYS
01-09 15:06:54 lock: 1 exclusive write lock requesting for SYS
01-09 15:06:54 lock: 1 exclusive write lock added for SYS
01-09 15:06:54 index: MASCHINENAUSWERTUNG_DATA opened rows: 285.480
01-09 15:06:54 database: CREATE CACHED TABLE FCM.LAGERBEST-NDE(
    "#id" INTEGER DEFAULT (NEXT VALUE FOR FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1
_B53B_FC2AD0D3510F) NOT NULL NULL_TO_DEFAULT SEQUENCE FCM.SYSTEM_SEQUENCE_A50422
70_9313_42F1_B53B_FC2AD0D3510F SELECTIVITY 100,
    SCENARIO VARCHAR(32672) SELECTIVITY 1,
    JAHR VARCHAR(32672) SELECTIVITY 1,
    MONAT VARCHAR(32672) SELECTIVITY 1,
    ARTIKEL VARCHAR(32672) SELECTIVITY 97,
    LAGERORT VARCHAR(32672) SELECTIVITY 1,
    EINHEIT VARCHAR(32672) SELECTIVITY 1,
    "#VALUE" DOUBLE SELECTIVITY 6
)
org.h2.jdbc.JdbcSQLException: Sequenz "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_F
C2AD0D3510F" nicht gefunden
Sequence "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" not found; SQL s
tatement:
CREATE CACHED TABLE FCM.LAGERBEST-NDE(
    "#id" INTEGER DEFAULT (NEXT VALUE FOR FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1
_B53B_FC2AD0D3510F) NOT NULL NULL_TO_DEFAULT SEQUENCE FCM.SYSTEM_SEQUENCE_A50422
70_9313_42F1_B53B_FC2AD0D3510F SELECTIVITY 100,
    SCENARIO VARCHAR(32672) SELECTIVITY 1,
    JAHR VARCHAR(32672) SELECTIVITY 1,
    MONAT VARCHAR(32672) SELECTIVITY 1,
    ARTIKEL VARCHAR(32672) SELECTIVITY 97,
    LAGERORT VARCHAR(32672) SELECTIVITY 1,
    EINHEIT VARCHAR(32672) SELECTIVITY 1,
    "#VALUE" DOUBLE SELECTIVITY 6
) [90036-169]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:169)
        at org.h2.message.DbException.get(DbException.java:146)
        at org.h2.schema.Schema.getSequence(Schema.java:474)
        at org.h2.command.Parser.readSequence(Parser.java:4816)
        at org.h2.command.Parser.readTerm(Parser.java:2491)
        at org.h2.command.Parser.readFactor(Parser.java:2046)
        at org.h2.command.Parser.readSum(Parser.java:2033)
        at org.h2.command.Parser.readConcat(Parser.java:2006)
        at org.h2.command.Parser.readCondition(Parser.java:1871)
        at org.h2.command.Parser.readAnd(Parser.java:1852)
        at org.h2.command.Parser.readExpression(Parser.java:1844)
        at org.h2.command.Parser.readTerm(Parser.java:2558)
        at org.h2.command.Parser.readFactor(Parser.java:2046)
        at org.h2.command.Parser.readSum(Parser.java:2033)
        at org.h2.command.Parser.readConcat(Parser.java:2006)
        at org.h2.command.Parser.readCondition(Parser.java:1871)
        at org.h2.command.Parser.readAnd(Parser.java:1852)
        at org.h2.command.Parser.readExpression(Parser.java:1844)
        at org.h2.command.Parser.parseColumnForTable(Parser.java:3535)
        at org.h2.command.Parser.parseCreateTable(Parser.java:5213)
        at org.h2.command.Parser.parseCreate(Parser.java:3806)
        at org.h2.command.Parser.parsePrepared(Parser.java:324)
        at org.h2.command.Parser.parse(Parser.java:279)
        at org.h2.command.Parser.parse(Parser.java:251)
        at org.h2.command.Parser.prepare(Parser.java:201)
        at org.h2.engine.Session.prepare(Session.java:388)
        at org.h2.engine.Session.prepare(Session.java:375)
        at org.h2.engine.MetaRecord.execute(MetaRecord.java:56)
        at org.h2.engine.Database.open(Database.java:632)
        at org.h2.engine.Database.openDatabase(Database.java:222)
        at org.h2.engine.Database.<init>(Database.java:217)
        at org.h2.engine.Engine.openSession(Engine.java:56)
        at org.h2.engine.Engine.openSession(Engine.java:159)
        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
        at org.h2.engine.Engine.createSession(Engine.java:121)
        at org.h2.engine.Engine.createSession(Engine.java:28)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.jav
a:305)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:109)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:93)
        at org.h2.Driver.connect(Driver.java:72)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at org.h2.util.JdbcUtils.getConnection(JdbcUtils.java:148)
        at org.h2.util.JdbcUtils.getConnection(JdbcUtils.java:118)
        at org.h2.tools.Shell.connect(Shell.java:347)
        at org.h2.tools.Shell.promptLoop(Shell.java:186)
        at org.h2.tools.Shell.runTool(Shell.java:148)
        at org.h2.tools.Shell.main(Shell.java:80)
01-09 15:06:54 pageStore: close
01-09 15:06:54 pageStore: log close
01-09 15:06:54 fileLock: load {method=file, id=13c1fa2961403153e1af0535ffe5d22fd
2f986c9098}
SQL Exception: Sequenz "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" ni
cht gefunden
Sequence "SYSTEM_SEQUENCE_A5042270_9313_42F1_B53B_FC2AD0D3510F" not found; SQL s
tatement:
CREATE CACHED TABLE FCM.LAGERBEST-NDE(
    "#id" INTEGER DEFAULT (NEXT VALUE FOR FCM.SYSTEM_SEQUENCE_A5042270_9313_42F1
_B53B_FC2AD0D3510F) NOT NULL NULL_TO_DEFAULT SEQUENCE FCM.SYSTEM_SEQUENCE_A50422
70_9313_42F1_B53B_FC2AD0D3510F SELECTIVITY 100,
    SCENARIO VARCHAR(32672) SELECTIVITY 1,
    JAHR VARCHAR(32672) SELECTIVITY 1,
    MONAT VARCHAR(32672) SELECTIVITY 1,
    ARTIKEL VARCHAR(32672) SELECTIVITY 97,
    LAGERORT VARCHAR(32672) SELECTIVITY 1,
    EINHEIT VARCHAR(32672) SELECTIVITY 1,
    "#VALUE" DOUBLE SELECTIVITY 6
) [90036-169]
01-09 15:06:54 fileLock: watchdog end
[Enter]   jdbc:h2:C:\Users\khaddadin\Desktop\trunk\etltomcat_7\wtpwebapps\etlser
ver\data\db\etl_drillthrough\drill

Reply via email to