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