[MonetDB-users] Star Schema Benchmark: Can't load SF 5 ou SELECT, LINE_READ Crash
Hello, I Have Ubunto 9.10 Karmik Koala installed. On top of this I have installed MonetDB latest version (same problem with previous one). I'm working with Star Schema Benchmark (SSBM). For Scale Factor 1 and 3 I can load the data. For SF 5 our above I get READ_LINE error when loading LINEORDER table. Also when running select Q4.1 I also get the same error and the server crashes. Anyone as a clue? Thanks Rui A.
Hello, There was some errors in the definition of scheme. To load the data you might have some error in the copy statement, in the delimiters. I loaded SF-10 without problems in MonetDB in the previous version. Use this package. It contains all queries, load statements plus dbgen and scheme files: http://homepages.cwi.nl/~goncalve/spool/ssbm.tar Regards, Romulo Rui Anastácio wrote:
Hello,
I Have Ubunto 9.10 Karmik Koala installed. On top of this I have installed MonetDB latest version (same problem with previous one).
I'm working with Star Schema Benchmark (SSBM). For Scale Factor 1 and 3 I can load the data. For SF 5 our above I get READ_LINE error when loading LINEORDER table.
Also when running select Q4.1 I also get the same error and the server crashes.
Anyone as a clue?
Thanks Rui A.
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Have you tested in Windows? I have tried using your definitions but no luck. Still get ERROR = !Connection terminated, ACTION = read_line Rui Anastácio Romulo Goncalves wrote:
Hello,
There was some errors in the definition of scheme. To load the data you might have some error in the copy statement, in the delimiters.
I loaded SF-10 without problems in MonetDB in the previous version.
Use this package. It contains all queries, load statements plus dbgen and scheme files: http://homepages.cwi.nl/~goncalve/spool/ssbm.tar
Regards, Romulo
Rui Anastácio wrote:
Hello,
I Have Ubunto 9.10 Karmik Koala installed. On top of this I have installed MonetDB latest version (same problem with previous one).
I'm working with Star Schema Benchmark (SSBM). For Scale Factor 1 and 3 I can load the data. For SF 5 our above I get READ_LINE error when loading LINEORDER table.
Also when running select Q4.1 I also get the same error and the server crashes.
Anyone as a clue?
Thanks Rui A.
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hello, I used a Linux machine. I have used the version May2009, it was sometime ago. I did not try in recent versions. That error show that the mserver crashed. We will check that. Regards Romulo Rui Anastácio wrote:
Have you tested in Windows?
I have tried using your definitions but no luck. Still get ERROR = !Connection terminated, ACTION = read_line
Rui Anastácio
Romulo Goncalves wrote:
Hello,
There was some errors in the definition of scheme. To load the data you might have some error in the copy statement, in the delimiters.
I loaded SF-10 without problems in MonetDB in the previous version.
Use this package. It contains all queries, load statements plus dbgen and scheme files: http://homepages.cwi.nl/~goncalve/spool/ssbm.tar
Regards, Romulo
Rui Anastácio wrote:
Hello,
I Have Ubunto 9.10 Karmik Koala installed. On top of this I have installed MonetDB latest version (same problem with previous one).
I'm working with Star Schema Benchmark (SSBM). For Scale Factor 1 and 3 I can load the data. For SF 5 our above I get READ_LINE error when loading LINEORDER table.
Also when running select Q4.1 I also get the same error and the server crashes.
Anyone as a clue?
Thanks Rui A.
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Romulo Goncalves -
Rui Anastácio