Skip to content

Instantly share code, notes, and snippets.

@chaporgin
chaporgin / chapson quick paste
Created January 19, 2022 10:38
chapson quick paste
* console-pageserver-1 | 2022-01-19T10:32:35.144633Z INFO tenant_create{tenant=ddcae36e58ef7e32f82486cb36c6ebf9}:bootstrapping{timeline=de10760a68b21ac07baa6a13a55afb76 tenant=ddcae36e58ef7e32f82486cb36c6ebf9}: running initdb in /data/tenants/ddcae36e58ef7e32f82486cb36c6ebf9/tmp...
@chaporgin
chaporgin / chapson quick paste
Created January 19, 2022 10:18
chapson quick paste
console-pageserver-1 | 2022-01-19T10:17:12.194341Z INFO POST /v1/tenant/ 201 Created
console-pageserver-1 | 2022-01-19T10:17:12.216609Z INFO GET /v1/branch/70e94d4b4ebac68cef2325fd3dcbdbc5 200 OK
console-pageserver-1 | 2022-01-19T10:17:12.226927Z INFO checkpoint{timeline=23d2942acd9bddbf253986b91a20423a tenant=d32c66359f09e8b4682a55f67931a446}: the oldest layer is now inmem-pg_control_checkpoint_0_0000000001695D11_FFFFFFFFFFFFFFFF which is 24336 bytes behind last_record_lsn
console-pageserver-1 | 2022-01-19T10:17:12.346646Z INFO GET /v1/branch/70e94d4b4ebac68cef2325fd3dcbdbc5 200 OK
console-pageserver-1 | 2022-01-19T10:17:12.495826Z INFO checkpoint{timeline=4170ddc889f52a235088aaf54f76efb7 tenant=1b21f903831296fa464d461
@chaporgin
chaporgin / chapson quick paste
Created January 19, 2022 10:00
chapson quick paste
console-pageserver-1 | 2022-01-19T10:00:25.717236Z ERROR pagestream{timeline=d9f5173096f81af9fa4d90bc1ad40768 tenant=7042b3749dd4dd6aa11569d08f8a4a74}: error reading relation or page version: WAL redo process closed its stderr unexpectedly
console-pageserver-1 |
console-pageserver-1 | Stack backtrace:
console-pageserver-1 | 0: <core::result::Result<T,F> as core::ops::try_trait::FromResidual<core::result::Result<core::convert::Infallible,E>>>::from_residual
console-pageserver-1 | at /rustc/f1edd0429582dd29cccacaf50fd134b05593bd9c/library/core/src/result.rs:1914:27
console-pageserver-1 | pageserver::layered_repository::LayeredTimeline::reconstruct_page
console-pageserver-1 | at /zenith/pageserver/src/layered_repository.rs:2039:27
console-pageserver-1 | pageserver::layered_repository::LayeredTimeline::materialize_page
console-pageserver-1 | at /zenith/pageserver/src/layered_repository.rs:1981:9
console-pageserver-1 |
@chaporgin
chaporgin / chapson quick paste
Created January 19, 2022 09:53
chapson quick paste
console-pageserver-1 | 2022-01-19T09:52:33.400844Z INFO loading timeline{timeline=739167a3d84f3cd418b03463608eeb86 tenant=57f27bb3357f60cc6369609464b165f5}:calc logical size{lsn=0/1695D68}: list_nonrels called at 0/1695D68
console-pageserver-1 | 2022-01-19T09:52:33.411147Z INFO Using auth: Trust
console-pageserver-1 | 2022-01-19T09:52:33.478218Z INFO Starting a http endpoint at 0.0.0.0:9898
console-pageserver-1 | 2022-01-19T09:52:33.513483Z ERROR Error processing HTTP request: InternalServerError(Tenant not found for tenant b7f3e0073dd6aa05ba74cee3e4002a76
console-pageserver-1 |
console-pageserver-1 | Stack backtrace:
console-pageserver-1 | 0: pageserver::tenant_mgr::get_repository_for_tenant::{{closure}}
console-pageserver-1 | at /zenith/pageserver/src/tenant_mgr.rs:254:24
console-pageserver-1 | core::option::Option<T>::ok_or_else
console-pageserver-1 | at /rustc/f1edd0429582dd29cccacaf50fd134b05593bd9c/library/core/src/option.rs:9
@chaporgin
chaporgin / chapson quick paste
Created January 19, 2022 09:09
chapson quick paste
api_client = Client(base_url='http://localhost:3000/api/v1', cookies=<RequestsCookieJar[Cookie(version=0, name='zenith', value='MTY...67, discard=False, comment=None, comment_url=None, rest={}, rfc2109=False)]>, headers={}, timeout=5.0, verify_ssl=True)
@pytest.mark.timeout(120)
def test_run_query_on_a_cluster(api_client):
resp = post_clusters.sync_detailed(
client=api_client,
json_body=ClusterStub.from_dict(
{
"cluster": {
"name": "default_cluster",
@chaporgin
chaporgin / chapson quick paste
Created January 18, 2022 13:03
chapson quick paste
2022/01/18 15:50:40 password reset was successful for role "@zenith" 47
{"level":"INFO","ts":"2022-01-18T15:50:40.026+0300","message":"/api/v1/clusters/gentle-wave-654294/roles/47/reset_password","status":200,"method":"POST","path":"/api/v1/clusters/gentle-wave-654294/roles/47/reset_password","query":"","ip":"::1","user-agent":"python-httpx/0.18.2","latency":0.037714917,"time":"2022-01-18T12:50:40Z"}
{"level":"DEBUG","ts":"2022-01-18T15:50:40.041+0300","message":"sql: query/select.users","middleware":"authorize","duration":0.001331,"db.host":"localhost:5432","db.database":"postgres","sql.action":"query","sql.statement":"SELECT * FROM users WHERE id = $1","sql.args":[{"Name":"","Ordinal":1,"Value":40}],"duration":0.001331,"db.host":"localhost:5432","db.database":"postgres","sql.action":"query","sql.statement":"SELECT * FROM users WHERE id = $1","sql.args":[{"Name":"","Ordinal":1,"Value":40}]}
{"level":"DEBUG","ts":"2022-01-18T15:50:40.041+0300","message":"authorized user id=40(zpdtjnhytx@example.com)","middlew
@chaporgin
chaporgin / chapson quick paste
Created January 18, 2022 12:32
chapson quick paste
operation #121 "create_timeline" started
2022/01/18 15:28:51 CreateTenant: creating tenant e54ab9e1ddcf2f7e09a963e92ba707c1
2022/01/18 15:28:51 CreateTenant: got error: pageserver responded with status 500
2022/01/18 15:28:51 ListTimelines: started for e54ab9e1ddcf2f7e09a963e92ba707c1
2022/01/18 15:28:51 ListTimelines: done for e54ab9e1ddcf2f7e09a963e92ba707c1. Got 1 timelines
2022/01/18 15:28:51 ListTimelines: started for e54ab9e1ddcf2f7e09a963e92ba707c1
2022/01/18 15:28:52 ListTimelines: done for e54ab9e1ddcf2f7e09a963e92ba707c1. Got 1 timelines
operation #121 "create_timeline" succeeded
operation #120 "create_compute" started
{"level":"DEBUG","ts":"2022-01-18T15:28:52.258+0300","message":"sql: query/select.users","middleware":"authorize","duration":0.001592,"db.host":"localhost:5432","db.database":"postgres","sql.action":"query","sql.statement":"SELECT * FROM users WHERE id = $1","sql.args":[{"Name":"","Ordinal":1,"Value":36}],"duration":0.001592,"db.host":"localhost:5432","db.database":"postgres","sql.act
@chaporgin
chaporgin / chapson quick paste
Created January 18, 2022 12:30
chapson quick paste
operation #121 "create_timeline" started
2022/01/18 15:28:51 CreateTenant: creating tenant e54ab9e1ddcf2f7e09a963e92ba707c1
2022/01/18 15:28:51 CreateTenant: got error: pageserver responded with status 500
2022/01/18 15:28:51 ListTimelines: started for e54ab9e1ddcf2f7e09a963e92ba707c1
2022/01/18 15:28:51 ListTimelines: done for e54ab9e1ddcf2f7e09a963e92ba707c1. Got 1 timelines
2022/01/18 15:28:51 ListTimelines: started for e54ab9e1ddcf2f7e09a963e92ba707c1
2022/01/18 15:28:52 ListTimelines: done for e54ab9e1ddcf2f7e09a963e92ba707c1. Got 1 timelines
operation #121 "create_timeline" succeeded
operation #120 "create_compute" started
{"level":"DEBUG","ts":"2022-01-18T15:28:52.258+0300","message":"sql: query/select.users","middleware":"authorize","duration":0.001592,"db.host":"localhost:5432","db.database":"postgres","sql.action":"query","sql.statement":"SELECT * FROM users WHERE id = $1","sql.args":[{"Name":"","Ordinal":1,"Value":36}],"duration":0.001592,"db.host":"localhost:5432","db.database":"postgres","sql.act
@chaporgin
chaporgin / chapson quick paste
Created January 18, 2022 12:14
chapson quick paste
{"level":"INFO","ts":"2022-01-18T15:09:14.928+0300","message":"/api/v1/clusters/dawn-bush-342570/query","status":200,"method":"POST","path":"/api/v1/clusters/dawn-bush-342570/query","query":"","ip":"::1","user-agent":"python-httpx/0.18.2","latency":4.564781417,"time":"2022-01-18T12:09:14Z"}
{"level":"DEBUG","ts":"2022-01-18T15:09:14.957+0300","message":"sql: query/select.users","middleware":"authorize","duration":0.001219,"db.host":"localhost:5432","db.database":"postgres","sql.action":"query","sql.statement":"SELECT * FROM users WHERE id = $1","sql.args":[{"Name":"","Ordinal":1,"Value":34}],"duration":0.001219,"db.host":"localhost:5432","db.database":"postgres","sql.action":"query","sql.statement":"SELECT * FROM users WHERE id = $1","sql.args":[{"Name":"","Ordinal":1,"Value":34}]}
{"level":"DEBUG","ts":"2022-01-18T15:09:14.957+0300","message":"authorized user id=34(ovgkfmgucv@example.com)","middleware":"authorize"}
{"level":"INFO","ts":"2022-01-18T15:09:14.977+0300","message":"/api/v1/clusters/dawn-bush-3425
@chaporgin
chaporgin / chapson quick paste
Created January 18, 2022 11:49
chapson quick paste
{"level":"DEBUG","ts":"2022-01-18T14:48:18.097+0300","message":"authorized user id=26(ftrugdvzjs@example.com)","middleware":"authorize"}
{"level":"INFO","ts":"2022-01-18T14:48:18.123+0300","message":"/api/v1/clusters/weathered-frog-511291","status":200,"method":"GET","path":"/api/v1/clusters/weathered-frog-511291","query":"","ip":"::1","user-agent":"python-httpx/0.18.2","latency":0.033842709,"time":"2022-01-18T11:48:18Z"}
operation create_timeline started
2022/01/18 14:48:18 CreateTenant: creating tenant b203c56c6e2563255743cee803653622
2022/01/18 14:48:18 CreateTenant: got error: pageserver responded with status 500
2022/01/18 14:48:18 ListTimelines: started for b203c56c6e2563255743cee803653622
2022/01/18 14:48:18 ListTimelines: done for b203c56c6e2563255743cee803653622. Got 1 timelines
2022/01/18 14:48:18 ListTimelines: started for b203c56c6e2563255743cee803653622
2022/01/18 14:48:18 ListTimelines: done for b203c56c6e2563255743cee803653622. Got 1 timelines
operation create_timeline succeeded