2014/09/06 09:06 -0700, Don Wieland
Can anyone tell me why this query is generating an ERROR:
Which error? The first "IF" statement is not properly ended? it isn't.
(A series of equality tests against the same variable is done more conveniently
with "CASE ... END CASE".)
--
I followed the manpage for mysqlimport:
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test
ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using
password: NO)
thufir@dur:~$
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT,
I think it's apparmor:
thufir@dur:/tmp$
thufir@dur:/tmp$ nl /etc/apparmor.d/usr.sbin.mysqld
1 # vim:syntax=apparmor
2 # Last Modified: Tue Jun 19 17:37:30 2007
3 #include
4 /usr/sbin/mysqld {
5#include
6#include
7#include
8#
Am 24.06.2014 07:08, schrieb thufir:
> On Mon, 23 Jun 2014 10:59:48 -0400, Scott Helms wrote:
>
>> I generally drop them into /tmp for easy access and cleanup after the
>> data load, but you can put them any place that the mysql daemon process
>> has access to read.
>
> Huh, maybe the daemon do
On Mon, 23 Jun 2014 10:59:48 -0400, Scott Helms wrote:
> I generally drop them into /tmp for easy access and cleanup after the
> data load, but you can put them any place that the mysql daemon process
> has access to read.
Huh, maybe the daemon doesn't have access to /tmp?...
thufir@dur:/tmp$
Sol :-
Change file owner to mysql.mysql
OR
Change folder and file mode to 777
DK Sent from Phone
> On 23-Jun-2014, at 8:22 pm, thufir wrote:
>
> Apparently this error is because MySQL can't read my home directory? Fair
> enough, but I don't quite follow. Where would
Or use the LOCAL diective to have the client send the csv file contents
to the server.
/ Carsten
On 23-06-2014 16:59, Scott Helms wrote:
I generally drop them into /tmp for easy access and cleanup after the data
load, but you can put them any place that the mysql daemon process has
access to
Often, one uses /tmp or set up an appropriately premoissioned folder under /var
On Mon, Jun 23, 2014 at 10:52 AM, thufir wrote:
> Apparently this error is because MySQL can't read my home directory? Fair
> enough, but I don't quite follow. Where would be a good location for the
> CSV file, then
I generally drop them into /tmp for easy access and cleanup after the data
load, but you can put them any place that the mysql daemon process has
access to read.
Scott Helms
Vice President of Technology
ZCorum
(678) 507-5000
http://twitter.com/kscotthelms
Hi Érico,
> mac:mysql-5.6.16-linux-glibc2.5-x86_64 ericomtx$ sudo
> scripts/mysql_install_db --user=mysql
> sh: ./bin/my_print_defaults: cannot execute binary file
> FATAL ERROR: Neither host 'mac.local' nor 'localhost' could be looked up
> with
> ./bin/resolveip
> Please configure the 'hostname'
2014/1/7
> 2014/01/06 17:07 +0100, Reindl Harald
> what about look in the servers logfiles
> most likely "max_allowed_packet" laughable low
>
> Is this then, too, likly when the server and the client are the same
> machine?
>
> I left this out, that it only then happens when th
2014/01/06 17:07 +0100, Reindl Harald
what about look in the servers logfiles
most likely "max_allowed_packet" laughable low
Is this then, too, likly when the server and the client are the same machine?
I left this out, that it only then happens when the client has been idle, a
Am 06.01.2014 15:36, schrieb h...@tbbs.net:
> Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often
> see that error-message, which under 5.5.8 I never saw. What is going on?
what about look in the servers logfiles
most likely "max_allowed_packet" laughable low
signatu
Hi Reindl Harald,
i have included [mysqladmin] section in config file also. but still facing
same issue.
On Mon, Sep 16, 2013 at 3:54 PM, Reindl Harald wrote:
>
>
> Am 16.09.2013 12:14, schrieb Pothanaboyina Trimurthy:
> > Hi guys,
> > today i have installed mysql 5.6.13 tar binary
Am 16.09.2013 12:14, schrieb Pothanaboyina Trimurthy:
> Hi guys,
> today i have installed mysql 5.6.13 tar binary distribution,
> on redhat5 machine. i have started the server with "skip-secure-auth",
> server started successfully.
> when i am trying to shutdown the server, it throwi
2013/04/05 11:16 +0200, Johan De Meersman
Half and half - rename the file, then issue "flush logs" in mysql to close and
reopen the logs, which will cause a new log with the configured name to be
created.
That being said, I'm not much aware of Windows' idiosyncracies - I hope the
damn
Am 04.04.2013 23:08, schrieb h...@tbbs.net:
> Is there somewhere within MySQL means of aging the error log, that it not
> indefinitly grow big, or is that done through the OS and filesystem on which
> "mysqld" runs?
man logrotate
signature.asc
Description: OpenPGP digital signature
Am 05.04.2013 11:16, schrieb Johan De Meersman:
> - Original Message -
>> From: h...@tbbs.net
>> Subject: Re: error-log aging
>>
>> man logrotate
>> <<<<<<<<
>> Not Unix!
>
> So get unix :-)
>
>> In any cas
- Original Message -
> From: h...@tbbs.net
> Subject: Re: error-log aging
>
> man logrotate
> <<<<<<<<
> Not Unix!
So get unix :-)
> In any case, I take this to mean that this is not done within MySQL,
> right?
Half and half - rename the
2013/04/04 23:18 +0200, Reindl Harald
> Is there somewhere within MySQL means of aging the error log, that it not
> indefinitly grow big, or is that done through the OS and filesystem on which
> "mysqld" runs?
man logrotate
Not Unix!
In any case, I take this to mean that this
you NEVER should upgrade the master before the slave
simply because the newer version may write statements in
a form to the binlog the older version does not understand
ALWAYS upgrade first the slaves and then the master
Am 12.02.2013 09:12, schrieb yoku ts.:
> Hello,
>
> It's because of binlog
Hello,
It's because of binlog_checksum = crc32 setted default at 5.6.5.
If you use 5.6's master and 5.5(or earlier)'s slave, you need to set
binlog_checksum = none on 5.6.
2013/2/12 Adarsh Sharma :
> Hi,
>
> I have a Multi Master Mysql setup between two mysql servers running 5.1.66-
> version. Bu
On 11/19/2012 10:27 AM, walter harms wrote:
hi List,
i get occasionally the following error:
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication
information', system error: 32
$ perror 32
OS error code 32: Broken pipe
Just to start.
If you want help you should inc
humm... I bet he have just run of space...
Some thing like tht...
On Tue, Oct 16, 2012 at 10:43 PM, Dehua Yang wrote:
> Hi
> There many reasons to lose connection to MySQL server.
> And what's more , the important thing is that you should provide the error
> code to us.
>
> If you got the err
gt;
>> <mailto:rja...@yahoo-inc.com>>**> wrote:
>>
>> SELinux ?
>>
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com
>>
The reason this is significant is because we are speaking about INFILE
use. The server processes infile commands assuming the file is already
stored on the server. LOCAL INFILE tells mysql that file is local to the
mysql client and must be moved to the server before processing. I suspect
that thi
<mailto:pengli...@gmail.com <mailto:pengli...@gmail.com>>]
> Sent: Tuesday, October 16, 2012 9:03 PM
> To: kalin
> Cc: Michael Dykman; mysql@lists.mysql.com
<mailto:mysql@li
;mailto:rja...@yahoo-inc.com>> wrote:
>>
>> SELinux ?
>>
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com
>> <mailto:pengli...@gmail.com>]
>> > Sent: Tuesday, October 16, 2012
alin
> Cc: Michael Dykman; mysql@lists.mysql.com
<mailto:mysql@lists.mysql.com>
> Subject: Re: error 13
>
> Hi,
>
> you can switch to mysql user "su - mysql", and then stat this
file.
> if you can&
gt;
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com]
>> > Sent: Tuesday, October 16, 2012 9:03 PM
>> > To: kalin
>> > Cc: Michael Dykman; mysql@lists.mysql.com
>> > Subject: Re: error 13
>> >
>> >
> Cc: Michael Dykman; mysql@lists.mysql.com
> > Subject: Re: error 13
> >
> > Hi,
> >
> > you can switch to mysql user "su - mysql", and then stat this file.
> > if you can't access, mysql user have not permissions.
> >
> > On Wed, O
SELinux ?
> -Original Message-
> From: Lixun Peng [mailto:pengli...@gmail.com]
> Sent: Tuesday, October 16, 2012 9:03 PM
> To: kalin
> Cc: Michael Dykman; mysql@lists.mysql.com
> Subject: Re: error 13
>
> Hi,
>
> you can switch to mysql user "su - my
Hi,
you can switch to mysql user "su - mysql", and then stat this file.
if you can't access, mysql user have not permissions.
On Wed, Oct 17, 2012 at 11:49 AM, kalin wrote:
>
>
>
> On 10/16/12 10:49 PM, Michael Dykman wrote:
>
>> is your mysql client on the same host as the mysql server? if not
On 10/16/12 10:49 PM, Michael Dykman wrote:
is your mysql client on the same host as the mysql server? if not, google
the docs for 'local infile'
yes. my laptop.
On 2012-10-16 10:45 PM, "Lixun Peng" wrote:
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file,
On 10/16/12 10:44 PM, Lixun Peng wrote:
Hi,
What's the dir permissions?
was 755. now 777. same result.
For example, if we have a file in /a/b/file, dir a is 644, even though
file is 777, we can't access file, too.
On Wed, Oct 17, 2012 at 10:31 AM, kalin mailto:ka...@el.net>> wrote:
Hi
There many reasons to lose connection to MySQL server.
And what's more , the important thing is that you should provide the error
code to us.
If you got the error code , you can check it by perror X
Anymore detail information would be appreciate !
On Wed, Oct 17, 2012 at 10:32 AM, ad...@cana
is your mysql client on the same host as the mysql server? if not, google
the docs for 'local infile'
On 2012-10-16 10:45 PM, "Lixun Peng" wrote:
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file, dir a is 644, even though file
is 777, we can't access file, too.
On
Hi,
What query is running? Is web server and DB server in the same server? Have
something in error.log of MySQL?
On Wed, Oct 17, 2012 at 10:32 AM, ad...@canadianinvestors.com <
ad...@canadianinvestors.com> wrote:
> Hi,
>
> I run www.canadianinvestors.com and am getting this error message.
>
> Wa
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file, dir a is 644, even though file
is 777, we can't access file, too.
On Wed, Oct 17, 2012 at 10:31 AM, kalin wrote:
>
>
> hi all..
>
> this hasn't happened before...
>
> i'm in as root on the command line cleint. trying
AM
To: 'Aastha'; mysql@lists.mysql.com
Subject: RE: Error starting data node
Unable to connect with connect string: nodeid=10,172.17.3.66:1186
There's a comma between 10 and 172 instead of a period.
-Original Message-
From: Aastha [mailto:aast...@gmail.com]
Sent: Tuesda
Unable to connect with connect string: nodeid=10,172.17.3.66:1186
There's a comma between 10 and 172 instead of a period.
-Original Message-
From: Aastha [mailto:aast...@gmail.com]
Sent: Tuesday, August 07, 2012 6:20 PM
To: mysql@lists.mysql.com
Subject: Error starting data node
Helo,
Hi
you have to see the reason in the mysql log file,
that is a file either in the datadir with .err extension or in the /var/log
directory.
tail the last 30 lines you will see the reason why it failed to start.
Claudio
2012/4/11 Prabhat Kumar
> did you check permission of file /var/run/mysqld/
did you check permission of file /var/run/mysqld/mysqld.sock
On Wed, Apr 11, 2012 at 9:48 AM, Larry Martell wrote:
> On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar wrote:
> > Hi Guys,
> >
> > I am using debian squeeze it's working good, I am trying to install
> > mysql-server. mysql-server instal
On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar wrote:
> Hi Guys,
>
> I am using debian squeeze it's working good, I am trying to install
> mysql-server. mysql-server installation successfully but didn't start
> service
> root@devel:/var/run# more /etc/mysql/my.cnf |grep socket
> # Remember to edit
Il 11/04/2012 10:51, Ganesh Kumar ha scritto:
Hi Guys,
I am using debian squeeze it's working good, I am trying to install
mysql-server. mysql-server installation successfully but didn't start
root@devel:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL databa
-Original Message-
> > From: lists-mysql [mailto:replies-lists-b3z1-my...@listmail.innovate.net
> ]
> > Sent: Thursday, April 05, 2012 5:28 PM
> > To: Manivannan S.
> > Subject: RE: Error in starting MySQL service on LINUX
> >
> >
> >
> >
ts-b3z1-my...@listmail.innovate.net]
> Sent: Thursday, April 05, 2012 5:28 PM
> To: Manivannan S.
> Subject: RE: Error in starting MySQL service on LINUX
>
>
>
> Original Message
> > Date: Thursday, April 05, 2012 11:04:48 AM +
> > From
Original Message-
From: lists-mysql [mailto:replies-lists-b3z1-my...@listmail.innovate.net]
Sent: Thursday, April 05, 2012 5:28 PM
To: Manivannan S.
Subject: RE: Error in starting MySQL service on LINUX
Original Message
> Date: Thursday, April 05, 2012 1
@lists.mysql.com
Subject: Re: Error in starting MySQL service on LINUX
boah do not top-post!
this was a typo - seems you did not understand my question WHY are you
downloading random binaries instead using packages from your linux distribution
which are tested and preconfigured?
Am 05.04.2012 12
Am 05.04.2012 12:27, schrieb Manivannan S.:
> Hi,
>
> In 64-bit Linux(Centos/Red Hat) machine when I am trying to
> start the MySQL service by using service mysql start command , I am getting
> the following error
>
>
> I have installed
>
> MySQL-client-5.1.52-1.glibc23.x86_6
boah do not top-post!
this was a typo - seems you did not understand my question
WHY are you downloading random binaries instead using
packages from your linux distribution which are tested
and preconfigured?
Am 05.04.2012 12:39, schrieb Manivannan S.:
> Hi,
>
> If I execute "service myqsl
Hi,
If I execute "service myqsld start" its saying
mysqld: unrecognized service
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, April 05, 2012 4:05 PM
To: mysql@lists.mysql.com
Subject: Re: Error in star
Thanks Andrew ,
I got my schema back :-) .
But Is it possible to get back all procedures that are created on these
tables.
Thanks once again.
Andrew Moore wrote:
You should be able to get the table structure again using the frm files
http://www.mysqlperformanceblog.com/2008/12/17/recovering
Thanks baron , below are the contents of my error.log :-
120315 17:17:51 [Note] Plugin 'FEDERATED' is disabled.
120315 17:17:51 InnoDB: Initializing buffer pool, size = 8.0M
120315 17:17:51 InnoDB: Completed initialization of buffer pool
InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on
InnoDB
It sounds like InnoDB itself might have failed to start, but there is
not enough information to know for sure. Please check the server's
error log.
On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma wrote:
> Dear All,
>
> Is there any way to recover data or only schema of corrupted innodb
> tables.My
If you did not work directly on mysql server (login
by mysql command), please try this.
Using script (PHP, ...) may lose connection, as my experience.
Best
--- On Mon, 3/5/12, Singer X.J. Wang wrote:
> From: Singer X.J. Wang
> Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL
egards,
> Javad Bakhshi,
>
>
>
> From: "mail...@securitylabs.it"
> To: mysql@lists.mysql.com
> Sent: Thursday, March 1, 2012 11:09 AM
> Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during
> query
>
> Il 01/03/2012 11:03, javad bakhshi ha sc
, 2012 11:09 AM
Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
Il 01/03/2012 11:03, javad bakhshi ha scritto:
> Hi,
>
> I am trying to load data into my table from a very large file but after some
> time I get this error:
>
> ERROR 2013 (HY000)
Il 01/03/2012 11:03, javad bakhshi ha scritto:
Hi,
I am trying to load data into my table from a very large file but after some
time I get this error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
My file size is around 4G and I have 220M lines in my file which have to be
On 02/28/2012 03:34 PM, Shafi AHMED wrote:
pls assist
- please give more information (OS, ...)
- you can search the web with
-- "ulimit more memory"
-- "mysql you-os increase memory"
-- "mysql you-os increase memory ulimit"
-- "mysql configuration memory"
-- ...
--
RMA.
--
MySQL General Mail
- Original Message -
> From: "Adarsh Sharma"
>
> 1. Go to data dir : cd /hdd2-1/mysql_data/
> 2. mv abc abc1
Whatever gave you the idea that it's a good plan to start messing with the
files of a service whose inner workings you have no clue about?
> ERROR 1146 (42S02): Table 'abc1.job_
2012/01/02 15:47 +0530, Adarsh Sharma
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
line 31 of what? Likly it would be helpful to show it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
;>>> 2011/10/20 10:21 -0400, Shawn Green (MySQL)
On 10/19/2011 17:50, wrote:
>I made this query a view, called "MEMBERP", no problem:
...snip...
>Only "GivenName" is derived from "GROUP_CONCAT" and is also a lesser field for
>ordering by. Why is that a problem?
Perhaps it is the USING claus
Hello Hal�sz S�ndor,
On 10/19/2011 17:50, wrote:
I made this query a view, called "MEMBERP", no problem:
SELECT MemberID, ereStart, DateModified, MembershipExpires, MemberSince,
Category, Boardster, GROUP_CONCAT(DISTINCT Salutation ORDER BY Rank) AS
Salutation, GROUP_CONCAT(DISTINCT Give
Hey everyone,
the problem was that I have the error log in /var/log/mysqld/mysql.error and
SELinux was not configured to allow it to rotate. I have compiled a custom
module to allow it so the problem is resolved. It was not an issue with
MySQL Server itself.
thanks again.
Keith
On Fri, Aug 12,
this will help you
http://adminlinux.blogspot.com/2009/09/mysql-log-file-rotation.html
On Fri, Aug 12, 2011 at 9:43 AM, Paul DuBois wrote:
>
> On Aug 11, 2011, at 2:30 PM, Keith Murphy wrote:
>
> > Hey everyone,
> >
> > I have run across something that has me stumped. I have some systems that
>
On Aug 11, 2011, at 2:30 PM, Keith Murphy wrote:
> Hey everyone,
>
> I have run across something that has me stumped. I have some systems that
> have very large error logs because we haven't moved from statement-based to
> mixed-based replication yet so they get a lot of warnings logged. I need
Am 17.06.2011 19:53, schrieb Philippe Mokrani:
> I have the following error messages:
>
> Installing MySQL system tables...
>
> 110617 19:46:25 [ERROR] ./bin/mysqld: unknown variable
> 'default-character-set=latin1'
"default-character-set=latin1" is way too old for 5.5
"character-set-server"
>-Original Message-
>From: Larry Martell [mailto:larry.mart...@gmail.com]
>Sent: Friday, April 29, 2011 5:31 PM
>To: Jerry Schwartz
>Cc: mysql mailing list
>Subject: Re: ERROR 2006 (HY000)
>
>On Fri, Apr 29, 2011 at 3:23 PM, Jerry Schwartz wrote:
>> I'm
On Fri, Apr 29, 2011 at 3:23 PM, Jerry Schwartz wrote:
> I'm getting
>
> ERROR 2006 (HY000) at line 10: MySQL server has gone away
>
> while trying to do an insert through the MySQL CLI. Our database is so small
> that I haven't gotten around to doing any tuning, so this came out of the
> blue. I'
Corrupted table and / or index.
A number of reasons could cause this issue:
http://dev.mysql.com/doc/refman/5.1/en/corrupted-myisam-tables.html
Regards,
m
"Adarsh Sharma" pisze:
> Thanks , but there is no trigger on tables.
>
> Even I solved the problem after googling a link but cannot unders
Thanks , but there is no trigger on tables.
Even I solved the problem after googling a link but cannot understand
below mentioned things :- Please have some comments on them
misiaq wrote:
Any triggers on this table..?
"Adarsh Sharma" pisze:
Dear all,
I have a login table in the databas
Hi,
It's quite simple and quick change in *nix. But would recommend to check your
server performance first (processlist, tmp tables, slow query log etc).
Regards,
m
"Jerry Schwartz" pisze:
> You are seeing *NIX error messages. You need to increase the operating system
> settings that control
You are seeing *NIX error messages. You need to increase the operating system
settings that control the number of files that a process can open.
I'm very rusty, and never really used Linux, so I can't tell you the exact
parameters. There are probably two: total number of open files, and files pe
300 is pretty low - MySQL counts every instance of a table in any query as an
"open file". A query that uses the same table twice (with an alias, for
example) thus counts for two open files.
This may also be outside of MySQL, the ulimit for the user running the daemon
may have open files restr
errono:13 is "Permission Denied". Check permissions for mysql data dir.
On Mon, Mar 14, 2011 at 11:02 AM, Adarsh Sharma wrote:
> Dear all,
>
> I am facing the below problem while installing mysql in a debian based
> system from the last 2 days.
>
> I tried the command apt-get install mysql-serve
Sorry for another email. But this is just to expand on what SHawn said..I
could also have created an index and then referenced the column.
So without a primary key. I can create the parent , then create the child
and the index .
mysql> create TABLE parent ( id int(16) , name varchar(128))ENGINE=
Thanks shawn for your reply. Your simplification of the innodb status
message and this post which I just read (http://lists.mysql.com/mysql/221900
)
tells me what I am doing wrong.
I need the referenced column to be indexed. I guess one way of ensuring that
is to declare it as a primary key .
So
Hello Hari,
You already posted the best answer we could provide :)
On 2/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child tables
and the innodb status below. ...
mysql> show innodb status;
+---
Hi everybody!
Peng Yu wrote:
> Hi,
>
> I run the following command. But I got the following error. I'm not
> sure what causes the problem. I have seen the same issue before, but
> it disappeared even I didn't take any action. Could anybody let me
> know how to fix the problem?
>
> mysql -ugenom
On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla wrote:
> Make sure the following things:
>
>
> - /tmp folder is having 1777 permissions
> - mysql folder is having the ownership from which it is running. Refer
> /etc/my.cnf
> - Make sure you have space on your MySQL partition
>
Also, make
Make sure the following things:
- /tmp folder is having 1777 permissions
- mysql folder is having the ownership from which it is running. Refer
/etc/my.cnf
- Make sure you have space on your MySQL partition
Regards
Sushant Chawla
On Tue, Jan 18, 2011 at 10:51 AM, Yogesh Kore wro
May be db files are not as MySQL user. Check owner ship for the files of the
table.
It should be mysql user ownership.
On Tue, Jan 18, 2011 at 6:36 AM, Peng Yu wrote:
> Hi,
>
> I run the following command. But I got the following error. I'm not
> sure what causes the problem. I have seen the sam
I'm sorry Michael and list mysql ,
I had realised that my mistake
not happen again
2011/1/13 Michael Dykman
> This doesn't look like a mysql problem per-se. It looks like the
> problem lies with connection pooling somewhere in your Java stack;
> it looks like Pentaho's connection pooling is
This doesn't look like a mysql problem per-se. It looks like the
problem lies with connection pooling somewhere in your Java stack;
it looks like Pentaho's connection pooling is misconfigured alloing
stale connections to remain in the pool. I suggest that you take this
query to a Pentaho support
check the error log,and you know the 5.5.8 enable the innodb by
default,make sure that you have enough RAM.
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2010/12/23 Krishna Chandra Prajapati :
> HI Adarsh,
>
> Try memtester command
>
> #memtester 5 1
>
> It' a linux t
HI Adarsh,
Try memtester command
#memtester 5 1
It' a linux tool to check ram for errors.
http://krishna-mysql.blogspot.com/2010/12/faulty-physical-ram.html
Krishna
On Thu, Dec 23, 2010 at 6:08 PM, Adarsh Sharma wrote:
> Dear all,
>
> I am able o successfully build Mysql 5.5.8 from its sour
Hi!
Johan De Meersman wrote:
> Probably one for the guys with the compilers, but have you tried running it
> with dtrace and seeing where it explodes ?
TTBOMK, "dtrace" is a Solaris tool, and I haven't heard about it being
available on CentOS.
I assume this is a typo, and Johan meant "strace".
n Thu, 23/12/10, Johan De Meersman wrote:
>
> > From: Johan De Meersman
> > Subject: Re: Error while running Mysql
> > To: "Adarsh Sharma"
> > Cc: mysql@lists.mysql.com
> > Date: Thursday, 23 December, 2010, 12:39
> > Probably one for the guys
I've no idea of the status of dtrace on linux, as I've never tried, but failing
that you could run it through gdb to get some insight into the issue.
--- On Thu, 23/12/10, Johan De Meersman wrote:
> From: Johan De Meersman
> Subject: Re: Error while running Mysql
> To: &q
Probably one for the guys with the compilers, but have you tried running it
with dtrace and seeing where it explodes ?
On Thu, Dec 23, 2010 at 1:38 PM, Adarsh Sharma wrote:
> Dear all,
>
> I am able o successfully build Mysql 5.5.8 from its source code on CentOS
> but when I issued the following
The application is designed to work such a way that it will process the csv
files daily as part of the aggregate process to calculate some metrics.
it runs fine on the master, when it come to slave through replicaiton it
fails with the error.
i even tried upgrading the slave to latest version mys
On Mon, Dec 20, 2010 at 9:00 AM, Anand wrote:
> Hi guys,
>
> i am facing a serious issue with my replication , i tried so many things
> but no luck.
>
> my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
>
> we run LOAD DATA INFILE in master to process some csv files and
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand :
> Hi guys,
>
> i am facing a serious issue with my replication , i tried so many things but
> no luck.
>
> my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
>
> we run LOAD DATA INFILE in
Some discussion of causes for this is at:
http://dev.mysql.com/doc/refman/5.0/en/join.html
Look for the part beginning:
"Join Processing Changes in MySQL 5.0.12"
On Nov 16, 2010, at 10:09 AM, Tompkins Neil wrote:
> Hi
>
> I've the following query :
>
> SELECT players_bids.players_bids_id, pla
I have run into similar issues in far less convoluted circumstances.
I'm not going to try to decode your query but using an alias can help
clarify things.
...
team_name_to
FROM players_bids AS PB
INNER JOIN players ON players_bids.players_id = players.players_id
...
and rename all your player_bid
On 2010年09月24日 16:27, Joerg Bruehe wrote:
Hi Sharl!
Sharl.Jimh.Tsin wrote:
hi,everyone
i try to compile and install mysql from source tarball,but i failed
again& again.
this is my config string:
[r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql
--exec-prefix=/usr/
Hi Sharl!
Sharl.Jimh.Tsin wrote:
> hi,everyone
> i try to compile and install mysql from source tarball,but i failed
> again & again.
>
> this is my config string:
> [r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql
> --exec-prefix=/usr/local --sysconfdir=/etc/sysconfig/my
Brad Scott skrev:
Any line beginning with just a number (ie 9, 10, 16) causes a failure. What am
I missing?
backticks. Use `9`, `10`, etc.
Having column names that begin with numbers is a really bad design
decision. "9a123" (unquoted, of course) will work, as you've noticed,
but e.g. "
Hi Brad,
2010/6/8 Brad Scott :
[...]
> Any line beginning with just a number (ie 9, 10, 16) causes a failure. What
> am I missing?
you should add backticks ( ` ) at both ends of the column name, e.g.
`7c` varchar(255) NOT NULL default '',
I think your export should have been done with the opt
1 - 100 of 1368 matches
Mail list logo
