The created table files are not opened for editing

malykholga · February 25, 2025, 11:03am

cdb · February 25, 2025, 11:06am

I am sorry, that you have trouble opening a base:

Run tail -f /opt/seatable-server/seatable/logs/*.log to actively monitor the logs for any relevant errors as you attempt to open the base.
Post the log output here.

It would help, if you support more information. You didn’t write, that you’re using SeaTable 3.3.0 Developer Edition. This version is more than two years old.

By the way, today we released version 5.2.

malykholga · February 25, 2025, 12:04pm

root@4210531-cy13937:/opt/seatable-server# tail -f /opt/seatable-server/seatable/logs/*.log
==> /opt/seatable-server/seatable/logs/dtable-access.2025-02-24.log <==
[2025-02-24 12:45:30] [INFO] requestTime - POST /api/v1/dtables/62e21abc-8648-4c12-b792-95f1876501af/import-exce l/?from=dtable_events&lang=ru 200 425.6ms

==> /opt/seatable-server/seatable/logs/dtable-access.log <==
[2025-02-25 11:47:05] [INFO] requestTime - GET / 403 3.8ms

==> /opt/seatable-server/seatable/logs/dtable-access-slow.log <==

==> /opt/seatable-server/seatable/logs/dtable-db-access.log <==

==> /opt/seatable-server/seatable/logs/dtable-db-error.log <==

==> /opt/seatable-server/seatable/logs/dtable-db.log <==
[2025-02-25 13:26:28] [info] use the default log level: info
[2025-02-25 13:26:28] [fatal] Failed to setup dtable-db: private_key must be specified in the config file
[2025-02-25 13:26:59] [info] use the default log level: info
[2025-02-25 13:26:59] [fatal] Failed to setup dtable-db: private_key must be specified in the config file
[2025-02-25 13:27:06] [info] use the default log level: info
[2025-02-25 13:27:06] [info] Dtable DB started.
[2025-02-25 13:32:06] [info] there is a total of 0.000000MB cache in dtable cache
[2025-02-25 14:32:06] [info] there is a total of 0.000000MB cache in dtable cache
[2025-02-25 14:53:35] [info] use the default log level: info
[2025-02-25 14:53:35] [info] Dtable DB started.

==> /opt/seatable-server/seatable/logs/dtable-db-slow.log <==

==> /opt/seatable-server/seatable/logs/dtable_events_data_sync.log <==

==> /opt/seatable-server/seatable/logs/dtable_events_io.log <==
2025-02-24 12:45:25,790 [INFO] got table: data_parsed.csv, rows: 1764, columns: 2
2025-02-24 12:45:25,813 [INFO] excel json file size: 3447 KB
2025-02-24 12:45:25,874 [INFO] parse excel data_parsed (1).xlsx success!
2025-02-24 12:45:25,874 [INFO] Run task success: 1740390325587 <function parse_excel_csv at 0x7f7794fc2710> cost 0s

2025-02-24 12:45:29,791 [INFO] Run task: 1740390329790 <function import_excel_csv at 0x7f7794fc27a0>
2025-02-24 12:45:29,791 [INFO] Start import excel or csv: 62e21abc-8648-4c12-b792-95f1876501af.
2025-02-24 12:45:30,277 [INFO] import excel or csv data_parsed (1) success!
2025-02-24 12:45:30,277 [INFO] Run task success: 1740390329790 <function import_excel_csv at 0x7f7794fc27a0> cos t 0s

==> /opt/seatable-server/seatable/logs/dtable-events.log <==
[2025-02-25 14:53:35,191] base.py[line:171] [INFO] Scheduler started
[2025-02-25 14:53:35,191] big_data_storage_stats_worker.py[line:61] [INFO] Start big data storage stats worker.
[2025-02-25 14:53:35,191] base.py[line:444] [INFO] Adding job tentatively – it will be properly scheduled when the scheduler starts
[2025-02-25 14:53:35,192] base.py[line:885] [INFO] Added job “BigDataStorageStatsTask.run..timed_job” to job store “default”
[2025-02-25 14:53:35,192] base.py[line:171] [INFO] Scheduler started
[2025-02-25 14:53:35,192] base.py[line:444] [INFO] Adding job tentatively – it will be properly scheduled when the scheduler starts
[2025-02-25 14:53:35,193] base.py[line:885] [INFO] Added job “DataSyncerTimer.run..timed_job” to job sto re “default”
[2025-02-25 14:53:35,193] base.py[line:171] [INFO] Scheduler started
/opt/seatable/seatable-server-latest/dtable-web/thirdpart/apscheduler/util.py:436: PytzUsageWarning: The localiz e method is no longer necessary, as this time zone supports the fold attribute (PEP 495). For more details on mi grating to a PEP 495-compliant implementation, see https://pytz-deprecation-shim.readthedocs.io/en/latest/migrat ion.html
return tzinfo.localize(dt)

==> /opt/seatable-server/seatable/logs/dtable_events_message.log <==

==> /opt/seatable-server/seatable/logs/dtable_events_plugin_email.log <==

==> /opt/seatable-server/seatable/logs/dtables_cleaner.log <==

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-16.log <==
[2025-02-16 23:12:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:17:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:22:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:27:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:32:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:37:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:42:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:47:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:52:59] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-16 23:57:59] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-17.log <==
[2025-02-17 23:13:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:18:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:23:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:28:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:33:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:38:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:43:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:48:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:53:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-17 23:58:00] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-18.log <==
[2025-02-18 23:13:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:18:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:23:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:28:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:33:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:38:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:43:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:48:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:53:00] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-18 23:58:00] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-19.log <==
[2025-02-19 23:13:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:18:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:23:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:28:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:33:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:38:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:43:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:48:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:53:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-19 23:58:30] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-20.log <==
[2025-02-20 23:13:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:18:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:23:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:28:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:33:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:38:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:43:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:48:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:53:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-20 23:58:30] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-21.log <==
[2025-02-21 23:13:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:18:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:23:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:28:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:33:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:38:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:43:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:48:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:53:30] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-21 23:58:30] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-22.log <==
[2025-02-22 23:13:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:18:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:23:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:28:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:33:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:38:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:43:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:48:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:53:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-22 23:58:31] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-23.log <==
[2025-02-23 23:13:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:18:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:23:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:28:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:33:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:38:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:43:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:48:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:53:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-23 23:58:31] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.2025-02-24.log <==
[2025-02-24 23:13:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:18:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:23:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:28:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:33:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:38:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:43:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:48:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:53:31] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-24 23:58:31] [INFO] dtable-manager.js[511] - 0 dtables saved.

==> /opt/seatable-server/seatable/logs/dtable-server.log <==
[2025-02-25 14:17:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:22:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:27:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:32:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:37:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:42:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:47:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:52:07] [INFO] dtable-manager.js[511] - 0 dtables saved.
[2025-02-25 14:53:36] [INFO] index.js[11] - Starting dtable server process: 2365996
[2025-02-25 14:53:36] [INFO] dtable-server.js[47] - listening on port 5000

==> /opt/seatable-server/seatable/logs/dtable-socket.log <==

==> /opt/seatable-server/seatable/logs/dtable-socket-slow.log <==

==> /opt/seatable-server/seatable/logs/dtable-threads.log <==
[2025-02-24 12:45:30] [INFO] index.js[91] - exec api on base ‘62e21abc86484c12b79295f1876501af’ success, api is ‘encapsulateInsertTableOperations’.

==> /opt/seatable-server/seatable/logs/dtable_updates_sender.log <==

[2025-02-25 10:25:38.790479] Start sending dtable updates emails…
[2025-02-25 10:25:38.799819] Finish sending dtable updates emails.

[2025-02-25 12:38:28.037200] Start sending dtable updates emails…
[2025-02-25 12:38:28.045018] Finish sending dtable updates emails.

[2025-02-25 14:27:08.760517] Start sending dtable updates emails…
[2025-02-25 14:27:08.769449] Finish sending dtable updates emails.

==> /opt/seatable-server/seatable/logs/dtable_web.log <==
return self.cursor.execute(sql, params)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/mysql/base.py”, line 73, in execute
return self.cursor.execute(query, args)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/connections.py”, line 254, in query
_mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1146, “Table ‘dtable_db.dtable_seafile_connectors’ doesn’t exist”)

==> /opt/seatable-server/seatable/logs/email_notices_sender.log <==
[2025-02-25 12:38:28.042100] Found 0 dtable notices
[2025-02-25 12:38:28.042129] Finish sending user email notices.

[2025-02-25 14:27:08.776746] Start sending user email notices…
[2025-02-25 14:27:08.787635] Last check time is 2025-02-25 12:38:28.021785, update to 2025-02-25 14:27:08.776781
[2025-02-25 14:27:08.789688] Found 0 notices
[2025-02-25 14:27:08.792344] DTable last check time is UTC 2025-02-25 09:38:28.039099, update to UTC 2025-02-25 11:27:08.789711
[2025-02-25 14:27:08.793199] Found 0 dtable notices
[2025-02-25 14:27:08.793217] Finish sending user email notices.

==> /opt/seatable-server/seatable/logs/logrotate.log <==
renaming /opt/seatable/logs/email_notices_sender.log to /opt/seatable/logs/email_notices_sender.log.2025-02-24
creating new /opt/seatable/logs/email_notices_sender.log mode = 0644 uid = 0 gid = 0
running postrotate script
logrotate_script: 7: kill: No such process

removing old log /opt/seatable/logs/dtable-db.log.2025-02-17
removing old log /opt/seatable/logs/dtable_web.log.2025-02-17
removing old log /opt/seatable/logs/dtable_updates_sender.log.2025-02-17
removing old log /opt/seatable/logs/dtables_cleaner.log.2025-02-16
error: error opening /opt/seatable/logs/dtables_cleaner.log.2025-02-16: No such file or directory

==> /opt/seatable-server/seatable/logs/monitor.log <==
[2025-02-25 13:23:21] Start dtable-db
[2025-02-25 13:23:52] Start dtable-db
[2025-02-25 13:24:23] Start dtable-db
[2025-02-25 13:24:54] Start dtable-db
[2025-02-25 13:25:25] Start dtable-db
[2025-02-25 13:25:56] Start dtable-db
[2025-02-25 13:26:28] Start dtable-db
[2025-02-25 13:26:59] Start dtable-db
[2025-02-25 13:27:06] Start Monitor
[2025-02-25 14:53:35] Start Monitor

==> /opt/seatable-server/seatable/logs/org_dingtalk_oauth.log <==

==> /opt/seatable-server/seatable/logs/org_work_weixin_oauth.log <==

==> /opt/seatable-server/seatable/logs/seafile.log <==
2025-02-25 14:53:32 http-server.c(210): fileserver: fixed_block_size = 8388608
2025-02-25 14:53:32 http-server.c(225): fileserver: web_token_expire_time = 3600
2025-02-25 14:53:32 http-server.c(240): fileserver: max_indexing_threads = 1
2025-02-25 14:53:32 http-server.c(255): fileserver: max_index_processing_threads= 3
2025-02-25 14:53:32 http-server.c(277): fileserver: cluster_shared_temp_file_mode = 600
2025-02-25 14:53:37 start to serve on pipe client
2025-02-25 14:53:37 start to serve on pipe client
2025-02-25 14:53:38 start to serve on pipe client
2025-02-25 14:53:39 start to serve on pipe client
2025-02-25 14:53:40 start to serve on pipe client

==> /opt/seatable-server/seatable/logs/storage-server-access.log <==

==> /opt/seatable-server/seatable/logs/storage-server.log <==
[2025-02-25 11:33:57] failed to query database: dial tcp: lookup db: Temporary failure in name resolution
[2025-02-25 11:34:29] failed to query database: dial tcp: lookup db: Temporary failure in name resolution
[2025-02-25 11:35:01] failed to query database: dial tcp: lookup db: Temporary failure in name resolution
[2025-02-25 11:35:33] failed to query database: dial tcp: lookup db: Temporary failure in name resolution
[2025-02-25 11:36:05] failed to query database: dial tcp: lookup db: Temporary failure in name resolution
[2025-02-25 11:36:38] Dtable storage server started.
[2025-02-25 11:38:25] Dtable storage server started.
[2025-02-25 13:23:21] Dtable storage server started.
[2025-02-25 13:27:06] Dtable storage server started.
[2025-02-25 14:53:35] Dtable storage server started.

==> /opt/seatable-server/seatable/logs/weixin_oauth.log <==

==> /opt/seatable-server/seatable/logs/seafile.log <==
2025-02-25 14:54:20 start to serve on pipe client

==> /opt/seatable-server/seatable/logs/dtable_web.log <==
2025-02-25 14:54:22,467 [ERROR] django.request:230 log_response Internal Server Error: /workspace/5/dtable/Тест/
Traceback (most recent call last):
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/mysql/base.py”, line 73, in execute
return self.cursor.execute(query, args)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/connections.py”, line 254, in query
_mysql.connection.query(self, query)
MySQLdb.ProgrammingError: (1146, “Table ‘dtable_db.dtable_seafile_connectors’ doesn’t exist”)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/handlers/exception.py”, line 47, in inner
response = get_response(request)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/core/handlers/base.py”, line 181, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/opt/seatable/seatable-server-latest/dtable-web/seahub/auth/decorators.py”, line 28, in _wrapped_view
return view_func(request, *args, **kwargs)
File “/opt/seatable/seatable-server-latest/dtable-web/seahub/dtable/views.py”, line 192, in dtable_file_view
seafile_connector = SeafileConnectors.objects.get(dtable=dtable)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/manager.py”, line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py”, line 431, in get
num = len(clone)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py”, line 262, in len
self._fetch_all()
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py”, line 1324, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/query.py”, line 51, in iter
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/models/sql/compiler.py”, line 1175, in execute_sql
cursor.execute(sql, params)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py”, line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py”, line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/utils.py”, line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/django/db/backends/mysql/base.py”, line 73, in execute
return self.cursor.execute(query, args)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/opt/seatable/seatable-server-latest/dtable-web/thirdpart/MySQLdb/connections.py”, line 254, in query
_mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1146, “Table ‘dtable_db.dtable_seafile_connectors’ doesn’t exist”)

cdb · February 25, 2025, 12:09pm

This is the relevant error message. It seems that you database container is called mariadb but in dtable-storage-server.conf you still have host = db. Change that and restart SeaTable.

malykholga · February 25, 2025, 12:12pm

[general]
log_dir = /opt/seatable/logs
temp_file_dir = /tmp/tmp-storage-data

[storage backend]
type = filesystem
path = /opt/seatable/storage-data

[snapshot]
interval = 86400
keep_days = 180

this is what the config file looks like

malykholga · February 25, 2025, 12:45pm

Is it necessary to make changes to this file?

[general]
log_dir = /opt/seatable/logs
temp_file_dir = /tmp/tmp-storage-data

[storage backend]
type = filesystem
path = /opt/seatable/storage-data

[snapshot]
interval = 86400
keep_days = 180

this is what the config file looks like

cdb · February 25, 2025, 12:53pm

Please check the other configuration files and search for host = db.

malykholga · February 25, 2025, 1:04pm

I understand correctly what should be
host = mariadb ?

cdb · February 26, 2025, 8:42am

I don’t understand your question. Check the name of your mariadb container and then add this name to the configuration files. Otherwise SeaTable will not work.

A general recommendation: you’re providing a lot of screenshots and log files, but you never described, what you tried to do. It would help more, if you explain more what you try to do and what you already tried.

malykholga · February 27, 2025, 5:35am

The problem is that when I want to open a newly created database, the error “Page unavailable” is displayed in the tab.
Sorry, but the requested page is unavailable due to a server hiccup.

Our engineers have been notified, so check back later."

log-file:

==> /opt/seatable-server/seatable/logs/dtable-db.log <==
[2025-02-27 08:28:11] [info] use the default log level: info
[2025-02-27 08:28:11] [fatal] Failed to setup dtable-db: private_key must be specified in the config file
[2025-02-27 08:28:42] [info] use the default log level: info
[2025-02-27 08:28:42] [fatal] Failed to setup dtable-db: private_key must be specified in the config file
[2025-02-27 08:29:13] [info] use the default log level: info
[2025-02-27 08:29:13] [fatal] Failed to setup dtable-db: private_key must be specified in the config file
[2025-02-27 08:29:44] [info] use the default log level: info
[2025-02-27 08:29:44] [fatal] Failed to setup dtable-db: private_key must be specified in the config file
[2025-02-27 08:30:15] [info] use the default log level: info
[2025-02-27 08:30:15] [fatal] Failed to setup dtable-db: private_key must be specified in the config file

==> /opt/seatable-server/seatable/logs/dtable-db-slow.log <==

==> /opt/seatable-server/seatable/logs/dtable_events_data_sync.log <==

==> /opt/seatable-server/seatable/logs/dtable_events_io.log <==
2025-02-24 12:45:25,790 [INFO] got table: data_parsed.csv, rows: 1764, columns: 2
2025-02-24 12:45:25,813 [INFO] excel json file size: 3447 KB
2025-02-24 12:45:25,874 [INFO] parse excel data_parsed (1).xlsx success!
2025-02-24 12:45:25,874 [INFO] Run task success: 1740390325587 <function parse_excel_csv at 0x7f7794fc2710> cost 0s

2025-02-24 12:45:29,791 [INFO] Run task: 1740390329790 <function import_excel_csv at 0x7f7794fc27a0>
2025-02-24 12:45:29,791 [INFO] Start import excel or csv: 62e21abc-8648-4c12-b792-95f1876501af.
2025-02-24 12:45:30,277 [INFO] import excel or csv data_parsed (1) success!
2025-02-24 12:45:30,277 [INFO] Run task success: 1740390329790 <function import_excel_csv at 0x7f7794fc27a0> cost 0s

==> /opt/seatable-server/seatable/logs/dtable-events.log <==
[2025-02-27 08:00:00,010] dtable_notification_rules_scanner.py[line:102] [INFO] Starts to scan notification rules…
[2025-02-27 08:00:00,014] base.py[line:144] [INFO] Job “DTableNofiticationRulesScannerTimer.run..timed_job (trigger: cron[day_of_week=‘‘, hour=’’], next run at: 2025-02-27 09:00:00 MSK)” executed successfully
[2025-02-27 08:00:00,015] base.py[line:123] [INFO] Running job “CommonDatasetSyncerTimer.run..timed_job (trigger: cron[day_of_week=‘‘, hour=’’], next run at: 2025-02-27 09:00:00 MSK)” (scheduled at 2025-02-27 08:00:00+03:00)
[2025-02-27 08:00:00,016] common_dataset_syncer.py[line:277] [INFO] Starts to scan common dataset syncs…
[2025-02-27 08:00:00,020] base.py[line:144] [INFO] Job “CommonDatasetSyncerTimer.run..timed_job (trigger: cron[day_of_week=‘‘, hour=’’], next run at: 2025-02-27 09:00:00 MSK)” executed successfully
[2025-02-27 08:01:47,693] email_notices_sender.py[line:70] [INFO] Starts to send email…
[2025-02-27 08:30:00,005] base.py[line:123] [INFO] Running job “DataSyncerTimer.run..timed_job (trigger: cron[day_of_week=‘‘, hour=’’, minute=‘30’], next run at: 2025-02-27 09:30:00 MSK)” (scheduled at 2025-02-27 08:30:00+03:00)
[2025-02-27 08:30:00,006] data_syncer.py[line:113] [INFO] Starts to scan data syncs…
[2025-02-27 08:30:00,014] data_syncer.py[line:99] [INFO] all tasks done
[2025-02-27 08:30:00,014] base.py[line:144] [INFO] Job “DataSyncerTimer.run..timed_job (trigger: cron[day_of_week=‘‘, hour=’’, minute=‘30’], next run at: 2025-02-27 09:30:00 MSK)” executed successfully