STSSoft / DatabaseBenchmark

Database Benchmark is one of the most powerfull open source tools designed to stress test databases with large data flows.
http://stssoft.com/products/database-benchmark/
GNU General Public License v2.0
81 stars 20 forks source link

PostgreSQL to remote database fails #14

Open fernwerker opened 7 years ago

fernwerker commented 7 years ago

Trying to run benchmarks on a remote PostgreSQL DB 9.5 (Ubuntu 16.04) fails and wants to send an online report.

The error log in the server log says:

2017-05-18 16:08:06 CEST [40173-11] postgres@postgres ERROR: syntax error at or near "COMIT" at character 702 2017-05-18 16:08:06 CEST [40173-12] postgres@postgres STATEMENT: CREATE OR REPLACE FUNCTION InsertToTable1(_id bigint, _symbol text, _time timestamp without time zone, _bid double precision, _ask double precision, _bidsize int, _asksize int, _provider text ) RETURNS int LANGUAGE plpgsql AS $$ DECLARE rowCount RECORD; BEGIN IF exists(select * from fanuc where id=_id) THEN UPDATE fanuc SET symbol =_symbol, time = _time, bid = _bid, ask = _ask, bidsize = _bidsize, asksize =_asksize, provider = _provider WHERE ID = _id; ELSE INSERT INTO fanuc VALUES(_id,_symbol,_time,_bid, _ask, _bidsize, _asksize, _provider); END IF; COMIT; RETURN 0; END $$; 2017-05-18 16:08:06 CEST [40173-13] postgres@postgres ERROR: function inserttotable1(bigint, text, timestamp without time zone, double precision, double precision, integer, integer, text) does not exist at character 8 2017-05-18 16:08:06 CEST [40173-14] postgres@postgres HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2017-05-18 16:08:06 CEST [40173-15] postgres@postgres STATEMENT: SELECT InsertToTable1(CAST(2476635885972918365 as bigint), CAST('CHFBGN' as text), CAST('18.05.2017 16:05:41' as timestamp without time zone), CAST('1.5857' as double precision), CAST('1.5863' as double precision), CAST(2993 as int), CAST(2034 as int), CAST('NASDAQ' as text));

Dragonites commented 7 years ago

I have the same problem. Is this project still alive?