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

A problem when using transaction #1204

Closed
villainess-y opened this issue Aug 29, 2018 · 3 comments
Closed

A problem when using transaction #1204

villainess-y opened this issue Aug 29, 2018 · 3 comments

Comments

@villainess-y
Copy link

For English only, other languages we will close it directly.

Please answer these questions before submitting your issue. Thanks!

Which version of Sharding-Sphere do you using?

3.0.0.M2

Which project do you using? Sharding-JDBC or Sharding-Proxy?

JDBC

Expected behavior

Successfully created transaction log table

Actual behavior

org.postgresql.util.PSQLException:
CREATE TABLE IF NOT EXISTS transaction_log (id VARCHAR(40) NOT NULL, transaction_type VARCHAR(30) NOT NULL, data_source VARCHAR(255) NOT NULL, sql TEXT NOT NULL, parameters TEXT NOT NULL, creation_time LONG NOT NULL, async_delivery_try_times INT NOT NULL DEFAULT 0, PRIMARY KEY (id));

Reason analyze

transactionManager.init().createtable();
PostgreSQL does not recognize quotes

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc

For bug report, please MUST provide the reproduce example codes (such as a github link).

@terrymanu
Copy link
Member

terrymanu commented Aug 29, 2018

  1. What is the original SQL? I don't see any quotes in your SQL.
  2. What is the full exception tracing? I don't where the exception thrown, form Sharding-JDBC or PostgreSQL?
  3. How to reproduce it? What is your sharding rule configuration?
  4. What is the sql.show? We need that to know what is really happen.

Cloud you fill all information we need?

@villainess-y
Copy link
Author

You didn't see the quotes because I forgot the markdown syntax rules to recognize the quotes

image

There is a create table statement in this function
image

There is the database log information
image

@terrymanu
Copy link
Member

BASE transaction will refactor in future, just reference #1190
So I just close this issue for now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants