API C MYSQL vs lock table ???

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to lock Oracle table through UNIX?

Hi frndz, Can anyone provide me some input or pseudo code for my req as mentioned below... I am loading 2 files through unix script into oracle table...as i am doing some updates also i am getting an error where both files try to update the table simultaneously and my script fails.. so i...

2. Red Hat

MySQL is not running, but lock exists

# service mysql status MySQL is not running, but lock exists I deleted the lock using rm /var/lock/subsys/mysql still the problem persists. I tried using mysqld_safe, still the same issue. Unable to start mysql # mysqld_safe nohup: ignoring input and redirecting stderr to...

3. UNIX and Linux Applications

mysql table disappear

I have set a mysql file to excute everyday morning to generate a html file displayng 2 tables from the database. Sometime they cannot be shown, and it shows the tables are not existed. I have not drop any table, and those 2 tables are not used by any other excution. Anybody know what is happening?...

4. Programming

Man pages for C API for MySql

Hi, I am on Ubuntu 9.04 tweaking some programs demanding MySql queries. I got the program working by installing following package: sudo apt-get install libmysqlclient-dev and using proper include and library folder However I was unable to access any man pages for these C api's (Strangely...

5. Shell Programming and Scripting

Help Inserting data in mysql table

Cant understand the error #!/bin/bash temp="" A="" D=$(date +"%Y-%m-%d") H=$(date +"%R") temp=$(wget -q -O - website | grep -o "Temperature:]**" | grep \-E -o "+") mysql -D "weather_wise" -e "INSERT INTO weather (Date, Hour, Degrees) VALUES ($D,$H, $temp)"; my data types for...

6. Shell Programming and Scripting

MySql: create table error

Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook" at the command line in mysql heres what i type but i get a error mysql>create table guestbook ->( -> name varchar(40) null. -> url varchar(40) null. -> comments ...

7. Programming

Sendmail & mail.local + MySQL API

I've searched this message board, and the newgroups THOROUGHLY, in search of any information towards implenting the MySQL API with C... I'm a "beginner" to the C language I suppose, and i've made a few functions in C that can be implemented into the source code of Sendmail/mail.local, so that any...

LEARN ABOUT HPUX

pthread_rwlock_wrlock

pthread_rwlock_wrlock(3T)												 pthread_rwlock_wrlock(3T)

NAME

       pthread_rwlock_wrlock(), pthread_rwlock_trywrlock() - lock or attempt to lock a read-write lock for writing

SYNOPSIS

PARAMETERS

	      rwlock	Pointer to the read-write lock to be locked for writing.

DESCRIPTION

       The  function  applies  a  write lock to the read-write lock object referenced by rwlock.  The calling thread acquires the write lock if no
       other thread (reader or writer) holds the read-write lock rwlock.  Otherwise, the thread blocks (that is, it does not return from the call)
       until  it  can acquire the lock.  Results are undefined if the calling thread holds the read-write lock (whether a read or a write lock) at
       the time the call is made.

       The function applies a write lock as in the function with the exception that the function fails if any thread currently holds  rwlock  (for
       reading or writing).

       Results are undefined if any of these functions are called with an uninitialized read-write lock.

       If  a  signal  is delivered to a thread waiting for a read-write lock, upon return from the signal handler, the thread shall resume waiting
       for the read-write lock as if it was not interrupted.

RETURN VALUE

       Upon successful completion, and return zero. Otherwise, an error number is returned to indicate the error (the variable is not set).

ERRORS

       If any of the following occur, the function returns the corresponding error number:

	      [EBUSY]	     The read-write lock rwlock could not be acquired for writing because it was already locked for reading or writing.

       For each of the following conditions, if the condition is detected, the and functions return the corresponding error number:

	      [EINVAL]	     The value specified by rwlock does not refer to an initialized read-write lock.

	      [EDEADLK]      The current thread already owns the read-write lock for reading or writing.

AUTHOR

       and were developed by X/Open.

SEE ALSO

       pthread_rwlock_init(3T), pthread_rwlock_destroy(3T), pthread_rwlock_tryrdlock(3T), pthread_rwlock_rdlock(3T), pthread_rwlock_unlock(3T).

STANDARDS CONFORMANCE

								  Pthread Library					 pthread_rwlock_wrlock(3T)

Programming