Skip to content

ERROR: row is too big: size 8880, maximum size 8160 #11

@demonlj

Description

@demonlj

follow the steps, PostgreSQL was established
when doing initiation, failed with error : ERROR: row is too big: size 8880, maximum size 8160

docker run --rm --net ukb \
  -v /raid1/ukbiobank/phenotype:/var/lib/phenotype \
  -e UKBREST_DB_URI="postgresql://test:test@pg:5432/ukb" \
  -e UKBREST_LOADING_N_JOBS=2 \
  hakyimlab/ukbrest --load

error reported:

2024-04-14 08:38:56,346 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 08:38:56,374 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 08:54:19,066 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 08:56:51,970 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 09:10:00,833 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 09:13:08,124 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 09:25:53,889 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 09:28:35,848 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 09:41:50,363 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 09:44:28,656 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 09:57:45,324 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 10:01:00,782 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 10:14:12,397 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 10:17:54,051 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 10:31:07,377 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 10:35:01,531 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 10:47:27,340 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 10:51:57,674 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 11:04:00,485 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 11:08:53,758 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 11:20:21,858 - ukbrest - WARNING - No encodings.txt found, assuming utf-8
2024-04-14 11:28:32,211 - ukbrest - INFO - Loading CSV files into database
2024-04-14 11:28:32,387 - ukbrest - INFO - /tmp/ukb_pheno_0_00.csv -> ukb_pheno_0_00
2024-04-14 11:28:32,415 - ukbrest - INFO - /tmp/ukb_pheno_0_01.csv -> ukb_pheno_0_01
2024-04-14 11:29:36,897 - ukbrest - INFO - /tmp/ukb_pheno_0_02.csv -> ukb_pheno_0_02
2024-04-14 11:30:23,631 - ukbrest - INFO - /tmp/ukb_pheno_0_03.csv -> ukb_pheno_0_03
2024-04-14 11:31:44,592 - ukbrest - INFO - /tmp/ukb_pheno_0_04.csv -> ukb_pheno_0_04
2024-04-14 11:32:30,952 - ukbrest - INFO - /tmp/ukb_pheno_0_05.csv -> ukb_pheno_0_05
2024-04-14 11:33:24,148 - ukbrest - INFO - /tmp/ukb_pheno_0_06.csv -> ukb_pheno_0_06
2024-04-14 11:33:51,006 - ukbrest - INFO - /tmp/ukb_pheno_0_07.csv -> ukb_pheno_0_07
2024-04-14 11:34:14,002 - ukbrest - INFO - /tmp/ukb_pheno_0_08.csv -> ukb_pheno_0_08
2024-04-14 11:34:33,383 - ukbrest - INFO - /tmp/ukb_pheno_0_09.csv -> ukb_pheno_0_09
2024-04-14 11:35:13,948 - ukbrest - INFO - /tmp/ukb_pheno_0_10.csv -> ukb_pheno_0_10
2024-04-14 11:35:45,600 - ukbrest - INFO - /tmp/ukb_pheno_0_11.csv -> ukb_pheno_0_11
2024-04-14 11:36:01,177 - ukbrest - ERROR - ERROR:  row is too big: size 8880, maximum size 8160
CONTEXT:  COPY ukb_pheno_0_11, line 543
2024-04-14 11:36:01,269 - ukbrest - INFO - /tmp/ukb_pheno_0_12.csv -> ukb_pheno_0_12
2024-04-14 11:36:15,184 - ukbrest - ERROR - ERROR:  row is too big: size 10656, maximum size 8160
CONTEXT:  COPY ukb_pheno_0_12, line 309
2024-04-14 11:36:15,213 - ukbrest - INFO - /tmp/ukb_pheno_0_13.csv -> ukb_pheno_0_13

my phenotype directory only have two files: csv & html
image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions