You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Gii16 (via GitHub)" <gi...@apache.org> on 2024/05/16 09:02:43 UTC

[I] Exception occurred postgre backend execute DDL statement in transaction [shardingsphere]

Gii16 opened a new issue, #31244:
URL: https://github.com/apache/shardingsphere/issues/31244

   ## Bug Report
   
   
   
   ### Which version of ShardingSphere did you use?
   5.4.0
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   I use a SQL client to send command to ShardingSphere-Proxy and forward to postgre DB. I execute DDL statement in transaction. 
   
   Statements as follow:
   1.begin;
   2.create table table_name;
   3.create index on table_name;
   4.commit;
   
   ### Actual behavior
   There is a null point exception. I lost log in server so I can't display it. However, I know the reason.
   
   ### Reason analyze (If you can)
   Get an exception while execute refreshMetaData() in DatabaseConnector#doExecute(). Cause  the table created in step 2 can not be seen in step3.
   SchemaMetaDataLoaderEngine#load will get another connection to get meta data. There is an isolation between two connections.
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Exception occurred postgre backend execute DDL statement in transaction [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #31244: Exception occurred postgre backend execute DDL statement in transaction
URL: https://github.com/apache/shardingsphere/issues/31244


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Exception occurred postgre backend execute DDL statement in transaction [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #31244:
URL: https://github.com/apache/shardingsphere/issues/31244#issuecomment-2174327433

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Exception occurred postgre backend execute DDL statement in transaction [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #31244:
URL: https://github.com/apache/shardingsphere/issues/31244#issuecomment-3681565894

   Duplicate with #35166


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org