Webmaster2020.com

mister_v

I can not edit my cronfile anymore.

I get the following error message.

cannot access /var/spool/cron/crontabs: Permission denied

As root it is possible.

mister_v

Hi,

I have the following error in MySQL,
when I do an alter statement:

Code: Select all

ERROR 1878 (HY000): Temporary file write failure.

the Alter command:

Code: Select all

ALTER TABLE f_inside_trade ADD COLUMN source TINYINT UNSIGNED;

Anyone know what the reason is?
Its the first time I get this error.

mister_v

Hi, I have tons of audit denied messages in my logs and dmesg: [ 528.090461] audit: type=1400 audit(1478343185.933:743): avc: denied { create } for pid=2785 comm="auditd" name="auditd" scontext=user_u:user_r:user_t tcontext=user_u:object_r:initrc_state_t tclass=lnk_file permissiv...

mister_v

Hello,

I get the following error:

Code: Select all

# screen
/tmp/screen/S-root/2##7.pts-0.host: connect: No such file or directory

Anyone known how to solve this.
I can't create a new screen session.

mister_v

Hi,

I noticed how you can get the previous commands in MySQL,
by using the up arrow.

Is there a way to search in the commands?

mister_v

Thanks,
that solved it for me.

mister_v

The queries are case insensitive.
That is good for most cases.
But now I want a case sensitive search.
For example all names starting with a small 'a'

Code: Select all

SELECT name FROM table WHERE name LIKE 'a%'

mister_v

I'm add a additional index on a table,
but after a few minutes I get the following error message:

Code: Select all

ERROR 1878 (HY000): Temporary file write failure.

And the index is not placed.

I check the partition, but there is still more as enough free space.

mister_v

Ok thanks

thats works.

mister_v

Hi,

How can I see all the queries that are currently running on the database?
I use mysql.
I know you can use mysql_slow.log, but that only show the slow running queries and only after.
I want to know the ones that are currently running.

Webmaster2020.com

Search found 194 matches

cannot access /var/spool/cron/crontabs: Permission denied

MYSQL ERROR 1878 (HY000): Temporary file write failure.

Lots of audit messages polluting my logs

screen connect: No such file or directory

How to get history of mysql commands

Re: mysql compare case-sensitive

SOLVED: mysql compare case-sensitive

ERROR 1878 (HY000): Temporary file write failure.

Re: See live queries

Solved: See live queries