Skip to content

Instantly share code, notes, and snippets.

View infotek's full-sized avatar

Jason Ellison infotek

View GitHub Profile
$ /usr/lib/nagios/plugins/check_pg_localhost -H localhost ais
OK|datid=16384;;; datname=ais;;; numbackends=3;;; xact_commit=22736561;;; xact_rollback=8801054;;; blks_read=3265965;;; blks_hit=84996885;;; tup_returned=74245605;;; tup_fetched=382129;;; tup_inserted=20383790;;; tup_updated=9165;;; tup_deleted=1244;;; conflicts=0;;; temp_files=0;;; temp_bytes=0;;; deadlocks=0;;; blk_read_time=0;;; blk_write_time=0;;;
@infotek
infotek / gist:f18fffd050bb6603b42da802d6b98e1c
Created December 17, 2020 21:24
npgsql problem connecting to postgresql v13 (worked with postgresql 9.6)
ERROR 2020-12-16 16:02:44,499 333535ms Archive rieveUnlimitedData - Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.TimeoutException: Timeout during reading attempt
at Npgsql.NpgsqlConnector.<<ReadMessage>g__ReadMessageLong|194_0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Npgsql.NpgsqlDataReader.<>c__DisplayClass41_0.<<ReadMessage>g__ReadMessageSequential|0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Threading.Tasks.ValueTask`1.get_Result()