⚲
Project
General
Profile
Sign in
Register
Home
Projects
Help
Search
:
Backport191
All Projects
Ruby
»
Backport191
Overview
Activity
Issues
Like
Download (1.03 KB)
Bug #3174
» reproduce_crash.rb
modified script -
tenderlovemaking (Aaron Patterson)
, 04/20/2010 02:25 AM
#!/usr/bin/env ruby
# encoding: utf-8
require
"rubygems"
require
"pg"
$old
=
PGconn
.
new
(
:dbname
=>
'tsm'
,
:host
=>
'localhost'
,
:user
=>
'postgres'
)
$new
=
PGconn
.
new
(
:dbname
=>
'tsm1'
,
:host
=>
'localhost'
,
:user
=>
'postgres'
)
puts
"create table "
$old
.
exec
(
"drop table if exists crash_table"
)
$old
.
exec
(
"create table crash_table ( id int8 , server_a float, server_b float, server_c float, server_d float, server_e float ) "
)
$new
.
exec
(
"drop table if exists crash_table"
)
$new
.
exec
(
"create table crash_table ( id int8 , name varchar(8), value float ) "
)
puts
"fill table "
$old
.
exec
(
"BEGIN"
)
250000
.
times
{
|
i
|
$old
.
exec
(
"insert into crash_table values (
#{
i
}
,
#{
rand
}
,
#{
rand
}
,
#{
rand
}
,
#{
rand
}
,
#{
rand
}
) "
)
}
$old
.
exec
(
"COMMIT"
)
puts
"queries"
[
'server_a'
,
'server_b'
,
'server_c'
,
'server_d'
,
'server_e'
,].
each
do
|
server
|
print
server
,
" : Session : "
t
=
$old
.
exec
(
"select id,
#{
server
}
from crash_table "
).
to_a
print
t
.
size
,
"
\n
"
t
.
each
{
|
i
|
$new
.
exec
(
"insert into crash_table values (
#{
i
[
"id"
]
}
, '
#{
server
}
',
#{
i
[
server
]
}
)"
)
}
end
« Previous
1
2
Next »
(2-2/2)
Loading...