Stopped working on IntelliJ 2019.2

[renedewaele]

Hey, just like for the original otj-pg-embedded project this fork stopped working on my system since upgrading to Mac OS 10.14.6 (latest version). The error I get is java.lang.IllegalStateException: Process [/var/folders/l_/c1b_7t2n39j48k7sbpp54zy00000gn/T/embedded-pg/PG-8eddc1e460ca1c5597350c162933683c/bin/initdb, -A, trust, -U, postgres, -D, /var/folders/l_/c1b_7t2n39j48k7sbpp54zy00000gn/T/epg3835758492450081687, -E, UTF-8] failed.

Deleting the temporary embedded-pg folder does not solve the problem. Do you have any ideas?

[tomix26]

Hi, thanks for the report. I will try to upgrade my system and let you know.

[aposchmann]

I am still using macOS 10.14.5, but experience the same issue. I did update IntelliJ to 2019.2 though. Everything else is still the same setup compared to the last successful run.

I tried embedded-database-spring-test version 1.4.1 and 1.5.0 ... without success so far.

[renedewaele]

I also updated to IntelliJ 2019.2 so that may be related to this as well. However, my tests fail with the same error during maven install.

[aposchmann]

I ran ./gradlew clean test from IntelliJ's integrated Terminal command line view -> fail. Afterwards I ran the same command from the Apple Terminal -> scuccess.

@renedewaele Can you confirm the behaviour with maven install?

[renedewaele]

Hi, I saw the same: maven install works from the terminal but not within IntelliJ 2019.2. Really weird, but I'm glad that settles it.

[tomix26]

Hey guys, thanks for the investigation. I did upgrade to IntelliJ 2019.2 (build IU-192.5728.98) and I'm trying to simulate the problem, but everything works fine. So, are you still experiencing the problem? Maybe some update fixed it?

[aposchmann]

@tomix26 In my case the problem is still exists. But I have two colleagues with almost the same setup (macOS 10.14.x and IntelliJ 2019.2) who don't experience the described behaviour. So it's very likely that it is some rare combination of installed programs and IntelliJ 2019.2

Edit

I just downgraded to IntelliJ 2019.1.4 and it works like a charm. So i guess it's more an IntelliJ 2019.2 issue and less an embedded-postgres issue.

[wiktord]

I had exact problem with otj-pg-embedded and spent too many hours on the issue (downgrading IntelliJ didn't help). ./gradlew build from mac terminal worked fine but same operation from intellij terminal failed with exactly same message as in the 1st post. Problem was with locales (don't ask why). Setting these properties in ~/.bash_profile helped:
export LC_CTYPE="en_US.UTF-8"
export LC_ALL="en_US.UTF-8"
Hope this saves someone from struggles.

[mahmoudnsr]

and if you using zsh, put these 2 exports into .zshrc file and restart Intellij

[sobvan]

Just my 2 cents: you can also put the locale environment variables in your gradle build file like this:

test {
    useJUnitPlatform()
    environment "LC_CTYPE", "en_US.UTF-8"
    environment "LC_ALL", "en_US.UTF-8"
}

Full answer here: opentable#65 (comment)