之前由于版本升级，数据库升级出错，导致部分表格无法打开，后来通过历史镜像打开，通过历史镜像将相关数据复制粘贴出来到新的表格，但这个老的无法打开的表格无法删除，进入系统管理后台也无法删除，提示“internet server error”，还有什么办法删除这些老的表格？
看开发者手册提供了命令 copy_dtable 来进行表格从一个 workspace 复制到另一个 workspace (跨用户)。用于数据的恢复。
是否也有命令可以进行删除操作？
你可以检查下日志中具体是什么错误。
[2022-12-03 12:49:56] [ERROR] http-service.js[147] - dtable_uuid: 70390233a4b94f01a63329c5a11887a7 - Dtable load failed 70390233a4b94f01a63329c5a11887a7
[2022-12-03 12:50:02] [ERROR] dtable-utils.js[136] - get base d25ab29570844c4d8b6907dc9f940adc download link error Error: Request failed with status code 500
at createError (/opt/seatable/seatable-server-3.2.0/dtable-server/node_modules/axios/lib/core/createError.js:16:15)
at settle (/opt/seatable/seatable-server-3.2.0/dtable-server/node_modules/axios/lib/core/settle.js:17:12)
at IncomingMessage.handleStreamEnd (/opt/seatable/seatable-server-3.2.0/dtable-server/node_modules/axios/lib/adapters/http.js:236:11)
at IncomingMessage.emit (events.js:326:22)
at endReadableNT (_stream_readable.js:1241:12)
at processTicksAndRejections (internal/process/task_queues.js:84:21) {
config: {
url: ‘http://127.0.0.1:8000/api/v2.1/dtable-internal/get-file-download-link/’,
method: ‘get’,
params: { dtable_uuid: ‘d25ab295-7084-4c4d-8b69-07dc9f940adc’ },
headers: {
Accept: ‘application/json, text/plain, /’,
Authorization: ‘Token eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE2NzAwNDMzMDIsImR0YWJsZV91dWlkIjoiZDI1YWIyOTUtNzA4NC00YzRkLThiNjktMDdkYzlmOTQwYWRjIiwiaWF0IjoxNjcwMDQzMDAyfQ.IdSPb7DO3BDmzcDz5Exmgju5-t7Sm8fCe4E3XYxs_uk’,
‘User-Agent’: ‘axios/0.19.2’
},
transformRequest: [ [Function: transformRequest] ],
transformResponse: [ [Function: transformResponse] ],
timeout: 30000,
adapter: [Function: httpAdapter],
xsrfCookieName: ‘XSRF-TOKEN’,
xsrfHeaderName: ‘X-XSRF-TOKEN’,
maxContentLength: -1,
validateStatus: [Function: validateStatus],
data: undefined
},
request: ClientRequest {
_events: [Object: null prototype] {
socket: [Array],
abort: [Function],
aborted: [Function],
error: [Function],
timeout: [Array],
prefinish: [Function: requestOnPrefinish]
},
_eventsCount: 6,
_maxListeners: undefined,
outputData: [],
outputSize: 0,
writable: true,
_last: true,
chunkedEncoding: false,
shouldKeepAlive: false,
_defaultKeepAlive: true,
useChunkedEncodingByDefault: false,
sendDate: false,
_removedConnection: false,
_removedContLen: false,
_removedTE: false,
_contentLength: 0,
_hasBody: true,
_trailer: ‘’,
finished: true,
_headerSent: true,
socket: Socket {
connecting: false,
_hadError: false,
_parent: null,
_host: null,
_readableState: [ReadableState],
readable: true,
_events: [Object: null prototype],
_eventsCount: 7,
_maxListeners: undefined,
_writableState: [WritableState],
writable: false,
allowHalfOpen: false,
_sockname: null,
_pendingData: null,
_pendingEncoding: ‘’,
server: null,
_server: null,
parser: null,
_httpMessage: [Circular],
timeout: 30000,
[Symbol(asyncId)]: 87,
[Symbol(kHandle)]: [TCP],
[Symbol(kSetNoDelay)]: false,
[Symbol(lastWriteQueueSize)]: 0,
[Symbol(timeout)]: Timeout {
_idleTimeout: 30000,
_idlePrev: [TimersList],
_idleNext: [TimersList],
_idleStart: 62797,
_onTimeout: [Function: bound ],
_timerArgs: undefined,
_repeat: null,
_destroyed: false,
[Symbol(refed)]: false,
[Symbol(kHasPrimitive)]: false,
[Symbol(asyncId)]: 93,
[Symbol(triggerId)]: 90
},
[Symbol(kBuffer)]: null,
[Symbol(kBufferCb)]: null,
[Symbol(kBufferGen)]: null,
[Symbol(kCapture)]: false,
[Symbol(kBytesRead)]: 0,
[Symbol(kBytesWritten)]: 0
},
connection: Socket {
connecting: false,
_hadError: false,
_parent: null,
_host: null,
_readableState: [ReadableState],
readable: true,
_events: [Object: null prototype],
_eventsCount: 7,
_maxListeners: undefined,
_writableState: [WritableState],
writable: false,
allowHalfOpen: false,
_sockname: null,
_pendingData: null,
_pendingEncoding: ‘’,
server: null,
_server: null,
parser: null,
_httpMessage: [Circular],
timeout: 30000,
[Symbol(asyncId)]: 87,
[Symbol(kHandle)]: [TCP],
[Symbol(kSetNoDelay)]: false,
[Symbol(lastWriteQueueSize)]: 0,
[Symbol(timeout)]: Timeout {
_idleTimeout: 30000,
_idlePrev: [TimersList],
_idleNext: [TimersList],
_idleStart: 62797,
_onTimeout: [Function: bound ],
_timerArgs: undefined,
_repeat: null,
_destroyed: false,
[Symbol(refed)]: false,
[Symbol(kHasPrimitive)]: false,
[Symbol(asyncId)]: 93,
[Symbol(triggerId)]: 90
},
[Symbol(kBuffer)]: null,
[Symbol(kBufferCb)]: null,
[Symbol(kBufferGen)]: null,
[Symbol(kCapture)]: false,
[Symbol(kBytesRead)]: 0,
[Symbol(kBytesWritten)]: 0
},
_header: ‘GET /api/v2.1/dtable-internal/get-file-download-link/?dtable_uuid=d25ab295-7084-4c4d-8b69-07dc9f940adc HTTP/1.1\r\n’ +
‘Accept: application/json, text/plain, /\r\n’ +
‘Authorization: Token eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE2NzAwNDMzMDIsImR0YWJsZV91dWlkIjoiZDI1YWIyOTUtNzA4NC00YzRkLThiNjktMDdkYzlmOTQwYWRjIiwiaWF0IjoxNjcwMDQzMDAyfQ.IdSPb7DO3BDmzcDz5Exmgju5-t7Sm8fCe4E3XYxs_uk\r\n’ +
‘User-Agent: axios/0.19.2\r\n’ +
‘Host: 127.0.0.1:8000\r\n’ +
‘Connection: close\r\n’ +
‘\r\n’,
_keepAliveTimeout: 0,
_onPendingData: [Function: noopPendingOutput],
agent: Agent {
_events: [Object: null prototype],
_eventsCount: 2,
_maxListeners: undefined,
defaultPort: 80,
protocol: ‘http:’,
options: [Object],
requests: {},
sockets: [Object],
freeSockets: {},
keepAliveMsecs: 1000,
keepAlive: false,
maxSockets: Infinity,
maxFreeSockets: 256,
maxTotalSockets: Infinity,
totalSocketCount: 1,
scheduling: ‘fifo’,
[Symbol(kCapture)]: false
},
socketPath: undefined,
method: ‘GET’,
insecureHTTPParser: undefined,
path: ‘/api/v2.1/dtable-internal/get-file-download-link/?dtable_uuid=d25ab295-7084-4c4d-8b69-07dc9f940adc’,
_ended: true,
res: IncomingMessage {
_readableState: [ReadableState],
readable: false,
_events: [Object: null prototype],
_eventsCount: 3,
_maxListeners: undefined,
socket: [Socket],
connection: [Socket],
httpVersionMajor: 1,
httpVersionMinor: 1,
httpVersion: ‘1.1’,
complete: true,
headers: [Object],
rawHeaders: [Array],
trailers: {},
rawTrailers: [],
aborted: false,
upgrade: false,
url: ‘’,
method: null,
statusCode: 500,
statusMessage: ‘Internal Server Error’,
client: [Socket],
_consuming: false,
_dumped: false,
req: [Circular],
responseUrl: ‘http://127.0.0.1:8000/api/v2.1/dtable-internal/get-file-download-link/?dtable_uuid=d25ab295-7084-4c4d-8b69-07dc9f940adc’,
redirects: [],
[Symbol(kCapture)]: false
},
aborted: false,
timeoutCb: [Function: emitRequestTimeout],
upgradeOrConnect: false,
parser: null,
maxHeadersCount: null,
reusedSocket: false,
host: ‘127.0.0.1’,
protocol: ‘http:’,
_redirectable: Writable {
_writableState: [WritableState],
writable: true,
_events: [Object: null prototype],
_eventsCount: 2,
_maxListeners: undefined,
_options: [Object],
_redirectCount: 0,
_redirects: [],
_requestBodyLength: 0,
_requestBodyBuffers: [],
_onNativeResponse: [Function],
_currentRequest: [Circular],
_currentUrl: ‘http://127.0.0.1:8000/api/v2.1/dtable-internal/get-file-download-link/?dtable_uuid=d25ab295-7084-4c4d-8b69-07dc9f940adc’,
[Symbol(kCapture)]: false
},
[Symbol(kCapture)]: false,
[Symbol(kNeedDrain)]: false,
[Symbol(corked)]: 0,
[Symbol(kOutHeaders)]: [Object: null prototype] {
accept: [Array],
authorization: [Array],
‘user-agent’: [Array],
host: [Array]
}
},
response: {
status: 500,
statusText: ‘Internal Server Error’,
headers: {
server: ‘gunicorn’,
date: ‘Sat, 03 Dec 2022 04:50:02 GMT’,
connection: ‘close’,
‘content-type’: ‘application/json’,
vary: ‘Accept, Accept-Language, Cookie’,
allow: ‘GET, HEAD, OPTIONS’,
‘content-length’: ‘37’,
‘content-language’: ‘en’
},
config: {
url: ‘http://127.0.0.1:8000/api/v2.1/dtable-internal/get-file-download-link/’,
method: ‘get’,
params: [Object],
headers: [Object],
transformRequest: [Array],
transformResponse: [Array],
timeout: 30000,
adapter: [Function: httpAdapter],
xsrfCookieName: ‘XSRF-TOKEN’,
xsrfHeaderName: ‘X-XSRF-TOKEN’,
maxContentLength: -1,
validateStatus: [Function: validateStatus],
data: undefined
},
request: ClientRequest {
_events: [Object: null prototype],
_eventsCount: 6,
_maxListeners: undefined,
outputData: [],
outputSize: 0,
writable: true,
_last: true,
chunkedEncoding: false,
shouldKeepAlive: false,
_defaultKeepAlive: true,
useChunkedEncodingByDefault: false,
sendDate: false,
_removedConnection: false,
_removedContLen: false,
_removedTE: false,
_contentLength: 0,
_hasBody: true,
_trailer: ‘’,
finished: true,
_headerSent: true,
socket: [Socket],
connection: [Socket],
_header: ‘GET /api/v2.1/dtable-internal/get-file-download-link/?dtable_uuid=d25ab295-7084-4c4d-8b69-07dc9f940adc HTTP/1.1\r\n’ +
‘Accept: application/json, text/plain, /\r\n’ +
‘Authorization: Token eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE2NzAwNDMzMDIsImR0YWJsZV91dWlkIjoiZDI1YWIyOTUtNzA4NC00YzRkLThiNjktMDdkYzlmOTQwYWRjIiwiaWF0IjoxNjcwMDQzMDAyfQ.IdSPb7DO3BDmzcDz5Exmgju5-t7Sm8fCe4E3XYxs_uk\r\n’ +
‘User-Agent: axios/0.19.2\r\n’ +
‘Host: 127.0.0.1:8000\r\n’ +
‘Connection: close\r\n’ +
‘\r\n’,
_keepAliveTimeout: 0,
_onPendingData: [Function: noopPendingOutput],
agent: [Agent],
socketPath: undefined,
method: ‘GET’,
insecureHTTPParser: undefined,
path: ‘/api/v2.1/dtable-internal/get-file-download-link/?dtable_uuid=d25ab295-7084-4c4d-8b69-07dc9f940adc’,
_ended: true,
res: [IncomingMessage],
aborted: false,
timeoutCb: [Function: emitRequestTimeout],
upgradeOrConnect: false,
parser: null,
maxHeadersCount: null,
reusedSocket: false,
host: ‘127.0.0.1’,
protocol: ‘http:’,
_redirectable: [Writable],
[Symbol(kCapture)]: false,
[Symbol(kNeedDrain)]: false,
[Symbol(corked)]: 0,
[Symbol(kOutHeaders)]: [Object: null prototype]
},
data: { error_msg: ‘Internal Server Error’ }
},
isAxiosError: true,
toJSON: [Function]
}
[2022-12-03 12:50:02] [ERROR] http-service.js[147] - dtable_uuid: d25ab29570844c4d8b6907dc9f940adc - Dtable load failed d25ab29570844c4d8b6907dc9f940adc
看着也是表格未下载成功