Re: [HACKERS] Error in running DBT2

On Tue, May 20, 2014 at 9:57 AM, Andrew Dunstan wrote: > > On 05/20/2014 03:39 AM, Rohit Goyal wrote: > >> Hi All, >> >> Just adding the actual error again. >> >> I run the the *dbt2-pgsql-build-db -w 1 * >> >> >> Output directory of data files: current directory >> >> *Generating data files for

Re: [HACKERS] Error in running DBT2

On 05/20/2014 03:39 AM, Rohit Goyal wrote: Hi All, Just adding the actual error again. I run the the *dbt2-pgsql-build-db -w 1 * Output directory of data files: current directory *Generating data files for 1 warehouse(s)...* *Generating item table data...* *BEGIN* *ERROR: invalid byte seque

Re: [HACKERS] Error in running DBT2

Hi All, Just adding the actual error again. I run the the *dbt2-pgsql-build-db -w 1 * Output directory of data files: current directory *Generating data files for 1 warehouse(s)...* *Generating item table data...* *BEGIN* *ERROR: invalid byte sequence for encoding "UTF8": 0xf9* *CONTEXT: COPY

Re: [HACKERS] Error in running DBT2

Hi All, On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan wrote: > > On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal wrote: > >> This pattern the above found many times. Please guide me through!!! >> > > IIRC, people have been working around this by setting > standard_conforming_strings to "off"

Re: [HACKERS] Error in running DBT2

Andrew Dunstan wrote > On 05/15/2014 06:37 PM, Rohit Goyal wrote: >> Hi All, >> >> I am using centOS6 and after all confugration, I run the below command >> >> *dbt2-run-workload -a pgsql -d 120 -w 1 -o /tmp/result -c 10 >> * >> *Error:* >> Stage 3. Processing of results... >> Killing client... >>

Re: [HACKERS] Error in running DBT2

On Thu, May 15, 2014 at 3:47 PM, Andrew Dunstan wrote: > Do these questions about running dbt2 even belong on pgsql-hackers? They > seem to me to be usage questions that belong on pgsql-general. I agree. Anyway, perhaps the OP will have more luck with OLTPBenchmark, which has some kind of TPC-C

Re: [HACKERS] Error in running DBT2

On 05/15/2014 06:37 PM, Rohit Goyal wrote: Hi All, I am using centOS6 and after all confugration, I run the below command *dbt2-run-workload -a pgsql -d 120 -w 1 -o /tmp/result -c 10 * *Error:* Stage 3. Processing of results... Killing client... waiting for server to shut down done server

[HACKERS] Error in running DBT2

Hi All, I am using centOS6 and after all confugration, I run the below command *dbt2-run-workload -a pgsql -d 120 -w 1 -o /tmp/result -c 10* *Error:* Stage 3. Processing of results... Killing client... waiting for server to shut down done server stopped Traceback (most recent call last): F

Re: [HACKERS] Error in running DBT2

Hi All, I am runnig dbt2 with last postgresql kit. pg9.4. I tried everything again after setting up awhole new machine again with ubuntu. Still facing the same error. I run the the *dbt2-pgsql-build-db -w 1 * but, after some time, I faced this error */home/abhi/dbt2_install/bin/dbt2-pgsql-load

Re: [HACKERS] Error in running DBT2

Hi Peter, I tried the solution suggested by you. Please problem still persists. I run the the *dbt2-pgsql-build-db -w 1 * but, after some time, I faced this error */home/abhi/dbt2_install/bin/dbt2-pgsql-load-stored-procs: 45: [: c: unexpected operator* */home/abhi/dbt2_install/bin/dbt2-pgsql-lo

Re: [HACKERS] Error in running DBT2

On Tue, May 13, 2014 at 2:51 PM, David G Johnston wrote: > The error is more typical of someone creating a database with UTF-8 encoding > but then tries storing Latin-1 (or some other) encoded data. I didn't say that it was the only problem. Just that I had noticed that other people were using st

Re: [HACKERS] Error in running DBT2

Rohit Goyal wrote > Hi Peter, > > On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan < > pg@ > > wrote: > >> >> On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal < > rhtgyl.87@ > > wrote: >> >>> This pattern the above found many times. Please guide me through!!! >>> >> >> IIRC, people have been wor

Re: [HACKERS] Error in running DBT2

Hi Peter, On Tue, May 13, 2014 at 9:44 PM, Peter Geoghegan wrote: > > On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal wrote: > >> This pattern the above found many times. Please guide me through!!! >> > > IIRC, people have been working around this by setting > standard_conforming_strings to "off"

Re: [HACKERS] Error in running DBT2

On Tue, May 13, 2014 at 12:36 PM, Rohit Goyal wrote: > This pattern the above found many times. Please guide me through!!! > IIRC, people have been working around this by setting standard_conforming_strings to "off". It really ought to be fixed in a principled way, though -- the real issue here

[HACKERS] Error in running DBT2

Hi All, I run the the *dbt2-pgsql-build-db -w 1 * but, after some time, I faced this error */home/abhi/dbt2_install/bin/dbt2-pgsql-load-stored-procs: 45: [: c: unexpected operator* */home/abhi/dbt2_install/bin/dbt2-pgsql-load-stored-procs: 53: [: c: unexpected operator* *unknown stored function