Net Packets out of order : received[0], expected[1]

Net Packets out of order : received[0], expected[1]

Postby kenny » Fri 31 Dec 2004 09:25

Hi,
I'm now using MyDac v3.30.2.15 Delphi 5.
Sometimes I encountered the error when open the query. Why?

Net Packets out of order : received[0], expected[1]

Thanks
kenny
 
Posts: 43
Joined: Mon 15 Nov 2004 08:48
Location: Malaysia

Re: Net Packets out of order : received[0], expected[1]

Postby Ikar » Fri 31 Dec 2004 09:35

Please send us complete small sample to demonstrate it and include script to create server objects.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Also

Postby ramajana » Fri 07 Jan 2005 10:09

I also have this error with your newest build. Do you still need sample?
ramajana
 
Posts: 10
Joined: Tue 23 Nov 2004 17:22

Net Packet out of order

Postby ebangert » Sun 09 Jan 2005 20:03

Dear all,

I also this error with last version 3.30.2.15 under Builder C++ 5.0.
This occured apparently only on Win98 client but not under XP.

I try also to uncheck compressed protocol but no result.


Serveur Mysql 4-0-16-standard log under linux.

Thanks for your support


Query :

INSERT INTO TUB (DESIGNATION, REF_FOUR, REF_SEIHE, FOURN, `PRIX U_HT`, CONDT, DELAIS, PAIEMENT) values(
'COLONNE D EXHAURE INOX DN150 DE 50ML AVEC DECHARDE DE 6ML A BRIDE/BRIDE + PLATEAU DN300',
'DEVIS W04/GC/0096',
'TUB-DEVIS W04/GC/0096',
'JOHNSON SCREENS DIVISION TUBAFOR',
5930.00,
'1',
'15',
'60JFDM'
)



CREATE TABLE `TUB` (
`DESIGNATION` char(255) NOT NULL default '',
`REF_FOUR` char(255) NOT NULL default '',
`REF_SEIHE` char(255) NOT NULL default '',
`FOURN` char(255) NOT NULL default '',
`PRIX U_HT` decimal(14,4) NOT NULL default '0.0000',
`CONDT` float NOT NULL default '0',
`DELAIS` smallint(6) NOT NULL default '0',
`PAIEMENT` char(50) NOT NULL default '',
PRIMARY KEY (`DESIGNATION`)
) TYPE=MyISAM


:!:
ebangert
 
Posts: 1
Joined: Sun 09 Jan 2005 19:56

Postby Paul » Tue 11 Jan 2005 10:31

Sorry, we cannot reproduce this problem. Small Delphi project will be appreciated.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Re: Net Packet out of order

Postby Ikar » Wed 19 Jan 2005 09:44

We couldn't reproduce the problem. It seems its appearance depends on transfering data. Please follow the next steps:

1. Stop the server and create a reserve copy of mysql\data\test\TUB.* at the server.
2. Send us these files. If data volume is too large or it is impossible by some reasons, try to decrease a number of records.
3. Send us your configuration file of MySQL Server (my.ini).
4. Attach simplest Delphi-project to demonstrate the problem.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Net Packets out of order : received[0], expected[1]

Postby applemac » Tue 08 Feb 2005 02:58

Dear ALL
I also got this type of error.

the following TMyQuery sould work without problem
but as [Alias] add in SQL.String SQL Statement this problem will be trigger.

SQL.Strings = (
'SELECT'
' *'
'FROM RVS'
'reference_van_sales'
'ORDER BY Ref_Prefix'
'')


