[MonetDB-users] mserver5/ubuntu crash
Hi, mserver5 crashed on ubuntu 64bit while running this query select count(*) from table1 where c1 like 'New Y%'; root@monetdb:~# mserver5 --dbinit="include sql;" # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb:50000/ # MonetDB/SQL module v2.30.0 loaded
Bus error root@monetdb:~#
/var/log/messages Jul 9 10:52:38 monetdb kernel: [260266.738514] mserver5[18561] general protection ip:7f1fa5f8996c sp:7f1f910989d8 error:0 in libbat.so.1.30.0[7f1fa5699000+d5f000] Jul 9 10:54:30 monetdb kernel: [260377.889355] mserver5[18577] trap stack segment ip:7fc1d0d161d3 sp:7fc1c8996d50 error:0
On Thu, Jul 09, 2009 at 11:01:49AM -0400, dariuszs wrote:
Hi, mserver5 crashed on ubuntu 64bit while running this query
select count(*) from table1 where c1 like 'New Y%';
What is the schema of your table1? How many records does it contain? How many records do you expect to qualify the predicate c1 like 'New Y%'? Is the crash reproducible? Which version of libpcre are you using? Stefan
root@monetdb:~# mserver5 --dbinit="include sql;" # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb:50000/ # MonetDB/SQL module v2.30.0 loaded
Bus error root@monetdb:~#
/var/log/messages Jul 9 10:52:38 monetdb kernel: [260266.738514] mserver5[18561] general protection ip:7f1fa5f8996c sp:7f1f910989d8 error:0 in libbat.so.1.30.0[7f1fa5699000+d5f000] Jul 9 10:54:30 monetdb kernel: [260377.889355] mserver5[18577] trap stack segment ip:7fc1d0d161d3 sp:7fc1c8996d50 error:0
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
Hi, I'm using Ubuntu Server 9.04 and whatever software comes with it. table1 has 260 columns all varchar, c1 is varchar(16). It crashes every time I run LIKE, and so far that's the only time it crushes. I expect about 3 million records that would qualify, but I only need a count. libpcre below: root@monetdb:~# apt-cache search 'libpcre' libpcre3 - Perl 5 Compatible Regular Expression Library - runtime files libpcre3-dbg - Perl 5 Compatible Regular Expression Library - debug symbols libpcre3-dev - Perl 5 Compatible Regular Expression Library - development files libpcrecpp0 - Perl 5 Compatible Regular Expression Library - C++ runtime files libpcre++-dev - C++ wrapper class for pcre (development) libpcre++0 - C++ wrapper class for pcre (runtime) libpcre-ocaml - OCaml bindings for PCRE (Perl Compatible Regular Expression) libpcre-ocaml-dev - OCaml bindings for PCRE (Perl Compatible Regular Expression) pcregrep - grep utility that uses perl 5 compatible regexes. root@monetdb:~# Dariusz. Stefan Manegold wrote:
On Thu, Jul 09, 2009 at 11:01:49AM -0400, dariuszs wrote:
Hi, mserver5 crashed on ubuntu 64bit while running this query
select count(*) from table1 where c1 like 'New Y%';
What is the schema of your table1? How many records does it contain? How many records do you expect to qualify the predicate c1 like 'New Y%'? Is the crash reproducible? Which version of libpcre are you using?
Stefan
root@monetdb:~# mserver5 --dbinit="include sql;" # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb:50000/ # MonetDB/SQL module v2.30.0 loaded
Bus error root@monetdb:~#
/var/log/messages Jul 9 10:52:38 monetdb kernel: [260266.738514] mserver5[18561] general protection ip:7f1fa5f8996c sp:7f1f910989d8 error:0 in libbat.so.1.30.0[7f1fa5699000+d5f000] Jul 9 10:54:30 monetdb kernel: [260377.889355] mserver5[18577] trap stack segment ip:7fc1d0d161d3 sp:7fc1c8996d50 error:0
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi, And now I also get this when starting up mserver5. Any clues? Thanks. Dariusz. root@monetdb:~# mserver5 --dbinit="include sql;" !ERROR: BBPdiskscan: stat(bat/01/51/15134.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15137.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15144.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15146.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15132.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15140.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15127.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15135.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15130.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15145.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15136.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15133.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15143.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15131.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15142.theap)!OS: Input/output error # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb:50000/ # MonetDB/SQL module v2.30.0 loaded
Hi, I'm using Ubuntu Server 9.04 and whatever software comes with it. table1 has 260 columns all varchar, c1 is varchar(16). It crashes every time I run LIKE, and so far that's the only time it crushes. I expect about 3 million records that would qualify, but I only need a count.
libpcre below: root@monetdb:~# apt-cache search 'libpcre' libpcre3 - Perl 5 Compatible Regular Expression Library - runtime files libpcre3-dbg - Perl 5 Compatible Regular Expression Library - debug symbols libpcre3-dev - Perl 5 Compatible Regular Expression Library - development files libpcrecpp0 - Perl 5 Compatible Regular Expression Library - C++ runtime files libpcre++-dev - C++ wrapper class for pcre (development) libpcre++0 - C++ wrapper class for pcre (runtime) libpcre-ocaml - OCaml bindings for PCRE (Perl Compatible Regular Expression) libpcre-ocaml-dev - OCaml bindings for PCRE (Perl Compatible Regular Expression) pcregrep - grep utility that uses perl 5 compatible regexes. root@monetdb:~#
Dariusz.
Stefan Manegold wrote:
On Thu, Jul 09, 2009 at 11:01:49AM -0400, dariuszs wrote:
Hi, mserver5 crashed on ubuntu 64bit while running this query
select count(*) from table1 where c1 like 'New Y%';
What is the schema of your table1? How many records does it contain? How many records do you expect to qualify the predicate c1 like 'New Y%'? Is the crash reproducible? Which version of libpcre are you using?
Stefan
root@monetdb:~# mserver5 --dbinit="include sql;" # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb:50000/ # MonetDB/SQL module v2.30.0 loaded
Bus error root@monetdb:~#
/var/log/messages Jul 9 10:52:38 monetdb kernel: [260266.738514] mserver5[18561] general protection ip:7f1fa5f8996c sp:7f1f910989d8 error:0 in libbat.so.1.30.0[7f1fa5699000+d5f000] Jul 9 10:54:30 monetdb kernel: [260377.889355] mserver5[18577] trap stack segment ip:7fc1d0d161d3 sp:7fc1c8996d50 error:0
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Looks like path access violations. Check the file modes up to dbfarm
Sent from my iPhone
On 10 jul 2009, at 16:19, dariuszs
Hi, And now I also get this when starting up mserver5. Any clues? Thanks. Dariusz.
root@monetdb:~# mserver5 --dbinit="include sql;" !ERROR: BBPdiskscan: stat(bat/01/51/15134.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15137.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15144.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15146.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15132.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15140.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15127.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15135.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15130.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15145.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15136.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15133.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15143.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15131.theap)!OS: Input/output error !ERROR: BBPdiskscan: stat(bat/01/51/15142.theap)!OS: Input/output error # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb:50000/ # MonetDB/SQL module v2.30.0 loaded
Hi, I'm using Ubuntu Server 9.04 and whatever software comes with it. table1 has 260 columns all varchar, c1 is varchar(16). It crashes every time I run LIKE, and so far that's the only time it crushes. I expect about 3 million records that would qualify, but I only need a count.
libpcre below: root@monetdb:~# apt-cache search 'libpcre' libpcre3 - Perl 5 Compatible Regular Expression Library - runtime files libpcre3-dbg - Perl 5 Compatible Regular Expression Library - debug symbols libpcre3-dev - Perl 5 Compatible Regular Expression Library - development files libpcrecpp0 - Perl 5 Compatible Regular Expression Library - C++ runtime files libpcre++-dev - C++ wrapper class for pcre (development) libpcre++0 - C++ wrapper class for pcre (runtime) libpcre-ocaml - OCaml bindings for PCRE (Perl Compatible Regular Expression) libpcre-ocaml-dev - OCaml bindings for PCRE (Perl Compatible Regular Expression) pcregrep - grep utility that uses perl 5 compatible regexes. root@monetdb:~#
Dariusz.
Stefan Manegold wrote:
On Thu, Jul 09, 2009 at 11:01:49AM -0400, dariuszs wrote:
Hi, mserver5 crashed on ubuntu 64bit while running this query
select count(*) from table1 where c1 like 'New Y%';
What is the schema of your table1? How many records does it contain? How many records do you expect to qualify the predicate c1 like 'New Y%'? Is the crash reproducible? Which version of libpcre are you using?
Stefan
root@monetdb:~# mserver5 --dbinit="include sql;" # MonetDB server v5.12.0, based on kernel v1.30.0 # Serving database 'svnp', using 8 threads # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://monetdb: 50000/ # MonetDB/SQL module v2.30.0 loaded
Bus error root@monetdb:~#
/var/log/messages Jul 9 10:52:38 monetdb kernel: [260266.738514] mserver5[18561] general protection ip:7f1fa5f8996c sp:7f1f910989d8 error:0 in libbat.so.1.30.0[7f1fa5699000+d5f000] Jul 9 10:54:30 monetdb kernel: [260377.889355] mserver5[18577] trap stack segment ip:7fc1d0d161d3 sp:7fc1c8996d50 error:0
--- --- --- --- ------------------------------------------------------------------
Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
--- --- --- --------------------------------------------------------------------- Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi, I've got this error loading a file. What does this mean? Dariusz. !SQLException:importTable:failed to import table !ERROR: HEAPextend: failed to extend to 580806800 for 02/65/26541tail !ERROR: TABLETcreate_bats: Failed to create bat of size 72600850 !COMMIT: failed !ERROR: COMMIT: transaction is aborted, will ROLLBACK instead 0 tuples
participants (3)
-
dariuszs
-
Martin Kersten
-
Stefan Manegold