[AAA-80] H2Store tries to create tables multiple times Created: 15/Dec/15  Updated: 21/Mar/19  Resolved: 03/Feb/16

Status: Resolved
Project: aaa
Component/s: General
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Ryan Goulding Assignee: Ryan Goulding
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Operating System: All
Platform: All

Issue Links:
Duplicate
is duplicated by AAA-86 StoreException in -all- csit job Resolved
External issue ID: 4782

 Description   

AAA H2Store code surrounding table creation is not synchronized, resulting in dangerous race conditions. Below is one such example of this:

2015-12-15 04:50:42,923 | INFO | qtp2032590313-78 | DomainStore | 235 - org.opendaylight.aaa.h2-store - 0.3.0.SNAPSHOT | in dbConnect, domains Table does not exist, creating table
2015-12-15 04:50:42,923 | INFO | config-pusher | DomainStore | 235 - org.opendaylight.aaa.h2-store - 0.3.0.SNAPSHOT | in dbConnect, domains Table does not exist, creating table
2015-12-15 04:50:42,947 | ERROR | config-pusher | StoreException | 235 - org.opendaylight.aaa.h2-store - 0.3.0.SNAPSHOT | Cannot connect to database server org.h2.jdbc.JdbcSQLException: Table "DOMAINS" already exists; SQL statement:
CREATE TABLE DOMAINS (domainid VARCHAR(128) PRIMARY KEY,name VARCHAR(128) UNIQUE NOT NULL, description VARCHAR(128) , enabled INTEGER NOT NULL) [42101-185]

 Comments   
Comment by Ryan Goulding [ 15/Dec/15 ]

https://git.opendaylight.org/gerrit/#/c/31364/

Comment by Ryan Goulding [ 02/Feb/16 ]

Very rare instances; shows up in CSIT often. Will be fixed in next day.

Comment by Ryan Goulding [ 03/Feb/16 ]

https://git.opendaylight.org/gerrit/#/c/33988/

Generated at Wed Feb 07 19:08:34 UTC 2024 using Jira 8.20.10#820010-sha1:ace47f9899e9ee25d7157d59aa17ab06aee30d3d.