You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/12/07 10:15:34 UTC

[GitHub] [shardingsphere] oneslideicywater opened a new issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

oneslideicywater opened a new issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978


   connect to the database `sharding_db`,which is a logical  postgresql database(use sharding-proxy for database-spliting). when I am using some database client-tools,such as navicat,pg_dump.
   
   It always complain that I don't specify client-encoding, even I indeed do it already:
   
   ```bash
   root@a15d5aac4a11:/var/lib/postgresql/data# pg_dump -E UTF8 -U postgres -d sharding_db -h 192.168.10.53 -p 13308 > test.sql
   pg_dump: [archiver (db)] connection to database "sharding_db" failed: ERROR:  Null charset name
   ``` 


-- 
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



[GitHub] [shardingsphere] oneslideicywater closed issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
oneslideicywater closed issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978


   


-- 
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



[GitHub] [shardingsphere] oneslideicywater commented on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
oneslideicywater commented on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-988620559


   @TeslaCN It's very nice that I successfully build an image `apache/shardingsphere-proxy:5.0.1-SNAPSHOT`, the previous problem solved!. 
   
   
   
   but there's another question occurs:
   
   using pg_dump dump the logical database `sharding_db` (with postgis extension enabled using `CREATE EXTENSION postgis;`) failed:
   
   ```bash
   root@a15d5aac4a11:/var/lib/postgresql/data# pg_dump -U postgres -d sharding_db -h 192.168.10.53 -p 13308 > test.sql
   Password: 
   pg_dump: [archiver (db)] query failed: ERROR:  You have an error in your SQL syntax
   pg_dump: [archiver (db)] query was: LOCK TABLE public.spatial_ref_sys IN ACCESS SHARE MODE
   ```
   
   but dump the physical database( not proxyed by sharding-proxy) is ok :
   
   ```bash
   pg_dump -U postgres -d geo -h 192.168.10.53 -p 5432 > test.sql
   ```
   
   


-- 
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



[GitHub] [shardingsphere] TeslaCN commented on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-988455141


   Sorry for the inconvenience. Could you try building one by yourself?
   Refer to the wiki https://github.com/apache/shardingsphere/wiki


-- 
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



[GitHub] [shardingsphere] TeslaCN edited a comment on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
TeslaCN edited a comment on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-987812468


   Hi @oneslideicywater 
   This issue is duplicated with #13576. This problem has been fixed in master branch.


-- 
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



[GitHub] [shardingsphere] oneslideicywater commented on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
oneslideicywater commented on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-988427738


   @TeslaCN How can I get the master branch's latest docker image cuz I don't use it in production.


-- 
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



[GitHub] [shardingsphere] TeslaCN commented on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-987812468


   Hi @oneslideicywater 
   This issue is duplicated with #13576.


-- 
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



[GitHub] [shardingsphere] TeslaCN commented on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-988677661


   Hi @oneslideicywater 
   About the `pg_dump`, could you create another issue? I think this issue is done.


-- 
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



[GitHub] [shardingsphere] oneslideicywater edited a comment on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
oneslideicywater edited a comment on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-988620559


   @TeslaCN It's very nice that I successfully build an image `apache/shardingsphere-proxy:5.0.1-SNAPSHOT`, the previous problem solved!. 
   
   
   
   but there's another question occurs:
   
   dump the logical database `sharding_db` (with postgis extension enabled using `CREATE EXTENSION postgis;`) 
    failed when using pg_dump  
   :
   
   ```bash
   root@a15d5aac4a11:/var/lib/postgresql/data# pg_dump -U postgres -d sharding_db -h 192.168.10.53 -p 13308 > test.sql
   Password: 
   pg_dump: [archiver (db)] query failed: ERROR:  You have an error in your SQL syntax
   pg_dump: [archiver (db)] query was: LOCK TABLE public.spatial_ref_sys IN ACCESS SHARE MODE
   ```
   
   but dump the physical database( not proxyed by sharding-proxy) is ok :
   
   ```bash
   pg_dump -U postgres -d geo -h 192.168.10.53 -p 5432 > test.sql
   ```
   
   


-- 
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



[GitHub] [shardingsphere] oneslideicywater edited a comment on issue #13978: connection to database "sharding_db" failed: ERROR: Null charset name

Posted by GitBox <gi...@apache.org>.
oneslideicywater edited a comment on issue #13978:
URL: https://github.com/apache/shardingsphere/issues/13978#issuecomment-988427738


   @TeslaCN How can I get the master branch's latest docker image  of sharding-proxy , cuz I don't use it in production.


-- 
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