search

g0ldyy / comet

Stremio's fastest torrent/debrid search add-on.
MIT License
135 stars 24 forks source link

FATAL: database "zilean" does not exist #105

Closed Telkaoss closed 2 weeks ago

Telkaoss commented 3 weeks ago 
2024-08-18 19:56:57.178 UTC [1] LOG:  starting PostgreSQL 16.3 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
2024-08-18 19:56:57.178 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-08-18 19:56:57.178 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-08-18 19:56:57.192 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-08-18 19:56:57.206 UTC [56] LOG:  database system was shut down at 2024-08-18 19:56:57 UTC
2024-08-18 19:56:57.239 UTC [1] LOG:  database system is ready to accept connections
2024-08-18 19:56:57.735 UTC [60] FATAL:  database "zilean" does not exist
2024-08-18 19:56:57.886 UTC [61] FATAL:  database "zilean" does not exist
2024-08-18 19:56:57.918 UTC [62] FATAL:  database "zilean" does not exist
2024-08-18 19:57:50.795 UTC [54] LOG:  checkpoint starting: wal
2024-08-18 19:58:13.429 UTC [54] LOG:  checkpoint complete: wrote 12226 buffers (74.6%); 0 WAL file(s) added, 0 removed, 33 recycled; write=22.525 s, sync=0.075 s, total=22.634 s; sync files=329, longest=0.015 s, average=0.001 s; distance=537818 kB, estimate=537818 kB; lsn=0/3FF001E0, redo lsn=0/22226688
2024-08-18 19:58:15.880 UTC [54] LOG:  checkpoints are occurring too frequently (25 seconds apart)
2024-08-18 19:58:15.880 UTC [54] HINT:  Consider increasing the configuration parameter "max_wal_size".
2024-08-18 19:58:15.880 UTC [54] LOG:  checkpoint starting: wal
2024-08-18 19:58:36.387 UTC [54] LOG:  checkpoint complete: wrote 11975 buffers (73.1%); 0 WAL file(s) added, 0 removed, 33 recycled; write=20.379 s, sync=0.046 s, total=20.507 s; sync files=9, longest=0.012 s, average=0.006 s; distance=539406 kB, estimate=539406 kB; lsn=0/610753D0, redo lsn=0/430EA178
^Ccontext canceled

EROR | "Zilean.Database.Services.TorrentInfoService" | Error finding unfiltered dmm entries.
Npgsql.PostgresException: 22023: 40 is outside the valid range for parameter
"pg_trgm.similarity_threshold" (0 .. 1)
  at async ValueTask<IBackendMessage> 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<TResult>.
     GetResult(short token)
  at async ValueTask<IBackendMessage> Npgsql.NpgsqlDataReader.
     <ReadMessage>g__ReadMessageSequential|49_0(NpgsqlConnector connector, bool
     async)
  at async Task<bool> Npgsql.NpgsqlDataReader.NextResult(bool async, bool
     isConsuming, CancellationToken cancellationToken)
  at async Task<bool> Npgsql.NpgsqlDataReader.NextResult(bool async, bool
     isConsuming, CancellationToken cancellationToken)
  at async ValueTask<NpgsqlDataReader> Npgsql.NpgsqlCommand.ExecuteReader(bool
     async, CommandBehavior behavior, CancellationToken cancellationToken)
  at async ValueTask<NpgsqlDataReader> Npgsql.NpgsqlCommand.ExecuteReader(bool
     async, CommandBehavior behavior, CancellationToken cancellationToken)
  at async Task<DbDataReader> Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(
     CommandBehavior behavior, CancellationToken cancellationToken)
  at async Task<IEnumerable<T>> Dapper.SqlMapper.QueryAsync<T>(IDbConnection cnn
     , Type effectiveType, CommandDefinition command) in /_/Dapper/
     SqlMapper.Async.cs:434
  at void
     Zilean.Database.Services.TorrentInfoService.<>c__DisplayClass4_0.<<SearchFo
     rTorrentInfoFiltered>b__0>d.MoveNext() in
     /build/src/Zilean.Database/Services/TorrentInfoService.cs:108
  at async Task<TResult> Zilean.Database.Services.BaseDapperService.
     ExecuteCommandAsync<TResult>(Func<NpgsqlConnection, Task<TResult>>
     operation, string errorMessage, CancellationToken cancellationToken) in
     /build/src/Zilean.Database/Services/BaseDapperService.cs:31
  at async Task<TResult> Zilean.Database.Services.BaseDapperService.
     ExecuteCommandAsync<TResult>(Func<NpgsqlConnection, Task<TResult>>
     operation, string errorMessage, CancellationToken cancellationToken) in
     /build/src/Zilean.Database/Services/BaseDapperService.cs:32