object sReferenceCounterSQL: TMyQuery
SQLInsert.Strings = (
'INSERT INTO referenceCounter'
' (Itemno, CASH, DO, INV, SIN, SOT, IsLOCK, Timestamp_)'
'VALUES'
' (:Itemno, :CASH, :DO, :INV, :SIN, :SOT, :IsLOCK, :Timestamp_)')
SQLDelete.Strings = (
'DELETE FROM referenceCounter'
'WHERE'
' Itemno = :Old_Itemno')
SQLUpdate.Strings = (
'UPDATE referenceCounter'
'SET'

' Itemno = :Itemno, CASH = :CASH, DO = :DO, INV = :INV, SIN = :S' +
'IN, SOT = :SOT, IsLOCK = :IsLOCK, Timestamp_ = :Timestamp_'
'WHERE'
' Itemno = :Old_Itemno')
SQLRefresh.Strings = (

'SELECT referenceCounter.Itemno, referenceCounter.CASH, reference' +
'Counter.DO, referenceCounter.INV, referenceCounter.SIN, referenc' +
'eCounter.SOT, referenceCounter.IsLOCK, referenceCounter.Timestam' +
'p_ FROM referenceCounter'
'WHERE'
' referenceCounter.Itemno = :Old_Itemno')
Connection = nData.dConnection
SQL.Strings = (
'select * from referenceCounter')
CachedUpdates = True
FetchAll = True
CommandTimeout = 30
Left = 16
Top = 88
end
object sRef_VanSalesSQL: TMyQuery
SQLInsert.Strings = (
'INSERT INTO reference_van_sales'

' (Ref_Prefix, Ref_Number, Reference_Type, Saleman_ID, Descripti' +
'ons, Status, Locked)'
'SELECT'
' :Ref_Prefix,'
' :Ref_Number, '
' RPT.Reference_Type, '
' :Saleman_ID, '
' :Descriptions, '
' :Status, '
' :Locked'
'FROM'
' reference_prefix_type RPT'
'WHERE'
' RPT.Ref_Prefix = :Ref_Prefix')
SQLDelete.Strings = (
'DELETE FROM reference_van_sales'
'WHERE'
' Ref_Prefix = :Old_Ref_Prefix')
SQLUpdate.Strings = (
'UPDATE reference_van_sales RVS, reference_prefix_type RPT'
'SET'
' RVS.Ref_Prefix = :Ref_Prefix, '
' RVS.Ref_Number = :Ref_Number, '
' RVS.Reference_Type = RPT.Reference_Type, '
' RVS.Saleman_ID = :Saleman_ID, '
' RVS.Descriptions = :Descriptions, '
' RVS.Status = :Status, '
' RVS.Locked = :Locked'
'WHERE'
' RVS.Ref_Prefix = :Old_Ref_Prefix AND'
' RPT.Ref_Prefix = :Ref_Prefix')
SQLRefresh.Strings = (

'SELECT reference_van_sales.Ref_Prefix, reference_van_sales.Ref_N' +
'umber, reference_van_sales.Reference_Type, reference_van_sales.S' +
'aleman_ID, reference_van_sales.Descriptions, reference_van_sales' +
'.Status, reference_van_sales.Locked FROM reference_van_sales'
'WHERE'
' reference_van_sales.Ref_Prefix = :Old_Ref_Prefix')
Connection = nData.dConnection
SQL.Strings = (
'SELECT'
' *'
'FROM'
'reference_van_sales'
'ORDER BY Ref_Prefix'
'')
FetchRows = 1
CachedUpdates = True
FetchAll = True
CommandTimeout = 30
Left = 56
Top = 88
end
applemac
 

Postby Ikar » Tue 08 Feb 2005 16:19

The example you sent us doesn't make any sense without a script to create and fill tables. Beside that we need to know the next:

1. Do you use compression (MyConnection.Options.Compress)?
2. What MyDAC version (3.XX.XX.XX) do you use?
3. What MySQL version (4.X.XX) do you use?
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Net Packets out of order : received[0], expected[1]

Postby blindber » Tue 22 Feb 2005 00:50

Hi,
Just checking if the cause of this problem has been found, as I am intermittently getting it with MyDac 3.50.0.16 under BCB 6 and mysql 3.23.55 running on win 2k
blindber
 
Posts: 1
Joined: Mon 21 Feb 2005 23:01

Postby peterviau » Tue 08 Mar 2005 19:36

Are you using multiple threads in your application?
I ran into this issue because I was running multiple threads using the same Connections/Tables
peterviau
 
Posts: 3
Joined: Thu 18 Nov 2004 18:44

3.50.20 net packets out of sequence

Postby Jeffl » Thu 05 May 2005 18:06

Having just updated to 3.50.20 for D7 I now get the net packets out of sequence using a project and database that were working previously.
Not server version (4.17 and 5.03), not compression. My platform win2k
Jeffl
 
Posts: 5
Joined: Thu 28 Apr 2005 10:07

Postby Ikar » Fri 06 May 2005 07:43

What is the previous version of MyDAC that you use?
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby StoneWeasel (guest) » Wed 21 Sep 2005 13:32

I also had this problem. Was caused by a thread and a form using the same connection. I created a new connection in the thread instead and this seemed to solve the problem.
StoneWeasel (guest)
 


Return to MySQL Data Access Components