Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > it.comp.www.php > #21531

Re: PDO e easyphp 14.1 - crash mysql

Show all headers | View raw

Grazie per la risposta,
la query non riesco ad identificarla.

L'errore è il seguente: "Unexpected end of mysql".

Nei log di mysql, subito dopo il crash trovo:

2017-03-23 07:29:55 7556 [Note] Plugin 'FEDERATED' is disabled.
2017-03-23 07:29:55 7556 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-23 07:29:55 7556 [Note] InnoDB: Mutexes and rw_locks use Windows 
interlocked functions
2017-03-23 07:29:55 7556 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-23 07:29:55 7556 [Note] InnoDB: Not using CPU crc32 instructions
2017-03-23 07:29:55 7556 [Note] InnoDB: Initializing buffer pool, size = 
20.0M
2017-03-23 07:29:55 7556 [Note] InnoDB: Completed initialization of 
buffer pool
2017-03-23 07:29:55 7556 [Note] InnoDB: Highest supported file format is 
Barracuda.
2017-03-23 07:29:55 7556 [Note] InnoDB: The log sequence numbers 
1416362483 and 1416362483 in ibdata files do not match the log sequence 
number 1416595354 in the ib_logfiles!
2017-03-23 07:29:55 7556 [Note] InnoDB: Database was not shutdown normally!
2017-03-23 07:29:55 7556 [Note] InnoDB: Starting crash recovery.
2017-03-23 07:29:55 7556 [Note] InnoDB: Reading tablespace information 
from the .ibd files...
2017-03-23 07:29:55 7556 [Note] InnoDB: Restoring possible half-written 
data pages
2017-03-23 07:29:55 7556 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 2046, file name mysql-bin.000651
2017-03-23 07:29:56 7556 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-23 07:29:56 7556 [Note] InnoDB: Waiting for purge to start
2017-03-23 07:29:56 7556 [Note] InnoDB: 5.6.15 started; log sequence 
number 1416595354
2017-03-23 07:29:56 7556 [Note] Recovering after a crash using mysql-bin
2017-03-23 07:29:56 7556 [Note] Starting crash recovery...
2017-03-23 07:29:56 7556 [Note] Crash recovery finished.
2017-03-23 07:29:56 7556 [Note] Server hostname (bind-address): 
'127.0.0.1'; port: 3306
2017-03-23 07:29:56 7556 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-03-23 07:29:56 7556 [Note] Server socket created on IP: '127.0.0.1'.

Non capisco quali di questi messaggi possa essere un errore.



Il 23/03/2017 14.57, Leonardo Serni ha scritto:
> On Thu, 23 Mar 2017 09:22:06 +0100, NoS <NoS@nospam.no> wrote:
>
>> Come da oggetto,
>> utilizzo Easyphp da parecchi anni, nessun problema.
>> Adesso, nel primo progetto in cui uso PDO  spesso va crash il server MYSQL.
>
> Controlla cosa c'è nei log di MySQL. E cosa significa "va in crash"? Il server
> va giù, o salta la connessione? Che query stava girando?
>
> Leonardo
>

Back to it.comp.www.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

PDO e easyphp 14.1 - crash mysql NoS <NoS@nospam.no> - 2017-03-23 09:22 +0100
  Re: PDO e easyphp 14.1 - crash mysql "ciccio_the_best" <21669invalid@mynewsgate.net> - 2017-03-23 12:54 +0000
  Re: PDO e easyphp 14.1 - crash mysql Leonardo Serni <lserni@gmail.com> - 2017-03-23 14:57 +0100
    Re: PDO e easyphp 14.1 - crash mysql NoS <NoS@nospam.no> - 2017-03-23 15:58 +0100
      Re: PDO e easyphp 14.1 - crash mysql Leonardo Serni <lserni@gmail.com> - 2017-03-23 23:13 +0100
        Re: PDO e easyphp 14.1 - crash mysql NoS <NoS@nospam.no> - 2017-03-24 07:07 +0100
          Re: PDO e easyphp 14.1 - crash mysql Leonardo Serni <lserni@gmail.com> - 2017-03-24 11:28 +0100
            Re: PDO e easyphp 14.1 - crash mysql NoS <NoS@nospam.no> - 2017-03-24 12:08 +0100
  Re: PDO e easyphp 14.1 - crash mysql bramante <bramante@yopmail.com> - 2017-03-23 22:08 +0100
    Re: PDO e easyphp 14.1 - crash mysql NoS <NoS@nospam.no> - 2017-03-24 07:06 +0100
      Re: PDO e easyphp 14.1 - crash mysql fmigliori <fmigliori@gmail.com> - 2017-03-24 09:33 -0700
        Re: PDO e easyphp 14.1 - crash mysql NoS <NoS@nospam.no> - 2017-03-24 17:35 +0100
          Re: PDO e easyphp 14.1 - crash mysql fmigliori <fmigliori@gmail.com> - 2017-03-24 09:50 -0700
            Re: PDO e easyphp 14.1 - crash mysql NoS <NoS@nospam.no> - 2017-03-24 18:38 +0100
              Re: PDO e easyphp 14.1 - crash mysql fmigliori <fmigliori@gmail.com> - 2017-03-24 13:01 -0700
      Re: PDO e easyphp 14.1 - crash mysql bramante <bramante@yopmail.com> - 2017-03-24 21:35 +0100
        Re: PDO e easyphp 14.1 - crash mysql Alessandro Pellizzari <shuriken@amiran.it> - 2017-03-27 10:50 +0100

csiph-web