j'ai retourné le truc dans tous les sens, ça a fonctionné pendant un temps mais la database disparaît à chaque fois j'ai meme essayé de l'a rajouter à postgres, sans sucess j'ai aussi compose down avec les volumes.

g0ldyy commented 3 weeks ago

https://github.com/iPromKnight/zilean/blob/main/compose.yaml

essaye avec ce compose

Telkaoss commented 3 weeks ago

toujours pas, j'ai meme refais une installation propre ça a fonctionné 2h puis :

__rage=0.002 s; distance=7 kB, estimate=101743 kB; lsn=0/EC5C8DA8, redo lsn=0/EC5C8D70
2024-08-21 16:28:25.872 UTC [17311] ERROR:  relation "__efmigrationshistory" does not exist at character 15
2024-08-21 16:28:25.872 UTC [17311] STATEMENT:  SELECT * FROM __EFMigrationsHistory LIMIT 20;
2024-08-21 16:28:26.184 UTC [17313] FATAL:  database "template0" is not currently accepting connections
2024-08-21 16:28:27.503 UTC [17316] ERROR:  cannot drop the currently open database
2024-08-21 16:28:27.503 UTC [17316] STATEMENT:  DROP DATABASE postgres;
2024-08-21 16:28:27.600 UTC [56] LOG:  checkpoint starting: immediate force wait
2024-08-21 16:28:27.609 UTC [56] LOG:  checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.002 s, total=0.009 s; sync files=1, longest=0.002 s, average=0.002 s; distance=12 kB, estimate=91570 kB; lsn=0/EC5CBFE8, redo lsn=0/EC5CBFB0
2024-08-21 16:29:22.866 UTC [17367] FATAL:  database "zilean" does not exist
2024-08-21 16:33:27.700 UTC [56] LOG:  checkpoint starting: time
2024-08-21 16:34:59.996 UTC [56] LOG:  checkpoint complete: wrote 923 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=92.267 s, sync=0.024 s, total=92.297 s; sync files=301, longest=0.001 s, average=0.001 s; distance=4272 kB, estimate=82840 kB; lsn=0/EC9F82E8, redo lsn=0/EC9F82B0
2024-08-21 17:00:14.305 UTC [18762] FATAL:  database "zilean" does not exist
2024-08-21 18:00:01.437 UTC [21485] FATAL:  unsupported frontend protocol 0.0: server supports 3.0 to 3.0
2024-08-21 18:00:01.764 UTC [21486] FATAL:  unsupported frontend protocol 255.255: server supports 3.0 to 3.0
2024-08-21 18:00:02.088 UTC [21487] FATAL:  no PostgreSQL user name specified in startup packet
2024-08-21 18:00:13.809 UTC [21496] FATAL:  database "zilean" does not exist
2024-08-21 18:17:34.838 UTC [22291] LOG:  invalid length of startup packet
2024-08-21 19:00:14.049 UTC [24228] FATAL:  database "zilean" does not exist
2024-08-21 20:00:13.823 UTC [26953] FATAL:  database "zilean" does not exist
2024-08-21 21:00:14.151 UTC [29675] FATAL:  database "zilean" does not exist
2024-08-21 22:00:14.160 UTC [32406] FATAL:  database "zilean" does not exist__