• Hey Guest, we're evolving the future of TeaSpeak.
    You're invited to join the discussion here!

Completed Error DataBase is Locked (Resolved)

When it was to start the service I can not, because it presents this error in the database, already tried to unlock more I could not, can you help me?

Screenshot_1.png
 
I still have the same error :(

[root@vps77792 TeaSpeak-1.2.8-beta-1]# ps aux | grep teaspeak
root 27930 0.0 0.0 112704 964 pts/0 R+ 10:21 0:00 grep --color=auto teaspeak
[root@vps77792 TeaSpeak-1.2.8-beta-1]# ./teastart.sh start
WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
Starting the TeaSpeak server...
Could not start TeaSpeak server.
Last log entries:
[2018-08-20 10:21:41] [DEBUG] Log successfully started!
[2018-08-20 10:21:41] [INFO] GEN | Starting TeaSpeak-Server v1.2.8-beta [Build: 1534452552]
[2018-08-20 10:21:41] [INFO] GEN | Starting music providers
[2018-08-20 10:21:41] [DEBUG] [Music] Provider load order:
[2018-08-20 10:21:41] [DEBUG] [Music] [0] providers/000ProviderFFMpeg.so
[2018-08-20 10:21:41] [DEBUG] [Music] [1] providers/001ProviderYT.so
[2018-08-20 10:21:41] [INFO] [Music] [FFMPEG] Resolved ffmpeg with version "ffmpeg version 4.0.2-static https://johnvansickle.com/ffmpeg/ Copyright (c) 2000-2018 the FFmpeg developers"
[2018-08-20 10:21:41] [INFO] [Music] Loaded successfully provider FFMpeg
[2018-08-20 10:21:42] [INFO] [Music] [YT-DL] Resolved youtube-dl with version 2018.07.21
[2018-08-20 10:21:42] [INFO] [Music] Loaded successfully provider YouTube
[2018-08-20 10:21:43] [DEBUG] GEN | Created a new async thread pool!
[2018-08-20 10:21:43] [INFO] GEN | Upgrading database from version -1 to 3. This could take a moment!

[2018-08-20 10:21:43] [CRITICAL] GEN | Could not initialize SQL!
[2018-08-20 10:21:43] [CRITICAL] GEN | Could not setup SQL tables! Command 'CREATE TABLE IF NOT EXISTS `general` (`key` VARCHAR(256), `value` TEXT)' returns sql: CREATE TABLE IF NOT EXISTS `general` (`key` VARCHAR(256), `value` TEXT) returned -> 1/database is locked

[2018-08-20 10:21:43] [INFO] GEN | Stopping application
[2018-08-20 10:21:43] [INFO] GEN | Application suspend successful!
 

DrN00bish

Well-known member
Edit:
Yeah I totally misread that one lol

Reedit:
I think you have an instance already running of the server. Try ps aux | grep TeaSpeakServer or killall TeaSpeakServer or a soft stop ./teastart.sh stop (probably best if working)
 
Last edited:

schwertle

Member
Yeah seems like
Code:
[root@vps77792 TeaSpeak-1.2.8-beta-1]# ps aux | grep teaspeak
root 27930 0.0 0.0 112704 964 pts/0 R+ 10:21 0:00 grep --color=auto teaspeak
you have a instance already running of the server

Either try kill -9 27930 and then starting a server or killall TeaSpeakServer and then try and start it again.
No, server is not runnig. pid-27930 is "ps aux | grep teaspeak" command.
 
I restarted the server, and did the following processes:

[root@vps77792 TeaSpeak-1.2.8-beta-1]# ./teastart_minimal.sh start
Time 15:49:12 date Aug 16 2018
[INFO] Setting up exception handler
[INFO] Loading configuration
Loading configuration
[INFO] Setting up log
[2018-08-20 10:49:11] [INFO] GEN | Starting TeaSpeak-Server v1.2.8-beta [Build: 1534452552]
[2018-08-20 10:49:11] [INFO] GEN | Starting music providers
[2018-08-20 10:49:11] [INFO] [Music] [FFMPEG] Resolved ffmpeg with version "ffmpeg version 4.0.2-static https://johnvansickle.com/ffmpeg/ Copyright (c) 2000-2018 the FFmpeg developers"
[2018-08-20 10:49:11] [INFO] [Music] Loaded successfully provider FFMpeg
[2018-08-20 10:49:13] [INFO] [Music] [YT-DL] Resolved youtube-dl with version 2018.07.21
[2018-08-20 10:49:13] [INFO] [Music] Loaded successfully provider YouTube
[2018-08-20 10:49:14] [INFO] GEN | Got 4 saved channels
[2018-08-20 10:49:14] [INFO] FILE | Starting server on 0.0.0.0:30303
[2018-08-20 10:49:14] [INFO] QUERY | Starting server on 0.0.0.0:10101
[2018-08-20 10:49:14] [INFO] GEN | Generating server puzzles...
[2018-08-20 10:49:14] [INFO] GEN | Puzzles generated! Time required: 179ms
[2018-08-20 10:49:14] [INFO] GLOBL | Required 94ms to preload the startup cache. Cache needs 0mb
[2018-08-20 10:49:14] [INFO] 1 | Got 4 saved channels
[2018-08-20 10:49:14] [INFO] 1 | Starting server
[2018-08-20 10:49:14] [INFO] 1 | Started server on 0.0.0.0:9987 | :::9987.
[2018-08-20 10:49:14] [INFO] 1 | Starting web server on 0.0.0.0:9987
[2018-08-20 10:49:14] [INFO] GLOBL | Loaded 1 servers within 23ms. Server/sec: 1.000000
[2018-08-20 10:49:14] [INFO] GEN | [WebList] Sending new report.
[2018-08-20 10:49:19] [ERROR] GEN | [WebList] Invalid web manager key response (-1) Error Resource temporarily unavailable
[2018-08-20 10:49:30] [INFO] GEN | License successfully validated!
Ctrl A+D
[root@vps77792 TeaSpeak-1.2.8-beta-1]# ./teastart.sh start
WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
Starting the TeaSpeak server..
Could not start TeaSpeak server.
Last log entries:
[2018-08-20 10:50:56] [DEBUG] Log successfully started!
[2018-08-20 10:50:56] [INFO] GEN | Starting TeaSpeak-Server v1.2.8-beta [Build: 1534452552]
[2018-08-20 10:50:56] [INFO] GEN | Starting music providers
[2018-08-20 10:50:56] [DEBUG] [Music] Provider load order:
[2018-08-20 10:50:56] [DEBUG] [Music] [0] providers/000ProviderFFMpeg.so
[2018-08-20 10:50:56] [DEBUG] [Music] [1] providers/001ProviderYT.so
[2018-08-20 10:50:56] [INFO] [Music] [FFMPEG] Resolved ffmpeg with version "ffmpeg version 4.0.2-static https://johnvansickle.com/ffmpeg/ Copyright (c) 2000-2018 the FFmpeg developers"
[2018-08-20 10:50:56] [INFO] [Music] Loaded successfully provider FFMpeg
[2018-08-20 10:50:57] [INFO] [Music] [YT-DL] Resolved youtube-dl with version 2018.07.21
[2018-08-20 10:50:57] [INFO] [Music] Loaded successfully provider YouTube
[2018-08-20 10:50:58] [DEBUG] GEN | Created a new async thread pool!
[2018-08-20 10:50:58] [INFO] GEN | Upgrading database from version -1 to 3. This could take a moment!
[2018-08-20 10:50:58] [CRITICAL] GEN | Could not initialize SQL!
[2018-08-20 10:50:58] [CRITICAL] GEN | Could not setup SQL tables! Command 'CREATE TABLE IF NOT EXISTS `general` (`key` VARCHAR(256), `value` TEXT)' returns sql: CREATE TABLE IF NOT EXISTS `general` (`key` VARCHAR(256), `value` TEXT) returned -> 1/database is locked
[2018-08-20 10:50:58] [INFO] GEN | Stopping application
[2018-08-20 10:50:58] [INFO] GEN | Application suspend successful!
[root@vps77792 TeaSpeak-1.2.8-beta-1]#


Print Tea*Speak:
: Screenshot_1.png
 

DrN00bish

Well-known member
Alright try: screen -ls
If there's a screen already opened you can screen -r 382.pts-0.vm (or whatever name it has)
If nothing is running and nothing showing on the ps aux | grep TeaSpeakServer you can just delete the files TeaData.sqlite, TeaData.sqlite-shm and TeaData.sqlite-wal if present.

Also I notice you did CTRL+A+D there in the middle of it all. It shouldn't be needed unless you ran screen prior to using it

In other words:
Code:
screen
./teastart_minimal.sh
CTRL+A+D
and then you can do screen -r to resume the detached screen. But do not do ./teastart.sh start after you detached the screen with CTRL+A+D or you're just trying to start the server twice

You might as well just delete the whole folder if there is nothing worth saving on the server yet and then try again.
 
Last edited:
I did what you mentioned I did not start, and even then it does not connect to TS when I do the command ./teastart.sh start gives the same error "database is locked"

[root@vps77792 TeaSpeak-1.2.8-beta-1]# ./teastart_minimal.sh
Time 15:49:12 date Aug 16 2018
[INFO] Setting up exception handler
[INFO] Loading configuration
Loading configuration
[INFO] Setting up log
[2018-08-20 11:24:57] [INFO] GEN | Starting TeaSpeak-Server v1.2.8-beta [Build: 1534452552]
[2018-08-20 11:24:57] [INFO] GEN | Starting music providers
[2018-08-20 11:24:57] [INFO] [Music] [FFMPEG] Resolved ffmpeg with version "ffmpeg version 4.0.2-static https://johnvansickle.com/ffmpeg/ Copyright (c) 2000-2018 the FFmpeg developers"
[2018-08-20 11:24:57] [INFO] [Music] Loaded successfully provider FFMpeg
[2018-08-20 11:24:58] [INFO] [Music] [YT-DL] Resolved youtube-dl with version 2018.07.21
[2018-08-20 11:24:58] [INFO] [Music] Loaded successfully provider YouTube
[2018-08-20 11:24:59] [INFO] GEN | Upgrading database from version -1 to 3. This could take a moment!
[2018-08-20 11:25:00] [INFO] GEN | Got 0 saved channels
[2018-08-20 11:25:00] [INFO] GEN | Generating default tree
[2018-08-20 11:25:00] [INFO] FILE | Starting server on 0.0.0.0:30303
[2018-08-20 11:25:00] [INFO] GEN | ------------------ [Server Query] ------------------
[2018-08-20 11:25:00] [INFO] GEN | New Admin Server Query login credentials generated
[2018-08-20 11:25:00] [INFO] GEN | Username: serveradmin
[2018-08-20 11:25:00] [INFO] GEN | Password: B8d70G4
[2018-08-20 11:25:00] [INFO] GEN | ------------------ [Server Query] ------------------
[2018-08-20 11:25:00] [INFO] QUERY | Starting server on 0.0.0.0:10101
[2018-08-20 11:25:00] [INFO] GEN | Generating server puzzles...
[2018-08-20 11:25:00] [INFO] GEN | Puzzles generated! Time required: 182ms
[2018-08-20 11:25:00] [INFO] GLOBL | Required 58ms to preload the startup cache. Cache needs 0mb
[2018-08-20 11:25:00] [INFO] GLOBL | Loaded 0 servers within 0ms. Server/sec: 0.000000
[2018-08-20 11:25:00] [INFO] GLOBL | Creating new TeaSpeak server...
[2018-08-20 11:25:00] [INFO] 1 | Got 0 saved channels
[2018-08-20 11:25:00] [INFO] 1 | Creating new channel tree (Copy from server 0)
[2018-08-20 11:25:00] [INFO] 1 | Got 4 saved channels
[2018-08-20 11:25:00] [INFO] 1 | ---------------------- Token ----------------------
[2018-08-20 11:25:00] [INFO] 1 | The server's serveradmin token:
[2018-08-20 11:25:00] [INFO] 1 | fVyhfqxhBhExYmjUD0XI
[2018-08-20 11:25:00] [INFO] 1 |
[2018-08-20 11:25:00] [INFO] 1 | Note: This token could be used just once!
[2018-08-20 11:25:00] [INFO] 1 | ---------------------- Token ----------------------
[2018-08-20 11:25:00] [INFO] 1 | Started server on 0.0.0.0:9987 | :::9987.
[2018-08-20 11:25:00] [INFO] 1 | Starting web server on 0.0.0.0:9987
[2018-08-20 11:25:00] [INFO] GEN | [WebList] Sending new report.
[2018-08-20 11:25:05] [ERROR] GEN | [WebList] Invalid web manager key response (-1) Error Resource temporarily unavailable
[2018-08-20 11:25:15] [INFO] GEN | License successfully validated!


Print TS3
Screenshot_1.png
[root@vps77792 TeaSpeak-1.2.8-beta-1]# ls
buildVersion.txt logs TeaData.sqlitedb-wal
certs protocol_key.txt tealoop.sh
commanddocs providers TeaSpeakServer
config.yml query_ip_blacklist.txt teastart_autorestart.sh
files query_ip_whitelist.txt teastart_minimal.sh
geoloc resources teastart.sh
libs TeaData.sqlitedb testDB.sql
[root@vps77792 TeaSpeak-1.2.8-beta-1]# ./teastart.sh start
WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
Starting the TeaSpeak server...
Could not start TeaSpeak server.
Last log entries:
[2018-08-20 11:29:11] [DEBUG] Log successfully started!
[2018-08-20 11:29:11] [INFO] GEN | Starting TeaSpeak-Server v1.2.8-beta [Build: 1534452552]
[2018-08-20 11:29:11] [INFO] GEN | Starting music providers
[2018-08-20 11:29:11] [DEBUG] [Music] Provider load order:
[2018-08-20 11:29:11] [DEBUG] [Music] [0] providers/000ProviderFFMpeg.so
[2018-08-20 11:29:11] [DEBUG] [Music] [1] providers/001ProviderYT.so
[2018-08-20 11:29:11] [INFO] [Music] [FFMPEG] Resolved ffmpeg with version "ffmpeg version 4.0.2-static https://johnvansickle.com/ffmpeg/ Copyright (c) 2000-2018 the FFmpeg developers"
[2018-08-20 11:29:11] [INFO] [Music] Loaded successfully provider FFMpeg
[2018-08-20 11:29:12] [INFO] [Music] [YT-DL] Resolved youtube-dl with version 2018.07.21
[2018-08-20 11:29:12] [INFO] [Music] Loaded successfully provider YouTube
[2018-08-20 11:29:13] [DEBUG] GEN | Created a new async thread pool!
[2018-08-20 11:29:13] [INFO] GEN | Upgrading database from version -1 to 3. This could take a moment!
[2018-08-20 11:29:13] [CRITICAL] GEN | Could not initialize SQL!
[2018-08-20 11:29:13] [CRITICAL] GEN | Could not setup SQL tables! Command 'CREATE TABLE IF NOT EXISTS `general` (`key` VARCHAR(256), `value` TEXT)' returns sql: CREATE TABLE IF NOT EXISTS `general` (`key` VARCHAR(256), `value` TEXT) returned -> 1/database is locked
[2018-08-20 11:29:13] [INFO] GEN | Stopping application
[2018-08-20 11:29:13] [INFO] GEN | Application suspend successful!
[root@vps77792 TeaSpeak-1.2.8-beta-1]#