On 9/10/2012 9:55 AM, Garot Conklin wrote:
Not to beat the perms to death but /tmp should have the sticky bit set as
well... so 1777 not just 0777. Perhaps hard kill any lingering mysql PIDS
unless this is production and u expect other DB's to be running... if u have
duplicated this DB schema
Not to beat the perms to death but /tmp should have the sticky bit set as
well... so 1777 not just 0777. Perhaps hard kill any lingering mysql PIDS
unless this is production and u expect other DB's to be running... if u have
duplicated this DB schema somewhow by mistake and a second or first id
2012/9/10 Machiel Richards - Gmail
> Hi,
>
> permissions are confirmed as being correct. Other applications and
> users are currently writing files to this directory yes.
>
Have you tried su - mysql and touch /tmp/test? (if your mysql user has
shell...)
Good luck!
Manuel.
*From: * Machiel Richards - Gmail ;
*To: * Ananda Kumar ;
*Cc: * ;
*Subject: * Re: Temporary table creation fails
*Sent: * Mon, Sep 10, 2012 12:41:51 PM
no selinux , checked this as well.
We generally dont use selinux and disable it completely from installation.
I have
Apologies if I missed this in the thread but have you confirmed not only the
effectve perms for the directory but that another user can write to this
dirrectory? Perhaps outside of mysql for instance; I.e. other processes are
successfully writting logs to /tmp? Anything to share from the mysql l
please share the command ur using to create the temp table
On Mon, Sep 10, 2012 at 6:11 PM, Machiel Richards - Gmail <
machiel.richa...@gmail.com> wrote:
> no selinux , checked this as well.
>
> We generally dont use selinux and disable it completely from installation.
>
> I have also gone thro
no selinux , checked this as well.
We generally dont use selinux and disable it completely from installation.
I have also gone through the firewall settings and that is only rules
for connections.
On 09/10/2012 02:40 PM, Ananda Kumar wrote:
did u check if there any firewall settings, forbi
Hi,
If you can afford try changing the tmpdir for mysql. This is a static
variable and will require a mysql restart.
thanks
On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail <
machiel.richa...@gmail.com> wrote:
> Hi
>
>
> at the moment this does not really matter to us.
>
> we have
did u check if there any firewall settings, forbidding you to create files,
check if " SELinux is disabled"
On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail <
machiel.richa...@gmail.com> wrote:
> Hi
>
>
> at the moment this does not really matter to us.
>
> we have even tried to cr
Hi
at the moment this does not really matter to us.
we have even tried to create a temp table with only one field in
order to insert one row for testing, but we are currently not able to
create any temporary tables whatsoever as even the simplest form of
table still gives the same error.
this temp table will hold how many rows, what would be its size.
On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail <
machiel.richa...@gmail.com> wrote:
> Hi,
> We confirmed that the /tmp directory permissions is set to rwxrwxrwxt
> and is owned by root , the same as all our other serv
Hi,
We confirmed that the /tmp directory permissions is set to
rwxrwxrwxt and is owned by root , the same as all our other servers.
There is also about 60Gb of free space on the filesystem where /tmp
resides.
Regards
On 09/10/2012 01:11 PM, Rik Wasmus wrote:
the message "ERROR 1
> the message "ERROR 1005 (HY000): Can't create table
> '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
Basics first:
1) Is the /tmp directory write & readable for the user mysql runs as?
2) Has the /tmp directory enough free space?
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http:
This is a current production database with about 100Gb + of data and the
DB is extremely busy.
On 09/10/2012 12:08 PM, Akshay Suryavanshi wrote:
Hi,
If you dont have data on the server, would you please initialize the
data directory.
Use mysql-install-db and give proper data directory a
Hi,
If you dont have data on the server, would you please initialize the data
directory.
Use mysql-install-db and give proper data directory and proper cnf file if
you are giving so.
Also specify the user as root if you have root access.
Thanks
On Mon, Sep 10, 2012 at 3:34 PM, Machiel Richards
Hi,
still no luck, same error being given immediately after pressing
enter.
On 09/10/2012 12:02 PM, Ananda Kumar wrote:
start with 500MB and try
On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail
mailto:machiel.richa...@gmail.com>> wrote:
Hi, the sort_buffer_size was set
start with 500MB and try
On Mon, Sep 10, 2012 at 3:31 PM, Machiel Richards - Gmail <
machiel.richa...@gmail.com> wrote:
> Hi, the sort_buffer_size was set to 8Mb as well as 32M for the session
> (currently 1M) and retried with same result.
>
>
>
>
>
> On 09/10/2012 11:55 AM, Ananda Kumar wrote:
Hi, the sort_buffer_size was set to 8Mb as well as 32M for the session
(currently 1M) and retried with same result.
On 09/10/2012 11:55 AM, Ananda Kumar wrote:
can you trying setting sort_buffer_size to big value at your session
level and create the table
On Mon, Sep 10, 2012 at 2:54 PM,
can you trying setting sort_buffer_size to big value at your session level
and create the table
On Mon, Sep 10, 2012 at 2:54 PM, Machiel Richards - Gmail <
machiel.richa...@gmail.com> wrote:
> Hi
>
> We tried that as well, however the databases are quite busy and either
> other transactions
Hi
We tried that as well, however the databases are quite busy and
either other transactions overwrite the info, or there is nothing logged.
We even tried running the create statement and immediately running
Show innodb status, but nothing for that statement.
Regards
On 09/10/20
try this command and see if you can get more info about the error
show innodb status\G
On Mon, Sep 10, 2012 at 2:25 PM, Machiel Richards - Gmail <
machiel.richa...@gmail.com> wrote:
> Hi All
>
> I am hoping someone can point me in the right direction.
>
> We have a mysql 5.0 database whi
mysql@lists.mysql.com
Subject: Re: Temporary table lifespan - SOLVED
Amer Neely wrote:
Daniel Kasak wrote:
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is
still live
- I don't do a disconnect anywhere. So I'm still not sure why I
can't pull the data b
l@lists.mysql.com
> Subject: Re: Temporary table lifespan - SOLVED
>
> Amer Neely wrote:
> > Daniel Kasak wrote:
> >> Amer Neely wrote:
> >>
> >>>> OK, that makes sense. As far as I know, my connection is
> still live
> >>>> - I don
Amer Neely wrote:
Daniel Kasak wrote:
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live
- I don't do a disconnect anywhere. So I'm still not sure why I
can't pull the data back out. I do get an error telling me about a
problem with my statement near w
Daniel Kasak wrote:
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live -
I don't do a disconnect anywhere. So I'm still not sure why I can't
pull the data back out. I do get an error telling me about a problem
with my statement near which is where it tr
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live -
I don't do a disconnect anywhere. So I'm still not sure why I can't
pull the data back out. I do get an error telling me about a problem
with my statement near which is where it tries to execute the
F
Amer Neely wrote:
Daniel Kasak wrote:
Amer Neely wrote:
I'm writing a perl script in which I need to save some session data.
My first attempt is to use a temporary table to store some data.
However, I'm a little unclear as to the lifespan of the temporary
table. My understanding is they las
Amer Neely wrote:
I'm writing a perl script in which I need to save some session data.
My first attempt is to use a temporary table to store some data.
However, I'm a little unclear as to the lifespan of the temporary
table. My understanding is they last until the session ends, or a
DELETE T
Thanks again,
raymond
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006 14:54
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Temporary table ERROR 1109 (42S02) where are temporary
tables kept?
Jacob, Raymond A Jr wrote
Jacob, Raymond A Jr wrote:
Thank you,
I was definitely on the wrong track on this one.
I annotated your commands to make sure that I understood what they
were doing. Are my comments correct?
---
You have the wrong syntax. You can't mention a table in the WHERE
clause that wasn't in t
Thank you,
I was definitely on the wrong track on this one.
I annotated your commands to make sure that I understood what they
were doing. Are my comments correct?
---
You have the wrong syntax. You can't mention a table in the WHERE
clause that wasn't in the FROM clause. Try
DELE
Jacob, Raymond A Jr wrote:
I ran the following commands:
USE snort;
CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp <
'2006-05-01';
...
SELECT count(*) from sidtemp;
count(*)
7501376
DELETE FROM data WHERE data.cid = sidtemp.cid;
ERROR 1109 (42S02): Unkown table 'sidtem
Ben Clewett wrote:
But the index does not seem nearly as fast as liner (normal) indexes.
Hence using a less effective liner index may be better...
After this method I still need select a radius within these data points,
more effort.
This could be an excellent case for using HAVING
The WHER
Thanks for the excellent advise.
In the mean while a friend Googled me an article suggesting that this
can be done using the POINT and SPATIAL INDEX. But I prefer your ideas.
I'll show what I found because I want to see if anybody has an opinion
on problems with either method:
Here I Store
Hi, Jigal
Thanks a lot. It works.
> Xiaobo Chen wrote:
>> Hi, all
>>
>> I am trying to use this with error:
>>
>> drop temporary tabel temp_a if exists 'temp_a';
>>
>> it said syntax error.
>
> Try:
>
> DROP TEMPORARY TABLE IF EXISTS `temp_a`;
>
> ('table' instead of 'tabel'; table name only once
DROP TEMPORARY TABLE IF EXISTS `temp_a`;
Xiaobo Chen wrote:
Hi, all
I am trying to use this with error:
drop temporary tabel temp_a if exists 'temp_a';
it said syntax error.
Could anybody tell me the right syntax? I didn't find the answer after
googling a while.
Thanks in advance.
Xiaob
Xiaobo Chen wrote:
Hi, all
I am trying to use this with error:
drop temporary tabel temp_a if exists 'temp_a';
it said syntax error.
Try:
DROP TEMPORARY TABLE IF EXISTS `temp_a`;
('table' instead of 'tabel'; table name only once; backticks around
table name instead of quotes)
http://dev
IL PROTECTED]>
Sent: Friday, January 23, 2004 6:20 PM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client
running xp
> Hi,
>
> 1) Try to reproduce the situation with pure myscl client (command-line
> client).
> 2) There is no any MySQL parameter that ch
Kind of what I was thinking of. How can I generate a unique identifier?
-Nate
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 2:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Temporary table issues. Do I need persistent connections
with
Even with persistent connections, you can't use a temporary table on
a later HTTP connection (Web request), because you don't know that
your new HTTP connection will get the same MySQL connection that you
used before.
It should work to use a temporary table in a series of queries to get
data t
.
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 5:11 PM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client
running xp
> 1) yes, I am sure
Massimo Petrini wrote:
We have a server running NT4 with mysql 4.017 (with the my.ini as in
previuous mail). In the network the client (the single pc ) run msaccess
application linked to mysql database. In such case we use a temporary table,
created as follow
CREATE TEMPORARY TABLE wrk_AlzateInte
een
> > and
> > > on the server the thread is still existent in sleep mode.
> >
> > could you explain in details what is your system configuration?
> > what is the client of MySQL server?
> >
> >
> > - Original Message -
> > From:
clear for you ?
Thanks
- Original Message -
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
To: "Massimo Petrini" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 11:12 AM
Subject: Re: temporary table in 4.0.17 on Windo
imo Petrini" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 11:08 AM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> no; because the client have still the result of the query
PROTECTED]>
Sent: Thursday, January 22, 2004 10:05 AM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> Hi Massimo,
>
> May be after some minutes of inactivity client closes connection to MySQL
> server?
> In this case MySQL deletes all temp tables that wer
Hi Massimo,
May be after some minutes of inactivity client closes connection to MySQL
server?
In this case MySQL deletes all temp tables that were created by this client.
Best regards,
Mikhail.
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
- Original Message -
From: "Nitin" <[EMAIL PROTECTED]>
To: "Susan Ator" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 16:39
Subject: Re: Temporary table question
> basically used to make queries easier running from within scripts
From: "Nitin" <[EMAIL PROTECTED]>
To: "Susan Ator" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 16:39
Subject: Re: Temporary table question
> basically used to make queries easier running from within scripts. it
could
> be
basically used to make queries easier running from within scripts. it could
be a good workaround for views, as you can create a temporary table to be
used as a view, but it gets destroyed as the connection to your database
closes. You can also use it as a good workaround for union, for older mysql
I am ausuming you are using the same user from both PHP and the mysql client.
But are you doing both locally? There may be two user records, one for
localhost and one for remote connections (or something to that effect).
Just a thought.
-Jackson
On Monday 11 August 2003 1:52, Miretsky, Anya
"Miretsky, Anya" <[EMAIL PROTECTED]> wrote:
>
> I'm running mysql version 4.0.13 and trying to create a temporary table
> from a php script. For some reason, even though I have the permission
> set up correctly, I can't seem to create a temporary table from the
> script. The permission say that cr
"Phil Dowson" <[EMAIL PROTECTED]> wrote:
> Very good question, I believe I do since it does work 90% of the time. Only
> occasionally it doesnt work, and thats why I need help
>
In wich cases it doesn't work? We need repeatable test cases.
>
>
> - Original Message ---
--
For technical s
gt;
Sent: Saturday, June 28, 2003 4:50 pm
Subject: Re: Temporary Table Issues
> At 16:47 -0500 6/28/03, Phil Dowson wrote:
> >Hi,
> >
> >I am experiencing a problem creating temporary tables within a MySQL
> >database. When I run the following query:
> >
>
At 16:47 -0500 6/28/03, Phil Dowson wrote:
Hi,
I am experiencing a problem creating temporary tables within a MySQL
database. When I run the following query:
CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY
rmmtid;
drop table rmb
I get the error
[server] ERROR 1044: Access
Temporary tables are per thread.
WHat guarantee do you have that your next page gets the same thread?
Martin Thomas wrote:
Help (apologies for the length of this email),
I am currently using mysql-max-3.23.49a with a process as follows:
Using tomcat/jsp/servlets, I have written a database conn
2002 10:18 AM
Subject: Re: Re: Re: Re: Temporary Table
> Thanks Egor, but the table names in the example are
> already lower case and I pasted them in SQL window of
> the client.
>
> Since yesterday I have test to type the script
> manually at the prompt in a DOS-window and then
Thanks Egor, but the table names in the example are
already lower case and I pasted them in SQL window of
the client.
Since yesterday I have test to type the script
manually at the prompt in a DOS-window and then all
worked well.
Trying to do the same in the SQL-window of MySQL-Front
all was OK
Ruda,
Friday, July 05, 2002, 7:55:51 PM, you wrote:
RG> Forgive me the wrong addressing - I didn't observed
RG> that.
RG> Yes I used same connection all the time. I am a
RG> SQL-newbee and I suspect that the problem is the
RG> installation or configuration.
RG> I use Windows 2000 Pro, MySQL 4.0
Forgive me the wrong addressing - I didn't observed
that.
Yes I used same connection all the time. I am a
SQL-newbee and I suspect that the problem is the
installation or configuration.
I use Windows 2000 Pro, MySQL 4.0.1-alpha-max-nt and
MySQL-Front 2.2
The MySQL-server and the client are inst
Hello Ruda,
Friday, July 05, 2002, 4:05:03 PM, you wrote:
Please, send your questions in the maling list, not only me.
RG> Hello Egor,
RG> I get NO result when i run the whole code.
RG> If I run the create-statement once more I was told
RG> that the table already exists and that is not a
RG> sur
Ruda,
Friday, July 05, 2002, 9:41:18 AM, you wrote:
RG> I am new to MySQL and to learn how to use it I am
RG> studying examples from
RG> http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html
RG> The following code does not work for med:
[skip]
RG> Perhaps I must add some informati
* Wilbert Enserink
> I'm using this query:
>
> CREATE temporary TABLE temptable SELECT * FROM gallery INNER JOIN
> designers
> ON (designers.designersID=gallery.designersID) WHERE
> (LOWER(gallery.omschrijving) LIKE '%$search%' OR
> LOWER(gallery.productnaam)
> LIKE '%$search%' OR LOWER(voornaam)
Selecting each column (instead of *) and then assigning an alias to
designerID from one of the tables (select designerID as GDID..) might
work.
Regards,
Bhavin.
- Original Message -
From: "Wilbert Enserink" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 7:38
Wilbert,
Tuesday, June 18, 2002, 11:11:38 AM, you wrote:
WE> i have this php script which queries a table. The results are stored in a
WE> temprrary table
WE> "CREATE temporary TABLE t1 SELECT .statements...";
WE> when I query this table in the same script i can see that the results wore
WE>
Wilbert:
> i have this php script which queries a table. The results are
> stored in a
> temprrary table
> "CREATE temporary TABLE t1 SELECT .statements...";
> when I query this table in the same script i can see that the
> results wore
> indeed stored in t1.
> however when i call this t
AFAIK, temporary table is session based. i.e. only the session creating
the temporary table can manipulate the table.
Wilbert Enserink wrote:
>
> hi all,
>
> i have this php script which queries a table. The results are stored in a
> temprrary table
> "CREATE temporary TABLE t1 SELECT .stat
Paul Chvostek writes:
> The only catch is ... it won't go in PHP. The code looks fine, and I
> suspect it's just a permission problem.
Indeed it seems that you need to have CREATE to do that. There
might be a good reason for it, but the only thing I can think
of is disk usage.
> Do I *realy*
68 matches
Mail list logo
