DeeGee - f047419

Results 8 comments of DeeGee - f047419

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

1. AMD Ryzen Threadripper 3960X 24-Core Processor 2. 256 GB of Ram (8x32GB - DDR4-3600) 3. NVME 4. Headless Server Linux 5. Ubuntu VERSION="20.04.6 LTS (Focal Fossa)" 6. 1 7....

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

I connected to database, some tables return data and some time out.... ``` ./ycqlsh Connected to local cluster at 127.0.1.1:9042. [ycqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 |...

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

@davidd8 There has been no updates. I applied to be a part of Yugabyte slack and I didnt get the email. I just tried registering with another email address and...

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

@ddorian I am not sure how to see which statement failed? You want Yuga logs? This is the only message in the WARNING LOG. . `W0220 00:38:00.328931 65125 yb_rpc.cc:335] Call...

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

@LexLuthr ``` yugabyte=# SELECT count(*) FROM PieceTracker; count ------- 3711 (1 row) ````

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

``` yugabyte=# select * from goose_db_version; id | version_id | is_applied | tstamp ----+------------+------------+--------------------------- 1 | 0 | t | 2023-10-23 07:20:21.31317 (1 row) ```

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

@LexLuthr it times out on the first line ``` yugabyte=# ALTER TABLE PieceTracker DROP CONSTRAINT piecetracker_pkey; ERROR: Timed out waiting for Alter Table ```

[Support Ticket]: Error: running postgres migrations: ERROR go migration: "20230801093422_add_piece_tracker_miner_addr.go": failed to run go migration: pq: Timed out waiting for Alter Table

@LexLuthr I have restarted yuga and same result. See INFO log from yuga logs. [INFOLOG.txt](https://github.com/filecoin-project/boost/files/14427638/INFOLOG.txt)