search

AmsterdamUMC / AmsterdamUMCdb

AmsterdamUMCdb - Freely Accessible ICU database. Please access our Open Access manuscript at https://doi.org/10.1097/CCM.0000000000004916
https://amsterdammedicaldatascience.nl/
MIT License
149 stars 43 forks source link

"value too large" #54

Open demon9514753 opened 2 years ago

demon9514753 commented 2 years ago

I using postgreSQL to install UMCdb, when it copy "listitems.csv" and "numericitems.csv", the softwaer prompts error message: "psql:postgres-load-data-csv.sql:16: error: unable to extract files "listitems.csv" status: value too large" and "psql:postgres-load-data-csv.sql:18: error: unable to extract files "numericitems.csv" status: value too large". What's wrong about it? What can I do to solve these problems? Thank you !

patrickthoral commented 2 years ago

Since I don't use psql directly: @peiyaoli Could you comment on this? I'm assuming you manually created the database schema and did not use BIGINT?

Alternatively, you could use this notebook from Python: https://github.com/AmsterdamUMC/AmsterdamUMCdb/blob/master/setup-amsterdamumcdb/setup-amsterdamumc.ipynb. That should not return that error.

demon9514753 commented 2 years ago

Thank you very much, I’ll try it.

从 Windows 版邮件发送

发件人: Patrick Thoral 发送时间: 2022年1月18日 5:05 收件人: AmsterdamUMC/AmsterdamUMCdb 抄送: demon9514753; Author 主题: Re: [AmsterdamUMC/AmsterdamUMCdb] "value too large" (Issue #54)

Since I don't use psql directly: @peiyaoli Could you comment on this? I'm assuming you manually created the database schema and did not use BIGINT? Alternatively, you could use this notebook from Python: https://github.com/AmsterdamUMC/AmsterdamUMCdb/blob/master/setup-amsterdamumcdb/setup-amsterdamumc.ipynb. That should not return that error. — Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you authored the thread.Message ID: @.***>

XiangBu commented 2 years ago

I using postgreSQL to install UMCdb, when it copy "listitems.csv" and "numericitems.csv", the softwaer prompts error message: "psql:postgres-load-data-csv.sql:16: error: unable to extract files "listitems.csv" status: value too large" and "psql:postgres-load-data-csv.sql:18: error: unable to extract files "numericitems.csv" status: value too large". What's wrong about it? What can I do to solve these problems? Thank you !

I doubt it might have something to do with the RAM.

patrickthoral commented 2 years ago

@demon9514753 Were you able to fix this?