Created
November 27, 2013 19:20
-
-
Save joubertredrat/7681526 to your computer and use it in GitHub Desktop.
Error SQLSTATE[HY000]: General error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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