Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

roachtest: hibernate failed #36151

Closed
cockroach-teamcity opened this issue Mar 26, 2019 · 6 comments
Closed

roachtest: hibernate failed #36151

cockroach-teamcity opened this issue Mar 26, 2019 · 6 comments
Assignees
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot.
Milestone

Comments

@cockroach-teamcity
Copy link
Member

SHA: https://github.com/cockroachdb/cockroach/commits/25398c010b2af75b11fed189680ea6b9645f0cf5

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=hibernate PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1199659&tab=buildLog

The test failed on master:
	hibernate.go:312,hibernate.go:323,test.go:1214: 
		Tests run on Cockroach v19.1.0-beta.20190318-354-g25398c0
		Tests run against Hibernate 5.4.2
		8587 Total Tests Run
		8264 tests passed
		323 tests failed
		0 tests passed unexpectedly
		21 tests failed unexpectedly
		0 tests expected failed, but not run
		For a full summary look at the hibernate artifacts 
		
		An updated blacklist (hibernateBlackList19_1) is available in the artifacts' hibernate log

@cockroach-teamcity cockroach-teamcity added this to the 19.1 milestone Mar 26, 2019
@cockroach-teamcity cockroach-teamcity added C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. labels Mar 26, 2019
@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/7f8a0969e8e9eb7e9fc0d2fe96e03849d30dd561

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=hibernate PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1199677&tab=buildLog

The test failed on release-19.1:
	hibernate.go:312,hibernate.go:323,test.go:1214: 
		Tests run on Cockroach v19.1.0-beta.20190318-269-g7f8a096
		Tests run against Hibernate 5.4.2
		8587 Total Tests Run
		8264 tests passed
		323 tests failed
		0 tests passed unexpectedly
		21 tests failed unexpectedly
		0 tests expected failed, but not run
		For a full summary look at the hibernate artifacts 
		
		An updated blacklist (hibernateBlackList19_1) is available in the artifacts' hibernate log

@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/3aadd20bbf0940ef65f8b2cdcda498401ba5d9c6

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=hibernate PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1201905&tab=buildLog

The test failed on release-19.1:
	hibernate.go:312,hibernate.go:323,test.go:1216: 
		Tests run on Cockroach v19.1.0-beta.20190318-271-g3aadd20
		Tests run against Hibernate 5.4.2
		8587 Total Tests Run
		8264 tests passed
		323 tests failed
		0 tests passed unexpectedly
		21 tests failed unexpectedly
		0 tests expected failed, but not run
		For a full summary look at the hibernate artifacts 
		
		An updated blacklist (hibernateBlackList19_1) is available in the artifacts' hibernate log

@cockroach-teamcity
Copy link
Member Author

SHA: https://github.com/cockroachdb/cockroach/commits/ed21f6da64b022a3e1e550fad5850fdffe2a7d17

Parameters:

To repro, try:

# Don't forget to check out a clean suitable branch and experiment with the
# stress invocation until the desired results present themselves. For example,
# using stress instead of stressrace and passing the '-p' stressflag which
# controls concurrency.
./scripts/gceworker.sh start && ./scripts/gceworker.sh mosh
cd ~/go/src/github.com/cockroachdb/cockroach && \
stdbuf -oL -eL \
make stressrace TESTS=hibernate PKG=roachtest TESTTIMEOUT=5m STRESSFLAGS='-maxtime 20m -timeout 10m' 2>&1 | tee /tmp/stress.log

Failed test: https://teamcity.cockroachdb.com/viewLog.html?buildId=1201887&tab=buildLog

The test failed on master:
	hibernate.go:312,hibernate.go:323,test.go:1216: 
		Tests run on Cockroach v19.1.0-beta.20190318-396-ged21f6d
		Tests run against Hibernate 5.4.2
		8587 Total Tests Run
		8264 tests passed
		323 tests failed
		0 tests passed unexpectedly
		21 tests failed unexpectedly
		0 tests expected failed, but not run
		For a full summary look at the hibernate artifacts 
		
		An updated blacklist (hibernateBlackList19_1) is available in the artifacts' hibernate log

@BramGruneir
Copy link
Member

Something happened recently that causing 21 tests to fail. Investigating.

@BramGruneir
Copy link
Member

Figured it out. There is a new version of Hiberante, so this is now testing against 5.4.2.

The 21 new failed tests are all newly added tests. I've gone through the issue spend some time figuring out what is causing their failures and update the blacklist.
No new issues, just more missing features (e.g. temp tables, recursive CTEs, blobs)

BramGruneir added a commit to BramGruneir/cockroach that referenced this issue Mar 27, 2019
craig bot pushed a commit that referenced this issue Mar 27, 2019
36234: roachtest: update hibernate blacklist for v5.4.2 r=BramGruneir a=BramGruneir

Fixes #36151

Release note: None

Co-authored-by: Bram Gruneir <bram@cockroachlabs.com>
craig bot pushed a commit that referenced this issue Mar 27, 2019
36234: roachtest: update hibernate blacklist for v5.4.2 r=BramGruneir a=BramGruneir

Fixes #36151

Release note: None

Co-authored-by: Bram Gruneir <bram@cockroachlabs.com>
@craig craig bot closed this as completed in #36234 Mar 27, 2019
@scavienger
Copy link

@BramGruneir Hi. I'm testing my application with a Cockroach DB.

Development stack is as following,

Spring Boot 1.5.16
Spring Data JPA 1.11.15
Hibernate 5.0.12
Postgresql 10.x (compatible with MariaDB latest, Oracle 11g)

I'm using Spring Data JPA(Hibernate) in persistence layer.
There were some problems in changing database. (To check a compatibility with various DB.)
I could solve them with the help of this issue space, now I have just one. (Just my wish... 🤣)

I have a domain class, and generate the Primary Key using table sequence strategy.

    @Id
    @GeneratedValue(strategy = GenerationType.TABLE, generator = "seqGenerator")
    @Column(nullable = false, precision = 19, scale = 0)
    private BigInteger id;

Error occurred when application had inserted new data in database.

Error message(captured) is as following,
image2019-8-6_7-34-28

Can you tell me what I to do more?
Please tell me if you don't have enough information.
(Sorry for my broken English 😭)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot.
Projects
None yet
Development

No branches or pull requests

3 participants