Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: DBI mysql set transaction isolation level (trace)

by Anonymous Monk
on Feb 12, 2014 at 19:58 UTC ( [id://1074679]=note: print w/replies, xml ) Need Help??


in reply to DBI mysql set transaction isolation level

What is supposed to happen?

get more info  DBI->trace(999) and https://dev.mysql.com/doc/refman/5.0/en/set-transaction.html

Replies are listed 'Best First'.
Re^2: DBI mysql set transaction isolation level (trace)
by Anonymous Monk on Feb 12, 2014 at 20:34 UTC

    Thanks for the timely response! I'll run the trace tommorrow (leaving now), but what is supposed to happen is the isolation should change from repeatable read (default) to read committed

      I ran the trace please see below</p?

      DBI 1.631-ithread default trace level set to 0x300/7 (pid 4275 pi +100800000) at sel_ftp_files.pl line 82 via sel_ftp_files.pl line 55 -> do for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f39188 'S +ET TRANSACTION ISOLATION LEVEL READ COMMITTED') thr#100800000 mysql.xs do() use_server_side_prepare 0, async 0 mysql_st_internal_execute MYSQL_VERSION_ID 50528 >parse_params statement SET TRANSACTION ISOLATION LEVEL READ COMMITTED <- do= '0E0' at ./sel_ftp_files.pl line 86 via at ./sel_ftp_files +.pl line 55 -> commit for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f3918 +8) thr#100800000 <- commit= 1 at ./sel_ftp_files.pl line 88 via at ./sel_ftp_files +.pl line 55 $VAR1 = '0E0'; -> selectrow_array for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0 +x100f39188 'SELECT * FROM information_schema.global_variables WHERE v +ariable_name = 'tx_isolation'') thr#100800000 1 -> prepare for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNER 'SE +LECT * FROM information_schema.global_variables WHERE variable_name = + 'tx_isolation'' undef) thr#100800000 2 -> _async_check for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNE +R) thr#100800000 2 <- _async_check= 1 at /Library/Perl/5.10.0/darwin-thread-multi-2le +vel/DBD/mysql.pm line 227 via at ./sel_ftp_files.pl line 92 New 'DBI::st' (for DBD::mysql::st, parent=DBI::db=HASH(0x100f39188 +), id=undef) dbih_setup_handle(DBI::st=HASH(0x100f3a698)=>DBI::st=HASH(0x100f3a +4d0), DBD::mysql::st, 100f3c128, Null!) dbih_make_com(DBI::db=HASH(0x100f39188), 10221b9a0, DBD::mysql::st +, 448, 0) thr#100800000 dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Err, DBI::db=HASH(0x1 +00f39188)) SCALAR(0x10088dba8) (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), State, DBI::db=HASH(0 +x100f39188)) SCALAR(0x10088dc68) (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Errstr, DBI::db=HASH( +0x100f39188)) SCALAR(0x10088dc08) (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), TraceLevel, DBI::db=H +ASH(0x100f39188)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), FetchHashKeyName, DBI +::db=HASH(0x100f39188)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), HandleSetErr, DBI::db +=HASH(0x100f39188)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), HandleError, DBI::db= +HASH(0x100f39188)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), ReadOnly, DBI::db=HAS +H(0x100f39188)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Profile, DBI::db=HASH +(0x100f39188)) undef (not defined) -> dbd_st_prepare MYSQL_VERSION_ID 50528, SQL statement: SELECT * +FROM information_schema.global_variables WHERE variable_name = 'tx_is +olation' >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets >count_params statement SELECT * FROM information_schema.global_variab +les WHERE variable_name = 'tx_isolation' <- dbd_st_prepare 1 <- prepare= DBI::st=HASH(0x100f3a698) at ./sel_ftp_files.pl line 9 +2 via at ./sel_ftp_files.pl line 55 -> dbd_st_execute for 100f6c5c0 >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets mysql_st_internal_execute MYSQL_VERSION_ID 50528 >parse_params statement SELECT * FROM information_schema.global_variab +les WHERE variable_name = 'tx_isolation' <- dbd_st_execute returning imp_sth->row_num 1 -> dbd_st_fetch dbd_st_fetch for 100f6c5c0, chopblanks 0 dbd_st_fetch result set details imp_sth->result=1004d6030 mysql_num_fields=2 mysql_num_rows=1 mysql_affected_rows=1 dbd_st_fetch for 100f6c5c0, currow= 1 dbih_setup_fbav alloc for 2 fields dbih_setup_fbav now 2 fields <- dbd_st_fetch, 2 cols --> dbd_st_finish >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets <-- dbd_st_finish <- selectrow_array= ( 'TX_ISOLATION' 'REPEATABLE-READ' ) [2 items] + at ./sel_ftp_files.pl line 92 via at ./sel_ftp_files.pl line 55 <> DESTROY(DBI::st=HASH(0x100f3a698)) ignored for outer handle (in +ner DBI::st=HASH(0x100f3a4d0) has ref cnt 1) -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x100f3a4d0)~INNER) th +r#100800000 <- DESTROY= undef at ./sel_ftp_files.pl line 93 via at ./sel_ftp_ +files.pl line 93 DESTROY (dbih_clearcom) (sth 0x100f3a4d0, com 0x10221ce00, imp DBD +::mysql::st): FLAGS 0x100191: COMSET Warn RaiseError PrintError PrintWarn PARENT DBI::db=HASH(0x100f39188) KIDS 0 (0 Active) NUM_OF_FIELDS 2 NUM_OF_PARAMS 0 dbih_clearcom 0x100f3a4d0 (com 0x10221ce00, type 3) done. -> commit for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f3918 +8) thr#100800000 <- commit= 1 at ./sel_ftp_files.pl line 93 via at ./sel_ftp_files +.pl line 55 $VAR1 = 'TX_ISOLATION'; $VAR2 = 'REPEATABLE-READ'; ### TESTING REMOVE FOR PRODUCTION -- DBI::END ($@: , $!: ) -> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x100f3e128)~0x +100f38848) thr#100800000 <- disconnect_all= (not implemented) at /Library/Perl/5.10.0/darwi +n-thread-multi-2level/DBI.pm line 750 via at ./sel_ftp_files.pl line + 100 ! <> DESTROY(DBI::db=HASH(0x100f392d8)) ignored for outer handle (in +ner DBI::db=HASH(0x100f39188) has ref cnt 1) ! -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNER) th +r#100800000 imp_dbh->pmysql: 102811600 ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (dbh 0x100f39188, com 0x10221b9a0, imp glo +bal destruction): FLAGS 0x100191: COMSET Warn RaiseError PrintError PrintWarn PARENT DBI::dr=HASH(0x100f38848) KIDS 0 (0 Active) IMP_DATA HASH(0x100f39200) dbih_clearcom 0x100f39188 (com 0x10221b9a0, type 2) done. ! <> DESTROY(DBI::dr=HASH(0x100f3e128)) ignored for outer handle (in +ner DBI::dr=HASH(0x100f38848) has ref cnt 1) ! -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0x10 +0f38848)~INNER) thr#100800000 ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (drh 0x100f38848, com 0x1020c4dc0, imp glo +bal destruction): FLAGS 0x180215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 1 (1 Active) dbih_clearcom 0x100f38848 (com 0x1020c4dc0, type 1) done.

      I ran the trace please see below

      DBI 1.631-ithread default trace level set to 0x300/7 (pid 4275 pi +100800000) at sel_ftp_files.pl line 82 via sel_ftp_files.pl line 55 -> do for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f39188 'S +ET TRANSACTION ISOLATION LEVEL READ COMMITTED') thr#100800000 mysql.xs do() use_server_side_prepare 0, async 0 mysql_st_internal_execute MYSQL_VERSION_ID 50528 >parse_params statement SET TRANSACTION ISOLATION LEVEL READ COMMITTED <- do= '0E0' at ./sel_ftp_files.pl line 86 via at ./sel_ftp_files +.pl line 55 -> commit for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f3918 +8) thr#100800000 <- commit= 1 at ./sel_ftp_files.pl line 88 via at ./sel_ftp_files +.pl line 55 $VAR1 = '0E0'; -> selectrow_array for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0 +x100f39188 'SELECT * FROM information_schema.global_variables WHERE v +ariable_name = 'tx_isolation'') thr#100800000 1 -> prepare for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNER 'SE +LECT * FROM information_schema.global_variables WHERE variable_name = + 'tx_isolation'' undef) thr#100800000 2 -> _async_check for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNE +R) thr#100800000 2 <- _async_check= 1 at /Library/Perl/5.10.0/darwin-thread-multi-2le +vel/DBD/mysql.pm line 227 via at ./sel_ftp_files.pl line 92 New 'DBI::st' (for DBD::mysql::st, parent=DBI::db=HASH(0x100f39188 +), id=undef) dbih_setup_handle(DBI::st=HASH(0x100f3a698)=>DBI::st=HASH(0x100f3a +4d0), DBD::mysql::st, 100f3c128, Null!) dbih_make_com(DBI::db=HASH(0x100f39188), 10221b9a0, DBD::mysql::st +, 448, 0) thr#100800000 dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Err, DBI::db=HASH(0x1 +00f39188)) SCALAR(0x10088dba8) (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), State, DBI::db=HASH(0 +x100f39188)) SCALAR(0x10088dc68) (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Errstr, DBI::db=HASH( +0x100f39188)) SCALAR(0x10088dc08) (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), TraceLevel, DBI::db=H +ASH(0x100f39188)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), FetchHashKeyName, DBI +::db=HASH(0x100f39188)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), HandleSetErr, DBI::db +=HASH(0x100f39188)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), HandleError, DBI::db= +HASH(0x100f39188)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), ReadOnly, DBI::db=HAS +H(0x100f39188)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x100f3a4d0), Profile, DBI::db=HASH +(0x100f39188)) undef (not defined) -> dbd_st_prepare MYSQL_VERSION_ID 50528, SQL statement: SELECT * +FROM information_schema.global_variables WHERE variable_name = 'tx_is +olation' >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets >count_params statement SELECT * FROM information_schema.global_variab +les WHERE variable_name = 'tx_isolation' <- dbd_st_prepare 1 <- prepare= DBI::st=HASH(0x100f3a698) at ./sel_ftp_files.pl line 9 +2 via at ./sel_ftp_files.pl line 55 -> dbd_st_execute for 100f6c5c0 >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets mysql_st_internal_execute MYSQL_VERSION_ID 50528 >parse_params statement SELECT * FROM information_schema.global_variab +les WHERE variable_name = 'tx_isolation' <- dbd_st_execute returning imp_sth->row_num 1 -> dbd_st_fetch dbd_st_fetch for 100f6c5c0, chopblanks 0 dbd_st_fetch result set details imp_sth->result=1004d6030 mysql_num_fields=2 mysql_num_rows=1 mysql_affected_rows=1 dbd_st_fetch for 100f6c5c0, currow= 1 dbih_setup_fbav alloc for 2 fields dbih_setup_fbav now 2 fields <- dbd_st_fetch, 2 cols --> dbd_st_finish >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets <-- dbd_st_finish <- selectrow_array= ( 'TX_ISOLATION' 'REPEATABLE-READ' ) [2 items] + at ./sel_ftp_files.pl line 92 via at ./sel_ftp_files.pl line 55 <> DESTROY(DBI::st=HASH(0x100f3a698)) ignored for outer handle (in +ner DBI::st=HASH(0x100f3a4d0) has ref cnt 1) -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x100f3a4d0)~INNER) th +r#100800000 <- DESTROY= undef at ./sel_ftp_files.pl line 93 via at ./sel_ftp_ +files.pl line 93 DESTROY (dbih_clearcom) (sth 0x100f3a4d0, com 0x10221ce00, imp DBD +::mysql::st): FLAGS 0x100191: COMSET Warn RaiseError PrintError PrintWarn PARENT DBI::db=HASH(0x100f39188) KIDS 0 (0 Active) NUM_OF_FIELDS 2 NUM_OF_PARAMS 0 dbih_clearcom 0x100f3a4d0 (com 0x10221ce00, type 3) done. -> commit for DBD::mysql::db (DBI::db=HASH(0x100f392d8)~0x100f3918 +8) thr#100800000 <- commit= 1 at ./sel_ftp_files.pl line 93 via at ./sel_ftp_files +.pl line 55 $VAR1 = 'TX_ISOLATION'; $VAR2 = 'REPEATABLE-READ'; ### TESTING REMOVE FOR PRODUCTION -- DBI::END ($@: , $!: ) -> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x100f3e128)~0x +100f38848) thr#100800000 <- disconnect_all= (not implemented) at /Library/Perl/5.10.0/darwi +n-thread-multi-2level/DBI.pm line 750 via at ./sel_ftp_files.pl line + 100 ! <> DESTROY(DBI::db=HASH(0x100f392d8)) ignored for outer handle (in +ner DBI::db=HASH(0x100f39188) has ref cnt 1) ! -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x100f39188)~INNER) th +r#100800000 imp_dbh->pmysql: 102811600 ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (dbh 0x100f39188, com 0x10221b9a0, imp glo +bal destruction): FLAGS 0x100191: COMSET Warn RaiseError PrintError PrintWarn PARENT DBI::dr=HASH(0x100f38848) KIDS 0 (0 Active) IMP_DATA HASH(0x100f39200) dbih_clearcom 0x100f39188 (com 0x10221b9a0, type 2) done. ! <> DESTROY(DBI::dr=HASH(0x100f3e128)) ignored for outer handle (in +ner DBI::dr=HASH(0x100f38848) has ref cnt 1) ! -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0x10 +0f38848)~INNER) thr#100800000 ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (drh 0x100f38848, com 0x1020c4dc0, imp glo +bal destruction): FLAGS 0x180215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 1 (1 Active) dbih_clearcom 0x100f38848 (com 0x1020c4dc0, type 1) done.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1074679]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2024-04-24 19:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found