Skip to content

Instantly share code, notes, and snippets.

@joubertredrat
Created November 27, 2013 19:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save joubertredrat/7681526 to your computer and use it in GitHub Desktop.
Save joubertredrat/7681526 to your computer and use it in GitHub Desktop.
Error SQLSTATE[HY000]: General error
<?php
$pdo = false;
function load_database() {
global $pdo;
try {
$options = array();
$options[PDO::ATTR_PERSISTENT] = true;
$options[PDO::MYSQL_ATTR_USE_BUFFERED_QUERY] = true;
$options[PDO::ATTR_EMULATE_PREPARES] = true;
$options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$options[PDO::MYSQL_ATTR_INIT_COMMAND] = "SET NAMES utf8, CHARACTER_SET_DATABASE='utf8'";
$pdo = new PDO('mysql:host=10.0.0.232;dbname=devel_timesat;charset=utf8', 'devel', '123456', $options);
} catch (PDOException $e) {
printf('erro load: ' . $e->getMessage());
}
}
function db_get($query) {
global $pdo;
try {
$resource = $pdo->prepare($query);
$resource->execute();
$data = $resource->fetchAll(PDO::FETCH_ASSOC);
$resource->closeCursor();
//sleep(1);
return $data;
} catch (PDOException $e) {
printf('erro get: ' . $e->getMessage() . PHP_EOL);
}
}
function db_insert_update($query) {
global $pdo;
try {
$resource = $pdo->prepare($query);
$resource->execute();
$resource->closeCursor();
} catch (PDOException $e) {
printf('erro update: ' . $e->getMessage());
}
}
function fork_me()
{
//global $pdo;
$pid = pcntl_fork();
if ($pid == -1) {
add_log('Erro durante o fork do processo de handle de uma nova conexão.', ERROR_LOG);
die();
} else if ($pid) {
return;
}
while(true) {
$query = 'SELECT * FROM transmissoes LIMIT ' . rand(1, 19824) . ', ' . rand(1, 300);
$data = db_get($query);
echo getmypid() . ' - ' . time() . PHP_EOL;
sleep(3);
}
}
load_database();
for($i = 0; $i < 3; $i++) {
fork_me();
sleep(1);
}
while(true) {}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment