部分表格打不开,提示服务器内部错误,升级3.1后升级数据库提示错误,升级3.2升级数据库还是有错误

部分表格打不开,提示服务器内部错误,怀疑是数据升级的问题,升级3.1后升级数据库提示错误,升级3.2升级数据库还是有错误,怎么处理?

root@d328393198f9:/opt/seatable# seatable.sh upgrade-sql 3.1
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 113: Unknown column ‘is_current’ in ‘where clause’

root@d328393198f9:/opt/seatable# seatable.sh upgrade-sql 3.2
/opt/seatable/scripts/seatable.sh: line 107: /opt/seatable/seatable-server-latest/sql/mysql/upgrade/3.2/dtable.sql: No such file or directory

建议对照下数据库升级语句文件 /opt/seatable/seatable-server-latest/sql/mysql/upgrade/3.2/dtable.sql , 看看数据库表的状态对不对。不对的话,可以手工执行语句。

进行手动执行DELETE FROM dtable_workflow_task_participants WHERE is_current=0;
错误依旧,连接数据库查看,


可能没有这一行导致的。
3.2的错误也有点类似。
但现在有些表格打不开,是什么原因造成的?

补充图片,部分表格正常,部分表格又提示错误,怎么解决?

部分表格打不开,如何处理,有些数据还是比较重要的

你这边报错 500,服务器错误,看一下服务器日志,具体的错误信息是什么?

这个有点意思,你看一下 server 日志

[2022-10-19 11:18:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2022-10-19 11:23:01] [INFO] dtable-manager.js[631] - dtable 1a4faf4791404bf2beb06e0a0840082e update success.
[2022-10-19 11:23:01] [INFO] dtable-manager.js[511] - 1 dtables saved.
[2022-10-19 11:27:21] [ERROR] dtable-utils.js[136] - get base 70390233a4b94f01a63329c5a11887a7 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: ‘70390233-a4b9-4f01-a633-29c5a11887a7’ },
headers: {
Accept: ‘application/json, text/plain, /’,
Authorization: ‘Token eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE2NjYxNTAzNDEsImR0YWJsZV91dWlkIjoiNzAzOTAyMzMtYTRiOS00ZjAxLWE2MzMtMjljNWExMTg4N2E3IiwiaWF0IjoxNjY2MTUwMDQxfQ.iz5BkIzwllEmp5UtHNvijdC8B1MXtDAuxlVEOmSFSPw’,
‘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)]: 64021,
[Symbol(kHandle)]: [TCP],
[Symbol(kSetNoDelay)]: false,
[Symbol(lastWriteQueueSize)]: 0,
[Symbol(timeout)]: Timeout {
_idleTimeout: 30000,
_idlePrev: [TimersList],
_idleNext: [Timeout],
_idleStart: 64709097,
_onTimeout: [Function: bound ],
_timerArgs: undefined,
_repeat: null,
_destroyed: false,
[Symbol(refed)]: false,
[Symbol(kHasPrimitive)]: false,
[Symbol(asyncId)]: 64027,
[Symbol(triggerId)]: 64024
},
[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)]: 64021,
[Symbol(kHandle)]: [TCP],
[Symbol(kSetNoDelay)]: false,
[Symbol(lastWriteQueueSize)]: 0,
[Symbol(timeout)]: Timeout {
_idleTimeout: 30000,
_idlePrev: [TimersList],
_idleNext: [Timeout],
_idleStart: 64709097,
_onTimeout: [Function: bound ],
_timerArgs: undefined,
_repeat: null,
_destroyed: false,
[Symbol(refed)]: false,
[Symbol(kHasPrimitive)]: false,
[Symbol(asyncId)]: 64027,
[Symbol(triggerId)]: 64024
},
[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=70390233-a4b9-4f01-a633-29c5a11887a7 HTTP/1.1\r\n’ +
‘Accept: application/json, text/plain, /\r\n’ +
‘Authorization: Token eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE2NjYxNTAzNDEsImR0YWJsZV91dWlkIjoiNzAzOTAyMzMtYTRiOS00ZjAxLWE2MzMtMjljNWExMTg4N2E3IiwiaWF0IjoxNjY2MTUwMDQxfQ.iz5BkIzwllEmp5UtHNvijdC8B1MXtDAuxlVEOmSFSPw\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=70390233-a4b9-4f01-a633-29c5a11887a7’,
_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=70390233-a4b9-4f01-a633-29c5a11887a7’,
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=70390233-a4b9-4f01-a633-29c5a11887a7’,
[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: ‘Wed, 19 Oct 2022 03:27:21 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=70390233-a4b9-4f01-a633-29c5a11887a7 HTTP/1.1\r\n’ +
‘Accept: application/json, text/plain, /\r\n’ +
‘Authorization: Token eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE2NjYxNTAzNDEsImR0YWJsZV91dWlkIjoiNzAzOTAyMzMtYTRiOS00ZjAxLWE2MzMtMjljNWExMTg4N2E3IiwiaWF0IjoxNjY2MTUwMDQxfQ.iz5BkIzwllEmp5UtHNvijdC8B1MXtDAuxlVEOmSFSPw\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=70390233-a4b9-4f01-a633-29c5a11887a7’,
_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-10-19 11:27:21] [ERROR] http-service.js[147] - dtable_uuid: 70390233a4b94f01a63329c5a11887a7 - Dtable load failed 70390233a4b94f01a63329c5a11887a7

@Devin 这里可能是服务器无法获取 base 下载链接

需要怎么处理解决?

因为你本地 3.1 已经数据库升级错误了,我想一下啊

跟数据库升级有关系吗?错误出现在DELETE FROM dtable_workflow_task_participants WHERE is_current=0;这句话,是这张表出现问题导致打不开吗?那是不是修复这个表就可以了?感觉不太对,这个表我打开过,里面没有什么相关的内容。

因为你升级 3.1 就有问题,现在 3.2 版本还是有问题,这个不好排查根本问题。能否试下:

第一种:本地备份一下数据,然后本地重新部署试 3.2 版本,看是否正常?

第二种:你导出表格的数据,然后在 cloud.seatable.cn 云端模式下导入使用,这样就不需要考虑本地的数据库的报错,可以正常使用。

通过历史镜像可以打开,目前通过历史镜像将相关数据复制粘贴出来到新的表格,但这个老的表格无法删除,进入系统管理后台也无法删除,提示“internet server error”,那我还有什么办法删除这些老的表格?

你这个问题,我这两天也遇到了。估计意外断电造成的。
我先后用hddreg fsck 全盘扫描,确认磁盘无坏道,文件有两个小问题,已修复,故障依旧。
后终于看到这篇文章https://docs.seatable.cn/published/seatable-manual/maintain/seafile_fsck.md,查出文件损坏,修复之。故障消除。

在这儿也算记录下。
这个软件总统使用感受不错,但缺少专业人士指导,出现问题,个人解决难度大。

1 个赞