Stuck on Creating New Table

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 新建表卡主

| username: TiDBer_yBunUeUc

The newly installed cluster gets stuck when creating a new table:




| username: Jjjjayson_zeng | Original post link

I guess there might be some kind of synchronization task using this table, but it might be stuck due to the lack of a primary key (just my guess).

| username: TiDBer_yBunUeUc | Original post link

That’s not right, I tried it with another random table and it’s still the same.

| username: 路在何chu | Original post link

Check if there are any errors in the logs.

| username: Jjjjayson_zeng | Original post link

Do you have logs? I can’t say for sure either.

| username: 饭光小团 | Original post link

We have encountered this issue before, where creating a table is very slow, but admin show ddl jobs shows success. We suspect that there might be some problem during the synchronization of schema version information.

| username: 像风一样的男子 | Original post link

Is the cluster status normal?

| username: TiDBer_yBunUeUc | Original post link

Normal

| username: TiDBer_yBunUeUc | Original post link

Yes, the current phenomenon seems to be this issue.

| username: TiDBer_yBunUeUc | Original post link

There are no errors in the logs, it’s just slow, but it can be seen as successful.

| username: 像风一样的男子 | Original post link

Check the dashboard monitoring to see if there are any anomalies.

| username: TIDB-Learner | Original post link

I haven’t encountered this before, but here’s a guess: 1. Check the time on each server. Is NTP configured?

| username: 连连看db | Original post link

You can check the status of region creation.

| username: h5n1 | Original post link

Pre-split regions and waiting for scheduling and balancing all take time. Try removing this and see.

| username: TiDBer_yBunUeUc | Original post link

It was fine before, very fast. Removing it is also very fast.

| username: 小龙虾爱大龙虾 | Original post link

Has the tidb_scatter_region parameter been adjusted?

| username: h5n1 | Original post link

Was this before enabling tidb_scatter_region?

| username: TiDBer_yBunUeUc | Original post link

No adjustments were made, it was already running. After taking the newly added KV node offline, it returned to normal. Suspecting it might be a server issue, will investigate further.

| username: tidb狂热爱好者 | Original post link

It seems that your servers have many issues.

| username: TiDBer_yBunUeUc | Original post link

There are many issues with building your own data center.